PAYROLL COMMITMENT FY SUMMARY Table
View exposing fiscal-year payroll commitment summary by cost collector and general ledger account including monthly commitment amounts and total fiscal-year commitment.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APRIL_COMMITMENT_AMOUNT |
April commitment amount associated with the record. |
NUMBER |
15,2 |
AUGUST_COMMITMENT_AMOUNT |
August commitment amount associated with the record. |
NUMBER |
15,2 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DECEMBER_COMMITMENT_AMOUNT |
December commitment amount associated with the record. |
NUMBER |
15,2 |
FEBRUARY_COMMITMENT_AMOUNT |
February commitment amount associated with the record. |
NUMBER |
15,2 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FY_COMMITMENT_AMOUNT |
Fy commitment amount associated with the record. |
NUMBER |
15,2 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
JANUARY_COMMITMENT_AMOUNT |
January commitment amount associated with the record. |
NUMBER |
15,2 |
JULY_COMMITMENT_AMOUNT |
July commitment amount associated with the record. |
NUMBER |
15,2 |
JUNE_COMMITMENT_AMOUNT |
June commitment amount associated with the record. |
NUMBER |
15,2 |
MARCH_COMMITMENT_AMOUNT |
March commitment amount associated with the record. |
NUMBER |
15,2 |
MAY_COMMITMENT_AMOUNT |
May commitment amount associated with the record. |
NUMBER |
15,2 |
NOVEMBER_COMMITMENT_AMOUNT |
November commitment amount associated with the record. |
NUMBER |
15,2 |
OCTOBER_COMMITMENT_AMOUNT |
October commitment amount associated with the record. |
NUMBER |
15,2 |
SEPTEMBER_COMMITMENT_AMOUNT |
September commitment amount associated with the record. |
NUMBER |
15,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |