AV_ASGN_STAFF

(SQL Table)
 Index Back

Staff Assignments

Parent record for assigning staff purposes. Contains only the staff member, institution and emplid.

  • Parent Record Of AV_ASGN_STF_PRP AV_MYPROS_AET

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

    Prompt Table: AV_PEOPLE_SRCH

    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTN_SCRTY

    4 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID

    Prompt Table: AV_STAFF_STF_VW