PIQDB_NL_LOTTERY - Student's Data for Lottery Process
Student's Data for Lottery Process information is stored in SAP table PIQDB_NL_LOTTERY.
It is part of development package PMIQ_NL in software component IS-HER-CM-NL. This development package consists of objects that can be grouped under "Student Lifecycle Management - Netherlands".
It is part of development package PMIQ_NL in software component IS-HER-CM-NL. This development package consists of objects that can be grouped under "Student Lifecycle Management - Netherlands".
Fields for table PIQDB_NL_LOTTERY
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| STUDENT_NO | Student Number | X | PIQSTUDENT12 | CHAR | 24 | |
| EDUCATIONCODE | Education Code | X | PIQ_NL_EDUCATIONCODE | NUMC | 10 | |
| ADM_AYEAR | Academic Year | X | PIQPERYR | NUMC | 8 | |
| FULLTPARTT | Form of Education Code | PIQ_NL_FULLTPARTT | CHAR | 2 | ||
| RANKING_NO | Ranking Number for a Student | PIQ_NL_RANKING_NUM | NUMC | 40 | ||
| SC_OBJID | Program ID | PIQSCOBJID | NUMC | 16 | ||
| BRINNUMBER | BRIN Number | PIQ_NL_BRINNUMBER | CHAR | 8 | ||
| STUDIELINK_NO | Studielink number | PIQ_NL_STUDIELINK_NUM | CHAR | 18 | ||
| CITIZEN_NO | Citizen Service Number | PIQ_NL_DUO_CITSNUM | CHAR | 18 | ||
| EDUCATION_NO | Education Number | PIQ_NL_DUO_EDUNUM | CHAR | 18 | ||
| STUDIELINK_REG_NO | Studielink Registration Sequence Number | PIQ_NL_DUO_REGIST_NUM | CHAR | 40 | ||
| EDUCATION_STATUS | Limited Education Status | PIQ_NL_LIMEDU_STATUS | CHAR | 2 | ||
| REMOVE_INDICATOR | Remove/Addition of Selection Attempt | PIQ_NL_REMOVE_IND | CHAR | 2 | ||
| MESSAGE53_SENT | Message53 Sent Indicator | PIQ_NL_MSG53_SENT | CHAR | 2 | ||
| SELECTION_DATE | Selection Date | PIQ_NL_SEL_DATE | DATS | 16 |