CJM_PROGRAMS_MATRIX_MAP_ALL

This table contains the mapping between the pricing dynamic matrix ID and the program for the combination of PROGRAM_TYPE_ID, BU_ID, and the PRICING_DATE_TYPE_CODE.

Details

• Schema: FUSION

• Object owner: CJM

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CJM_PROGRAMS_MATRIX_MAP_ALL_PK	MATRIX_MAP_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MATRIX_MAP_ID	NUMBER		18	Yes	Unique identifier for the CJM_PROGRAM_MATRIX_MAP table.
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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
BU_ID	NUMBER		18	Yes	Identifier of the business unit associated with the row.
PROGRAM_TYPE_ID	NUMBER		18	Yes	Referenced from CJM_PROGRAM_TYPES_B.PROGRAM_TYPE_ID. Values are from the program type template used to create the channel program.
SEEDED_PROGRAM_TYPE_CODE	VARCHAR2	30		Yes	Predefined program type values. Values are from the lookup ORA_CJM_SEEDED_PROGRAM_TYPE.
DYNAMIC_MATRIX_ID	NUMBER		18	Yes	This column is mapped to the DYNAMIC_MATRIX_ID of QP_MATRICES table. Channel program qualifiers which are sourced from the order header are mapped to the Header Matrix Type. DYNAMIC_MATRIX_ID is further mapped to QP_MATRIX_INHERITED_DIMENSIONS and QP_MATRIX_RULES.
PRICING_DATE_TYPE_CODE	VARCHAR2	30			This column stores the date type sourced from the header and is used to evaluate channel program eligibility. Contains Null if the program has data sourcing from the COMMON_DYNAMIC_MATRIX_ID. This code is populated from the lookup ORA_CJM_PRICING_APP_DATE_TYPE.

Indexes

Index	Uniqueness	Tablespace	Columns
CJM_PROGRAMS_MATRIX_MAP_U1	Unique	Default	MATRIX_MAP_ID