Reader field specifications

This table lists the field-column specifications in the Reader import interface. Fields with the asterisk (*) symbol are required.

Col. Field Name Type Size/Format Description
1 RDR_NAME* Varchar2 40 The Reader name identifier.
2 RDR_DESC* Varchar2 100 The description of the Reader.
3 RDRGRP_NAME* Varchar2 40 Name of the reader group (RDRGRP_NAME), which is resolved to the RDRGRP_ID field.
4 RDR_IP_ADDRESS* Varchar2 40 The IP address of the reader.
5 RDRSTAT_NAME* Varchar2 40

Name of the reader status (RDRSTAT_NAME), which is resolved to the to the RDRSTAT_ID field.

The default value for this field is ON-LINE.
6 RDR_ZONE* Number Reader Zone Offset which must be used together with the Time Zone table. The default value is 0.
7 RDR_CONTROLLER Varchar2 40 Used by Chronos readers and DT600 for some old S systems.
8 RDR_PASSWORD Varchar2 40 The password of the reader.
9 RDR_LASTPOLLDATE Date yyyyMMddHHmmss Last successful time the clock server communicated with the reader.
10 RDR_MESSAGE Varchar2 40 The message on the reader's screen when on idle.
11 TZ_JAVA_NAME* Varchar2 100 The Java name for the timezone (TZ_JAVA_NAME), which is resolved to the TZ_ID field.
12 RDR_CMI_SUBADDR Varchar2 40 The address of a reader on a serially linked chain.
13 RDR_CMI_DLFILE Varchar2 40 Used by ALL Clock Servers, points program that needs to be sent to the reader.
14 RDR_CMI_AUTOCONN Varchar2 1 The CMI Clock Server will maintain the connection to this reader if Y is selected.
15 RDR_CMI_DISPSIZE Varchar2 1 Used by the CMI Clock Server which formats messages sent to the reader.
16 RDR_CMI_TYPE Varchar2 1 Used by ALL Clock Servers which determines if the reader is using bio metrics or not.
17 RDR_DISABLE_PIN Varchar2 1 Indicates if the authentication using PIN is disabled.
18 RDR_ENABLE_BIO Varchar2 1 Indicates if the authentication using finger print is enabled.
19 RDR_SKD_VALIDATION Varchar2 1 Indicates if schedule validation is enabled.
20 RDR_GRACE_START_MINUTES Number Number of minutes before the scheduled time to allow swipe.
21 RDR_GRACE_END_MINUTES Number Number of minutes after the scheduled time to allow swipe
22 RDR_SWIPE_METHOD* Varchar2 1 Method of swiping at the clock. Values available:

C = Default

D = Directionless

S = Swipe and Go
23 RDRTYPE_NAME* Varchar2 40 Name of the reader type (RDRTYPE_NAME), which is resolved to the RDRTYPE_ID field.
24 RDR_SHARE_SWIPES Varchar2 1 Flag to indicate if the clock participates in sharing swipes with other clocks.
25 RDR_MEAL_CONFIRM_REQUIRED Varchar2 1 Stores whether or not meal confirmation is enabled for the reader.
26 CLKRDRUT_ID Varchar2 40 The name of the Reader Update type.
27 RDR_FLAG1 Varchar2 1 One-character flag for general use.

A {space} in one of the flag positions indicates no processing is to be done for that flag.

An ampersand (&) in one of the flag positions indicates the flag is to be blanked.
28 RDR_FLAG2 Varchar2 1 One-character flag for general use.
29 RDR_FLAG3 Varchar2 1 One-character flag for general use.
30 RDR_FLAG4 Varchar2 1 One-character flag for general use.
31 RDR_FLAG5 Varchar2 1 One-character flag for general use.
32 RDR_UDF1 Varchar2 1 User defined field.
33 RDR_UDF2 Varchar2 1 User defined field.
34 RDR_UDF3 Varchar2 1 User defined field.
35 RDR_UDF4 Varchar2 1 User defined field.
36 RDR_UDF5 Varchar2 1 User defined field.