INT_CI_EXCESS_26_02_2021

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EXCESS_TYPE_ID BIGINT 8
2 UPDATE_TIME TIMESTAMP 8
3 UPDATE_TIME_LBL CHARACTER VARYING(30) 30
4 UPDATE_DATE_ID INTEGER 4
5 CREATE_DATE TIMESTAMP 8
6 CREATE_DATE_LBL CHARACTER VARYING(30) 30
7 EXPOSURE_ID BIGINT 8
8 CREATE_DATE_ID INTEGER 4
9 BEAN_VERSION BIGINT 8
10 CLAIM_AUTO BIGINT 8
11 RETIRED BIGINT 8
12 LOAD_COMMAND_ID BIGINT 8
13 ARCHIVE_PARTITION BIGINT 8
14 EXCESS_CREATE_USER_ID BIGINT 8
15 EXCESS_AMOUNT NUMERIC(18,2) 19
16 PUBLIC_ID CHARACTER VARYING(20) 20
17 EXCESS_UPDATE_USER_ID BIGINT 8
18 EXCESS_ID BIGINT 8
19 EXCESS_APPLIES_ID BIGINT 8
20 EXCESS_DESCRIPTION CHARACTER VARYING(255) 255
21 EXCESS_SOURCE_ID BIGINT 8
22 EXCESS_REASON CHARACTER VARYING(256) 256
23 CLAIM_HOME BIGINT 8
24 EXGRATIA_REASON_ID BIGINT 8
25 EXGRATIA_OTHER_REASON CHARACTER VARYING(255) 255
26 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 RECORD_TYPE CHARACTER VARYING(16) 16
28 COMMIT_TIMESTAMP_TIME TIMESTAMP 8
29 COMMIT_TIMESTAMP_TIME_LBL CHARACTER VARYING(30) 30
30 COMMIT_TIMESTAMP_DATE_ID INTEGER 4
31 EXTRACT_TIMESTAMP_TIME TIMESTAMP 8
32 EXTRACT_TIMESTAMP_TIME_LBL CHARACTER VARYING(30) 30
33 EXTRACT_TIMESTAMP_DATE_ID INTEGER 4