Need to Reset 1098T Process to rerun file for IRS

Problem Description :

Resolution :

this is the script I ran to reset the file so that the Business Office can rerun the 1098T processs

UPDATE TTBTAXN

SET TTBTAXN_STUD_NOTIF_STATUS = 'R',

TTBTAXN_STUD_NOTIF_DATE = TRUNC(SYSDATE)

WHERE TTBTAXN_TAX_YEAR = '2014'

AND TTBTAXN_STUD_NOTIF_STATUS IN ('S', 'E')

AND TRIM(TTBTAXN_IRS_REPORT_DATE) = '&DATE'--TO_DATE('&date', 'DD-MON-YY')

if the Report Status Date needs to be reset (the file has already been sent.) Run this script.

UPDATE TTBTAXN

SET TTBTAXN_IRS_REPORT_STATUS = 'R',

TTBTAXN_IRS_REPORT_DATE = TRUNC(SYSDATE)

WHERE TTBTAXN_TAX_YEAR = '2014' AND TTBTAXN_IRS_REPORT_STATUS IN ('S', 'E')

Revision Date : 1/23/2015

Article Details