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 TM01.1 TM250 TM255
UPDATED BY
PR195 PR197 PR82.1 PR85.1 TM300 TM70.1
TM71.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATH-COMPANY Numeric 4 PR195 PR197
Company Contains the company number. Validated PR82.1 PR85.1
in the HR Company and Process Levels TM70.1 TM71.1
file.
ATH-DATE Numeric 8 (yyyymmdd) PR195 PR197
Date Contains the system date this record PR82.1 PR85.1
was created. TM70.1 TM71.1
ATH-ATTEND-CODE Alpha 2 PR195 PR197
Attendance Code Contains the user-defined alphanumeric PR82.1 PR85.1
code that represents a reason for an TM70.1 TM71.1
employee's absence or hours worked.
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 PR195 PR197
Employee Contains the employee number associated PR82.1 PR85.1
with this attendance record. Validated TM70.1 TM71.1
in the Employee file.
ATH-TIME-SEQ Numeric 12 PR195 PR197
Sequence Number Contains the system-assigned number PR82.1 PR85.1
that makes the record unique. TM70.1 TM71.1
ATH-PROCESS-LEVEL Alpha 5 PR195 PR197
Process Level Contains the process level with which PR82.1 PR85.1
this attendance record is associated. TM70.1 TM71.1
Validated in the HR Company and Process
Levels file.
ATH-DEPARTMENT Alpha 5 PR195 PR197
Department Contains the department with which this PR82.1 PR85.1
attendance record is associated. TM70.1 TM71.1
Validated in the Department file.
ATH-HOURS Signed 7.2 PR195 PR197
Hours Contains the hours associated with this PR82.1 PR85.1
attendance code. PR199 (Payroll Close) TM70.1 TM71.1
creates attendance history for time
records with an attendance code
attached. Hours is an optional entry for
manual type records.
ATH-POINTS Signed 7.2 PR195 PR197
Points Contains the points associated with the PR82.1 PR85.1
attendance code. The value in this field TM70.1 TM71.1
defaults from the Points field in the
Attendance Code file. You can override
Points in TM70 (Attendance History) if
appropriate.
ATH-OCCURRENCE Alpha 1 PR195 PR197
Occurrence Contains the value that indicates PR82.1 PR85.1
whether this record is a unique TM70.1 TM71.1
attendance occurrence or a continuation
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 PR195 PR197
Record Type Contains the value that identifies the PR82.1 PR85.1
record type. Attendance history records TM70.1 TM71.1
created by PR199 (Payroll Close) are
system records. Records added or changed
through TM70 (Attendance History) are
manual records.
M = Manual
S = System
ATH-DAYS-IND Numeric 1 PR195 PR197
Days Indicator Contains the numeric value that PR82.1 PR85.1
represents the day of the week on which TM70.1 TM71.1
the occurrence took place.
1 = Sun
2 = Mon
3 = Tue
4 = Wed
5 = Thu
6 = Fri
7 = Sat
ATH-DATE-STAMP Numeric 8 (yyyymmdd) PR195 PR197
Date Stamp This field contains the server date PR82.1 PR85.1
(month, date, and year) of the last TM70.1 TM71.1
change to this record.
ATH-TIME-STAMP Numeric 6 (hhmmss) PR195 PR197
Time Stamp Contains the server time (hour, minute, PR82.1 PR85.1
and second) when the record was last TM70.1 TM71.1
changed.
ATH-USER-ID Alpha 10 (Lower Case) PR195 PR197
User ID Name Contains the user ID of the person who PR82.1 PR85.1
last changed this record. 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 TM70.1 TM71.1
EMPLOYEE
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 TM70.1
TIME-SEQ* 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
|
