1. Tables and Views for Sales and Fusion Service
  2. MOW_WORKOBJ_CANDOBJ_RELS

MOW_WORKOBJ_CANDOBJ_RELS

Table for storing the Work Object and Candidate Object relationship

Details

  • Schema: FUSION

  • Object owner: MOW

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

MOW_WORKOBJ_CANDOBJ_RELS_PK

WORKOBJ_CANDOBJ_REL_GUID

Columns

Name Datatype Length Precision Not-null Comments
WORKOBJ_CANDOBJ_REL_GUID VARCHAR2 64 Yes Primary Key to uniquely identify the row
NO_MATCH_BEHAVIOR VARCHAR2 30 Yes This field indicates the disposition behaviour, when there is no match(Remove,Retain or Error)
REF_ROW_GUID VARCHAR2 64 Reference key the to respective N/D row.
RECORD_STATUS VARCHAR2 1 Yes Indicates if WO-CO Relation has been published to Engine
WORK_OBJECT_GUID VARCHAR2 64 Yes Foreign Key to the MOW_ASGN_OBJECTS_B table
CANDIDATE_OBJECT_GUID VARCHAR2 64 Yes Foreign Key to the MOW_ASGN_OBJECTS_B table
ASSIGNMENT_MODE VARCHAR2 30 Yes This filed indicate to evaluate TBA/RBA, based on the assignment mode (Territory, Matching, Scoring or Classification)
CAND_PARENT_ATTR VARCHAR2 80 This is used in TBA to know the parent attribute name.
CAND_ATTR1 VARCHAR2 80 Contains the first/only attribute name in the composite primary key to write back the single candidate on the Work Object VO
CAND_ATTR2 VARCHAR2 80 Contains the second attribute name in the composite primary key to write back the single candidate on the Work Object VO
CAND_ATTR3 VARCHAR2 80 Contains the third attribute name in the composite primary key to write back the single candidate on the Work Object VO
CAND_SCORE_ATTR VARCHAR2 80 Contains the column name on the base VO for storing the score of the candidate assigned
CAND_TEAM_VO_NAME VARCHAR2 255 The VO name which will be the intersection for writing the candidates
CAND_TEAM_CAND_ATTR1 VARCHAR2 80 Contains the first/only attribute name to write back the assigned candidate on the child/intersection VO
CAND_TEAM_CAND_ATTR2 VARCHAR2 80 Contains the second attribute name to write back the assigned candidate on the child/intersection VO
CAND_TEAM_CAND_ATTR3 VARCHAR2 80 Contains the third attribute name to write back the assigned candidate on the child/intersection VO
CAND_TEAM_SCORE_ATTR VARCHAR2 80 Contains the column name on the child/team VO for storing the score of the candidate assigned
CAND_TEAM_MANL_ATTR VARCHAR2 80 Contains the candidate manual attribute name on the child/intersection VO
CAND_TEAM_SYS_ATTR VARCHAR2 80 Contains the candidate system attribute name on the child/intersection VO
ADD_CAND_FLAG VARCHAR2 1 Indicates whether to write back the assigned candidates and rules
INVOKE_CALLBACK_FLAG VARCHAR2 1 Indicates whether to call the call back function on the invoked work object
CAND_REPLACE_FLAG VARCHAR2 1 Indicates whether to delete the existing candidates if they no longer qualify
KEEP_MANL_ASGN_CAND_FLAG VARCHAR2 1 Indicates whether to delete the user assigned candidates from the team
CAND_EXCL_VO_NAME VARCHAR2 255 Contains the intersection VO name for the candidate exclusion list.
CAND_EXCL_ATTR1 VARCHAR2 80 Contains the attribute name of the first candidate primary key field on the candidate exclusion intersection VO.
CAND_EXCL_ATTR2 VARCHAR2 80 Contains the attribute name of the second candidate primary key field on the candidate exclusion intersection VO.
CAND_EXCL_ATTR3 VARCHAR2 80 Contains the attribute name of the third candidate primary key field on the candidate exclusion intersection VO.
CAND_EXCL_COV_ATTR VARCHAR2 80 Used in TBA to Identify the attribute on the candidate object that stores the exclusion coverage indicator.
CAND_DISCRIM_ATTR VARCHAR2 80 This is used in TBA to know the candidate discriminator attribute name.
EXCL_ASGN_ATTR VARCHAR2 80 Contains the name of the lock assignment attribute name in the primary VO, which is the attribute in the work object's VO that can be used to prevent assigning the certain row. This is applicable only for the Work Object
ASGN_DATE_ATTR VARCHAR2 80 Contains the attribute name on the base VO for datetime to be stamped when the record is last assigned
MAX_NO_OF_CANDIDATES NUMBER 9 Maximum number of Candidates to be returned upon a Assignment request
MERGE_FLAG VARCHAR2 1 Yes Indicates whether assignment should merge the results from evaluation of each mapping set before submitting to disposition.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
MOW_WORKOBJ_CANDOBJ_RELS mow_asgn_objects_b WORK_OBJECT_GUID
MOW_WORKOBJ_CANDOBJ_RELS mow_asgn_objects_b CANDIDATE_OBJECT_GUID
mow_rule_set_groups_b mow_workobj_candobj_rels WORKOBJ_CANDOBJ_REL_GUID
mow_mapping_sets mow_workobj_candobj_rels WORKOBJ_CANDOBJ_REL_GUID
mow_mappings mow_workobj_candobj_rels WORKOBJ_CANDOBJ_REL_GUID

Indexes

Index Uniqueness Tablespace Columns
MOW_WORKOBJ_CANDOBJ_RELS_PK Unique Default WORKOBJ_CANDOBJ_REL_GUID, ORA_SEED_SET1
MOW_WORKOBJ_CANDOBJ_RELS_PK1 Unique Default WORKOBJ_CANDOBJ_REL_GUID, ORA_SEED_SET2
MOW_WORKOBJ_CANDOBJ_RELS_U1 Unique Default WORK_OBJECT_GUID, CANDIDATE_OBJECT_GUID, ASSIGNMENT_MODE, RECORD_STATUS, ORA_SEED_SET1
MOW_WORKOBJ_CANDOBJ_RELS_U11 Unique Default WORK_OBJECT_GUID, CANDIDATE_OBJECT_GUID, ASSIGNMENT_MODE, RECORD_STATUS, ORA_SEED_SET2