HRS_STS2_LNG

(SQL View)
 Index Back

Status Definition View - Lang

Identifies a set of status codes for the status area that is being impacted due to a status change for language translations.

SELECT A.STATUS_AREA , A.STATUS_CODE , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM PS_HRS_STS_LNG A

  • Related Language Record for HRS_STATUS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STATUS_AREA_CHG Character(1) VARCHAR2(1) NOT NULL Identifies a status area that is impacted by a status change.
    1=Job Opening
    2=Applicant
    3=Recruitment Summary
    4=Route
    5=Interview
    6=Offer
    2 STATUS_CODE_CHG Character(3) VARCHAR2(3) NOT NULL Identifies a status code that is changed or is changed to based on a status code change.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description