920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
54HS: Health & Safety Incident Mgt
1	920	F54HS02M	I2	117	1	Incident People Change History	Files	54HS: Health & Safety Incident Mgt

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	I2HSINO	Incident Number	Numeric	Generic Edit	8	0	Allow NULL?
2	I2UKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
3	I2HSIMN	Incident Modification Number	Numeric	Generic Edit	6	0	Allow NULL?
4	I2HSIMT	Incident Modification Type	Character	UDC (54HS MT)	1	0	Allow NULL?
5	I2MODDT	Modification Date	Date	Generic Edit	6	0
6	I2AN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
7	I2DL01	Description	String	Generic Edit	30	0	Allow NULL?
8	I2HSIRL	Incident Role	String	UDC (54HS RL)	2	0	Allow NULL?
9	I2HSIID	Injury / Illness Description	String	Generic Edit	40	0	Allow NULL?
10	I2HSIPC	Privacy Case	Character	Generic Edit	1	0	Allow NULL?
11	I2HSIPD	Privacy Case Alternate Description	String	Generic Edit	40	0	Allow NULL?
12	I2HSIEM	Employee	Character	Generic Edit	1	0	Allow NULL?
13	I2HSICON	Contractor	Character	Generic Edit	1	0	Allow NULL?
14	I2JBCX	Job Title	String	Generic Edit	30	0	Allow NULL?
15	I2HSIINJD	Injured	Character	Generic Edit	1	0	Allow NULL?
16	I2WCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
17	I2WET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
18	I2HSICIA	Insurance Claim Applied	Character	Generic Edit	1	0	Allow NULL?
19	I2HSICN	Claim Number	String	Generic Edit	40	0	Allow NULL?
20	I2HSICIR	Insurance Claim Reason	String	UDC (54HS IR)	2	0	Allow NULL?
21	I2HMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
22	I2HMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
23	I2DSI	Date - Original Employment	Date	Generic Edit	6	0
24	I2HSIRHD	Rehire Date	Date	Generic Edit	11	0
25	I2JBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
26	I2JBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
27	I2SEX	Gender (Male/Female)	Character	UDC (07 SG)	1	0	Allow NULL?
28	I2HSITOP	Time on Project	Numeric	Generic Edit	15	2	Allow NULL?
29	I2UOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
30	I2HSIHW	Hours Worked Prior to Incident	Numeric	Generic Edit	15	2	Allow NULL?
31	I2HSIWB	Time Work Began	Numeric	Generic Edit	6	0	Allow NULL?
32	I2ANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
33	I2XAN8	Address Number - Foreman	Numeric	Generic Edit	8	0	Allow NULL?
34	I2DOB	Date - Birth	Date	Generic Edit	6	0
35	I2HSIAG	Age Group	String	UDC (54HS AG)	2	0	Allow NULL?
36	I2SHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
37	I2HSIDAC	Drug and Alcohol Test Conducted	Character	Generic Edit	1	0	Allow NULL?
38	I2HSIDC	Drug and Alcohol Comment	String	Generic Edit	40	0	Allow NULL?
39	I2HSIDAR	Drug and Alcohol Result	String	UDC (54HS DR)	2	0	Allow NULL?
40	I2HSI3P	3rd Party	Character	Generic Edit	1	0	Allow NULL?
41	I2VR01	Reference	String	Generic Edit	25	0	Allow NULL?
42	I2MNTR	Mentor	Numeric	Generic Edit	8	0	Allow NULL?
43	I2ADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
44	I2ADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
45	I2ADD3	Address Line 3	String	Generic Edit	40	0	Allow NULL?
46	I2CTY1	City	String	Generic Edit	25	0	Allow NULL?
47	I2ADDS	State	String	UDC (00 S)	3	0	Allow NULL?
48	I2ADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
49	I2COUN	County	String	UDC (00 CT)	25	0	Allow NULL?
50	I2CTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
51	I2PH1	Phone Number	String	Generic Edit	20	0	Allow NULL?
52	I2PH2	Phone Number 2	String	Generic Edit	20	0	Allow NULL?
53	I2PH3	Phone Number	String	Generic Edit	20	0	Allow NULL?
54	I2HSIEE	Person Email	String	Generic Edit	75	0	Allow NULL?
55	I2HSIIC	Injury Classification	String	UDC (54HS IC)	2	0	Allow NULL?
56	I2HSIIC2	Secondary Injury Classification	String	UDC (54HS IC)	2	0	Allow NULL?
57	I2HSISI	Severity of Injury	String	UDC (54HS SI)	2	0	Allow NULL?
58	I2HSICF	Primary Causal Factor	String	UDC (54HS CF)	2	0	Allow NULL?
59	I2HSIP01	Incident People Category Code 1	String	UDC (54HS P1)	3	0	Allow NULL?
60	I2HSIP02	Incident People Category Code 2	String	UDC (54HS P2)	3	0	Allow NULL?
61	I2HSIP03	Incident People Category Code 3	String	UDC (54HS P3)	3	0	Allow NULL?
62	I2HSIP04	Incident People Category Code 4	String	UDC (54HS P4)	3	0	Allow NULL?
63	I2HSIP05	Incident People Category Code 5	String	UDC (54HS P5)	3	0	Allow NULL?
64	I2HSIP06	Incident People Category Code 6	String	UDC (54HS P6)	3	0	Allow NULL?
65	I2HSIP07	Incident People Category Code 7	String	UDC (54HS P7)	3	0	Allow NULL?
66	I2HSIP08	Incident People Category Code 8	String	UDC (54HS P8)	3	0	Allow NULL?
67	I2HSIP09	Incident People Category Code 9	String	UDC (54HS P9)	3	0	Allow NULL?
68	I2HSIP10	Incident People Category Code 10	String	UDC (54HS P0)	3	0	Allow NULL?
69	I2HSISR	Signature Required	Character	Generic Edit	1	0	Allow NULL?
70	I2HSISIG	Signature	String	Generic Edit	40	0	Allow NULL?
71	I2HSIDOS	Date of Signature	Date	Generic Edit	11	0
72	I2OSH	Yes or No - OSHA	Character	UDC (05 YN)	1	0	Allow NULL?
73	I2HSIYRC	Year - Incident Case	Numeric	Generic Edit	4	0	Allow NULL?
74	I2CASE	Number - Case/File	Numeric	Generic Edit	8	0	Allow NULL?
75	I2CSFX	Suffix - Case Entry Number	Numeric	Generic Edit	3	0	Allow NULL?
76	I2CSTS	Status - Case	String	UDC (08 CS)	2	0	Allow NULL?
77	I2DCLO	Date - Case Closed	Date	Generic Edit	6	0
78	I2IR	Injury/Illness Related (IN/IL)	String	UDC (08H IR)	2	0	Allow NULL?
79	I2HSIOI	Occupational Injury / Illness	String	UDC (54HS OI)	3	0	Allow NULL?
80	I2HSIBP	Part of Body	String	UDC (54HS BP)	4	0	Allow NULL?
81	I2NDAW	Number - Days Away from Work	Numeric	Generic Edit	5	0	Allow NULL?
82	I2NDWA	Number - Days Restricted	Numeric	Generic Edit	5	0	Allow NULL?
83	I2DDEC	Date - Deceased	Date	Generic Edit	6	0
84	I2DRT	Date - Returned to Work	Date	Generic Edit	6	0
85	I2ONPRM	Incident Occured on Employer's Premises	Character	UDC (00 ZO)	1	0	Allow NULL?
86	I2HSIOL	Occurrence Location	String	UDC (54HS OL)	3	0	Allow NULL?
87	I2ERCHKBX	Emergency Room Check Box	Character	Generic Edit	1	0	Allow NULL?
88	I2HCHKBX	Hospitalized Overnight Check Box	Character	Generic Edit	1	0	Allow NULL?
89	I2FACAN8	Facility Address Number	Numeric	Generic Edit	8	0	Allow NULL?
90	I2HSIMC	Sent to Onsite Medical Center	Character	Generic Edit	1	0	Allow NULL?
91	I2HSISD	Sent to Doctor	Character	Generic Edit	1	0	Allow NULL?
92	I2HSIHCP	Name of Physician	String	Generic Edit	40	0	Allow NULL?
93	I2HSINOC	Non-Occupational Injury	Character	Generic Edit	1	0	Allow NULL?
94	I2HSINC	Secondary Non-Occupational Injury	Character	Generic Edit	1	0	Allow NULL?
95	I2HSIAT	Action When Injured	String	Generic Edit	200	0	Allow NULL?
96	I2HSIHO	How Accident Occurred	String	Generic Edit	200	0	Allow NULL?
97	I2HSIPO	Physical Object Involved	String	Generic Edit	200	0	Allow NULL?
98	I2HSIBJ	BLS Job Category	String	UDC (54HS BJ)	2	0	Allow NULL?
99	I2HSIBJO	BLS Job Category Other	String	Generic Edit	40	0	Allow NULL?
100	I2HSIBL	BLS Service Length	String	UDC (54HS BL)	2	0	Allow NULL?
101	I2HSIBW	BLS Work Shift	Character	UDC (54HS BW)	1	0	Allow NULL?
102	I2HSIO1	OIICS Code 1 - Nature of Illness	String	UDC (54HS O1)	4	0	Allow NULL?
103	I2HSIO2	OIICS Code 2 - Part of Body	String	UDC (54HS O2)	4	0	Allow NULL?
104	I2HSIO3	OIICS Code 3 - Source of Injury	String	UDC (54HS O3)	4	0	Allow NULL?
105	I2HSIO4	OIICS Code 4 - Event / Exposure	String	UDC (54HS O4)	4	0	Allow NULL?
106	I2URAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
107	I2URCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
108	I2URAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
109	I2URDT	User Reserved Date	Date	Generic Edit	6	0
110	I2URRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
111	I2USER	User ID	String	Generic Edit	10	0	Allow NULL?
112	I2UPMJ	Date - Updated	Date	Generic Edit	6	0
113	I2UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
114	I2JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
115	I2PID	Program ID	String	Generic Edit	10	0	Allow NULL?
116	I2HSISB	Side of Body	String	UDC (54HS SB)	2	0	Allow NULL?
117	I2HSICS	Current Status of Injury / Illness	String	UDC (54HS CS)	2	0	Allow NULL?

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

117 COLUMNS | 1 INDEXES | 920 | 54HS | F54HS02M TABLE

TOP 920 | 54HS | F54HS02M COLUMNS

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

117 COLUMNS | 1 INDEXES | 920 | 54HS | F54HS02M TABLE

TOP920 | 54HS | F54HS02M COLUMNS

TOP920 | 54HS | F54HS02M INDEXES

TOP 920 | 54HS | F54HS02M COLUMNS

TOP 920 | 54HS | F54HS02M INDEXES