BRS_SUBCODE_HISTORY_V Table - Data Element Index
Select a data element to view its definition and its indexed,
format, and null values.
Data element
|
Definition
|
BRS_DESC
Indexed - no
Format - varchar2 (30)
May be null? yes
|
The description related to the subcode. This may be an
ad-hoc description, different from the default description for the subcode,
as based on a weekly feeder or other override. This is the description
used for the subcode at the time the detail record was created, and is
not updated over time. For a list of current subcode descriptions, refer
to the BRS_SUBCODE table.
|
BRS_TERM
Indexed - yes
Format - char (3)
May be null? no
|
The 3-digit Term Code in the format TYY, where T is 1=Fall,
2=Spring, 3=Summer1, 4=Summer2 and YY is the 2-digit calendar year.
Example: 103 (corresponds to 2003C, which means Fall 2003), 203 (corresponds
to 2003A, which means Spring 2003), 303 and 403 (representing Summer
1 and 2 sessions, respectively; corresponds to 2003B, which means Summer
2003)
|
BRS_USER
Indexed - no
Format - char (1)
May be null? yes
|
This is the user code for the subcode at the time the detail
record was created, and is not updated over time. For a list of current
subcode user codes, refer to the BRS_SUBCODE table.
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 |
TERM
Indexed - no
Format - char(5)
May be null? yes
|
The SRS term corresponding to the BRS_Term. Penn divides
the academic year into 3 terms or semesters: Fall, Spring, and Summer.
Terms are designated by the 4-digit calendar year, followed by a term code.
The Spring term code is A, the Summer term code is B, and the Fall term
code is C. Since the BRS_Term is in TYY format (where the first digit represents
the term, and the second two digits the calendar year), the BRS_Term values
of 1 through 4 (1=Fall, 2=Spring, 3=Summer1, 4=Summer2) are translated
to the appropriate letter term, and the 2-digit year is converted to a
4-digit format.
Example: 2003C means Fall 2003 (corresponds to BRS_Term 103), 2003A
means Spring 2003 (corresponds to BRS_Term 203), 2003B means Summer
2003 (correponds to BRS_Terms 303 and 403, representing Summer 1 and
2 sessions, respectively)
|
TERM_SESSION
Indexed - no
Format - char(1)
May be null? yes
|
For summer terms, represents the session in which the
student was billed.
Values:
1 the first summer session
2 the second summer session
S special session
Null 12 week session
|
TUIT_AUD_CODE
Indexed - no
Format - char(1)
May be null? yes
|
Tuition Calculation flag.
Values:
Y Calc
Null Do Not Calc
|
Questions about this page? Email us at da-staff@isc.upenn.edu
|