Assurity Template.xls

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI
1	Employee SSN	EID	Prefix	First	MI	Last	Suffix	DOB	Sex	Marital Status	Country	Address 1	Address 2	Address 3	City	State	Zip	Home Phone	Mobile Phone	Work Phone	Email	Personal Email	Payroll Frequency	Deduction Frequency	Gross Salary	Location Number	Location	Job Class	Pay Group	Department Number	Department	Title	FTE	Hours Per Week	Hire date	Eligibility Date	Status	Enrollment Status	Termination date	Event date	PIN	Require PIN Change	As Of	Session UserID	Session City	Session State	Hourly Wage	PTO Balance	PTO Cost	Mailing Country	Mailing Address 1	Mailing Address 2	Mailing City	Mailing State	Mailing Zip	Country of Citizenship	Event Code	Event Description	User ID	Birth Country	Send invite

2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100