Product – Sub product Definition

OD_HOST_ID

   M

String

A unique ID with which this product can be categorized against a host.

OD_HOST_PRODUCT_CODE

   M

String

This is the product code under which the host system respects this product.

OD_HOST_SUBPROD_CODE

   M

String

This is the sub product code under which the host system identifies this sub product.

OD_PRODUCT_TYPE

   M

String

This is used for categorizing this product / sub product offering.

OD_PRODUCT_CODE

   M

String(10)

This is the product code that is recognized by Canvas and is used as part of its internal storage of profiles, etc.

OD_PRODUCT_DESC

   M

String

This is a column provided to the developer for storing any meaningful comment for quick identification of this product.

OD_SUBPROD_CODE

   M

String

This is the sub product under the provided product that is to be used. This is the code that is recognized by Canvas and is used as part of its internal storage of profiles, etc.

OD_SUBPROD_DESC

M

String

This is a column provided to the developer for storing any meaningful comment for quick identification of this sub product.

OD_PRODUCT_DEFN

O

String

One more categorization provided for the product.

OD_PRODUCT_CATEGORY

O

String

Another categorization option provided for the product. The possible values used are as follows:

• FO – Used for end user facing application
• BO – Used for bank user facing application

CRITERIA_TYPE

M

String

The criteria type (key) against which the data level entitlement is captured as part profiling.

DESCRIPTION

M

String

This is a column provided to the developer for storing any meaningful comment for quick identification of the criteria.

PRODUCT_CODE

M

String(10)

This is the product code that is recognized by Canvas and is used as part of its internal storage of profiles, etc.

SUBPRODUCT_CODE

M

String

This is the sub product under the provided product that is to be used. This is the code that is recognized by Canvas and is used as part of its internal storage of profiles, etc.

ENABLE_FLAG

M

String

Provide this as Y to indicate that this criterion is activated.

SOURCE_TYPE

M

String

Indicates how the possible values for the criterion can be fetched. The default source type is V.
In scenarios where the user is entitled to all source values as defined in the OO_CRITERIA_TYPE_MASTER table, a reserved keyword called $ALL is used. For more information, refer $ALL keyword.
Possible source types when the $ALL keyword is used are as follows:

• V – Product or service values whose data is to be fetched based on the criteria defined. This is the default source type and can be used without the $ALL keyword also.
• Q – Indicates that the source is the result of a query.
• C – Indicates that the source is through a Java class.

SOURCE_VALUE

M

String

Provides the actual value corresponding to the source type.
If the SOURCE_TYPE is V, this is the product or service values whose data is to be fetched based on the criteria defined. To provide multiple values separate the values with comma. For example, Home Loan, Personal Loan.
If SOURCE_TYPE is Q, this is the query to be fired. For example, select LOAN_TYPE from LOAN_TYPE_MASTER where LAUNCHED='Y'.
If the SOURCE_TYPE is C, this is the class that should be invoked. For example, com.intellectdesign.modelhouse.LoanTypesEntitlmentProvider.
This source type is recommended if you want to apply some logic to filter data or if the source is a Web service, database, Excel file, text file, and so on. There is no restriction with respect to the data source when a Java class is used.

LOOKUP_CLASS

M

String

For requests that are raised linked to transaction flow, this is the class that is invoked for evaluating limits against the criteria.

LIMIT_REQUIRED

M

String

This is applicable only for requests that are raised linked to the transaction flow. Provide this as Y to indicate that limit validation should be activated for this criterion.