SAP ABAP Table T7PIQ_GB_SCHOOL (UCAS: Schools)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T7PIQ_GB_SCHOOL	Table Relationship Diagram
Short Description	UCAS: Schools

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SCHOOL_ID	☑	PIQ_GB_UCAS_SCHOOL	PIQ_GB_UCAS_SCHOOL	CHAR	7	0	UCAS: School Number
3	NAME	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description
4	COUNTRY_CODE	☐	PIQ_GB_UCAS_COUNTRY	PIQ_GB_UCAS_COUNTRY	CHAR	1	0	UCAS: School country code
5	EST_GRP	☐	PIQ_GB_UCAS_EST_GRP	CHAR1	CHAR	1	0	UCAS: Establishment group
6	STATUS	☐	PIQ_GB_UCAS_SCHOOL_STATUS	CHAR1	CHAR	1	0	UCAS: School status
7	DFE_ID	☐	PIQ_GB_UCAS_DFE_ID	CHAR7	CHAR	7	0	UCAS: DFE number
8	NC_ID	☐	PIQ_GB_UCAS_NC_ID	CHAR5	CHAR	5	0	UCAS: National Centre Number (NCN)
9	BTEC_ID	☐	PIQ_GB_UCAS_BTEC_ID	CHAR6	CHAR	6	0	UCAS: BTEC National Centre Number
10	HEAD_NAME	☐	PIQ_GB_UCAS_HEAD_NAME	PIQ_GB_UCAS_NAME	CHAR	35	0	UCAS: Headmaster/Principal Name
11	HEAD_TITLE	☐	PIQ_GB_UCAS_HEAD_TITLE	PIQ_GB_UCAS_NAME	CHAR	35	0	UCAS: Headmaster/Principal Title
12	CONT_TITLE	☐	PIQ_GB_UCAS_CONT_TITLE	PIQ_GB_UCAS_NAME	CHAR	35	0	UCAS: Usual Contact Title
13	CONT_NAME	☐	PIQ_GB_UCAS_CONT_NAME	PIQ_GB_UCAS_NAME	CHAR	35	0	UCAS: Usual Contact Name
14	ADDRESS_1	☐	PIQ_GB_UCAS_ADDRESS	PIQ_GB_UCAS_ADDRESS_LINE	CHAR	27	0	UCAS: Address line
15	ADDRESS_2	☐	PIQ_GB_UCAS_ADDRESS	PIQ_GB_UCAS_ADDRESS_LINE	CHAR	27	0	UCAS: Address line
16	ADDRESS_3	☐	PIQ_GB_UCAS_ADDRESS	PIQ_GB_UCAS_ADDRESS_LINE	CHAR	27	0	UCAS: Address line
17	ADDRESS_4	☐	PIQ_GB_UCAS_ADDRESS	PIQ_GB_UCAS_ADDRESS_LINE	CHAR	27	0	UCAS: Address line
18	POSTCODE	☐	PD_PSTLZ	PSTLZ	CHAR	10	0	Postal Code
19	TELNR	☐	TELENR	CHAR25	CHAR	25	0	Telephone Number
20	SCHOOL_TYPE	☐	PIQ_GB_UCAS_SCHOOL_TYPE	PIQ_GB_UCAS_SCHOOL_TYPE	CHAR	1	0	UCAS: School type	T7PIQ_GB_SCHTYP
21	DAY_BOARD	☐	PIQ_GB_UCAS_DAY_BOARD	CHAR1	CHAR	1	0	UCAS: School Day Board
22	SEX	☐	PIQ_GB_UCAS_SEX	CHAR1	CHAR	1	0	UCAS: School Sexes
23	DTM_COLL	☐	PIQ_GB_UCAS_DTM_COLL	DATE	DATS	8	0	UCAS: Date annual data collected
24	ROLL_NR	☐	PIQ_GB_UCAS_ROLL_NR	CHAR1	CHAR	1	0	UCAS: Number on Roll
25	FULL_TIME	☐	PIQ_GB_UCAS_FULL_TIME	CHAR1	CHAR	1	0	UCAS: Full Time
26	FIFTH_FORM	☐	PIQ_GB_UCAS_FIFTH_FORM	CHAR1	CHAR	1	0	UCAS: Fifth Form
27	SIXTH_FORM	☐	PIQ_GB_UCAS_SIXTH_FORM	CHAR1	CHAR	1	0	UCAS: Sixth Form
28	HI_EDUCAT	☐	PIQ_GB_UCAS_HI_EDUCAT	CHAR1	CHAR	1	0	UCAS: Higher Education
29	WELSH	☐	PIQ_GB_UCAS_WELSH	CHAR1	CHAR	1	0	UCAS: Welshs Schools Main Language
30	TOWN	☐	KORT	TEXT40	CHAR	40	0	City
31	COUNTY	☐	BEZEI20	TEXT20	CHAR	20	0	Description
32	LEA_CODE	☐	PIQ_GB_UCAS_LEA	PIQ_GB_UCAS_LEA	NUMC	3	0	UCAS: LEA code	*
33	AEDTM	☐	PIQ_GB_UCAS_AEDTM	DATS	DATS	8	0	UCAS: Date of the last change made by UCAS
34	PREV_SCHOOL_ID	☐	PIQ_GB_UCAS_PREV_SCHOOL_ID	PIQ_GB_UCAS_SCHOOL	CHAR	7	0	UCAS: Previous School ID	*
35	BASE_YEAR	☐	PIQ_GB_UCAS_BASE_YEAR	PIQ_GB_UCAS_YEAR	NUMC	4	0	UCAS: Base Year
36	NO_APPLIC	☐	PIQ_GB_UCAS_NO_APPLIC	NUM4	NUMC	4	0	UCAS: Number of UCAS Applicants
37	NO_ACCEPT	☐	PIQ_GB_UCAS_NO_ACCEPT	NUM4	NUMC	4	0	UCAS: Number of UCAS Acceptances
38	FORMS	☐	PIQ_GB_UCAS_FORMS	CHAR1	CHAR	1	0	UCAS: Forms processed
39	FAX	☐	FAXNR	CHAR25	CHAR	25	0	Fax Number
40	EMAIL	☐	PIQ_GB_UCAS_EMAIL		CHAR	241	0	UCAS: Email address

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in