FCT_OBP_COLLECTION_PIT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_COLLECTION_PIT_V

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 SOURCE_SYSTEM_CODE CHARACTER VARYING(5) 5
4 COLLECTIONS_FACILITY_ID CHARACTER VARYING(40) 40
5 COLLECTIONS_LIABILITY_ID CHARACTER VARYING(40) 40
6 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
7 COLLECTION_ACCOUNT_ID CHARACTER(10) 10
8 COLLECTION_SERVICE_AGREEMENT_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 CASE_ID CHARACTER(10) 10
51 COLLECTION_TYPE_CD CHARACTER(12) 12
52 INTEREST_RATE NUMERIC(36,18) 19
53 INTEREST_TYPE CHARACTER VARYING(14) 14
54 INSTALLMENT_IN_ARREARS SMALLINT 2
55 MINIMUM_DUE_AMOUNT NUMERIC(38,16) 19
56 WILLINGNES_TO_PAY CHARACTER(4) 4
57 REASON_FOR_DELINQUENCY CHARACTER VARYING(60) 60
58 START_DT TIMESTAMP 8
59 END_DT TIMESTAMP 8
60 HOST_REASON_FOR_DELINQUENCY CHARACTER VARYING(40) 40
61 DEMAND_NOTICE_DATE TIMESTAMP 8
62 DEFAULT_NOTICE_DATE TIMESTAMP 8
63 IS_FORCED_ACCOUNT CHARACTER(1) 1
64 FORCED_ACCOUNT_REASON CHARACTER(4) 4
65 DAYS_PAST_DUE SMALLINT 2
66 DELINQUENCY_START_DATE TIMESTAMP 8
67 DELINQUENCY_END_DATE TIMESTAMP 8
68 BILL_CYCLE_CODE CHARACTER(4) 4
69 CURRENCY_CODE CHARACTER(3) 3
70 ACCOUNT_MANAGEMENT_GROUP_CODE CHARACTER(10) 10
71 ALERT_INFORMATION CHARACTER VARYING(250) 250
72 BILL_AFTER_DATE TIMESTAMP 8
73 PROTECT_CYCLE CHARACTER(1) 1
74 CIS_DIVISION CHARACTER(5) 5
75 COLLECTION_MAILING_PREM_ID CHARACTER(10) 10
76 COLLECTION_PROTECT_PREM CHARACTER(1) 1
77 COLLECTION_CR_REVIEW_DATE TIMESTAMP 8
78 COLLECTION_POSTPONE_CR_REVIEW_DATE TIMESTAMP 8
79 COLLECTION_INT_CR_REVIEW CHARACTER(1) 1
80 COLLECTIONS_CUSTOMER_CL_CD CHARACTER(8) 8
81 COLLECTION_BILL_PRINT_INTERCEPT CHARACTER(255) 255
82 COLLECTIONS_NO_DEPOSIT_REVIEW CHARACTER(1) 1
83 BUD_PLAN_CD CHARACTER(8) 8
84 PROTECT_DIV CHARACTER(1) 1
85 COLLECTION_ACCESS_GRP_CD CHARACTER(12) 12
86 EC_EXPIRY_SCHEDULE_CD CHARACTER(12) 12
87 BILL_LEAD_DAYS INTEGER 4
88 CHANGE_IN_OVERDUE_AMOUNT NUMERIC(38,16) 19
89 STICKY_NOTES CHARACTER VARYING(4000) 4000
90 BUSINESS_END_OF_DAY_DATE TIMESTAMP 8
91 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
92 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
93 IS_CURRENT CHARACTER VARYING(1) 1