OBP24_HST_CI_ACCT_EXTN
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_HST_CI_ACCT_EXTN
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCT_ID | CHARACTER(10) | 10 |
| 2 | FACILITY_ID | CHARACTER VARYING(40) | 40 |
| 3 | LIABILITY_ID | CHARACTER VARYING(40) | 40 |
| 4 | HOST_ACCNT_NBR | CHARACTER VARYING(40) | 40 |
| 5 | BUSINESS_UNIT | CHARACTER VARYING(40) | 40 |
| 6 | MARKET_ENTITY | CHARACTER VARYING(40) | 40 |
| 7 | HOST_PROD_CLASS_CD | CHARACTER VARYING(10) | 10 |
| 8 | HOST_PROD_GRP_CD | CHARACTER VARYING(20) | 20 |
| 9 | HOST_PRD_CD | CHARACTER VARYING(10) | 10 |
| 10 | HOST_SYS_ACCT_STAT_FLG | CHARACTER VARYING(50) | 50 |
| 11 | ACCT_TYPE_CD | CHARACTER VARYING(8) | 8 |
| 12 | SOURCE_HOST_ID | CHARACTER VARYING(10) | 10 |
| 13 | BUS_OBJ_CD | CHARACTER(30) | 30 |
| 14 | BO_STATUS_CD | CHARACTER(12) | 12 |
| 15 | BO_DATA_AREA | CHARACTER VARYING(2000) | 2000 |
| 16 | VERSION | INTEGER | 4 |
| 17 | STATUS_UPD_DTTM | TIMESTAMP | 8 |
| 18 | DR_INT_ACCRD_AMT | NUMERIC(36,18) | 19 |
| 19 | ACCRL_STAT_FLG | CHARACTER(1) | 1 |
| 20 | ACCT_PURPS_CD | CHARACTER VARYING(20) | 20 |
| 21 | LAST_ACCT_RESTR_DT | TIMESTAMP | 8 |
| 22 | APPL_SCR | NUMERIC(5,2) | 19 |
| 23 | BEHAVIOR_SCORE | NUMERIC(5,2) | 19 |
| 24 | REPAYMNT_FREQ | CHARACTER VARYING(30) | 30 |
| 25 | REDRAW_AVL_SW | CHARACTER(1) | 1 |
| 26 | REDRAW_CNT | SMALLINT | 2 |
| 27 | WRITE_OFF_DT | TIMESTAMP | 8 |
| 28 | WRITE_OFF_AMT | NUMERIC(36,18) | 19 |
| 29 | LAST_PRNCPL_WRITE_OFF_DT | TIMESTAMP | 8 |
| 30 | LAST_PROVSN_DT | TIMESTAMP | 8 |
| 31 | MATURITY_DT | TIMESTAMP | 8 |
| 32 | UNCLR_PAYMNT_AMT | NUMERIC(36,18) | 19 |
| 33 | LAST_PRNCPL_WRITE_OFF_BAL | NUMERIC(36,18) | 19 |
| 34 | LAST_PROVSN_BAL | NUMERIC(36,18) | 19 |
| 35 | ACCT_PURPS_TYPE | CHARACTER VARYING(20) | 20 |
| 36 | USR_DEF_ACCT_STAT_FLG | CHARACTER VARYING(120) | 120 |
| 37 | ASST_CLASS_CD | CHARACTER VARYING(40) | 40 |
| 38 | JOINT_APPLICANT_SW | CHARACTER(1) | 1 |
| 39 | LAST_PAYMENT_DT | TIMESTAMP | 8 |
| 40 | LAST_PAYMENT_AMT | NUMERIC(36,18) | 19 |
| 41 | ACCT_ADDR_TYPE | CHARACTER(20) | 20 |
| 42 | EMPLOYEE_ACCT_SW | CHARACTER(1) | 1 |
| 43 | MINOR_ACCOUNT_STATUS_TYPE | CHARACTER VARYING(40) | 40 |
| 44 | OFFER_ID | CHARACTER VARYING(30) | 30 |
| 45 | OFFER_NAME | CHARACTER VARYING(60) | 60 |
| 46 | GUARANTOR_SW | CHARACTER(1) | 1 |
| 47 | SECURED_SW | CHARACTER(1) | 1 |
| 48 | PPI_INSURED_SW | CHARACTER(1) | 1 |
| 49 | LMI_INSURED_SW | CHARACTER(1) | 1 |
| 50 | PROBABILITY_OF_DEFLT_VAL | CHARACTER VARYING(60) | 60 |
| 51 | PER_ADDR_ID | CHARACTER(14) | 14 |
| 52 | UDF1 | CHARACTER VARYING(60) | 60 |
| 53 | UDF2 | CHARACTER VARYING(60) | 60 |
| 54 | UDF3 | CHARACTER VARYING(60) | 60 |
| 55 | UDF4 | CHARACTER VARYING(60) | 60 |
| 56 | UDF5 | CHARACTER VARYING(60) | 60 |
| 57 | UDF6 | CHARACTER VARYING(60) | 60 |
| 58 | UDF7 | CHARACTER VARYING(60) | 60 |
| 59 | UDF8 | CHARACTER VARYING(60) | 60 |
| 60 | UDF9 | CHARACTER VARYING(60) | 60 |
| 61 | UDF10 | CHARACTER VARYING(60) | 60 |
| 62 | UDF11 | CHARACTER VARYING(60) | 60 |
| 63 | UDF12 | CHARACTER VARYING(60) | 60 |
| 64 | UDF13 | CHARACTER VARYING(60) | 60 |
| 65 | UDF14 | CHARACTER VARYING(60) | 60 |
| 66 | UDF15 | CHARACTER VARYING(60) | 60 |
| 67 | UDF16 | CHARACTER VARYING(60) | 60 |
| 68 | UDF17 | CHARACTER VARYING(60) | 60 |
| 69 | UDF18 | CHARACTER VARYING(60) | 60 |
| 70 | UDF19 | CHARACTER VARYING(60) | 60 |
| 71 | UDF20 | CHARACTER VARYING(60) | 60 |
| 72 | NON_STARTER_SW | CHARACTER(1) | 1 |
| 73 | WRITE_OFF_REQUEST_DT | TIMESTAMP | 8 |
| 74 | BRANCH_CD | CHARACTER VARYING(20) | 20 |
| 75 | IN_COLLECTIONS_SW | CHARACTER(1) | 1 |
| 76 | LAST_SETOFF_DT | TIMESTAMP | 8 |
| 77 | LAST_SETOFF_AMT | NUMERIC(36,18) | 19 |
| 78 | LEGAL_CASE_EXISTS_SW | CHARACTER(1) | 1 |
| 79 | REPO_CASE_EXISTS_SW | CHARACTER(1) | 1 |
| 80 | DEBT_SOLD_SW | CHARACTER(1) | 1 |
| 81 | ACCT_IN_DISPUTE_SW | CHARACTER(1) | 1 |
| 82 | OUTSTANDING_AMT | NUMERIC(38,16) | 19 |
| 83 | OVERLIMIT_AMT | NUMERIC(38,16) | 19 |
| 84 | OVERDUE_AMT | NUMERIC(38,16) | 19 |
| 85 | DISBRS_AMT | NUMERIC(38,16) | 19 |
| 86 | TOTAL_AVL_DISBRS_AMT | NUMERIC(38,16) | 19 |
| 87 | LTV_VAL | NUMERIC(5,2) | 19 |
| 88 | LVR_VAL | NUMERIC(5,2) | 19 |
| 89 | JOINT_NOMINATION_SW | CHARACTER(1) | 1 |
| 90 | STICKY_NOTES | CHARACTER VARYING(4000) | 4000 |
| 91 | SETOFF_EXCLD_DT | TIMESTAMP | 8 |
| 92 | REGULATED_ACCOUNT_SW | CHARACTER(1) | 1 |
| 93 | ACCT_TITLE | CHARACTER VARYING(500) | 500 |
| 94 | USR_DEF_INST_SW | CHARACTER VARYING(1) | 1 |
| 95 | IOA_BALANCE_AMT | NUMERIC(36,18) | 19 |
| 96 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 97 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 98 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 99 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |