HCR_PERSDAT_E_I

(SQL View)
 Index Back

Effect.Dated PersData Inter Vw

Effective dated personal data Interface View

SELECT A.EMPLID , A.EFFDT FROM PS_PERS_DATA_EFFDT 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: NEW

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date