REQ_STATUS_VWLN

(SQL View)
 Index Back

Requisition Status Prompt View


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

  • Related Language Record for REQ_STATUS_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name