HRS_STAT_DS_LVW

(SQL View)
 Index Back

Status View

Status View

SELECT rl.fieldname , rl.fieldvalue , rl.LANGUAGE_CD , rl.xlatlongname , rl.xlatshortname FROM psxlatitem x , PSXLATITEMLANG rl WHERE rl.fieldname = x.fieldname AND rl.fieldvalue = x.fieldvalue AND rl.effdt = x.effdt AND x.fieldname = 'STATUS_PHASE' AND x.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE B.FIELDNAME = x.FIELDNAME AND B.FIELDVALUE = x.FIELDVALUE AND B.EFFDT <= %CurrentDateIn) AND x.EFF_STATUS = 'A' AND EXISTS ( SELECT 'Y' FROM PS_HRS_STS_LNG y1 ,PS_HRS_STS_TBL y WHERE y1.LANGUAGE_CD = rl.LANGUAGE_CD AND y1.STATUS_CODE = y.STATUS_CODE AND y1.STATUS_AREA = y.STATUS_AREA AND y.STATUS_AREA = '3' AND x.fieldvalue = y.status_phase)

  • Related Language Record for HRS_STAT_DSC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 STATUS_PHASE Character(1) VARCHAR2(1) NOT NULL Identifies a phase within a status area.
    1=1-Applied
    2=2-Reviewed
    3=3-Screen
    4=4-Route
    5=5-Interview
    6=6-Offer
    7=7-Hire
    8=8-Hold
    9=9-Reject
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    5 HRS_REC_PHASE Character(10) VARCHAR2(10) NOT NULL Recruitment Phase