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