PAYROLL IN PERIOD Table
View exposing payroll in period data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IN_PAYROLL_PERIOD |
In payroll period associated with the record. |
VARCHAR2 |
7 |
IN_PAYROLL_PERIOD_DESCRIPTION |
Description of in payroll period. |
VARCHAR2 |
60 |
IN_PERIOD_CALENDAR_PERIOD |
In period calendar period associated with the record. |
VARCHAR2 |
9 |
IN_PERIOD_CAL_MONTH |
In period cal month associated with the record. |
VARCHAR2 |
2 |
IN_PERIOD_CAL_PERIOD_DESC |
Description of in period cal period. |
VARCHAR2 |
30 |
IN_PERIOD_CAL_YEAR |
In period cal year associated with the record. |
VARCHAR2 |
4 |
IN_PERIOD_CAL_YR_QTR |
In period cal yr qtr associated with the record. |
VARCHAR2 |
60 |
IN_PERIOD_CAL_YR_QTR_CODE |
Code identifying in period cal yr qtr. |
VARCHAR2 |
8 |
IN_PERIOD_FISCAL_PERIOD |
In period fiscal period associated with the record. |
VARCHAR2 |
6 |
IN_PERIOD_FISCAL_PERIOD_DESC |
Description of in period fiscal period. |
VARCHAR2 |
30 |
IN_PERIOD_FISCAL_YEAR |
In period fiscal year associated with the record. |
VARCHAR2 |
4 |
IN_PERIOD_FISCAL_YR_QTR |
In period fiscal yr qtr associated with the record. |
VARCHAR2 |
60 |
IN_PERIOD_FISCAL_YR_QTR_CODE |
Code identifying in period fiscal yr qtr. |
VARCHAR2 |
8 |
IN_PERIOD_IS_OFF_CYCLE |
In period is off cycle associated with the record. |
VARCHAR2 |
1 |
IN_PERIOD_PAYMENT_DATE |
Date associated with in period payment. |
DATE |
|
IN_PERIOD_PAYROLL_AREA |
In period payroll area associated with the record. |
VARCHAR2 |
60 |
IN_PERIOD_PAYROLL_AREA_CODE |
Code identifying in period payroll area. |
VARCHAR2 |
2 |
IN_PERIOD_PAYROLL_END_DATE |
Date associated with in period payroll end. |
DATE |
|
IN_PERIOD_PAYROLL_START_DATE |
Date associated with in period payroll start. |
DATE |
|
PAYROLL_IN_PERIOD_KEY |
Surrogate key identifying the payroll in period. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |