PSHUP_ST_L_VW1

(SQL View)
 Index Back

PSHUP Status Lang View 1

PSHUP Status Lang View 1

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

  • Related Language Record for PSHUP_ST_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description