IRC_OUTREACH_HISTORY

This table records a detailed, timestamped history of all communication attempts within a candidate outreach lifecycle.

Details

• Schema: FUSION

• Object owner: IRC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
IRC_OUTREACH_HISTORY_PK	HISTORY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
HISTORY_ID	NUMBER		18	Yes	Unique identifier for each history record that captures the detailed activity or communication attempt within a candidate outreach.
OUTREACH_ID	NUMBER		18	Yes	References the outreach to which this history record belongs.Foreign key, references OUTREACH_ID from the IRC_OUTREACHES table.
REMINDER_ID	NUMBER		18		References the reminder record associated with this outreach history entry. Foreign key, references REMINDER_ID from the IRC_OUTREACH_REMINDERS table.
RECIPIENT_ID	NUMBER		18	Yes	Unique identifier for the specific recipient associated with this outreach history record. Foreign key, references RECIPIENT_ID from the IRC_OUTREACH_RECIPIENTS table.
ATTEMPT_DATE	TIMESTAMP			Yes	Records the date and time when an outreach attempt (initial message, follow-up, or reminder) was made to the candidate.
ATTEMPT_ACTION_STATUS	VARCHAR2	30		Yes	Indicates the outcome or status(e.g., 'ORA_SENT', 'ORA_DELIVERED', 'ORA_FAILED'). of the outreach attempt recorded in this history entry.
CHANNEL_TYPE_CODE	VARCHAR2	30		Yes	Specifies the communication channel through which the outreach attempt was made (e.g., ORA_EMAIL, ORA_SMS, ORA_WHATSAPP).
ERROR_DETAILS	VARCHAR2	1000			Stores detailed information about any errors or failures that occurred during the outreach attempt.
FOLLOW_UP_TASK_ID	NUMBER		18		Unique identifier for a specific follow-up task. Foreign key, references TASK_ID from the IRC_FOLLOWUP_TASKS table.
HIRING_TEAM_INTERACTION_ID	NUMBER		18		Unique identifier for a specific hiring team interaction created part of outreach processing. Foreign key, references INTERACTION_ID from the IRC_INTERACTIONS 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.
CANDIDATE_RESPONSE_DATE	TIMESTAMP				Captures the date and time when the candidate responded to the outreach message or follow-up
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_OUTREACH_HISTORY	irc_outreaches	OUTREACH_ID
IRC_OUTREACH_HISTORY	irc_outreach_reminders	REMINDER_ID
IRC_OUTREACH_HISTORY	irc_outreach_recipients	RECIPIENT_ID
IRC_OUTREACH_HISTORY	irc_interactions	HIRING_TEAM_INTERACTION_ID
IRC_OUTREACH_HISTORY	irc_followup_tasks	FOLLOW_UP_TASK_ID

Indexes

Index	Uniqueness	Tablespace	Columns
IRC_OUTREACH_HISTORY_FK1	Non Unique	Default	OUTREACH_ID
IRC_OUTREACH_HISTORY_FK2	Non Unique	Default	REMINDER_ID
IRC_OUTREACH_HISTORY_FK3	Non Unique	Default	RECIPIENT_ID
IRC_OUTREACH_HISTORY_FK4	Non Unique	Default	HIRING_TEAM_INTERACTION_ID
IRC_OUTREACH_HISTORY_FK5	Non Unique	Default	FOLLOW_UP_TASK_ID
IRC_OUTREACH_HISTORY_PK	Unique	Default	HISTORY_ID