SCC_CITIZEN_H (SQL View)	Index Back
EE/Dependent Citizenship Use SCC_CITIZEN_H to record an employee's or dependent's country of citizenship. You can enter related passport data on SCC_CITZN_PAS_H. Campus Solutions hollow view for the core CITIZENSHIP table. Data is actually sourced from the Service Oriented Architecture.

SCC_CITIZEN_H

(SQL View)

EE/Dependent Citizenship

Use SCC_CITIZEN_H to record an employee's or dependent's country of citizenship. You can enter related passport data on SCC_CITZN_PAS_H. Campus Solutions hollow view for the core CITIZENSHIP table. Data is actually sourced from the Service Oriented Architecture.

SELECT ' ' , ' ' , ' ' , ' ' , ' ' , %DateNull FROM %Table(INSTALLATION_SA)

Parent Record Of SCC_CITZN_PAS_H

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID

3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

4 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
Prompt Table: HCR_CTZN_STS_I
Set Control Field: COUNTRY

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

6 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
2	DEPENDENT_ID	Character(2)	VARCHAR2(2) NOT NULL	Dependent ID
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
4	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status Prompt Table: HCR_CTZN_STS_I Set Control Field: COUNTRY
5	WORKER_TYPE_SGP	Character(2)	VARCHAR2(2) NOT NULL	Worker's Type - Singapore
6	PERM_STATUS_DT_SGP	Date(10)	DATE	Permanent Status Date