PAYROLL BY FP FLAGS Table
View exposing payroll change and activity flags by fiscal period, person, position, cost collector, wage type, and general ledger account including adjustment, salary change, overtime, transfer, suspense, and leave indicators.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPT_SUBTYPE_CODE |
Code identifying appt subtype. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
HAS_ADJUSTMENT |
Has adjustment associated with the record. |
VARCHAR2 |
1 |
HAS_APPOINTMENT_TYPE_CHANGE |
Has appointment type change associated with the record. |
VARCHAR2 |
1 |
HAS_DISTRIBUTION_CHANGE |
Has distribution change associated with the record. |
VARCHAR2 |
1 |
HAS_EFFORT_CHANGE |
Has effort change associated with the record. |
VARCHAR2 |
1 |
HAS_OVERTIME |
Has overtime associated with the record. |
VARCHAR2 |
1 |
HAS_SALARY_CHANGE |
Has salary change associated with the record. |
VARCHAR2 |
1 |
HAS_SUSPENSE |
Has suspense associated with the record. |
VARCHAR2 |
1 |
HAS_VACATION_ADJUSTMENT |
Has vacation adjustment associated with the record. |
VARCHAR2 |
1 |
HR_POSITION_KEY |
Surrogate key identifying the hr position. |
VARCHAR2 |
10 |
IS_TRANSFER |
Indicator identifying whether transfer (Y/N). |
VARCHAR2 |
1 |
ON_LEAVE |
On leave associated with the record. |
VARCHAR2 |
1 |
PAYROLL_WAGE_TYPE_KEY |
Surrogate key identifying the payroll wage type. |
VARCHAR2 |
4 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |