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 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.
Except for the matrix cell, any information on the matrix area should be display only.
The grid information alignment is dependent on the information displayed 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 #
- The time card uniquely assigned number will be displayed in this field.
- Time Sheet Status
- This field indicates the status of the time sheet (e.g. active, submitted).
- From/To
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
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.- Add Leave Time
- Delete Leave Time
- Leave Time Code
Sundries#
This section provides all the time codes that has time type Money, Meal Allowance, and they are defined on assignment work rule- Add Sundry Line
- Delete Sundry Line
Totals#
This areas provides different type of totals (time code, time code type, time code sets, and leave balance).Time Code Totals#
- Date
- Amount
Time Type Totals#
- Date
- Amount
Time Code Set Totals#
- Amount
Leave Bank Balances#
- Leave
- Balance
Cascade Leaves#
- Start Date
- End Date
- Type
- Projected Time
- Actual Time
- Basis
- Leave Policy Code
- Amount
- Basis
- Bank Exceeded