Employee Master File

Import File: SVEM0001.CSV (Comma) or SVEM0001.TXT (Tab)
Warehouse File: SV_Employee_IMP_WHSE
Destination Files: UPR_MSTR (UPR00100), UPR_MSTR_Pay_Type (UPR00400), SV_Lookup_Tech_MSTR (SV00115)

*Indicates validated fields, and must contain data.

**Indicates validated, but can be left empty.

If 'Technician' (93, CO) is empty, it will be set to the 'Employee ID' (32,AF).

'Base Pay Record' (45,AS) is not validated.
'Pay Unit' (47,AU) must be present if a 'Pay Type' (44,AR) of 1 or 3 is entered.
'Base Pay Record' (45,AS) must be present if a 'Pay Type' (44,AR) of 6, 7, 8, or 9 is entered.

Tab Position (.txt file)	Excel Column (.csv file)	Field Name	Storage Type	Keyable	Storage
1	A	*Employee ID	String	15	16
2	B	*Pay Record (Pay Code)	String	6	8
3	C	Employee Class	String	15	16
4	D	Inactive	checkbox	1	2
5	E	*Last Name	String	20	22
6	F	*First Name	String	15	16
7	G	Middle Name	String	15	16
8	H	Address 1	String	30	32
9	I	Address 2	String	30	32
10	J	City	String	30	32
11	K	State	String	4	30
12	L	Country	String	20	22
13	M	Zip Code	String	10	12
14	N	Phone Number	String	14	22
15	O	*Social Security Number	String	15	16
16	P	Birth Date	Date	6	4
17	Q	Gender	Drop-Down List 1 = Male 2 = Female	6	2
18	R	Ethnic Origin	Drop-Down List 1 = Caucasian 2 = Native American 3 = Black 4 = Asian 5 = Hispanic 6 = Other	15	2
19	S	Part Time	checkbox	1	2
20	T	*Department	String	6	8
21	U	*Job Title	String	6	8
22	V	Which Cash Account For Pay	Radio Group	0	2
23	W	Account Index	Long Integer	14	4
24	X	*Work Hours Per Year	Integer	4	2
25	Y	Start Date	Date	6	4
26	Z	Date Employee Inactivated	Date	8	4
27	AA	Reason Employee Inactivated	String	30	32
28	AB	Minimum Net Pay	Currency	14	10
29	AC	Suta State	String	2	4
30	AD	Workers Comp	String	6	8
31	AE	Auto Accrue Vacation	checkbox	16	2
32	AF	Vacation Accrual Amount	Long Integer	6	4
33	AG	Vacation Accrual Method	Radio Group	0	2
34	AH	Vacation Hours Per Year	Long Integer	6	4
35	AI	Vacation Available	Long Integer	6	4
36	AJ	Auto Accrue Sick Time	checkbox	1	2
37	AK	Sick Time Accrual Method	Radio Group	0	2
38	AL	Sick Time Accrual Amount	Long Integer	6	4
39	AM	Sick Time Available	Long Integer	6	4
40	AN	Sick Time Hours Per Year	Long Integer	6	4
41	AO	User Defined 1	String	20	22
42	AP	User Defined 2	String	20	22
43	AQ	Note Index	Currency	14	10
44	AR	*Pay Type	Drop-Down List 1 = Hourly 2 = Salary 3 = Piecework 4 = Commission 5 = Business Expense 6 = Overtime 7 = Double Time 8 = Vacation 9 = Sick 10 = Holiday 11 = Pension 12 = Other 13 = Earned Inc. Credit 14 = Charged Tips 15 = Reported Tips 16 = Min. Wage Bal.	20	2
45	AS	Base Pay Record	String	6	8
46	AT	*Pay Rate Amount	Currency	14	10
47	AU	Pay Unit	String	25	26
48	AV	Pay Unit Period	Drop-Down List 1 = Weekly 2 = Biweekly 3 = Semimonthly 4 = Monthly 5 = Quarterly 6 = Semiannually 7 = Annually 8 = Daily/Misc.	19	2
49	AW	Report As Wages	checkbox	1	2
50	AX	Taxable	checkbox	1	2
51	AY	Subject To Federal Tax	checkbox	1	2
52	AZ	Subject To Social Security	checkbox	1	2
53	BA	Subject To Medicare	checkbox	1	2
54	BB	Subject To State Tax	checkbox	1	2
55	BC	Subject To Local Tax	checkbox	1	2
56	BD	Subject To Futa	checkbox	1	2
57	BE	Subject To Suta	checkbox	1	2
58	BF	Flat Federal Tax Rate	Integer	4	2
59	BG	Flat State Tax Rate	Integer	4	2
60	BH	Pay Period	Drop-Down List 1 = Weekly 2 = Biweekly 3 = Semimonthly 4 = Monthly 5 = Quarterly 6 = Semiannually 7 = Annually 8 = Daily/Misc.	19	2
61	BI	Pay Per Period	Currency	14	10
62	BJ	Max Pay Per Period	Currency	14	10
63	BK	Pay Advance	Currency	14	10
64	BL	Accrue Vacation	checkbox	1	2
65	BM	Accrue Sick Time	checkbox	1	2
66	BN	W2 Box Number	Integer	2	2
67	BO	W2 Box Label	String	6	8
68	BP	Pay Advance Taken	Currency	14	10
69-80	BQ-CB	MTD Hours	Long Integer	6	4
81-92	CC-CN	MTD Wages	Currency	14	10
93	CO	Technician	String	10	12
94	CP	**Technician Team	String	15	16
95	CQ	Vendor Switch	checkbox	1	2
96	CR	Vendor ID	String	15	16
97	CS	**Branch Name	String	40	42