AV_WORK_EXPR_VW

(SQL View)
 Index Back

Employer Work View

Used to view employers employees (by employer).

SELECT EXT_ORG_ID , EMPLID , START_DT , EMPLOYMENT_DESCR , CITY , STATE , COUNTRY , COUNTRY_CODE , PHONE , END_DT , TITLE_LONG , ENDING_RATE , PAY_FREQ_ABBRV , CURRENCY_CD , US_SOC_CD , CAN_NOC_CD , US_SIC_CD , RETIRED FROM PS_SCC_PRIORWORK WHERE EXT_ORG_ID <> ' '

  • Parent record: PERSON

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

    Prompt Table: AV_PEOPLE_SRCH

    3 START_DT Date(10) DATE NOT NULL Start Date
    4 EMPLOYMENT_DESCR Character(50) VARCHAR2(50) NOT NULL Employment Description
    5 CITY Character(30) VARCHAR2(30) NOT NULL City
    6 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: INSTALLATION.COUNTRY

    Prompt Table: COUNTRY_TBL

    8 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    10 END_DT Date(10) DATE end date
    11 TITLE_LONG Character(50) VARCHAR2(50) NOT NULL Title Long
    12 ENDING_RATE Number(19,3) DECIMAL(18,3) NOT NULL Ending Pay Rate
    13 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
    A=Annual
    B=Bi-weeky
    H=Hour
    M=Month
    Y=Year

    Default Value: M

    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    15 US_SOC_CD Character(10) VARCHAR2(10) NOT NULL Standard Occupational Classif

    Prompt Table: US_SOC_TBL

    16 CAN_NOC_CD Character(10) VARCHAR2(10) NOT NULL National Occupational Classif
    17 US_SIC_CD Character(4) VARCHAR2(4) NOT NULL US Standard Industrial Classif
    18 RETIRED Character(1) VARCHAR2(1) NOT NULL Retired (Y/N)

    Y/N Table Edit