REQ_STATUS_VW

(SQL View)
 Index Back

Requisition Status Prompt View


SELECT fieldvalue , xlatlongname FROM PSXLATITEM WHERE fieldname = 'REQ_STATUS' AND fieldvalue IN ('P', 'O', 'X','A','C')

  • Related Language Record: REQ_STATUS_VWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
    A=Approved
    C=Complete
    D=Denied
    I=Initial
    LA=Line Approved
    O=Open
    P=Pending Approval
    V=Preview
    X=Canceled
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name