XT795
XT795 - Anniversary Todate PTO-ALB-ELB

TCMC Internal Program. Run TA795 (Anniversary To Date PTO/ALB/ELB) to produce a report, listing the employees annual accruals and usages for the three Time Accrual Plans. The report is in company, department, employee name order. Totals are produced for the department and company. This report evaluates each employees adjusted hire date, to determine where the employee is within their anniversary year. If the employee has started a new year, their accruals and usages will be zeroed with the balance being carried forward. This report is used to determine the employees annual buy back amounts. The user must specify the company and pay period date. All other fields are optional. Program Logic: Program uses the EMTATRANS file via ETTSET1 as the driving file. It then accesses the EMPLOYEE file and performs a routine to determine that valid daterange for each employee. This routine is described below. Records are selected only if the employee status is "A0", "A1", "A2" or "DH" and the transaction date falls within the employees calculated date range. The transaction status must also be greater than zero. The program also checks process level, department or an employee range, in case any of these had beenspecified by the user. If the transaction type is "U", the program converts the hours to a negative balance. To produce the report, hours and accruals are accumulated for the employee by plan name. These plans are "ALB-100%", "ALB-80%", "ALB-60%", "ELB", "ALB-LOA", "PTO-LOA", "CEO-PTO", "DHPTO-100%", "PTO-100%", "PTO-80%", "PTO-60%" and "PTO-WKNPRO". If the transaction type is "U", the hours are treated as usage, while transaction type "X" is treated as accruals. The program gets the balance from the ETMASTER file. Determining Employee Date Range : The user is required to enter pay period ending date. The program uses this date in conjunction with employees adjusted hire date, to determine the valid date range for the employee. The starting date range (or from date), will contain the employees hire month and day. If the employees hire month/day combination is greater than the pay period end month/day combination, the program will subtract one from the pay period end year. This year will then be used in the from year field. Otherwise, the year indicated for the pay period end will be used. The pay period end date is used for the ending date range (or to date).

Updated Files
CKPOINT - No Description Available.
EMTAMASTR - No Description Available.
EMTATRANS - No Description Available.



Referenced Files
DEPTCODE - No Description Available.
EMPLOYEE - No Description Available.
EMTAMASTR - No Description Available.
EMTATRANS - No Description Available.
PRSYSTEM - No Description Available.






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

Nogalis, inc.
Contact Us

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