Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HR2NJ01
Product: Human Resources (414)
Series:
Display Name: HR_Injury Group Display Name: HR Third Party
Physical Name: HR2NJ01
Technical Name: HR_Injury
Group Technical Name: HR_Third_Party
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | EMPID_I | Emp ID | String | STR15_Employee_ID_I | 15 |
2 | INJURYNUMBER_I | Injury Number | String | STR10 | 10 |
3 | INCIDENTDATE_I | Incident Date | Date | DT | 8 |
4 | INCIDENTTIME_I | Incident Time | String | STR_Time | 5 |
5 | NOTIFYDATE_I | Notify Date | Date | DT | 8 |
6 | GBILLINJ_I | GB_Ill/Inj | Integer | GB_Illness/Injury | 0 |
7 | EMPLOYEEDIEDCB_I | Employee Died CB | Boolean | CB_Died | 0 |
8 | OSHARECORDABLE_I | OSHA Recordable | Boolean | CB_OSHA_Recordable | 0 |
9 | O7S_I | 7s | String | STR2 | 2 |
10 | INJURYTYPE_I | Injury Type | String | STR30_I0 | 30 |
11 | INJURYBODYPART_I | Injury Body Part | String | STR30_I0 | 30 |
12 | INJURYOBJECTCAUSIN_I | Injury Object Causing | String | STR30_I0 | 30 |
13 | INJURYLOCATION_I | Injury Location | String | STR60 | 60 |
14 | ONSITECB_I | On Site CB | Boolean | CB_OnSite | 0 |
15 | INJURYTASK_I | Injury Task | String | STR50_I | 50 |
16 | PERSONNOTIFIED_I | Person Notified | String | STR60 | 60 |
17 | WITNESSNAME_I | Witness Name | String | STR60 | 60 |
18 | WITNESSADDRESS_I | Witness Address | String | STR60 | 60 |
19 | WITNESSPHONE_I | Witness Phone | String | STR10_Phone_Number | 10 |
20 | TIMEARRIVED_I | Time Arrived | String | STR_Time | 5 |
21 | DATEOFDEATH_I | Date of Death | Date | DT | 8 |
22 | DATERETURN_I | Date Returned to Work | Date | DT | 8 |
23 | HOSPITALIZEDCB_I | Hospitalized CB | Boolean | CB_Hospitalized | 0 |
24 | OUTPATIENT_I | Out Patient_CB | Boolean | CB_Out Patient | 0 |
25 | EMERGENCYROOM_I | Emergency Room | Boolean | CB_Emergency Room | 0 |
26 | INHOUSETREATMENT_I | In House Treatment | Boolean | CB_In House Treatment | 0 |
27 | FIRSTAID_I | First Aid | Boolean | CB_First Aid | 0 |
28 | SAFEGUARDSPROVDCB_I | Safeguards Provided CB | Boolean | CB_Safeguards Provided | 0 |
29 | SAFEGUARDSUSEDCB_I | Safeguards Used CB | Boolean | CB_Safeguards Used | 0 |
30 | SAFEGUARDDESCRIPT_I | Safeguard Description | String | STR30_I0 | 30 |
31 | FIRSTAIDDATE_I | First Aid Date | Date | DT | 8 |
32 | FIRSTAIDNAME_I | First Aid Name | String | STR20 | 20 |
33 | FIRSTAIDDESCRIPT_I | First Aid Description | String | STR30_I0 | 30 |
34 | INJURYDOCTOR_I | Injury Doctor | String | STR60 | 60 |
35 | INJURYDOCTORPHONE_I | Injury Doctor Phone | String | STR10_Phone_Number | 10 |
36 | INJURYDOCTORSPECIA_I | Injury Doctor Specialty | String | STR20 | 20 |
37 | INJURYDOCTORDATEFI_I | Injury Doctor Date First | Date | DT | 8 |
38 | INJURYDOCTORTREATM_I | Injury Doctor Treatment | String | STR30_I0 | 30 |
39 | INJURYHOSPITAL_I | Injury Hospital | String | STR60 | 60 |
40 | INJURYHOSPITALPHON_I | Injury Hospital Phone | String | STR10_Phone_Number | 10 |
41 | INJHOSPLENGTHOFSTA_I | Injury Hospital Length of Stay | Integer | IINT4 | 4 |
42 | INJURYHOSPITALDATE_I | Injury Hospital Date | Date | DT | 8 |
43 | INJURYHOSPITALTREA_I | Injury Hospital Treatment | String | STR20 | 20 |
44 | CLAIMNUMBER_I | Claim Number | String | STR15_I | 15 |
45 | DATEFILED_I | Date Filed | Date | DT | 8 |
46 | DATECLOSED_I | Date Closed | Date | DT | 8 |
47 | DAYSMISSED_I | Days Missed | Currency | DLR4.2 | 9 |
48 | DAYSRESTRICTED_I | Days Restricted | Currency | DLR4.2 | 9 |
49 | DOLLARTIMELOST_I | Dollar Time Lost | Currency | DLR12_$S2 | 12 |
50 | DOLLARMEDICALCOST_I | Dollar Medical Cost | Currency | DLR12_$S2 | 12 |
51 | INJURYCAUSE_I | Injury Cause | String | STR80 | 80 |
52 | CHANGEBY_I | Change By | String | STR15_User_ID | 15 |
53 | CHANGEDATE_I | Change Date | Date | DT | 8 |
54 | NOTESINDEX_I | Notes Index | Currency | DOLLAR | 0 |
55 | NOTESINDEX2_I | Notes Index2 | Currency | DOLLAR | 0 |
56 | NOTESINDEX3_I | Notes Index3 | Currency | DOLLAR | 0 |
57 | NOTESINDEX4_I | Notes Index4 | Currency | DOLLAR | 0 |
58 | NOTESINDEX5_I | Notes Index5 | Currency | DOLLAR | 0 |
59 | NOTESINDEX6_I | Notes Index6 | Currency | DOLLAR | 0 |
60 | CONFIDENTIAL_I | Confidential | Boolean | CB_I | 0 |
61 | DEPRTMNT | Department | String | STR6_Payroll_Code | 6 |
62 | DIVISIONCODE_I | Division Code | String | STR6_Payroll_Code | 6 |
63 | Date_Case_Closed | Date Case Closed | Date | DT | 8 |
64 | Case_Status | Case Status | Integer | DDL_Injury_Status | 0 |