SAP ABAP Table PIQ_GB_UCAS_REF_SCHOOL (UCAS: School Releted Information)

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	Table Relationship Diagram
Short Description	UCAS: School Releted Information

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

Foreign Keys

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

History

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