HRS_BIP_WEXPLVW

(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 , B.LANGUAGE_CD , ' ' , ' ' , B.EMPLOYER , A.COUNTRY_CODE , A.PHONE , B.ENDING_TITLE , X.XLATLONGNAME , A.CURRENCY_CD , A.HRS_SUPERVISOR , A.EMAIL_ADDR , ' ' , 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 , ' ' , B.DESCRLONG FROM PS_HRS_APP_WRK_EXP A , PS_HRS_APP_PWE_LNG B , PSXLATITEMLANG X WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND B.START_DT = A.START_DT AND B.SEQUENCE_NBR = A.SEQUENCE_NBR AND X.FIELDNAME = 'PAY_FREQ_ABBRV' AND X.FIELDVALUE = A.PAY_FREQ_ABBRV AND A.PAY_FREQ_ABBRV <> ' ' UNION ALL SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.START_DT , A.SEQUENCE_NBR , B.LANGUAGE_CD , ' ' , ' ' , B.EMPLOYER , A.COUNTRY_CODE , A.PHONE , B.ENDING_TITLE , ' ' , A.CURRENCY_CD , A.HRS_SUPERVISOR , A.EMAIL_ADDR , ' ' , 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 , ' ' , B.DESCRLONG FROM PS_HRS_APP_WRK_EXP A , PS_HRS_APP_PWE_LNG B WHERE B.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND B.START_DT = A.START_DT AND B.SEQUENCE_NBR = A.SEQUENCE_NBR AND A.PAY_FREQ_ABBRV = ' '

  • Related Language Record for HRS_BIP_WEXP_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    9 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    10 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    11 ENDING_TITLE Character(30) VARCHAR2(30) NOT NULL Ending Job Title
    12 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    14 HRS_SUPERVISOR Character(50) VARCHAR2(50) NOT NULL Supervisor
    15 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    18 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    19 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    20 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    21 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    22 CITY Character(30) VARCHAR2(30) NOT NULL City
    23 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    24 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    25 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    26 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    27 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    28 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    29 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    30 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: HCR_STONLY_I

    31 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    32 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    33 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    34 ADDRESSLONG Long Character CLOB Address Long
    35 DESCRLONG Long Character CLOB Long Description