Module List > Module HR tables HR2NJ01
You are currently viewing the COMPANY database.
Change

COMPANY..HR2NJ01 Table Definition

(COMPANY..HR_Injury)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3