CJM_PROGRAM_QUALIFIERS
CJM_PROGRAM_QUALIFIERS contains the eligibility rules for the Channel Rebate Programs. All the Level 0 (mandatory qualifiers) and Level 1 Qualifiers will be inserted in this table. Program_line_id will be NULL for the Channel Program Header Level qualifiers and it will be mapped to CJM_PROGRAM_LINES.program_line_id for the line level qualifiers. Mandatory_Qualifier field will be marked as Y for the Level 0 qualifiers. Each Rule will be present in a different Row and all the Rows marked as Y for Mandatory Qualifiers will be appended as AND conditions with each Rule.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_PROGRAM_QUALIFIERS_PK |
PROGRAM_QUALIFIER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROGRAM_QUALIFIER_ID | NUMBER | 18 | Yes | Unique identifier for a Program Qualifier. | |
| PARENT_PROGRAM_QUALIFIER_ID | NUMBER | 18 | Identifier of the parent for the current program qualifier. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PROGRAM_HEADER_ID | NUMBER | 18 | Yes | Unique Identifier for a Channel Program. This is the Foreign key from CJM_PROGRAMS_ALL_B.PROGRAM_HEADER_ID. | |
| PROGRAM_LINE_ID | NUMBER | 18 | Unique Identifier for Channel Program Lines. This is the Foreign key from CJM_PROGRAM_LINES.PROGRAM_LINE_ID. | ||
| QUALIFIER_TYPE_CODE | VARCHAR2 | 30 | The value from the Source Code Name of the Conditions Column, in the Matrix Class. Values are from lookup ORA_CJM_QUALIFIER_TYPE. | ||
| COMPARISON_OPERATOR_CODE | VARCHAR2 | 30 | The relational operator code used to define how the pricing engine should evaluate the qualifier attributes, based on lookup ORA_CJM_MKT_COND_OPERATOR. | ||
| QUALIFIER_VALUE_CODE | VARCHAR2 | 240 | Values, such as customer account identifier in the case of a customer, bill-to site identifier in the case of BILL_TO, and so on. | ||
| QUALIFIER_VALUE_CODE_TO | VARCHAR2 | 240 | The high value for the QUALIFIER_ATTRIBUTE, if the COMPARISON_OPERATOR_CODE is BETWEEN. | ||
| START_DATE | DATE | Date the qualifier becomes effective. | |||
| END_DATE | DATE | Date the qualifier becomes ineffective. | |||
| QUALIFIER_PRECEDENCE | NUMBER | 22 | The precedence number or selectivity of the qualifier attribute in the Qualifier Descriptive Flexfield. Used by the pricing engine for incompatibility resolution. | ||
| QUALIFIER_DATATYPE | VARCHAR2 | 10 | Identifies the datatype of the QUALIFIER_ATTR_VALUE and QUALIFIER_ATTR_VALUE_TO. The values are from lookup ORA_QP_MTRXR_DIMN_DATA_TYPES. | ||
| MANDATORY_QUALIFIER | VARCHAR2 | 1 | Mandatory qualifier for the program. These qualifiers are displayed in the header. | ||
| BENEFICIARY_TYPE_CODE | VARCHAR2 | 30 | Values like CUSTOMER, CUSTOMER NAME, VENDOR, and so on. The values are from lookup ORA_CJM_BENEFICIARY_TYPE. | ||
| BENEFICIARY_VALUE_CODE | VARCHAR2 | 30 | Values, such as customer account identifier in the case of a customer, bill-to site identifier in the case of BILL_TO, and so on. | ||
| HEADER_MATRIX_RULE_ID | NUMBER | 18 | This column is mapped to the DYNAMIC_MATRIX_RULE_ID from QP_MATRIX_RULES table. This matrix rule will be created for the Channel Program when user enters the qualifiers sourced from order header. | ||
| COMMON_MATRIX_RULE_ID | NUMBER | 18 | This column is mapped to the DYNAMIC_MATRIX_RULE_ID from QP_MATRIX_RULES table.This matrix rule will be created for the Channel Program when user enters the qualifiers sourced from order header or order Line. | ||
| RULE_NUMBER | NUMBER | 4 | Number that identifies the leading component in the Display Line Number. The rule number must be an integer greater than 0. The Display Line Number is a unique number and is the concatenation of the rule number and the child rule number separated by a period. For example, if the display line number is 3.1, then the rule number is 3 and the child rule number is 1. | ||
| CHILD_RULE_NUMBER | NUMBER | 4 | Number that identifies the trailing component in the Display Line Number. The child rule number must be blank for the first rule number and must be an integer greater than 0. The Display Line Number is a unique number and is the concatenation of the rule number and the child rule number separated by a period. For example, if the display line number is 5.2, then the rule number is 5 and the child rule number is 2. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER2 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER3 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER4 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER5 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER6 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER7 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER8 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER9 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER10 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CJM_PROGRAM_QUALIFIERS | cjm_programs_all_b | PROGRAM_HEADER_ID |
| CJM_PROGRAM_QUALIFIERS | cjm_program_lines | PROGRAM_LINE_ID |
| cjm_program_conditions | cjm_program_qualifiers | PROGRAM_QUALIFIER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_PROGRAM_QUALIFIERS_N1 | Non Unique | Default | PROGRAM_HEADER_ID |
| CJM_PROGRAM_QUALIFIERS_N2 | Non Unique | Default | QUALIFIER_TYPE_CODE, QUALIFIER_VALUE_CODE |
| CJM_PROGRAM_QUALIFIERS_U1 | Unique | Default | PROGRAM_QUALIFIER_ID |