HR_ROST_STAT_VW

(SQL View)
Index Back

HR - Rost Status Vw

Roster Statuses from Xlattable.

SELECT %Substring(A.FIELDVALUE ,1,3) , A.EFFDT , A.EFF_STATUS , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'LBR_ROST_STATUS_CD' AND %EffdtCheck(PSXLATITEM, A, %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: HR_ROSTSTVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LBR_ROST_STATUS_CD Character(3) VARCHAR2(3) NOT NULL Roster Status
    010=010 - Open
    020=020 - In Progress
    030=030 - Awaiting Approval
    040=040 - Approved
    050=050 - Not Approved
    060=060 - On Hold
    070=070 - Final
    090=090 - Cancelled
    100=100 - Closed
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description