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

COMPANY..HRINJ022 Table Definition

(COMPANY..HR_Injury_Costs)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
INJURYNUMBER_I char(11)
''

ISERIALNUMBER_I char(15)
''

EMPID_I char(15)
''
Employee I...(more) Join Now
CLINICCOSTS_I numeric(19,5)
0.00

DOCTORCOSTS_I numeric(19,5)
0.00

MEDICATIONCOSTS_I numeric(19,5)
0.00

OTHERCOSTS_I numeric(19,5)
0.00

TESTCOSTS_I numeric(19,5)
0.00

THERAPYCOSTS_I numeric(19,5)
0.00

TOTALCOSTS_I numeric(19,5)
0.00

CMNTS1_I char(31)
''

CMNTS2_I char(31)
''

CMNTS3_I char(31)
''

CMNTS4_I char(31)
''

IDATE_I datetime
'1/1/1900'

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

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