Channel User Statuses

The Channel User Statuses view object contains the definition of the user statuses and their associated system statuses for channel entities such as the program and claim.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.UserStatusExtractPVO

Primary Keys : UserStatusId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
BuySideFlag	Indicates whether the user status is enabled for the buy side. Contains one of the following values: Y or N. If Y, then the user status is enabled for the buy side. If N, then the user status isn't enabled for the buy side. The default value is N.
CreatedBy	User who created the user status row.
CreationDate	Date and time when the user status row was created.
DefaultFlag	Indicates whether the user status is the default for the buy side. Contains one of the following values: Y or N. If Y, then the user status is the default for the buy side. If N, then the user status isn't the default for the buy side. The default value is N.
EnabledFlag	Indicates whether the user status is enabled. Contains the following value: Y or N. If Y, then the user status is enabled. If N, then the user status isn't enabled. The default value is Y.
LastUpdateDate	Date and time when the user status row was last updated.
LastUpdateLogin	Session login associated with the user who last updated the user status row.
LastUpdatedBy	User who last updated the user status row.
ObjectVersionNumber	Number of times the user status row has been updated.
SeededFlag	Indicates whether the user status is predefined. Contains the following value: Y or N. If Y, then the user status is predefined. If N, then the user status isn't predefined.
SellSideDefaultFlag	Indicates whether the user status is the default for the sell side. Contains one of the following values: Y or N. If Y, then the user status is the default for the sell side. If N, then the user status isn't the default for the sell side. The default value is N.
SellSideFlag	Indicates whether the user status is enabled for the sell side. Contains one of the following values: Y or N. If Y, then the user status is enabled for the sell side. If N, then the user status isn't enabled for the sell side. The default value is N.
SystemStatusCode	Indicates system status code of the channel objects. For claim status, a list of accepted values is defined in the lookup type ORA_CJM_CLAIM_STATUS. For program status, a list of accepted values is defined in the lookup ORA_CJM_PROGRAM_STATUS .
SystemStatusType	Indicates the channel object type for which the user status is created. A list of accepted values is defined in the lookup type ORA_CJM_USER_STATUS_FOR.
UserStatusCode	Code that uniquely identifies the user status.
UserStatusId	Value that uniquely identifies the user status. This is the primary key of the Channel User Statuses view object.