FCT_BNK_COLLECTION_CCR_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

Collections status account and customer details for OBP, CLMS, and Hogan accounts

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
2 SOURCE_SYSTEM_CODE CHARACTER VARYING(5) 5
3 COLLECTIONS_FACILITY_ID CHARACTER VARYING(40) 40
4 COLLECTIONS_LIABILITY_ID CHARACTER VARYING(40) 40
5 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
6 COLLECTION_ACCOUNT_ID CHARACTER(10) 10
7 COLLECTION_SERVICE_AGREEMENT_ID CHARACTER(10) 10
8 CASE_ID CHARACTER(10) 10
9 PRODUCT_CODE CHARACTER VARYING(10) 10
10 PRODUCT_GROUP_CODE CHARACTER VARYING(20) 20
11 OFFER_ID CHARACTER VARYING(30) 30
12 OFFER_NAME CHARACTER VARYING(60) 60
13 PRODUCT_CLASS_CODE CHARACTER VARYING(10) 10
14 BRANCH_CODE CHARACTER VARYING(20) 20
15 ACCOUNT_PURPOSE_CD CHARACTER VARYING(20) 20
16 IN_COLLECTIONS CHARACTER(1) 1
17 COLLECTION_DATE_ENTERED TIMESTAMP 8
18 COLLECTION_CLASS_TYPE CHARACTER(10) 10
19 COLLECTION_STATUS_DATE TIMESTAMP 8
20 COLLECTION_ASSISTANCE_CLASS_CODE CHARACTER VARYING(40) 40
21 LEGAL_CASE_EXISTS CHARACTER(1) 1
22 REPO_CASE_EXISTS CHARACTER(1) 1
23 DEBT_SOLD CHARACTER(1) 1
24 ACCOUNT_IN_DISPUTE CHARACTER(1) 1
25 WRITE_OFF_REQUEST_DATE TIMESTAMP 8
26 WRITE_OFF_DATE TIMESTAMP 8
27 WRITE_OFF_AMOUNT NUMERIC(36,18) 19
28 UNCLEARED_PAYMENT_AMOUNT NUMERIC(36,18) 19
29 BEHAVIOR_SCORE NUMERIC(5,2) 19
30 REPAYMENT_FREQUENCY CHARACTER VARYING(30) 30
31 REDRAW_AVAILABLE CHARACTER(1) 1
32 REDRAW_COUNT SMALLINT 2
33 LOAN_MATURITY_DATE TIMESTAMP 8
34 EMPLOYEE_ACCOUNT CHARACTER(1) 1
35 GUARANTOR_EXISTS CHARACTER(1) 1
36 LOAN_SECURITY_EXISTS CHARACTER(1) 1
37 PPI_INSURANCE_EXISTS CHARACTER(1) 1
38 LMI_INSURANCE_EXISTS CHARACTER(1) 1
39 PROBABILITY_OF_DEFAULT CHARACTER VARYING(60) 60
40 LAST_PAYMENT_DATE TIMESTAMP 8
41 LAST_PAYMENT_AMOUNT NUMERIC(36,18) 19
42 OUTSTANDING_AMOUNT NUMERIC(38,16) 19
43 OVERDUE_AMOUNT NUMERIC(38,16) 19
44 OVERLIMIT_AMOUNT NUMERIC(38,16) 19
45 DISBURSEMENT_AMOUNT NUMERIC(38,16) 19
46 TOTAL_AVAILABLE_DIBURSEMENT_AMOUNT NUMERIC(38,16) 19
47 LOAN_VALUE_RATIO NUMERIC(5,2) 19
48 IS_DELINQUENT CHARACTER(1) 1
49 PARTY_UID CHARACTER(10) 10
50 COLLECTION_TYPE_CD CHARACTER(12) 12
51 INTEREST_RATE NUMERIC(36,18) 19
52 INTEREST_TYPE CHARACTER VARYING(14) 14
53 INSTALLMENT_IN_ARREARS SMALLINT 2
54 MINIMUM_DUE_AMOUNT NUMERIC(38,16) 19
55 WILLINGNES_TO_PAY CHARACTER(4) 4
56 REASON_FOR_DELINQUENCY CHARACTER VARYING(60) 60
57 START_DT TIMESTAMP 8
58 END_DT TIMESTAMP 8
59 HOST_REASON_FOR_DELINQUENCY CHARACTER VARYING(40) 40
60 DEMAND_NOTICE_DATE TIMESTAMP 8
61 DEFAULT_NOTICE_DATE TIMESTAMP 8
62 IS_FORCED_ACCOUNT CHARACTER(1) 1
63 FORCED_ACCOUNT_REASON CHARACTER(4) 4
64 DAYS_PAST_DUE SMALLINT 2
65 DELINQUENCY_START_DATE TIMESTAMP 8
66 DELINQUENCY_END_DATE TIMESTAMP 8
67 BILL_CYCLE_CODE CHARACTER(4) 4
68 CURRENCY_CODE CHARACTER(3) 3
69 ACCOUNT_MANAGEMENT_GROUP_CODE CHARACTER(10) 10
70 ALERT_INFORMATION CHARACTER VARYING(250) 250
71 BILL_AFTER_DATE TIMESTAMP 8
72 PROTECT_CYCLE CHARACTER(1) 1
73 CIS_DIVISION CHARACTER(5) 5
74 COLLECTION_MAILING_PREM_ID CHARACTER(10) 10
75 COLLECTION_PROTECT_PREM CHARACTER(1) 1
76 COLLECTION_CR_REVIEW_DATE TIMESTAMP 8
77 COLLECTION_POSTPONE_CR_REVIEW_DATE TIMESTAMP 8
78 COLLECTION_INT_CR_REVIEW CHARACTER(1) 1
79 COLLECTIONS_CUSTOMER_CL_CD CHARACTER(8) 8
80 COLLECTION_BILL_PRINT_INTERCEPT CHARACTER(255) 255
81 COLLECTIONS_NO_DEPOSIT_REVIEW CHARACTER(1) 1
82 BUD_PLAN_CD CHARACTER(8) 8
83 PROTECT_DIV CHARACTER(1) 1
84 COLLECTION_ACCESS_GRP_CD CHARACTER(12) 12
85 EC_EXPIRY_SCHEDULE_CD CHARACTER(12) 12
86 BILL_LEAD_DAYS INTEGER 4
87 CHANGE_IN_OVERDUE_AMOUNT NUMERIC(38,16) 19
88 STICKY_NOTES CHARACTER VARYING(4000) 4000
89 BUSINESS_END_OF_DAY_DATE TIMESTAMP 8
90 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
91 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
92 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
93 IS_CURRENT CHARACTER VARYING(1) 1
94 IS_DELETED CHARACTER VARYING(16) 16