CC_STATUS_VW1LN

(SQL View)
 Index Back

SELECT %Substring(A.FIELDVALUE, 1, 1) , A.LANGUAGE_CD , A.XLATSHORTNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'CC_STATUS' AND A.EFFDT <= %CurrentDateIn AND (%Substring(A.FIELDVALUE, 1, 1) = '1' OR %Substring(A.FIELDVALUE, 1, 1) = '2' OR %Substring(A.FIELDVALUE, 1, 1) = '3')

  • Related Language Record for CC_STATUS_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CC_STATUS Character(1) VARCHAR2(1) NOT NULL Statement Status
    0=Staged
    1=Initial
    2=Verified
    3=Approved
    4=Closed
    5=Error
    6=Processing
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name