SmartFusion Modules > Payroll > Process > NeoGov Import 

Recent Changes:
6.189 - Created a new screen to allow importing (add/update) payroll employees.

Introduction

This allows the user to allow importing add/update payroll employees.

Fields

Select Process - Option to print or print and update.
Import File Name - Select the file name to import.

Import File Format

Column Name Description Data Type Length
cssn Social Security Number varchar 11
clastname Last Name varchar 25
cfirstname First Name varchar 25
cmi MI varchar 20
csuffix Suffix varchar 6
ctitle Title varchar 5
cnickname Nckname varchar 15
caddress1 Address 1 varchar 35
caddress2 Address 2 varchar 35
ccity City varchar 20
cstate State varchar 6
czip Zip Code varchar 10
cphone Phone 1 varchar 14
cphone2 Phone 2 varchar 14
crace Race varchar 1
csex Sex varchar 1
cempstatus Employment Status varchar 1
cemptype Employment Type varchar 1
ypayperhrs Hours Per Pay Period money 19 (15 digits before the decimal point and 4 digits after the decimal point.)
ypayrate Pay Rate money 19 (15 digits before the decimal point and 4 digits after the decimal point.)
yotrate Overtime Rate money 19 (15 digits before the decimal point and 4 digits after the decimal point.)
dhiredate Hire Date datetime 8
yfte FTE money 19 (15 digits before the decimal point and 4 digits after the decimal point.)
cjobdesc Job Description varchar 50
iempno Employee No int 10
lwhite Is White bit 1
lblack Is African American bit 1
lpacisland Is Pacific Island bit 1
lasian Is Asian bit 1
lamerind Is American Indian bit 1