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

AR_ADJUSTMENT Table

Explanation
Contains adjustment details for header and line level receivables transaction adjustments.

Common Uses

• Reporting on receivables adjustment details at the award, fund, transaction or transaction line level.
• Reporting on receivables adjustments associated with a deposit transaction.
  
  

ADJ_ID

      

BBR_CUSTOMER_REGISTRY_ID 
BBR_AWARD_NUMBER 
BBR_INSTALLMENT_NUMBER 
BBR_PROJECT_NUMBER 
BBR_EVENT_NUMBER 
BBR_TASK_NUMBER 
BBR_RECEIPT_NUMBER 
BBR_AWARD_ORG 
BBR_PROJECT_ORG_CODE 
COA_RESPONSIBLE_ORG 
ADJ_ID ADJ_NUMBER 
TRX_ID TRX_NUMBER 
TRX_LINE_ID 
TRX_LINE_NUMBER 
ADJ_APPLY_DATE 
ADJ_APLY_DATE_ACCT_PERIOD 
ADJ_APLY_DATE_FISCAL_MONTH_SEQ 
ADJ_APLY_DATE_FISCAL_YEAR 
ADJ_GL_DATE 
ADJ_GL_DATE_ACCT_PERIOD 
ADJ_GL_DATE_FISCAL_MONTH_SEQ 
ADJ_GL_DATE_FISCAL_YEAR 
ADJ_GL_POSTED_DATE 
PENNERA_SPONSOR_CODE 
COA_CNAC 
COA_ORG 
COA_BC 
COA_FUND 
COA_OBJECT 
COA_PROGRAM 
COA_CREF 
EXTRACT_DATE

AR_TRANSACTION
AR_TRANSACTION_LINE
AR_APPLICATION

• The AR_ADJUSTMENT table may contain "header level" adjustments. These adjustments are not applied to a specific transaction line but to the transaction as whole. Header level adjustment records cannot be related to a specfic line and the TRX_LINE_ID field will be null for these records.
• 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 AR_ADJUSTMENT records. Users with Organization-based access may see only those records which they are authorized to access based on the BBR_AWARD_ORG, BBR_PROJECT_ORG_CODE, COA_RESPONSIBLE_ORG or COA_ORG.

Source

The AR.AR_ADJUSTMENTS_ALL 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.

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