GMS_AWARD_REPORT_LOG Table - Data Element Index   Tables and Data Elements   BEN Billing and Receivables Home   Data Warehouse Home

GMS_AWARD_REPORT_LOG Table

Explanation
Contains information about financial reports generated for sponsored projects.

Common Uses

• Reporting on sponsored project reporting requirements and report due dates.
  
  

BBR_AWARD_NUMBER
SEQUENCE_NO

      

BBR_AWARD_NUMBER 
BBR_AWARD_ORG 
FIN_RPT_DUE 
FIN_RPT_DUE_ACCT_PERIOD 
FIN_RPT_DUE_FISCAL_MONTH_SEQ 
FIN_RPT_DUE_FISCAL_YEAR 
FILED_DATE 
FILED_DATE_ACCT_PERIOD 
FILED_DATE_FISCAL_MONTH_SEQ 
FILED_DATE_FISCAL_YEAR 
SEQUENCE_NO 
BBR_PROJECT_ORG_CODE 
EXTRACT_DATE 

GMS_AWARD_REPORT_LOG_SNAP

• EXTRACT_DATE is the date when the record was extracted from BEN Billing and Receivables and loaded into the Data Warehouse.
• Users with University-wide access may see all the GMS_AWARD_REPORT_LOG records. Users with Organization-based access may see only those records which they are authorized to access based on the BBR_AWARD_ORG or BBR_PROJECT_ORG_CODE.

Source

The XXGMSC.UP_GMS_AWARD_REPORTS_LOG table in from the BEN Billing and Receivables (BBR) system used by the Office of Research Services.

BEN Billing and Receivables is used to track award payments due and received for sponsored project funds where the sponsors either send payments as they are billed for project expenses, or send payments based on a schedule.

GMS_AWARD_REPORT_LOG Table - Data Element Index   Tables and Data Elements   BEN Billing and Receivables Home   Data Warehouse Home