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

COMPANY..AHR2IN01 Table Definition

(COMPANY..Archive_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 TATX1030.EMPID_I
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 UPR00100.CHANGEBY_I
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now UPR00100.CHANGEDATE_I
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

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