|
|
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
PR150 PR195 PR199 PR82.1 PR85.1 TM300
TM570 TM70.1 TM71.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATH-COMPANY Numeric 4 PR150 PR195
Company Contains the company number. Validated PR199 PR82.1
in the HR Company and Process Levels PR85.1 TM570
file. TM70.1 TM71.1
ATH-DATE Numeric 8 (yyyymmdd) PR150 PR195
Date Contains the system date this record PR199 PR82.1
was created. PR85.1 TM570
TM70.1 TM71.1
ATH-ATTEND-CODE Alpha 2 PR150 PR195
Attendance Code Contains the user-defined alphanumeric PR199 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 PR150 PR195
Employee Contains the employee number associated PR199 PR82.1
with this attendance record. Validated PR85.1 TM570
in the Employee file. TM70.1 TM71.1
ATH-TIME-SEQ Numeric 12 PR150 PR195
Sequence Number Contains the system-assigned number PR199 PR82.1
that makes the record unique. PR85.1 TM570
TM70.1 TM71.1
ATH-PROCESS-LEVEL Alpha 5 PR150 PR195
Process Level Contains the process level with which PR199 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 PR150 PR195
Department Contains the department with which this PR199 PR82.1
attendance record is associated. PR85.1 TM570
Validated in the Department file. TM70.1 TM71.1
ATH-HOURS Signed 7.2 PR150 PR195
Hours Contains the hours associated with this PR199 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 5.2 PR150 PR195
Points Contains the points associated with the PR199 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 PR150 PR195
Occurrence Contains the value that indicates PR199 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 PR150 PR195
Record Type Contains the value that identifies the PR199 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 PR150 PR195
Days Indicator Contains the numeric value that PR199 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) PR150 PR195
Date Stamp Contains the server date (month, date, PR199 PR82.1
and year) of the last change to this PR85.1 TM570
record. TM70.1 TM71.1
ATH-TIME-STAMP Numeric 6 (hhmmss) PR150 PR195
Time Stamp Contains the server time (hour, minute, PR199 PR82.1
and second) when the record was last PR85.1 TM570
changed. TM70.1 TM71.1
ATH-USER-ID Alpha 10 (Lower Case) PR150 PR195
User ID Name Contains the user ID of the person who PR199 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
|