INT_OBP_COLLECTION

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_OBP_COLLECTION_V

Columns
# Name Data Type Length
1 ACCT_ID CHARACTER(10) 10
2 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
3 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
4 SA_ID CHARACTER(10) 10
5 DELINQ_START_DT TIMESTAMP 8
6 DELINQ_END_DT TIMESTAMP 8
7 PARTY_UID CHARACTER(10) 10
8 CASE_ID CHARACTER(10) 10
9 SETUP_DT TIMESTAMP 8
10 PROTECT_PREM_SW CHARACTER(1) 1
11 PROTECT_DIV_SW CHARACTER(1) 1
12 PROTECT_CYC_SW CHARACTER(1) 1
13 POSTPONE_CR_RVW_DT TIMESTAMP 8
14 NO_DEP_RVW_SW CHARACTER(1) 1
15 MAILING_PREM_ID CHARACTER(10) 10
16 INT_CR_REVIEW_SW CHARACTER(1) 1
17 EC_EXPIRY_SCHEDULE_CD CHARACTER(12) 12
18 CUST_CL_CD CHARACTER(8) 8
19 CURRENCY_CD CHARACTER(3) 3
20 CR_REVIEW_DT TIMESTAMP 8
21 CIS_DIVISION CHARACTER(5) 5
22 BUD_PLAN_CD CHARACTER(8) 8
23 BILL_PRT_INTERCEPT CHARACTER(255) 255
24 BILL_LEAD_DAYS INTEGER 4
25 BILL_CYC_CD CHARACTER(4) 4
26 BILL_AFTER_DT TIMESTAMP 8
27 COLL_CL_CD CHARACTER(10) 10
28 ALERT_INFO CHARACTER VARYING(250) 250
29 ACCT_MGMT_GRP_CD CHARACTER(10) 10
30 ACCESS_GRP_CD CHARACTER(12) 12
31 WRITE_OFF_REQUEST_DT TIMESTAMP 8
32 WRITE_OFF_DT TIMESTAMP 8
33 WRITE_OFF_AMT NUMERIC(36,18) 19
34 UNCLR_PAYMNT_AMT NUMERIC(36,18) 19
35 TOTAL_AVL_DISBRS_AMT NUMERIC(38,16) 19
36 STATUS_UPD_DTTM TIMESTAMP 8
37 SOURCE_HOST_ID CHARACTER VARYING(10) 10
38 SECURED_SW CHARACTER(1) 1
39 REPO_CASE_EXISTS_SW CHARACTER(1) 1
40 REPAYMNT_FREQ CHARACTER VARYING(30) 30
41 REDRAW_CNT SMALLINT 2
42 REDRAW_AVL_SW CHARACTER(1) 1
43 PROBABILITY_OF_DEFLT_VAL CHARACTER VARYING(60) 60
44 PPI_INSURED_SW CHARACTER(1) 1
45 OVERLIMIT_AMT NUMERIC(38,16) 19
46 OVERDUE_AMT NUMERIC(38,16) 19
47 OUTSTANDING_AMT NUMERIC(38,16) 19
48 MATURITY_DT TIMESTAMP 8
49 LVR_VAL NUMERIC(5,2) 19
50 LMI_INSURED_SW CHARACTER(1) 1
51 LIABILITY_ID CHARACTER VARYING(40) 40
52 LEGAL_CASE_EXISTS_SW CHARACTER(1) 1
53 LAST_PAYMENT_DT TIMESTAMP 8
54 LAST_PAYMENT_AMT NUMERIC(36,18) 19
55 IN_COLLECTIONS_SW CHARACTER(1) 1
56 HOST_SYS_ACCT_STAT_FLG CHARACTER VARYING(50) 50
57 HOST_PROD_GRP_CD CHARACTER VARYING(20) 20
58 HOST_PROD_CLASS_CD CHARACTER VARYING(10) 10
59 HOST_PRD_CD CHARACTER VARYING(10) 10
60 HOST_ACCNT_NBR CHARACTER VARYING(40) 40
61 GUARANTOR_SW CHARACTER(1) 1
62 FACILITY_ID CHARACTER VARYING(40) 40
63 EMPLOYEE_ACCT_SW CHARACTER(1) 1
64 DISBRS_AMT NUMERIC(38,16) 19
65 DEBT_SOLD_SW CHARACTER(1) 1
66 CHANGE_IN_OVERDUE_AMOUNT NUMERIC(38,16) 19
67 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
68 BRANCH_CD CHARACTER VARYING(20) 20
69 BEHAVIOR_SCORE NUMERIC(5,2) 19
70 ASST_CLASS_CD CHARACTER VARYING(40) 40
71 ACCT_PURPS_CD CHARACTER VARYING(20) 20
72 ACCT_IN_DISPUTE_SW CHARACTER(1) 1
73 STICKY_NOTES CHARACTER VARYING(4000) 4000