T7PIQ_GB_SCHOOL - UCAS: Schools

UCAS: Schools information is stored in SAP table T7PIQ_GB_SCHOOL.
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 T7PIQ_GB_SCHOOL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SCHOOL_ID	UCAS: School Number	X	PIQ_GB_UCAS_SCHOOL	CHAR	14
NAME	-Cm UCAS: Field description		PIQ_GB_UCAS_DESCRIPTION	CHAR	100
COUNTRY_CODE	UCAS: School country/region code		PIQ_GB_UCAS_COUNTRY	CHAR	2
EST_GRP	UCAS: Establishment group		PIQ_GB_UCAS_EST_GRP	CHAR	2
STATUS	UCAS: School status		PIQ_GB_UCAS_SCHOOL_STATUS	CHAR	2
DFE_ID	UCAS: DFE number		PIQ_GB_UCAS_DFE_ID	CHAR	14
NC_ID	UCAS: National Centre Number (NCN)		PIQ_GB_UCAS_NC_ID	CHAR	10
BTEC_ID	UCAS: BTEC National Centre Number		PIQ_GB_UCAS_BTEC_ID	CHAR	12
HEAD_NAME	UCAS: Headmaster/Principal Name		PIQ_GB_UCAS_HEAD_NAME	CHAR	70
HEAD_TITLE	UCAS: Headmaster/Principal Title		PIQ_GB_UCAS_HEAD_TITLE	CHAR	70
CONT_TITLE	UCAS: Usual Contact Title		PIQ_GB_UCAS_CONT_TITLE	CHAR	70
CONT_NAME	UCAS: Usual Contact Name		PIQ_GB_UCAS_CONT_NAME	CHAR	70
ADDRESS_1	UCAS: Address line		PIQ_GB_UCAS_ADDRESS	CHAR	54
ADDRESS_2	UCAS: Address line		PIQ_GB_UCAS_ADDRESS	CHAR	54
ADDRESS_3	UCAS: Address line		PIQ_GB_UCAS_ADDRESS	CHAR	54
ADDRESS_4	UCAS: Address line		PIQ_GB_UCAS_ADDRESS	CHAR	54
POSTCODE	Postal Code		PD_PSTLZ	CHAR	20
TELNR	Telephone Number		TELENR	CHAR	50
SCHOOL_TYPE	UCAS: School type		PIQ_GB_UCAS_SCHOOL_TYPE	CHAR	2	T7PIQ_GB_SCHTYP
DAY_BOARD	UCAS: School Day Board		PIQ_GB_UCAS_DAY_BOARD	CHAR	2
SEX	UCAS: School Sexes		PIQ_GB_UCAS_SEX	CHAR	2
DTM_COLL	UCAS: Date annual data collected		PIQ_GB_UCAS_DTM_COLL	DATS	16
ROLL_NR	UCAS: Number on Roll		PIQ_GB_UCAS_ROLL_NR	CHAR	2
FULL_TIME	UCAS: Full Time		PIQ_GB_UCAS_FULL_TIME	CHAR	2
FIFTH_FORM	UCAS: Fifth Form		PIQ_GB_UCAS_FIFTH_FORM	CHAR	2
SIXTH_FORM	UCAS: Sixth Form		PIQ_GB_UCAS_SIXTH_FORM	CHAR	2
HI_EDUCAT	UCAS: Higher Education		PIQ_GB_UCAS_HI_EDUCAT	CHAR	2
WELSH	UCAS: Welshs Schools Main Language		PIQ_GB_UCAS_WELSH	CHAR	2
TOWN	City		KORT	CHAR	80
COUNTY	Description		BEZEI20	CHAR	40
LEA_CODE	UCAS: LEA code		PIQ_GB_UCAS_LEA	NUMC	6
AEDTM	UCAS: Date of the last change made by UCAS		PIQ_GB_UCAS_AEDTM	DATS	16
PREV_SCHOOL_ID	UCAS: Previous School ID		PIQ_GB_UCAS_PREV_SCHOOL_ID	CHAR	14
BASE_YEAR	UCAS: Base Year		PIQ_GB_UCAS_BASE_YEAR	NUMC	8
NO_APPLIC	UCAS: Number of UCAS Applicants		PIQ_GB_UCAS_NO_APPLIC	NUMC	8
NO_ACCEPT	UCAS: Number of UCAS Acceptances		PIQ_GB_UCAS_NO_ACCEPT	NUMC	8
FORMS	UCAS: Forms processed		PIQ_GB_UCAS_FORMS	CHAR	2
FAX	Fax Number		FAXNR	CHAR	50
EMAIL	UCAS: Email address		PIQ_GB_UCAS_EMAIL	CHAR	482
UKPRN_NUM	CM UCAS : External Reference Number Assigned by UKRLP		PIQ_GB_UCAS_UKPRN	CHAR	16