INT_PTP_CONTACT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_PTP_CONTACT_V

Columns
# Name Data Type Length
1 ACCT_ID CHARACTER(10) 10
2 CC_ID CHARACTER(10) 10
3 CASE_ID CHARACTER(10) 10
4 CONTACT_METH_FLG CHARACTER(4) 4
5 CC_CRE_DTTM TIMESTAMP 8
6 CC_CRE_DT DATE 4
7 CHAR_VAL CHARACTER VARYING(16) 16
8 ACTION_ID CHARACTER(14) 14
9 RESULT_TYPE_CD CHARACTER(12) 12
10 ACT_CRE_DTTM TIMESTAMP 8
11 ACT_CRE_DT DATE 4
12 PTP_ID CHARACTER(10) 10
13 PTP_GEN_DTTM TIMESTAMP 8
14 PTP_GEN_DT DATE 4
15 PP_STAT_FLG CHARACTER(2) 2
16 PP_STATUS_UPD_DTTM TIMESTAMP 8
17 PTP_START_DT TIMESTAMP 8
18 PTP_AMT NUMERIC(38,18) 19
19 PTP_SCHED_COUNT BIGINT 8
20 DAYS_PAST_DUE SMALLINT 2
21 SA_CRE_DT TIMESTAMP 8
22 IS_DELINQUENT_SW CHARACTER(1) 1
23 LAST_DPD_UPDATE_DT TIMESTAMP 8
24 DELINQ_START_DT TIMESTAMP 8
25 MONTH_END_DT TIMESTAMP 8