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 |
PR195 | PR197 | PR582 | PR82.1 | PR85.1 | TM300 |
TM570 | TM70.1 | TM71.1 |
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. |
|
||||||||
ATH-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the system date this record was created. |
|
||||||||
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. |
|
||||||||
ATH-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number associated with this attendance record. Validated in the Employee file. |
|
||||||||
ATH-TIME-SEQ Element: Sequence Number | Numeric 12 Contains the system-assigned number that makes the record unique. |
|
||||||||
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. |
|
||||||||
ATH-DEPARTMENT Element: Department | Alpha 5 Contains the department with which this attendance record is associated. Validated in the Department file. |
|
||||||||
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. |
|
||||||||
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. |
|
||||||||
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 |
|
||||||||
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 |
|
||||||||
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 |
|
||||||||
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. |
|
||||||||
ATH-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||
ATH-USER-ID Element: User | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ATHSET1 |
COMPANY DATE ATTEND-CODE EMPLOYEE TIME-SEQ |
|
| ||||||||||||||||||
ATHSET2 |
COMPANY EMPLOYEE DATE* ATTEND-CODE TIME-SEQ* |
|
| ||||||||||||||||||
ATHSET3 |
COMPANY ATTEND-CODE DATE* EMPLOYEE TIME-SEQ* |
|
| ||||||||||||||||||
ATHSET4 |
COMPANY EMPLOYEE ATTEND-CODE DATE* TIME-SEQ* |
|
| ||||||||||||||||||
ATHSET5 |
COMPANY DATE* DATE-STAMP* ATTEND-CODE EMPLOYEE TIME-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Attend Code | ATTENDCODE |
Required
| |||||||||||||||
Company | PRSYSTEM |
Required
| |||||||||||||||
Department | DEPTCODE |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Paemployee | PAEMPLOYEE |
Required
| |||||||||||||||
Process Level | PRSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Prtime | PRTIME |
| |||||||||||||||||||||
Taeemaster | TAEEMASTER |
|
All trademarks and registered trademarks are the property of their
respective owners.