	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

211 COLUMNS | 14 INDEXES | 920 | 05A | F060116 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05A: PeopleSoft HR & PR Foundation
1	920	F060116	YA	211	14	Employee Master Information	Master Files	05A: PeopleSoft HR & PR Foundation	Business Data

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 YAAN8, YAALPH, YASSN, YAOEMP, YASEX, YAMSTX, YAMSTI, YAWSPS, YAEIC, YANDEP, YAEST, YAECNT, YATARR, YATARA, YASCDC, YAHMST, YAWKSE, YAHMLC, YALWK1, YALWK2, YAHMCO, YAMCU, YAHMCU, YASG, YAMAIL, YAPAST, YAPFRQ, YASALY, YAPYCB, YABCB, YAUN, YAJBCD, YAJBST, YAEEOJ, YAEEOM, YATRS, YAWCMP, YAFLSA, YAWS, YASHFT, YALMTH, YAPBRT, YALF, YASAL, YAPHRT, YAPPRT, YAPWRN, YAHRTN, YABRTN, YASALN, YASTDH, YASTDD, YASDYY, YAUSR, YAUFLG, YANS, YAIFN, YAIMN, YADOB, YADSI, YADT, YADST, YAPSDT, YAPTDT, YANRDT, YANBDT, YANPDT, YALCDT, YADR, YACTDT, YALADT, YABSDT, YACPDT, YAFICM, YAP001, YAP002, YAP003, YAP004, YAP005, YAP006, YAP007, YAP008, YAP009, YAP010, YAP011, YAP012, YAP013, YAP014, YAP015, YAP016, YAP017, YAP018, YAP019, YAP020, YAE001, YAE002, YAE003, YAE004, YAE005, YAE006, YAE007, YAE008, YAE009, YAE010, YAICC, YANMAX, YASOCC, YAIUSR, YAITRM, YAINBT, YAREGN, YAPSTP, YAIH, YACCPR, YAADPN, YATCNF, YARAF, YATIPE, YARCCD, YABDRT, YABORN, YANBDR, YAWET, YAAFLG, YARMST, YALMST, YASMKR, YACBAC, YACBAF, YAPCCD, YARCDT, YALSDT, YAPADT, YAPYMH, YAUYST, YADTSP, YAANN8, YAPPNB, YAPYDT, YACBEN, YADOBM, YADSTM, YAPSAL, YAHIPN, YACM, YALSAL, YADIVC, YAVSHF, YAPYRV, YAANPA, YAPGRD, YAPGRS, YASLOC, YANRVW, YATINC, YAHM01, YAHM02, YAHM03, YAHM04, YAPOS, YAED01, YAED02, YAED03, YAED04, YAED05, YAED06, YAED07, YAED08, YAED09, YAED10, YAED11, YAED12, YAED13, YAED14, YAED15, YAED16, YAED17, YAED18, YAED19, YAED20, YADEPT, YAFAGE, YAFSAL, YAADSD, YACMPA, YAEPNT, YAJOBN, YAUSER, YAPID, YAUPMJ, YAK001, YAK002, YAK003, YAK004, YAK005, YAK006, YAK007, YAK008, YAK009, YAK010, YAATPY, YAPENS, YAORG, YABENS, YAFTE, YAAAF, YASUI, YADTSF, YASMOY, YALDID, YATTAR FROM F060116

TOP 920 | 05A | F060116 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YAAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
2	YAALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
3	YASSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
4	YAOEMP	Additional Employee No	String	Generic Edit	8	0	Allow NULL?
5	YASEX	Gender (Male/Female)	Character	UDC (07 SG)	1	0	Allow NULL?
6	YAMSTX	Marital Status - Tax	Character	UDC (06 MS)	1	0	Allow NULL?
7	YAMSTI	Marital Status - State Tax	Character	UDC (06 MS)	1	0	Allow NULL?
8	YAWSPS	Residency Status	Character	UDC (05 WS)	1	0	Allow NULL?
9	YAEIC	Earned Income Credit Status	Character	UDC (05 EI)	1	0	Allow NULL?
10	YANDEP	Dependents	Numeric	Generic Edit	2	0	Allow NULL?
11	YAEST	Employment Status	Character	UDC (06 ES)	1	0	Allow NULL?
12	YAECNT	Employee Classification Status	Character	UDC (05A EC)	1	0	Allow NULL?
13	YATARR	Tax Area (Residence)	String	Generic Edit	10	0	Allow NULL?
14	YATARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
15	YASCDC	School District Code	Numeric	UDC (07 SS)	5	0	Allow NULL?
16	YAHMST	State - Home	String	UDC (06 SC)	3	0	Allow NULL?
17	YAWKSE	State - Working	String	UDC (06 SC)	3	0	Allow NULL?
18	YAHMLC	Location - Home City	String	UDC (06 W1)	3	0	Allow NULL?
19	YALWK1	Location - Work City	String	UDC (06 W1)	3	0	Allow NULL?
20	YALWK2	Location - Work County	String	UDC (06 W2)	3	0	Allow NULL?
21	YAHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
22	YAMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
23	YAHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
24	YASG	Last Job Worked	String	Generic Edit	12	0	Allow NULL?
25	YAMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
26	YAPAST	Employee Pay Status	Character	UDC (06 PS)	1	0	Allow NULL?
27	YAPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
28	YASALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
29	YAPYCB	Pay Cycle Bypass Count	Numeric	Generic Edit	2	0	Allow NULL?
30	YABCB	Benefit Cycle Bypass Count	Numeric	Generic Edit	2	0	Allow NULL?
31	YAUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
32	YAJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
33	YAJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
34	YAEEOJ	Job Category (EEO)	String	UDC (06 J)	3	0	Allow NULL?
35	YAEEOM	Ethnic Code	String	UDC (06 M)	2	0	Allow NULL?
36	YATRS	Change Reason	String	UDC (06 T)	3	0	Allow NULL?
37	YAWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
38	YAFLSA	FLSA Exempt Y/N	Character	UDC (05 FL)	1	0	Allow NULL?
39	YAWS	Work Schedule Code	Character	UDC (05A WS)	1	0	Allow NULL?
40	YASHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
41	YALMTH	Labor Distribution Method	Character	UDC (07 LT)	1	0	Allow NULL?
42	YAPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
43	YALF	Labor Distribution Multiplier	Numeric	Generic Edit	5	4	Allow NULL?
44	YASAL	Rate - Salary Annual	Numeric	Generic Edit	11	2	Allow NULL?
45	YAPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
46	YAPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
47	YAPWRN	Rate (Piecework)at Next Raise	Numeric	Generic Edit	9	3	Allow NULL?
48	YAHRTN	Rate (Hourly) at Next Raise	Numeric	Generic Edit	9	3	Allow NULL?
49	YABRTN	Rate (Billing) at Next Raise	Numeric	Generic Edit	9	3	Allow NULL?
50	YASALN	Rate - Salary at Next Raise	Numeric	Generic Edit	11	2	Allow NULL?
51	YASTDH	Hours - Standard per Payperiod	Numeric	Generic Edit	5	2	Allow NULL?
52	YASTDD	Hours - Standard per Day	Numeric	Generic Edit	5	2	Allow NULL?
53	YASDYY	Days - Standard per Year	Numeric	Generic Edit	5	2	Allow NULL?
54	YAUSR	Payroll Lockout Identification	String	Generic Edit	18	0	Allow NULL?
55	YAUFLG	Update Flag	Character	Generic Edit	1	0	Allow NULL?
56	YANS	Work Tax Area Source	Character	UDC (05 NS)	1	0	Allow NULL?
57	YAIFN	Initial - First Name (Govt Rpts)	Character	Generic Edit	1	0	Allow NULL?
58	YAIMN	Initial - Middle Name (Govt Rpts)	Character	Generic Edit	1	0	Allow NULL?
59	YADOB	Date - Birth	Date	Generic Edit	6	0
60	YADSI	Date - Original Employment	Date	Generic Edit	6	0
61	YADT	Date - Terminated	Date	Generic Edit	6	0
62	YADST	Date Started	Date	Generic Edit	6	0
63	YAPSDT	Date - Pay Starts	Date	Generic Edit	6	0
64	YAPTDT	Date - Pay Stops	Date	Generic Edit	6	0
65	YANRDT	Date - Next Raise	Date	Generic Edit	6	0
66	YANBDT	Date - New Bill Rate	Date	Generic Edit	6	0
67	YANPDT	Date - New Piecerate	Date	Generic Edit	6	0
68	YALCDT	Date - Last Check	Date	Generic Edit	6	0
69	YADR	Date - Last Raise	Date	Generic Edit	6	0
70	YACTDT	Date - Last Contact	Date	Generic Edit	6	0
71	YALADT	Date - LOA Expiration Date	Date	Generic Edit	6	0
72	YABSDT	Date - Bonus	Date	Generic Edit	6	0
73	YACPDT	Date - Current Position	Date	Generic Edit	6	0
74	YAFICM	Tax Calc Method	Character	UDC (06 TM)	1	0	Allow NULL?
75	YAP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
76	YAP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
77	YAP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
78	YAP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
79	YAP005	Category Codes - Payroll5	String	UDC (06 05)	3	0	Allow NULL?
80	YAP006	Category Codes - Payroll6	String	UDC (06 06)	3	0	Allow NULL?
81	YAP007	Category Codes - Payroll7	String	UDC (06 07)	3	0	Allow NULL?
82	YAP008	Category Codes - Payroll8	String	UDC (06 08)	3	0	Allow NULL?
83	YAP009	Category Codes - Payroll9	String	UDC (06 09)	3	0	Allow NULL?
84	YAP010	Category Codes - Payroll10	String	UDC (06 10)	3	0	Allow NULL?
85	YAP011	Category Codes - Payroll11	String	UDC (06 11)	3	0	Allow NULL?
86	YAP012	Category Codes - Payroll12	String	UDC (06 12)	3	0	Allow NULL?
87	YAP013	Category Codes - Payroll13	String	UDC (06 13)	3	0	Allow NULL?
88	YAP014	Category Codes - Payroll14	String	UDC (06 14)	3	0	Allow NULL?
89	YAP015	Category Codes - Payroll15	String	UDC (06 15)	3	0	Allow NULL?
90	YAP016	Category Codes - Payroll16	String	UDC (06 16)	3	0	Allow NULL?
91	YAP017	Category Codes - Payroll17	String	UDC (06 17)	3	0	Allow NULL?
92	YAP018	Category Codes - Payroll18	String	UDC (06 18)	3	0	Allow NULL?
93	YAP019	Category Codes - Payroll19	String	UDC (06 19)	3	0	Allow NULL?
94	YAP020	Category Codes - Payroll20	String	UDC (06 21)	3	0	Allow NULL?
95	YAE001	Eligibility Code 001	Character	UDC (05 YB)	1	0	Allow NULL?
96	YAE002	Eligibility Code 002	Character	UDC (05 YB)	1	0	Allow NULL?
97	YAE003	Eligibility Code 003	Character	UDC (05 YB)	1	0	Allow NULL?
98	YAE004	Eligibility Code 004	Character	UDC (05 YB)	1	0	Allow NULL?
99	YAE005	Eligibility Code 005	Character	UDC (05 YB)	1	0	Allow NULL?
100	YAE006	Eligibility Code 006	Character	UDC (05 YB)	1	0	Allow NULL?
101	YAE007	Eligibility Code 007	Character	UDC (05 YB)	1	0	Allow NULL?
102	YAE008	Eligibility Code 008	Character	UDC (05 YB)	1	0	Allow NULL?
103	YAE009	Eligibility Code 009	Character	UDC (05 YB)	1	0	Allow NULL?
104	YAE010	Eligibility Code 010	Character	UDC (05 YB)	1	0	Allow NULL?
105	YAICC	Interim Check Code	Character	UDC (07 IC)	1	0	Allow NULL?
106	YANMAX	Amount - Maximum Net Pay	Numeric	Generic Edit	15	2	Allow NULL?
107	YASOCC	Standard Occupational Class Code	String	UDC (06 SO)	4	0	Allow NULL?
108	YAIUSR	User ID - Interim Check Enterer	String	Generic Edit	10	0	Allow NULL?
109	YAITRM	Terminal Id - Interim Check	String	Generic Edit	10	0	Allow NULL?
110	YAINBT	Interim Processing Batch Flag	Character	UDC	1	0	Allow NULL?
111	YAREGN	Region	String	UDC (06 RG)	3	0	Allow NULL?
112	YAPSTP	No. of Pay Grade Steps	String	Generic Edit	4	0	Allow NULL?
113	YAIH	Hours per Standard Year	Numeric	Generic Edit	7	2	Allow NULL?
114	YACCPR	Country Code	String	UDC (00 CN)	3	0	Allow NULL?
115	YAADPN	Pre-Note Code	Character	UDC (07 AE)	1	0	Allow NULL?
116	YATCNF	Third Country National Flag	Character	Generic Edit	1	0	Allow NULL?
117	YARAF	Resident Alien Flag	Character	Generic Edit	1	0	Allow NULL?
118	YATIPE	Employee Code - Tipped(Y/N)	Character	UDC (05 YN)	1	0	Allow NULL?
119	YARCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
120	YABDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
121	YABORN	Rate - New Recharge Burden Rate	Numeric	Generic Edit	9	3	Allow NULL?
122	YANBDR	Date - New Bill Rate	Date	Generic Edit	6	0
123	YAWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
124	YAAFLG	Address Flag	Character	Generic Edit	1	0	Allow NULL?
125	YARMST	Marital Status - Resident State	Character	UDC (06 MS)	1	0	Allow NULL?
126	YALMST	Local Area Marital Status	Character	UDC (06 MS)	1	0	Allow NULL?
127	YASMKR	Flag - Language Preference	String	UDC (07 SN)	2	0	Allow NULL?
128	YACBAC	Amount - Cash Accumulator	Numeric	Generic Edit	3	2	Allow NULL?
129	YACBAF	Flag - Cash Rounding	Character	Generic Edit	1	0	Allow NULL?
130	YAPCCD	Pay Cycle Code	String	UDC (06 PY)	5	0	Allow NULL?
131	YARCDT	Date - Employee Recall	Date	Generic Edit	6	0
132	YALSDT	Date - LOA Beginning Date	Date	Generic Edit	6	0
133	YAPADT	Date - Participation	Date	Generic Edit	6	0
134	YAPYMH	Method - Employee Payment	Character	UDC	1	0	Allow NULL?
135	YAUYST	Processed Code - Payroll	Character	UDC	1	0	Allow NULL?
136	YADTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
137	YAANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
138	YAPPNB	Pay Period Number	String	Generic Edit	3	0	Allow NULL?
139	YAPYDT	Date - Pay Cycle Processed	Date	Generic Edit	6	0
140	YACBEN	Cash Benefit	Character	UDC (05 YN)	1	0	Allow NULL?
141	YADOBM	Birthday - Month	Numeric	Generic Edit	2	0	Allow NULL?
142	YADSTM	Startdate - Month	Numeric	Generic Edit	2	0	Allow NULL?
143	YAPSAL	Rate - Previous Salary	Numeric	Generic Edit	11	2	Allow NULL?
144	YAHIPN	Medical Plan ID	String	Generic Edit	11	0	Allow NULL?
145	YACM	Credit Message	String	UDC (00 CM)	2	0	Allow NULL?
146	YALSAL	Rate - Life Ins. Annual Salary	Numeric	Generic Edit	13	2	Allow NULL?
147	YADIVC	Benefit Group	String	Generic Edit	6	0	Allow NULL?
148	YAVSHF	Shares Flag - Voting	Character	UDC (05 YN)	1	0	Allow NULL?
149	YAPYRV	Prior Years for Calculating Vesting	Numeric	Generic Edit	5	3	Allow NULL?
150	YAANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
151	YAPGRD	Pay Grade	String	Generic Edit	6	0	Allow NULL?
152	YAPGRS	Pay Grade Step	String	Generic Edit	4	0	Allow NULL?
153	YASLOC	Salary Data Locality	String	UDC (06 SL)	8	0	Allow NULL?
154	YANRVW	Date - Next Review	Date	Generic Edit	6	0
155	YATINC	Type of Increase Next Review	Character	UDC (06 RV)	1	0	Allow NULL?
156	YAHM01	EEO - I9 Status	Character	UDC (07 HN)	1	0	Allow NULL?
157	YAHM02	EEO - Veteran	Character	UDC (05 HO)	1	0	Allow NULL?
158	YAHM03	EEO - Disabled Veteran	Character	UDC (05 HP)	1	0	Allow NULL?
159	YAHM04	EEO - Disability	Character	UDC (05 HQ)	1	0	Allow NULL?
160	YAPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
161	YAED01	Date - User Defined1	Date	Generic Edit	6	0
162	YAED02	Date - User Defined2	Date	Generic Edit	6	0
163	YAED03	Date - User Defined3	Date	Generic Edit	6	0
164	YAED04	Date - User Defined4	Date	Generic Edit	6	0
165	YAED05	Date - User Defined5	Date	Generic Edit	6	0
166	YAED06	Date - User Defined6	Date	Generic Edit	6	0
167	YAED07	Date - User Defined7	Date	Generic Edit	6	0
168	YAED08	Date - User Defined8	Date	Generic Edit	6	0
169	YAED09	Date - User Defined9	Date	Generic Edit	6	0
170	YAED10	Date - User Defined10	Date	Generic Edit	6	0
171	YAED11	Date - User Defined11	Date	Generic Edit	6	0
172	YAED12	Date - User Defined12	Date	Generic Edit	6	0
173	YAED13	Date - User Defined13	Date	Generic Edit	6	0
174	YAED14	Date - User Defined14	Date	Generic Edit	6	0
175	YAED15	Date - User Defined15	Date	Generic Edit	6	0
176	YAED16	Date - User Defined16	Date	Generic Edit	6	0
177	YAED17	Date - User Defined17	Date	Generic Edit	6	0
178	YAED18	Date - User Defined18	Date	Generic Edit	6	0
179	YAED19	Date - User Defined19	Date	Generic Edit	6	0
180	YAED20	Date - User Defined20	Date	Generic Edit	6	0
181	YADEPT	Department Code	String	Generic Edit	12	0	Allow NULL?
182	YAFAGE	Age - Employee	Numeric	Generic Edit	3	0	Allow NULL?
183	YAFSAL	Rate - Life Ins. Annual Salary	Numeric	Generic Edit	15	2	Allow NULL?
184	YAADSD	Date - Adjusted Service Date	Date	Generic Edit	6	0
185	YACMPA	Compa-Ratio	Numeric	Generic Edit	5	2	Allow NULL?
186	YAEPNT	Job Evaluation Points	Numeric	Generic Edit	5	0	Allow NULL?
187	YAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
188	YAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
189	YAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
190	YAUPMJ	Date - Updated	Date	Generic Edit	6	0
191	YAK001	401(k) Non-Discrimination Test1	Character	Generic Edit (05 OO)	1	0	Allow NULL?
192	YAK002	401(k) Non-Discrimination Test2	Character	Generic Edit (05 YB)	1	0	Allow NULL?
193	YAK003	401(k) Non-Discrimination Test3	Character	Generic Edit (05 YB)	1	0	Allow NULL?
194	YAK004	401(k) Non-Discrimination Test4	Character	Generic Edit (05 YB)	1	0	Allow NULL?
195	YAK005	401(k) Non-Discrimination Test5	Character	Generic Edit (05 YB)	1	0	Allow NULL?
196	YAK006	401(k) Non-Discrimination Test6	Character	Generic Edit (05 YB)	1	0	Allow NULL?
197	YAK007	401(k) Non-Discrimination Test7	Character	Generic Edit (05 YB)	1	0	Allow NULL?
198	YAK008	401(k) Non-Discrimination Test8	Character	Generic Edit (05 YB)	1	0	Allow NULL?
199	YAK009	401(k) Non-Discrimination Test9	Character	Generic Edit (05 YB)	1	0	Allow NULL?
200	YAK010	401(k) Non-Discrimination Test10	Character	Generic Edit (05 YB)	1	0	Allow NULL?
201	YAATPY	Payroll Autopay Paytype	Numeric	UDC (06 20)	3	0	Allow NULL?
202	YAPENS	Pension Code	Character	UDC (05 YB)	1	0	Allow NULL?
203	YAORG	Orgeon Insurance	Character	UDC (05A OR)	1	0	Allow NULL?
204	YABENS	Employee Benefit Status	Character	UDC (06 EA)	1	0	Allow NULL?
205	YAFTE	Full Time Equivalents	Numeric	Generic Edit	9	2	Allow NULL?
206	YAAAF	Vacation Factor	Character	UDC (07 AA)	1	0	Allow NULL?
207	YASUI	Source of SUI Reporting	Character	UDC (05 SR)	1	0	Allow NULL?
208	YADTSF	Salary Forecast Change Date	Date	Generic Edit	6	0
209	YASMOY	Periods Paid Per Year	Numeric	Generic Edit	5	2	Allow NULL?
210	YALDID	Labor Distribution Period ID	String	UDC (05T LD)	5	0	Allow NULL?
211	YATTAR	Total Time Accounting Rules	Character	UDC (05T TA)	1	0	Allow NULL?

TOP 920 | 05A | F060116 INDEXES

Number

Description

AddressNumber (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

Social Security Number

Element	Alias	Description	Sequence
1	SSN	Employee Tax ID	Ascending

Home BU Job Code +A

Element	Alias	Description	Sequence
1	HMCU	Business Unit - Home	Ascending
2	JBCD	Job Type (Craft) Code	Ascending
3	JBST	Job Step	Descending
4	ALPH	Name - Alpha	Ascending

Job Code Job Step +A

Element	Alias	Description	Sequence
1	JBCD	Job Type (Craft) Code	Ascending
2	JBST	Job Step	Descending
3	ALPH	Name - Alpha	Ascending

PR Lockout ID Update Flag

Element	Alias	Description	Sequence
1	USR	Payroll Lockout Identification	Ascending
2	UFLG	Update Flag	Ascending

Date Next Rev Supervisor +A

Element	Alias	Description	Sequence
1	NRVW	Date - Next Review	Ascending
2	ANPA	Supervisor	Ascending
3	TINC	Type of Increase Next Review	Ascending

Supervisor Type of Inc +A

Element	Alias	Description	Sequence
1	ANPA	Supervisor	Ascending
2	TINC	Type of Increase Next Review	Ascending
3	NRVW	Date - Next Review	Ascending

Type of Inc Supervisor +A

Element	Alias	Description	Sequence
1	TINC	Type of Increase Next Review	Ascending
2	ANPA	Supervisor	Ascending
3	NRVW	Date - Next Review	Ascending

Home BU Check Route Code +A (Unique)

Element	Alias	Description	Sequence
1	HMCU	Business Unit - Home	Ascending
2	MAIL	Routing Code - Check	Ascending
3	AN8	Address Number	Ascending

Supervisor Address Number (Unique)

Element	Alias	Description	Sequence
1	ANPA	Supervisor	Ascending
2	AN8	Address Number	Ascending

Address Number Supervisor (Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	ANPA	Supervisor	Ascending

Address Number Job Type A+

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	JBCD	Job Type (Craft) Code	Ascending
3	JBST	Job Step	Ascending

Alternate Employee Number

Element	Alias	Description	Sequence
1	OEMP	Additional Employee No	Ascending

Company Home Union Code A+

Element	Alias	Description	Sequence
1	HMCO	Company - Home	Ascending
2	UN	Union Code	Ascending
3	HMCU	Business Unit - Home	Ascending
4	AN8	Address Number	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

211 COLUMNS | 14 INDEXES | 920 | 05A | F060116 TABLE

TOP 920 | 05A | F060116 COLUMNS

TOP 920 | 05A | F060116 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

211 COLUMNS | 14 INDEXES | 920 | 05A | F060116 TABLE

TOP920 | 05A | F060116 COLUMNS

TOP920 | 05A | F060116 INDEXES

TOP 920 | 05A | F060116 COLUMNS

TOP 920 | 05A | F060116 INDEXES