CS_CNT_AG_VW1

(SQL View)
 Index Back

Contract AG Status Xlat View

View for contract compliance status xlats.

SELECT %Substring(X.FIELDVALUE, 1, 2) , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'CS_COMPLIANCE_STAT' AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

  • Related Language Record: CS_CNT_AG_LVW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_COMPLIANCE_STAT Character(2) VARCHAR2(2) NOT NULL Compliance Status for Supplier Contract Managment
    1=Compliant
    2=Not Compliant
    3=Not Set
    4=Cancelled
    2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name