|
|
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 TM260 TM265
UPDATED BY
PR197 PR82.1 PR85.1 TM300 TM570 TM70.1
TM71.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATH-COMPANY Numeric 4 PR197 PR82.1
Element: Company Hr Contains the company number. Validated PR85.1 TM570
in the HR Company and Process Levels TM70.1 TM71.1
file.
ATH-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Element: Date Contains the system date this record PR85.1 TM570
was created. TM70.1 TM71.1
ATH-ATTEND-CODE Alpha 2 PR197 PR82.1
Element: Attendance CodContains the user-defined alphanumeric PR85.1 TM570
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 PR197 PR82.1
Element: Employee Contains the employee number associated PR85.1 TM570
with this attendance record. Validated TM70.1 TM71.1
in the Employee file.
ATH-TIME-SEQ Numeric 12 PR197 PR82.1
Element: Sequence NumbeContains the system-assigned number PR85.1 TM570
that makes the record unique. TM70.1 TM71.1
ATH-PROCESS-LEVEL Alpha 5 PR197 PR82.1
Element: Process Lev HrContains the process level with which PR85.1 TM570
this attendance record is associated. TM70.1 TM71.1
Validated in the HR Company and Process
Levels file.
ATH-DEPARTMENT Alpha 5 PR197 PR82.1
Element: Department Contains the department with which this PR85.1 TM570
attendance record is associated. TM70.1 TM71.1
Validated in the Department file.
ATH-HOURS Signed 7.2 PR197 PR82.1
Element: Hours Contains the hours associated with this PR85.1 TM570
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 PR197 PR82.1
Element: Points Contains the points associated with the PR85.1 TM570
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 PR197 PR82.1
Element: Occurrence Contains the value that indicates PR85.1 TM570
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 PR197 PR82.1
Element: Record Type Contains the value that identifies the PR85.1 TM570
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 PR197 PR82.1
Element: Days IndicatorContains the numeric value that PR85.1 TM570
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) PR197 PR82.1
Element: Date Stamp This field contains the server date PR85.1 TM570
(month, date, and year) of the last TM70.1 TM71.1
change to this record.
ATH-TIME-STAMP Numeric 6 (hhmmss) PR197 PR82.1
Element: Time Stamp Contains the server time (hour, minute, PR85.1 TM570
and second) when the record was last TM70.1 TM71.1
changed.
ATH-USER-ID Alpha 10 (Lower Case) PR197 PR82.1
Element: User Contains the user ID of the person who PR85.1 TM570
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 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 TM260
EMPLOYEE TM265 TM300
TIME-SEQ* TM52.1
ATHSET4 COMPANY This path is used to access history TM240 TM245
EMPLOYEE records for a particular employee and TM250 TM255
ATTEND-CODE attendance code. TM260 TM265
DATE* TM470 TM50.1
TIME-SEQ* TM52.1
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
|
