PIQDB_NL_TKG - CRIHO - IBG Tuition Fee ( Return Data )
CRIHO - IBG Tuition Fee ( Return Data ) information is stored in SAP table PIQDB_NL_TKG.
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_TKG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| STNUM | Student Number | X | PIQSTUDENT12 | CHAR | 24 | |
| ECODE | Education Code | X | PIQ_NL_EDUCATIONCODE | NUMC | 10 | T7PIQ_NL_EDUC |
| EPHASCOD | Education Phase Code | X | PIQ_NL_EDUPHASECODE | CHAR | 2 | T7PIQ_NL_EDUPHA |
| ADM_AYEAR | Academic Year | X | PIQPERYR | NUMC | 8 | * |
| SEQNR | Number of Infotype Record With Same Key | X | SEQNR | NUMC | 6 | |
| REF_DATE | Reference Date | PIQ_NL_DUODATE | DATS | 16 | ||
| GUID | Tuition Fee GUID | PIQ_NL_GUID | CHAR | 64 | ||
| RCD_TYPE | Record Type | PIQ_NL_RCDTYPE | CHAR | 6 | ||
| BRINNO | BRIN Number | PIQ_NL_BRINNUMBER | CHAR | 8 | ||
| BSNNO | BSN Number | PIQ_NL_BSNNUMBER | NUMC | 18 | ||
| OCWNO | OC&W Number | PIQ_NL_OCWNUMBER | NUMC | 24 | ||
| STLNKNO | Studielink Number | PIQ_NL_STUDIELINKNO | NUMC | 24 | ||
| MONTH_FRM | Month | PIQ_NL_MONTH | NUMC | 4 | ||
| TUIFEEIND | Indicator:Legal Tuition Fees | PIQ_NL_TUIFEEIND | CHAR | 2 | * | |
| HGRADIND | Grade acquired for Higher Education | PIQ_NL_HGRADIND | CHAR | 2 | ||
| HEDUIND | Grade acquired for Health or Education | PIQ_NL_HEDUIND | CHAR | 2 | ||
| MGRADIND | Grade acquired for Master�s | PIQ_NL_MGRADIND | CHAR | 2 | ||
| MEDUIND | Grade acquired for Master�s in Health or Education | PIQ_NL_MEDUIND | CHAR | 2 | ||
| FUNCIND | Indication For Functional Limitation | PIQ_NL_FUNCIND | CHAR | 2 | ||
| HYEAR | Years of Study for Higher Education | PIQ_NL_HYEAR | NUMC | 4 | ||
| HEDUYEAR | Number Of Study Years In Higher Health Or Education | PIQ_NL_HEDUYEAR | NUMC | 4 | ||
| MYEAR | Years of Study for Master�s | PIQ_NL_MYEAR | NUMC | 4 | ||
| MEDUYEAR | Years of study for Master�s in Health or Education | PIQ_NL_MEDUYEAR | NUMC | 4 | ||
| RESIND | Residence Availability Indicator | PIQ_NL_RESIDENCEIND | CHAR | 2 | ||
| NATREQIND | Nationality Avilability Indicator | PIQ_NL_NATIONALITYIND | CHAR | 2 | ||
| TOTTUIFEEIND | Indication Type Tuition Fee Total | PIQ_NL_TOTALTUIFEEIND | CHAR | 2 |