ACA_CALENDAR_YEARP=Production
T=AATS
ACA_XMIT_PARAMS(SQL Table) |
Index Back |
|---|---|
ACA Transmittal ParametersParameters required to generate ACA Transmittal file(s). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACA_CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | 1094-C/1095-C Calendar Year |
| 2 | ACA_SOFTWARE_ID | Character(20) | VARCHAR2(20) NOT NULL | ACA Software ID. |
| 3 | ACA_FORMTYPECD | Character(20) | VARCHAR2(20) NOT NULL | ACA Form Type Code. |
| 4 | ACA_NUM_OF_REC | Number(7,0) | INTEGER NOT NULL | Indicates the batch sizes for breaking down a large report. |
| 5 | ACA_TESTFILEIND | Character(1) | VARCHAR2(1) NOT NULL |
ACA Test File Indicator.
P=Production T=AATS |
| 6 | ACA_VENDOR_ID | Character(1) | VARCHAR2(1) NOT NULL | ACA Vendor ID. |
| 7 | CONTACT_NAME_SUFFX | Character(15) | VARCHAR2(15) NOT NULL | Name Suffix |
| 8 | CONTACT_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 9 | CONTACT_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 10 | CONTACT_MID_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 11 | CONTACT_PHONE_ACA | Character(24) | VARCHAR2(24) NOT NULL | Used for contact phone for ACA |