HRS_BIP_WEXP_VW

(SQL View)
 Index Back

Applicant Work Experience

Returns work experience for an applicant's profile

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.START_DT , A.SEQUENCE_NBR , ' ' , A.EMPLOYER , %subrec(PHONE_SBR, A) , A.END_DT , ' ' , A.ENDING_TITLE , A.ENDING_RATE , A.PAY_FREQ_ABBRV , X.XLATLONGNAME , A.CURRENCY_CD , A.HRS_SUPERVISOR , A.EMAIL_ADDR , A.HRS_CONTACT_OK_FLG , ' ' , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.ADDR_FIELD1 , A.ADDR_FIELD2 , A.ADDR_FIELD3 , A.COUNTY , A.STATE , A.POSTAL , A.GEO_CODE , A.IN_CITY_LIMIT , ' ' , A.DESCRLONG , ' ' FROM PS_HRS_APP_WRK_EXP A LEFT OUTER JOIN PS_HRS_XLAT_EFF_VW X ON X.FIELDNAME = 'PAY_FREQ_ABBRV' AND X.FIELDVALUE = A.PAY_FREQ_ABBRV AND X.EFF_STATUS = 'A'

  • Related Language Record: HRS_BIP_WEXPLVW

    • # 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
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    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 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    11 ENDING_TITLE Character(30) VARCHAR2(30) NOT NULL Ending Job Title
    12 ENDING_RATE Number(19,3) DECIMAL(18,3) NOT NULL Ending Pay Rate
    13 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
    A=Annual
    B=Bi-weeky
    H=Hour
    M=Month
    Y=Year
    14 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    16 HRS_SUPERVISOR Character(50) VARCHAR2(50) NOT NULL Supervisor
    17 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email
    18 HRS_CONTACT_OK_FLG Character(1) VARCHAR2(1) NOT NULL OK to contact?

    Y/N Table Edit

    Default Value: Y

    19 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    25 CITY Character(30) VARCHAR2(30) NOT NULL City
    26 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    27 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    28 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    29 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    30 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    31 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    32 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    33 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: HCR_STONLY_I

    34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    36 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    37 ADDRESSLONG Long Character CLOB Address Long
    38 DESCRLONG Long Character CLOB Long Description
    39 HRS_PRINT_WRKD_SEL Character(1) VARCHAR2(1) NOT NULL Determines if Work Exp with details is selected
    N=No
    Y=Yes