Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HRINJ022
Product: Human Resources (414)
Series: 3rd Party
Display Name: HR_Injury_Costs Group Display Name: HR Third Party
Physical Name: HRINJ022
Technical Name: HR_Injury_Costs
Group Technical Name: HR_Third_Party
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | INJURYNUMBER_I ![]() | Injury Number | STR10 | String | 10 | |
2 | ISERIALNUMBER_I ![]() | ISerial Number | STR15_I | String | 15 | |
3 | EMPID_I ![]() | Emp ID | STR15_Employee_ID_I | String | 15 | |
4 | CLINICCOSTS_I ![]() | Clinic Costs | DLR10_Salary | Currency | 10 | |
5 | DOCTORCOSTS_I ![]() | Doctor Costs | DLR10_Salary | Currency | 10 | |
6 | MEDICATIONCOSTS_I ![]() | Medication Costs | DLR10_Salary | Currency | 10 | |
7 | OTHERCOSTS_I ![]() | Other Costs | DLR10_Salary | Currency | 10 | |
8 | TESTCOSTS_I ![]() | Test Costs | DLR10_Salary | Currency | 10 | |
9 | THERAPYCOSTS_I ![]() | Therapy Costs | DLR10_Salary | Currency | 10 | |
10 | TOTALCOSTS_I ![]() | Total Costs | DLR10_Salary | Currency | 10 | |
11 | CMNTS1_I ![]() | Cmnts1 | STR30_I0 | String | 30 | |
12 | CMNTS2_I ![]() | Cmnts2 | STR30_I0 | String | 30 | |
13 | CMNTS3_I ![]() | Cmnts3 | STR30_I0 | String | 30 | |
14 | CMNTS4_I ![]() | Cmnts4 | STR30_I0 | String | 30 | |
15 | IDATE_I ![]() | IDate | DT | Date | 8 | |
16 | CHANGEBY_I ![]() | Change By | STR15_User_ID | String | 15 | |
17 | CHANGEDATE_I ![]() | Change Date | DT | Date | 8 | |
18 | NOTESINDEX_I ![]() | Notes Index | DOLLAR | Currency | 0 | |
19 | DEX_ROW_ID ![]() | int | int | 10 | ||
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. |