PSHUP_ST_L_VW2

(SQL View)
 Index Back

PSHUP Status Lang View 2

PSHUP Status Lang View 2

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 <= %CurrentDateIn) AND A.FIELDVALUE <> 'X'

  • Related Language Record for PSHUP_ST_VW2

    • # 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