POST_STATUS_VW

(SQL View)
 Index Back

Post_Status Suspended


SELECT A.FIELDVALUE ,A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'POST_STATUS' AND A.FIELDVALUE IN ('E','I','N') AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = A.FIELDNAME AND C.FIELDVALUE = A.FIELDVALUE AND C.EFF_STATUS = 'A')

  • Related Language Record: POSTSTATUSVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POST_STATUS Character(1) VARCHAR2(1) NOT NULL Posting Status
    B=Balance
    C=Complete
    E=Errors
    I=Incomplete
    N=Not Posted
    R=Reversed
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description