Adding Group Asset IDs with Background Processing

Group asset IDs, like group member assets, can be loaded using a background process. In the Transaction Loader, you use the Default_Profile_SW = "N" option. Consequently, you must load one record for each book of each asset into INTFC_FIN.

Load these required fields into the PS_INTFC_FIN table when adding group asset IDs:

  • INTFC_ID

  • INTFC_LINE_NUM

  • BUSINESS_UNIT

  • ASSET_ID

    This is the group asset ID.

  • BOOK

  • DTTM_STAMP

  • APPROVAL_SW

  • LOAD_STATUS

  • DEFAULT_PROFILE_SW = 'N'

  • CATEGORY

  • METHOD

    Set the method to FL (flat rate).

  • DEPR_PERCENT

  • CONVENTION

  • DEPR_AVG_OPTION

  • IN_SERVICE_DT

  • TRANS_DT

  • CURRENCY_CD

Load these fields into the PS_INTFC_PHY_A record when loading group asset IDs:

  • INTFC_ID

  • INTFC_LINE_NUMBER

  • BUSINESS_UNIT

  • ASSET_ID

    This is the group asset ID.

  • DTTM_STAMP

  • INTFC_TYPE

  • SYSTEM_SOURCE

  • APPROVAL_SW

  • LOAD_STATUS

  • DEFAULT_PROFILE_SW

  • ASSET_STATUS

  • FINANCIAL_ASSET_SW

  • PROFILE_ID

  • GROUP_ASSET_FLAG

  • CURRENCY_CD

  • CUSTODIAN_EFFDT

  • LOCATION_EFFDT

Note: You can include physical attribute data (asset location and asset custodian) for the group asset; however, the custodian and location effective-dated fields are required. The physical attribute data must be loaded into the PS_INTFC_PHY_A table.

Note: If a profile is already created for a group asset ID and you load the group asset ID in a background process, the system detects the profile ID in the PROFILE_DET_TBL table and returns an error.