| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | STNUM | Student Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | PIQSTUDENT12 | Allow NULL? |
| 3 | ECODE | Education Code | nvarchar | 5 | 0 | NUMC | (N'00000') | No | T7PIQ_NL_EDUC | PIQ_NL_EDUCATIONCODE | Allow NULL? |
| 4 | EPHASCOD | Education Phase Code | char | 1 | 0 | CHAR | (N' ') | No | T7PIQ_NL_EDUPHA | PIQ_NL_EDUPHASECODE | Allow NULL? |
| 5 | ADM_AYEAR | Academic Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | PIQPERYR | Allow NULL? |
| 6 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SEQNR | Allow NULL? |
| 7 | REF_DATE | Reference Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_DUODATE | Allow NULL? |
| 8 | GUID | Tuition Fee GUID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_GUID | Allow NULL? |
| 9 | RCD_TYPE | Record Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_RCDTYPE | Allow NULL? |
| 10 | BRINNO | BRIN Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_BRINNUMBER | Allow NULL? |
| 11 | BSNNO | BSN Number | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | PIQ_NL_BSNNUMBER | Allow NULL? |
| 12 | OCWNO | OC&W Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | PIQ_NL_OCWNUMBER | Allow NULL? |
| 13 | STLNKNO | Studielink Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | PIQ_NL_STUDIELINKNO | Allow NULL? |
| 14 | MONTH_FRM | Month | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_MONTH | Allow NULL? |
| 15 | TUIFEEIND | Indicator:Legal Tuition Fees | char | 1 | 0 | CHAR | (N' ') | Yes | * | PIQ_NL_TUIFEEIND | Allow NULL? |
| 16 | HGRADIND | Grade acquired for Higher Education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_HGRADIND | Allow NULL? |
| 17 | HEDUIND | Grade acquired for Health or Education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_HEDUIND | Allow NULL? |
| 18 | MGRADIND | Grade acquired for Master’s | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_MGRADIND | Allow NULL? |
| 19 | MEDUIND | Grade acquired for Master’s in Health or Education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_MEDUIND | Allow NULL? |
| 20 | FUNCIND | Indication For Functional Limitation | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_FUNCIND | Allow NULL? |
| 21 | HYEAR | Years of Study for Higher Education | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_HYEAR | Allow NULL? |
| 22 | HEDUYEAR | Number Of Study Years In Higher Health Or Education | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_HEDUYEAR | Allow NULL? |
| 23 | MYEAR | Years of Study for Master’s | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_MYEAR | Allow NULL? |
| 24 | MEDUYEAR | Years of study for Master’s in Health or Education | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_MEDUYEAR | Allow NULL? |
| 25 | RESIND | Residence Availability Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_RESIDENCEIND | Allow NULL? |
| 26 | NATREQIND | Nationality Avilability Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_NATIONALITYIND | Allow NULL? |
| 27 | TOTTUIFEEIND | Indication Type Tuition Fee Total | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_TOTALTUIFEEIND | Allow NULL? |
