FCT_BNK_CRHDS_CTR_GROSS_MONTHLY_INSIGHT
Description
OBP monthly loan Capacity to Replay extract for CHRDS with all income types (no expenses) for gross Credit Risk History
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PARTY_ID | CHARACTER VARYING(40) | 40 |
| 2 | SUBMISSION_ID | CHARACTER VARYING(100) | 100 |
| 3 | FACILITY_ID | CHARACTER VARYING(50) | 50 |
| 4 | FULL_NAME | CHARACTER VARYING(509) | 509 |
| 5 | FIRST_NAME | CHARACTER VARYING(254) | 254 |
| 6 | LAST_NAME | CHARACTER VARYING(254) | 254 |
| 7 | GROSS_OCCUPATION_INCOME | NUMERIC(22,2) | 19 |
| 8 | NET_OCCUPATION_INCOME | NUMERIC(22,2) | 19 |
| 9 | GROSS_PROPOSED_INCOME | NUMERIC(22,2) | 19 |
| 10 | NET_PROPOSED_INCOME | NUMERIC(22,2) | 19 |
| 11 | GROSS_ASSET_INCOME | NUMERIC(22,2) | 19 |
| 12 | NET_ASSET_INCOME | NUMERIC(22,2) | 19 |
| 13 | GROSS_NON_TAXABLE_INCOME | NUMERIC(22,2) | 19 |
| 14 | NET_NON_TAXABLE_INCOME | NUMERIC(22,2) | 19 |
| 15 | BUS_CASH_FROM_OPS_2YRPRIOR | NUMERIC(22,2) | 19 |
| 16 | BUS_CASH_FROM_OPS_1YRPRIOR | NUMERIC(22,2) | 19 |
| 17 | BUS_CASH_FROM_OPS_CURRENTYR | NUMERIC(22,2) | 19 |