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 TypeLength
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString15
2INJURYNUMBER_I SearchInjury NumberSTR10String10
3INCIDENTDATE_I SearchIncident DateDTDate8
4INCIDENTTIME_I SearchIncident TimeSTR_TimeString5
5NOTIFYDATE_I SearchNotify DateDTDate8
6GBILLINJ_I SearchGB_Ill/InjGB_Illness/InjuryInteger0
7EMPLOYEEDIEDCB_I SearchEmployee Died CBCB_DiedBoolean0
8OSHARECORDABLE_I SearchOSHA RecordableCB_OSHA_RecordableBoolean0
9O7S_I Search7sSTR2String2
10INJURYTYPE_I SearchInjury TypeSTR30_I0String30
11INJURYBODYPART_I SearchInjury Body PartSTR30_I0String30
12INJURYOBJECTCAUSIN_I SearchInjury Object CausingSTR30_I0String30
13INJURYLOCATION_I SearchInjury LocationSTR60String60
14ONSITECB_I SearchOn Site CBCB_OnSiteBoolean0
15INJURYTASK_I SearchInjury TaskSTR50_IString50
16PERSONNOTIFIED_I SearchPerson NotifiedSTR60String60
17WITNESSNAME_I SearchWitness NameSTR60String60
18WITNESSADDRESS_I SearchWitness AddressSTR60String60
19WITNESSPHONE_I SearchWitness PhoneSTR10_Phone_NumberString10
20TIMEARRIVED_I SearchTime ArrivedSTR_TimeString5
21DATEOFDEATH_I SearchDate of DeathDTDate8
22DATERETURN_I SearchDate Returned to WorkDTDate8
23HOSPITALIZEDCB_I SearchHospitalized CBCB_HospitalizedBoolean0
24OUTPATIENT_I SearchOut Patient_CBCB_Out PatientBoolean0
25EMERGENCYROOM_I SearchEmergency RoomCB_Emergency RoomBoolean0
26INHOUSETREATMENT_I SearchIn House TreatmentCB_In House TreatmentBoolean0
27FIRSTAID_I SearchFirst AidCB_First AidBoolean0
28SAFEGUARDSPROVDCB_I SearchSafeguards Provided CBCB_Safeguards ProvidedBoolean0
29SAFEGUARDSUSEDCB_I SearchSafeguards Used CBCB_Safeguards UsedBoolean0
30SAFEGUARDDESCRIPT_I SearchSafeguard DescriptionSTR30_I0String30
31FIRSTAIDDATE_I SearchFirst Aid DateDTDate8
32FIRSTAIDNAME_I SearchFirst Aid NameSTR20String20
33FIRSTAIDDESCRIPT_I SearchFirst Aid DescriptionSTR30_I0String30
34INJURYDOCTOR_I SearchInjury DoctorSTR60String60
35INJURYDOCTORPHONE_I SearchInjury Doctor PhoneSTR10_Phone_NumberString10
36INJURYDOCTORSPECIA_I SearchInjury Doctor SpecialtySTR20String20
37INJURYDOCTORDATEFI_I SearchInjury Doctor Date FirstDTDate8
38INJURYDOCTORTREATM_I SearchInjury Doctor TreatmentSTR30_I0String30
39INJURYHOSPITAL_I SearchInjury HospitalSTR60String60
40INJURYHOSPITALPHON_I SearchInjury Hospital PhoneSTR10_Phone_NumberString10
41INJHOSPLENGTHOFSTA_I SearchInjury Hospital Length of StayIINT4Integer4
42INJURYHOSPITALDATE_I SearchInjury Hospital DateDTDate8
43INJURYHOSPITALTREA_I SearchInjury Hospital TreatmentSTR20String20
44CLAIMNUMBER_I SearchClaim NumberSTR15_IString15
45DATEFILED_I SearchDate FiledDTDate8
46DATECLOSED_I SearchDate ClosedDTDate8
47DAYSMISSED_I SearchDays MissedDLR4.2Currency9
48DAYSRESTRICTED_I SearchDays RestrictedDLR4.2Currency9
49DOLLARTIMELOST_I SearchDollar Time LostDLR12_$S2Currency12
50DOLLARMEDICALCOST_I SearchDollar Medical CostDLR12_$S2Currency12
51INJURYCAUSE_I SearchInjury CauseSTR80String80
52CHANGEBY_I SearchChange BySTR15_User_IDString15
53CHANGEDATE_I SearchChange DateDTDate8
54NOTESINDEX_I SearchNotes IndexDOLLARCurrency0
55NOTESINDEX2_I SearchNotes Index2DOLLARCurrency0
56NOTESINDEX3_I SearchNotes Index3DOLLARCurrency0
57NOTESINDEX4_I SearchNotes Index4DOLLARCurrency0
58NOTESINDEX5_I SearchNotes Index5DOLLARCurrency0
59NOTESINDEX6_I SearchNotes Index6DOLLARCurrency0
60CONFIDENTIAL_I SearchConfidentialCB_IBoolean0
61DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
62DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString6
63Date_Case_Closed SearchDate Case ClosedDTDate8
64Case_Status SearchCase StatusDDL_Injury_StatusInteger0
65DEX_ROW_ID Searchintint10

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 *