Penn Computing

University of Pennsylvania
Penn Computing << go backback
BRS_SUBCODE_HISTORY_V Table - Data Element Index   Tables and Data Elements   BRS Home   Data Warehouse Home

BRS_SUBCODE_HISTORY_V Table

Explanation
Reference table for historical Billing and Receivables System (BRS) subcodes.

Common Uses
Displaying the attributes of a subcode over time.

Primary Key Indexed Data Elements Related Tables
SUBCODE
BRS_DESC
BRS_TERM
None
BRS_DETAIL
BRS_SUBCODE

Cautions
  • BRS_SUBCODE_HISTORY_V is a view of the subcode data as it was at a point in time, when used in a Detail transaction. The view selects distinct combinations of subcode, subcode description, user code, C_P indicator and tuition audit code from the BRS_DETAIL table, to facilitate querying subcodes (or their attributes over time).


  • To see a list of subcodes currently used in the BRS system, refer to the BRS_SUBCODE table, which only lists current subcodes and their attributes. Since subcode attributes, such as the desciption, user code, etc., can vary over time, these attributes are not updated in BRS_DETAIL (or BRS_SUBCODE_HISTORY_V) once the record has been created. There may exist records in the BRS_DETAIL and BRS_SUBCODE_HISTORY_V tables with subcodes that are no longer in existence, and therefore not available in the BRS_SUBCODE lookup table.

Source

  • The source of the data is the BRS_DETAIL table in the Data Warehouse.
BRS_SUBCODE_HISTORY_V Table - Data Element Index   Tables and Data Elements   BRS 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