HRS_STS_JO_LVW

(SQL View)
Index Back

Posn Applied For Sts Defn Vw

Identifies the set of status code definitions for the position applied for recruitment area.

SELECT STATUS_AREA , STATUS_CODE , LANGUAGE_CD , DESCR , DESCRSHORT FROM PS_HRS_STS_LNG WHERE STATUS_AREA = '1'

  • Related Language Record for HRS_STS_JO_I HRS_STS_JO_VW
  • # 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 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