|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
emp__chr01
|
|
|
x(8)
|
|
|
|
emp__chr02
|
|
|
x(8)
|
|
|
|
emp__chr03
|
|
|
x(8)
|
|
|
|
emp__chr04
|
|
|
x(8)
|
|
|
|
emp__chr05
|
|
|
x(8)
|
|
|
|
emp__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
emp__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
emp__dte01
|
|
|
99/99/99
|
|
|
|
emp__dte02
|
|
|
99/99/99
|
|
|
|
emp__dte03
|
|
|
99/99/99
|
|
|
|
emp__dte04
|
|
|
99/99/99
|
|
|
|
emp__dte05
|
|
|
99/99/99
|
|
|
|
emp__log01
|
|
|
yes/no
|
|
|
|
emp__log02
|
|
|
yes/no
|
|
|
|
emp__qad01
|
|
|
x(8)
|
|
|
|
emp__qad02
|
|
|
x(4)
|
|
|
|
emp_active
|
Active
|
|
yes/no
|
|
|
|
emp_ad_acc1
|
Acct 1
|
|
x(20)
|
|
|
|
emp_ad_acc2
|
Acct 2
|
|
x(20)
|
|
|
|
emp_ad_amt1
|
Deposit Amount
|
Amount
|
>>>,>>9.99
|
10
|
|
|
emp_ad_amt2
|
Deposit Amount
|
Amount
|
>>>,>>9.99
|
10
|
|
|
emp_ad_bank
|
Auto Deposit Bank 1
|
Auto Bk1
|
x(8)
|
|
|
|
emp_ad_bank2
|
Auto Deposit Bank 2
|
Auto Bk2
|
x(8)
|
|
|
|
emp_ad_pct1
|
Percentage
|
Pct
|
>>9.99
|
10
|
|
|
emp_ad_pct2
|
Percentage
|
Pct
|
>>9.99
|
10
|
|
|
emp_ad_type1
|
Account 1 Type
|
Type1
|
x(1)
|
|
|
|
emp_ad_type2
|
Account 2 Type
|
Type2
|
x(1)
|
|
|
|
emp_addr
|
Employee
|
|
x(8)
|
|
|
|
emp_bank
|
Bank
|
Bk
|
x(2)
|
|
|
|
emp_birthday
|
Birth Date
|
Birth Dt
|
99/99/9999
|
|
|
|
emp_bs_phone
|
Business Phone
|
Bus Phone
|
x(20)
|
|
|
|
emp_city
|
City
|
|
x(20)
|
|
|
|
emp_country
|
Country
|
|
x(28)
|
|
|
|
emp_ctry
|
Country Code
|
Ctry
|
x(3)
|
|
|
|
emp_dept
|
Department
|
Dept
|
x(8)
|
|
|
|
emp_domain
|
Domain
|
|
x(8)
|
|
|
|
emp_emp_date
|
Date Employed
|
Dt Empld
|
99/99/99
|
|
|
|
emp_entity
|
Entity
|
|
x(20)
|
|
|
|
emp_exempt
|
Personal Exemptions
|
Ex
|
>9
|
|
|
|
emp_ext
|
Ext
|
|
x(4)
|
|
|
|
emp_fname
|
First Name
|
|
x(16)
|
|
|
|
emp_freq
|
Pay Frequency
|
Fr
|
x(2)
|
|
|
|
emp_last_dt
|
Date of Last Pay Rate Change
|
Last Chg
|
99/99/99
|
|
|
|
emp_last_pay
|
Prior Pay Rate
|
Prior Pay
|
->>>,>>9.99
|
10
|
|
|
emp_line1
|
Address 1
|
|
x(36)
|
|
|
|
emp_line2
|
Address 2
|
|
x(36)
|
|
|
|
emp_line3
|
Address 3
|
|
x(36)
|
|
|
|
emp_lname
|
Last Name
|
|
x(16)
|
|
|
|
emp_marital
|
Marital Status
|
MS
|
x(2)
|
|
|
|
emp_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
emp_name
|
Name
|
|
x(36)
|
|
|
|
emp_pay_rate
|
Rate of Pay
|
Pay Rate
|
->>>,>>9.99<<
|
10
|
|
|
emp_pay_type
|
Pay Type
|
T
|
x(2)
|
|
|
|
emp_phone
|
Home Phone
|
|
x(20)
|
|
|
|
emp_project
|
Default Project
|
Project
|
x(8)
|
|
|
|
emp_shift
|
Employee Shift
|
Sh
|
x(2)
|
|
|
|
emp_sick_hrs
|
Accrued Sick Leave
|
Sick Leave
|
->,>>9.999
|
10
|
|
|
emp_sort
|
Sort Name
|
|
x(28)
|
|
|
|
emp_ssn
|
SSN
|
|
x(18)
|
|
|
|
emp_state
|
State
|
|
x(4)
|
|
|
|
emp_status
|
Employment Status
|
St
|
x(2)
|
|
|
|
emp_title
|
Job Title
|
|
x(24)
|
|
|
|
emp_transit1
|
Transit Number 1
|
Transit 1
|
x(10)
|
|
|
|
emp_transit2
|
Transit Number 2
|
Transit 2
|
x(10)
|
|
|
|
emp_trm_date
|
Date Terminated
|
Term Dt
|
99/99/99
|
|
|
|
emp_units
|
Normal Hrs/Units
|
Hrs/Uts
|
->>,>>9.99
|
10
|
|
|
emp_user1
|
Ufld1
|
|
x(8)
|
|
|
|
emp_user2
|
Ufld2
|
|
x(8)
|
|
|
|
emp_user3
|
User3
|
|
x(8)
|
|
|
|
emp_user4
|
User4
|
|
->>>,>>9.99
|
10
|
|
|
emp_user5
|
User5
|
|
->>>,>>9.99
|
10
|
|
|
emp_user6
|
User6
|
|
99/99/99
|
|
|
|
emp_userid
|
User ID
|
|
x(8)
|
|
|
|
emp_vac_hrs
|
Accrued Vacation
|
Vacation
|
->,>>9.999
|
10
|
|
|
emp_wc_class
|
Worker Comp Class
|
W/C
|
x(2)
|
|
|
|
emp_wk_loc
|
Default Work Location
|
Wk Loc
|
x(4)
|
|
|
|
emp_zip
|
Post
|
|
x(10)
|
|
|
|
oid_emp_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
emp_addr
|
yes
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_addr
|
yes
|
no
|
|
|
emp_bank
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_bank
|
yes
|
no
|
|
|
|
|
emp_lname
|
yes
|
no
|
|
|
|
|
emp_fname
|
yes
|
no
|
|
|
emp_dept
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_dept
|
yes
|
no
|
|
|
emp_frq_mar
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_freq
|
yes
|
no
|
|
|
|
|
emp_marital
|
yes
|
no
|
|
|
emp_name
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_name
|
yes
|
no
|
|
|
emp_ssn
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_ssn
|
yes
|
no
|
|
|
emp_wc_ind
|
no
|
emp_domain
|
yes
|
no
|
|
|
|
|
emp_wc_class
|
yes
|
no
|
|
|
|
|
emp_wk_loc
|
yes
|
no
|
|
|
oid_emp_mstr
|
yes
|
oid_emp_mstr
|
yes
|
no
|