Use this report to print change data stored in the audit history tables for Asset Master records and/or Asset Template records.
To store change data in the ASSET_AUDIT_LOG table and/or the FA_TMPLT_AUDIT_LOG table (as applicable), you must use the Asset/Template Change Settings screen to indicate whether you generally want to capture Asset Master changes and/or Asset Template changes. Then you must access the Asset/Template Field/Column Names subtask of that screen to select checkboxes on a field-by-field basis for Asset Master and/or Asset Template records, as applicable. Each checkbox that you select signifies that you want to capture data for that field for an Asset Master and/or Asset Template record each time you make a change to that data, regardless of the screen in which the change was made.
Provided that selection has occurred as described, the ASSET_AUDIT_LOG table holds audit history data that is created when you make changes in any of the following screens:
Maintain Asset Master Info (main screen and all subtasks)
Maintain Asset Desc Info
Maintain Asset Purchase Info
Maintain Asset Cost Info
Maintain Asset Location Info
Maintain Asset Account Info
Maintain Asset G/L Book Info
Maintain Asset Other Books Info
Maintain Asset Disposal Info
Maintain Asset Government Info
Maintain Asset User-Defined Info
Asset Master Info Global Changes
Asset Master UDF Info Global Change
The FA_TMPLT_AUDIT_LOG table holds audit history data that is created when you make changes in any of the following screens:
Maintain Asset Template Info (main screen and all subtasks)
Maintain Template User-Defined Info
Template Info Global Changes
Template UDF Info Global Changes
You can print Asset Master record changes stored in the ASSET_AUDIT_LOG table or you can print Asset Template record changes stored in the FA_TMPLT_AUDIT_LOG. You must run each type of print (Asset or Template) separately from this screen. In addition, for the selected data print type (Asset or Template), you can print history data either for changes to the user-defined fields only or for changes to the database fields only (excluding the user-defined fields).
You must first select the Asset Change History or the Template Change History data type for the report.
If you select Asset Change History data type, you must also select asset/item numbers for the report.
If you select Template Change History data type, you must also select template/revision numbers for the report.
You must also print change history related to user-defined fields or for database fields excluding the user-defined fields. Depending on this decision, use Lookup to choose either the database column name or the User-Defined Label, as applicable.
Regardless of the data type selected for the report, you can also select a user ID and a range of change dates and/or fiscal years/periods.
You can also print data for active records, inactive records, disposals, depreciable records, and/or non-depreciable records.
Sort options for the change history include the following: Asset/Item No, Template/Rev No, Change Date, User ID, Database Column Name, User-Defined Label, or Fiscal Year/Period. You can select the Page Break checkbox for many of these sort options.
You can print this report at any time. The system incrementally stores additional change history data per your selections in the Asset/Template Change Settings screen; the table data is not replaced. You can delete the change data only by running the Purge Asset/Template Change History process.
Change history data prints on the report based on your selection parameters and the data that resides in the ASSET_AUDIT_LOG table and/or the FA_TMPLT_AUDIT_LOG table (as applicable) at the time you run the report.
Use the radio buttons in this group box to print asset change history OR template change history. This report automatically prints data for each selected asset/item number (within the parameters of your other selection criteria).
This radio button is selected by default. Select this radio button to print asset change history on the report.
If you select this radio button, you cannot select or sort by template/revision number.
If you select this radio button and save the report parameter selections, "A" will be stored in the Select Data Type column in the Query table.
This radio button is unselected by default. Select this radio button to print template change history on the report.
If you select this radio button, you cannot select or sort by asset/item number.
If you select this radio button and save the report parameter selections, "T" will be stored in the Select Data Type column in the Query table.
Use the fields in this group box to select the asset/item number(s) for which to print change history data. The fields in this group box are available only if you have selected the Asset Change History radio button in the Select Data Type group box.
If you enter an asset number, you must also enter a corresponding item number.
Use this drop-down box to select a range option. Range options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "Range."
If you save the print parameters for this report, the selected range option, as applicable, will be stored in the Query table in the Asset Range Option column.
Enter the beginning asset/item number for the Range Option or use Lookup to select one. Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset number that does not meet your other selection criteria.
If you select "All" or "From Beginning" in the Range Option field, these fields will be inactive.
If you save the print parameters for this report, the selected From values, as applicable, will be stored in the Query table in the From Asset No and From Item No columns.
Enter the ending asset/item number for the Range Option or use Lookup to select one. Because this is a standard Lookup to the ASSET table, you may find that you have selected an item number that does not meet your other selection criteria.
If you select "All," "One," or "To End" in the Range Option field, these fields will be inactive.
If you save the print parameters for this report, the selected To values, as applicable, will be identified in the Query table in the To Asset No and To Item Number columns.
Use the fields in this group box to select the template/revision number(s) for which to print change history data. The fields in this group box are available only if you have selected the Template Change History radio button in the Select Data Type group box.
Use this drop-down box to select a range option. Range options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "Range."
If you save the print parameters for this report, the selected range option, as applicable, will be stored in the Template Range Option column in the Query table.
Enter the beginning template/revision identifier in this field or use Lookup to select one.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value(s), as applicable, will be stored in the From Template No and From Rev No columns in the Query table.
Enter the ending template/revision identifier in this field or use Lookup to select one.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value(s), as applicable, will be stored in the To Template No and To Rev No columns in the Query table.
Use the fields in this group box to print change history for database fields excluding the user-defined fields OR for user-defined fields on the report. The following describes how the single-selection Database Column and User-Defined Label fields function:
You can specify a single database column name in either field either by data entry or by using Lookup (to FA_DB_COL_DEF.ENGL_COL_NAME).
If you leave both fields blank, all database column data will automatically print on the report (excluding user-defined data and within the confines of the other selection criteria).
If the User-Defined Label field is left blank and you specify a column name in the Database Column field (other than "User-Defined Text," "User-Defined Date," "User-Defined Numeric," or "User-Defined Validated Text"), data for the specified column will print on the report.
If you select or enter "User-Defined Text," " User-Defined Date," "User-Defined Numeric," or "User-Defined Validated Text" in the Database Column field (these "columns" will also be included as selections during the Lookup to FA_DB_COL_DEF.ENGL_COL_NAME) AND if you do not enter a specific UDF label in the User-Defined Label field, all data for the user-defined field type will automatically be selected (within the confines of the other selection criteria).
To print UDF data for a specific user-defined label, you must select or enter "User-Defined Text," "User-Defined Date," " User-Defined Numeric," or "User-Defined Validated Text" in the Database Column field (these "columns" will also be included as selections during the Lookup) AND you must also specify the label in the User-Defined Label data field.
The User-Defined Label field is disabled if the data entered in the Database Column field is NOT one of the following: "User-Defined Text," "User-Defined Date," "User-Defined Numeric," or "User-Defined Validated Text."
Use the field in this group box to print change history for a single user ID or for all user IDs on the report. The following describes how the single-selection User ID field functions:
You can specify data for a single user ID by entering that user ID in this field or by using Lookup.
If you leave this field blank, data for ALL USERS (that meet the other specified selection parameters) will be printed on the report.
If you select the Asset Change History radio button in the Select Data Type group box, Lookup will access the ASSET_AUDIT_LOG.ENTR_USER_ID table.
If you select the Template Change History radio button in the Select Data Type group box, Lookup will access the FA_TMPLT_AUDIT_LOG.ENTR_USER_ID.
Use the fields in this optional group box to select the change dates for which to print change history data. The change date is the date at which changed data is saved in the ASSET_AUDIT_LOG table and/or the FA_TMPLT_AUDIT_LOG table, as applicable.
Use this drop-down box to select a range option. Range options include "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "Range."
If you save the print parameters for this report, the selected range option, as applicable, will be stored in the Query table in the Change Date Range Option column.
Enter the beginning change date for the Range Option.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be stored in the Query table in the From Change Date column.
Enter the ending change date for the range option.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be stored in the Query table in the To Change Date column.
Select this pushbutton to display additional selection criteria for the report.