• OBJECT_CODE
• OBJECT_DESC
• RCM_ROW
• RCM_ROW_DESCRIPTION
• RCM_ROW_PARENT_OBJECT
• RCM_CATEGORY
• RCM_CATEGORY_DESCRIPTION

• RCM_CATEGORY_PARENT_OBJECT
• RCM_SUMMARY
• RCM_SUMMARY_DESCRIPTION
• RCM_SUMMARY_PARENT_OBJECT
• RCM_TREE_PK
• RCM_TEMPLATE_NAME

OBJECT_CODE

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

The 4-character code that identifies an asset, liability, revenue, or expense. OBJECT_CODE is the fifth segment of the Accounting Flexfield.

Examples: 5220 (EXT OFF SUPPLY); 1310 (INSURANCE)

OBJECT_DESC

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

The description that corresponds to the OBJECT_CODE identifying the asset, liability, revenue, or expense.

Examples: EXT OFF SUPPLY (5220); INSURANCE (1310)

The row sequence number for an object code, or aggregation of object codes, found on a standard RCM report. This determines the sort order of rows in the template. For example, the 'Grad & Prof Fin Aid' RCM_Row is 250.

RCM_ROW_DESCRIPTION

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

The label for an object code, or aggregation of object codes, found on a standard RCM report, which corresponds to the RCM_Row. For example, RCM_Row_Description for RCM_Row 250 is 'Grad & Prof Fin Aid.'

The Parent_Object_Code corresponding to the RCM_Row for a row found on a standard RCM report. For example, the RCM_Row_Parent_Object for RCM_Category 250 is 'K004.'

The row sequence number for a high-level aggregation of object code, found on a standard RCM report. This determines the sort order of rows in the template. For example, the 'Tuition & Fees' RCM_Row is 300.

RCM_CATEGORY_DESCRIPTION

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

The label for a high-level aggregation of object code, found on a standard RCM report, which corresponds to the RCM_Category for the row. For example, RCM_Category_Description for RCM_Category 300 is 'Tuition & Fees.'

RCM_CATEGORY_PARENT_OBJECT

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

The Parent_Object_Code corresponding to the RCM_Category for a row found on a standard RCM report. For example, the RCM_Category_Parent_Object for RCM_Category 300 is 'K009.'

RCM_SUMMARY

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

The row sequence number for the highest level aggregation of object code, found on a standard RCM report. This determines the sort order of rows in the template. For example, the 'REV & TRANSFERS' RCM_Summary is 790.

RCM_SUMMARY_DESCRIPTION

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

The label for the highest level aggregation of object code, found on a standard RCM report, which corresponds to the RCM_Summary for the row. For example, RCM_Summary_Description for RCM_Summary 790 is 'REV & TRANSFERS.'

The Parent_Object_Code corresponding to the RCM_Summary for a row found on a standard RCM report. For example, the RCM_Summary_Parent_Object for RCM_Summary 790 is 'K035.'

The unique identifier for a row in the RCM_OBJECT_TREE table.

The name of the template. Templates are used in General Ledger reports to provide consistency across reports with respect to row labels and object code groupings.

Example: RCM_TEMPLATE_1A