The BEN Billing and Receivables Data Collection (BBR) is a subset of the University Data Warehouse containing accounts receivable and collections detail information from May 2014 through the current fiscal year.
Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.
Looking for a specific element or caution? Try the searching the collection documentation for particular keywords (search page will open in a new tab).
| AR_ADJUSTMENT Table Elements |
AR_DUNNING Table Elements |
| AR_APPLICATION Table Elements |
AR_PROMISE Table Elements |
| AR_TRANSACTION Table Elements |
AR_NOTE Table Elements |
| AR_TRANSACTION_LINE Table Elements |
GMS_AWARD_LOG Table Elements |
| AR_DELINQUENCY Table Elements |
|
| General Ledger data included in the BEN Billing and Receivables universe: | |
| CNAC_CODES Table Elements |
ORG_CODES Table Elements |
| FUND_CODES Table Elements |
PARENT_FUND_CODES Table Elements |
| OBJECT_CODES Table Elements |
|
| Sponsored Projects data included in the BEN Billing and Receivables universe: | |
| PENNERA_SPONSOR Table Elements |
|
| Salary Management data included in the BEN Billing and Receivables universe: | |
| EMPLOYEE_GENERAL Table Elements |
|
The BEN Billing and Recievables collection is refreshed nightly, Monday through Saturday.
BEN Billing and Recievables details tables (AR_TRANSACTION, AR_TRASNACTION_LINES, AR_ADJUSTMENT, AR_APPLICATION and GMS_AWARD_REPORT_LOG are refreshed following the completion of BEN Financials batch processing around midnight (updates should usually be completed by start of business).
Source of the Data
The data in the Data Warehouse that is accessible via the BusinessObjects BEN Billing and Recievables Universe comes from the BEN Billing and Receivables (BBR) system, sometimes referred to as Grant Projects Accounts Receivable (GPAR), 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.
Time Span Covered
The BEN Billing and Recievables data collection includes data for sponsored projects active at the time of the conversion from the legacy BRIM billing and receivables information management system in May 2014 as well as any sponsored projects initiated during or after May 2014.
Data training for this collection is offered on an ad hoc basis -- please contact Enterprise Information & Analytics for assistance with specific training questions. You can also refer to the table and element documentation for information and cautions about specific data.
Individuals must be authorized to use the General Ledger data collection in the Data Warehouse before they can be granted access to the BEN Billing and Receivables data collection. (Information on how to obtain access to the General Ledger data collection is available here.) Individuals will be granted access to view BEN Billing and Receivables data in the Warehouse for the same organization(s) whose General Ledger data they can view in the Warehouse.
Releasing Data Outside the University
Be cautious about releasing BEN Billing and Receivables data outside the University. If you do not customarily release data outside Penn, and you receive a request for data to be sent outside the University, contact the Office of Research Services (573-6705) or Institutional Research (898-5897).
Releasing Data Within the University
Within the University, BEN Billing and Receivables data may be disclosed only if it is needed to do the business of the University, and only to those who need to know the information in order to do their jobs. If you are not sure whether to fulfill a request for BEN Billing and Receivables data, call the Office of Research Services (573-6705).
Query Results
If you save your query results in Excel, pdf, or any other local file type, you must see to it that any sensitive data stored on your peronal computer is safeguarded through physical security, access control software, or encryption. When a computer is left signed to an account, it is easy for someone to gain unauthorized access. Either sign off from your account before you leave your computer or restrict access by some other means (physical security or access control software).
For more information on security and privacy, contact the Office of Information Security.
If you have a question about the BEN Billing and Receivables data, or if you notice some documentation that needs updating, please contact Enterprise Information & Analytics. For documentation published on the Web, please specify the URL for the documentation that needs to be updated. For BusinessObjects documentation (help for Objects), please specify the Universe, Class, and Object.