PY_1042S_TRM_LG

(SQL View)
 Index Back

1042S Year End Transmitter

1042S Year End Transmitter View (related language)

SELECT A.TAX_YEAR , A.TRANSMITTER , B.LANGUAGE_CD , B.DESCR FROM PS_PY_1042S_TRMCTL A , PS_COMPNY_TBL_LANG B WHERE NOT EXISTS ( SELECT 'X' FROM PS_PY_1042S_FILCTL C WHERE A.TAX_YEAR = C.TAX_YEAR AND A.TRANSMITTER = C.TRANSMITTER AND C.PY_FORM_SUBMITTED = 'Y') AND A.TRANSMITTER = B.COMPANY AND %EffdtCheck(COMPANY_TBL B1, B, %CurrentDateIn)

  • Related Language Record for PY_1042S_TRM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TAX_YEAR Signed Number(5,0) DECIMAL(4) NOT NULL Tax Year
    2 TRANSMITTER Character(3) VARCHAR2(3) NOT NULL Transmitter

    Prompt Table: COMPANY_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description