PRT_CLMSTACM

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 CLAIMNO NUMERIC(11,0) 19
3 CMCLTPFCTR CHARACTER VARYING(2) 2
4 CMCLTCTCTR CHARACTER VARYING(4) 4
5 CMCLTREFNO CHARACTER VARYING(15) 15
6 CMTYPDMG CHARACTER VARYING(3) 3
7 CMACCZNE CHARACTER VARYING(1) 1
8 CMFAULT CHARACTER VARYING(2) 2
9 CMREG CHARACTER VARYING(7) 7
10 CMOWNGRP CHARACTER VARYING(1) 1
11 CMMAKE CHARACTER VARYING(4) 4
12 CMMODEL CHARACTER VARYING(6) 6
13 CMMANUFYR SMALLINT 2
14 CMFEEHNDC INTEGER 4
15 CMFEEASSC INTEGER 4
16 CMFEERCYC INTEGER 4
17 CMNAMEREF INTEGER 4
18 CMNAMESEQ INTEGER 4
19 CMLICTYP CHARACTER VARYING(1) 1
20 CMLICSTATE CHARACTER VARYING(1) 1
21 CMLICDTE SMALLINT 2
22 MFCATGORY CHARACTER VARYING(2) 2
23 MVAGEEXC NUMERIC(5,0) 19
24 MVDRVABLE CHARACTER VARYING(1) 1
25 MVTRAFLTS CHARACTER VARYING(1) 1
26 MVROADCON CHARACTER VARYING(1) 1
27 MVVISIBIL CHARACTER VARYING(1) 1
28 MVIVSPEED SMALLINT 2
29 MVTPSPEED SMALLINT 2
30 MVTPCLAIM CHARACTER VARYING(1) 1
31 MVFAULTAD CHARACTER VARYING(1) 1
32 MVCHARGED CHARACTER VARYING(1) 1
33 MVWITNESS CHARACTER VARYING(1) 1
34 MVVEHTYPE CHARACTER VARYING(1) 1
35 MVRELATION CHARACTER VARYING(1) 1
36 CMNOCKFOR CHARACTER VARYING(2) 2
37 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 RECORD_TYPE CHARACTER VARYING(16) 16
39 COMMIT_TIMESTAMP TIMESTAMP 8
40 EXTRACT_TIMESTAMP TIMESTAMP 8
41 CDC_ID BIGINT 8
42 COMPANY_CDC SMALLINT 2
43 DW_TIMESTAMP TIMESTAMP 8