HRP1785

DB Table for Infotype 1785 | #masterdata | Component: United Kingdom
Column Name Description
MANDT FK Client
PLVAR FK Plan Version
OTYPE FK Object Type
OBJID FK Object ID
SUBTY FK Subtype
ISTAT FK Planning Status
BEGDA Start Date
ENDDA End Date
VARYF Variation Field for File PLOG
SEQNR Number of Infotype Record With Same Key
Column Name Description
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
AEDTM Changed on
Column Name Description
STATUS UCAS: Flag for previous/final results Show values
BTEC_FLAG UCAS: BTEC Flag Show values
IRISH_FLAG UCAS: Irish Leaving Certification Flag Show values
OTHER_RESULTS UCAS: Other A/AS/Highers/CSYS Flag Show values
REC_ACHIEVMNT UCAS: Record of Achievement Show values
SQA_FLAG UCAS: Flag SQA applicant Show values
Column Name Description Domain name
OTJID Concatenation of Object Type and Object ID CHAR10
UNAME User Name CHAR12
REASN Reason CHAR2
HISTO Historical Record Flag CHAR1
ITXNR Text Module for Infotype NUM08
EXTORGID External Organization ID HROBJID
SUMMER_GCE_A_AS UCAS: No. of Summer GCE A/AS-Levels PIQ_GB_UCAS_NO_RESULTS
SUMMER_A UCAS: No. of Summer (revised do not use) PIQ_GB_UCAS_NO_RESULTS
SUMMER_VCE_A_AS UCAS: No. of Summer VCE AS/A-Levels and Doubles PIQ_GB_UCAS_NO_RESULTS
SUMMER_AS UCAS: No. of Summer (revised do not use) PIQ_GB_UCAS_NO_RESULTS
WINTER_A UCAS: No. of Winter A-Levels PIQ_GB_UCAS_NO_RESULTS
PREV_SUMMER_RES UCAS: No. of previous (revised do not use) PIQ_GB_UCAS_NO_RESULTS
PREV_SUMMER_A UCAS: No. of previous Summer A-Levels PIQ_GB_UCAS_NO_RESULTS
PREV_AS UCAS: No. of previous AS-Levels PIQ_GB_UCAS_NO_RESULTS
HIGHERS CM UCAS: No of Highers (revised do not use) PIQ_GB_UCAS_NO_RESULTS
CSYS CM UCAS: No of CSYS (revised do not use) PIQ_GB_UCAS_NO_RESULTS
REG_NUMBER UCAS: BTEC/SQA Scottish Cand. Number PIQ_GB_UCAS_REG_NUM
GCEASN CM UCAS: Number of GCE AS level PIQ_GB_UCAS_TR_NUM
GCEASTS CM UCAS: Tariff Score for GCE AS Level PIQ_GB_UCAS_TR_SCORE
VCEASN CM UCAS: Number of VCE AS level PIQ_GB_UCAS_TR_NUM
VCEASTS CM UCAS: Tariff Score for VCE AS Level PIQ_GB_UCAS_TR_SCORE
GCEAN CM UCAS: Number of GCE A level PIQ_GB_UCAS_TR_NUM
GCEATS CM UCAS: Tariff Score for GCE A Level PIQ_GB_UCAS_TR_SCORE
VCEAN CM UCAS: Number of VCE A level PIQ_GB_UCAS_TR_NUM
VCEATS CM UCAS: Tariff Score for VCE A Level PIQ_GB_UCAS_TR_SCORE
KSQN CM UCAS: Number of Key Skills PIQ_GB_UCAS_TR_NUM
KSQTS CM UCAS: Tariff score for Key Skills qualification PIQ_GB_UCAS_TR_SCORE
UKSAN CM UCAS: Number of 1-unit award Key Skills PIQ_GB_UCAS_TR_NUM
UKSATS CM UCAS: Tariff score for 1-unit key skills award PIQ_GB_UCAS_TR_SCORE
SAHN CM UCAS: Number of Scottish Advanced Higher PIQ_GB_UCAS_TR_NUM
SAHTS CM UCAS: Tariff score for Scottish Advanced Higher PIQ_GB_UCAS_TR_SCORE
SHN CM UCAS: Number of Scottish Higher PIQ_GB_UCAS_TR_NUM
SHTS CM UCAS: Tariff score for Scottish Higher PIQ_GB_UCAS_TR_SCORE
SI2N CM UCAS: Number of Scottish Intermediate PIQ_GB_UCAS_TR_NUM
SI2TS CM UCAS: Tariff score for Scottish Intermediate 2 PIQ_GB_UCAS_TR_SCORE
SSGCN CM UCAS: Number of Scottish Standard Grade Credit PIQ_GB_UCAS_TR_NUM
SSGCTS CM UCAS: Tariff score for Scottish Standard Grade Credit PIQ_GB_UCAS_TR_SCORE
SCSN CM UCAS: Number of Scottish Core Skills PIQ_GB_UCAS_TR_NUM
SCSTS CM UCAS: Tariff score for Scottish Core Skills PIQ_GB_UCAS_TR_SCORE
AEAN CM UCAS: Number of Advanced Extension Awards PIQ_GB_UCAS_TR_NUM
AEANTS CM UCAS: Tariff score for Advanced Extension Awards PIQ_GB_UCAS_TR_SCORE
TOTALTS CM UCAS: Total Tariff Score PIQ_GB_UCAS_TR_SCORE
CACHEN CM UCAS: Number of CACHE qualifications PIQ_GB_UCAS_TR_NUM
CACHETS CM UCAS: Tariff Score for CACHE qualifications PIQ_GB_UCAS_TR_SCORE
BTECN CM UCAS: Number of BTEC National PIQ_GB_UCAS_TR_NUM
BTECTS CM UCAS: Tariff Score for BTEC National PIQ_GB_UCAS_TR_SCORE
IBTS CM UCAS: Tariff Score for International Baccalaureate PIQ_GB_UCAS_TR_SCORE
ILCTS CM UCAS: Tariff Score for Irish Leaving Certificate PIQ_GB_UCAS_TR_SCORE
MDPATS CM UCAS: Tariff Score for Music, Drama, Performing Arts PIQ_GB_UCAS_TR_SCORE
Master Data Relations Join Conditions
UCAS: HSC/IBAC Flag
  • UCAS: HSC/IBAC Flag
  • Client
Foreign Key: Infotype
  • HRP1785.MANDT == T778T.MANDT
  • HRP1785.INFTY == T778T.INFTY
Foreign Key: Status
  • HRP1785.MANDT == T778S.MANDT
  • HRP1785.ISTAT == T778S.ISTAT
Foreign Key: Client HRP1785.MANDT == T000.MANDT
UCAS: Match indicator
  • UCAS: Match indicator
  • Client
Foreign Key: Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1785.OTYPE == PLOGI.OTYPE
  • HRP1785.PLVAR == PLOGI.PLVAR
  • HRP1785.MANDT == PLOGI.MANDT
  • HRP1785.OBJID == PLOGI.OBJID
Foreign Key: Object Type
  • HRP1785.MANDT == T778O.MANDT
  • HRP1785.OTYPE == T778O.OTYPE
Foreign Key: Plan Version
  • HRP1785.MANDT == T778P.MANDT
  • HRP1785.PLVAR == T778P.PLVAR
UCAS: OEQ Flag
Reference Number to Table Part