PIQDB_DE_TRH - Transcript Header
Transcript Header information is stored in SAP table PIQDB_DE_TRH.
It is part of development package PMIQ_DE_STAT_REPORTING in software component IS-HER-CM. This development package consists of objects that can be grouped under "Statistical Reporting".
It is part of development package PMIQ_DE_STAT_REPORTING in software component IS-HER-CM. This development package consists of objects that can be grouped under "Statistical Reporting".
Fields for table PIQDB_DE_TRH
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| TRANS_GUID | GUID - Unique ID of External Transcript | X | PIQTRTRANS_GUID | CHAR | 64 | |
| HEI | Higher Education Institution | PIQ_DE_HEI | CHAR | 8 | ||
| MONTH_COUNT | Duration of Study in Months | PIQ_DE_STUD_DUR | DEC | 2 | ||
| COUNTY | County Code | COUNC | CHAR | 6 | ||
| UEQ | University Entrance Qualification | PIQ_DE_UEQ | CHAR | 4 | ||
| COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | ||
| REGION | Region (State, Province, County) | REGIO | CHAR | 6 | ||
| EXP_TYPE | Type of Professional Experience Outside Germany | PIQ_DE_EXP_TYPE | CHAR | 4 | T7PIQ_DE_EXPTYP | |
| MOBILITY_PROG_TYPE | Type of Mobility Program | PIQ_DE_MOBILITY_PROG_TYPE | CHAR | 4 | T7PIQ_DE_MOBPRG | |
| PROGRAM_OBJID | Program ID | PIQSCOBJID | NUMC | 16 |