FCT_OBP_COLLECTION_PERSON

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_COLLECTION_PERSON_V

Columns
# Name Data Type Length
1 PERSON_ID CHARACTER(10) 10
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 SOURCE_SYSTEM_CODE CHARACTER VARYING(5) 5
4 COLLECTION_ACCOUNT_ID CHARACTER(10) 10
5 CUSTOMER_NUMBER CHARACTER VARYING(40) 40
6 LANGUAGE_CODE CHARACTER(3) 3
7 PERSON_OR_BUSINESS CHARACTER(2) 2
8 LS_SL_FLG CHARACTER(2) 2
9 LS_SL_DESCR CHARACTER VARYING(254) 254
10 EMAIL_ID CHARACTER VARYING(70) 70
11 ADDRESS_LINE_1 CHARACTER VARYING(64) 64
12 ADDRESS_LINE_2 CHARACTER VARYING(64) 64
13 ADDRESS_LINE_3 CHARACTER VARYING(64) 64
14 ADDRESS_LINE_4 CHARACTER VARYING(64) 64
15 CITY CHARACTER VARYING(30) 30
16 PHONE_NUMBER_1 CHARACTER(6) 6
17 PHONE_NUMBER_2 CHARACTER(4) 4
18 COUNTY CHARACTER VARYING(30) 30
19 POSTAL CHARACTER(12) 12
20 HOUSE_TYPE CHARACTER(2) 2
21 GEOGRAPHY_CODE CHARACTER(11) 11
22 IN_CITY_LIMIT CHARACTER(1) 1
23 STATE CHARACTER(6) 6
24 COUNTRY CHARACTER(3) 3
25 RECEIVE_MARKETING_INFORMATION CHARACTER(4) 4
26 BIRTH_DATE TIMESTAMP 8
27 MARITAL_STATUS CHARACTER VARYING(20) 20
28 SETUP_DATE TIMESTAMP 8
29 ABILITY_TO_PAY CHARACTER(4) 4
30 STATUS_UPDATE_DTTM TIMESTAMP 8
31 GENDER CHARACTER(4) 4
32 THIRD_PARTY CHARACTER(1) 1
33 INTERNET_BANK CHARACTER(1) 1
34 PHONE_BANK CHARACTER(1) 1
35 DETERMINANT_VALUE CHARACTER VARYING(60) 60
36 BEHAVIOR_SCORE NUMERIC(5,2) 19
37 CUSTOMER_RISK_SCORE NUMERIC(5,2) 19
38 PROBABILITY_OF_DEFLT_VALUE CHARACTER VARYING(60) 60
39 BANKRUPT CHARACTER(1) 1
40 HARDSHIP CHARACTER(1) 1
41 IN_COLLECTIONS CHARACTER(1) 1
42 IMPRISONED CHARACTER(1) 1
43 DECEASED CHARACTER(1) 1
44 ABSCONDING CHARACTER(1) 1
45 ENTERPRISE_CUSTOMER_NUMBER CHARACTER VARYING(60) 60
46 SURVIVOR_PARTY_ID CHARACTER VARYING(40) 40
47 ACCOUNT_RELATION_TYPE_CD CHARACTER(8) 8
48 BILL_ADDRESS_SOURCE CHARACTER(4) 4
49 MAIN_CUSTOMER CHARACTER(1) 1
50 FINAL_RESPONSE CHARACTER(1) 1
51 RECEIVE_COPY CHARACTER(1) 1
52 BILL_RATE_TYPE_CD CHARACTER(8) 8
53 BILL_FORMAT CHARACTER(2) 2
54 NUMBER_BILL_COPIES BYTEINT 1
55 CUST_PO_ID CHARACTER VARYING(20) 20
56 NOTIFY CHARACTER(1) 1
57 NAME_PFEFIX_SUFFIX CHARACTER VARYING(50) 50
58 PFEFIX_SUFFIX CHARACTER(2) 2
59 WEB_ACCESS CHARACTER(4) 4
60 MOBILE_BANK CHARACTER(1) 1
61 DEBITCARD CHARACTER(1) 1
62 ATM CHARACTER(1) 1
63 CORRESPONDENCE_NOMINATION CHARACTER(1) 1
64 FULL_NAME CHARACTER VARYING(250) 250
65 BUSINESS_END_OF_DAY_DATE DATE 4
66 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
67 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
68 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
69 IS_CURRENT CHARACTER VARYING(1) 1