HR2NJ01 - HR_Injury | Prospr - Dynamics GP Table Reference

HR2NJ01 - HR_Injury

Query Builder

Select * from HR2NJ01

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPID_I	Emp ID	String	16	View
INJURYNUMBER_I	Injury Number	String	12	View
INCIDENTDATE_I	Incident Date	Date	4	View
INCIDENTTIME_I	Incident Time	String	6	View
NOTIFYDATE_I	Notify Date	Date	4	View
GBILLINJ_I	GB_Ill/Inj	Integer	2	View
EMPLOYEEDIEDCB_I	Employee Died CB	Boolean	2	View
OSHARECORDABLE_I	OSHA Recordable	Boolean	2	View
O7S_I	7s	String	4	View
INJURYTYPE_I	Injury Type	String	32	View
INJURYBODYPART_I	Injury Body Part	String	32	View
INJURYOBJECTCAUSIN_I	Injury Object Causing	String	32	View
INJURYLOCATION_I	Injury Location	String	62	View
ONSITECB_I	On Site CB	Boolean	2	View
INJURYTASK_I	Injury Task	String	52	View
PERSONNOTIFIED_I	Person Notified	String	62	View
WITNESSNAME_I	Witness Name	String	62	View
WITNESSADDRESS_I	Witness Address	String	62	View
WITNESSPHONE_I	Witness Phone	String	12	View
TIMEARRIVED_I	Time Arrived	String	6	View
DATEOFDEATH_I	Date of Death	Date	4	View
DATERETURN_I	Date Returned to Work	Date	4	View
HOSPITALIZEDCB_I	Hospitalized CB	Boolean	2	View
OUTPATIENT_I	Out Patient_CB	Boolean	2	View
EMERGENCYROOM_I	Emergency Room	Boolean	2	View
INHOUSETREATMENT_I	In House Treatment	Boolean	2	View
FIRSTAID_I	First Aid	Boolean	2	View
SAFEGUARDSPROVDCB_I	Safeguards Provided CB	Boolean	2	View
SAFEGUARDSUSEDCB_I	Safeguards Used CB	Boolean	2	View
SAFEGUARDDESCRIPT_I	Safeguard Description	String	32	View
FIRSTAIDDATE_I	First Aid Date	Date	4	View
FIRSTAIDNAME_I	First Aid Name	String	22	View
FIRSTAIDDESCRIPT_I	First Aid Description	String	32	View
INJURYDOCTOR_I	Injury Doctor	String	62	View
INJURYDOCTORPHONE_I	Injury Doctor Phone	String	12	View
INJURYDOCTORSPECIA_I	Injury Doctor Specialty	String	22	View
INJURYDOCTORDATEFI_I	Injury Doctor Date First	Date	4	View
INJURYDOCTORTREATM_I	Injury Doctor Treatment	String	32	View
INJURYHOSPITAL_I	Injury Hospital	String	62	View
INJURYHOSPITALPHON_I	Injury Hospital Phone	String	12	View
INJHOSPLENGTHOFSTA_I	Injury Hospital Length of Stay	Integer	2	View
INJURYHOSPITALDATE_I	Injury Hospital Date	Date	4	View
INJURYHOSPITALTREA_I	Injury Hospital Treatment	String	22	View
CLAIMNUMBER_I	Claim Number	String	16	View
DATEFILED_I	Date Filed	Date	4	View
DATECLOSED_I	Date Closed	Date	4	View
DAYSMISSED_I	Days Missed	Currency	10	View
DAYSRESTRICTED_I	Days Restricted	Currency	10	View
DOLLARTIMELOST_I	Dollar Time Lost	Currency	10	View
DOLLARMEDICALCOST_I	Dollar Medical Cost	Currency	10	View
INJURYCAUSE_I	Injury Cause	String	82	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
NOTESINDEX_I	Notes Index	Currency	10	View
NOTESINDEX2_I	Notes Index2	Currency	10	View
NOTESINDEX3_I	Notes Index3	Currency	10	View
NOTESINDEX4_I	Notes Index4	Currency	10	View
NOTESINDEX5_I	Notes Index5	Currency	10	View
NOTESINDEX6_I	Notes Index6	Currency	10	View
CONFIDENTIAL_I	Confidential	Boolean	2	View
DEPRTMNT	Department	String	8	View
DIVISIONCODE_I	Division Code	String	8	View
Date_Case_Closed	Date Case Closed	Date	4	View
Case_Status	Case Status	Integer	2	View

HR2NJ01 - HR_Injury

Query Builder

Customer Service

Information

My Account

Contact Us