Channel Program Qualifiers

The Channel Program Qualifiers view object contains qualifier attributes that define the target market rules in channel programs.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ProgramQualifierExtractPVO

Primary Keys : ProgramQualifierId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ComparisonOperatorCode	Code that identifies the comparison operator used in the market rule. A list of accepted values is defined in the lookup type ORA_CJM_QUALIFIER_OPERATOR.
CreatedBy	User who created the channel program qualifier.
CreationDate	Date and time when the channel program qualifier was created.
EndDate	Date when the qualifier is no longer applicable. If blank, then the qualifier end date is the end date for the channel program.
LastUpdateDate	Date and time when the channel program qualifier row was last updated.
LastUpdateLogin	Session login associated with the user who last updated the channel program qualifier.
LastUpdatedBy	User who last updated the channel program qualifier row.
MandatoryQualifier	Indicates whether the qualifier is used in the program rule or market rule. Contains one of the following values: Y or N. If Y, then the qualifier is used in the program rule. If N, then the qualifier is used in the market rule.
ObjectVersionNumber	Number of times the channel program qualifier row has been updated.
ProgramHeaderId	Value that uniquely identifies the channel program. This is a foreign key to the Channel Programs view object.
ProgramQualifierId	Value that uniquely identifies the channel program qualifier. This is the primary key of the Channel Program Qualifiers view object.
QualifierTypeCode	Code that identifies the type of qualifier used to define the eligibility of the channel program. For supplier ship and debit programs, the list of accepted values is defined in the lookup type ORA_CJM_QUALIFIER_TYPE. For supplier rebate programs, the list of accepted values is defined in the lookup type ORA_CJM_SUP_REBATE_QUAL.
QualifierValueCode	The qualifier value used in channel program qualification.
StartDate	Date when the qualifier becomes applicable. If blank, then the qualifier start date is the start date for the channel program.