PRT_GOVTCHGS

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 CLASS CHARACTER(3) 3
3 SUBCLASS CHARACTER(3) 3
4 RISKSTATE CHARACTER(2) 2
5 CHRGCODE CHARACTER(2) 2
6 FIREBRIG CHARACTER(1) 1
7 ACTIVFROM INTEGER 4
8 ACTIVTO INTEGER 4
9 GCRATE NUMERIC(5,2) 19
10 FSLGROUP CHARACTER(4) 4
11 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 RECORD_TYPE CHARACTER VARYING(16) 16
13 COMMIT_TIMESTAMP TIMESTAMP 8
14 EXTRACT_TIMESTAMP TIMESTAMP 8
15 CDC_ID BIGINT 8
16 COMPANY_CDC SMALLINT 2
17 ACTIVTO_CDC DATE 4
18 DW_TIMESTAMP TIMESTAMP 8