CC_STATUS_VW1

(SQL View)
 Index Back

SELECT %Substring(A.FIELDVALUE, 1, 1) , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'CC_STATUS' AND A.EFF_STATUS = 'A' AND A.EFFDT <= %CurrentDateIn AND A.FIELDVALUE <> '4'

  • Related Language Record: CC_STATUS_VW1LN

    • # 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 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name