SCC_PDE_USA_H (SQL View)	Index Back
Extension of PERSON for USA Extension of the PERSON object for US specific fields with EFFDT Campus Solutions hollow view for the core PERS_DATA_USA table. Data is actually sourced from the Service Oriented Architecture.

SCC_PDE_USA_H

(SQL View)

Extension of PERSON for USA

Extension of the PERSON object for US specific fields with EFFDT Campus Solutions hollow view for the core PERS_DATA_USA table. Data is actually sourced from the Service Oriented Architecture.

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PERSON.EMPLID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.
Y/N Table Edit
Default Value: Y

4 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
1=Not indicated
2=No Military Service
3=Veteran of the Vietnam Era
4=Active Duty/Campaign Badge Vet
4=Other Protected Veteran
5=Active Reserve
6=Inactive Reserve
7=Retired Military
8=Veteran (VA Ineligible)
9=Vietnam & Active Duty Vet
9=Vietnam & Other Protected Vet
A=Armed Forces Service Medal Vet
B=Pre-Vietnam-Era Veteran
C=Separated/Srvc Medal/Active
C=Separated/Srvc Medal/Other Vet
D=Protected, Not Classified
N=Not a Vietnam-Era Veteran
O=Service Medal & Active Duty
O=Service Medal & Other Vet
P=Post-Vietnam-Era Veteran
R=Recently Separated Veteran
S=Separated & Service Medal Vet
T=Separated & Active Duty Vet
T=Separated & Other Vet
V=Vietnam-Era Veteran
X=Not a Veteran
X=Not a Veteran
Z=Not a Protected Veteran

5 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)

6 CITIZEN_PROOF2 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 2)

7 MEDICARE_ENTLD_DT Date(10) DATE Date Entitled to Medicare

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERSON.EMPLID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	US_WORK_ELIGIBILTY	Character(1)	VARCHAR2(1) NOT NULL	Eligible to Work in U.S. Y/N Table Edit Default Value: Y
4	MILITARY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Veteran Status / Military Status 1=Not indicated 2=No Military Service 3=Veteran of the Vietnam Era 4=Active Duty/Campaign Badge Vet 4=Other Protected Veteran 5=Active Reserve 6=Inactive Reserve 7=Retired Military 8=Veteran (VA Ineligible) 9=Vietnam & Active Duty Vet 9=Vietnam & Other Protected Vet A=Armed Forces Service Medal Vet B=Pre-Vietnam-Era Veteran C=Separated/Srvc Medal/Active C=Separated/Srvc Medal/Other Vet D=Protected, Not Classified N=Not a Vietnam-Era Veteran O=Service Medal & Active Duty O=Service Medal & Other Vet P=Post-Vietnam-Era Veteran R=Recently Separated Veteran S=Separated & Service Medal Vet T=Separated & Active Duty Vet T=Separated & Other Vet V=Vietnam-Era Veteran X=Not a Veteran X=Not a Veteran Z=Not a Protected Veteran
5	CITIZEN_PROOF1	Character(10)	VARCHAR2(10) NOT NULL	Citizenship (Proof 1)
6	CITIZEN_PROOF2	Character(10)	VARCHAR2(10) NOT NULL	Citizenship (Proof 2)
7	MEDICARE_ENTLD_DT	Date(10)	DATE	Date Entitled to Medicare