	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

114 COLUMNS | 3 INDEXES | 920 | 54HS | F54HS02 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
54HS: Health & Safety Incident Mgt
1	920	F54HS02	S2	114	3	Incident People	Files	54HS: Health & Safety Incident Mgt

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT S2HSINO, S2UKID, S2AN8, S2DL01, S2HSIRL, S2HSIID, S2HSIPC, S2HSIPD, S2HSIEM, S2HSICON, S2JBCX, S2HSIINJD, S2WCMP, S2WET, S2HSICIA, S2HSICN, S2HSICIR, S2HMCO, S2HMCU, S2DSI, S2HSIRHD, S2JBCD, S2JBST, S2SEX, S2HSITOP, S2UOM, S2HSIHW, S2HSIWB, S2ANPA, S2XAN8, S2DOB, S2HSIAG, S2SHFT, S2HSIDAC, S2HSIDC, S2HSIDAR, S2HSI3P, S2VR01, S2MNTR, S2ADD1, S2ADD2, S2ADD3, S2CTY1, S2ADDS, S2ADDZ, S2COUN, S2CTR, S2PH1, S2PH2, S2PH3, S2HSIEE, S2HSIIC, S2HSIIC2, S2HSISI, S2HSICF, S2HSIP01, S2HSIP02, S2HSIP03, S2HSIP04, S2HSIP05, S2HSIP06, S2HSIP07, S2HSIP08, S2HSIP09, S2HSIP10, S2HSISR, S2HSISIG, S2HSIDOS, S2OSH, S2HSIYRC, S2CASE, S2CSFX, S2CSTS, S2DCLO, S2IR, S2HSIOI, S2HSIBP, S2NDAW, S2NDWA, S2DDEC, S2DRT, S2ONPRM, S2HSIOL, S2ERCHKBX, S2HCHKBX, S2FACAN8, S2HSIMC, S2HSISD, S2HSIHCP, S2HSINOC, S2HSINC, S2HSIAT, S2HSIHO, S2HSIPO, S2HSIBJ, S2HSIBJO, S2HSIBL, S2HSIBW, S2HSIO1, S2HSIO2, S2HSIO3, S2HSIO4, S2URAB, S2URCD, S2URAT, S2URDT, S2URRF, S2USER, S2UPMJ, S2UPMT, S2JOBN, S2PID, S2HSISB, S2HSICS FROM F54HS02

TOP 920 | 54HS | F54HS02 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	S2HSINO	Incident Number	Numeric	Generic Edit	8	0	Allow NULL?
2	S2UKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
3	S2AN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
4	S2DL01	Description	String	Generic Edit	30	0	Allow NULL?
5	S2HSIRL	Incident Role	String	UDC (54HS RL)	2	0	Allow NULL?
6	S2HSIID	Injury / Illness Description	String	Generic Edit	40	0	Allow NULL?
7	S2HSIPC	Privacy Case	Character	Generic Edit	1	0	Allow NULL?
8	S2HSIPD	Privacy Case Alternate Description	String	Generic Edit	40	0	Allow NULL?
9	S2HSIEM	Employee	Character	Generic Edit	1	0	Allow NULL?
10	S2HSICON	Contractor	Character	Generic Edit	1	0	Allow NULL?
11	S2JBCX	Job Title	String	Generic Edit	30	0	Allow NULL?
12	S2HSIINJD	Injured	Character	Generic Edit	1	0	Allow NULL?
13	S2WCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
14	S2WET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
15	S2HSICIA	Insurance Claim Applied	Character	Generic Edit	1	0	Allow NULL?
16	S2HSICN	Claim Number	String	Generic Edit	40	0	Allow NULL?
17	S2HSICIR	Insurance Claim Reason	String	UDC (54HS IR)	2	0	Allow NULL?
18	S2HMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
19	S2HMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
20	S2DSI	Date - Original Employment	Date	Generic Edit	6	0
21	S2HSIRHD	Rehire Date	Date	Generic Edit	11	0
22	S2JBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
23	S2JBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
24	S2SEX	Gender (Male/Female)	Character	UDC (07 SG)	1	0	Allow NULL?
25	S2HSITOP	Time on Project	Numeric	Generic Edit	15	2	Allow NULL?
26	S2UOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
27	S2HSIHW	Hours Worked Prior to Incident	Numeric	Generic Edit	15	2	Allow NULL?
28	S2HSIWB	Time Work Began	Numeric	Generic Edit	6	0	Allow NULL?
29	S2ANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
30	S2XAN8	Address Number - Foreman	Numeric	Generic Edit	8	0	Allow NULL?
31	S2DOB	Date - Birth	Date	Generic Edit	6	0
32	S2HSIAG	Age Group	String	UDC (54HS AG)	2	0	Allow NULL?
33	S2SHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
34	S2HSIDAC	Drug and Alcohol Test Conducted	Character	Generic Edit	1	0	Allow NULL?
35	S2HSIDC	Drug and Alcohol Comment	String	Generic Edit	40	0	Allow NULL?
36	S2HSIDAR	Drug and Alcohol Result	String	UDC (54HS DR)	2	0	Allow NULL?
37	S2HSI3P	3rd Party	Character	Generic Edit	1	0	Allow NULL?
38	S2VR01	Reference	String	Generic Edit	25	0	Allow NULL?
39	S2MNTR	Mentor	Numeric	Generic Edit	8	0	Allow NULL?
40	S2ADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
41	S2ADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
42	S2ADD3	Address Line 3	String	Generic Edit	40	0	Allow NULL?
43	S2CTY1	City	String	Generic Edit	25	0	Allow NULL?
44	S2ADDS	State	String	UDC (00 S)	3	0	Allow NULL?
45	S2ADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
46	S2COUN	County	String	UDC (00 CT)	25	0	Allow NULL?
47	S2CTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
48	S2PH1	Phone Number	String	Generic Edit	20	0	Allow NULL?
49	S2PH2	Phone Number 2	String	Generic Edit	20	0	Allow NULL?
50	S2PH3	Phone Number	String	Generic Edit	20	0	Allow NULL?
51	S2HSIEE	Person Email	String	Generic Edit	75	0	Allow NULL?
52	S2HSIIC	Injury Classification	String	UDC (54HS IC)	2	0	Allow NULL?
53	S2HSIIC2	Secondary Injury Classification	String	UDC (54HS IC)	2	0	Allow NULL?
54	S2HSISI	Severity of Injury	String	UDC (54HS SI)	2	0	Allow NULL?
55	S2HSICF	Primary Causal Factor	String	UDC (54HS CF)	2	0	Allow NULL?
56	S2HSIP01	Incident People Category Code 1	String	UDC (54HS P1)	3	0	Allow NULL?
57	S2HSIP02	Incident People Category Code 2	String	UDC (54HS P2)	3	0	Allow NULL?
58	S2HSIP03	Incident People Category Code 3	String	UDC (54HS P3)	3	0	Allow NULL?
59	S2HSIP04	Incident People Category Code 4	String	UDC (54HS P4)	3	0	Allow NULL?
60	S2HSIP05	Incident People Category Code 5	String	UDC (54HS P5)	3	0	Allow NULL?
61	S2HSIP06	Incident People Category Code 6	String	UDC (54HS P6)	3	0	Allow NULL?
62	S2HSIP07	Incident People Category Code 7	String	UDC (54HS P7)	3	0	Allow NULL?
63	S2HSIP08	Incident People Category Code 8	String	UDC (54HS P8)	3	0	Allow NULL?
64	S2HSIP09	Incident People Category Code 9	String	UDC (54HS P9)	3	0	Allow NULL?
65	S2HSIP10	Incident People Category Code 10	String	UDC (54HS P0)	3	0	Allow NULL?
66	S2HSISR	Signature Required	Character	Generic Edit	1	0	Allow NULL?
67	S2HSISIG	Signature	String	Generic Edit	40	0	Allow NULL?
68	S2HSIDOS	Date of Signature	Date	Generic Edit	11	0
69	S2OSH	Yes or No - OSHA	Character	UDC (05 YN)	1	0	Allow NULL?
70	S2HSIYRC	Year - Incident Case	Numeric	Generic Edit	4	0	Allow NULL?
71	S2CASE	Number - Case/File	Numeric	Generic Edit	8	0	Allow NULL?
72	S2CSFX	Suffix - Case Entry Number	Numeric	Generic Edit	3	0	Allow NULL?
73	S2CSTS	Status - Case	String	UDC (08 CS)	2	0	Allow NULL?
74	S2DCLO	Date - Case Closed	Date	Generic Edit	6	0
75	S2IR	Injury/Illness Related (IN/IL)	String	UDC (08H IR)	2	0	Allow NULL?
76	S2HSIOI	Occupational Injury / Illness	String	UDC (54HS OI)	3	0	Allow NULL?
77	S2HSIBP	Part of Body	String	UDC (54HS BP)	4	0	Allow NULL?
78	S2NDAW	Number - Days Away from Work	Numeric	Generic Edit	5	0	Allow NULL?
79	S2NDWA	Number - Days Restricted	Numeric	Generic Edit	5	0	Allow NULL?
80	S2DDEC	Date - Deceased	Date	Generic Edit	6	0
81	S2DRT	Date - Returned to Work	Date	Generic Edit	6	0
82	S2ONPRM	Incident Occured on Employer's Premises	Character	UDC (00 ZO)	1	0	Allow NULL?
83	S2HSIOL	Occurrence Location	String	UDC (54HS OL)	3	0	Allow NULL?
84	S2ERCHKBX	Emergency Room Check Box	Character	Generic Edit	1	0	Allow NULL?
85	S2HCHKBX	Hospitalized Overnight Check Box	Character	Generic Edit	1	0	Allow NULL?
86	S2FACAN8	Facility Address Number	Numeric	Generic Edit	8	0	Allow NULL?
87	S2HSIMC	Sent to Onsite Medical Center	Character	Generic Edit	1	0	Allow NULL?
88	S2HSISD	Sent to Doctor	Character	Generic Edit	1	0	Allow NULL?
89	S2HSIHCP	Name of Physician	String	Generic Edit	40	0	Allow NULL?
90	S2HSINOC	Non-Occupational Injury	Character	Generic Edit	1	0	Allow NULL?
91	S2HSINC	Secondary Non-Occupational Injury	Character	Generic Edit	1	0	Allow NULL?
92	S2HSIAT	Action When Injured	String	Generic Edit	200	0	Allow NULL?
93	S2HSIHO	How Accident Occurred	String	Generic Edit	200	0	Allow NULL?
94	S2HSIPO	Physical Object Involved	String	Generic Edit	200	0	Allow NULL?
95	S2HSIBJ	BLS Job Category	String	UDC (54HS BJ)	2	0	Allow NULL?
96	S2HSIBJO	BLS Job Category Other	String	Generic Edit	40	0	Allow NULL?
97	S2HSIBL	BLS Service Length	String	UDC (54HS BL)	2	0	Allow NULL?
98	S2HSIBW	BLS Work Shift	Character	UDC (54HS BW)	1	0	Allow NULL?
99	S2HSIO1	OIICS Code 1 - Nature of Illness	String	UDC (54HS O1)	4	0	Allow NULL?
100	S2HSIO2	OIICS Code 2 - Part of Body	String	UDC (54HS O2)	4	0	Allow NULL?
101	S2HSIO3	OIICS Code 3 - Source of Injury	String	UDC (54HS O3)	4	0	Allow NULL?
102	S2HSIO4	OIICS Code 4 - Event / Exposure	String	UDC (54HS O4)	4	0	Allow NULL?
103	S2URAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
104	S2URCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
105	S2URAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
106	S2URDT	User Reserved Date	Date	Generic Edit	6	0
107	S2URRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
108	S2USER	User ID	String	Generic Edit	10	0	Allow NULL?
109	S2UPMJ	Date - Updated	Date	Generic Edit	6	0
110	S2UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
111	S2JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
112	S2PID	Program ID	String	Generic Edit	10	0	Allow NULL?
113	S2HSISB	Side of Body	String	UDC (54HS SB)	2	0	Allow NULL?
114	S2HSICS	Current Status of Injury / Illness	String	UDC (54HS CS)	2	0	Allow NULL?

TOP 920 | 54HS | F54HS02 INDEXES

Number

Description

IncidentNo UKID (Primary/Unique)

Element	Alias	Description	Sequence
1	HSINO	Incident Number	Ascending
2	UKID	Unique Key ID (Internal)	Ascending

IncidentNo

Element	Alias	Description	Sequence
1	HSINO	Incident Number	Ascending

Year CaseNo

Element	Alias	Description	Sequence
1	HSIYRC	Year - Incident Case	Ascending
2	CASE	Number - Case/File	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

114 COLUMNS | 3 INDEXES | 920 | 54HS | F54HS02 TABLE

TOP 920 | 54HS | F54HS02 COLUMNS

TOP 920 | 54HS | F54HS02 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

114 COLUMNS | 3 INDEXES | 920 | 54HS | F54HS02 TABLE

TOP920 | 54HS | F54HS02 COLUMNS

TOP920 | 54HS | F54HS02 INDEXES

TOP 920 | 54HS | F54HS02 COLUMNS

TOP 920 | 54HS | F54HS02 INDEXES