PERSDATA_ESP_CV (SQL View)	Index Back
PERSON for ESP Clairvia Clone of PERS_DATA_ESP record for Clairvia Fullsync message

PERSDATA_ESP_CV

(SQL View)

PERSON for ESP Clairvia

Clone of PERS_DATA_ESP record for Clairvia Fullsync message

SELECT ESP.EMPLID , ESP.EFFDT , ESP.MILIT_SITUATN_ESP , ESP.SOC_SEC_AFF_DT FROM PS_PERS_DATA_ESP ESP , PS_PER_ORG_ASG_INT ASG WHERE %EffdtCheck(PERS_DATA_ESP,ESP,%CurrentDateIn) AND ASG.EMPLID = ESP.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

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