INT_PTP_CONTACT
Description
Source Object (CTAS)
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 |