OMEC_SCHSTAT_VW

(SQL View)
 Index Back

OMEC Schedule status

Valid status for ORD_SCHEDULE in OMEC

SELECT x.fieldvalue , x.xlatlongname FROM PSXLATITEM x WHERE x.fieldname = 'ORD_SCH_STATUS' AND x.fieldvalue IN ('O','X') AND x.eff_status = 'A' AND %EffdtCheck(PSXLATITEM, x, %CurrentDateIn)

  • Related Language Record: OMEC_SCHSTATLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
    C=Closed
    O=Open
    P=Pending
    X=Canceled
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name