HRS_STSRSN2_LNG

(SQL View)
 Index Back

Status Reason Defn Vw - Lang

Identifies a set of status reasons for status codes for impacted status areas when another status is changed for language translations.

SELECT A.STATUS_AREA , A.STATUS_CODE , A.STATUS_REASON , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM PS_HRS_STS_RSN_LNG A

  • Related Language Record for HRS_STSRSN_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 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description