Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Contents of the View Template Change History Screen

Use the fields and options to configure the View Template Change History screen from the Accounting screen.

To store change data in the FA_TMPLT_AUDIT_LOG table, you must first run the Configure Asset/Template Change Settings screen. You must also access the Asset/ Template Field/Column Names subtask from that screen to select check boxes on a field-by-field basis for Asset Template records. Each check box that you select signifies that you want to capture data for that field for an Asset Template record each time you make a change to that data, regardless of the screen in which the change was made.

The FA_TMPLT_AUDIT_LOG table holds audit history data that is created when you make changes on any of the following screens:

  • Manage Asset Template Information
  • Manage Asset Template User-Defined Information
  • Manage Template Global Changes

In the header of this inquiry screen, you can select a general subset of records to view, including the template/revision number, change date, entry user ID, English column name, and user-defined label name.

Data displays in the table window when you select the Execute button on the toolbar.

Use Query to choose more specific selection criteria or enter selection criteria on the screen fields. Data in the table window is non-editable.

You can view template change history data at any time on this screen once the template change history data has been written to the FA_TMPLT_AUDIT_LOG.

Select general parameters using the fields in the header of this screen, or use Query to select a more specific subset. If you use Query, you will not need to enter any data in the header fields on this screen as selection criteria.

If you do not enter data in this field or in any other header field on this screen, and you do not use Query, all available data from the FA_TMPLT_AUDIT_LOG will display in the table window.

Contents

Field Description
Additional Information on the Header fields

The following describes how the English Column Name and User-Defined Label fields function in the header of this screen:

  • You can specify a single database column name in either data field, by data entry or when you use Lookup (to the S_FA_DB_COL_DEF.ENGL_COL_NAME table).
  • If you leave both fields blank, all database column data will automatically display in the table window (excluding user-defined data and within the confines of your other selection criteria).
  • If you leave the User-Defined Label field blank and you specify a column name in the English Column Name field, data for the specified column will display in the table window. The English Column Name column will not appear on the table window.
  • If you select or enter user-defined text fields in the English Column Name field, these "columns" will also be included as selections during the Lookup to S_FA_DB_COL_DEF.ENGL_COL_NAME.

    If you do not enter a specific user-defined label in the User-Defined Label field, all data for the user-defined field type will automatically be selected (within the confines of your other selection criteria).

  • To print user-defined data for a specific user-defined label, you must select or enter user-defined text fields in the English Column Name field (these "columns" will also be included as selections during the Lookup).

    You must also specify the label in the User-Defined Label data field.

Template

Enter, or click to select, the desired template number of the data you want to view.

If you leave this field blank and you do not use Query, all template numbers from the Asset Audit Log table, within the confines of your other selection parameters, will display in the table window.

Because this is a standard Lookup to the FA_TEMPLATE table, you may find that you have selected template/revision numbers for which change history data do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_TMPLT_AUDIT_LOG table may not be selected.

Note: The Template field is one of several key fields in the Template Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the Template column will not display in the table window.
Rev No

Enter, or click to select, the desired revision number of the data you want to view.

If you leave this field blank and you do not use Query, all revision numbers from the Template Audit Log table, within the confines of your other selection parameters, will display in the table window.

Because this is a standard lookup to the FA_TEMPLATE table, you may find that you have selected template/revision numbers from the lookup for which change history data do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_TMPLT_AUDIT_LOG table may not be selected.

Note: The Rev No field is one of several key fields in the Template Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the Rev No column will not display in the table window.
Change Date

Enter, or click to select, the desired change history entry date for the data you want to view in this field. Lookup is not available at this field.

If you leave this field blank and you do not use Query, all change history entry dates, within the confines of your other selection parameters, will display in the table window.

Note: The Change Date field is one of several key fields in the table. If you enter data in this field and you click the Execute button on the toolbar, the Change Date column will not display.
Entry User ID

Enter, or click to select, the desired user ID for the data you want to view.

If you leave this field blank and you do not use Query, all entry user IDs from the Template Audit Log table, within the confines of your other selection parameters, will display in the table window.

Lookup at this field is to the Template Audit Log table, and will therefore display only entry user IDs for which change history data has been written to the Template Audit Log table (FA_TMPLT_AUDIT_LOG).

Note:

The Entry User ID field is one of several key fields in the Template Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the Entry User ID column will not display in the table window.

English Column Name

Enter, click to select, the desired English column name of the data you want to view.

If you leave this field blank and you do not use Query, all English column names from the Template Audit Log table, within the confines of your other selection parameters, will display in the table window.

Lookup at this field is to the Template Audit Log table and will therefore only display English column names for which change history data has been written to the Template Audit Log table (FA_TMPLT_AUDIT_LOG).

Note: The English Column Name is one of several key fields in the Template Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the English Column Name column will not display in the table window.

Use the rules outlined in the Header Fields documentation section to make your desired selection in this field.

User-Defined Label

Enter, or click to select, the desired user-defined label of the data you want to view.

If you leave this field blank and you do not use Query, all user-defined labels from the Template Audit Log table, within the confines of your other selection parameters, will display in the table window.

Lookup at this field is to the Template Audit Log table, and will therefore display only user-defined labels for which change history data has been written to the Template Audit Log table (FA_TMPLT_AUDIT_LOG).

Note: The User-Defined Label field is one of several key fields in the Template Audit Log table. If you have entered data in this field and you click the Execute button in the toolbar, the User-Defined Label column will not display in the table window.

Use the rules outlined in the Header Fields documentation section to make your desired selection in this field.

Table Window

Please refer to the preceding documentation regarding the relationship between column data displayed in the table window and field data displayed in the screen header. The columns in the table window are non-editable.

Field Description
Template

This column, as applicable, displays the template number for the change history data that you have selected to view.

Rev No

This column, as applicable, displays the revision number for the change history data that you have selected to view.

Change Date

This column, as applicable, displays the change history entry date for the change history data that you have selected to view.

Entry User ID

This column, as applicable, displays the change history entry user ID for the change history data that you have selected to view.

English Column Name

This column, as applicable, displays the English column name for the change history data that you have selected to view.

User-Defined Label

This column, as applicable, displays the user-defined label for the change history data that you have selected to view.

Original Column Value

This column displays the original (old) data from before the change for the records you have selected to view.

New Column Value

This column displays the revised (new) data after the change for the records you have selected to view.