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 |