fiscal period dimension
(PLT_DIM_FISCAL_PERIOD) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (PLT_DIM_FISCAL_PERIOD)
| Column Name | Column Description |
|---|---|
| Fiscal Period Key | Primary key uniquely identifying each row in the fiscal period dimension, associated with facts corresponding to the posted date of the transaction fact. |
| Fiscal Year | The value of the Institute's fiscal year (e.g. 1999, 2000, 2001), following a cycle starting July 1st and ending June 30th. |
| Fiscal Year Description | The name of the Institute's fiscal year (e.g. FY 1999, FY 2000, FY 2001), following a cycle starting July 1st and ending June 30th. |
| Fiscal Quarter | The numeric value (i.e. 1, 2, 3, 4) representing the 3-month period that collectively forms a quarter. |
| Fiscal Quarter Description | The name of the fiscal quarter (e.g. 1st FY Quarter, 2nd FY Quarter, etc.). The 1st FY Quarter contains fiscal periods 00-03; the 2nd FY Quarter contains fiscal periods 04-06; the 3rd FY Quarter contains fiscal periods 07-09; the 4th FY Quarter contains fiscal periods 10-12 and 14. Period 00 represents the beginning balance. Period 14 represents the accrual. |
| Fiscal Period | The numeric value (i.e. 00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 14) corresponding to the month within the Institute's fiscal year. Period 00 represents the beginning balance; period 01 represents July; period 02 represents August; etc.; period 14 represents the accrual. |
| Fiscal Period Description Long | The name of the fiscal period (e.g. July, August, September, etc.); note that July includes fiscal periods 00 and 01; June includes fiscal periods 12 and 14. |
| Fiscal Period Description Short | The abbreviated name of the fiscal period (e.g. Jul, Aug, Sep, etc.); note that July includes fiscal periods 00 and 01; June includes fiscal periods 12 and 14. |
| Fiscal Period and Year Description | The combined display value of the fiscal period and fiscal year, separated by a comma (e.g. 00, 2001; 01, 2001; 02, 2001; etc.). |
| Fiscal Period Type | The type of fiscal period, where Opening Period represents fiscal period 00, Posting Period represents fiscal periods 01-12, and Accrual Period represents fiscal period 14. |
| Fiscal Year Period | No description available. |
| Fiscal Period Start Date | No description available. |
| Fiscal Period End Date | No description available. |
