| 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 | REG_NUM | Academic Year and Session | nvarchar | 20 | 0 | CHAR | (N' ') | No | | PIQ_NL_DUO_YEAR_PERID | Allow NULL? |
| 3 | EDU_CODE | Education Code | nvarchar | 5 | 0 | NUMC | (N'00000') | No | T7PIQ_NL_EDUC | PIQ_NL_EDUCATIONCODE | Allow NULL? |
| 4 | SEQNR | Sequence Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PIQ_NL_SEQNR | Allow NULL? |
| 5 | STNUM | Student Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | PIQSTUDENT12 | Allow NULL? |
| 6 | CITS_NUM | Citizen Service Number | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_CITSNUM | Allow NULL? |
| 7 | EDU_NUM | Education Number | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDUNUM | Allow NULL? |
| 8 | BRIN_NUM | BRIN Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_BRINNUMBER | Allow NULL? |
| 9 | EDU_FORM | Form of Education | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_FORM_EDUC | Allow NULL? |
| 10 | REG_DATE | Date Registration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_DUO_REGIST_DATE | Allow NULL? |
| 11 | DATE_DETRM | Date Determination | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_DATE_DETERMIN | Allow NULL? |
| 12 | TUFTOT_IND | Indicate Total Tuitionfee | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_TOTALTUFEE_IND | Allow NULL? |
| 13 | TUIFEE_TYPE | Tuition Fee Type | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_TUIFEE_TYPE | Allow NULL? |
| 14 | IS_GRADE_HE | Indication grade higher education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_GRADE_HE | Allow NULL? |
| 15 | IS_GRADE_HOE | Indication grade higher education health or education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_GRADE_HOE | Allow NULL? |
| 16 | IS_GRADE_MAST | Indication grade master | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_GRADE_MAST | Allow NULL? |
| 17 | IS_GRADE_MAST_HOE | Indication grade master health or education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_GRADE_MAST_HOE | Allow NULL? |
| 18 | IS_FUNC_LIMIT_RIGHT_USED | Indication functional limitation right to be used | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_FUNC_LIMITATION | Allow NULL? |
| 19 | NO_STUDY_YEAR | Number of study years higher education | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_DUO_NUM_STUDY_YEARS_HE | Allow NULL? |
| 20 | NO_STUDY_YEAR_HOE | Number of study years higher education health or education | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_DUO_NUM_STUDY_YEARS_HOE | Allow NULL? |
| 21 | NO_STUDY_YEAR_MAST | Number of study years master | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_DUO_NUM_STUDY_MAST | Allow NULL? |
| 22 | NO_STUDY_YEAR_MAST_HOE | Number of Study Years Master Health or Education | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_DUO_NUM_STUDY_MAST_HOE | Allow NULL? |
| 23 | IS_RES | Indication residence requirement | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_RESIDENCE_REQ | Allow NULL? |
| 24 | STATE_CODE | State code (German) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | PIQ_NL_DUO_STATE_CODE | Allow NULL? |
| 25 | IS_NATIONAL | Indication nationality requirement | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_NATIONALITY_REQ | Allow NULL? |
| 26 | ALLOTMENT_DATE | Date allotment functional limitation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_DUO_ALLOT_DATE | Allow NULL? |
| 27 | IS_REG_HOE_Q | Indication registration health or education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_REG_HOE | Allow NULL? |
| 28 | IS_REG_BOM_Q | Indication registration bachelor or master | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_REG_BOM | Allow NULL? |
| 29 | EDU_CODE_Q | Education Code | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | PIQ_NL_EDUCATIONCODE | Allow NULL? |
| 30 | EDU_NAME_SHORT_Q | Name educational program (short) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDUNAMESHORT | Allow NULL? |
| 31 | EDU_NAME_LONG_Q | Education Name | nvarchar | 225 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_EDUNAMELONG | Allow NULL? |
| 32 | EDU_LEVEL_Q | Educational level | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDU_LEVEL | Allow NULL? |
| 33 | CODE_DEFRAYMENT_Q | Code defrayment | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_CODE_DEFRAYMENT | Allow NULL? |
| 34 | DUR_DEFRAYMENT_Q | Defrayment duration | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_DUO_DUR_DEFRAYMENT | Allow NULL? |
| 35 | EDU_SECTION_Q | Educational section | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDU_SECTION | Allow NULL? |
| 36 | EDU_FORM_Q | Form of Education | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_FORM_EDUC | Allow NULL? |
| 37 | TABNR | Reference Number to Table Part | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | HRTABNR | Allow NULL? |
| 38 | REGNUM | Registration Sequence Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_REGIST_NUM | Allow NULL? |
