FCT_BNK_CRHDS_LNBASE_INSIGHT
Description
OBP Monthly extract with select details for active loan accounts
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | COID | INTEGER | 4 |
| 2 | LNPRD | CHARACTER VARYING(30) | 30 |
| 3 | LNNUM | CHARACTER VARYING(40) | 40 |
| 4 | PRD_GRP | CHARACTER VARYING(1) | 1 |
| 5 | LNTYPE | CHARACTER VARYING(30) | 30 |
| 6 | LN_DESC | CHARACTER VARYING(120) | 120 |
| 7 | LNTRM | NUMERIC(18,0) | 19 |
| 8 | ORGTRM | BIGINT | 8 |
| 9 | LNBAL | NUMERIC(35,2) | 19 |
| 10 | LNAPR | DOUBLE PRECISION | 8 |
| 11 | BCH_NAME | CHARACTER VARYING(105) | 105 |
| 12 | BOR1 | CHARACTER VARYING(40) | 40 |
| 13 | PCDE1 | CHARACTER VARYING(30) | 30 |
| 14 | BOR2 | CHARACTER VARYING(40) | 40 |
| 15 | PCDE2 | CHARACTER VARYING(30) | 30 |
| 16 | BOR3 | CHARACTER VARYING(40) | 40 |
| 17 | PCDE3 | CHARACTER VARYING(30) | 30 |
| 18 | BOR4 | CHARACTER VARYING(40) | 40 |
| 19 | PCDE4 | CHARACTER VARYING(30) | 30 |
| 20 | A_FLAG | CHARACTER VARYING(1) | 1 |
| 21 | A_TIME | CHARACTER VARYING(10) | 10 |
| 22 | REPO | CHARACTER VARYING(1) | 1 |
| 23 | AR_AMT | NUMERIC(35,2) | 19 |
| 24 | PRIM_OFF | CHARACTER VARYING(50) | 50 |
| 25 | BROKER | CHARACTER VARYING(20) | 20 |
| 26 | SALE_OFF | CHARACTER VARYING(254) | 254 |
| 27 | DT_FUND | CHARACTER VARYING(200) | 200 |
| 28 | APR_DT | CHARACTER VARYING(200) | 200 |
| 29 | VALUE | NUMERIC(18,2) | 19 |
| 30 | SP_PROV | NUMERIC(18,2) | 19 |
| 31 | AR_DAY | DOUBLE PRECISION | 8 |
| 32 | SEC_OFF | CHARACTER VARYING(40) | 40 |
| 33 | NA_FLAG | CHARACTER VARYING(1) | 1 |
| 34 | NA_AMT | DOUBLE PRECISION | 8 |
| 35 | MAT_DT | CHARACTER VARYING(200) | 200 |
| 36 | INSCO | CHARACTER VARYING(50) | 50 |
| 37 | POLICY | CHARACTER VARYING(20) | 20 |
| 38 | NAME | CHARACTER VARYING(250) | 250 |
| 39 | INSAMT | CHARACTER(15) | 15 |
| 40 | PAYMT | NUMERIC(18,2) | 19 |
| 41 | FHOF | CHARACTER VARYING(1) | 1 |
| 42 | BDAY | CHARACTER VARYING(200) | 200 |
| 43 | SEX | CHARACTER(3) | 3 |
| 44 | OCC | CHARACTER VARYING(30) | 30 |
| 45 | EMP | CHARACTER VARYING(120) | 120 |
| 46 | D_G | INTEGER | 4 |
| 47 | D30 | INTEGER | 4 |
| 48 | D60 | INTEGER | 4 |
| 49 | D90 | INTEGER | 4 |
| 50 | D120 | INTEGER | 4 |
| 51 | LOAN_ISS | CHARACTER VARYING(200) | 200 |
| 52 | FEE_ARREARS_AMT | DOUBLE PRECISION | 8 |