Penn Computing

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

BRS_GL_DETAIL Table - Data Element Index

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



Data element

Definition

ACCOUNT_1

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

The 9-digit legacy number tied to a deferred income for charges, or liability account for payments. Charges could be for items such as tuition, residence or dining; payments might be in the form of financial aid or cash.

ACCOUNT_1_BC

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

The budgetary control character that represents the level at which funds availability checking occurs, for the 26-digit General Ledger account that has been mapped to Account_1.

COA_BC is the third segment of the Accounting Flexfield. 

Examples: 1 (CNAC/ORG/FUND Year-To-Date); T (All Funds Checks). 

Values:
0 Project-to-Date for capital projects
1 CNAC/ORG/FUND Year-To-Date
2 CNAC/ORG/FUND/CREF Year-To-Date
4 CNAC/ORG/FUND/CREF Project-to-Date
A Funds Check parent of 1
B Funds Check parent of 2
D Funds Check parent of 4
T All Funds Checks

 

ACCOUNT_1_CNAC

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

The 3-character center Net Asset Class (NAC) code, for the 26-digit General Ledger account that has been mapped to Account_1. The first two positions of the COA_CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). 

COA_CNAC is the first segment of the Accounting Flexfield. 

Example: 880 (Medical center, Unrestricted) 

Values:
Refer to the CNAC_Codes table for values.

ACCOUNT_1_CREF

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

The 4-character Center Reference code, for the 26-digit General Ledger account that has been mapped to Account_1. This is an identifier uniquely defined by each school or center. 

COA_CREF is used to record information that is important to a school or center but is inappropriate for any other segment of the Accounting Flexfield. The value of the center Reference code is unique within a school or center. 

COA_CREF is the seventh and last segment of the Accounting Flexfield. 

See the definition for CENTER_REF_CODES / CENTER_REF_CODE. 

Examples: 4045 (Graduate Programs); 4091 (SAS Newsletter) 

Values:
Refer to the center_REF_CODES table for values. 

ACCOUNT_1_FUND

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

The 6-character fund number, for the 26-digit General Ledger account that has been mapped to Account_1. A fund is the unique identifier for a specific set of financial resources that needs tracking or management. 

COA_FUND is the fourth segment of the Accounting Flexfield. 

Examples: 000000 (General Unrestricted Fund); 010201 (SAS: GEN FUND 1) 

Values:
Refer to the FUND_CODES table for values.

ACCOUNT_1_OBJ

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

The 4-character OBJECT code, for the 26-digit General Ledger account that has been mapped to Account_1. Identifies the asset, liability, revenue, or expense. 

COA_OBJECT is the fifth segment of the Accounting Flexfield.

Examples: 5220 (EXTERNAL OFFICE SUPPLIES); 1149 (CASH SUSPENSE) 

Values:
Refer to the OBJECT_CODES table for values.

ACCOUNT_1_ORG

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

The 4-character ORGANIZATION code, for the 26-digit General Ledger account that has been mapped to Account_1. This is a subdivision of the University created for management purposes. 

An ORGANIZATION belongs to only one responsibility center, and its ORGANIZATION code is unique. That is, no two ORGANIZATIONs will have the same values for COA_ORG. 

COA_ORG is the second segment of the Accounting Flexfield.

Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies) 

Values:
Refer to the ORG_CODES table for values.

ACCOUNT_1_PROG

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

The 4-character PROGRAM code, for the 26-digit General Ledger account that has been mapped to Account_1. This is an activity or work process commonly defined across the University for tracking a PROGRAM's activity across schools and centers (or across organizations within a school or center).

COA_PROGRAM is the sixth segment of the Accounting Flexfield. 

Examples: 7311 (Alumni Relations); 0001 (Discretionary) 

Values:
Refer to the PROGRAM_CODES table for values.

ACCOUNT_1_RESP_ORG

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

The 4-character code for the organization responsible for managing the fund, for the 26-digit General Ledger account that has been mapped to Account_1. Many organizations may use the same fund, but only one organization -- the COA_RESPONSIBLE_ORG -- is accountable for managing the fund. Those who are authorized to access records for the COA_RESPONSIBLE_ORG for the fund may access all records for the fund, regardless of the value of the COA_ORG in the COA_ACCOUNT for the record. 

Examples: 0011 (NYC Penn Club); 0215 (French Institute). 

Values:
Refer to the ORG_CODES table for values. 

ACCOUNT_2

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

The 9-digit legacy number tied to a revenue or expense account.

ACCOUNT_2_BC

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

The budgetary control character that represents the level at which funds availability checking occurs, for the 26-digit General Ledger account that has been mapped to Account_2.

COA_BC is the third segment of the Accounting Flexfield. 

Examples: 1 (CNAC/ORG/FUND Year-To-Date); T (All Funds Checks). 

Values:
0 Project-to-Date for capital projects
1 CNAC/ORG/FUND Year-To-Date
2 CNAC/ORG/FUND/CREF Year-To-Date
4 CNAC/ORG/FUND/CREF Project-to-Date
A Funds Check parent of 1
B Funds Check parent of 2
D Funds Check parent of 4
T All Funds Checks

ACCOUNT_2_CNAC

Indexed - yes
Format - char (3)
May be null? yes

The 3-character center Net Asset Class (NAC) code, for the 26-digit General Ledger account that has been mapped to Account_2. The first two positions of the COA_CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). 

COA_CNAC is the first segment of the Accounting Flexfield. 

Example: 880 (Medical center, Unrestricted) 

Values:
Refer to the CNAC_Codes table for values.

ACCOUNT_2_CREF

Indexed - yes
Format - char (4)
May be null? yes

The 4-character Center Reference code, for the 26-digit General Ledger account that has been mapped to Account_2. This is an identifier uniquely defined by each school or center. 

COA_CREF is used to record information that is important to a school or center but is inappropriate for any other segment of the Accounting Flexfield. The value of the center Reference code is unique within a school or center. 

COA_CREF is the seventh and last segment of the Accounting Flexfield. 

See the definition for CENTER_REF_CODES / CENTER_REF_CODE. 

Examples: 4045 (Graduate Programs); 4091 (SAS Newsletter) 

Values:
Refer to the center_REF_CODES table for values. 

ACCOUNT_2_FUND

Indexed - yes
Format - char (6)
May be null? yes

The 6-character fund number, for the 26-digit General Ledger account that has been mapped to Account_2. A fund is the unique identifier for a specific set of financial resources that needs tracking or management. 

COA_FUND is the fourth segment of the Accounting Flexfield. 

Examples: 000000 (General Unrestricted Fund); 010201 (SAS: GEN FUND 1) 

Values:
Refer to the FUND_CODES table for values.

ACCOUNT_2_OBJ

Indexed - yes
Format - char (4)
May be null? yes

The 4-character OBJECT code, for the 26-digit General Ledger account that has been mapped to Account_1. Identifies the asset, liability, revenue, or expense. 

COA_OBJECT is the fifth segment of the Accounting Flexfield.

Examples: 5220 (EXTERNAL OFFICE SUPPLIES); 1149 (CASH SUSPENSE) 

Values:
Refer to the OBJECT_CODES table for values.

ACCOUNT_2_ORG

Indexed - yes
Format - char (4)
May be null? yes

The 4-character ORGANIZATION code, for the 26-digit General Ledger account that has been mapped to Account_2. This is a subdivision of the University created for management purposes. 

An ORGANIZATION belongs to only one responsibility center, and its ORGANIZATION code is unique. That is, no two ORGANIZATIONs will have the same values for COA_ORG. 

COA_ORG is the second segment of the Accounting Flexfield.

Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies) 

Values:
Refer to the ORG_CODES table for values.

ACCOUNT_2_PROG

Indexed - yes
Format - char (4)
May be null? yes

The 4-character PROGRAM code, for the 26-digit General Ledger account that has been mapped to Account_2. This is an activity or work process commonly defined across the University for tracking a PROGRAM's activity across schools and centers (or across organizations within a school or center).

COA_PROGRAM is the sixth segment of the Accounting Flexfield. 

Examples: 7311 (Alumni Relations); 0001 (Discretionary) 

Values:
Refer to the PROGRAM_CODES table for values.

ACCOUNT_2_RESP_ORG

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

The 4-character code for the organization responsible for managing the fund, for the 26-digit General Ledger account that has been mapped to Account_2.. Many organizations may use the same fund, but only one organization -- the COA_RESPONSIBLE_ORG -- is accountable for managing the fund. Those who are authorized to access records for the COA_RESPONSIBLE_ORG for the fund may access all records for the fund, regardless of the value of the COA_ORG in the COA_ACCOUNT for the record. 

Examples: 0011 (NYC Penn Club); 0215 (French Institute). 

Values:
Refer to the ORG_CODES table for values. 

BATCH_DATE

Indexed - yes
Format - date
May be null? no

The date this transaction was submitted to the billing system. Null values indicate transactions which have not yet been billed.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. For example: 3/10/2004.

BATCH_REF

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

The batch reference code for this transaction. The first three characters indicate the type of batch load.

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.

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)

C_P

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

Indicates whether the transaction was a charge or payment.

Values:
C(harge)
P(ayment)

DTL_AMOUNT

Indexed - no
Format - number(10,2)
May be null? yes

The amount paid which has been fed to the accounting system (the General Ledger). This determines how much deferred income has been moved to actual income.

LAST_ACTIVITY_DATE

Indexed - no
Format - date
May be null? yes

The date this record was last modified in the Data Warehouse.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. For example: 3/10/2004.

PENN_ID

Indexed - yes
Format - char(8)
May be null? yes

The 8-digit identification number assigned to the employee by the Penn Community system. For example: 77777777. No two persons have the same Penn_ID. Only persons affiliated with the University will be assigned a Penn_ID.

RUN_DATE

Indexed - no
Format - date
May be null? yes

The date this transaction was billed for the first time.

This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. For example: 3/10/2004.

SSN

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

The 9-digit Social Security Number of the student, or the University-assigned Student ID.

SUBCODE

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

A five-digit code used to designate a particular charge or payment. The subcode description used for the transaction. Values are generally 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.

Values: 
1     the first summer session
2     the second summer session
S     special session
BRS_GL_DETAIL Table   Tables and Data Elements   BRS Home   Data Warehouse Home

Questions about this page? Email us at isc-da@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania