SAP ABAP Table HRI1782 (UCAS/HESA Student Data (GB)), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `HRI1782` {UCAS/HESA Student Data (GB)}

Home

                title {label: "SAP ABAP table HRI1782 {UCAS/HESA Student Data (GB)}", size: "20"}

# Entities

[HRI1782] {bgcolor: "tomato"}
+RESID_CAT {label: "CHAR (1)"}
+DOM_COUNTRY {label: "CHAR (3)"}
+DOM_COUNTY {label: "CHAR (3)"}
+DOM_COUNC {label: "CHAR (3)"}
+INSTHE {label: "NUMC (4)"}
+LEA {label: "NUMC (3)"}
+FEE_PAYER_CODE {label: "NUMC (2)"}
+SOCIO_EC_CLASS {label: "CHAR (1)"}
+QUALENT2 {label: "NUMC (2)"}
+FEEELIG {label: "CHAR (1)"}
+SPCSTU {label: "CHAR (1)"}
+TTACOM {label: "CHAR (1)"}
+SCHOOL_NO {label: "CHAR (7)"}
+TTCID {label: "NUMC (1)"}
+NHSEMP {label: "CHAR (5)"}
+PGCESBJ1 {label: "CHAR (4)"}
+PGCESBJ2 {label: "CHAR (4)"}
+PGCESBJ3 {label: "CHAR (4)"}
+PGCECLSS {label: "CHAR (2)"}
+FEINSTID {label: "CHAR (7)"}

[T005] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LAND1 {label: "CHAR (3)"}

[T005E] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*+REGIO {label: "CHAR (3)"}
*COUNC {label: "CHAR (3)"}

[T005S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*BLAND {label: "CHAR (3)"}

[T7PIQ_GB_FEEEL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*FEEEL {label: "CHAR (1)"}

[T7PIQ_GB_FEES] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*FEE_PAYER_CODE {label: "NUMC (2)"}

[T7PIQ_GB_FEINS] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*FEINST {label: "CHAR (7)"}

[T7PIQ_GB_HQUAL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*QUALENT2 {label: "NUMC (2)"}

[T7PIQ_GB_INST_HE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*INSTID {label: "NUMC (4)"}

[T7PIQ_GB_LEA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LEA {label: "NUMC (3)"}

[T7PIQ_GB_NHSEMP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*NHSEMP {label: "CHAR (5)"}

[T7PIQ_GB_PGCECL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PGCECLSS {label: "CHAR (2)"}

[T7PIQ_GB_RCAT] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*RESID_CAT {label: "CHAR (1)"}

[T7PIQ_GB_SBJ] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*SBJ {label: "CHAR (4)"}

[T7PIQ_GB_SCECCL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*SOCIO_EC_CLASS {label: "CHAR (1)"}

[T7PIQ_GB_SCHOOL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*SCHOOL_ID {label: "CHAR (7)"}

[T7PIQ_GB_SPSTU] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*SPCSTU {label: "CHAR (1)"}

[T7PIQ_GB_TTCACO] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TTACCOM {label: "CHAR (1)"}

[T7PIQ_GB_TTCID] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TTCID {label: "NUMC (1)"}

# Relationships

HRI1782 1--* T005E {label: "HRI1782-DOM_COUNC = T005E-COUNC"}
HRI1782 1--* T005 {label: "HRI1782-DOM_COUNTRY = T005-LAND1"}
HRI1782 1--* T005S {label: "HRI1782-DOM_COUNTY = T005S-BLAND"}
HRI1782 1--* T7PIQ_GB_FEEEL {label: "HRI1782-FEEELIG = T7PIQ_GB_FEEEL-FEEEL"}
HRI1782 1--* T7PIQ_GB_FEES {label: "HRI1782-FEE_PAYER_CODE = T7PIQ_GB_FEES-FEE_PAYER_CODE"}
HRI1782 *--* T7PIQ_GB_FEINS {label: "HRI1782-FEINSTID = T7PIQ_GB_FEINS-FEINST"}
HRI1782 1--* T7PIQ_GB_INST_HE {label: "HRI1782-INSTHE = T7PIQ_GB_INST_HE-INSTID"}
HRI1782 1--* T7PIQ_GB_LEA {label: "HRI1782-LEA = T7PIQ_GB_LEA-LEA"}
HRI1782 1--* T7PIQ_GB_NHSEMP {label: "HRI1782-NHSEMP = T7PIQ_GB_NHSEMP-NHSEMP"}
HRI1782 1--* T7PIQ_GB_PGCECL {label: "HRI1782-PGCECLSS = T7PIQ_GB_PGCECL-PGCECLSS"}
HRI1782 1--* T7PIQ_GB_SBJ {label: "HRI1782-PGCESBJ1 = T7PIQ_GB_SBJ-SBJ"}
HRI1782 1--* T7PIQ_GB_SBJ {label: "HRI1782-PGCESBJ2 = T7PIQ_GB_SBJ-SBJ"}
HRI1782 *--* T7PIQ_GB_SBJ {label: "HRI1782-PGCESBJ3 = T7PIQ_GB_SBJ-SBJ"}
HRI1782 1--* T7PIQ_GB_HQUAL {label: "HRI1782-QUALENT2 = T7PIQ_GB_HQUAL-QUALENT2"}
HRI1782 1--* T7PIQ_GB_RCAT {label: "HRI1782-RESID_CAT = T7PIQ_GB_RCAT-RESID_CAT"}
HRI1782 1--* T7PIQ_GB_SCHOOL {label: "HRI1782-SCHOOL_NO = T7PIQ_GB_SCHOOL-SCHOOL_ID"}
HRI1782 1--* T7PIQ_GB_SCECCL {label: "HRI1782-SOCIO_EC_CLASS = T7PIQ_GB_SCECCL-SOCIO_EC_CLASS"}
HRI1782 1--* T7PIQ_GB_SPSTU {label: "HRI1782-SPCSTU = T7PIQ_GB_SPSTU-SPCSTU"}
HRI1782 1--* T7PIQ_GB_TTCACO {label: "HRI1782-TTACOM = T7PIQ_GB_TTCACO-TTACCOM"}
HRI1782 1--* T7PIQ_GB_TTCID {label: "HRI1782-TTCID = T7PIQ_GB_TTCID-TTCID"}

E-R Diagram for table HRI1782 (UCAS/HESA Student Data (GB))

Foreign Key tables (18)

T005 {Countries}
T005E {County}
T005S {Taxes: Region (Province) Key}
T7PIQ_GB_FEEEL {UCAS: Fee eligibility}
T7PIQ_GB_FEES {UCAS: Fee payer code}
T7PIQ_GB_FEINS {HESA: Further Education Institutions}
T7PIQ_GB_HQUAL {UCAS: Highest Qualification on Entry}
T7PIQ_GB_INST_HE {HESA: Institution Codes}
T7PIQ_GB_LEA {UCAS: LEA code}
T7PIQ_GB_NHSEMP {HESA: NHS Employer}
T7PIQ_GB_PGCECL {HESA: PGCE - Classification of UG Degree}
T7PIQ_GB_RCAT {UCAS: Residential category (Revised do not use)}
T7PIQ_GB_SBJ {HESA: JACS Subject Codes}
T7PIQ_GB_SCECCL {UCAS: Socioeconomic Class}
T7PIQ_GB_SCHOOL {UCAS: Schools}
T7PIQ_GB_SPSTU {HESA: Special Students}
T7PIQ_GB_TTCACO {HESA: Term Time Accomodation}
T7PIQ_GB_TTCID {HESA: Teacher Training Course Identifier}

SAP ABAP Table HRI1782 {UCAS/HESA Student Data (GB)}

Foreign Key tables (18)

SAP ABAP Table `HRI1782` {UCAS/HESA Student Data (GB)}