The SAT requires that employers submit to them their employees' wages, salaries, and ISR withholdings on a yearly basis. The Multiple Informative Declaration (DIM) program is the Java application they provide for this purpose. This program accepts flat files with data in a continuous delimited sequence. Oracle Payroll provides the Information Declaration Report (DIM) process to generate this file.
The DIM information must include any ISR tax withheld to any employee in the fiscal year (January 1 through December 31). If there are any rehires in the same GRE, then the DIM interface recalculates the seniority for employees having multiple period of services using the function CALC_SENIORITY. This function will calculate the seniority of an employee for each period of service in the current reporting year based on the original hire date for the first period of service and period of service start date for the remaining periods of service.
Oracle Payroll provides the Information Declaration Report (DIM) concurrent program to produce the data in a format requi red by SAT for uploading into the DIM program. The output file produced by Oracle Payroll corresponds to Attachment 1 (ISR Reporting) of the DIM.
The Information Declaration Report (DIM) concurrent program creates five output files in the default output directory for your application's concurrent processing:
| File Name | File Type | Description |
|---|---|---|
| DIMAAABBBBBMMDDYYHHMISS_4_P.eft | Fixed Format | Wages, salaries, and tax information. Upload this file to DIM. |
| DIMAAABBBBBMMDDYYHHMISS_3_P.eft | Comma Separated | Audit report for DIM. This file contains details of employee wages, salaries, and ISR tax and can be opened using a spreadsheet tool for review and verification. Do not upload this file to DIM. |
| DIMAAABBBBBMMDDYYHHMISS_2_P.eft | Comma Separated | Exception report for DIM. This file contains records that had errors or did not pass validation rules. The file can be opened using a spreadsheet tool. Do not upload this file to DIM. |
| DIMAAABBBBBMMDDYYHHMISS_1_P.pdf | Summary report. This report provides a summary of data reported on the main report. | |
| DIMAAABBBBBMMDDYYHHMISS.xml | XML | The XML file containing all the DIM information. This file is currently for internal use only. |
These files using the following naming convention:
AAA: First three characters of the Legal Employer name
BBBBB: Organization ID for the Legal Employer
MMDDYY: Date when the Information Declaration Report (DIM) program was run (MM = Month, DD = Day, YY = Year)
HHMISS: Time when the Information Declaration Report (DIM) program was run (HH = Hour, MI = Minutes, SS = Seconds)