HRP1785 - DB Table for Infotype 1785
DB Table for Infotype 1785 information is stored in SAP table HRP1785.
It is part of development package PMIQ_GB in software component IS-HER-CM-GB. This development package consists of objects that can be grouped under "Campus Management (Great Britain)".
It is part of development package PMIQ_GB in software component IS-HER-CM-GB. This development package consists of objects that can be grouped under "Campus Management (Great Britain)".
Fields for table HRP1785
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
.INCLUDE | X | HRIKEY | 0 | |||
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
PLVAR | Plan Version | X | PLVAR | CHAR | 4 | T778P |
OTYPE | Object Type | X | OTYPE | CHAR | 4 | T778O |
OBJID | Object ID | X | HROBJID | NUMC | 16 | PLOGI |
SUBTY | Subtype | X | SUBTYP | CHAR | 8 | * |
ISTAT | Planning Status | X | ISTAT_D | CHAR | 2 | T778S |
BEGDA | Start Date | X | BEGDATUM | DATS | 16 | |
ENDDA | End Date | X | ENDDATUM | DATS | 16 | |
VARYF | Variation Field for File PLOG | X | VARYF | CHAR | 20 | |
SEQNR | Number of Infotype Record With Same Key | X | SEQNR | NUMC | 6 | |
INFTY | Infotype | INFOTYP | CHAR | 8 | T778T | |
OTJID | Concatenation of Object Type and Object ID | OTJID | CHAR | 20 | ||
.INCLUDE | HRIADMIN | 0 | ||||
AEDTM | Changed on | AEDTM | DATS | 16 | ||
UNAME | User Name | USRNAME | CHAR | 24 | ||
REASN | Reason | REASN | CHAR | 4 | ||
HISTO | Historical Record Flag | HISTO | CHAR | 2 | ||
ITXNR | Text Module for Infotype | ITXNR | NUMC | 16 | ||
.INCLUDE | HRI1785 | 0 | ||||
STATUS | UCAS: Flag for previous/final results | PIQ_GB_UCAS_RESULT_STATUS | CHAR | 2 | ||
MATCH_IND | UCAS: Match indicator | PIQ_GB_UCAS_MATCH_INDC | CHAR | 2 | T7PIQ_GB_MATCH | |
EXTORGID | External Organization ID | PIQEXTORGID | NUMC | 16 | * | |
SUMMER_GCE_A_AS | UCAS: No. of Summer GCE A/AS-Levels | PIQ_GB_UCAS_GCE_A_AS | NUMC | 2 | ||
SUMMER_A | UCAS: No. of Summer (revised do not use) | PIQ_GB_UCAS_SUMMER_A | NUMC | 2 | ||
SUMMER_VCE_A_AS | UCAS: No. of Summer VCE AS/A-Levels and Doubles | PIQ_GB_UCAS_VCE_A_AS_DB | NUMC | 2 | ||
SUMMER_AS | UCAS: No. of Summer (revised do not use) | PIQ_GB_UCAS_SUMMER_AS | NUMC | 2 | ||
WINTER_A | UCAS: No. of Winter A-Levels | PIQ_GB_UCAS_WINTER_A | NUMC | 2 | ||
PREV_SUMMER_RES | UCAS: No. of previous (revised do not use) | PIQ_GB_UCAS_PREV_RESULTS | NUMC | 2 | ||
PREV_SUMMER_A | UCAS: No. of previous Summer A-Levels | PIQ_GB_UCAS_PREV_A | NUMC | 2 | ||
PREV_AS | UCAS: No. of previous AS-Levels | PIQ_GB_UCAS_PREV_AS | NUMC | 2 | ||
HIGHERS | CM UCAS: No of Highers (revised do not use) | PIQ_GB_UCAS_HIGHERS | NUMC | 2 | ||
CSYS | CM UCAS: No of CSYS (revised do not use) | PIQ_GB_UCAS_CSYS | NUMC | 2 | ||
BTEC_FLAG | UCAS: BTEC Flag | PIQ_GB_UCAS_BTEC | CHAR | 2 | ||
HIG_FLAG | UCAS: HSC/IBAC Flag | PIQ_GB_UCAS_HHIQ_FLAG | CHAR | 2 | T7PIQ_GB_HSC | |
IRISH_FLAG | UCAS: Irish Leaving Certification Flag | PIQ_GB_UCAS_IRISH_FLAG | CHAR | 2 | ||
OTHER_RESULTS | UCAS: Other A/AS/Highers/CSYS Flag | PIQ_GB_UCAS_OTHER_RESULTS | CHAR | 2 | ||
REC_ACHIEVMNT | UCAS: Record of Achievement | PIQ_GB_UCAS_REC_ACHIEVMNT | CHAR | 2 | ||
REG_NUMBER | UCAS: BTEC/SQA Scottish Cand. Number | PIQ_GB_UCAS_REG_NUM | CHAR | 26 | ||
QEQ | UCAS: OEQ Flag | PIQ_GB_UCAS_QEQ | CHAR | 2 | T7PIQ_GB_QEQ | |
SQA_FLAG | UCAS: Flag SQA applicant | PIQ_GB_UCAS_SQA_FLAG | CHAR | 2 | ||
GCEASN | CM UCAS: Number of GCE AS level | PIQ_GB_UCAS_TR_GCEASN | NUMC | 2 | ||
GCEASTS | CM UCAS: Tariff Score for GCE AS Level | PIQ_GB_UCAS_TR_GCEASTS | NUMC | 6 | ||
VCEASN | CM UCAS: Number of VCE AS level | PIQ_GB_UCAS_TR_VCEASN | NUMC | 2 | ||
VCEASTS | CM UCAS: Tariff Score for VCE AS Level | PIQ_GB_UCAS_TR_VCEASTS | NUMC | 6 | ||
GCEAN | CM UCAS: Number of GCE A level | PIQ_GB_UCAS_TR_GCEAN | NUMC | 2 | ||
GCEATS | CM UCAS: Tariff Score for GCE A Level | PIQ_GB_UCAS_TR_GCEATS | NUMC | 6 | ||
VCEAN | CM UCAS: Number of VCE A level | PIQ_GB_UCAS_TR_VCEAN | NUMC | 2 | ||
VCEATS | CM UCAS: Tariff Score for VCE A Level | PIQ_GB_UCAS_TR_VCEATS | NUMC | 6 | ||
KSQN | CM UCAS: Number of Key Skills | PIQ_GB_UCAS_TR_KSQN | NUMC | 2 | ||
KSQTS | CM UCAS: Tariff score for Key Skills qualification | PIQ_GB_UCAS_TR_KSQTS | NUMC | 6 | ||
UKSAN | CM UCAS: Number of 1-unit award Key Skills | PIQ_GB_UCAS_TR_UKSAN | NUMC | 2 | ||
UKSATS | CM UCAS: Tariff score for 1-unit key skills award | PIQ_GB_UCAS_TR_UKSATS | NUMC | 6 | ||
SAHN | CM UCAS: Number of Scottish Advanced Higher | PIQ_GB_UCAS_TR_SAHN | NUMC | 2 | ||
SAHTS | CM UCAS: Tariff score for Scottish Advanced Higher | PIQ_GB_UCAS_TR_SAHTS | NUMC | 6 | ||
SHN | CM UCAS: Number of Scottish Higher | PIQ_GB_UCAS_TR_SHN | NUMC | 2 | ||
SHTS | CM UCAS: Tariff score for Scottish Higher | PIQ_GB_UCAS_TR_SHTS | NUMC | 6 | ||
SI2N | CM UCAS: Number of Scottish Intermediate | PIQ_GB_UCAS_TR_SI2N | NUMC | 2 | ||
SI2TS | CM UCAS: Tariff score for Scottish Intermediate 2 | PIQ_GB_UCAS_TR_SI2TS | NUMC | 6 | ||
SSGCN | CM UCAS: Number of Scottish Standard Grade Credit | PIQ_GB_UCAS_TR_SSGCN | NUMC | 2 | ||
SSGCTS | CM UCAS: Tariff score for Scottish Standard Grade Credit | PIQ_GB_UCAS_TR_SSGCTS | NUMC | 6 | ||
SCSN | CM UCAS: Number of Scottish Core Skills | PIQ_GB_UCAS_TR_SCSN | NUMC | 2 | ||
SCSTS | CM UCAS: Tariff score for Scottish Core Skills | PIQ_GB_UCAS_TR_SCSTS | NUMC | 6 | ||
AEAN | CM UCAS: Number of Advanced Extension Awards | PIQ_GB_UCAS_TR_AEAN | NUMC | 2 | ||
AEANTS | CM UCAS: Tariff score for Advanced Extension Awards | PIQ_GB_UCAS_TR_AEANTS | NUMC | 6 | ||
TOTALTS | CM UCAS: Total Tariff Score | PIQ_GB_UCAS_TR_TOTALTS | NUMC | 6 | ||
CACHEN | CM UCAS: Number of CACHE qualifications | PIQ_GB_UCAS_TR_CACHEN | NUMC | 2 | ||
CACHETS | CM UCAS: Tariff Score for CACHE qualifications | PIQ_GB_UCAS_TR_CACHETS | NUMC | 6 | ||
BTECN | CM UCAS: Number of BTEC National | PIQ_GB_UCAS_TR_BTECN | NUMC | 2 | ||
BTECTS | CM UCAS: Tariff Score for BTEC National | PIQ_GB_UCAS_TR_BTECTS | NUMC | 6 | ||
IBTS | CM UCAS: Tariff Score for International Baccalaureate | PIQ_GB_UCAS_TR_IBTS | NUMC | 6 | ||
ILCTS | CM UCAS: Tariff Score for Irish Leaving Certificate | PIQ_GB_UCAS_TR_ILCTS | NUMC | 6 | ||
MDPATS | CM UCAS: Tariff Score for Music, Drama, Performing Arts | PIQ_GB_UCAS_TR_MDPATS | NUMC | 6 | ||
.INCLUDE | CI_P1785 | 0 | ||||
TABNR | Reference Number to Table Part | HRTABNR | CHAR | 64 | HRITABNR |