ACA_EXT_ERR_AET(SQL Table) |
Index Back |
|---|---|
ACA Extract State RecordThis is a state record utilized by the ACA Extract process (ACA_EXTRACT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 3 | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
|
| 4 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |