| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
ACA_DAT_EXTRACT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Extract ID for the ACA data
Prompt Table:
ACA_DATEXTR_DEF
|
| 4 |
ACA_ALE_GRP_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
ACA Aggregated ALE Group ID
Prompt Table:
ACA_ALE_GRP
|
| 5 |
ACA_ALE_MEMBER |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to contain value of ALE Member name
Prompt Table:
ACA_ALE_TBL
|
| 6 |
ACA_CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
1094-C/1095-C Calendar Year
|
| 7 |
ACA_PROCESS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process type.
C=Correction
O=Original
P=Replace Transmission
Q=Replace Submission
R=Reissue
Default Value: O
|
| 8 |
ACA_FINAL_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether final run or not.
Y/N Table Edit
Default Value: N
|
| 9 |
ACA_EXPORT_FILE |
Character(80) |
VARCHAR2(80) NOT NULL |
Transmittal Export File Name.
|
| 10 |
ACA_IMPORT_FILE |
Character(80) |
VARCHAR2(80) NOT NULL |
Transmittal Export File Name.
|
| 11 |
ACA_YE_RPT_BURST |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if report bursting is required.
|
| 12 |
ACA_NUM_OF_REC |
Number(7,0) |
INTEGER NOT NULL |
Indicates the batch sizes for breaking down a large report.
|
| 13 |
ACA_SORT_CODE1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Report By
1=None
5=Zip Code
Default Value: 1
|
| 14 |
ACA_SORT_CODE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Within Sort, Order By
1=Employee ID
2=Employee SSN
3=Employee Last Name
Default Value: 1
|
| 15 |
ACA_SELECT_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular or Select Empl Proc
A=All Employees
S=Selected Employees
Default Value: A
|
| 16 |
ACA_UUID |
Character(36) |
VARCHAR2(36) NOT NULL |
UUID
|
| 17 |
ACA_TESTFILEIND |
Character(1) |
VARCHAR2(1) NOT NULL |
ACA Test File Indicator.
P=Production
T=AATS
|
| 18 |
ACA_TESTSCENARIOID |
Character(5) |
VARCHAR2(5) NOT NULL |
ACA Test Scenario ID.
|
| 19 |
ACA_TOT_FORMS_ALE |
Number(12,0) |
DECIMAL(12) NOT NULL |
Total number of Forms submitted with this transmittal
|
| 20 |
ACA_PLAN_START_NON |
Character(1) |
VARCHAR2(1) NOT NULL |
Set Plan Start Month to blank.
Y/N Table Edit
Default Value: N
|
| 21 |
ACA_ATTACHADD |
Character(1) |
VARCHAR2(1) NOT NULL |
Load ACA Attachment.
|
| 22 |
ACA_RECEIPT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
ACA Receipt ID
Prompt Table:
ACA_ALE_MEM_SUB
|
| 23 |
ACA_RERUN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ACA rerun flag.
Y/N Table Edit
Default Value: N
|
| 24 |
ACA_ALE_SEQNO |
Number(3,0) |
SMALLINT NOT NULL |
ACA ALE Sequence
Prompt Table:
ACA_ALE_MEM_SUB
|
| 25 |
ACA_TOT_FORMS_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Total number of Forms submitted with this transmittal
Y/N Table Edit
Default Value: N
|
| 26 |
ACA_TOT_FORMS_ADD |
Number(12,0) |
DECIMAL(12) NOT NULL |
Total number of Forms submitted with this transmittal
|