| 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 | TABNR | Reference Number to Table Part | nvarchar | 32 | 0 | CHAR | (N' ') | No | * | HRTABNR | Allow NULL? |
| 3 | TABSEQNR | Sequence Number in Table Part of Table Infotype | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | HRTABSEQNR | Allow NULL? |
| 4 | BRIN_NUM_P | BRIN Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_BRINNUMBER | Allow NULL? |
| 5 | BRIN_NAME_P | Institute Name | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_INST_NAME | Allow NULL? |
| 6 | EDU_CODE_P | Education Code | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | PIQ_NL_EDUCATIONCODE | Allow NULL? |
| 7 | EDU_NAME_SHORT_P | Name educational program (short) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDUNAMESHORT | Allow NULL? |
| 8 | EDU_NAME_LONG_P | Education Name | nvarchar | 225 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_EDUNAMELONG | Allow NULL? |
| 9 | EDU_LEVEL_P | Educational level | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDU_LEVEL | Allow NULL? |
| 10 | CODE_DEFRAYMENT_P | Code defrayment | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_CODE_DEFRAYMENT | Allow NULL? |
| 11 | DUR_DEFRAYMENT_P | Defrayment duration | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_DUO_DUR_DEFRAYMENT | Allow NULL? |
| 12 | EDU_SECTION_P | Educational section | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDU_SECTION | Allow NULL? |
| 13 | EDU_FORM_P | Form of Education | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_FORM_EDUC | Allow NULL? |
| 14 | BRIN_SEQN_P | BRIN Sequence Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_BRINSEQUENCECHAR | Allow NULL? |
| 15 | ENROLL_FORM | Enrollment Form Code | char | 1 | 0 | CHAR | (N' ') | Yes | * | PIQ_NL_ENROLLFORMCODE | Allow NULL? |
| 16 | EDU_PHASE_P | Education Phase Code | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_EDUPHASECODE | Allow NULL? |
| 17 | REG_DATE_P | Date Registration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_DUO_REGIST_DATE | Allow NULL? |
| 18 | DEREG_DATE | Date Deregistration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_DUO_DEREGIST_DATE | Allow NULL? |
| 19 | IS_REG_HOE_P | Indication registration health or education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_REG_HOE | Allow NULL? |
| 20 | IS_REG_BOM_P | Indication registration bachelor or master | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_REG_BOM | Allow NULL? |
| 21 | BRIN_NUM_R | BRIN Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_BRINNUMBER | Allow NULL? |
| 22 | BRIN_NAME_R | Institute Name | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_INST_NAME | Allow NULL? |
| 23 | EDU_CODE_R | Education Code | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | PIQ_NL_EDUCATIONCODE | Allow NULL? |
| 24 | EDU_NAME_SHORT_R | Name educational program (short) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDUNAMESHORT | Allow NULL? |
| 25 | EDU_NAME_LONG_R | Education Name | nvarchar | 225 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_EDUNAMELONG | Allow NULL? |
| 26 | EDU_LEVEL_R | Educational level | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDU_LEVEL | Allow NULL? |
| 27 | CODE_DEFRAYMENT_R | Code defrayment | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_CODE_DEFRAYMENT | Allow NULL? |
| 28 | DUR_DEFRAYMENT_R | Defrayment duration | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_DUO_DUR_DEFRAYMENT | Allow NULL? |
| 29 | EDU_SECTION_R | Educational section | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_EDU_SECTION | Allow NULL? |
| 30 | EDU_FORM_R | Form of Education | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_FORM_EDUC | Allow NULL? |
| 31 | BRIN_SEQN_R | BRIN Sequence Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_BRINSEQUENCECHAR | Allow NULL? |
| 32 | EDU_PHASE_R | Education Phase Code | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_EDUPHASECODE | Allow NULL? |
| 33 | DIPLOMA_DATE | Diploma Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_DUO_DIPLOMA_DATE | Allow NULL? |
| 34 | IS_GRADE_HOE_R | Indication grade higher education health or education | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_GRADE_HOE | Allow NULL? |
| 35 | IS_GRADE_BOM_R | Indication grade bachelor or master | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_DUO_IS_GRADE_BOM | Allow NULL? |
