cdpar3_raw
Core Schemas
>
Silverlake
>
cdpar3_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| __op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
| __op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
| __uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
| __ver | Mapping and Schema Version | REQUIRED | INTEGER | |
| c3tran | Tran Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c3dorc | Debit/Credit Code | CHAR(1) | NULLABLE | STRING | 1 |
| c3afft | Affects Code | CHAR(1) | NULLABLE | STRING | 1 |
| c3lact | Affects Date Last Active | CHAR(1) | NULLABLE | STRING | 1 |
| c3ytdc | IRA YTD Contribution | CHAR(1) | NULLABLE | STRING | 1 |
| c3line | IRA Status Report Group | DEC(2,0) | NULLABLE | INTEGER | 2 |
| c3adsb | IRA Status Report Affect | CHAR(1) | NULLABLE | STRING | 1 |
| c3desc | Description | CHAR(40) | NULLABLE | STRING | 40 |
| c3stmd | Statement Description | CHAR(40) | NULLABLE | STRING | 40 |
| c3contyp | ARGO CONTRIBUTION TYPE | CHAR(2) | NULLABLE | STRING | 2 |
| c3lin2 | IRA Status Line #2 | DEC(2,0) | NULLABLE | INTEGER | 2 |
| c3add2 | Affects Line #2 | CHAR(1) | NULLABLE | STRING | 1 |
| c3txyr | Cur/Prev Tax Year | CHAR(1) | NULLABLE | STRING | 1 |
| c3amda | Affects MDA bal | CHAR(1) | NULLABLE | STRING | 1 |
| c3adir | Affects Direct trans | CHAR(1) | NULLABLE | STRING | 1 |
| c3dist | Distribution Code | CHAR(2) | NULLABLE | STRING | 2 |
| c3stmt | Print On Stmt | CHAR(1) | NULLABLE | STRING | 1 |
| c3taxb | Taxable Transaction | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024