	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	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
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	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
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

99 COLUMNS | 8 INDEXES | 920 | 54HS | F54HS01 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
54HS: Health & Safety Incident Mgt
1	920	F54HS01	S1	99	8	Incident Master	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 S1HSINO, S1HSIDN, S1HSIDT, S1HSITM, S1HSIDM, S1WKD, S1HSIDR, S1HSITR, S1HSIST, S1HSISV, S1HSINOP, S1HSINM, S1HSIPED, S1HSIMV, S1HSIINJ, S1HSIENV, S1HSISEC, S1HSISC, S1HSIOT, S1HSIOC, S1HSIXS, S1HSIAA, S1HSILN, S1ESTB, S1CO, S1MCUS, S1MCU, S1CTR, S1ADDS, S1ADD1, S1ADD2, S1ADD3, S1ADD4, S1CTY1, S1ADDZ, S1COUN, S1LATT, S1LONG, S1REGION, S1DOCO, S1HSITEC, S1HSITAC, S1CRCD, S1HSIDA, S1HSIDC, S1HSIDAR, S1HSICR, S1HSICRN, S1HSICRNM, S1HSIFR, S1HSIPR, S1HSIPRC, S1HSIPRN, S1HSIPRNM, S1HSIDTC, S1HSICSF, S1HSIINS, S1HSICIS, S1HSIEF, S1HSIRT, S1HSICMT, S1HSINT, S1HSIC01, S1HSIC02, S1HSIC03, S1HSIC04, S1HSIC05, S1HSIC06, S1HSIC07, S1HSIC08, S1HSIC09, S1HSIC10, S1HSIOR, S1HSIRB, S1HSIHR, S1HSIIB, S1KBCO, S1URAB, S1URCD, S1URAT, S1URDT, S1URRF, S1USER, S1UPMJ, S1UPMT, S1JOBN, S1PID, S1CRTU, S1HSIC11, S1HSIC12, S1HSIC13, S1HSIC14, S1HSIC15, S1HSIC16, S1HSIC17, S1HSIC18, S1HSIC19, S1HSIC20, S1HSIIRT FROM F54HS01

TOP 920 | 54HS | F54HS01 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	S1HSINO	Incident Number	Numeric	Generic Edit	8	0	Allow NULL?
2	S1HSIDN	Incident Description	String	Generic Edit	100	0	Allow NULL?
3	S1HSIDT	Incident Date	Date	Generic Edit	11	0
4	S1HSITM	Incident Time	Numeric	Generic Edit	6	0	Allow NULL?
5	S1HSIDM	Incident Month	String	UDC (06 MN)	2	0	Allow NULL?
6	S1WKD	Day of Week	Character	UDC (08 WD)	1	0	Allow NULL?
7	S1HSIDR	Incident Date Reported	Date	Generic Edit	11	0
8	S1HSITR	Incident Time Reported	Numeric	Generic Edit	6	0	Allow NULL?
9	S1HSIST	Incident Status	String	UDC (54HS ST)	2	0	Allow NULL?
10	S1HSISV	Incident Severity	String	UDC (54HS SV)	2	0	Allow NULL?
11	S1HSINOP	Parent Incident Number	Numeric	Generic Edit	8	0	Allow NULL?
12	S1HSINM	Potential Incident	Integer	Generic Edit	11	0	Allow NULL?
13	S1HSIPED	Property / Equipment Damage	Integer	Generic Edit	11	0	Allow NULL?
14	S1HSIMV	Motor Vehicle Involved	Integer	Generic Edit	11	0	Allow NULL?
15	S1HSIINJ	Injury / Illness	Integer	Generic Edit	11	0	Allow NULL?
16	S1HSIENV	Environmental Impact	Integer	Generic Edit	11	0	Allow NULL?
17	S1HSISEC	Security	Integer	Generic Edit	11	0	Allow NULL?
18	S1HSISC	Security Classification	String	UDC (54HS SC)	2	0	Allow NULL?
19	S1HSIOT	Other	Integer	Generic Edit	11	0	Allow NULL?
20	S1HSIOC	Other Classification	String	UDC (54HS OC)	2	0	Allow NULL?
21	S1HSIXS	Exclude From Safety Statistics	Integer	Generic Edit	11	0	Allow NULL?
22	S1HSIAA	Authorities Alerted	Integer	Generic Edit	11	0	Allow NULL?
23	S1HSILN	Incident Location	String	Generic Edit	200	0	Allow NULL?
24	S1ESTB	Number - Establishment of Business Activ	Numeric	Generic Edit	8	0	Allow NULL?
25	S1CO	Company	String	Generic Edit	5	0	Allow NULL?
26	S1MCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
27	S1MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
28	S1CTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
29	S1ADDS	State	String	UDC (00 S)	3	0	Allow NULL?
30	S1ADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
31	S1ADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
32	S1ADD3	Address Line 3	String	Generic Edit	40	0	Allow NULL?
33	S1ADD4	Address Line 4	String	Generic Edit	40	0	Allow NULL?
34	S1CTY1	City	String	Generic Edit	25	0	Allow NULL?
35	S1ADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
36	S1COUN	County	String	UDC (00 CT)	25	0	Allow NULL?
37	S1LATT	Latitude	String	Generic Edit	25	0	Allow NULL?
38	S1LONG	Longitude	String	Generic Edit	25	0	Allow NULL?
39	S1REGION	Geographic Region Code	String	UDC (17 GR)	3	0	Allow NULL?
40	S1DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
41	S1HSITEC	Total Incident Estimated Cost	Numeric	Generic Edit	15	2	Allow NULL?
42	S1HSITAC	Total Incident Actual Cost	Numeric	Generic Edit	15	2	Allow NULL?
43	S1CRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
44	S1HSIDA	Drug and Alcohol Test	Integer	Generic Edit	11	0	Allow NULL?
45	S1HSIDC	Drug and Alcohol Comment	String	Generic Edit	40	0	Allow NULL?
46	S1HSIDAR	Drug and Alcohol Result	String	UDC (54HS DR)	2	0	Allow NULL?
47	S1HSICR	Contractor/3rd Party Involved	Integer	Generic Edit	11	0	Allow NULL?
48	S1HSICRN	Contractor/3rd Party Number	Numeric	Generic Edit	8	0	Allow NULL?
49	S1HSICRNM	Contractor/3rd Party Name	String	Generic Edit	40	0	Allow NULL?
50	S1HSIFR	Incident Frequency	String	UDC (54HS FR)	2	0	Allow NULL?
51	S1HSIPR	Potential Recurrence	String	UDC (54HS PR)	2	0	Allow NULL?
52	S1HSIPRC	Party Responsible Code	String	UDC (54HS RS)	2	0	Allow NULL?
53	S1HSIPRN	Party Responsible Number	Numeric	Generic Edit	8	0	Allow NULL?
54	S1HSIPRNM	Party Responsible Name	String	Generic Edit	40	0	Allow NULL?
55	S1HSIDTC	Determined Cause	String	Generic Edit	40	0	Allow NULL?
56	S1HSICSF	Incident Causal Factor	String	UDC (54HS FC)	3	0	Allow NULL?
57	S1HSIINS	Insurance Claim Number	String	Generic Edit	40	0	Allow NULL?
58	S1HSICIS	Insurance Claim Status	String	UDC (54HS IS)	2	0	Allow NULL?
59	S1HSIEF	Effect on Environment Text	String	Generic Edit	200	0	Allow NULL?
60	S1HSIRT	Remediation Text	String	Generic Edit	200	0	Allow NULL?
61	S1HSICMT	Corrective Measures Text	String	Generic Edit	200	0	Allow NULL?
62	S1HSINT	Other Text	String	Generic Edit	200	0	Allow NULL?
63	S1HSIC01	Incident Category Code 01	String	UDC (54HS C1)	3	0	Allow NULL?
64	S1HSIC02	Incident Category Code 02	String	UDC (54HS C2)	3	0	Allow NULL?
65	S1HSIC03	Incident Category Code 03	String	UDC (54HS C3)	3	0	Allow NULL?
66	S1HSIC04	Incident Category Code 04	String	UDC (54HS C4)	3	0	Allow NULL?
67	S1HSIC05	Incident Category Code 05	String	UDC (54HS C5)	3	0	Allow NULL?
68	S1HSIC06	Incident Category Code 06	String	UDC (54HS C6)	3	0	Allow NULL?
69	S1HSIC07	Incident Category Code 07	String	UDC (54HS C7)	3	0	Allow NULL?
70	S1HSIC08	Incident Category Code 08	String	UDC (54HS C8)	3	0	Allow NULL?
71	S1HSIC09	Incident Category Code 09	String	UDC (54HS C9)	3	0	Allow NULL?
72	S1HSIC10	Incident Category Code 10	String	UDC (54HS C0)	3	0	Allow NULL?
73	S1HSIOR	Originator Address	Numeric	Generic Edit	8	0	Allow NULL?
74	S1HSIRB	Reported By Address	Numeric	Generic Edit	8	0	Allow NULL?
75	S1HSIHR	Incident Handler Address	Numeric	Generic Edit	8	0	Allow NULL?
76	S1HSIIB	Investigated By Address	Numeric	Generic Edit	8	0	Allow NULL?
77	S1KBCO	Failure Analysis Code	String	Generic Edit	15	0	Allow NULL?
78	S1URAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
79	S1URCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
80	S1URAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
81	S1URDT	User Reserved Date	Date	Generic Edit	6	0
82	S1URRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
83	S1USER	User ID	String	Generic Edit	10	0	Allow NULL?
84	S1UPMJ	Date - Updated	Date	Generic Edit	6	0
85	S1UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
86	S1JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
87	S1PID	Program ID	String	Generic Edit	10	0	Allow NULL?
88	S1CRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
89	S1HSIC11	Incident Category Code 11	String	UDC (54HS 11)	3	0	Allow NULL?
90	S1HSIC12	Incident Category Code 12	String	UDC (54HS 12)	3	0	Allow NULL?
91	S1HSIC13	Incident Category Code 13	String	UDC (54HS 13)	3	0	Allow NULL?
92	S1HSIC14	Incident Category Code 14	String	UDC (54HS 14)	3	0	Allow NULL?
93	S1HSIC15	Incident Category Code 15	String	UDC (54HS 15)	3	0	Allow NULL?
94	S1HSIC16	Incident Category Code 16	String	UDC (54HS 16)	3	0	Allow NULL?
95	S1HSIC17	Incident Category Code 17	String	UDC (54HS 17)	3	0	Allow NULL?
96	S1HSIC18	Incident Category Code 18	String	UDC (54HS 18)	3	0	Allow NULL?
97	S1HSIC19	Incident Category Code 19	String	UDC (54HS 19)	3	0	Allow NULL?
98	S1HSIC20	Incident Category Code 20	String	UDC (54HS 20)	3	0	Allow NULL?
99	S1HSIIRT	Incident Record Type	String	UDC (54HS RT)	3	0	Allow NULL?

TOP 920 | 54HS | F54HS01 INDEXES

Number

Description

IncidentNo (Primary/Unique)

Element	Alias	Description	Sequence
1	HSINO	Incident Number	Ascending

IncidentDate ExcludeSafetyFlag

Element	Alias	Description	Sequence
1	HSIDT	Incident Date	Ascending
2	HSIXS	Exclude From Safety Statistics	Ascending
3	HSINM	Potential Incident	Ascending

Establishment

Element	Alias	Description	Sequence
1	ESTB	Number - Establishment of Business Activ	Ascending

Company

Element	Alias	Description	Sequence
1	CO	Company	Ascending

Project

Element	Alias	Description	Sequence
1	MCUS	Business Unit - Subsequent	Ascending

BusinessUnit

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

Contractor

Element	Alias	Description	Sequence
1	HSICRN	Contractor/3rd Party Number	Ascending

IncidentDateDesc

Element	Alias	Description	Sequence
1	HSIDT	Incident Date	Descending

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

99 COLUMNS | 8 INDEXES | 920 | 54HS | F54HS01 TABLE

TOP 920 | 54HS | F54HS01 COLUMNS

TOP 920 | 54HS | F54HS01 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

99 COLUMNS | 8 INDEXES | 920 | 54HS | F54HS01 TABLE

TOP920 | 54HS | F54HS01 COLUMNS

TOP920 | 54HS | F54HS01 INDEXES

TOP 920 | 54HS | F54HS01 COLUMNS

TOP 920 | 54HS | F54HS01 INDEXES