IRC_OFFERS

Stores all the offer related details.

Details

  • Schema: FUSION

  • Object owner: IRC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

IRC_OFFERS_PK

OFFER_ID

Columns

Name Datatype Length Precision Not-null Comments
OFFER_ID NUMBER 18 Yes System generated primary key for this entity.
START_DATE_CHANGED_FLAG VARCHAR2 1 Indicates if proposed start date is changed in HR phase.
BATCH_CREATION_FLAG VARCHAR2 1 Indicates if offer was created as part of a batch.
ADDITIONALTEXT1 CLOB Offer Letter additional text 1.
ADDITIONALTEXT2 CLOB Offer Letter additional text 2.
OFFER_LETTER_LAYOUT_ID NUMBER 18 Foreign key to IRC_DESCRIPTIONS_B table. Refers to BIP template used to generate the offer letter.
ONBOARDING_OSN_ID NUMBER 18 Foreign key to IRC_ONBOARDING_OSN
EXPIRATION_DATE DATE Stores offer expiration date of this offer.
OFFER_NAME VARCHAR2 240 Yes Stores the name of this offer. Offer name is not translatable.
SUBMISSION_ID NUMBER 18 Foreign key to IRC_SUBMISSIONS table. Refers to the Job submission.
PRESELECTED_HR_ACTION_ID NUMBER 18 Stores the action id of the Offer. Foreign key to the PER_ACTIONS_B table.
HANDOFF_HR_SCENARIO_ID NUMBER 2 Stores Offer handoff scenario ID
PERSON_ID NUMBER 18 Stores the person id of the candidate for this Offer. Foreign key to PER_PERSONS table.
PRESELECTED_HR_ACTIONTYPE_CODE VARCHAR2 30 Stores the action type code that you can also get on the preselected hr action relation.
RECRUITER_ID NUMBER 18 Yes Stores the PERSON_ID of the recruiter for this Offer. Foreign key to PER_PERSONS table.
RECRUITER_ASSIGNMENT_ID NUMBER 18 Stores the ASSIGNMENT_ID of the recruiter's assignment for this Offer. Foreign key to PER_ALL_ASSIGNMENTS_M table.
ASSIGNMENT_OFFER_ID NUMBER 18 Stores the ASSIGNMENT_ID of the Offer. Foreign key to PER_ALL_ASSIGNMENTS_M table.
HIRING_MANAGER_ID NUMBER 18 Yes Stores the PERSON_ID of the hiring manager for this Offer. Foreign key to PER_PERSONS table.
MANAGER_ASSIGNMENT_ID NUMBER 18 Stores the ASSIGNMENT_ID of the hiring manager's assignment for this Offer. Foreign key to PER_ALL_ASSIGNMENTS_M table.
OFFER_COMMENTS CLOB Contains the text in the "Comments" field of the Comments And Attachments section for an Offer
COMMENTS VARCHAR2 1000 Stores the comments associated to the offer.
DESCRIPTION CLOB (Rich) text for describing the offer to the candidate.
ESIGNATURE_INSTRUCTIONS CLOB Copy of the ESignature instructions for EOffer.
ACCEPTED_ON_BEHALF VARCHAR2 1 To recall if current Offer got accepted on behalf of the candidate. The default value 'N' represents Candidate Acceptance, 'Y' represents Recruiter Acceptance on behalf of the candidate and 'A' represents Agent Acceptance on behalf of the candidate.
ACCEPTED_ON_BEHALF_BY_ID NUMBER 18 User who has accepted on behalf of the candidate
ACCEPTED_ON_BEHALF_DATE DATE Date at which the offer got accepted on behalf
APPROVAL_SUBMITTED_DATE TIMESTAMP Indicates Date and Time of Offer Submission for approval
APPROVAL_REJECTED_DATE TIMESTAMP Indicates Date and Time of Offer approval rejection
EXTENDED_DATE TIMESTAMP Stores last extended date.
WITHDRAWN_REJECTED_DATE TIMESTAMP Stores last withdrawn date.
ACCEPTED_DATE TIMESTAMP Stores last accepted date.
APPROVED_DATE TIMESTAMP APPROVED_DATE
DRAFTED_DATE TIMESTAMP Stores last drafted date.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER21 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER22 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER23 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER24 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER25 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER26 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER27 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER28 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER29 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER30 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR1 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR16 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR17 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR18 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR19 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR20 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR21 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR22 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR23 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR24 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR25 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR26 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR27 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR28 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR29 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR30 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR31 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR32 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR33 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR34 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR35 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR36 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR37 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR38 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR39 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR40 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR41 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR42 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR43 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR44 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR45 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR46 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR47 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR48 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR49 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR50 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR51 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR52 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR53 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR54 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR55 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR56 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR57 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR58 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR59 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR60 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR61 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR62 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR63 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR64 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR65 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR66 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR67 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR68 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR69 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR70 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR71 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR72 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR73 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR74 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR75 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR76 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR77 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR78 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR79 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR80 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR81 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR82 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR83 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR84 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR85 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR86 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR87 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR88 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR89 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR90 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
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.
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.
OFFER_LETTER_CUSTOMIZED_FLAG VARCHAR2 1 Yes Column that tells if the offer letter is customized or relies on the Content Library version.
RTF_RESOLVED_FLAG VARCHAR2 1 Yes Column that indicates whether the custom offer letter was resolved before downloading.
MOVE_TO_HR_STATUS VARCHAR2 30 Stores the Move to HR status lookup code of the offer. The corresponding lookup type is ORA_IRC_OFFER_MOVE_TO_HR_STATUS.
MOVE_TO_HR_DATE TIMESTAMP Timestamp when the offer got moved to HR phase.
OFFER_MOVE_STATUS VARCHAR2 30 Indicates last move status of offer. The corresponding lookup type is ORA_IRC_OFFER_MOVE_STATUS.
EXTEND_SCHEDULE_DATE TIMESTAMP Indicates the date and time when the offer is scheduled to be extended.
EXTEND_UPDATE_DATE TIMESTAMP Indicates the date and time of the last update of extend offer.
EXTEND_UPDATED_BY VARCHAR2 64 Indicates the user who last updated extend offer.
EXTEND_REQUEST_ID NUMBER 18 Indicates the latest request ID of the job for extend offer.
OBJECT_STATUS VARCHAR2 30 Stores the status of the object.
PARENT_OFFER_ID NUMBER 18 Foreign key to IRC_OFFERS_B.OFFER_ID
MERGED_FLAG VARCHAR2 1 Determines if the Offer is a result of merge.
BYPASS_OFFER_LC_FLAG VARCHAR2 1 Determines if the user has opted to speed through offer phase.
DUP_CHECK_FAILED_FLAG VARCHAR2 1 Flag to determine duplicate check status.
STATE_POST_PROCESS_STATUS VARCHAR2 30 Stores the Post processing status for a given state. Lookup ORA_IRC_STATE_PROCESS_STATUS.
ASYNC_QUEUED_DATE TIMESTAMP Indicates the date when the offer was queued for asynchronous processing.
ASYNC_RETRY_COUNT NUMBER Indicates the number of times the retry has been attempted for an asynchronous process.
HR_PROCESSED_DATE TIMESTAMP Stores the timestamp when the Offer was last moved to HR Processed State.
AUTO_PROCESS_FLAG VARCHAR2 1 Column that determines whether the offer for internal candidate should be included or excluded in Auto Processing.
MOVE_TO_HR_PREVAL_FLAG VARCHAR2 1 Column that determines if the Move to HR prevalidations are completed.
REDRAFT_COUNT NUMBER Indicates the number of times that the current offer is redrafted.

Foreign Keys

Table Foreign Table Foreign Key Column
IRC_OFFERS irc_submissions SUBMISSION_ID
IRC_OFFERS per_persons HIRING_MANAGER_ID
IRC_OFFERS per_persons RECRUITER_ID
IRC_OFFERS per_actions_b PRESELECTED_HR_ACTION_ID
IRC_OFFERS per_persons ACCEPTED_ON_BEHALF_BY_ID
IRC_OFFERS per_persons PERSON_ID
IRC_OFFERS irc_descriptions_b OFFER_LETTER_LAYOUT_ID
IRC_OFFERS IRC_OFFERS PARENT_OFFER_ID
IRC_OFFERS irc_onboarding_osn ONBOARDING_OSN_ID
irc_batch_offer_items irc_offers OFFER_ID
irc_batch_offers irc_offers SOURCE_OFFER_ID
irc_cx_cndt_email_tkns irc_offers OFFER_ID

Indexes

Index Uniqueness Tablespace Columns
IRC_OFFERS_FK1 Non Unique Default SUBMISSION_ID
IRC_OFFERS_FK2 Non Unique Default RECRUITER_ID
IRC_OFFERS_FK3 Non Unique Default HIRING_MANAGER_ID
IRC_OFFERS_FK4 Non Unique Default PRESELECTED_HR_ACTION_ID
IRC_OFFERS_FK5 Non Unique Default ACCEPTED_ON_BEHALF_BY_ID
IRC_OFFERS_FK6 Non Unique Default PERSON_ID
IRC_OFFERS_FK7 Non Unique Default OFFER_LETTER_LAYOUT_ID
IRC_OFFERS_FK8 Non Unique Default PARENT_OFFER_ID
IRC_OFFERS_FK9 Non Unique Default ASSIGNMENT_OFFER_ID
IRC_OFFERS_IRC_ONBOARDING_FK1 Non Unique Default ONBOARDING_OSN_ID
IRC_OFFERS_U1 Unique Default OFFER_ID