Skip to end of metadata
Go to start of metadata

 

Purpose 

Advance to Fame Comparison Dashboard is designed to view reconciliations and traceability of transactions between Advance and Fame by various chartfield, Journal Id, Batch ID and Dates.

  • Updating and correcting of script logic which builds the gift journal entries and recording to FAME

  • Development and implementation of a governance process to facilitate and escalate process issues

 

Exception report is designed to view report discrepancy between Advanced and FAME system for pledges and gifts data. Pledges and Gifts data transactions originate in Advance and then flow into FAME. Fame is a system of records of all Debits and Credits. Pledge data will be included 3/17/2017 onwards.

  • Displays and Exception when Journal ID is null 
  • Transaction entered in Advance but a different amount posted to fame. (Monetary Amount in Fame is different from the Advance gift amount)
  • Report Displays an exception when Credit+Debit is greater than 0.00

  • Report allows a user to drill into an Exception for a specific Journal ID/Receipt Id
     

Note: The Exception Report doesn't include allocations for Funds 25 and 75, and it only display exception for a current fiscal year.

 

Who Should use this Dashboard? 

Office of Gift Administration (OGA) Dashboard Pages – Advance to Fame Comparison Report and  Exception Report


Data Source: WebProd is the source of data in UDW+.  Gift process runs on a nightly basis, with the exception of weekend and holidays in FAME and UDW+ would see the data following business day. Agent could send out notification of new records from Tuesday through Saturday


Data Security/Access – Advance to Fame Comparison Dashboard is using Object Security limited to specific users identified by Office of Gift Administration (OGA).


Other Reporting Nuances - When a new exception is identified in a report,  a email notification is sent out to the user community(predetermined by OGA office) informing them for a new record.

 

SourceColumn NamesDescription
AdvanceDate AddedThis is the date that gift process completed. UDW+ would see the data following business day.
NYU_PROCESS_TYPEThis determine a type of transaction, gifts, Gift Reversal, Pledge and Pledge Reversal
Tender TypeMethod of payment such as Cash, Check, Credit Card, EFT, Payroll Deductions, Securities
Transaction TypeType of Transaction For e.g. Gift, Pledge Payment, or a Secondary Pledge Payment
Receipt IdReceipt ID is same as Journal_Ref_line number which is Fed to Fame. It the Key fields to Join advance and Fame and determine exceptions
Batch IdGifts are processed in Batches. Each Batch can have multiple receipt IDs. 
Pledge NumberTypically each Pledge Payment Transaction had associated Pledge number in the exception report. Each pledge has a number associated with it.
Pledge TypeAttribute of a Pledge
Donor IdID associated with a Donor
PurposeThe purpose of the transaction
AccountAccount is Advance if Fund, Org, Program and Project from Fame
AllocationAdvance version of Chart of Accounts, it is a free text field and might or might not align with Account in Fame
Gift AmountGift Amount is a transaction Amount in Advance. Each gift Amount has a corresponding Credit or Debit in Fame. 
Pledge Secondary CodeFor a Pledge, it is a set of code
FAMEJRNL_LN_REFDisplay a text or a number from the reference field of the journal line.
BUSINESS_UNITBusiness Unit associated with a transaction
Journal IDJournal ID is a alphanumeric code identifying a unique transaction on the ledger
Debit AccountDebit Account of the gift Transaction
Debit FundDebit Fund associated with of the gift Transaction
Debit DeptDebit  Department associated with the gift Transaction
Debit ProgramDebit Program associated with the gift Transaction
Debit ProjectDebit Project associated with the gift Transaction
Debit AmountDebit Amount in Fame corresponds with a gift Amount.
Debit Journal LineDebit Journal line is a unique number identifying a journal line of a given Journal transaction
Credit AccountCredit  Account of the gift Transaction
Credit FundCredit  Fund associated with the gift Transaction
Credit DeptIDCredit  Department associated with the gift Transaction
Credit ProgramCredit Program associated with the gift Transaction
Credit ProjectCredit Project associated with the gift Transaction
Credit AmountCredit Amount in Fame corresponds with a gift Amount.
Credit Journal LineCredit Journal line is a unique number identifying a journal line of a given Journal transaction
Debit + CreditDebit(Monetary) Amount + Credit (Monetary) Amount



  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  • No labels