Reference table for historical Billing and Receivables System (BRS) subcodes.
Displaying the attributes of a subcode over time.
||Indexed Data Elements
- 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
- 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.
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
available in the BRS_SUBCODE
- The source of the data is the BRS_DETAIL table in the Data Warehouse.
Questions about this page? Email us at email@example.com
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania