PRIORWRK_EX_LNG

(SQL Table)
 Index Back

EE Prior Work Experience

Use PRIORWORK_EXPER to record an employee's prior job experiences -- employers, locations, dates worked, type of position, and pay rate.

  • Related Language Record for PRIORWORK_EXPER

  • 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 START_DT Date(10) DATE NOT NULL Start Date
    3 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    6 ENDING_TITLE Character(30) VARCHAR2(30) NOT NULL Ending Job Title
    7 PCMP_PREV_CLASS Character(20) VARCHAR2(20) NOT NULL Used i n the Professional Compliance module. Previous classification level of a RI
    8 PCMP_PREV_LEAVE Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Reason why RI left previous job.
    9 DESCRLONG Long Character CLOB Long Description