FCT_OBP_COLLECTION_CASE

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_COLLECTION_CASE_V

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
2 SOURCE_SYSTEM_CODE CHARACTER VARYING(5) 5
3 COLLECTION_ACCOUNT_ID CHARACTER(10) 10
4 COLLECTION_CASE_ID CHARACTER(10) 10
5 PERSON_ID CHARACTER(10) 10
6 COLLECTION_CASE_TYPE CHARACTER(12) 12
7 COLLECTION_CASE_TYPE_DESCRIPTION CHARACTER VARYING(60) 60
8 COLLECTION_CASE_STATUS CHARACTER(12) 12
9 COLLECTION_CASE_STATUS_DESCRIPTION CHARACTER VARYING(60) 60
10 COLLECTION_CASE_CREATION_TIMESTAMP TIMESTAMP 8
11 COLLECTION_CASE_APPROVER_ID CHARACTER VARYING(255) 255
12 COLLECTION_CASE_APPROVER CHARACTER VARYING(201) 201
13 COLLECTION_CASE_APPROVE_TIMESTAMP TIMESTAMP 8
14 COLLECTION_CASE_CREATED_BY CHARACTER VARYING(255) 255
15 COLLECTION_CASE_CREATED_TIMESTAMP TIMESTAMP 8
16 NEXT_COLLECTION_ACTION_TYPE_CODE CHARACTER(12) 12
17 NEXT_COLLECTION_ACTION_TIMESTAMP TIMESTAMP 8
18 COLLECTION_HOLD_REASON_CODE CHARACTER(4) 4
19 COLLECTION_HOLD_TILL_DATE TIMESTAMP 8
20 COLLECTION_HOLD_BY_CASE CHARACTER(10) 10
21 LMI_INSURED_SW CHARACTER(1) 1
22 IS_DELETED CHARACTER VARYING(16) 16
23 COLLECTION_CUSTOMER_NUMBER CHARACTER VARYING(40) 40
24 CONTACT_PERSON_ID CHARACTER(10) 10
25 COLLECTION_CONTACT_METHOD_FLAG CHARACTER(4) 4
26 COLLECTION_CASE_COND_FLAG CHARACTER(4) 4
27 COLLECTION_CONTACT_INSTRUCTIONS CHARACTER VARYING(2000) 2000
28 COLLECTION_PHONE_TYPE_CODE CHARACTER(12) 12
29 COLLECTION_PHONE CHARACTER VARYING(24) 24
30 COLLECTION_EXTENSION CHARACTER(6) 6
31 COLLECTIONS_PARTY_UID CHARACTER(10) 10
32 COLLECTION_PARTY_TYPE CHARACTER(4) 4
33 COLLECTIONS_PARTY_ID CHARACTER(10) 10
34 COLLECTIONS_CASE_CATEGORY CHARACTER(4) 4
35 COLLECTIONS_REALLOCATE_YN CHARACTER(1) 1
36 COLLECTIONS_CREATE_MODE CHARACTER(1) 1
37 IS_CURRENT CHARACTER VARYING(1) 1
38 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
39 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
40 BUSINESS_END_OF_DAY_DATE DATE 4
41 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1