SYEMPLOY

Employer Setup (ER) Database

Seq Field Name Type Length Dec Description
1 E_ADDRESS1 C 32 0 Street Address Line 1
2 E_ADDRESS2 C 32 0 Street Address Line 2
3 E_AGEWARN N 2 0 Display Warning For Young Employees
4 E_ATABRA L 1 0 Interface to Attendance Module (Y/N)
5 E_ATACCRUE L 1 0 Post HR Accruals During Payroll
6 E_ATDEC N 1 0 Decimal Places Per Transaction
7 E_ATUNITS C 5 0 Unit of absence transactions
8 E_AUDIT C 1 0 Audit Trail Enabled (Y/N)
9 E_BANKCLR C 15 0 Bank Clear Code
10 E_BANKPHON C 13 0 Bank Phone Number For ACH Direct Deposit
11 E_BENEABRA L 1 0 HR Benefits Module Interface
12 E_BPSSYNC T 8 0 SPS Last Sync Date
13 E_CASENO N 6 0 Last OSHA Case Number
14 E_CITY C 28 0 City
15 E_CNTRYSTG C 2 0 Country Indicator
16 E_COMPANY C 3 0 Company Code
17 E_CONTACT C 30 0 Payroll Contact
18 E_COUNTRY C 6 0 Country
19 E_COUNTY C 20 0 County Within State
20 E_DESTROUT C 9 0 ACH destination bank routing number
21 E_ECOUNTRY C 20 0 Employer Country
22 E_EMAIL C 35 0 Contact E-Mail address
23 E_FAX C 13 0 Fax Number
24 E_FEDID C 9 0 Federal Identification Number
25 E_FIELDSW C 10 0 EEO-4 Job Function Settings
26 E_FIELDSWC C 10 0 EE Job Function Settings
27 E_FISC_YR T 8 0 Att. Fiscal Year Start Date
28 E_GLJOBCD N 2 0 Job Code G/L Component
29 E_GLMAIN N 2 0 G/L Main Acct . Component
30 E_GLORG1 N 2 0 Org Level 1 G/L Component
31 E_GLORG2 N 2 0 Org Level 2 G/L Component
32 E_GLORG3 N 2 0 Org Level 3 G/L Component
33 E_GLORG4 N 2 0 Org Level 4 G/L Component
34 E_GLORG5 N 2 0 Org Level 5 G/L Component
35 E_GLPROJ N 2 0 Project Code G/L Component
36 E_ILLIND C 1 0 Method Of Illness Accrual
37 E_ILLRATE N 11 5 Default Hours/Units Sick Leave
38 E_INDUST C 2 0 Industrial Sector Code for Employer
39 E_J250 C 1 0 EEO-4 Over 999 Employees Flag
40 E_J250C C 1 0 EE Over 249 Employee Flag
41 E_JAPPRENT C 1 0 EEO-1 Employ Apprentices (Y/N)
42 E_JCCITY C 28 0 EEO Report City
43 E_JCCITYC C 28 0 EE Report Contact City
44 E_JCCOUNTY C 20 0 EEO Report County
45 E_JCITY C 28 0 EEO Parent/Jurisdiction City
46 E_JCITYC C 28 0 EE Jurisdiction City
47 E_JCNAME C 35 0 EEO Company Name
48 E_JCONTACT C 50 0 EEO-4 Report Contact
49 E_JCONTCTC C 50 0 EE Report Contact
50 E_JCONTRLC C 11 0 EE Control Number
51 E_JCONTROL C 11 0 EEO EI/Control Number
52 E_JCONUM C 8 0 EEO-1 Company Number
53 E_JCOUNTY C 20 0 EEO Parent/Jurisdiction County
54 E_JCPHONE C 13 0 EEO-4 Report Contact Phone Number
55 E_JCPHONEC C 13 0 EE Report Contact Phone Number
56 E_JCPOST C 10 0 EE Report Contact Post Code
57 E_JCPROV C 2 0 EE Report Contact Prov Code
58 E_JCST C 32 0 EE Report Contact Street Address
59 E_JCSTATE C 2 0 EEO Report State Code
60 E_JCSTREET C 35 0 EEO Report Street Address
61 E_JCTITLE C 30 0 EEO-4 Title of Report Contact
62 E_JCTITLEC C 30 0 EE Title of Report Contact
63 E_JCVALID C 1 0 Enable Job Code Validation (Y/N)
64 E_JCZIP C 10 0 EEO Report ZIP Code
65 E_JDUNS C 9 0 EEO-1 Duns Number
66 E_JEMAIL C 64 0 Veterans Employment Report E-Mail Address
67 E_JINFO C 140 0 EEO-1 Establishment Information
68 E_JLASTYR C 1 0 EEO-1 Filed Last Year (Y/N)
69 E_JNAICS C 6 0 EEO-1 NAICS Code
70 E_JNAME C 35 0 EEO Parent/Jurisdiction Name
71 E_JNAMEC C 30 0 EE Jurisdiction Name
72 E_JPHONE C 13 0 Veterans Employment Report Contact Phone Number
73 E_JPOST C 10 0 EE Jurisdiction Post Code
74 E_JPROV C 2 0 EE Jurisdiction Prov Code
75 E_JSIC C 4 0 EEO-1 SIC Code
76 E_JSTATE C 2 0 EEO Parent/Jurisdiction State Code
77 E_JSTREET C 35 0 EEO Parent/Jurisdiction Street Address
78 E_JSTREETC C 32 0 EE Jurisdiction Street Address
79 E_JTEST C 3 0 EEO-1 Test for Filing Requirements
80 E_JTITLE C 30 0 EEO-4 Title of Certification Official
81 E_JTITLEC C 30 0 Employee Title of Certifying Official
82 E_JTYPE C 1 0 EEO-1 Type (Headquarters/Establishment)
83 E_JUNIT C 8 0 EEO-1 Unit Number
84 E_JVCONTAC C 50 0 Veterans Employment Report Contact
85 E_JZIP C 10 0 EEO Parent/Jurisdiction ZIP Code
86 E_LANGUAGE C 1 0 Language of Communicatino (E/F)
87 E_LASTPAID T 8 0 Last Check Date Of Final Payroll Run
88 E_LOCATEC C 1 0 Location Reporting for EE
89 E_METHOD C 1 0 Attendance Accrual Method (F), (A)
90 E_MISC1 C 15 0 Miscellaneous Field Prompt
91 E_MISC2 C 15 0 Miscellaneous Field Prompt
92 E_MISC3 C 15 0 Miscellaneous Field Prompt
93 E_MISC4 C 15 0 Miscellaneous Field Prompt
94 E_MISC5 C 15 0 Miscellaneous Field Prompt
95 E_MISC6 C 15 0 Miscellaneous Field Prompt
96 E_MISC7 C 15 0 Miscellaneous Field Prompt
97 E_MISC8 C 15 0 Miscellaneous Field Prompt
98 E_NAME C 35 0 Company Name
99 E_NORMUNIT N 11 5 Most Common Hours-Units Worked
100 E_NUMERIC C 1 0 Numeric Entry Of Employee Numbers
101 E_ORIGROUT C 10 0 ACH origination bank routing number
102 E_PAYDATA C 6 0 Payroll Database Name
103 E_PAYFREQ C 1 0 Most Common Payroll Frequency
104 E_PAYNUM N 3 0 Last Final Payroll Run Number
105 E_PAYPERDT T 8 0 Payroll-Employee Self Service Last Sync Period End Date
106 E_PAYSYNC T 8 0 Payroll-Employee Self Service Last Sync Date
107 E_PERIND C 1 0 Method of Personal Accrual
108 E_PERRATE N 11 5 Default Hours/Units Personal Leave
109 E_PHONE C 13 0 Phone Number
110 E_POSITION N 3 0 Employer Byte Position in Security Files
111 E_QTREND T 8 0 Last Quarter End Date
112 E_SGVALID C 1 0 Enable Salary Grade Validation (Y/N)
113 E_SIGOPT C 2 0 Signature Option Settings
114 E_STATE C 2 0 State/Province Code
115 E_TRAINENT L 1 0 Training Enterprise Indicator
116 E_VACIND C 1 0 Method of Vacation Accrual
117 E_VACRATE N 11 5 Default Hours/Units Vacation Leave
118 E_ZIP C 10 0 ZIP/Postal Code
119 _JCSTATE C 25 0 EEO Report State
120 _JSTATE C 25 0 EEO Parent/Jurisdiction State
121 _STATE C 25 0 State/Province
122 _ZFILTER C 25 0 Filter Function

Published: April 11, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks