Add a Column to the Funding Template (or Project/Shell Funding Sheet)
These procedures are applicable to funding sheet templates, funding sheets, and funding sheets created in project or shell templates.
Funding columns specify the data sources (business process transactions, formulas, values entered manually, etc.) that will be displayed on the project or shell funding sheet. Default columns on funding sheet are Fund Code and Fund Name. If a Fund Attribute form has been imported, in which the label of Fund Code data element and Fund Name data element were modified, then the new labels will be displayed as column headers.
Note: Some project funding columns require assignment information at the project level and cannot be created in the template (for example, Consumed Funds, CBS Funding).
To add a funding column
- Open the funding sheet or template:
- Open the funding template and click the Columns button. The Column Log window opens, displaying the list of existing columns.
- Click New. The Column Properties window opens.
- Complete the Column Properties window as described in the table below.
- Click OK to add the new column.
In this field: | Do this: |
---|---|
Name | The name you choose will appear as the column header. You may manually enter a column name, or, if you leave the Name field blank, the selection you make in the Datasource field will automatically populate the Name field. |
Datasource | All columns must be associated with a data source. The data source that you choose will determine which of the following options are available. The types of Data sources available are: Single Sources: These values roll up from other sources. These include cost type business processes, some pre-defined cost columns. Logical Sources: These include user-defined Manual Entry or Formula columns. |
Single Source | Data sources that contain funding sources and consumption information; that is, Fund subtype of Cost business processes, which allocate funding, Spends business processes that consume funding, and Commit business processes that trigger commitment funding, if used.
|
Logical Sources | Logical sources include:
|
Entry Method | This is applicable for logical data sources. Manual Entry: Choose Direct Entry into Cell to allow entry directly into the cell, or Line Item Content to allow data entry through a line item window. Formula: Values are calculated based on a specified formula entered for the column. Formulas can include the values of other columns. Click the Create button to create the formula. |
Data Format | Applicable for Manual Entry or Formula columns: Currency: right-aligns column contents and includes a currency symbol, formatting the value to the specified currency for the sheet. Percentage: right-aligns the contents and includes a percentage symbol |
Display Mode | Refers to whether the column is displayed on the sheet. Show: This is the default choice. This indicates that column will display by default on the funding sheet to all users with at least "view" permission for the funding sheet. Hide: Hidden columns are active but not displayed and can be accessed by users with "create" permission on the funding sheet. |
Column Position After | The new column will be inserted after the column selected |
Last Published Monday, August 28, 2023