SS_EVT_STAT_SVW

(SQL View)
Index Back

Sourcing Event Status XLAT


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

  • Related Language Record: SS_EVT_STAT_SLW
  • # 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 AUC_XLAT_DESCR Character(30) VARCHAR2(30) NOT NULL Unit of Measure