|
Financial Information Systems |
| a division of Enterprise Information Technology Services | |
Ms. Sharon Burch, Interim Director
(706) 542-5305
Query Table - QUERY.ACC_ACCOUNTING_ME
| Column Name | Definition |
|---|---|
| FISCAL_YEAR | Fiscal Year in which the Accounting Period
occurs Example: the code for FY 1999-2000 is 2000 |
| FY_BEGIN | Date on which the Fiscal Year begins -
approximately the beginning of the month of July Format: MM/DD/YYYY |
| FY_END | Date on which the Fiscal Year ends -
approximately the end of the month of June Format: MM/DD/YYYY |
| ACCOUNTING_PERIOD | Calendar Year and Month of the Accounting Period Format: YYYYMM |
| PERIOD_BEGIN | Date on which the Accounting Period begins -
approximately the beginning of the month Format: MM/DD/YYYY |
| PERIOD_END | Date on which the Accounting Period ends -
approximately the end of the month Format: MM/DD/YYYY |
| REPORT_DATE | Official reporting date for the Accounting
Period - the last day of the month Format: MM/DD/YYYY |
| QUARTER_BEGIN | Date on which the Quarter of the Year containing
the Accounting Period begins -
approximately the beginning of the first month of the quarter Format: MM/DD/YYYY |
| REG_CURRENT_MONTH | Board of Regents code indicating the last completed Accounting Period: 01=Jul, 02=Aug, 03=Sep, etc. |
| REG_PREVIOUS_MONTH | Board of Regents code indicating the previous completed Accounting Period: 01=Jul, 02=Aug, 03=Sep, etc. |
| PURGE_YEAR | Fiscal Year prior to which accounting
transactions will be purged Example: the code for FY 1999-2000 is 2000 |
| PURGE_PERIOD | Calendar Year and Month of the Accounting Period
prior to which accounting transactions will be purged Format: YYYYMM |
| NEXT_FY | Fiscal Year that follows the current one Example: the code for FY 1999-2000 is 2000 |
| NEXT_FY_BEGIN | Date on which the next
Fiscal Year begins -
approximately the beginning of the month of July Format: MM/DD/YYYY |
| NEXT_FY_END | Date on which the next
Fiscal Year ends -
approximately the end of the month of June Format: MM/DD/YYYY |
| PREVIOUS_FY | Fiscal Year that preceded the current one Example: the code for FY 1999-2000 is 2000 |
| Access Services Enterprise Information Technology Services The University of Georgia |