HRS_APP_WRK_EXP

(SQL Table)
 Index Back

App Prior Work Experience

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

  • Related Language Record: HRS_APP_PWE_LNG

  • Parent record: HRS_APP_PROFILE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 START_DT Date(10) DATE NOT NULL Start Date
    4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    5 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: HRS_COUNTRY_VW

    7 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    8 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    9 END_DT Date(10) DATE end date
    10 ENDING_TITLE Character(30) VARCHAR2(30) NOT NULL Ending Job Title
    11 ENDING_RATE Number(19,3) DECIMAL(18,3) NOT NULL Ending Pay Rate
    12 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

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

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: HRS_CURRENCY_VW

    14 US_SOC_CD Character(10) VARCHAR2(10) NOT NULL Standard Occupational Classif
    15 CAN_NOC_CD Character(10) VARCHAR2(10) NOT NULL National Occupational Classif
    16 REL_WRK_EXPER Character(1) VARCHAR2(1) NOT NULL Relevant Work Experience

    Y/N Table Edit

    Default Value: Y

    17 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: HRS_GVTGRD_I

    18 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    19 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    20 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

    Prompt Table: HRS_PAY_PLAN_I

    21 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series

    Prompt Table: HRS_GVT_OCC_I

    22 GVT_TYPE_OF_APPT Character(2) VARCHAR2(2) NOT NULL Type of Appointment
    10=Career (Competitive Svc Perm)
    15=Career-Conditional (Comp Perm)
    20=Nonpermanent (Comp NonPerm)
    30=Schedule A (Except Svc Perm)
    32=Schedule B (Except Svc Perm)
    34=Schedule C (Except Svc Perm)
    36=Executive (Except Svc Perm)
    38=Other (Except Svc Perm)
    40=Schedule A (Except NonPerm)
    42=Schedule B (Except NonPerm)
    44=Schedule C (Except NonPerm)
    46=Executive (Except NonPerm)
    48=Other (Except NonPerm)
    50=Career (Senior Exec Perm)
    55=Noncareer (Senior Exec Perm)
    60=Limited Term (Senior Exec NPrm
    65=Limited Emergency (SES NPerm)
    23 GVT_HOURS_PER_WEEK Number(4,1) DECIMAL(3,1) NOT NULL Hours Per Week
    24 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
    1=Competitive
    2=Excepted
    3=SES General
    4=SES Career Reserved
    25 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    26 GVT_TYPE_OF_EXP Character(1) VARCHAR2(1) NOT NULL Experience Type
    F=Federal Civilian Sector
    O=Other
    P=Private Sector
    27 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    28 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    29 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    30 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    31 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    32 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    33 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    34 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    35 CITY Character(30) VARCHAR2(30) NOT NULL City
    36 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    37 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    38 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    39 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    40 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    41 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    42 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    43 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: HCR_STONLY_I

    44 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    45 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    46 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    47 DESCRLONG Long Character CLOB Long Description