Module List >
Module HR tables
HR2NJ01
You are currently viewing the COMPANY
database.
Change
|
COMPANY..HR2NJ01 Table Definition
(COMPANY..HR_Injury)
Field Definitions:
What is the 'source' column?
| EMPID_I |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
|
| INJURYNUMBER_I |
char(11)
''
|
|
|
|
|
| INCIDENTDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| INCIDENTTIME_I |
char(5)
''
|
|
|
|
|
| NOTIFYDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| GBILLINJ_I |
smallint
0
|
|
|
|
|
| EMPLOYEEDIEDCB_I |
tinyint
0
|
|
|
|
|
| OSHARECORDABLE_I |
tinyint
0
|
|
|
|
|
| O7S_I |
char(3)
''
|
|
|
|
|
| INJURYTYPE_I |
char(31)
''
|
|
|
|
|
| INJURYBODYPART_I |
char(31)
''
|
|
|
|
|
| INJURYOBJECTCAUSIN_I |
char(31)
''
|
|
|
|
|
| INJURYLOCATION_I |
char(61)
''
|
|
|
|
|
| ONSITECB_I |
tinyint
0
|
|
|
|
|
| INJURYTASK_I |
char(51)
''
|
|
|
|
|
| PERSONNOTIFIED_I |
char(61)
''
|
|
|
|
|
| WITNESSNAME_I |
char(61)
''
|
|
|
|
|
| WITNESSADDRESS_I |
char(61)
''
|
|
|
|
|
| WITNESSPHONE_I |
char(11)
''
|
|
|
|
|
| TIMEARRIVED_I |
char(5)
''
|
|
|
|
|
| DATEOFDEATH_I |
datetime
'1/1/1900'
|
|
|
|
|
| DATERETURN_I |
datetime
'1/1/1900'
|
|
|
|
|
| HOSPITALIZEDCB_I |
tinyint
0
|
|
|
|
|
| OUTPATIENT_I |
tinyint
0
|
|
|
|
|
| EMERGENCYROOM_I |
tinyint
0
|
|
|
|
|
| INHOUSETREATMENT_I |
tinyint
0
|
|
|
|
|
| FIRSTAID_I |
tinyint
0
|
|
|
|
|
| SAFEGUARDSPROVDCB_I |
tinyint
0
|
|
|
|
|
| SAFEGUARDSUSEDCB_I |
tinyint
0
|
|
|
|
|
| SAFEGUARDDESCRIPT_I |
char(31)
''
|
|
|
|
|
| FIRSTAIDDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| FIRSTAIDNAME_I |
char(21)
''
|
|
|
|
|
| FIRSTAIDDESCRIPT_I |
char(31)
''
|
|
|
|
|
| INJURYDOCTOR_I |
char(61)
''
|
|
|
|
|
| INJURYDOCTORPHONE_I |
char(11)
''
|
|
|
|
|
| INJURYDOCTORSPECIA_I |
char(21)
''
|
|
|
|
|
| INJURYDOCTORDATEFI_I |
datetime
'1/1/1900'
|
|
|
|
|
| INJURYDOCTORTREATM_I |
char(31)
''
|
|
|
|
|
| INJURYHOSPITAL_I |
char(61)
''
|
|
|
|
|
| INJURYHOSPITALPHON_I |
char(11)
''
|
|
|
|
|
| INJHOSPLENGTHOFSTA_I |
smallint
0
|
|
|
|
|
| INJURYHOSPITALDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| INJURYHOSPITALTREA_I |
char(21)
''
|
|
|
|
|
| CLAIMNUMBER_I |
char(15)
''
|
|
|
|
|
| DATEFILED_I |
datetime
'1/1/1900'
|
|
|
|
|
| DATECLOSED_I |
datetime
'1/1/1900'
|
|
|
|
|
| DAYSMISSED_I |
numeric(19,5)
0.00
|
|
|
|
|
| DAYSRESTRICTED_I |
numeric(19,5)
0.00
|
|
|
|
|
| DOLLARTIMELOST_I |
numeric(19,5)
0.00
|
|
|
|
|
| DOLLARMEDICALCOST_I |
numeric(19,5)
0.00
|
|
|
|
|
| INJURYCAUSE_I |
char(81)
''
|
|
|
|
|
| CHANGEBY_I |
char(15)
''
|
*Change By...(more) Join Now
|
|
|
|
| CHANGEDATE_I |
datetime
'1/1/1900'
|
*Change Da...(more) Join Now
|
|
|
|
| NOTESINDEX_I |
numeric(19,5)
0.00
|
|
|
|
|
| NOTESINDEX2_I |
numeric(19,5)
0.00
|
|
|
|
|
| NOTESINDEX3_I |
numeric(19,5)
0.00
|
|
|
|
|
| NOTESINDEX4_I |
numeric(19,5)
0.00
|
|
|
|
|
| NOTESINDEX5_I |
numeric(19,5)
0.00
|
|
|
|
|
| NOTESINDEX6_I |
numeric(19,5)
0.00
|
|
|
|
|
| CONFIDENTIAL_I |
tinyint
0
|
|
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
UPR00100.DEPRTMNT
|
|
join ... more text available
|
| DIVISIONCODE_I |
char(7)
''
|
*Division:...(more) Join Now
|
UPR00100.DIVISIONCODE_I
|
|
|
| Date_Case_Closed |
datetime
'1/1/1900'
|
|
|
|
|
| Case_Status |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|