cdparp_raw
Core Schemas
>
Silverlake
>
cdparp_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 | |
| c1code | Penalty Type | CHAR(2) | NULLABLE | STRING | 2 |
| c1desc | Penalty Description | CHAR(30) | NULLABLE | STRING | 30 |
| c1btm1 | Beginning Term 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1btc1 | Beg Term 1 Code | CHAR(1) | NULLABLE | STRING | 1 |
| c1etm1 | Ending Term 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1etc1 | End Term 1 Code | CHAR(1) | NULLABLE | STRING | 1 |
| c1ftm1 | Forfeit Term 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ftc1 | Forfeit Term Code 1 | CHAR(1) | NULLABLE | STRING | 1 |
| c1pct1 | Forfeit Percent 1 | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| c1pcd1 | Prin/Int Percent 1 | CHAR(1) | NULLABLE | STRING | 1 |
| c1rt_num_1 | Alternate Rate # 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ptm1 | Alt Rate Term 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ptc1 | Alt Rate Term Code 1 | CHAR(1) | NULLABLE | STRING | 1 |
| c1inv1 | Invade Principal 1 | CHAR(1) | NULLABLE | STRING | 1 |
| c1glc1 | Greater/Lesser Code 1 | CHAR(1) | NULLABLE | STRING | 1 |
| c1int1 | Intpd subject to penalty | CHAR(1) | NULLABLE | STRING | 1 |
| c1btm2 | Beginning Term 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1btc2 | Beg Term 2 Code | CHAR(1) | NULLABLE | STRING | 1 |
| c1etm2 | Ending Term 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1etc2 | End Term 2 Code | CHAR(1) | NULLABLE | STRING | 1 |
| c1ftm2 | Forfeit Term 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ftc2 | Forfeit Term Code 2 | CHAR(1) | NULLABLE | STRING | 1 |
| c1pct2 | Forfeit Percent 2 | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| c1pcd2 | Prin/Int Percent 2 | CHAR(1) | NULLABLE | STRING | 1 |
| c1rt_num_2 | Alternate Rate # 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ptm2 | Alt Rate Term 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ptc2 | Alt Rate Term Code 2 | CHAR(1) | NULLABLE | STRING | 1 |
| c1inv2 | Invade Principal 2 | CHAR(1) | NULLABLE | STRING | 1 |
| c1glc2 | Greater/Lesser Code 2 | CHAR(1) | NULLABLE | STRING | 1 |
| c1int2 | Intpd subject to penalty | CHAR(1) | NULLABLE | STRING | 1 |
| c1btm3 | Beginning Term 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1btc3 | Beg Term 3 Code | CHAR(1) | NULLABLE | STRING | 1 |
| c1etm3 | Ending Term 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1etc3 | End Term 3 Code | CHAR(1) | NULLABLE | STRING | 1 |
| c1ftm3 | Forfeit Term 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ftc3 | Forfeit Term Code 3 | CHAR(1) | NULLABLE | STRING | 1 |
| c1pct3 | Forfeit Percent 3 | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| c1pcd3 | Prin/Int Percent 3 | CHAR(1) | NULLABLE | STRING | 1 |
| c1rt_num_3 | Alternate Rate # 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ptm3 | Alt Rate Term 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| c1ptc3 | Alt Rate Term Code 3 | CHAR(1) | NULLABLE | STRING | 1 |
| c1inv3 | Invade Principal 3 | CHAR(1) | NULLABLE | STRING | 1 |
| c1glc3 | Greater/Lesser Code 3 | CHAR(1) | NULLABLE | STRING | 1 |
| c1int3 | Intpd subject to penalty | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024