Data Element |
Definition |
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)
|
RCM_ROW
Indexed - yes
Format - number(10)
May be null? yes |
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.'
|
RCM_ROW_PARENT_OBJECT
Indexed - yes
Format - char(4)
May be null? yes |
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.'
|
RCM_CATEGORY
Indexed - yes
Format - number(10)
May be null? yes |
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.'
|
RCM_SUMMARY_PARENT_OBJECT
Indexed - yes
Format - char(4)
May be null? yes |
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.'
|
RCM_TREE_PK
Indexed - yes
Format - number(9)
May be null - no |
The unique identifier for a row in the RCM_OBJECT_TREE table.
|
RCM_TEMPLATE_NAME
Indexed - yes
Format - varchar2(20)
May be null - yes |
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
|