Versions Compared

Old Version 7

changes.mady.by.user Sunitha Balasubramanian

Saved on

compared with

New Version 8

changes.mady.by.user Sunitha Balasubramanian

Saved on

Key

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

...

Element

Source

(System->Table->Column)

DescriptionFrequency of Update
Anchor
Fiscal Year
Fiscal Year
Fiscal Year		Sid[Finance].[dbo].[REC_DivDepts]->[FiscalYear]  
Anchor
Division
Division
Division 		[Finance].[dbo].[REC_Divisions]->[DivID]/ DivName]  
Anchor
Department
Department
Department

DEPTID

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

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

  
Anchor
Reporting Month
Reporting Month
Reporting Month 

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

Calculated

  
Anchor
Type
Type
Type		[Finance].[dbo].[REC_Rev_Expense]->[REVEXP_TYPE] Values include Revenue or Expense 
Anchor
Fund Code
Fund Code
Fund Code		[Finance].[dbo].[REC_Rev_Expense]->[FUND_CODE]  
Anchor
Fund Description
Fund Description
Fund Description		[Finance].[dbo].[REC_Rev_Expense]->[FUND_DESC]  
Anchor
Trans Description Report
Trans Description Report
Trans Description Report

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

  
Anchor
Posted
Posted
Posted		[Finance].[dbo].[REC_Rev_Expense]->[POSTED_DATE]  
Anchor
Doc Num 1 Report
Doc Num 1 Report
Doc Num 1 Report		[Finance].[dbo].[REC_Rev_Expense]->[DOC_NUM_1_RPT]  
Anchor
Invoice
Invoice
Invoice		[Finance].[dbo].[REC_Rev_Expense]->[INVOICE]  
Anchor
Actual Amount
Actual Amount
Actual Amount		[Finance].[dbo].[REC_Rev_Expense]->[ACTUAL_AMT]  
Anchor
Reconciled
Reconciled
Reconciled		[Finance].[dbo].[REC_Rev_Expense]->[Reconciled]  
Report Run Date
Anchor
Report Run Date
Report Run Date
 Date that the report data was refreshed from sourceReal Time

...