	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

213 COLUMNS | 1 INDEXES | 920 | 05A | F0601161 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05A: PeopleSoft HR & PR Foundation
1	920	F0601161	PT	213	1	Point-In-Time Employee Master	History 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 PTEFTO, PTSVER, PTAN8, PTALPH, PTSSN, PTOEMP, PTSEX, PTMSTX, PTMSTI, PTWSPS, PTEIC, PTNDEP, PTEST, PTECNT, PTTARR, PTTARA, PTSCDC, PTHMST, PTWKSE, PTHMLC, PTLWK1, PTLWK2, PTHMCO, PTMCU, PTHMCU, PTSG, PTMAIL, PTPAST, PTPFRQ, PTSALY, PTPYCB, PTBCB, PTUN, PTJBCD, PTJBST, PTEEOJ, PTEEOM, PTTRS, PTWCMP, PTFLSA, PTWS, PTSHFT, PTLMTH, PTPBRT, PTLF, PTSAL, PTPHRT, PTPPRT, PTPWRN, PTHRTN, PTBRTN, PTSALN, PTSTDH, PTSTDD, PTSDYY, PTUSR, PTUFLG, PTNS, PTIFN, PTIMN, PTDOB, PTDSI, PTDT, PTDST, PTPSDT, PTPTDT, PTNRDT, PTNBDT, PTNPDT, PTLCDT, PTDR, PTCTDT, PTLADT, PTBSDT, PTCPDT, PTFICM, PTP001, PTP002, PTP003, PTP004, PTP005, PTP006, PTP007, PTP008, PTP009, PTP010, PTP011, PTP012, PTP013, PTP014, PTP015, PTP016, PTP017, PTP018, PTP019, PTP020, PTE001, PTE002, PTE003, PTE004, PTE005, PTE006, PTE007, PTE008, PTE009, PTE010, PTICC, PTNMAX, PTSOCC, PTIUSR, PTITRM, PTINBT, PTREGN, PTPSTP, PTIH, PTCCPR, PTADPN, PTTCNF, PTRAF, PTTIPE, PTRCCD, PTBDRT, PTBORN, PTNBDR, PTWET, PTAFLG, PTRMST, PTLMST, PTSMKR, PTCBAC, PTCBAF, PTPCCD, PTRCDT, PTLSDT, PTPADT, PTPYMH, PTUYST, PTDTSP, PTANN8, PTPPNB, PTPYDT, PTCBEN, PTDOBM, PTDSTM, PTPSAL, PTHIPN, PTCM, PTLSAL, PTDIVC, PTVSHF, PTPYRV, PTANPA, PTPGRD, PTPGRS, PTSLOC, PTNRVW, PTTINC, PTHM01, PTHM02, PTHM03, PTHM04, PTPOS, PTED01, PTED02, PTED03, PTED04, PTED05, PTED06, PTED07, PTED08, PTED09, PTED10, PTED11, PTED12, PTED13, PTED14, PTED15, PTED16, PTED17, PTED18, PTED19, PTED20, PTDEPT, PTFAGE, PTFSAL, PTADSD, PTCMPA, PTEPNT, PTJOBN, PTUSER, PTPID, PTUPMJ, PTK001, PTK002, PTK003, PTK004, PTK005, PTK006, PTK007, PTK008, PTK009, PTK010, PTATPY, PTPENS, PTORG, PTBENS, PTFTE, PTAAF, PTSUI, PTDTSF, PTSMOY, PTLDID, PTTTAR FROM F0601161

TOP 920 | 05A | F0601161 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PTEFTO	Date - Effective On	Date	Generic Edit	6	0
2	PTSVER	Snapshot Version	String	Generic Edit	10	0	Allow NULL?
3	PTAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
4	PTALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
5	PTSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
6	PTOEMP	Additional Employee No	String	Generic Edit	8	0	Allow NULL?
7	PTSEX	Gender (Male/Female)	Character	UDC (07 SG)	1	0	Allow NULL?
8	PTMSTX	Marital Status - Tax	Character	UDC (06 MS)	1	0	Allow NULL?
9	PTMSTI	Marital Status - State Tax	Character	UDC (06 MS)	1	0	Allow NULL?
10	PTWSPS	Residency Status	Character	UDC (05 WS)	1	0	Allow NULL?
11	PTEIC	Earned Income Credit Status	Character	UDC (05 EI)	1	0	Allow NULL?
12	PTNDEP	Dependents	Numeric	Generic Edit	2	0	Allow NULL?
13	PTEST	Employment Status	Character	UDC (06 ES)	1	0	Allow NULL?
14	PTECNT	Employee Classification Status	Character	UDC (05A EC)	1	0	Allow NULL?
15	PTTARR	Tax Area (Residence)	String	Generic Edit	10	0	Allow NULL?
16	PTTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
17	PTSCDC	School District Code	Numeric	UDC (07 SS)	5	0	Allow NULL?
18	PTHMST	State - Home	String	UDC (06 SC)	3	0	Allow NULL?
19	PTWKSE	State - Working	String	UDC (06 SC)	3	0	Allow NULL?
20	PTHMLC	Location - Home City	String	UDC (06 W1)	3	0	Allow NULL?
21	PTLWK1	Location - Work City	String	UDC (06 W1)	3	0	Allow NULL?
22	PTLWK2	Location - Work County	String	UDC (06 W2)	3	0	Allow NULL?
23	PTHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
24	PTMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
25	PTHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
26	PTSG	Last Job Worked	String	Generic Edit	12	0	Allow NULL?
27	PTMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
28	PTPAST	Employee Pay Status	Character	UDC (06 PS)	1	0	Allow NULL?
29	PTPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
30	PTSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
31	PTPYCB	Pay Cycle Bypass Count	Numeric	Generic Edit	2	0	Allow NULL?
32	PTBCB	Benefit Cycle Bypass Count	Numeric	Generic Edit	2	0	Allow NULL?
33	PTUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
34	PTJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
35	PTJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
36	PTEEOJ	Job Category (EEO)	String	UDC (06 J)	3	0	Allow NULL?
37	PTEEOM	Ethnic Code	String	UDC (06 M)	2	0	Allow NULL?
38	PTTRS	Change Reason	String	UDC (06 T)	3	0	Allow NULL?
39	PTWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
40	PTFLSA	FLSA Exempt Y/N	Character	UDC (05 FL)	1	0	Allow NULL?
41	PTWS	Work Schedule Code	Character	UDC (05A WS)	1	0	Allow NULL?
42	PTSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
43	PTLMTH	Labor Distribution Method	Character	UDC (07 LT)	1	0	Allow NULL?
44	PTPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
45	PTLF	Labor Distribution Multiplier	Numeric	Generic Edit	5	4	Allow NULL?
46	PTSAL	Rate - Salary Annual	Numeric	Generic Edit	11	2	Allow NULL?
47	PTPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
48	PTPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
49	PTPWRN	Rate (Piecework)at Next Raise	Numeric	Generic Edit	9	3	Allow NULL?
50	PTHRTN	Rate (Hourly) at Next Raise	Numeric	Generic Edit	9	3	Allow NULL?
51	PTBRTN	Rate (Billing) at Next Raise	Numeric	Generic Edit	9	3	Allow NULL?
52	PTSALN	Rate - Salary at Next Raise	Numeric	Generic Edit	11	2	Allow NULL?
53	PTSTDH	Hours - Standard per Payperiod	Numeric	Generic Edit	5	2	Allow NULL?
54	PTSTDD	Hours - Standard per Day	Numeric	Generic Edit	5	2	Allow NULL?
55	PTSDYY	Days - Standard per Year	Numeric	Generic Edit	5	2	Allow NULL?
56	PTUSR	Payroll Lockout Identification	String	Generic Edit	18	0	Allow NULL?
57	PTUFLG	Update Flag	Character	Generic Edit	1	0	Allow NULL?
58	PTNS	Work Tax Area Source	Character	UDC (05 NS)	1	0	Allow NULL?
59	PTIFN	Initial - First Name (Govt Rpts)	Character	Generic Edit	1	0	Allow NULL?
60	PTIMN	Initial - Middle Name (Govt Rpts)	Character	Generic Edit	1	0	Allow NULL?
61	PTDOB	Date - Birth	Date	Generic Edit	6	0
62	PTDSI	Date - Original Employment	Date	Generic Edit	6	0
63	PTDT	Date - Terminated	Date	Generic Edit	6	0
64	PTDST	Date Started	Date	Generic Edit	6	0
65	PTPSDT	Date - Pay Starts	Date	Generic Edit	6	0
66	PTPTDT	Date - Pay Stops	Date	Generic Edit	6	0
67	PTNRDT	Date - Next Raise	Date	Generic Edit	6	0
68	PTNBDT	Date - New Bill Rate	Date	Generic Edit	6	0
69	PTNPDT	Date - New Piecerate	Date	Generic Edit	6	0
70	PTLCDT	Date - Last Check	Date	Generic Edit	6	0
71	PTDR	Date - Last Raise	Date	Generic Edit	6	0
72	PTCTDT	Date - Last Contact	Date	Generic Edit	6	0
73	PTLADT	Date - LOA Expiration Date	Date	Generic Edit	6	0
74	PTBSDT	Date - Bonus	Date	Generic Edit	6	0
75	PTCPDT	Date - Current Position	Date	Generic Edit	6	0
76	PTFICM	Tax Calc Method	Character	UDC (06 TM)	1	0	Allow NULL?
77	PTP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
78	PTP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
79	PTP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
80	PTP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
81	PTP005	Category Codes - Payroll5	String	UDC (06 05)	3	0	Allow NULL?
82	PTP006	Category Codes - Payroll6	String	UDC (06 06)	3	0	Allow NULL?
83	PTP007	Category Codes - Payroll7	String	UDC (06 07)	3	0	Allow NULL?
84	PTP008	Category Codes - Payroll8	String	UDC (06 08)	3	0	Allow NULL?
85	PTP009	Category Codes - Payroll9	String	UDC (06 09)	3	0	Allow NULL?
86	PTP010	Category Codes - Payroll10	String	UDC (06 10)	3	0	Allow NULL?
87	PTP011	Category Codes - Payroll11	String	UDC (06 11)	3	0	Allow NULL?
88	PTP012	Category Codes - Payroll12	String	UDC (06 12)	3	0	Allow NULL?
89	PTP013	Category Codes - Payroll13	String	UDC (06 13)	3	0	Allow NULL?
90	PTP014	Category Codes - Payroll14	String	UDC (06 14)	3	0	Allow NULL?
91	PTP015	Category Codes - Payroll15	String	UDC (06 15)	3	0	Allow NULL?
92	PTP016	Category Codes - Payroll16	String	UDC (06 16)	3	0	Allow NULL?
93	PTP017	Category Codes - Payroll17	String	UDC (06 17)	3	0	Allow NULL?
94	PTP018	Category Codes - Payroll18	String	UDC (06 18)	3	0	Allow NULL?
95	PTP019	Category Codes - Payroll19	String	UDC (06 19)	3	0	Allow NULL?
96	PTP020	Category Codes - Payroll20	String	UDC (06 21)	3	0	Allow NULL?
97	PTE001	Eligibility Code 001	Character	UDC (05 YB)	1	0	Allow NULL?
98	PTE002	Eligibility Code 002	Character	UDC (05 YB)	1	0	Allow NULL?
99	PTE003	Eligibility Code 003	Character	UDC (05 YB)	1	0	Allow NULL?
100	PTE004	Eligibility Code 004	Character	UDC (05 YB)	1	0	Allow NULL?
101	PTE005	Eligibility Code 005	Character	UDC (05 YB)	1	0	Allow NULL?
102	PTE006	Eligibility Code 006	Character	UDC (05 YB)	1	0	Allow NULL?
103	PTE007	Eligibility Code 007	Character	UDC (05 YB)	1	0	Allow NULL?
104	PTE008	Eligibility Code 008	Character	UDC (05 YB)	1	0	Allow NULL?
105	PTE009	Eligibility Code 009	Character	UDC (05 YB)	1	0	Allow NULL?
106	PTE010	Eligibility Code 010	Character	UDC (05 YB)	1	0	Allow NULL?
107	PTICC	Interim Check Code	Character	UDC (07 IC)	1	0	Allow NULL?
108	PTNMAX	Amount - Maximum Net Pay	Numeric	Generic Edit	15	2	Allow NULL?
109	PTSOCC	Standard Occupational Class Code	String	UDC (06 SO)	4	0	Allow NULL?
110	PTIUSR	User ID - Interim Check Enterer	String	Generic Edit	10	0	Allow NULL?
111	PTITRM	Terminal Id - Interim Check	String	Generic Edit	10	0	Allow NULL?
112	PTINBT	Interim Processing Batch Flag	Character	UDC	1	0	Allow NULL?
113	PTREGN	Region	String	UDC (06 RG)	3	0	Allow NULL?
114	PTPSTP	No. of Pay Grade Steps	String	Generic Edit	4	0	Allow NULL?
115	PTIH	Hours per Standard Year	Numeric	Generic Edit	7	2	Allow NULL?
116	PTCCPR	Country Code	String	UDC (00 CN)	3	0	Allow NULL?
117	PTADPN	Pre-Note Code	Character	UDC (07 AE)	1	0	Allow NULL?
118	PTTCNF	Third Country National Flag	Character	Generic Edit	1	0	Allow NULL?
119	PTRAF	Resident Alien Flag	Character	Generic Edit	1	0	Allow NULL?
120	PTTIPE	Employee Code - Tipped(Y/N)	Character	UDC (05 YN)	1	0	Allow NULL?
121	PTRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
122	PTBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
123	PTBORN	Rate - New Recharge Burden Rate	Numeric	Generic Edit	9	3	Allow NULL?
124	PTNBDR	Date - New Bill Rate	Date	Generic Edit	6	0
125	PTWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
126	PTAFLG	Address Flag	Character	Generic Edit	1	0	Allow NULL?
127	PTRMST	Marital Status - Resident State	Character	UDC (06 MS)	1	0	Allow NULL?
128	PTLMST	Local Area Marital Status	Character	UDC (06 MS)	1	0	Allow NULL?
129	PTSMKR	Flag - Language Preference	String	UDC (07 SN)	2	0	Allow NULL?
130	PTCBAC	Amount - Cash Accumulator	Numeric	Generic Edit	3	2	Allow NULL?
131	PTCBAF	Flag - Cash Rounding	Character	Generic Edit	1	0	Allow NULL?
132	PTPCCD	Pay Cycle Code	String	UDC (06 PY)	5	0	Allow NULL?
133	PTRCDT	Date - Employee Recall	Date	Generic Edit	6	0
134	PTLSDT	Date - LOA Beginning Date	Date	Generic Edit	6	0
135	PTPADT	Date - Participation	Date	Generic Edit	6	0
136	PTPYMH	Method - Employee Payment	Character	UDC	1	0	Allow NULL?
137	PTUYST	Processed Code - Payroll	Character	UDC	1	0	Allow NULL?
138	PTDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
139	PTANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
140	PTPPNB	Pay Period Number	String	Generic Edit	3	0	Allow NULL?
141	PTPYDT	Date - Pay Cycle Processed	Date	Generic Edit	6	0
142	PTCBEN	Cash Benefit	Character	UDC (05 YN)	1	0	Allow NULL?
143	PTDOBM	Birthday - Month	Numeric	Generic Edit	2	0	Allow NULL?
144	PTDSTM	Startdate - Month	Numeric	Generic Edit	2	0	Allow NULL?
145	PTPSAL	Rate - Previous Salary	Numeric	Generic Edit	11	2	Allow NULL?
146	PTHIPN	Medical Plan ID	String	Generic Edit	11	0	Allow NULL?
147	PTCM	Credit Message	String	UDC (00 CM)	2	0	Allow NULL?
148	PTLSAL	Rate - Life Ins. Annual Salary	Numeric	Generic Edit	13	2	Allow NULL?
149	PTDIVC	Benefit Group	String	Generic Edit	6	0	Allow NULL?
150	PTVSHF	Shares Flag - Voting	Character	UDC (05 YN)	1	0	Allow NULL?
151	PTPYRV	Prior Years for Calculating Vesting	Numeric	Generic Edit	5	3	Allow NULL?
152	PTANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
153	PTPGRD	Pay Grade	String	Generic Edit	6	0	Allow NULL?
154	PTPGRS	Pay Grade Step	String	Generic Edit	4	0	Allow NULL?
155	PTSLOC	Salary Data Locality	String	UDC (06 SL)	8	0	Allow NULL?
156	PTNRVW	Date - Next Review	Date	Generic Edit	6	0
157	PTTINC	Type of Increase Next Review	Character	UDC (06 RV)	1	0	Allow NULL?
158	PTHM01	EEO - I9 Status	Character	UDC (07 HN)	1	0	Allow NULL?
159	PTHM02	EEO - Veteran	Character	UDC (05 HO)	1	0	Allow NULL?
160	PTHM03	EEO - Disabled Veteran	Character	UDC (05 HP)	1	0	Allow NULL?
161	PTHM04	EEO - Disability	Character	UDC (05 HQ)	1	0	Allow NULL?
162	PTPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
163	PTED01	Date - User Defined1	Date	Generic Edit	6	0
164	PTED02	Date - User Defined2	Date	Generic Edit	6	0
165	PTED03	Date - User Defined3	Date	Generic Edit	6	0
166	PTED04	Date - User Defined4	Date	Generic Edit	6	0
167	PTED05	Date - User Defined5	Date	Generic Edit	6	0
168	PTED06	Date - User Defined6	Date	Generic Edit	6	0
169	PTED07	Date - User Defined7	Date	Generic Edit	6	0
170	PTED08	Date - User Defined8	Date	Generic Edit	6	0
171	PTED09	Date - User Defined9	Date	Generic Edit	6	0
172	PTED10	Date - User Defined10	Date	Generic Edit	6	0
173	PTED11	Date - User Defined11	Date	Generic Edit	6	0
174	PTED12	Date - User Defined12	Date	Generic Edit	6	0
175	PTED13	Date - User Defined13	Date	Generic Edit	6	0
176	PTED14	Date - User Defined14	Date	Generic Edit	6	0
177	PTED15	Date - User Defined15	Date	Generic Edit	6	0
178	PTED16	Date - User Defined16	Date	Generic Edit	6	0
179	PTED17	Date - User Defined17	Date	Generic Edit	6	0
180	PTED18	Date - User Defined18	Date	Generic Edit	6	0
181	PTED19	Date - User Defined19	Date	Generic Edit	6	0
182	PTED20	Date - User Defined20	Date	Generic Edit	6	0
183	PTDEPT	Department Code	String	Generic Edit	12	0	Allow NULL?
184	PTFAGE	Age - Employee	Numeric	Generic Edit	3	0	Allow NULL?
185	PTFSAL	Rate - Life Ins. Annual Salary	Numeric	Generic Edit	15	2	Allow NULL?
186	PTADSD	Date - Adjusted Service Date	Date	Generic Edit	6	0
187	PTCMPA	Compa-Ratio	Numeric	Generic Edit	5	2	Allow NULL?
188	PTEPNT	Job Evaluation Points	Numeric	Generic Edit	5	0	Allow NULL?
189	PTJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
190	PTUSER	User ID	String	Generic Edit	10	0	Allow NULL?
191	PTPID	Program ID	String	Generic Edit	10	0	Allow NULL?
192	PTUPMJ	Date - Updated	Date	Generic Edit	6	0
193	PTK001	401(k) Non-Discrimination Test1	Character	Generic Edit (05 OO)	1	0	Allow NULL?
194	PTK002	401(k) Non-Discrimination Test2	Character	Generic Edit (05 YB)	1	0	Allow NULL?
195	PTK003	401(k) Non-Discrimination Test3	Character	Generic Edit (05 YB)	1	0	Allow NULL?
196	PTK004	401(k) Non-Discrimination Test4	Character	Generic Edit (05 YB)	1	0	Allow NULL?
197	PTK005	401(k) Non-Discrimination Test5	Character	Generic Edit (05 YB)	1	0	Allow NULL?
198	PTK006	401(k) Non-Discrimination Test6	Character	Generic Edit (05 YB)	1	0	Allow NULL?
199	PTK007	401(k) Non-Discrimination Test7	Character	Generic Edit (05 YB)	1	0	Allow NULL?
200	PTK008	401(k) Non-Discrimination Test8	Character	Generic Edit (05 YB)	1	0	Allow NULL?
201	PTK009	401(k) Non-Discrimination Test9	Character	Generic Edit (05 YB)	1	0	Allow NULL?
202	PTK010	401(k) Non-Discrimination Test10	Character	Generic Edit (05 YB)	1	0	Allow NULL?
203	PTATPY	Payroll Autopay Paytype	Numeric	UDC (06 20)	3	0	Allow NULL?
204	PTPENS	Pension Code	Character	UDC (05 YB)	1	0	Allow NULL?
205	PTORG	Orgeon Insurance	Character	UDC (05A OR)	1	0	Allow NULL?
206	PTBENS	Employee Benefit Status	Character	UDC (06 EA)	1	0	Allow NULL?
207	PTFTE	Full Time Equivalents	Numeric	Generic Edit	9	2	Allow NULL?
208	PTAAF	Vacation Factor	Character	UDC (07 AA)	1	0	Allow NULL?
209	PTSUI	Source of SUI Reporting	Character	UDC (05 SR)	1	0	Allow NULL?
210	PTDTSF	Salary Forecast Change Date	Date	Generic Edit	6	0
211	PTSMOY	Periods Paid Per Year	Numeric	Generic Edit	5	2	Allow NULL?
212	PTLDID	Labor Distribution Period ID	String	UDC (05T LD)	5	0	Allow NULL?
213	PTTTAR	Total Time Accounting Rules	Character	UDC (05T TA)	1	0	Allow NULL?

TOP 920 | 05A | F0601161 INDEXES

Number

Description

F0601161_1 (Primary/Unique)

Element	Alias	Description	Sequence
1	EFTO	Date - Effective On	Ascending
2	SVER	Snapshot Version	Ascending
3	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

213 COLUMNS | 1 INDEXES | 920 | 05A | F0601161 TABLE

TOP 920 | 05A | F0601161 COLUMNS

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

213 COLUMNS | 1 INDEXES | 920 | 05A | F0601161 TABLE

TOP920 | 05A | F0601161 COLUMNS

TOP920 | 05A | F0601161 INDEXES

TOP 920 | 05A | F0601161 COLUMNS

TOP 920 | 05A | F0601161 INDEXES