| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRP1789 | DB Table for Infotype 1789 | 18 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
2 | HRP1798 | DB Table for Infotype 1798 | 18 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
3 | HRP1707 | Database Table for Infotype 1707 | 22 | PERYR | Note Reference to an Academic Year | nvarchar | 4 | 0 | | |
4 | HRP1739 | DB Table for Infotype 1739 | 18 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
5 | HRP1750 | DB Table for Infotype 1750 | 18 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
6 | HRPAD506 | Additional Data for PAD506 | 18 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
7 | HRPAD512 | Additional Data for PAD512 | 3 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
8 | HRPAD532 | Additional Data for PAD508 | 14 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
9 | HRPAD547 | Additional Data PAD547 | 5 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
10 | HRT1737 | Table Section for Infotype 1737 | 16 | PERYR | Academic Year for Progression Result | nvarchar | 4 | 0 | | |
11 | HRT1750 | Table Section for Infotype 1750 | 5 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
12 | HRT1764 | Table Section for Infotype 1764 | 9 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
13 | HRT1773 | Table Section for Infotype 1773 | 33 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
14 | PIQDBCMPRRECORDS | Assessment Process | 8 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
15 | PIQDBEVOBOFFER | Scheduled Assessment | 5 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
16 | PIQDBEVOBOFFER2 | Scheduled Assessment: Functions | 5 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
17 | PIQDBEVOBOFFER3 | Scheduled Assessment: Location/Time | 5 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
18 | PIQDBLMSLPID | Learning Product UUID - LMS | 4 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
19 | PIQDBOFFERMP1 | Templates Copied for Academic Period | 3 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
20 | PIQDBOFFERMP2 | Business Events Copied for Academic Period | 4 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
21 | PIQPROC_ED_INT_W | ED Activity Document: Transferred Internal Academic Work | 18 | PERYR | Assigned Academic Year of Internal Academic Work/Qualif. | nvarchar | 4 | 0 | | |
22 | PIQPROC_PG_DT | Activity Document: Progression Details | 17 | PERYR | Academic Year for Progression Result | nvarchar | 4 | 0 | | |
23 | PIQPROC_PG_MB | Activity Document: Module Booking | 11 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
24 | T7PIQOFFERPATDEF | Session Pattern Definition | 4 | PERYR | First Academic Year | nvarchar | 4 | 0 | | |
25 | T7PIQSTDYEARPRD | Standard Academic Year/Session Assignments | 2 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
26 | T7PIQYEAR | Academic Years | 2 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
27 | T7PIQYEARPRD | Academic Year/Session Assignments | 2 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
28 | T7PIQYEART | Text Table for Academic Years | 3 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
29 | T7PIQ_NL_ENRNM | Mapping Table for Year/ Session and Enrollment Moment Code | 2 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
30 | T7PIQ_US_APPFRM | US IPEDS: Customizing to Map Relavent Prior Reporting Years | 2 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
31 | T7PIQ_US_PERIOD | US IPEDS: Customizing table for Mapping periods | 2 | PERYR | Reporting Year | nvarchar | 4 | 0 | | |
32 | T7PIQ_US_PREPYR | US IPEDS: Customizing to Map Relavent Prior Reporting Years | 2 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
33 | T7PIQ_US_PTINDX | Customizing to map Program Full time and Performance Index | 5 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
34 | TCMACGRHD | Grants Document Header | 3 | PERYR | Academic Year | nvarchar | 4 | 0 | | |
35 | TCMACGRIT | Grants Document Items | 4 | PERYR | Academic Year | nvarchar | 4 | 0 | | |