Defined fields

Clock transaction data

type:
01 = ON
02 = OFF
03 = Job transfer
04 = Docket transfer
06 = Change time code
07 = Transfer department
08 = Project
09 = Docket with time
11 = Directionless clock
rdrName:
Unique name of the clock to identify the source of the transaction. All clocks must be defined in the READER table.
badgeNo:
Employee badge number as input into the clock. All badge numbers must be defined in the EMPLOYEE_BADGE table.
time:
In the format: YYYYMMDDhhmmss.

Value pairs

vName: Dept Department Transfer
Job Job Transfer
Dkt Docket Transfer
Prj Project Transfer
MgrId Manager's badge number when the manager approval is required
DktTime In format hhmm when time is input for a docket with time
Tcode Time code change
ExtraData
value: Value between quotes "... "

Examples

XML format used to transport clock transaction data:

<CXIXML>
  <Transactions>
    <Clock type="01" rdrName=" STORE1-CLK1" badgeNo="123001"
      time="20030313075807"/ >
    <Clock type="01" rdrName=" STORE1-CLK2" badgeNo="123002"
      time="20030313075909"/>
    <Clock type="02" rdrName=" STORE1-CLK1" badgeNo="123001"
      time="20030313105910"/ >
    <Clock type="02" rdrName=" STORE1-CLK1" badgeNo="123005"
      time="20030313105912"/>
    <Clock type="01" rdrName=" STORE1-CLK1" badgeNo="123006"
      time="20030313080019"/>
    <Clock type="01" rdrName=" STORE1-CLK2" badgeNo="123009"
      time="20030313081123">
      <NValPair vName="MgrId" value="123001" />
    </Clock>
    <Clock type="07" rdrName=" STORE1-CLK1" badgeNo="123002"
      time="20030313092915">
      <NValPair vName="Dept" value="Cashier" />
    </Clock>

    <Clock type="07" rdrName=" STORE1-CLK2" badgeNo="123006"
      time="20030313094505">
      <NValPair vName="MgrId" value="123001" />
      <NValPair vName="Dept" value="Freezer" />
    </Clock>
  </Transactions>
</CXIXML>

XML format to transport clock status information:

<SYXML>
  <ReaderStatuses>
    <RdrStatus rdrName="STORE1-CLK1" timeStamp="20030827121642"
      event="ON_LINE" eventType="CONNECTION" />
    <RdrStatus rdrName="STORE2-CLK1" timeStamp="18991230000000"
      event="ON_LINE" eventType="CONNECTION" />
  </ReaderStatuses>
</SYXML>

XML format to request reader, employee and job data from the database:

<SYXML>
  <TableDumps>
    <TableDump tableName="READER"/>
    <TableDump tableName="EMPLOYEE"/>
    <TableDump tableName="JOB"/>
  </TableDumps>
</SYXML>

Other tables are DOCKET, DEPARTMENT, PROJECT.

Examples of XML formatted data sent to the external system from the database:

<SYXML>
  <Directives>
    <Inserts>
      <Rdr id="10013" name="R100" description="TestReader"
        addr="192.169.10.232" statusID="0" zoneOffset="-1"/>
      <Group memID="10013" grpName="10003" memType="rdr"/>
      <Rdr id="10003" name="TEST1" description="Testing XML"
        addr="192.168.10.231" statusID="1" zoneOffset="-1.0" 
        grace="15" msg=" "/>
      <Group memID="10003" grpName="10004" memType="rdr"/>
      <Rdr id="10053" name="R300" description="R3002" 
        addr="123.123.123.123" statusID="0" zoneOffset="0.0"/>
      <Group memID="10053" grpName="10003" memType="rdr"/>
      <Emp id="4" lName="Wallace1" fName="Adam" badge="000219"
        classification="1"/>
      <Group memID="4" grpName="10003" memType="emp"/>
      <Emp id="5" lName="Sheppard" fName="Andrew" badge="002000"
        classification="0"/>
      <Group memID="5" grpName="10004" memType="emp"/>
      <Emp id="7" lName="Scott" fName="Angela" badge="000218"
        classification="0" msg="true"/>
      <Group memID="7" grpName="10003" memType="emp"/>
      <Emp id="8" lName="Mills" fName="Robert" badge="123456"
        classification="0"/>
      <Group memID="8" grpName="10003" memType="emp"/>
      <Emp id="9" lName="Skinner" fName="Robert" badge="111111"
        classification="0"/>
      <Group memID="9" grpName="10003" memType="emp"/>
      <Emp id="16" lName="Mason" fName="Edward" badge="000016"
        classification="0"/>
      <Group memID="16" grpName="10003" memType="emp"/>
      <Group memID="16" grpName="10004" memType="emp"/>
      <Group memID="16" grpName="10005" memType="emp"/>
      <ValData id="10002" code="002000" desc="Docket 2" 
        valName="Dkt"/>
      <Group memID="10002" grpName="10003" memType="val" 
        memName="dkt"/>
      <ValData id="10001" code="002000" desc="Administration" 
        valName="Job"/>
      <Group memID="10001" grpName="10003" memType="val" 
        memName="job"/>
    </Inserts>
  </Directives>
</SYXML>