PAYROLL IN PERIOD Table
Information about payroll IN-period, including the type of payroll (monthly vs.weekly), service start and end dates, payment date, etc. "In-period" specifies the period in which a payroll runs, as opposed to the "For-period" which specifies the period for which the person is paid. 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 |
---|---|---|---|
IN_PAYROLL_PERIOD |
The time period (month or week) and year of the payroll in period in the format mm.yyyy (monthly) and ww.yyyy(weekly). |
VARCHAR2 |
7 |
IN_PAYROLL_PERIOD_DESCRIPTION |
Alphanumeric description of the payroll in-period in the format MONTH, YEAR (March, 2009) or WEEK WW, YEAR (Week 29, 2009) |
VARCHAR2 |
60 |
IN_PERIOD_CALENDAR_PERIOD |
Six digit calendar period of the payroll IN period, e.g., 200801 for January 2008. |
VARCHAR2 |
9 |
IN_PERIOD_CAL_MONTH |
Two digit representation of the payroll IN period calendar month (as opposed to fiscal year period), e.g., 01 for January. |
VARCHAR2 |
2 |
IN_PERIOD_CAL_PERIOD_DESC |
Alphanumeric description of the payroll IN period calendar month (as opposed to fiscal year period), e.g., July, 2008. |
VARCHAR2 |
30 |
IN_PERIOD_CAL_YEAR |
The four digit calendar year as opposed to fiscal year, of the payroll IN period. |
VARCHAR2 |
4 |
IN_PERIOD_CAL_YR_QTR |
Description of the calendar year quarter of the payroll IN period, e.g., Year 2009 Quarter 1 for Jan-Mar 2009. |
VARCHAR2 |
60 |
IN_PERIOD_CAL_YR_QTR_CODE |
Eight character alphanumeric code for the calendar year quarter of the payroll IN period, e.g. CY2008Q1. |
VARCHAR2 |
8 |
IN_PERIOD_FISCAL_PERIOD |
Six digit fiscal period of the payroll IN period, e.g., 200801 for July 2007. |
VARCHAR2 |
6 |
IN_PERIOD_FISCAL_PERIOD_DESC |
Alphanumeric description of the payroll IN period fiscal period, e.g., FY 2008 period 1. |
VARCHAR2 |
30 |
IN_PERIOD_FISCAL_YEAR |
Four digit fiscal year of the payroll IN period. |
VARCHAR2 |
4 |
IN_PERIOD_FISCAL_YR_QTR |
The fiscal year quarter of the payroll in period, e.g., FY2008 Quarter 1 |
VARCHAR2 |
60 |
IN_PERIOD_FISCAL_YR_QTR_CODE |
Eight digit alphanumeric code for the fiscal year quarter of the payroll IN period, e.g., FY2008Q1. |
VARCHAR2 |
8 |
IN_PERIOD_IS_OFF_CYCLE |
A flag, Y or N, indicating if the payment is off cycle. |
VARCHAR2 |
1 |
IN_PERIOD_PAYMENT_DATE |
The IN period payment date, usually the normal pay date, e.g, the last working day of the month for exempt and each Friday for non-exempt |
DATE |
8 |
IN_PERIOD_PAYROLL_AREA |
Indicates whether Monthly Paid or Weekly Paid. |
VARCHAR2 |
60 |
IN_PERIOD_PAYROLL_AREA_CODE |
Two digit code for payroll area, ZM for monthly paid and ZW for weekly paid. |
VARCHAR2 |
2 |
IN_PERIOD_PAYROLL_END_DATE |
The last day of the pay period for the IN period, e.g., 01/31/2009 for January 2009 (Monthly paid) or any Sunday for weekly, e.g. 1/18/2009 |
DATE |
8 |
IN_PERIOD_PAYROLL_START_DATE |
The first day in the pay period for the IN period, e.g., 01/01/2009 for January 2009 (Monthly paid) and always a Monday for weekly. |
DATE |
8 |
PAYROLL_IN_PERIOD_KEY |
Key field used to join the PAYROLL_IN_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 |