cfpar1_raw
Core Schemas
>
Silverlake
>
cfpar1_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 | |
| cp1rel | Relationship code | CHAR(5) | NULLABLE | STRING | 5 |
| cp1dsc | Description | CHAR(10) | NULLABLE | STRING | 10 |
| cp1typ | Relationship type | CHAR(1) | NULLABLE | STRING | 1 |
| cp1val | Valid application | CHAR(1) | NULLABLE | STRING | 1 |
| cp1llb | Include on loan liability report | CHAR(1) | NULLABLE | STRING | 1 |
| cp1txt | Text | CHAR(50) | NULLABLE | STRING | 50 |
| cp1rgp | Eligble for Reg P | CHAR(1) | NULLABLE | STRING | 1 |
| cp1adr | Argo deposit relationship code | CHAR(3) | NULLABLE | STRING | 3 |
| cp1alr | Argo loan relationship code | CHAR(3) | NULLABLE | STRING | 3 |
| cp1pdn | Past due notices to this relationship | CHAR(1) | NULLABLE | STRING | 1 |
| cp1str | Addl Name for Streamline | CHAR(1) | NULLABLE | STRING | 1 |
| cfpar1_id | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| cp1crtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| cp1mntts | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| cp1own | Owner Y/N | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024