TA Account Connector

With this connector, it is possible to export daily account values of the Time & Attendance system (Interflex IF6020) for a defined selection of persons and a specific period.

Configuring the Connector

• Parent connector

• Name

• Data flow direction:
  Data source

• Description

• Do not export 0.0 values:
  Only persons and days where at least one account has a value other than 0.0 are exported.

• One account value per page:
  If multiple accounts are defined, only one account value is shown per person and date in the result. If, for example, 4 accounts are defined, there are 4 pages per person and date in the result!

• TA accounts

  • TA account
  • Column name
  • Up and down arrow
  • Delete

• Persons

• Groups

• Clients

Period

The period is specified via the restriction (constraint) of the connector query with the variable referenceDate and date values in the format yyyyMMdd, e.g., referenceDate = '20160119', referenceDate >= '20160101' and referenceDate <= '20160119' or referenceDate between '20160101' and '20160119'. Without a restriction, the values of the previous day are exported. Only days before the current day and within the person's time recording period are exported; persons without a taId are ignored.

Fields Provided

• date, firstName, lastName, taId, employeeId, person, orgUnit
• for each configured TA account, a field with the specified column name, or, with One account value per page, the fields accountName (TA account) and accountValue (account value)