HCR_OC_PRO_VW

(SQL View)
 Index Back

Pers.Org Assignments Interf V.

Personal Org Assignments Interface View

SELECT A.EMPLID , A.EMPL_RCD FROM PS_PER_ORG_ASGN A WHERE A.EMPL_RCD <> A.ORG_INSTANCE_ERN

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record