ORIG_HIR_PER_VW

(SQL View)
 Index Back

Person Orig Start Date

Returns the earlist ORIG_HIRE_DT for the Person

SELECT EMPLID ,MIN(ORIG_HIRE_DT) FROM PS_PER_ORG_INST GROUP BY EMPLID

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ORIG_HIRE_DT Date(10) DATE Original Start Date