SS_EVT_STAT_SLW

(SQL View)
 Index Back

Sourcing Event Status XLAT Lan


SELECT B.FIELDVALUE ,L.LANGUAGE_CD , L.XLATLONGNAME FROM PSXLATITEM B , PSXLATITEMLANG L WHERE B.FIELDNAME = 'AUC_STATUS' AND %EffdtCheck(PSXLATITEM A, B, %CURRENTDATEIN) AND B.FIELDNAME = L.FIELDNAME AND B.FIELDVALUE = L.FIELDVALUE AND B.EFFDT = L.EFFDT AND B.EFF_STATUS = 'A'

  • Related Language Record for SS_EVT_STAT_SVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
    A=Awarded
    C=Collaborating Event
    D=Collaborating Bid Analysis
    E=Evaluating
    F=RFI Reviewed
    I=Pending RFI Review
    N=Not Awarded
    O=Open
    P=Posted
    Q=Paused
    R=Pending Scheduled Review
    S=Pending Post Approval
    T=Pending Award
    U=Pending Award Approval
    W=Post to Third Party Failed
    X=Cancelled
    Z=Inactive Version
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 AUC_XLAT_DESCR Character(30) VARCHAR2(30) NOT NULL Unit of Measure