HRS_HIRE_WK_EXP

(SQL View)
 Index Back

Hire - Prior Work Experience

Hire Integration - Prior Work Experience

SELECT B.EMPLID ,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.REL_WRK_EXPER ,A.DESCRLONG ,B.HRS_HIRE_SEQ FROM PS_HRS_APP_WRK_EXP A ,PS_HRS_HIRE B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = B.HRS_PROFILE_SEQ

  • Related Language Record: HRS_HIREWRK_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    3 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    4 START_DT Date(10) DATE NOT NULL Start Date
    5 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    6 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    7 CITY Character(30) VARCHAR2(30) NOT NULL City
    8 STATE Character(6) VARCHAR2(6) NOT NULL State
    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    10 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    11 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    12 END_DT Date(10) DATE end date
    13 ENDING_TITLE Character(30) VARCHAR2(30) NOT NULL Ending Job Title
    14 ENDING_RATE Number(19,3) DECIMAL(18,3) NOT NULL Ending Pay Rate
    15 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
    A=Annual
    B=Bi-weeky
    H=Hour
    M=Month
    Y=Year
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    17 REL_WRK_EXPER Character(1) VARCHAR2(1) NOT NULL Relevant Work Experience

    Y/N Table Edit

    Default Value: Y

    18 DESCRLONG Long Character CLOB Long Description
    19 HRS_HIRE_SEQ Number(10,0) DECIMAL(10) NOT NULL Hire Sequence ID