SAP ABAP Table HRI1711 (Residency Information)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ_E (Package) Campus Management, original language EN

Basic Data

Table Category	INTTAB	Structure
Structure	HRI1711	Table Relationship Diagram
Short Description	Residency 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	RESID_STATUS	☐	PIQRESIDSTATUS	RESIS	CHAR	1	0	Resident Status	T505U
2	RESID_COUNTRY	☐	PIQRESIDCOUNTRY	LAND1	CHAR	3	0	Resident Country	T005
3	RESID_REGIO	☐	PIQRESIDREGIO	REGIO	CHAR	3	0	Resident State	T005S
4	RESID_COUNC	☐	PIQRESIDCOUNC	COUNC	CHAR	3	0	Resident County	T005E
5	PASSN	☐	PIQPASSN	PIQPASSN	CHAR	20	0	Passport Number
6	ORIGIN	☐	PIQORIGIN	PIQORIGIN	CHAR	4	0	Origin	T7PIQORIGIN
7	PASS_ISSUEDATE	☐	PIQ_GB_UCAS_PASSPORTISDATE	DATS	DATS	8	0	UCAS: Passport Issue Date
8	PASS_EXPIRYDATE	☐	PIQ_GB_UCAS_PASSPORTEXDATE	DATS	DATS	8	0	UCAS: Passport Expiry Date
9	PASS_ISSUEPLACE	☐	PIQ_GB_UCAS_PASSPORTISPLACE	CHAR30	CHAR	30	0	UCAS: Passport Place of Issue
10	DATE_ENTERED_UK	☐	PIQ_GB_UCAS_DATEENTERUK	DATS	DATS	8	0	Date of Admission to United Kingdom
11	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRI1711	ORIGIN	T7PIQORIGIN	ORIGIN
2	HRI1711	RESID_COUNC	T005E	COUNC
3	HRI1711	RESID_COUNTRY	T005	LAND1
4	HRI1711	RESID_REGIO	T005S	BLAND
5	HRI1711	RESID_STATUS	T505U	RESIS

History

Last changed by/on	SAP	20130529
SAP Release Created in	463