HR_Injury (HR2NJ01)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HR2NJ01

Product: Human Resources (414)
Series: 3rd Party

Display Name: HR_Injury
Physical Name: HR2NJ01
Technical Name: HR_Injury

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString1615
2INJURYNUMBER_I SearchInjury NumberSTR10String1210
3INCIDENTDATE_I SearchIncident DateDTDate48
4INCIDENTTIME_I SearchIncident TimeSTR_TimeString65
5NOTIFYDATE_I SearchNotify DateDTDate48
6GBILLINJ_I SearchGB_Ill/InjGB_Illness/InjuryInteger20
7EMPLOYEEDIEDCB_I SearchEmployee Died CBCB_DiedBoolean20
8OSHARECORDABLE_I SearchOSHA RecordableCB_OSHA_RecordableBoolean20
9O7S_I Search7sSTR2String42
10INJURYTYPE_I SearchInjury TypeSTR30_I0String3230
11INJURYBODYPART_I SearchInjury Body PartSTR30_I0String3230
12INJURYOBJECTCAUSIN_I SearchInjury Object CausingSTR30_I0String3230
13INJURYLOCATION_I SearchInjury LocationSTR60String6260
14ONSITECB_I SearchOn Site CBCB_OnSiteBoolean20
15INJURYTASK_I SearchInjury TaskSTR50_IString5250
16PERSONNOTIFIED_I SearchPerson NotifiedSTR60String6260
17WITNESSNAME_I SearchWitness NameSTR60String6260
18WITNESSADDRESS_I SearchWitness AddressSTR60String6260
19WITNESSPHONE_I SearchWitness PhoneSTR10_Phone_NumberString1210
20TIMEARRIVED_I SearchTime ArrivedSTR_TimeString65
21DATEOFDEATH_I SearchDate of DeathDTDate48
22DATERETURN_I SearchDate Returned to WorkDTDate48
23HOSPITALIZEDCB_I SearchHospitalized CBCB_HospitalizedBoolean20
24OUTPATIENT_I SearchOut Patient_CBCB_Out PatientBoolean20
25EMERGENCYROOM_I SearchEmergency RoomCB_Emergency RoomBoolean20
26INHOUSETREATMENT_I SearchIn House TreatmentCB_In House TreatmentBoolean20
27FIRSTAID_I SearchFirst AidCB_First AidBoolean20
28SAFEGUARDSPROVDCB_I SearchSafeguards Provided CBCB_Safeguards ProvidedBoolean20
29SAFEGUARDSUSEDCB_I SearchSafeguards Used CBCB_Safeguards UsedBoolean20
30SAFEGUARDDESCRIPT_I SearchSafeguard DescriptionSTR30_I0String3230
31FIRSTAIDDATE_I SearchFirst Aid DateDTDate48
32FIRSTAIDNAME_I SearchFirst Aid NameSTR20String2220
33FIRSTAIDDESCRIPT_I SearchFirst Aid DescriptionSTR30_I0String3230
34INJURYDOCTOR_I SearchInjury DoctorSTR60String6260
35INJURYDOCTORPHONE_I SearchInjury Doctor PhoneSTR10_Phone_NumberString1210
36INJURYDOCTORSPECIA_I SearchInjury Doctor SpecialtySTR20String2220
37INJURYDOCTORDATEFI_I SearchInjury Doctor Date FirstDTDate48
38INJURYDOCTORTREATM_I SearchInjury Doctor TreatmentSTR30_I0String3230
39INJURYHOSPITAL_I SearchInjury HospitalSTR60String6260
40INJURYHOSPITALPHON_I SearchInjury Hospital PhoneSTR10_Phone_NumberString1210
41INJHOSPLENGTHOFSTA_I SearchInjury Hospital Length of StayIINT4Integer24
42INJURYHOSPITALDATE_I SearchInjury Hospital DateDTDate48
43INJURYHOSPITALTREA_I SearchInjury Hospital TreatmentSTR20String2220
44CLAIMNUMBER_I SearchClaim NumberSTR15_IString1615
45DATEFILED_I SearchDate FiledDTDate48
46DATECLOSED_I SearchDate ClosedDTDate48
47DAYSMISSED_I SearchDays MissedDLR4.2Currency109
48DAYSRESTRICTED_I SearchDays RestrictedDLR4.2Currency109
49DOLLARTIMELOST_I SearchDollar Time LostDLR12_$S2Currency1012
50DOLLARMEDICALCOST_I SearchDollar Medical CostDLR12_$S2Currency1012
51INJURYCAUSE_I SearchInjury CauseSTR80String8280
52CHANGEBY_I SearchChange BySTR15_User_IDString1615
53CHANGEDATE_I SearchChange DateDTDate48
54NOTESINDEX_I SearchNotes IndexDOLLARCurrency100
55NOTESINDEX2_I SearchNotes Index2DOLLARCurrency100
56NOTESINDEX3_I SearchNotes Index3DOLLARCurrency100
57NOTESINDEX4_I SearchNotes Index4DOLLARCurrency100
58NOTESINDEX5_I SearchNotes Index5DOLLARCurrency100
59NOTESINDEX6_I SearchNotes Index6DOLLARCurrency100
60CONFIDENTIAL_I SearchConfidentialCB_IBoolean20
61DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
62DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString86
63Date_Case_Closed SearchDate Case ClosedDTDate48
64Case_Status SearchCase StatusDDL_Injury_StatusInteger20
65DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *