Populating Loader Tables

To load retired assets using the ARA load type, follow these instructions to populate the loader tables:

• If you have a valid asset profile that is effective-dated correctly and the assets have the same amounts for cost, depreciation, gain/loss, and so on for each book (use the same depreciation conventions), you can load the retired assets with the DEFAULT_PROFILE_SW set to Y.

  In this case, you should set DEFAULT_PROFILE_SW to Yon INTFC_FIN and INTFC_PHY_A, enter the valid profile ID in INTFC_PHY_A, and make only one entry in INTFC_FIN for each asset. Leave the BOOK field blank.

• If this is not the case, set the DEFAULT_PROFILE_SW to N and load one record for each book for each asset into INTFC_FIN. Consequently, if one asset reports to two books, you will load two records for the asset into INTFC_FIN.

Enter the accumulated depreciation into INTFC_FIN.DEPR, one entry for every ChartField combination. Each entry in INTFC_FIN corresponds to a row in PS_DEPRECIATION.

To simplify populating the load tables, one entry in INTFC_FIN is used to create both an ADD and a RET cost row for each book.

The key difference between the ADD and the RET rows is the DTTM_STAMP. The Transaction Loader loads the ADD row first, and then it increments the DTTM_STAMP by one day, sets the RETIRE_SW to 1, and multiplies COST and QUANTITY by negative 1 (−1). It then loads this as the RET row.

Note that when the Transaction Loader finishes successfully, values in all the INTFC_FIN rows for ARA INTFC_TYPE and INTFC_ID will have changed. If you want to rerun the transaction using the same INTFC_ID entries:

• Subtract one day from DTTM_STAMP.

• Set RETIRE_SW back to 0.

• Set the LOAD_STATUS to New (pending).

• Multiply the COST and QUANTITY by negative 1 (−1).

These actions restore the rows to their original values.