ORIG_HIR_CWR_VW

(SQL View)
 Index Back

Cont Workrer Orig Hire Date

Returns the original Hire Date for the Person as a Contingent Worker from PS_PERSON_ORG

SELECT EMPLID ,MIN(ORIG_HIRE_DT ) FROM PS_PER_ORG_INST WHERE PER_ORG = 'CWR' 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