PAYROLL WAGE TYPE Table
Most of payroll reporting occurs by wage types and this table contains all wage types used in payroll reporting. Wage types are combined into Wage Type Categories that have been created to facilitate reporting. Some of the wage type categories are: Gross Pay, Deductions, Taxes. Each deduction, each type of tax, gross pay, and gross pay component is identified as a specific wage type.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
GTN_MULTIPLIER |
Necessary to zero out gross to net calculations because some wage types are positive numbers and some wage types are negative numbers. The payroll amount is multiplied by this number (0, 1 or -1) to ensure that everything zeroes out. |
NUMBER |
22 |
IS_MAP_WAGE_TYPE |
Currently not in use. |
VARCHAR2 |
1 |
PAYROLL_WAGE_TYPE_KEY |
Key field used to join the PAYROLL_WAGE_TYPE table to Payroll fact tables. Use for joining data, not for reporting. |
VARCHAR2 |
4 |
WAGE_TYPE |
wage type text of the amount, e.g., work, vacation, sick leave, health plan deduction, etc. There are hundreds of wage types; only those most likely to be used for reporting are in the data warehouse. |
VARCHAR2 |
30 |
WAGE_TYPE_CATEGORY |
Shows the category of the wage type, e.g., gross pay, taxes, deductions. |
VARCHAR2 |
70 |
WAGE_TYPE_CODE |
An alphanumeric code for the Wage Type. Numeric (450E, 453E) customized by MIT. With slash (/101, /102) SAP supplied |
VARCHAR2 |
4 |
WAGE_TYPE_PERCENT_RATE |
The multiplier used to calculate the hourly rate for time absence and attendance wage types. Usually 100 percent unless overtime, holiday work, etc |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |