UPG_CC801_C_AET

(SQL Table)
 Index Back

EE Prior Work Experience

Use SCC_PRIORWORK to record a person's prior job experiences -- employers, locations, dates worked, type of position, and pay rate.

  • Parent record: HCR_PERSON_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    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
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    8 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    10 START_DT Date(10) DATE Start Date
    11 END_DT Date(10) DATE end date
    12 TITLE_LONG Character(50) VARCHAR2(50) NOT NULL Title Long
    13 ENDING_RATE Number(19,3) DECIMAL(18,3) NOT NULL Ending Pay Rate
    14 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
    A=Annual
    B=Bi-weeky
    H=Hour
    M=Month
    Y=Year
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    16 US_SOC_CD Character(10) VARCHAR2(10) NOT NULL Standard Occupational Classif
    17 CAN_NOC_CD Character(10) VARCHAR2(10) NOT NULL National Occupational Classif
    18 REL_WRK_EXPER Character(1) VARCHAR2(1) NOT NULL Relevant Work Experience
    19 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    20 US_SIC_CD Character(4) VARCHAR2(4) NOT NULL US Standard Industrial Classif
    21 RETIRED Character(1) VARCHAR2(1) NOT NULL Retired (Y/N)
    22 RETIREMENT_DT Date(10) DATE Projected Retirement Date
    23 DESCRLONG Long Character CLOB Long Description