PSHUP_ST_VW1

(SQL View)
 Index Back

PSHUP Status View 1

PSHUP Status View 1

SELECT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'PU_TXN_STATUS' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PSXLATITEM A1 WHERE A1.FIELDNAME = A.FIELDNAME AND A1.FIELDVALUE = A.FIELDVALUE AND A1.EFFDT <= %DateIn('2019-01-01')) AND A.FIELDVALUE IN ('A','E','I','X')

  • Related Language Record: PSHUP_ST_L_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PU_TXN_STATUS Character(1) VARCHAR2(1) NOT NULL Paysheet transaction status.
    A=Active
    E=Exclude
    I=Inactive
    I=Loaded
    M=Manually Paid
    R=Rejected
    X=In Progress
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description