HRS_APWRKEX_HST

(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.

  • Parent record: HRS_APP_PROFILE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    5 START_DT Date(10) DATE NOT NULL Start Date
    6 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    7 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: COUNTRY_TBL

    9 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    10 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    11 END_DT Date(10) DATE end date
    12 ENDING_TITLE Character(30) VARCHAR2(30) NOT NULL Ending Job Title
    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

    Default Value: M

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

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    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

    Y/N Table Edit

    Default Value: Y

    19 HRS_SUPERVISOR Character(50) VARCHAR2(50) NOT NULL Supervisor
    20 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email
    21 HRS_CONTACT_OK_FLG Character(1) VARCHAR2(1) NOT NULL OK to contact?

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: HRS_GVTGRD_I

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

    Prompt Table: HRS_PAY_PLAN_I

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

    Prompt Table: HRS_GVT_OCC_I

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

    Prompt Table: HCR_STONLY_I

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

    Y/N Table Edit

    52 DESCRLONG Long Character CLOB Long Description