W2_REPORTING_COBALANCE_YEARPR_CONF_NBR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.W2_REPORTING_CO , A.CALENDAR_YEAR , A.ELEC_FILE_CONF_NO , A.ELEC_FILE_CONF_NO FROM PS_W2_COMPANY A , PS_COMPANY_TBL C WHERE A.COMPANY = A.W2_REPORTING_CO AND A.COMPANY = C.COMPANY AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_COMPANY_TBL C1 WHERE C1.COMPANY = C.COMPANY AND C1.EFFDT <= %DateIn(%NumToChar(A.CALENDAR_YEAR) %Concat '-12-31')) AND C.TAX_REPORT_TYPE = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | W2_REPORTING_CO |
Character(3) | VARCHAR2(3) NOT NULL | W-2 Reporting Company |
| 2 | BALANCE_YEAR |
Number(4,0) | SMALLINT NOT NULL | Balances for Year |
| 3 | ELEC_FILE_CONF_NO | Character(11) | VARCHAR2(11) NOT NULL | Puerto Rico Electronic Filing Confirmation Number |
| 4 | PREV_ELEC_CONF_NO | Character(11) | VARCHAR2(11) NOT NULL | Previous Puerto Rico Electronic Filing Confirmation Number |