Penn Computing

University of Pennsylvania
Penn Computing << go backback
BRS_SUBCODE Table   Tables and Data Elements   BRS Home   Data Warehouse Home

BRS_SUBCODE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element

Definition

BRS_USER

Indexed - no
Format - char (1)
May be null? yes

Values:
A = Student Financial Aid
B = Billable Agencies
C = Cash payments
D = Dining / Dining Refunds
E = Voided Refunds
F = Fee Codes
H = Student Health
I = Info Assoc Inc Package
L = Short Term / Long Term Loans
M = Blue Cross/ Blue Shield
O = Auxiliary Charges
R = Residence/Housing
T = Tuition
W = Deferments
X = Clearing Accounts
Y = Student Deposits
Z = Bad Checks

C_P

Indexed - no
Format - char (1)
May be null? yes

Indicates whether the subcode is used for a charge or payment.

Values:
C(harge)
P(ayment)

SUBCODE

Indexed - yes
Format - char(5)
May be null? no

A 5 digit number categorizing the transaction. The first 3-digits may represent a type of transaction (e.g., 010 = tuition). In the case of tuition, general fee and tech fee subcodes, the last 2 digits represent the student’s division. This convention applies to tuition and general fees. Subcodes are commonly grouped as follows:

0xxxx = Tuition, Acceptance Fees, General Fees 
     Special Fees & Other
1xxxx = Housing/Fraternities
2xxxx = Dining
3xxxx = Fees (schools, off-campus)
4xxxx = Student deposits
5xxxx = Refunds, Telephone, Damages, Short Term Loans & Other
6xxxx = Loans, Scholarships, Fac/Staff, RA, TA, 
          RF & and dept awards
7xxxx = Temporary Credits, Outside agencies
8xxxx = Outside programs
9xxxx = Payments, Voided refunds

SUBCODE_DESC

Indexed - no
Format - varchar2 (30)
May be null? yes

The default description related to the subcode.

BRS_SUBCODE Table   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