ATTENDHIST

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
TM255


UPDATED BY
PR195 PR197 PR582 PR82.1 PR85.1 TM300
TM570 TM70.1 TM71.1 TM240 TM245 TM52.1
HR170 HR70.1 TM470 TM50.1 TM50.2 TM60.1
TM61.1 TM01.1 TM250 TM260 TM265

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


ATTENDHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATHSET1 COMPANY
DATE
ATTEND-CODE
EMPLOYEE
TIME-SEQ
TM240 TM245
TM300 TM52.1
TM570 TM70.1
TM71.1
ATHSET2 COMPANY
EMPLOYEE
DATE*
ATTEND-CODE
TIME-SEQ*
HR170 HR70.1
TM300 TM470
TM50.1 TM50.2
TM52.1 TM60.1
TM61.1 TM70.1
TM71.1
ATHSET3 COMPANY
ATTEND-CODE
DATE*
EMPLOYEE
TIME-SEQ*
TM01.1 TM240
TM245 TM250
TM255 TM260
TM265 TM300
TM52.1
ATHSET4 COMPANY
EMPLOYEE
ATTEND-CODE
DATE*
TIME-SEQ*
TM240 TM245
TM250 TM255
TM260 TM265
TM470 TM50.1
TM52.1


ATTENDHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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
Taeemaster TAEEMASTER
ATH-COMPANY->TEM-COMPANY
  TEM-EMPLOYEE
  TEM-PLAN
  TEM-EMPLOYEE-GROUP
  TEM-POSITION

File created: Wed Jun 08 20:51:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.