INT_CI_MATTER

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MATTER_CLAIM_ID BIGINT 8
2 MATTER_UPDATE_DATE TIMESTAMP 8
3 MATTER_UPDATE_DATE_ID INTEGER 4
4 MATTER_CREATE_DATE TIMESTAMP 8
5 MATTER_CREATE_DATE_ID INTEGER 4
6 MATTER_CREATE_USER_ID BIGINT 8
7 MATTER_NAME CHARACTER VARYING(128) 128
8 MATTER_REOPENED_REASON_ID BIGINT 8
9 MATTER_ASSIGNMENT_DATE TIMESTAMP 8
10 MATTER_ASSIGNMENT_DATE_ID INTEGER 4
11 MATTER_PRIMARY_CAUSE_ID BIGINT 8
12 MATTER_CLOSE_DATE TIMESTAMP 8
13 MATTER_CLOSE_DATE_ID INTEGER 4
14 MATTER_FINAL_SETTLE_DATE TIMESTAMP 8
15 MATTER_FINAL_SETTLE_DATE_ID INTEGER 4
16 MATTER_STATUS CHARACTER VARYING(6) 6
17 MATTER_ID BIGINT 8
18 MATTER_ASSIGNED_USER_ID BIGINT 8
19 MATTER_ASSIGNED_GROUP_ID BIGINT 8
20 MATTER_RECOVERY_FLAG_ID INTEGER 4
21 MATTER_LEGAL_SPECIALTY_ID BIGINT 8
22 MATTER_DURATION INTEGER 4
23 MATTER_DURATION_BAND_ID INTEGER 4
24 IMATTER_REFERRED_FLAG_ID INTEGER 4