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.
Questions about this page? Email us at da-staff@isc.upenn.edu
|