HRP1782

DB Table for Infotype 1782 | #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
SABAT HESA: Flag Student as sabbatical Show values
ENTRYCDE HESA: New Entrant to HE Show values
EMPLOYER HESA: Major Source of Tuition Fee is Student's Employer Show values
PARED UCAS: Parental Education 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
YRLLINST Year left last institution
UCAS_NO UCAS: UCAS Number PIQ_GB_UCAS_APPLICANT_ID
HUSID HESA Student Identifier
TREFNO UCAS: Teacher Reference Number PIQ_GB_UCAS_TREFNO
DHREGREF HESA: Regulatory Body Reference (revised) PIQ_GB_UCAS_DHREGREF
PREVINST HESA: Previous Institution attended CHAR8
DHREGREF2 HESA: Regulatory Body Reference No. allocated to a Student PIQ_GB_UCAS_DHREGREF2
POSTCODE UCAS: Postcode prior to entry PIQ_GB_UCAS_POSTCODE
Master Data Relations | to Other Relations ↓ Join Conditions
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • HRP1782.MANDT == T005E.MANDT
  • HRP1782.DOM_COUNC == T005E.COUNC
  • HRP1782.DOM_COUNTRY == T005E.LAND1
  • HRP1782.DOM_COUNTY == T005E.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • HRP1782.DOM_COUNTRY == T005.LAND1
  • HRP1782.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • HRP1782.MANDT == T005S.MANDT
  • HRP1782.DOM_COUNTRY == T005S.LAND1
  • HRP1782.DOM_COUNTY == T005S.BLAND
UCAS: Fee Eligibility
  • UCAS: Fee Eligibility
  • Client
UCAS: Fee Payer Code
HESA: Further Education Institution Identifier
Infotype
  • HRP1782.MANDT == T778T.MANDT
  • HRP1782.INFTY == T778T.INFTY
Planning Status
  • HRP1782.MANDT == T778S.MANDT
  • HRP1782.ISTAT == T778S.ISTAT
Client HRP1782.MANDT == T000.MANDT
HESA: NHS Employer
  • HESA: NHS Employer
  • Client
Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1782.OTYPE == PLOGI.OTYPE
  • HRP1782.PLVAR == PLOGI.PLVAR
  • HRP1782.MANDT == PLOGI.MANDT
  • HRP1782.OBJID == PLOGI.OBJID
Object Type
  • HRP1782.MANDT == T778O.MANDT
  • HRP1782.OTYPE == T778O.OTYPE
HESA: PGCE - Classification of UG Degree
HESA: PGCE - Subject 1 of UG Degree
  • HESA: PGCE - Subject 1 of UG Degree
  • Client
HESA: PGCE - Subject 2 of UG Degree
  • HESA: PGCE - Subject 2 of UG Degree
  • Client
HESA: Subject 3 of UG Degree
  • HESA: Subject 3 of UG Degree
  • Client
Plan Version
  • HRP1782.MANDT == T778P.MANDT
  • HRP1782.PLVAR == T778P.PLVAR
HESA: Highest Qualification on Entry
UCAS: Residential category
UCAS: Socioeconomic Class
HESA: Special Students
HESA: Term Time Accommodation
  • HESA: Term Time Accommodation
  • Client
HESA: Teacher Training Course Identifier
  • HESA: Teacher Training Course Identifier
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
HESA: HE institution last attended
UCAS: LEA code
UCAS: School Number