SAP ABAP Table PIQ_GB_UCAS_APPL_REFREES (UCAS: Applicant Refrees)

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	INTTAB	Structure
Structure	PIQ_GB_UCAS_APPL_REFREES	Table Relationship Diagram
Short Description	UCAS: Applicant Refrees

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	INSTCODE	☐	PIQ_GB_UCAS_INST_ID1	PIQ_GB_UCAS_INST_ID	CHAR	4	0	UCAS: Institution Code	*
2	APPLICANT_NO	☐	PIQ_GB_UCAS_APPLICANT_ID	PIQ_GB_UCAS_APPLICANT_ID	NUMC	9	0	UCAS: Applicant number
3	PERSONALID	☐	PIQ_GB_UCAS_PERSONALID	PIQ_GB_UCAS_PERSONALID	CHAR	10	0	UCAS : ucaslink Personal Id
4	APPL_SCHEME_CODE	☐	PIQ_GB_UCAS_APPLSCHCODE	CHAR4	CHAR	4	0	UCAS: Application Scheme Code
5	ADDRESS_LINE1	☐	PIQ_GB_UCAS_ADDRESS_LINE	PIQ_GB_UCAS_ADDR_LINE	CHAR	50	0	UCAS: Address Line
6	ADDRESS_LINE2	☐	PIQ_GB_UCAS_ADDRESS_LINE	PIQ_GB_UCAS_ADDR_LINE	CHAR	50	0	UCAS: Address Line
7	ADDRESS_LINE3	☐	PIQ_GB_UCAS_ADDRESS_LINE	PIQ_GB_UCAS_ADDR_LINE	CHAR	50	0	UCAS: Address Line
8	ADDRESS_LINE4	☐	PIQ_GB_UCAS_ADDRESS_LINE	PIQ_GB_UCAS_ADDR_LINE	CHAR	50	0	UCAS: Address Line
9	DFE_NUMBER	☐	PIQ_GB_UCAS_DFE_ID	CHAR7	CHAR	7	0	UCAS: DFE number
10	EMAIL	☐	PIQ_GB_UCAS_EMAIL_ADDRESS	PIQ_GB_UCAS_EMAIL	CHAR	250	0	UCAS: Referee's Email
11	FAX	☐	PIQ_GB_UCAS_FAX	PIQ_GB_UCAS_FAX	CHAR	35	0	UCAS: Referee's Fax Number
12	FULLTIME_COUNT	☐	PIQ_GB_UCAS_FULLTIME_COUNT	PIQ_GB_UCAS_FULLTIME_COUNT	NUMC	5	0	UCAS: Full time Students Count at School
13	HIGHR_EDUC_COUNT	☐	PIQ_GB_UCAS_HIGHER_EDUC_COUNT	PIQ_GB_UCAS_HIGHER_EDUC_COUNT	NUMC	4	0	UCAS: Higher Education Students
14	REFEREE_NAME	☐	PIQ_GB_UCAS_REFEREENAME	PIQ_GB_UCAS_REFEREENAME	CHAR	50	0	UCAS: Referee Name
15	ORG_NAME	☐	PIQ_GB_UCAS_ORG_NAME	PIQ_GB_UCAS_ORG_NAME	CHAR	2000	0	UCAS: Organization Name
16	POSITION_HELD	☐	PIQ_GB_UCAS_POSITION_HELD	PIQ_GB_UCAS_POSITION_HELD	CHAR	20	0	UCAS: Position held by Referee
17	POSTALCODE	☐	PIQ_GB_UCAS_POSTALCODE	PIQ_GB_UCAS_POSTCODE	CHAR	8	0	UCAS: Referee's Postcode
18	REFEREE_STATEMENT	☐	PIQ_GB_UCAS_REFEREE_STATEMENT	PIQ_GB_UCAS_REFEREE_STATEMENT	CHAR	4000	0	UCAS: Referee's Statement
19	ROLL_COUNT	☐	PIQ_GB_UCAS_ROLLCOUNT		NUMC	5	0	UCAS: Total Number of Students at School
20	SCHOOL_TYPE	☐	PIQ_GB_UCAS_SCHOOL_TYP_DESC	CHAR50	CHAR	50	0	UCAS: Referenec School Type Description
21	QUAL_CHECK	☐	PIQ_GB_UCAS_QUAL_CHECK	PIQ_GB_UCAS_QUAL_CHECK	CHAR	1	0	UCAS: Qualification Check
22	TELEPHONE	☐	PIQ_GB_UCAS_TELEPHONE		CHAR	35	0	UCAS: Telephone Number
23	PREDICTED_GRADE	☐	PIQ_GB_UCAS_PREDICTEDGRADE	PIQ_GB_UCAS_PREDICTEDGRADE	CHAR	150	0	UCAS: Predicted Grade
24	AEDTM_UCAS	☐	PIQ_GB_UCAS_AEDTM	DATS	DATS	8	0	UCAS: Date of the last change made by UCAS
25	UZEIT_UCAS	☐	PIQ_GB_UCAS_UZEIT	UZEIT	TIMS	6	0	UCAS: Time of the last change made by UCAS

History

Last changed by/on	SAP	20130529
SAP Release Created in