The Timecard Entry Type dimension has a number of conformed domains which are used in many of the Time and Labor metrics. These domains must be configured correctly for the reports to contain the accurate attribution of time reporting entries to warehouse reporting categories and subcategories.
Optional or Mandatory
This task is mandatory.
Applies to
Oracle Fusion Applications, Oracle E-Business Suite, and PeopleSoft.
Source Timecard Entry Type Code Mapped To Timecard Entry Type Subcategory
This task is mandatory.
Used to identify how Source Timecard Entry Type map to delivered target Timecard Entry Type Subcategory domain members; target domain members are used in the delivered metrics, dashboards and reports, for example, REGULAR (Regular), OVERTIME (Overtime). The target domain is Extensible - customers can add to but not delete from it.
Example for Fusion:
The Source Timecard Entry Type is the Payroll Time Type concept.
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
ZOTL_Doubletime |
OVERTIME (Overtime) |
|
ZOTL_UKRegular |
REGULAR (Regular) |
|
_HOURS_ (Hours) |
REGULAR (Regular) |
Example for E-Business Suite:
The Source Timecard Entry Type is the Element Type Id (Element).
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
64668 (Overtime Element) |
OVERTIME (Overtime) |
|
57941 (Regular Hours Worked) |
REGULAR (Regular) |
|
_HOURS_ (Hours) |
REGULAR (Regular) |
|
63085 (In Class Training Hours Rebate) |
TRAINING (Training) |
Example for PeopleSoft:
On PeopleSoft the Source Timecard Entry Type is the Time Reporting Code (TRC).
| Source Member Code | Target Member Code |
|---|---|
|
KAO20 (Overtime - Double Time) |
OVERTIME (Overtime) |
|
MCREG (Regular) |
REGULAR (Regular) |
|
MTRG (Training) |
TRAINING (Training) |
Timecard Entry Type Subcategory Mapped to Timecard Entry Type Category
This task is optional. There are seeded mappings delivered with the product.
Used to identify which Timecard Entry Type Subcategory are mapped to Timecard Entry Type Category; target domain members are used in the delivered metrics, dashboards and reports, for example, WORKED (Worked), NON_WORKED (Non-Worked). The target domain is Extensible - customers can add to but not delete from it.
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
BL (Bereavement) |
NON_WORKED (Non-Worked) |
|
FAML (Family Leave) |
NON_WORKED (Non-Worked) |
|
HOL (Holiday) |
NON_WORKED (Non-Worked) |
|
OVERTIME (Overtime) |
WORKED (Worked) |
|
PREMIUM (Premium) |
WORKED (Worked) |
|
REGULAR (Regular) |
WORKED (Worked) |
|
SCK (Sickness) |
NON_WORKED (Non-Worked) |
|
TRAINING (Training) |
OTHER (Other) |
|
WORKING (Working) |
WORKED (Worked) |
Source Timecard Entry Type Code for Timecard Entry Productive (Y or N) Flag
Used to identify which Source Timecard Entry Type are considered productive; target domain members are used in the delivered metrics, dashboards and reports, for example, Y (Yes), N (No). The target domain is Extensible - customers can add to but not delete from it.
Example for Fusion:
The Source Timecard Entry Type is the Payroll Time Type concept.
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
ZOTL_Doubletime |
Y (Yes) |
|
ZOTL_UKRegular |
Y (Yes) |
|
_HOURS_ (Hours) |
Y (Yes) |
|
ZOTL_Training |
N (No) |
Example for E-Business Suite:
The Source Timecard Entry Type is the Element Type Id (Element).
| Source Member Code (Name) | Target Member Code (Name) |
|---|---|
|
64668 (Overtime Element) |
Y (Yes) |
|
57941 (Regular Hours Worked) |
Y (Yes) |
|
63085 (In Class Training Hours Rebate) |
N (No) |
Example for PeopleSoft:
On PeopleSoft the Source Timecard Entry Type is the Time Reporting Code (TRC).
| Source Member Code | Target Member Code |
|---|---|
|
KAO20 (Overtime - Double Time) |
Y (Yes) |
|
MCREG (Regular) |
Y (Yes) |
|
MTRG (Training) |
N (No) |
Note:
The following Domain Member Mappings should be completed by customers prior to loading the Time and Labor warehouse schema.
Source Timecard Entry Absence Category Mapped to Timecard Entry Absence Category
This task is optional.
Used to identify which Source Timecard Entry Absence Category are mapped to Timecard Entry Absence Category; target domain members are not currently used in the delivered metrics, dashboards and reports. The target domain is Extensible - customers can add to but not delete from it.
Source Timecard Entry Earning Category Code for Timecard Entry Type Earning Category
This task is optional
Used to identify which Source Timecard Entry Earning Category are mapped to Timecard Entry Type Earning Category; target domain members are not currently used in the delivered metrics, dashboards and reports. The target domain is Extensible - customers can add to but not delete from it.