Analytics Catalog/Data dictionary/IRC_WFMODEL_REQUISITIONS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

IRC_WFMODEL_REQUISITIONS

SharedUsed in 0 subject areas25 reporting columnsBICC incremental-ready

Recruiting (IRC).

Primary key: not yet catalogued for IRC_WFMODEL_REQUISITIONS — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
COMMENTSComments.
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
GEOGRAPHY_NODE_IDIdentifier for the geography node.
HIRING_MANAGER_IDIdentifier for the hiring manager.
JUSTIFICATION_CODECode identifying the justification.
LAST_UPDATED_BYUser who last updated the row.
LAST_UPDATE_DATEINCRDate and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGINSession login of the user who last updated the row.
MANAGER_ASSIGNMENT_IDIdentifier for the manager assignment.
MANAGER_TITLEManager title.
NUMBER_TO_HIRENumber to hire.
OBJECT_VERSION_NUMBEROptimistic-locking version number, incremented on each update.
PHASE_IDIdentifier for the phase.
RECRUITER_ASSIGNMENT_IDIdentifier for the recruiter assignment.
RECRUITER_IDIdentifier for the recruiter.
RECRUITING_TYPE_CODECode identifying the recruiting type.
REQUISITION_LANGUAGERequisition language.
REQUISITION_NUMBERRequisition number.
SOURCE_REQUISITION_IDIdentifier for the source requisition.
STATE_IDIdentifier for the state.
TITLETitle.
UNLIMITED_HIRE_FLAGIndicator (Y/N) for the unlimited hire.
WF_MODEL_IDIdentifier for the wf model.
WF_MODEL_REQUISITION_IDIdentifier for the wf model requisition.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Subject areas

Need the extract + dbt staging for IRC_WFMODEL_REQUISITIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us