HRS_PERSD_ESP_I (SQL View)	Index Back
Interface View for Spanish Interface View for Spanish Person Data

HRS_PERSD_ESP_I

(SQL View)

Interface View for Spanish

Interface View for Spanish Person Data

SELECT A.EMPLID , A.EFFDT , A.MILIT_SITUATN_ESP , A.SOC_SEC_AFF_DT FROM PS_PERS_DATA_ESP A

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 MILIT_SITUATN_ESP Character(3) VARCHAR2(3) NOT NULL Military Status
0=Not Applicable
1=Service Done
2=Exempt from Service
3=Service
4=Conscientious Objector
9=No Information

4 SOC_SEC_AFF_DT Date(10) DATE Social Security Affiliation Dt

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERSON.EMPLID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	MILIT_SITUATN_ESP	Character(3)	VARCHAR2(3) NOT NULL	Military Status 0=Not Applicable 1=Service Done 2=Exempt from Service 3=Service 4=Conscientious Objector 9=No Information
4	SOC_SEC_AFF_DT	Date(10)	DATE	Social Security Affiliation Dt