Penn Computing

University of Pennsylvania
Penn Computing << go backback
BRIM_EXP_CODES Table    Tables and Data Elements   BRIM Home   Data Warehouse Home

BRIM_EXP_CODES Table - Data Element Index

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



Data element Definition

SB_OBJ_PARENT

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

The 4-character code for the Object in the General Ledger's chart of accounts that serves as the parent (or rollup group) for one or more other Objects, allowing amounts to be summarized at the parent level.

An Object identifies the asset, liability, revenue, or expense.

On BRIM invoices, an SB_OBJ_PARENT corresponds to an invoice line.

In the General Ledger, a given parent Object may be associated with more than one child Object, and a given child Object may have more than one parent. However, BRIM includes only Objects that fall
under Object parents SB01 through SB41, and a given Object has only one SB_OBJ_PARENT. All values for SB_OBJ_PARENT begin with 'SB'.

Example: SB01 (Administrative Salaries)


Values: Refer to the BRIM_EXP_CODES table for values. 

BRIM source: AREXDS.expcode

SB_OBJ_PARENT_LONG_DESC

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

The description (up to 35 characters long) that corresponds to the SB_OBJ_PARENT, the rollup group identifying the expenses. This is the description that appears on the invoice.

Example: Administrative Salaries (SB01)


Values: Refer to the BRIM_EXP_CODES table for values.

BRIM source: AREXDS.longdesc

SB_OBJ_PARENT_SHORT_DESC

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

The description (up to 12 characters long) that corresponds to the SB_OBJ_PARENT, the rollup group identifying the expenses. This is the description that appears on the Enter Detail Invoice screen in BRIM.

Example: Sal-Admin (SB01)


Values: Refer to the BRIM_EXP_CODES table for values.

AREXDS.shortdesc

 
BRIM_EXP_CODES Table    Tables and Data Elements   BRIM 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