HRS_APP_WK_EX_I

(SQL View)
 Index Back

App Prior Work Experiencev Int

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

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.START_DT ,A.SEQUENCE_NBR ,A.EMPLOYER ,A.CITY ,A.STATE ,A.COUNTRY ,%subrec(PHONE_SBR, A) ,A.END_DT ,A.ENDING_TITLE ,A.ENDING_RATE ,A.PAY_FREQ_ABBRV ,A.CURRENCY_CD ,A.US_SOC_CD ,A.CAN_NOC_CD ,A.REL_WRK_EXPER ,%subrec(GVT_PRI_WRK_SBR, A) ,A.DESCRLONG FROM PS_HRS_APP_WRK_EXP A

  • Related Language Record: HRS_APP_WK_EX_L

  • 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
    5 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    6 CITY Character(30) VARCHAR2(30) NOT NULL City
    7 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    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 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: %SAL_GRD_PRMPT1

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

    Prompt Table: GVT_PAY_PLAN

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

    Prompt Table: GVT_OCCUPATION

    24 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)
    25 GVT_HOURS_PER_WEEK Number(4,1) DECIMAL(3,1) NOT NULL Hours Per Week
    26 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
    1=Competitive
    2=Excepted
    3=SES General
    4=SES Career Reserved
    27 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
    0=None
    1=Permanent
    2=Conditional
    3=Indefinite
    28 GVT_TYPE_OF_EXP Character(1) VARCHAR2(1) NOT NULL Experience Type
    F=Federal Civilian Sector
    O=Other
    P=Private Sector
    29 DESCRLONG Long Character CLOB Long Description