FCT_BNK_HPP_PERSONAL_LOAN_REPORT_V
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 2 | GCIS_PARTY_ID | CHARACTER VARYING(400) | 400 |
| 3 | PARTY_ID | CHARACTER VARYING(50) | 50 |
| 4 | PROD_GROUP | CHARACTER VARYING(14) | 14 |
| 5 | ACCOUNT_TITLE | CHARACTER VARYING(300) | 300 |
| 6 | FACILITY_ID | CHARACTER VARYING(40) | 40 |
| 7 | ACCOUNT_OPENING_DATE | TIMESTAMP | 8 |
| 8 | ACCOUNT_CLOSURE_DATE | TIMESTAMP | 8 |
| 9 | ACCOUNT_STATUS_CODE | CHARACTER VARYING(50) | 50 |
| 10 | MATURITY_DATE | TIMESTAMP | 8 |
| 11 | HL_MIN_DATE | TIMESTAMP | 8 |
| 12 | SUBMISSION_UNCDTL_APPROVAL_OFFICER | CHARACTER VARYING(40) | 40 |
| 13 | STANDARD_RATE | NUMERIC(8,5) | 19 |
| 14 | ADJUSTED_RATE | DOUBLE PRECISION | 8 |
| 15 | SAME_RATE_FLAG | CHARACTER VARYING(14) | 14 |
| 16 | PL_OPEN_GT_HL_FLAG | CHARACTER VARYING(9) | 9 |
| 17 | MAX_AKF_DATE | DATE | 4 |
| 18 | AKF_VALUE | DOUBLE PRECISION | 8 |
| 19 | AKF_CHARGED_FLAG | CHARACTER VARYING(15) | 15 |
| 20 | MAX_EST_DATE | DATE | 4 |
| 21 | ESTABLISHMENT_VALUE | DOUBLE PRECISION | 8 |
| 22 | EST_FEE_CHARGED_FLAG | CHARACTER VARYING(15) | 15 |