SFA_CITIZSHPVW (SQL View)	Index Back
View of Citizenship table.

SFA_CITIZSHPVW

(SQL View)

View of Citizenship table.

SELECT A.EMPLID ,A.CITIZENSHIP_STATUS ,%subrec(CITIZEN_SGP_SBR,A) FROM PS_CITIZENSHIP A , PS_INSTALLATION B WHERE A.DEPENDENT_ID = ' ' AND A.COUNTRY = B.COUNTRY

Parent record: HCR_PERSON_I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: HCR_PERSON_I

2 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

3 WORKER_TYPE_SGP Character(2) VARCHAR2(2) NOT NULL Worker's Type - Singapore

4 PERM_STATUS_DT_SGP Date(10) DATE Permanent Status Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: HCR_PERSON_I
2	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status
3	WORKER_TYPE_SGP	Character(2)	VARCHAR2(2) NOT NULL	Worker's Type - Singapore
4	PERM_STATUS_DT_SGP	Date(10)	DATE	Permanent Status Date