PRT_RIPOINT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 CLASS CHARACTER VARYING(3) 3
3 SUBCLASS CHARACTER VARYING(3) 3
4 ACTIVFROM INTEGER 4
5 ACTIVTO INTEGER 4
6 CLASOCCNO INTEGER 4
7 RETLIMNO INTEGER 4
8 EOLNO INTEGER 4
9 QSNO INTEGER 4
10 QSNO2 INTEGER 4
11 CATNO INTEGER 4
12 SPECNO INTEGER 4
13 PREMONLY CHARACTER VARYING(1) 1
14 QSBYPOST CHARACTER VARYING(1) 1
15 OCCLIMNO INTEGER 4
16 CONSTRUCT CHARACTER VARYING(1) 1
17 DISTRICT CHARACTER VARYING(1) 1
18 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 RECORD_TYPE CHARACTER VARYING(16) 16
20 COMMIT_TIMESTAMP TIMESTAMP 8
21 EXTRACT_TIMESTAMP TIMESTAMP 8
22 CDC_ID BIGINT 8
23 COMPANY_CDC SMALLINT 2
24 ACTIVTO_CDC DATE 4
25 DW_TIMESTAMP TIMESTAMP 8