CCR_CC_DOCUMENT_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ADMIN CHARACTER VARYING(1) 1
2 ANNOTATED_EXT CHARACTER VARYING(1) 1
3 ARCHIVEPARTITION BIGINT 8
4 AUTHOR CHARACTER VARYING(60) 60
5 AUTHORDENORM CHARACTER VARYING(60) 60
6 BEANVERSION BIGINT 8
7 CLAIMCONTACTID BIGINT 8
8 CLAIMID BIGINT 8
9 COMMIT_TIMESTAMP TIMESTAMP 8
10 CREATETIME TIMESTAMP 8
11 CREATEUSERID BIGINT 8
12 DATECREATED TIMESTAMP 8
13 DATEMODIFIED TIMESTAMP 8
14 DESCRIPTION CHARACTER VARYING(255) 255
15 DMS CHARACTER VARYING(1) 1
16 DOCUID CHARACTER VARYING(255) 255
17 DOCUMENTIDENTIFIER CHARACTER VARYING(60) 60
18 DOCUMENTIDENTIFIERDENORM CHARACTER VARYING(60) 60
19 EXPOSETOCUSTOMER_EXT CHARACTER VARYING(1) 1
20 EXPOSUREID BIGINT 8
21 EXTRACT_TIMESTAMP TIMESTAMP 8
22 ID BIGINT 8
23 INBOUND CHARACTER VARYING(1) 1
24 LANGUAGE BIGINT 8
25 LOADCOMMANDID BIGINT 8
26 MATTERID BIGINT 8
27 MIMETYPE CHARACTER VARYING(80) 80
28 NAME CHARACTER VARYING(80) 80
29 NAMEDENORM CHARACTER VARYING(80) 80
30 OBSOLETE CHARACTER VARYING(1) 1
31 PENDINGDOCUID CHARACTER VARYING(255) 255
32 PUBLICID CHARACTER VARYING(64) 64
33 RECIPIENT CHARACTER VARYING(200) 200
34 RECORD_TYPE CHARACTER VARYING(16) 16
35 RETIRED BIGINT 8
36 SC_ACTIVITYDUEOFFSET BIGINT 8
37 SC_ACTIVITYESCALATIONOFFSET BIGINT 8
38 SC_ACTIVITYSTATUS BIGINT 8
39 SC_ARCHIVEONLY BIGINT 8
40 SC_BATCHID CHARACTER VARYING(255) 255
41 SC_BOXNUMBER CHARACTER VARYING(30) 30
42 SC_CERTIFIED BIGINT 8
43 SC_CERTIFIEDDATE TIMESTAMP 8
44 SC_CREATEACTIVITY CHARACTER VARYING(1) 1
45 SC_DISCLOSUREDATE TIMESTAMP 8
46 SC_DISCLOSURESTATUS BIGINT 8
47 SC_DOCACTIVITYTYPE CHARACTER VARYING(30) 30
48 SC_DOCPROVIDEDBY BIGINT 8
49 SC_DOCSOURCE BIGINT 8
50 SC_DOCSUBTYPE BIGINT 8
51 SC_DOCUMENTDATE TIMESTAMP 8
52 SC_DOCUMENTPAGENUMBER BIGINT 8
53 SC_DOCUMENTSIZE BIGINT 8
54 SC_INJURYCODED BIGINT 8
55 SC_INJURYCODEDDATE TIMESTAMP 8
56 SC_ISVERSION CHARACTER VARYING(1) 1
57 SC_MAILPACKTASKREFERENCE CHARACTER VARYING(50) 50
58 SC_MASTERID CHARACTER VARYING(20) 20
59 SC_RESCANRSN BIGINT 8
60 SC_RESPONSEREQ CHARACTER VARYING(1) 1
61 SC_SOURCESYSTEMRECEIVEDDATE TIMESTAMP 8
62 SC_TRANSFERCLAIMNUMBER CHARACTER VARYING(40) 40
63 SC_TRANSMISSIONMETHOD BIGINT 8
64 SC_VERSIONNUMBER CHARACTER VARYING(10) 10
65 SECTION BIGINT 8
66 SECURITYTYPE BIGINT 8
67 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
68 STATUS BIGINT 8
69 TYPE BIGINT 8
70 UPDATETIME TIMESTAMP 8
71 UPDATEUSERID BIGINT 8