Import Files Structures

2 files are imported 'recbempe.dat' containing data on the employee and 'recbtime.dat' containing time sheet data. The file structures below are based on the default installation but there is some flexibility to alter the default layout of the files.

The middle letter '*' in the file names rec*empe.dat and rec*time.dat is the company letter set up in the maintenance option for multicompany installations 'b' is used as the default.

The key field in the files below is WorksNo this is used by the import process to uniquely identify the worker over their time at the company, it is defined by the source program for the files and is different from the Sage defined Sage Reference number.

Employee Data

The format below is a fixed width text file.

FieldNumber=FieldName,Character,FieldWidth,00,StartCharacter.

[recbempe]
Filetype=Fixed
Field1=WORKSNO,Char,08,00,10
Field2=WORKSTARTDATE,Char,08,00,18
Field3=TITLE,Char,08,00,026
Field4=FORENAME1,Char,14,00,34
Field5=FORENAME2,Char,14,00,49
Field6=INITIAL1,Char,1,00,34
Field7=INITIAL2,Char,1,00,49
Field8=SURNAME,Char,30,00,64
Field9=ADDRESS1,Char,30,00,94
Field10=ADDRESS2,Char,30,00,124
Field11=ADDRESS3,Char,30,00,154
Field12=ADDRESS4,Char,30,00,184
Field13=ADDRESS5,Char,30,00,214
Field14=POSTCODE,Char,08,00,244
Field15=CONTACTTEL,Char,20,00,254
Field16=TELEPHONE,Char,20,00,274
Field17=DATEOFBIRTH,Char,08,00,294
Field18=PAYMENTTYPE,Char,01,00,304
Field19=NI_NUMBER,Char,09,00,357
Field20=NICAT,Char,1,00,366
Field21=WK1BASISFLAG,Char,1,00,367
Field22=TAXCODE,Char,04,00,368
Field23=BANKNAME,Char,30,00,595
Field24=BANKADDRESS1,Char,30,00,625
Field25=SORTCODE,Char,08,00,685
Field26=BANKACCTNUMBER,Char,08,00,693
Field27=BANKACCTNAME,Char,30,00,701
Field28=ROLENUMBER,Char,20,00,731

Following fields are additional to Recruit Format and are optional in flat release 11_05 or later.
Field29=GENDER,Char,06,00,751 /* Male or Female */
Field30=P46,Char,02,00,757 /* A,B,AB */
Field31=DEPARTMENTREFERENCE,Char,03,00,759 /* three character integer */

Payment Data

[recbtime]
Filetype=Fixed
Field1=INSTANCE,Char,3,00,00 /*'001' can be used for this field */
Field2=WORKSNO,Char,08,00,23
Field3=JOBCODE,Char,04,00,89
Field4=UNITWORKED,Float,6,2,95
Field5=UNITPRICE,Float,7,2,108
Field6=PAYMENTTYPEDESCRIPTION,Char,20,00,123