HR_ROSTSTVW_LNG

(SQL View)
Index Back

HR - Rel Lang Roster Statuses.

Related Language Roster Statuses from Xlattable.

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

  • Related Language Record for HR_ROST_STAT_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description