PAYROLL FOR PERIOD Table
Information about payroll FOR-period, including the type of payroll (monthly vs.weekly), service start and end dates, payment date, etc. "For-period" specifies the period for which the employee is paid, as opposed to the "In-period" which specifies the period in which the payroll runs. The two are usually identical, e.g., an employee paid in August 2006 for his work in August 2006, but can be different, as in case of retroactive adjustments, when an August payroll may be recalculated in September. In this case the For-period will be August, and the In-period, September.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FOR_PAYROLL_PERIOD |
The time period(month or week) and year of the payroll FOR period in the format MM.YYYY or WW.YYYY. |
VARCHAR2 |
7 |
FOR_PAYROLL_PERIOD_DESCRIPTION |
The period and year of the payroll FOR period in alphanumeric form, e.g., July, 2007 or Week 37, 2008. |
VARCHAR2 |
60 |
FOR_PERIOD_CALENDAR_PERIOD |
Six digit calendar period of the payroll FOR period, e.g., 200801 for January 2008. |
VARCHAR2 |
9 |
FOR_PERIOD_CAL_MONTH |
Two digit representation of the FOR period calendar month (as opposed to fiscal year period) e.g., 01 for January. |
VARCHAR2 |
2 |
FOR_PERIOD_CAL_PERIOD_DESC |
Alphanumeric description of the payroll FOR period calendar month (as opposed to fiscal year period), e.g., July 2008. |
VARCHAR2 |
30 |
FOR_PERIOD_CAL_YEAR |
The calendar year, as opposed to the MIT Fiscal Year, of the Payroll FOR period in 4 digit format, e.g., 2008. |
VARCHAR2 |
4 |
FOR_PERIOD_CAL_YR_QTR |
Description of the calendar year quarter of the payroll FOR period, e.g., Year 2008 Quarter 1. |
VARCHAR2 |
60 |
FOR_PERIOD_CAL_YR_QTR_CODE |
Eight digit alphanumeric code for the calendar year quarter of the payroll FOR period, e.g. CY2008Q1. |
VARCHAR2 |
8 |
FOR_PERIOD_FISCAL_PERIOD |
Six digit fiscal period of the payroll FOR period, e.g., 200801 for July 2007. |
VARCHAR2 |
6 |
FOR_PERIOD_FISCAL_PERIOD_DESC |
Alphanumeric description of the payroll FOR period fiscal period, e.g., FY 2008 period 1. |
VARCHAR2 |
30 |
FOR_PERIOD_FISCAL_YEAR |
Four digit fiscal year of the Payroll FOR Period |
VARCHAR2 |
4 |
FOR_PERIOD_FISCAL_YR_QTR |
The fiscal year quarter of the payroll FOR period, e.g., FY2008 Quarter 1 |
VARCHAR2 |
60 |
FOR_PERIOD_FISCAL_YR_QTR_CODE |
Eight digit alphanumeric code for the fiscal year quarter of the payroll FOR period, e.g., FY2008Q1 for July-Sept 2007. |
VARCHAR2 |
8 |
FOR_PERIOD_IS_OFF_CYCLE |
A flag, Y or N, indicating if the FOR period is off cycle. |
VARCHAR2 |
1 |
FOR_PERIOD_PAYMENT_DATE |
The FOR period payment date, usually the normal pay date, e.g, the last day of the month for monthly paid employees or a Friday date for weekly. |
DATE |
8 |
FOR_PERIOD_PAYROLL_AREA |
Indicates whether Monthly Paid or Weekly Paid in the period FOR which the payment was made. |
VARCHAR2 |
60 |
FOR_PERIOD_PAYROLL_AREA_CODE |
Two digit code for payroll area, ZM for monthly paid and ZW for weekly paid. |
VARCHAR2 |
2 |
FOR_PERIOD_PAYROLL_END_DATE |
The last day of the pay period (weekly or monthly) for the FOR period. |
DATE |
8 |
FOR_PERIOD_PAYROLL_START_DATE |
The first day of the pay period (weekly or monthly) of the FOR period. |
DATE |
8 |
PAYROLL_FOR_PERIOD_KEY |
Key field used to join the PAYROLL_FOR_PERIOD table to Payroll fact tables. Use for joining data, not for reporting. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |