Penn Computing

University of Pennsylvania
Penn Computing << go backback
AR_TRANSACTION Table - Data Element Index   Tables and Data Elements   BEN Billing and Receivables Home   Data Warehouse Home

AR_TRANSACTION Table

Explanation
Contains receivables transaction header details.

Common Uses

  • Reporting on receivables transaction details at the award or transaction header level.
  • Reporting on receivables balances at the award or transaction header level.

Primary Key Indexed Data Elements Related Tables
TRX_ID 
BBR_CUSTOMER_REGISTRY_ID 
BBR_AWARD_NUMBER 
BBR_AWARD_ORGANIZATION 
TRX_ID 
TRX_NUMBER 
TRX_DATE 
TRX_DATE_ACCT_PERIOD 
TRX_DATE_FISCAL_MONTH_SEQ 
TRX_DATE_FISCAL_YEAR 
INV_GL_DATE 
INV_GL_DATE_ACCT_PERIOD 
INV_GL_DATE_FISCAL_MONTH_SEQ 
INV_GL_DATE_FISCAL_YEAR 
PENNERA_SPONSOR_CODE 
INITIAL_CUSTOMER_TRX_ID 
CREDITED_TRX_ID 
RELATED_TRX_ID 
EXTRACT_DATE 
EXTRACT_DATE_PAY_SCHED 
AR_TRANSACTION_LINE
AR_APPLICATION
AR_ADJUSTMENT


Cautions
  • Transaction "balances" such as BALANCE_DUE_TOTAL in the AR_TRANSACTION table always contain the current balance for the transaction. Historical balances for a transaction may be obtained by querying the AR_TRANSACTION_LINE, AR_APPLICATION and AR_ADJUSTMENT tables.
  • A single transaction may span multiple funds. As a reult, fund level balances can only be obtained by querying the AR_TRANSACTION_LINE, AR_APPLICATION and AR_ADJUSTMENT tables.
  • EXTRACT_DATE is the date when the transaction header attributes were extracted from BEN Billing and Receivables and loaded into the Data Warehouse.
  • EXTRACT_DATE_PAY_SCHEDULE is the date when the transaction header balances were extracted from BEN Billing and Receivables and loaded into the Data Warehouse. The EXTRACT_DATE and the EXTRACT_DATE_PAY_SCHEDULE may be different.
  • Users with University-wide access may see all the AR_TRANSACTION records. Users with Organization-based access may see only those records which they are authorized to access based on the BBR_AWARD_ORGANIZATION.

Source

From the AR.RA_CUSTOMER_TRX_ALL and AR.AR_PAYMENT_SCHEDULES_ALL tables in 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.

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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania