SAP ABAP Table PIQ_GB_UCAS_REF_SCHOOL_DETAILS (Reference School Details)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-GB (Application Component) United Kingdom
     ⤷ PMIQ_GB_UCASLINK (Package) Campus Management (Great Britain UCAS Link)

Basic Data

Table Category	INTTAB	Structure
Structure	PIQ_GB_UCAS_REF_SCHOOL_DETAILS	Table Relationship Diagram
Short Description	Reference School Details

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	UCAS: School Releted Information
2	.INCLUDE	☐				0	0	UCAS: Schools
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	SCHOOL_ID	☐	PIQ_GB_UCAS_SCHOOL	PIQ_GB_UCAS_SCHOOL	CHAR	7	0	UCAS: School Number	*
5	NAME	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description
6	COUNTRY_CODE	☐	PIQ_GB_UCAS_COUNTRY	PIQ_GB_UCAS_COUNTRY	CHAR	1	0	UCAS: School country code
7	EST_GRP	☐	PIQ_GB_UCAS_EST_GRP	CHAR1	CHAR	1	0	UCAS: Establishment group
8	STATUS	☐	PIQ_GB_UCAS_SCHOOL_STATUS	CHAR1	CHAR	1	0	UCAS: School status
9	DFE_ID	☐	PIQ_GB_UCAS_DFE_ID	CHAR7	CHAR	7	0	UCAS: DFE number
10	NC_ID	☐	PIQ_GB_UCAS_NC_ID	CHAR5	CHAR	5	0	UCAS: National Centre Number (NCN)
11	BTEC_ID	☐	PIQ_GB_UCAS_BTEC_ID	CHAR6	CHAR	6	0	UCAS: BTEC National Centre Number
12	HEAD_NAME	☐	PIQ_GB_UCAS_HEAD_NAME	PIQ_GB_UCAS_NAME	CHAR	35	0	UCAS: Headmaster/Principal Name
13	HEAD_TITLE	☐	PIQ_GB_UCAS_HEAD_TITLE	PIQ_GB_UCAS_NAME	CHAR	35	0	UCAS: Headmaster/Principal Title
14	CONT_TITLE	☐	PIQ_GB_UCAS_CONT_TITLE	PIQ_GB_UCAS_NAME	CHAR	35	0	UCAS: Usual Contact Title
15	CONT_NAME	☐	PIQ_GB_UCAS_CONT_NAME	PIQ_GB_UCAS_NAME	CHAR	35	0	UCAS: Usual Contact Name
16	ADDRESS_1	☐	PIQ_GB_UCAS_ADDRESS	PIQ_GB_UCAS_ADDRESS_LINE	CHAR	27	0	UCAS: Address line
17	ADDRESS_2	☐	PIQ_GB_UCAS_ADDRESS	PIQ_GB_UCAS_ADDRESS_LINE	CHAR	27	0	UCAS: Address line
18	ADDRESS_3	☐	PIQ_GB_UCAS_ADDRESS	PIQ_GB_UCAS_ADDRESS_LINE	CHAR	27	0	UCAS: Address line
19	ADDRESS_4	☐	PIQ_GB_UCAS_ADDRESS	PIQ_GB_UCAS_ADDRESS_LINE	CHAR	27	0	UCAS: Address line
20	POSTCODE	☐	PD_PSTLZ	PSTLZ	CHAR	10	0	Postal Code
21	TELNR	☐	TELENR	CHAR25	CHAR	25	0	Telephone Number
22	SCHOOL_TYPE	☐	PIQ_GB_UCAS_SCHOOL_TYPE	PIQ_GB_UCAS_SCHOOL_TYPE	CHAR	1	0	UCAS: School type	T7PIQ_GB_SCHTYP
23	DAY_BOARD	☐	PIQ_GB_UCAS_DAY_BOARD	CHAR1	CHAR	1	0	UCAS: School Day Board
24	SEX	☐	PIQ_GB_UCAS_SEX	CHAR1	CHAR	1	0	UCAS: School Sexes
25	DTM_COLL	☐	PIQ_GB_UCAS_DTM_COLL	DATE	DATS	8	0	UCAS: Date annual data collected
26	ROLL_NR	☐	PIQ_GB_UCAS_ROLL_NR	CHAR1	CHAR	1	0	UCAS: Number on Roll
27	FULL_TIME	☐	PIQ_GB_UCAS_FULL_TIME	CHAR1	CHAR	1	0	UCAS: Full Time
28	FIFTH_FORM	☐	PIQ_GB_UCAS_FIFTH_FORM	CHAR1	CHAR	1	0	UCAS: Fifth Form
29	SIXTH_FORM	☐	PIQ_GB_UCAS_SIXTH_FORM	CHAR1	CHAR	1	0	UCAS: Sixth Form
30	HI_EDUCAT	☐	PIQ_GB_UCAS_HI_EDUCAT	CHAR1	CHAR	1	0	UCAS: Higher Education
31	WELSH	☐	PIQ_GB_UCAS_WELSH	CHAR1	CHAR	1	0	UCAS: Welshs Schools Main Language
32	TOWN	☐	KORT	TEXT40	CHAR	40	0	City
33	COUNTY	☐	BEZEI20	TEXT20	CHAR	20	0	Description
34	LEA_CODE	☐	PIQ_GB_UCAS_LEA	PIQ_GB_UCAS_LEA	NUMC	3	0	UCAS: LEA code	*
35	AEDTM	☐	PIQ_GB_UCAS_AEDTM	DATS	DATS	8	0	UCAS: Date of the last change made by UCAS
36	PREV_SCHOOL_ID	☐	PIQ_GB_UCAS_PREV_SCHOOL_ID	PIQ_GB_UCAS_SCHOOL	CHAR	7	0	UCAS: Previous School ID	*
37	BASE_YEAR	☐	PIQ_GB_UCAS_BASE_YEAR	PIQ_GB_UCAS_YEAR	NUMC	4	0	UCAS: Base Year
38	NO_APPLIC	☐	PIQ_GB_UCAS_NO_APPLIC	NUM4	NUMC	4	0	UCAS: Number of UCAS Applicants
39	NO_ACCEPT	☐	PIQ_GB_UCAS_NO_ACCEPT	NUM4	NUMC	4	0	UCAS: Number of UCAS Acceptances
40	FORMS	☐	PIQ_GB_UCAS_FORMS	CHAR1	CHAR	1	0	UCAS: Forms processed
41	FAX	☐	FAXNR	CHAR25	CHAR	25	0	Fax Number
42	EMAIL	☐	PIQ_GB_UCAS_EMAIL		CHAR	241	0	UCAS: Email address
43	SCHOOL_CODE	☐	PIQ_GB_UCAS_SCHOOL_CODE	CHAR10	CHAR	10	0	UCAS : School Code
44	CONTACT_POST	☐	PIQ_GB_UCAS_CONTACT_POST	CHAR20	CHAR	20	0	UCAS : Contact Post
45	ED_EXCEL_NO	☐	PIQ_GB_UCAS_ED_EXCEL_NO	CHAR10	CHAR	10	0	UCAS : Education Excel No
46	HIGHER_ED_COUNT	☐	PIQ_GB_UCAS_HIGHER_ED_COUNT	NUMC10	NUMC	10	0	UCAS : Higher Education Count
47	MAIL_SORT_CODE	☐	PIQ_GB_UCAS_MAIL_SORT_CODE	CHAR10	CHAR	10	0	UCAS : Mail Sort Code
48	ESTABLISH_NO	☐	PIQ_GB_UCAS_ESTABLISH_NO	NUMC10	NUMC	10	0	UCAS : Merged Establish Number
49	OLD_NAME	☐	PIQ_GB_UCAS_OLD_NAME	CHAR50	CHAR	50	0	UCAS : Old Name
50	STATISTICS_DATE	☐	PIQ_GB_UCAS_AEDTM	DATS	DATS	8	0	UCAS: Date of the last change made by UCAS
51	STATISTICS_TIME	☐	PIQ_GB_UCAS_UZEIT	UZEIT	TIMS	6	0	UCAS: Time of the last change made by UCAS
52	.INCLUDE	☐				0	0	UCAS: Referenec School Type
53	SCHOOL_TYP_CODE	☐	PIQ_GB_UCAS_SCHOOL_TYP_CODE	CHAR1	CHAR	1	0	UCAS: Referenec School Type Code
54	SCHOOL_TYP_DESC	☐	PIQ_GB_UCAS_SCHOOL_TYP_DESC	CHAR50	CHAR	50	0	UCAS: Referenec School Type Description
55	SCHOOL_TYP_SUMMER_SCHL_F	☐	PIQ_GB_UCAS_SCHOOL_TYP_SCHL_F	CHAR1	CHAR	1	0	UCAS: Referenec School Type Summer school flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQ_GB_UCAS_REF_SCHOOL_DETAILS	MANDT	T000	MANDT		1	CN
2	PIQ_GB_UCAS_REF_SCHOOL_DETAILS	SCHOOL_TYPE	T7PIQ_GB_SCHTYP	SCHOOL_TYPE

History

Last changed by/on	SAP	20131127
SAP Release Created in	472