PAYROLL FOR PERIOD Table
View exposing payroll for period data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FOR_PAYROLL_PERIOD |
For payroll period associated with the record. |
VARCHAR2 |
7 |
FOR_PAYROLL_PERIOD_DESCRIPTION |
Description of for payroll period. |
VARCHAR2 |
60 |
FOR_PERIOD_CALENDAR_PERIOD |
For period calendar period associated with the record. |
VARCHAR2 |
9 |
FOR_PERIOD_CAL_MONTH |
For period cal month associated with the record. |
VARCHAR2 |
2 |
FOR_PERIOD_CAL_PERIOD_DESC |
Description of for period cal period. |
VARCHAR2 |
30 |
FOR_PERIOD_CAL_YEAR |
For period cal year associated with the record. |
VARCHAR2 |
4 |
FOR_PERIOD_CAL_YR_QTR |
For period cal yr qtr associated with the record. |
VARCHAR2 |
60 |
FOR_PERIOD_CAL_YR_QTR_CODE |
Code identifying for period cal yr qtr. |
VARCHAR2 |
8 |
FOR_PERIOD_FISCAL_PERIOD |
For period fiscal period associated with the record. |
VARCHAR2 |
6 |
FOR_PERIOD_FISCAL_PERIOD_DESC |
Description of for period fiscal period. |
VARCHAR2 |
30 |
FOR_PERIOD_FISCAL_YEAR |
For period fiscal year associated with the record. |
VARCHAR2 |
4 |
FOR_PERIOD_FISCAL_YR_QTR |
For period fiscal yr qtr associated with the record. |
VARCHAR2 |
60 |
FOR_PERIOD_FISCAL_YR_QTR_CODE |
Code identifying for period fiscal yr qtr. |
VARCHAR2 |
8 |
FOR_PERIOD_IS_OFF_CYCLE |
For period is off cycle associated with the record. |
VARCHAR2 |
1 |
FOR_PERIOD_PAYMENT_DATE |
Date associated with for period payment. |
DATE |
|
FOR_PERIOD_PAYROLL_AREA |
For period payroll area associated with the record. |
VARCHAR2 |
60 |
FOR_PERIOD_PAYROLL_AREA_CODE |
Code identifying for period payroll area. |
VARCHAR2 |
2 |
FOR_PERIOD_PAYROLL_END_DATE |
Date associated with for period payroll end. |
DATE |
|
FOR_PERIOD_PAYROLL_START_DATE |
Date associated with for period payroll start. |
DATE |
|
PAYROLL_FOR_PERIOD_KEY |
Surrogate key identifying the payroll for period. |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |