CCR_CC_MATTER_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 UPDATETIME TIMESTAMP 8
2 ROOM CHARACTER VARYING(32) 32
3 ASSIGNEDQUEUEID BIGINT 8
4 CREATETIME TIMESTAMP 8
5 PREVIOUSUSERID BIGINT 8
6 DEFENSEAPPTDATE TIMESTAMP 8
7 FIRSTNOTICE CHARACTER VARYING(1) 1
8 BEANVERSION BIGINT 8
9 PREVIOUSGROUPID BIGINT 8
10 DECLARATORYJGMT CHARACTER VARYING(1) 1
11 RETIRED BIGINT 8
12 LOADCOMMANDID BIGINT 8
13 CREATEUSERID BIGINT 8
14 SENTTODEFENSEDATE TIMESTAMP 8
15 ASSIGNEDGROUPID BIGINT 8
16 REOPENEDREASON BIGINT 8
17 PUBLICID CHARACTER VARYING(64) 64
18 CLAIMID BIGINT 8
19 VALIDATIONLEVEL BIGINT 8
20 NAME CHARACTER VARYING(128) 128
21 RISKTYPE BIGINT 8
22 RESOLUTION BIGINT 8
23 ASSIGNMENTSTATUS BIGINT 8
24 CASENUMBER CHARACTER VARYING(128) 128
25 FINALSETTLECOST NUMERIC(18,2) 19
26 ASSIGNEDBYUSERID BIGINT 8
27 FINALLEGALCOST NUMERIC(18,2) 19
28 ASSIGNMENTDATE TIMESTAMP 8
29 STRUCTUREDSETTLE CHARACTER VARYING(1) 1
30 MEDIATIONDATE TIMESTAMP 8
31 PRIMARYCAUSE BIGINT 8
32 ARBITRATION CHARACTER VARYING(1) 1
33 SUITTYPE BIGINT 8
34 TRIALDATE TIMESTAMP 8
35 MOTIONSUMMARYJGMT CHARACTER VARYING(1) 1
36 ASSIGNEDUSERID BIGINT 8
37 CLOSEDATE TIMESTAMP 8
38 FILEDATE TIMESTAMP 8
39 UPDATEUSERID BIGINT 8
40 PREVIOUSQUEUEID BIGINT 8
41 FINALSETTLEDATE TIMESTAMP 8
42 ID BIGINT 8
43 ARBITRATIONDATE TIMESTAMP 8
44 LEGALSPECIALTY BIGINT 8
45 COURTTYPE BIGINT 8
46 MATTERCASENUMBER CHARACTER VARYING(20) 20
47 RESPONSEFILED TIMESTAMP 8
48 ARBITRATIONROOM CHARACTER VARYING(32) 32
49 FILINGDATE TIMESTAMP 8
50 SUBROGATIONSUMMARYID BIGINT 8
51 PUNITIVEDAMAGES CHARACTER VARYING(1) 1
52 COURTDISTRICT BIGINT 8
53 MEDIATIONROOM CHARACTER VARYING(32) 32
54 RESPONSEDUE TIMESTAMP 8
55 MATTERTYPE BIGINT 8
56 METHODSERVED BIGINT 8
57 ADDAMNUMSPECIFIED CHARACTER VARYING(1) 1
58 SUBRORELATED CHARACTER VARYING(1) 1
59 ARCHIVEPARTITION BIGINT 8
60 ADDAMNUMAMOUNT NUMERIC(18,2) 19
61 HEARINGDATE TIMESTAMP 8
62 HEARINGROOM CHARACTER VARYING(32) 32
63 VENUERATING BIGINT 8
64 DOCKETNUMBER CHARACTER VARYING(20) 20
65 PUNITIVEAMOUNT NUMERIC(18,2) 19
66 SERVICEDATE TIMESTAMP 8
67 SC_FILESENTTOLAWFIRM CHARACTER VARYING(1) 1
68 SC_MATTERTYPELIST BIGINT 8
69 SC_MATTERCOMPLEXITY BIGINT 8
70 SC_EMPLOYERPREFERRED CHARACTER VARYING(1) 1
71 SC_SUPPORTED CHARACTER VARYING(1) 1
72 SC_DEFENSESOLICITORFKID BIGINT 8
73 SC_COMMENTS CHARACTER VARYING(600) 600
74 SC_MATTERPERFORMANCE BIGINT 8
75 SC_PLAINTIFFSOLICITORFKID BIGINT 8
76 SC_DRDS61MATTERS CHARACTER VARYING(1) 1
77 SC_GREFERRALFORLEGALADV CHARACTER VARYING(600) 600
78 SC_LEGALSERVICEPROVIDER BIGINT 8
79 SC_DATEREFERRED TIMESTAMP 8
80 SC_HEARINGADVICEDATE TIMESTAMP 8
81 SC_ADVICERECEIVEDDATE TIMESTAMP 8
82 SC_NUMBEROFTRIALDAYS BIGINT 8
83 SC_DATECOMPLETED TIMESTAMP 8
84 SC_DOCUMENTSRECEIVEDDATE TIMESTAMP 8
85 SC_EVALUATIONRELATED CHARACTER VARYING(1) 1
86 SC_MATTERACTIONTYPE BIGINT 8
87 SC_FIRSTADVICEDUE TIMESTAMP 8
88 SC_HICNOTICESETTLEDATE TIMESTAMP 8
89 SC_LEGALCASESTATUS BIGINT 8
90 SC_INTERNAL CHARACTER VARYING(1) 1
91 SC_SETTLEMENTDATE TIMESTAMP 8
92 SC_SETTLEMENTPAIDDATE TIMESTAMP 8
93 SC_SETTLEMENTPAID CHARACTER VARYING(1) 1
94 SC_MATTERSTATUSDATE TIMESTAMP 8
95 SC_CENTRELINKCLEARANCEDATE TIMESTAMP 8
96 SC_ACTIONDATE TIMESTAMP 8
97 SC_DORPCHANGEREASON BIGINT 8
98 SC_MATTERSTATUS BIGINT 8
99 SC_RELEVANTDATE TIMESTAMP 8
100 SC_RFTDSTATUS BIGINT 8
101 SC_IMPAIRMENTRESULT BIGINT 8
102 SC_NEGOTIATIONMODE BIGINT 8
103 SC_ASSESSMENTTYPE BIGINT 8
104 SC_REQUESTDATE TIMESTAMP 8
105 SC_APPDESCRIPTION CHARACTER VARYING(600) 600
106 SC_PROCSERVEDDATE TIMESTAMP 8
107 SC_COMPLYWITHCTP NUMERIC(18,2) 19
108 SC_RFTDSERVEDDATE TIMESTAMP 8
109 SC_PROCISSUEDDATE TIMESTAMP 8
110 SC_REVIEWER CHARACTER VARYING(600) 600
111 SC_COURTREFNUMBER CHARACTER VARYING(600) 600
112 SC_JUDGEMENTRESULT BIGINT 8
113 SC_REQUESTREVIEWDATE TIMESTAMP 8
114 SC_MATTERPROCDATE TIMESTAMP 8
115 SC_SETTLECONFDATE TIMESTAMP 8
116 SC_COMPLYTOCTP BIGINT 8
117 SC_IMPAIRMENTTHRESHOLD BIGINT 8
118 SC_JUDGEMENTAMNT NUMERIC(18,2) 19
119 SC_APPEALDATE TIMESTAMP 8
120 SC_ASSESSMENTOUTCOME BIGINT 8
121 SC_MATTERSUBTYPE BIGINT 8
122 SC_MATTEROUTCOME BIGINT 8
123 SC_NOTPROCREASON CHARACTER VARYING(600) 600
124 SC_APPEALISSUE CHARACTER VARYING(600) 600
125 SC_LIMEXTTYPE BIGINT 8
126 SC_SETTLEMENTCOST BIGINT 8
127 SC_APPEALRESULT CHARACTER VARYING(600) 600
128 SC_REASONING CHARACTER VARYING(600) 600
129 SC_COSTAWARDBASIS BIGINT 8
130 SC_COSTAWARD BIGINT 8
131 SC_PARTYAPPLICATION BIGINT 8
132 SC_MEDIATION CHARACTER VARYING(1) 1
133 SC_VENUE BIGINT 8
134 SC_LIMPERIODEXPDATE TIMESTAMP 8
135 SC_IMPAIRMENTTYPE BIGINT 8
136 SC_REVLIMDATE TIMESTAMP 8
137 SC_SERVEDDATE TIMESTAMP 8
138 SC_RFTDSIGNEDDATE TIMESTAMP 8
139 SC_COURTDETERMINATION BIGINT 8
140 SC_AGENCYADVISEDSETTLEMENTDATE TIMESTAMP 8
141 SC_LEGALACTIONCOMMENCEDDATE TIMESTAMP 8
142 SC_ISSUEDDATE TIMESTAMP 8
143 SC_RELATEDEVALUATIONPARTY BIGINT 8
144 SC_RELATEDSUBROPARTY BIGINT 8
145 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
146 RECORD_TYPE CHARACTER VARYING(16) 16
147 COMMIT_TIMESTAMP TIMESTAMP 8
148 EXTRACT_TIMESTAMP TIMESTAMP 8
149 ADMIN CHARACTER VARYING(1) 1
150 SC_LOCALDISTRICTCOURT BIGINT 8
151 HEARINGTYPE_EXT BIGINT 8
152 RAISEDBY_EXT BIGINT 8