Clock XML directives - field mapping

These tables list the system default field names for the data in the XML records. These names are sometimes different from the table column names.

See Readers - Export Directives task parameters.

The CMI EIS, Synel DT600, and RSI DR600 columns indicate which fields must be mapped for each server. Optional indicates that this is an optional field, depending on the implementation. When the XML field name differs from the default, the name is shown in the Map name column. Map names are case-sensitive.

READER data

System default field name Database column name CMI EIS Synel DT600 RSI DR600
Mapping Map name Mapping Map name Mapping Map name
id True True True
name True True True
description : Desc True True True
group : RdrgrpID True True
addr : IP Address True True
statusID : RdrStatID True
zoneOffset : Zone True True
controller : Controller True addr
password : Password
lastPollDate : LastPollDate
message : Message msg
timeZoneID : TimeZoneID
subAddr : CmiSubAddr True grace True
downLoadFile : CmiDIFile True True
autoConn : CmiAutoConn True
dispSize : CmiDispSize True
type : CmiType True
timeZoneName : TimeZoneName
timeZoneDesc : TimeZoneDesc
timeZoneJavaName : TimeZoneJava Name
timeZone : TimeZoneWin Name True

EMPLOYEE and EMPLOYEE_BADGE data

System default field name Database column name CMI EIS Synel DT600 RSI DR600
Mapping Map name Mapping Map name Mapping Map name
id True True True
empNo : Name True
IName : LastName True True True
fName : FirstName True True True
status : Status True True
SIN : SIN
empVal1 : Val1
empVal20 : Val20 True thres hold
badge : BadgeNumber True True True
badgePin : BadgePIN
classification :SupervisorLevel True True True
empbdgFlag1
empbdgFlag5
empbdgUdf1 msg
empbdgUdf5

EMPLOYEE_SCHEDULE data

System default field name Database column name CMI EIS Synel DT600 RSI DR600
Mapping Map name Mapping Map name Mapping Map name
id True True
empNo : empId True True empID
workdate
actShiftId
sTime actStartTime True sDT True sDT
sTime : actEndTime True edT True eDT
defShiftId
dsTime : defStartTime
deTime : defEndTime
actShiftId2
sTime2 : actStartTime2
eTime2 : actEndTime2
actShiftId3
sTime3 : actStartTime3
eTime3 : actEndTime3
actShiftId4
sTime4 : actStartTime4
eTime4 : actEndTime4
actShiftId5
sTime5 : actStartTime5
eTime5 : actEndTime5
flag1…10
udf1…10

LABOR (DEPT, JOB, DOCKET, PROJECT, T-CODE) data

System default field name Database column name CMI EIS Synel DT600 RSI DR600
Mapping Map name Mapping Map name Mapping Map name
id True True True
code : Name True True True
desc True
empbdgUdf1 … Udf5 msg