Fixed Assets New Tables Table Name Feature Area Brief Description CSI_FA_HEADERS Notification Process for newly added assets. This table captures asset related information about Fixed assets that are manually added using the Assets Workbench – The generated data is then used in the Generate Notification concurrent process. CSI_FA_TRANSACTIONS Notification Process for newly added assets. This table captures transactional information about Fixed assets that are manually added using the Assets Workbench – The generated data is then used in the Generate Notification concurrent process. CSI_I_ASSET_INTERFACE Open Interface for Instance to Fixed Asset Association This table if loaded with the instance and asset link information will be used by the “Install Base Open Interface” program to create the association between the item instance and the fixed asset. Changed Tables Table Name Feature Area Brief Description of Change CSI_I_ASSETS Improved Integration with Fixed Assets/Common Asset Repository Added NEW Columns · FA_SYNC_FLAG – This tracks whether the Fixed Assets and Item Instances are in sync with respect to quantities and Location Mapping. · FA_MASS_ADDITION_ID – This is the new linking column that stores the information about the record that is written in to FA_MASS_ADDITIONS table when the Asset Tracking concurrent program creates the interface data to create a fixed asset. · CREATION_COMPLETE_FLAG – Column that determines whether the instance to asset link is complete or not. CSI_INSTANCE_INTERFACE Install Base Open Interface · Added Asset Maintenance (EAM) support columns · Added instance attributes from 16 to 30 · Added operational status code column · Added Sync up family column for internal processing. Obsolete Tables Table Name Feature Area Optional - Replaced By CSI_I_ASSET_TXN_TEMP Improved Integration with Fixed Asset This table was used to temporarily hold data before creating assets in FA. Primarily used for grouping purpose. The grouping logic is now handled in the code. iReceivables New Tables Table Name Feature Area AR_IREC_SELFREG_CUST_QS Self Registration AR_IREC_SELFREG_SITE_QS Self Registration ARI_REG_VERIFICATIONS_GT Self Registration AR_IREC_PRINT_REQUESTS Print Request Changed Tables Table Name Feature Area Brief Description of Change AR_SYSTEM_PARAMETERS_ALL System Options Setup, the Receivables Activity type used for Convenience Charges. Added column column IREC_SERVICE_CHARGE_REC_TRX_ID NUMBER(15) Obsolete Tables Table Name Feature Area Optional - Replaced By AR_CUST_SEARCH_GT Customer Search AR_CUST_SEARCH_GT_ALL AR_IREC_CUSTOM_CUST_GT Custom Customer Search AR_IREC_CSTM_CUST_GT_ALL AR_IREC_CUSTOM_SRCH_GT Custom Transaction Search AR_IREC_CSTM_SRCH_GT_ALL AR_IREC_PAYMENT_LIST_GT Transaction List/Payment Page AR_IREC_PAYMENT_GT_ALL HZ_REGISTRATIONS Self Registration HZ_REG_VERIFICATIONS Self Registration New Views View Name Feature Area ARI_CUSTOMER_SEARCH_V Customer search for internal users Changed Views N/A Obsolete Views N/A iExpenses New Tables Table Name Feature Area Brief Description OIE_PDM_DAILY_BREAKUPS Enhanced Global Per Diem and Mileage This table holds per diem data for a rate period. OIE_PDM_DESTINATIONS This table holds per diem destination information. OIE_ADDON_MILEAGE_RATES This table stores additional information for a mileage expense type. OIE_POL_RATES_INTERFACE Staging table for uploading CONUS and OCONUS rates. OIE_ALLOCATION_PREFS Expense Allocations This table stores a person's allocation preferences. OIE_DISTRIBUTION_SETS This table stores distribution sets that make up an allocation preference. OIE_SET_DISTRIBUTIONS This table holds the distribution lines that belong to a distribution set. OIE_AME_NOTIFY_GT Data in OIE_AME_NOTIF_GT will be used for displaying instructions to the approver in the approval notification. Example, You are responsible for approving expenses that total 250.00 USD for cost center 420. OIE_AME_APPROVER_AMT_GT Data in OIE_AME_APPROVER_AMT_GT will be used for displaying Approver Amount in the approval notification.