HRS_STS_RSN_LNG

(SQL Table)
 Index Back

Status Reason Definition-Lang

Defines a set of status reasons for status codes for status areas for language translations.

  • Related Language Record for HRS_RSN_APP_I HRS_RSN_INT_I HRS_RSN_JO_I HRS_RSN_JO_VW HRS_RSN_OFF_I HRS_RSN_REC_I HRS_RSN_RTE_I HRS_RSN_RTE_VW HRS_STSRSN_TBL

  • Parent record: HRS_STS_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STATUS_AREA Character(1) VARCHAR2(1) NOT NULL Defines an area in the system that track statuses.
    1=1-Job Opening
    2=2-Applicant
    3=3-Recruitment Summary
    4=4-Route
    5=5-Interview
    6=6-Offer
    2 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    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