Wiki: WEPTCCM

My Non-Predefined Matrix Time Cards
Update My Time Card
Work Time
Leave Time
Sundries
Totals
Time Code Totals
Time Type Totals
Time Code Set Totals
Leave Bank Balances
Cascade Leaves

My Non-Predefined Matrix Time Cards#

The My Non-Predefined Matrix Time Cards (WEPTCCM) screen allows you to create a non-predefined "cost center matrix" time sheet.

The matrix lines may be added/deleted through dialogs, where the employee needs to provide the combination for matrix line.

When the employee uses the Add dialog, the system will create a prior time sheet entries (PTSE) with that combination for each day on a time sheet period.

When the employee uses the Delete dialog, the system will delete all the records in the time sheet for the combination provided. After the lines are created, the employee can record the time / sundry as needed.

The dialogs that are used to add/delete matrix line are:

MPMLL - Add/Delete Matrix Leave line
MPMSL - Add/Delete Matrix Sundry Line Dialog
MPMWL - Add/Delete Matrix Work Line Dialog

The time codes that are allowed to be chosen in the dialog follow the same rules as described earlier for each matrix area.
The cost centers allowed on a dialog are the ones allowed by assignment department. Please see IDDP - Allow Cost Centers tab.

For the employee that will use this screen, UEGTS should generate only the header and if needed, the holiday paid.

Since we do not generate details, auto balancing logic is not available for this type of time sheet.

This screen designs for a 7 day time sheet. If a 14 day time sheet is needed, the form definition needs to be changed as follows:

on the form layout tab for any group that has the layout type of "Matrix Columns", the "SS Rows Displayed" needs to be changed from 7 to 14. This number should be the same as time sheet time frame.

Excepting matrix cell, any information on matrix area should be display only.

The grid information alignment is depending on information display on each area they belong (work, leave, sundries) so their alignment in a form would be approximate.

First column in a matrix area should have all the time value because in other away the info can be shifted so information will not display in a correct place.(e.g. Cost center cannot be the first column in the work area since this is not a mandatory information and can be null).

The definition data for (WEPTCCM) is stored in the P2K_PR_TIME_SHEETS, P2K_PR_TIME_SHEET_ENTRIES, P2K_PR_SPTS_TC_TOTALS, P2K_PR_SPTC_TYPE_TOTALS, P2K_PR_TIMESHEET_TOTAL_GIVENS, P2K_AT_LEAVE_ACCRUALS,P2K_AT_LEAVE_LINES and ,P2K_AT_LEAVE_LINE_DETAILS tables.

Time Card #

Time Sheet Status

From/To

Pay Period

Update My Time Card#

You will enter the time for your card here.

Work Time#

This section provides all the time codes that has time type Regular, Excess, Overtime, and they are defined on assignment work rule

Add Work Line

Delete Work Line

Time Code

Cost Center

Description

Assignment

Leave Time#

This section provides all the time codes that has leave policy type not null, and they are defined on assignment work rule. If an employee has a holiday pay generated, then at the end of leave area a non-editable matrix shows when the holiday paid day is.