ATTENDHIST FILE
Employee Attendance History
The Attendance History file contains employee attendance history information.
TM70 (Attendance History) and PR199 (Payroll Close) are the primary programs
that update this file. More than one attendance record can exist for an
employee for the same day. For this reason a sequence number is needed to
maintain record uniqueness.
REFERENCED BY
TM240 TM245 TM52.1 HR170 HR70.1 TM470
TM50.1 TM50.2 TM60.1 TM61.1 TM01.1 TM250
TM255
UPDATED BY
AC542 PR195 PR197 PR82.1 PR85.1 TM300
TM570 TM70.1 TM71.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATH-COMPANY Numeric 4 AC542 PR195
Company Contains the company number. Validated PR197 PR82.1
in the HR Company and Process Levels PR85.1 TM570
file. TM70.1 TM71.1
ATH-DATE Numeric 8 (yyyymmdd) AC542 PR195
Date Contains the system date this record PR197 PR82.1
was created. PR85.1 TM570
TM70.1 TM71.1
ATH-ATTEND-CODE Alpha 2 AC542 PR195
Attendance Code Contains the user-defined alphanumeric PR197 PR82.1
code that represents a reason for an PR85.1 TM570
employee's absence or hours worked. TM70.1 TM71.1
Examples of attendance codes are, sick,
vacation, overtime, on the job injury,
snow day, tardy, left early, and so on.
Validated in the Attendance Code file.
ATH-EMPLOYEE Numeric 9 AC542 PR195
Employee Contains the employee number associated PR197 PR82.1
with this attendance record. Validated PR85.1 TM570
in the Employee file. TM70.1 TM71.1
ATH-TIME-SEQ Numeric 12 AC542 PR195
Sequence Number Contains the system-assigned number PR197 PR82.1
that makes the record unique. PR85.1 TM570
TM70.1 TM71.1
ATH-PROCESS-LEVEL Alpha 5 AC542 PR195
Process Level Contains the process level with which PR197 PR82.1
this attendance record is associated. PR85.1 TM570
Validated in the HR Company and Process TM70.1 TM71.1
Levels file.
ATH-DEPARTMENT Alpha 5 AC542 PR195
Department Contains the department with which this PR197 PR82.1
attendance record is associated. PR85.1 TM570
Validated in the Department file. TM70.1 TM71.1
ATH-HOURS Signed 7.2 AC542 PR195
Hours Contains the hours associated with this PR197 PR82.1
attendance code. PR199 (Payroll Close) PR85.1 TM570
creates attendance history for time TM70.1 TM71.1
records with an attendance code
attached. Hours is an optional entry for
manual type records.
ATH-POINTS Signed 7.2 AC542 PR195
Points Contains the points associated with the PR197 PR82.1
attendance code. The value in this field PR85.1 TM570
defaults from the Points field in the TM70.1 TM71.1
Attendance Code file. You can override
Points in TM70 (Attendance History) if
appropriate.
ATH-OCCURRENCE Alpha 1 AC542 PR195
Occurrence Contains the value that indicates PR197 PR82.1
whether this record is a unique PR85.1 TM570
attendance occurrence or a continuation TM70.1 TM71.1
of a previous occurrence. For example,
if an employee is sick on Monday and
Thursday, this is considered two
occurrences. If an employee is sick on
Monday and Tuesday, Monday is considered
an occurrence and Tuesday is not since
it is a continuation of Mondays
occurrence.
N = No
Y = Yes
ATH-RECORD-TYPE Alpha 1 AC542 PR195
Record Type Contains the value that identifies the PR197 PR82.1
record type. Attendance history records PR85.1 TM570
created by PR199 (Payroll Close) are TM70.1 TM71.1
system records. Records added or changed
through TM70 (Attendance History) are
manual records.
M = Manual
S = System
ATH-DAYS-IND Numeric 1 AC542 PR195
Days Indicator Contains the numeric value that PR197 PR82.1
represents the day of the week on which PR85.1 TM570
the occurrence took place. TM70.1 TM71.1
1 = Sun
2 = Mon
3 = Tue
4 = Wed
5 = Thu
6 = Fri
7 = Sat
ATH-DATE-STAMP Numeric 8 (yyyymmdd) AC542 PR195
Date Stamp This field contains the server date PR197 PR82.1
(month, date, and year) of the last PR85.1 TM570
change to this record. TM70.1 TM71.1
ATH-TIME-STAMP Numeric 6 (hhmmss) AC542 PR195
Time Stamp Contains the server time (hour, minute, PR197 PR82.1
and second) when the record was last PR85.1 TM570
changed. TM70.1 TM71.1
ATH-USER-ID Alpha 10 (Lower Case) AC542 PR195
User ID Name Contains the user ID of the person who PR197 PR82.1
last changed this record. PR85.1 TM570
TM70.1 TM71.1
ATTENDHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATHSET1 COMPANY This path is used to access history TM240 TM245
DATE records by date. TM300 TM52.1
ATTEND-CODE TM570 TM70.1
EMPLOYEE TM71.1
TIME-SEQ
ATHSET2 COMPANY This path is used to access history HR170 HR70.1
EMPLOYEE records for a particular employee in TM300 TM470
DATE* date sequence. TM50.1 TM50.2
ATTEND-CODE TM52.1 TM60.1
TIME-SEQ* TM61.1 TM70.1
TM71.1
ATHSET3 COMPANY This path is used to access history TM01.1 TM240
ATTEND-CODE records by a particular attendance code. TM245 TM250
DATE* TM255 TM300
EMPLOYEE TM52.1
TIME-SEQ*
ATHSET4 COMPANY This path is used to access history TM240 TM245
EMPLOYEE records for a particular employee and TM250 TM255
ATTEND-CODE attendance code. TM470 TM50.1
DATE* TM52.1
TIME-SEQ*
ATTENDHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attend Code ATTENDCODE Required
ATH-COMPANY -> ATC-COMPANY
ATH-ATTEND-CODE -> ATC-ATTEND-CODE
Company PRSYSTEM Required
ATH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When ATH-DEPARTMENT != Spaces
ATH-COMPANY -> DPT-COMPANY
ATH-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
ATH-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
ATH-COMPANY -> EMP-COMPANY
ATH-EMPLOYEE -> EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
ATH-COMPANY -> PEM-COMPANY
ATH-EMPLOYEE -> PEM-EMPLOYEE
Process Level PRSYSTEM Required
When ATH-PROCESS-LEVEL != Spaces
ATH-COMPANY -> PRS-COMPANY
ATH-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
ATTENDHIST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Prtime PRTIME
Valid When (ATH-RECORD-TYPE = "S" )
ATH-COMPANY -> PRT-COMPANY
ATH-EMPLOYEE -> PRT-EMPLOYEE
ATH-DATE -> PRT-TR-DATE
ATH-TIME-SEQ -> PRT-TIME-SEQ
PRT-CHECK-ID
|
