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 |