Adding New Data Model Columns

You can add additional data model columns to Staging tables. This feature allows you to use data that is not part of the OOB data model, but may be useful in your implementation.

To add a new column to extend your data model, follow these steps:

1. Under Pipeline Administration, select Data Model Extension. The FCCM Cloud Service Data Model Extension page displays.
2. Provide the required details for your new column.
   • Select the entity type of the data you are adding from the Select Entity drop-down list. You can choose from the following tables:
     • Customer populates the STG_PARTY_MASTER_EXT table.
     • Account populates the STG_CASA_EXT table.
     • Transaction populates the STG_CASA_TXNS_EXT table.
   • The Primary Keys field is automatically populated with the primary keys for this field. You cannot edit this field.
   • Enter a Logical Name for the column you want to add, for example, Passport Number. This name must be under 50 characters.
   • Enter the New Attribute Name. This will be the physical name of the column. For example, V_PASSPORT_NUMBER.
   • Select the Data Type from the drop-down list:
     • Number
     • Varchar2
     • Date
     • Timestamp
   • Enter the allowable Data Type Length for the column. For example, 20. This should be at least as long as the maximum expected value for the column you are adding.
   • Select whether Data Type Constraints will apply to the column from the drop-down list. Selecting Unique means that values provided in this column cannot be repeated.
   • Select the type of Environment you want to create this column for. You can select one or both options.
     • Selecting Stage adds this column to the data provided by Oracle customers.
     • Selecting Business adds this column to the data which can be configured to process the data or to populate the UI. This feature is not enabled fully at this time.
     • Selecting Case Management adds this column to the data which can be configured to process the data within the Case Management UI. This option is not enabled at this time.
     • Selecting Know Your Customer adds this column to the data which can be configured for use within the KYC application. This option will only display when either the Customer or Account entity type is selected.
3. Select whether or not this column will be considered Mandatory.
4. Click Add to add this column to the data model extension table, for example STG_PARTY_MASTER_EXT.
5. Enter Comments to explain why you are creating this column.
6. Click Submit. The Attribute details for all custom fields added to Stage tables, or both the Stage and Business tables, display on the right side pane. Columns added to Business tables only will not display in this section.
   When you have successfully added all columns you need, click Download Sample CSV to download a sample data model table containing all the customized columns along with the default columns provided by Oracle. Use this sample file to help you provide data in the proper format. For more information on Oracle's default sample .csv format, see Sample Templates files.

   More information about the default data model and how to load data into the application can be found in Using FCCM Cloud Service Data Loading.