Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The reconciliation reports provide the individual and summary level financial transactions  (Daily Revenue and Expense) of the departments. They are meant for internal use only and are not financial statements. All transactions that don't have the source of  'YTD', 'LTD' andf not and not having a fund code of '8000' are displayed. The departments are grouped under divisions.

...

The table below lists all the elements used in the Reports. Detailed glossary for these elements can be found in the MetaMart (https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1)

 

 

Element

Source

(System->Table->Column)

DescriptionFrequency of Update
Anchor
Fiscal Year
Fiscal Year
Fiscal Year
[Finance].[dbo].[REC_DivDepts]->[FiscalYear]  This field holds the fiscal year.Daily
Anchor
Division
Division
Division
[Finance].[dbo].[REC_Divisions]->[DivID]/ DivName]  Division is a grouping of multiple departments and sometimes referred to as the super department.Daily
Anchor
Department
Department
Department

[Finance].[dbo].[REC_DivDepts]->[Deptid]

[Finance].[dbo].[REC_Rev_Expense]->Dept_DESC

  This field holds the department ID and department description.Daily
Anchor
Reporting Month
Reporting Month
Reporting Month

[Finance].[dbo].[REC_Rev_Expense]->REPORTING_PERIOD

Calculated

  This fields holds the fiscal month.Daily
Anchor
Type
Type
Type
[Finance].[dbo].[REC_Rev_Expense]->[REVEXP_TYPE]Values include Revenue or Expense Daily
Anchor
Fund Code
Fund Code
Fund Code
[Finance].[dbo].[REC_Rev_Expense]->[FUND_CODE]  This field identifies the fund code associated with a record.Daily
Anchor
Fund Description
Fund Description
Fund Description
[Finance].[dbo].[REC_Rev_Expense]->[FUND_DESC]  This field holds the fund description.Daily
Anchor
Trans Description Report
Trans Description Report
Trans Description Report

[Finance].[dbo].[REC_Rev_Expense]->[TRANS_DESC_RPT]

  This field holds the transaction descriptionDaily
Anchor
Posted
Posted
Posted
[Finance].[dbo].[REC_Rev_Expense]->[POSTED_DATE]This field holds the posted date.  Daily
Anchor
Doc Num 1 Report
Doc Num 1 Report
Doc Num 1 Report
[Finance].[dbo].[REC_Rev_Expense]->[DOC_NUM_1_RPT]  This field holds the Document Number 1 Report.Daily
Anchor
Invoice
Invoice
Invoice
[Finance].[dbo].[REC_Rev_Expense]->[INVOICE]  This field identifies the invoice for Current Month records with a PIDM (PDaily
Anchor
Actual Amount
Actual Amount
Actual Amount
[Finance].[dbo].[REC_Rev_Expense]->[ACTUAL_AMT]  This field contains the actual amount associated with a transaction. For Cash Total records, it is set to "0".Daily
Anchor
Reconciled
Reconciled
Reconciled
[Finance].[dbo].[REC_Rev_Expense]->[Reconciled]  Values are 'Reconciled' or 'Not Reconciled'Daily
Report Run Date
Anchor
Report Run Date
Report Run Date
 CalculatedDate that the report data was refreshed from sourceReal Time

...