Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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