|
ALTERNATE_LABEL_NAME
Indexed - no
Format - varchar2(150)
May be null? yes
|
Used in some reports to print the text in this column as the row label,
instead of the text contained in the Label_Name.
|
|
BDGT_LVL1_LABEL
Indexed - no
Format - varchar2(80)
May be null? yes
|
If this row is a summary line, the value here is used for the row description
when an alternate label name (than that which exists in the LABEL_NAME
column) is desired. In such cases, this value is used to populate the
RCM_SUMMARY_DESCRIPTION value for an object code in the RCM_OBJECT_TREE
table in the Data Warehouse. Currently used for RCM_TEMPLATE_1A only.
|
BDGT_LVL1_ROLLUP
Indexed - no
Format - number(10)
May be null? yes |
The line number of the summary line that includes this template line
item. Used to determine the RCM_SUMMARY value for an object code in the
RCM_OBJECT_TREE table in the Data Warehouse. Currently used for RCM_TEMPLATE_1A
only.
|
|
BDGT_LVL2_LABEL
Indexed - no
Format - varchar2(80)
May be null? yes
|
If this row is a summary line, the value here is used for the row description
when an alternate label name (than that which exists in the LABEL_NAME
column) is desired. In such cases, this value is used to populate the
RCM_CATEGORY_DESCRIPTION value for an object code in the RCM_OBJECT_TREE
table in the Data Warehouse. Currently used for RCM_TEMPLATE_1A only.
|
|
BDGT_LVL2_ROLLUP
Indexed - no
Format - number(10)
May be null? yes
|
The line number of the summary line that includes this template line
item. Used to determine the RCM_CATEGORY value for an object code in the
RCM_OBJECT_TREE table in the Data Warehouse. Currently used for RCM_TEMPLATE_1A
only.
|
COL_SUPPRESS_10X
Indexed - no
Format - varchar2(1)
May be null? yes |
Used for RCM reports only, in conjunction with the Alternate_Label_Name
column.
|
|
FUND_PARENT
Indexed - no
Format - varchar2(20)
May be null? yes
|
No longer used in report templates.
|
HREF
Indexed - yes
Format - varchar2(20)
May be null? yes |
For RCM templates only, lists the object parent or single object associated
with the row. Will be blank for label rows.
|
|
HREF_TYPE
Indexed - yes
Format - varchar2(1)
May be null? yes
|
For RCM templates only, indicates whether the HREF value is an object
parent (P), or single object code (C). Will be blank if HREF is blank.
|
|
LABEL_NAME
Indexed - no
Format - varchar2(150)
May be null? yes
|
Description of the row exactly as it is printed on the report, including
precise indentations used for various row labels.
|
LAST_UPDATED
Indexed - no
Format - date(7)
May be null? yes |
No longer used in report templates.
|
MARKER
Indexed - no
Format - varchar2(10)
May be null - yes |
For RCM_TEMPLATE_5A, RCM_TEMPLATE_5B, and RCM_TEMPLATE_5C only, used
on an experimental basis to indicate whether a row represents revenue
(R), expense (E), cost recovery (C), or final year-end adjustments (F).
|
MASTER_PARENT
Indexed - no
Format - varchar2(1)
May be null - yes |
No longer used in report templates.
|
|
NOTE
Indexed - no
Format - varchar2(2000)
May be null? yes
|
No longer used in report templates.
|
PARENT_SEQUENCE
Indexed - no
Format - number(10)
May be null? yes |
Used for RCM templates only, to support the drilldown features of the
Revenue/Expense Inquiry Form. Specifies the sequence number of the row
that a row rolls up to. Values will be blank for label rows, rows of Sequence
higher than 1580, and rows where Summary_Detail is 'Y'.
|
PART1_SUMMARY
Indexed - no
Format - varchar2(5)
May be null? yes |
For Template_4A only, used only for those rows that appear on the Part
1 Summary portion of the report.
|
|
REPORT_PARENT
Indexed - no
Format - varchar2(100)
May be null? yes
|
Used in non-RCM reports to indicate the object parent that will be used
for balances for the row.
|
| ROW_SUPPRESS_10X
Indexed - no
Format - varchar2(1)
May be null? yes
|
Used for RCM reports only, to indicate whether the row should be excluded
(Y) from a 10X report.
|
| ROW_SUPPRESS_20X
Indexed - no
Format - varchar2(1)
May be null? yes
|
Used for RCM reports only, to indicate whether the row should be excluded
(Y) from a 20X report.
|
| ROW_SUPPRESS_21X
Indexed - no
Format - varchar2(1)
May be null?yes
|
Used for RCM reports only, to indicate whether the row should be excluded
(Y) from a 21X report.
|
| ROW_TEMPLATE_205
Indexed - no
Format - varchar2(30)
May be null? yes
|
No longer used in report templates.
|
| ROW_TEMPLATE_20X
Indexed - no
Format - varchar2(30)
May be null? yes
|
No longer used in report templates.
|
| ROW_TEMPLATE_21X
Indexed - no
Format - varchar2(30)
May be null? yes
|
No longer used in report templates.
|
| SEQUENCE
Indexed - no
Format - number(10)
May be null? yes
|
A unique identifier for a row within a template; determines the order
in which rows will appear on the report.
|
| SPACING
Indexed - no
Format - number(5)
May be null? yes
|
No longer used in report templates.
|
| SPECIAL_CALCULATION
Indexed - no
Format - varchar2(2000)
May be null? yes
|
For RCM templates only, used to define special programming logic associated
with the last few rows on the template (Operating Surplus/Deficit, Cash
Position, etc.).
|
| SPECIAL_HANDLING
Indexed - no
Format - varchar2(2000)
May be null? yes
|
For RCM templates only, used to define special programming logic associated
with the last few rows on the template (Operating Surplus/Deficit, Cash
Position, etc.).
|
| SUMMARY
Indexed - no
Format - varchar2(5)
May be null? yes
|
For some non-RCM reports, indicates special treatment for a row. For
example, for Template_3, indicates whether the row is a label row (L),
data is summarized (Y), the row is a total line which should be suppressed
for zero values (T), or the row is a total line which should be displayed
even if totals are zero (S).
|
| SUMMARY_DETAIL
Indexed - no
Format - varchar2(40)
May be null? yes
|
For RCM templates only, used by the 10X level reports to determine the
level of detail to be printed on the report. Distinguishes between row
labels (Lnnn), and summary lines (N), and total lines (Y).
|
| SUMMARY_LABEL_NAME
Indexed - no
Format - varchar2(150)
May be null? yes
|
For Template_4A only, indicates the label name to be used for the row
on the Part 1 Summary portion of the 137 report.
|
| SUMMARY_SPACING
Indexed - no
Format - number(9)
May be null? yes
|
For Template_4A only, used only for those rows that appear on the Part
1 Summary portion of the report.
|
| SUMMARY_SUMMARY
Indexed - no
Format - varchar2(40)
May be null? yes
|
For RCM templates only, used by the 21X level reports to determine the
level of detail to be used for each row on the report. Distinguishes between
row labels (Lnnn), summary lines (T), and total lines (Y).
|
| SUPPRESS_ZEROES
Indexed - no
Format - varchar2(1)
May be null? yes
|
For RCM templates only, indicates whether the line is a label only, with
no balances listed (L), whether the row should be suppressed if all balances
are zero (Y), or whether the row should be displayed even if all balances
are zero (N).
|
| 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.
|
