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 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 #
- From/To
Update My Time Card#
Work Time#
- Add Work Line
- Delete Work Line
Leave Time#
- Add Leave Time
- Delete Leave Time
- Leave Time Code
Sundries#
- Add Sundry Line
- Delete Sundry Line
Totals#
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
The screen has two tabs :
- "Update May Time Card" where the EE will enter the time
- "Totals" - that provides different type of totals (time code, time code type, time code sets, and leave balance)
On "Update May Time Card" are three major matrix areas :
- Work Time - All the time codes that has time type Regular, Excess, Overtime, and they are defined on assignment work rule
- Leave Time - All the time codes that has leave policy type not null, and they are defined on assignment work rule
- Sundries - All the time codes that has time type Money, Meal Allowance, and they are defined on assignment work rule
The matrix lines maybe added/deleted through dialogs, where EE needs to provide the combination for matrix line.
When EE use Add dialog the system will create PTSE with that combination for each day on a time sheet period. When EE use Delete dialog the system will delete all the records in the time sheet for the combination provided. After the lines are created, the EE can record the time / sundry as need it.
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 choose in the dialog follow the same rules as describe earlier for each matrix area
*The cost centers allowed on a dialog are the one that are allow by assignment department. Please see on IDDP Allow Cost Centers tab
*The dialogs are not configurable in IMFDH without changing the code in the ear, they contain special logic for adding/deleting PTSE records.
For the EE that will use this screen UEGTS should generated only the header and if need it the holiday paid
Since we do not generate details, auto balancing logic is not available for this type of time sheet.
This screen it designs for 7 days time sheet. If this need to support 14 time sheet the form definition need to be changed as follow, on form layout tab for any group that has layout type "Matrix Columns" need to changed "SS Rows Displayed" form 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).
