Summary

Use this command to import timebands from a third party software package called StaffWorks.

PayGlobal only updates timebands from the import timeband file if the employee’s timeband Task field = STAFFWORKS.

During the import process, PayGlobal deletes any existing timebands (from the earliest date in the import file to the earliest date + 6 days) where the timeband Task field = STAFFWORKS.

Any existing timeband, where the Task field does not equal STAFFWORKS, will remain unchanged.

StaffWorks format fields

Data from the StaffWorks import file is written to the CurrentActualTimebands table.

9 fields are imported for each record (listed in bold):

BuildThisTxtField(pTBFile, lsFieldList, True, 'EmployeeCode');

BuildThisTxtField(pTBFile, lsFieldList, True, 'Date');

BuildThisTxtField(pTBFile, lsFieldList, True, 'StartTime');

BuildThisTxtField(pTBFile, lsFieldList, True, 'EndTime');

BuildThisTxtField(pTBFile, lsFieldList, True, 'ReasonCode');

BuildThisTxtField(pTBFile, lsFieldList, True, 'BreakCode');

BuildThisTxtField(pTBFile, lsFieldList, True, 'TaskCode');

BuildThisTxtField(pTBFile, lsFieldList, True, 'Dim3Code');

BuildThisTxtField(pTBFile, lsFieldList, True, 'Dim4Code');

Note: EmployeeCode, Date, StartTime and EndTime are compulsory

Datatypes

The datatypes of these 9 fields are:

'EmployeeCode' Char, 12

'Date' Date

'StartTime' Integer

'EndTime' Integer

'ReasonCode' Char, 12

'BreakCode' Char, 12

'TaskCode' Char, 12

'Dim3Code' Char, 12

'Dim4Code' Char, 12

File format

A timeband in this import file (type .txt) uses the following format:

1005,70542109,24012009,400,1100,1,GL

Where:

EmployeeID = EmployeeCode = 1005

Cost Centre = 70542109. This value is then converted to calculate Dim3Code and Dim4Code.

• Dim3Code = Characters 1-4 of the Cost Centre = 7054
• Dim4Code = Characters 5-8 of the Cost Centre = 2109.

Roster Date = Date = 24012009 in ddmmyyyy format.

StartTime = 400 in HH24:MI format

EndTime = 1100 in HH24:MI format

BreakCode = 1

Leave Code = GL. This Leave Code is used to calculate the ReasonCode.If the Leave Code has a value of 1, 2, or 3, then it has specific purpose.

• For a value of 1 the ReasonCode = AL (annual leave).
• For a value of 2 the ReasonCode = PD (paid leave).
• For a value of 3 the ReasonCode = UP (unpaid leave).

  All other values remain as they are. In this example, the ReasonCode = GL

TaskCode = STAFFWORKS, which is a fixed value.