IRC_OUTREACHES

This table contains the information regarding the outreaches initiated by the hiring team in context of pool, events, candidate profile, and prospects.

Details

• Schema: FUSION

• Object owner: IRC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
IRC_OUTREACHES_PK	OUTREACH_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
OUTREACH_ID	NUMBER		18	Yes	Unique system-generated identifier representing a specific outreach.
ADDED_BY_PERSON_ID	NUMBER		18	Yes	Identifier of the person who created or initiated the outreach. Foreign key, references PERSON_ID from the PER_PERSONS table.
CONTEXT_TYPE_CODE	VARCHAR2	30		Yes	Stores the context type code. Possible values include ORA_EVENT, ORA_CAND_POOL, ORA_EVENT, etc. Lookup type is ORA_IRC_INTERACTION_CTXT_TYPE.
CONTEXT_ID	NUMBER		18		Unique identifier representing the specific business object (e.g., prospect, pool, event) under which the outreach is created.
INTENT	VARCHAR2	2000		Yes	Represents the purpose of the outreach, which determines the type and tone of personalized email message generated for candidates.
START_DATE	TIMESTAMP			Yes	Indicates the date and time when the outreach officially starts, typically the moment when the first email (initial outreach message) is triggered to the candidate(s). This marks the beginning of the outreach.
STATUS	VARCHAR2	30		Yes	Lifecycle state of the outreach (ORA_IN_PROGRESS, ORA_COMPLETED, etc.).
REMINDER_PLAN_FLAG	VARCHAR2	1		Yes	Indicates whether a follow-up or reminder plan is configured for the outreach. Possible values include Y or N.
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.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
IRC_OUTREACHES	per_persons	ADDED_BY_PERSON_ID
irc_interactions	irc_outreaches	OUTREACH_ID
irc_outreach_recipients	irc_outreaches	OUTREACH_ID
irc_outreach_history	irc_outreaches	OUTREACH_ID
irc_outreach_reminders	irc_outreaches	OUTREACH_ID

Indexes

Index	Uniqueness	Tablespace	Columns
IRC_OUTREACHES_FK1	Non Unique	Default	ADDED_BY_PERSON_ID
IRC_OUTREACHES_N1	Non Unique	Default	CONTEXT_TYPE_CODE, CONTEXT_ID, ADDED_BY_PERSON_ID, STATUS
IRC_OUTREACHES_N2	Non Unique	Default	REMINDER_PLAN_FLAG, STATUS
IRC_OUTREACHES_PK	Unique	Default	OUTREACH_ID