CCR_CC_EMPLOYMENTDATA_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CREATETIME TIMESTAMP 8
2 CLASSCODEID BIGINT 8
3 BEANVERSION BIGINT 8
4 LASTYEARINCOME NUMERIC(18,2) 19
5 LOADCOMMANDID BIGINT 8
6 RETIRED BIGINT 8
7 CREATEUSERID BIGINT 8
8 DAYSWORKEDWEEK CHARACTER VARYING(255) 255
9 SSBENEFITSAMNT NUMERIC(18,2) 19
10 DEPARTMENTCODE CHARACTER VARYING(60) 60
11 HIRESTATE BIGINT 8
12 PUBLICID CHARACTER VARYING(64) 64
13 WAGEAMOUNT NUMERIC(18,2) 19
14 HIREDATE TIMESTAMP 8
15 SCNDINJRYFNDDATE TIMESTAMP 8
16 NUMHOURSWORKED NUMERIC(3,1) 19
17 EMPLOYMENTSTATUS BIGINT 8
18 LASTWORKEDDATE TIMESTAMP 8
19 SSBENEFITS CHARACTER VARYING(1) 1
20 NUMDAYSWORKED NUMERIC(2,1) 19
21 PAYPERIOD BIGINT 8
22 SCNDINJRYFNDAMNT NUMERIC(18,2) 19
23 OCCUPATION CHARACTER VARYING(255) 255
24 WAGEPAYMENTCONT CHARACTER VARYING(1) 1
25 INJURYSTARTTIME TIMESTAMP 8
26 PAIDFULL CHARACTER VARYING(1) 1
27 OVERTIMERATE NUMERIC(18,2) 19
28 UPDATEUSERID BIGINT 8
29 SCNDINJRYFND CHARACTER VARYING(1) 1
30 ID BIGINT 8
31 ARCHIVEPARTITION BIGINT 8
32 SC_EMPLOYERNOTIFIED CHARACTER VARYING(1) 1
33 SC_RESUMEDWORKDATE TIMESTAMP 8
34 SC_RATETYPE CHARACTER VARYING(1) 1
35 SC_SERIALNO CHARACTER VARYING(20) 20
36 SC_WEEKLYRATE NUMERIC(6,2) 19
37 SC_WORKSTATUS BIGINT 8
38 SC_HOURSWORKEDPERWEEK NUMERIC(4,2) 19
39 SC_ESTIMATEDRTWDATE TIMESTAMP 8
40 SC_WORKERSTATUS BIGINT 8
41 SC_COSTCENTRE2 CHARACTER VARYING(20) 20
42 SC_PREINJURYRATE NUMERIC(6,2) 19
43 SC_COSTCENTRE1 CHARACTER VARYING(20) 20
44 SC_EMPLOYEEOCCUPATION CHARACTER VARYING(50) 50
45 SC_RATEEFFDATE TIMESTAMP 8
46 SC_WORKPLACESIZE BIGINT 8
47 SC_CEASEDDATE TIMESTAMP 8
48 SC_EMPLOYMENTTYPE BIGINT 8
49 SC_EMPLOYMENTSTATUS BIGINT 8
50 SC_STATDECLARATIONRECEIVED BIGINT 8
51 SC_DATESTATDECLARATIONSIGNED TIMESTAMP 8
52 SC_PARTIALINCAPHOURSPERWEEK NUMERIC(4,2) 19
53 SC_SECTION52AREASON BIGINT 8
54 SC_FULLRECOVERYDATE TIMESTAMP 8
55 SC_TRAININGSTATUS BIGINT 8
56 SC_PARTIALINCAPRATE NUMERIC(6,2) 19
57 SC_FITTORESUMEWORKDATE TIMESTAMP 8
58 SC_AVERAGEWEEKLYRATE NUMERIC(6,2) 19
59 SC_WEEKLYRATEDATE TIMESTAMP 8
60 SC_SECONDARYEMPLOYMENTIND CHARACTER VARYING(1) 1
61 SC_EMPSTATUSPOSTACCIDENT BIGINT 8
62 SC_OCCUPATIONDESCPOSTACCIDENT CHARACTER VARYING(255) 255
63 SC_GROSSWEEKLYINCOME NUMERIC(18,2) 19
64 SC_DISCHARGEPANELOUTCOME BIGINT 8
65 SC_MEDICALDISCHARGEDATE TIMESTAMP 8
66 SC_ADDITIONALINCOMEDETAILS CHARACTER VARYING(2000) 2000
67 SC_ADDITIONALINCOMEIND CHARACTER VARYING(1) 1
68 SC_WORKERSCOMPCLAIMDETAILS CHARACTER VARYING(2000) 2000
69 SC_RESUMEDWORK BIGINT 8
70 SC_SECONDARYEMPLOYMENTDETAILS CHARACTER VARYING(2000) 2000
71 SC_DEATHDISABSCHEMEFLAG BIGINT 8
72 SC_EMPLOYERPOSTACCIDENT BIGINT 8
73 SC_TERMINATIONREASON BIGINT 8
74 SC_AVGGROSSWEEKLYINCOMEPOSTACC NUMERIC(18,2) 19
75 SC_AVERAGEGROSSWEEKLYINCOME NUMERIC(18,2) 19
76 SC_ASSESSMENTPANELOUTCOME BIGINT 8
77 SC_REQFINANCIALHARDSHIPAMOUNT NUMERIC(18,2) 19
78 SC_ASSESSMENTPANELDATE TIMESTAMP 8
79 SC_EMPLOYER BIGINT 8
80 SC_OCCUPATIONPOSTACCIDENT CHARACTER VARYING(255) 255
81 SC_TERMINATIONDATE TIMESTAMP 8
82 SC_DISCHARGEPANELDATE TIMESTAMP 8
83 SC_FINANCIALHARDSHIPREQDATE TIMESTAMP 8
84 SC_WORKERSCOMPCLAIMIND CHARACTER VARYING(1) 1
85 SC_OCCUPATIONDESCRIPTION CHARACTER VARYING(255) 255
86 SC_DEATHDISABDUTYFLAG BIGINT 8
87 SC_GROSSWEEKLYINCOMEPOSTACC NUMERIC(18,2) 19
88 SC_ECONOMICLOSSTYPE BIGINT 8
89 OVERTIMESHIFTALLOWANCES_EXT NUMERIC(18,2) 19
90 NONPECUNIARYBENEFITS_EXT NUMERIC(18,2) 19
91 BASERATEOFPAY_EXT NUMERIC(18,2) 19
92 PREINJURYAWE_EXT NUMERIC(18,2) 19
93 ADJBASERATEOFPAY_EXT NUMERIC(18,2) 19
94 ADJNONPECUNIARYBENEFITS_EXT NUMERIC(18,2) 19
95 ADJOVERTIMESHIFTALLOWANCES_EXT NUMERIC(18,2) 19
96 ADJPREINJURYAWE_EXT NUMERIC(18,2) 19
97 WAGEADJUSTEDDATE_EXT TIMESTAMP 8
98 WAGEENTEREDDATE_EXT TIMESTAMP 8
99 ADMIN CHARACTER VARYING(1) 1
100 WAGEAMOUNTPOSTINJURY NUMERIC(18,2) 19
101 SC_CURRENTDOCWORKCAP BIGINT 8
102 SC_RTWGOAL BIGINT 8
103 CENTRELINKBENEFITSRECVD_EXT CHARACTER VARYING(1) 1