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
|
|
|