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 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 HRS_SUPERVISOR Character(50) VARCHAR2(50) NOT NULL Supervisor
    18 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email
    19 HRS_CONTACT_OK_FLG Character(1) VARCHAR2(1) NOT NULL OK to contact?

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: HRS_GVTGRD_I

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

    Prompt Table: HRS_PAY_PLAN_I

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

    Prompt Table: HRS_GVT_OCC_I

    25 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)
    26 GVT_HOURS_PER_WEEK Number(4,1) DECIMAL(3,1) NOT NULL Hours Per Week
    27 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
    1=Competitive
    2=Excepted
    3=SES General
    4=SES Career Reserved
    28 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    29 GVT_TYPE_OF_EXP Character(1) VARCHAR2(1) NOT NULL Experience Type
    F=Federal Civilian Sector
    O=Other
    P=Private Sector
    30 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    31 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    32 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    33 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    34 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    35 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    36 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    37 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    38 CITY Character(30) VARCHAR2(30) NOT NULL City
    39 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    40 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    41 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    42 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    43 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    44 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    45 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    46 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: HCR_STONLY_I

    47 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    48 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    49 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    50 DESCRLONG Long Character CLOB Long Description