AV_MTCH_ORG_EMP

(SQL Table)
 Index Back

Matching Org Employee

Matching Org Employee status

  • Parent record: AV_MTCH_RULES

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_VW

    2 AV_MTCH_EMP_STAT Character(4) VARCHAR2(4) NOT NULL Employee Status
    ALL=All Employees
    DOM=Employees in US & Possessions
    DRCT=Non-Employee Directors
    EMSP=Spouse of Eligible Employees
    FULL=All Full-Time Employees
    PART=Permanent Part-Time
    RESP=Spouses of Eligible Retirees
    RETR=Retired Employees
    SAL=Full-Time Salaried Employees
    SRVC=Period of Service
    WIDO=Widow/Widowers of Elig Retiree