HRS_STAT_DSC_VW

(SQL View)
 Index Back

Status View

Status View

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

  • Related Language Record: HRS_STAT_DS_LVW

    • # 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    4 HRS_REC_PHASE Character(10) VARCHAR2(10) NOT NULL Recruitment Phase