General Ledger Collection Data Training

Welcome to data training for the General Ledger Data Collection. You should review Prerequisites for General Ledger Training (prerequisites include knowledge of the source data via BEN Financials training, required logon IDs, data warehouse access request form, query tool training, and familiarity with database concepts) and How to Use This Tutorial before accessing any of the lessons for the first time.

After completing this training, you should be able to construct most of the General Ledger queries you need. Specifically, you should be able to:

• Select the correct data elements and impose the correct conditions so that you can retrieve data as efficiently as possible
  
• Know what resources are available when you need help in constructing a query
  
• Identify the security considerations involved when using General Ledger data
  
• Identify what data is available, how it is organized, and how to access it as efficiently as possible
  
• Recall specific questions that should be considered when writing a General Ledger query