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

IRC_REQUISITIONS_B

SharedUsed in 0 subject areas165 reporting columnsBICC incremental-ready

Recruiting (IRC) — base table — language-neutral data (paired with _TL labels and the _VL view).

Likely primary key: REQUISITION_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
APPLY_WHEN_NOT_POSTED_FLAG●Indicator (Y/N) for the apply when not posted.
APPROVED_DATE●Approved date.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_CHAR1●Attribute char1.
ATTRIBUTE_CHAR10●Attribute char10.
ATTRIBUTE_CHAR11●Attribute char11.
ATTRIBUTE_CHAR12●Attribute char12.
ATTRIBUTE_CHAR13●Attribute char13.
ATTRIBUTE_CHAR14●Attribute char14.
ATTRIBUTE_CHAR15●Attribute char15.
ATTRIBUTE_CHAR16●Attribute char16.
ATTRIBUTE_CHAR17●Attribute char17.
ATTRIBUTE_CHAR18●Attribute char18.
ATTRIBUTE_CHAR19●Attribute char19.
ATTRIBUTE_CHAR2●Attribute char2.
ATTRIBUTE_CHAR20●Attribute char20.
ATTRIBUTE_CHAR21●Attribute char21.
ATTRIBUTE_CHAR22●Attribute char22.
ATTRIBUTE_CHAR23●Attribute char23.
ATTRIBUTE_CHAR24●Attribute char24.
ATTRIBUTE_CHAR25●Attribute char25.
ATTRIBUTE_CHAR26●Attribute char26.
ATTRIBUTE_CHAR27●Attribute char27.
ATTRIBUTE_CHAR28●Attribute char28.
ATTRIBUTE_CHAR29●Attribute char29.
ATTRIBUTE_CHAR3●Attribute char3.
ATTRIBUTE_CHAR30●Attribute char30.
ATTRIBUTE_CHAR4●Attribute char4.
ATTRIBUTE_CHAR5●Attribute char5.
ATTRIBUTE_CHAR6●Attribute char6.
ATTRIBUTE_CHAR7●Attribute char7.
ATTRIBUTE_CHAR8●Attribute char8.
ATTRIBUTE_CHAR9●Attribute char9.
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER13●Descriptive flexfield segment.
ATTRIBUTE_NUMBER14●Descriptive flexfield segment.
ATTRIBUTE_NUMBER15●Descriptive flexfield segment.
ATTRIBUTE_NUMBER16●Descriptive flexfield segment.
ATTRIBUTE_NUMBER17●Descriptive flexfield segment.
ATTRIBUTE_NUMBER18●Descriptive flexfield segment.
ATTRIBUTE_NUMBER19●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER20●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
ATTRIBUTE_TIMESTAMP1●Attribute timestamp1.
ATTRIBUTE_TIMESTAMP10●Attribute timestamp10.
ATTRIBUTE_TIMESTAMP2●Attribute timestamp2.
ATTRIBUTE_TIMESTAMP3●Attribute timestamp3.
ATTRIBUTE_TIMESTAMP4●Attribute timestamp4.
ATTRIBUTE_TIMESTAMP5●Attribute timestamp5.
ATTRIBUTE_TIMESTAMP6●Attribute timestamp6.
ATTRIBUTE_TIMESTAMP7●Attribute timestamp7.
ATTRIBUTE_TIMESTAMP8●Attribute timestamp8.
ATTRIBUTE_TIMESTAMP9●Attribute timestamp9.
AUTOMATIC_FILL_FLAG●Indicator (Y/N) for the automatic fill.
AUTO_OPEN_REQUISITION●Auto open requisition.
AUTO_UNPOST_REQUISITION●Auto unpost requisition.
BUDGET_CURRENCY_CODE●Currency code for the budget.
BUSINESS_UNIT_ID●Identifier for the business unit.
COMMENTS●Comments.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
CURRENT_PHASE_ID●Identifier for the current phase.
CURRENT_STATE_ID●Identifier for the current state.
DEPARTMENT_ID●Identifier for the department.
DISPLAY_IN_ORG_CHART_FLAG●Indicator (Y/N) for the display in organization chart.
EMPLOYEE_REFERRAL_BONUS●Employee referral bonus.
EXTERNAL_APPLY_FLOW_ID●Identifier for the external apply flow.
EXTERNAL_DESCRIPTION_ID●Identifier for the external description.
EXT_CONTACT_EMAIL●Ext contact email.
EXT_CONTACT_NAME●Name of the ext contact.
EXT_EMPLOYER_DESC_ID●Identifier for the ext employer description.
EXT_FIRST_POSTED_DATE●Ext first posted date.
EXT_ORGANIZATION_DESC_ID●Identifier for the ext organization description.
EXT_PUBLISH_JOB_END_DATE●Ext publish job end date.
EXT_PUBLISH_JOB_START_DATE●Ext publish job start date.
EXT_PUBLISH_JOB_STATUS●Status of the ext publish job.
FILLED_DATE●Filled date.
FULL_PART_TIME●Full part time.
GEOGRAPHY_ID●Identifier for the geography.
GEOGRAPHY_NODE_ID●Identifier for the geography node.
GRADE_ID●Identifier for the grade.
HIRED_COUNT●Hired count.
HIRING_MANAGER_ID●Identifier for the hiring manager.
HOT_JOB_FLAG●Indicator (Y/N) for the hot job.
INTERNAL_DESCRIPTION_ID●Identifier for the internal description.
INT_CONTACT_EMAIL●Int contact email.
INT_CONTACT_NAME●Name of the int contact.
INT_EMPLOYER_DESC_ID●Identifier for the int employer description.
INT_FIRST_POSTED_DATE●Int first posted date.
INT_ORGANIZATION_DESC_ID●Identifier for the int organization description.
INT_PUBLISH_JOB_END_DATE●Int publish job end date.
INT_PUBLISH_JOB_START_DATE●Int publish job start date.
INT_PUBLISH_JOB_STATUS●Status of the int publish job.
JOB_FAMILY_ID●Identifier for the job family.
JOB_FUNCTION_CODE●Code identifying the job function.
JOB_ID●Identifier for the job.
JOB_SHIFT_CODE●Code identifying the job shift.
JOB_TYPE_CODE●Code identifying the job type.
JUSTIFICATION_CODE●Code identifying the justification.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN●Session login of the user who last updated the row.
LEGAL_EMPLOYER_ID●Identifier for the legal employer.
LOCATION_ID●Identifier for the location.
MANAGER_ASSIGNMENT_ID●Identifier for the manager assignment.
MANAGER_LEVEL●Manager level.
MAX_SALARY●Max salary.
MIN_SALARY●Min salary.
NUMBER_TO_HIRE●Number to hire.
OBJECT_STATUS●Status of the object.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
OPEN_DATE●Open date.
ORGANIZATION_ID●Identifier for the organization.
PIPELINE_REQUISITION_FLAG●Indicator (Y/N) for the pipeline requisition.
PIPELINE_REQUISITION_ID●Identifier for the pipeline requisition.
POSITION_ID●Identifier for the position.
POSTING_EXPIRE_IN_DAYS●Posting expire in days.
PROCESS_ID●Identifier for the process.
PROFILE_ID●Identifier for the profile.
RECRUITER_ASSIGNMENT_ID●Identifier for the recruiter assignment.
RECRUITER_ID●Identifier for the recruiter.
RECRUITING_TYPE_CODE●Code identifying the recruiting type.
REGULAR_TEMPORARY●Regular temporary.
RELOCATION_BUDGET●Relocation budget.
REQUISITION_IDPK?●Identifier for the requisition.
REQUISITION_NUMBER●Requisition number.
REQUISITION_TEMPLATE_ID●Identifier for the requisition template.
REQ_LAST_MODIFIED_DATE●Req last modified date.
REQ_SOURCE_TYPE●Type of req source.
REQ_USAGE_CODE●Code identifying the req usage.
REQ_USAGE_TYPE●Type of req usage.
SALARY_CURRENCY_CODE●Currency code for the salary.
SALARY_FREQUENCY_CODE●Code identifying the salary frequency.
SALARY_PERIOD_CODE●Code identifying the salary period.
SOURCING_BUDGET●Sourcing budget.
STUDY_LEVEL_CODE●Code identifying the study level.
SUBS_PROCESS_TEMPLATE_ID●Identifier for the subs process template.
SUSPENDED_DURATION●Suspended duration.
TRAVEL_BUDGET●Travel budget.
UNLIMITED_HIRE_FLAG●Indicator (Y/N) for the unlimited hire.
UNPOST_FORMULA_ID●Identifier for the unpost formula.
WORKER_TYPE_CODE●Code identifying the worker type.
WORKPLACE_TYPE_CODE●Code identifying the workplace type.
WORK_END_DATE●Work end date.
WORK_START_DATE●Work start date.

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_REQUISITIONS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us