POSTSTATUSVWLNG

(SQL View)
 Index Back

RelLang-Post_Status Susp

POSTSTATUSVWLNG is the related language recordfor the record POST_STATUS_VW

SELECT %Substring(A.FIELDVALUE ,1 ,1) ,B.LANGUAGE_CD ,B.XLATLONGNAME FROM PSXLATITEM A ,PSXLATITEMLANG B WHERE A.FIELDVALUE=B.FIELDVALUE AND A.FIELDNAME=B.FIELDNAME AND A.EFFDT=B.EFFDT AND 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 for POST_STATUS_VW

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