DW_TA_INSIGHTS_SALARY_EF (Preview)
This table requires activation of Talent Acquisition Connected Insights functional area. This is a derived fact with salary details of Accepted Job Offers
Details
Module: Recruiting
Key Columns
JOB_APPLICATION_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| JOB_APPLICATION_ID | NUMBER | 38 | 0 | True | Job Application Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| CALENDAR_DATE | DATE | Calendar Date | DW_DAY_D | CALENDAR_DATE | |||
| OFFER_ID | NUMBER | 38 | 0 | Offer Identifier | DW_TA_OFFER_D | OFFER_ID | |
| JOB_APP_PROFILE_ID | NUMBER | 38 | 0 | profile identifier | DW_CERTIFICATION_D | PROFILE_ID | |
| JOB_APP_REQUISITION_ID | NUMBER | 38 | 0 | requisition identifier | DW_TA_JOB_REQUISITION_D | REQUISITION_ID | |
| JOB_APP_PERSON_ID | NUMBER | 38 | 0 | person identifier | DW_PERSON_D | PERSON_ID | |
| REQ_BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business Unit Indentifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| REQ_ORGANIZATION_ID | NUMBER | 38 | 0 | Stores the organization identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| REQ_DEPARTMENT_ID | NUMBER | 38 | 0 | Department Identifier | DW_DEPARTMENT_D | DEPARTMENT_ID | |
| REQ_LOCATION_ID | NUMBER | 38 | 0 | Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID | |
| REQ_GEOGRAPHY_NODE_ID | NUMBER | 38 | 0 | Stores the corresponding geography node ID | DW_TA_GEO_HIERARICHAL_NODES_D | GEOGRAPHY_NODE_ID | |
| REQ_PROFILE_ID | NUMBER | 38 | 0 | Stores the corresponding job profile ID | DW_WORK_REQUIREMENT_D | PROFILE_ID | |
| REQ_JOB_ID | NUMBER | 38 | 0 | Job Identifier | DW_JOB_D | JOB_ID | |
| REQ_JOB_FAMILY_ID | NUMBER | 38 | 0 | Job Family Identifier | DW_JOB_FAMILY_D | JOB_FAMILY_ID | |
| REQ_JOB_FUNCTION_CODE | VARCHAR2 | 32 | Stores the job function as a lookup code | DW_JOB_FUNCTION_D_TL | JOB_FUNCTION_CODE | ||
| REQ_GRADE_ID | NUMBER | 38 | 0 | Grade Identifier | DW_PAY_GRADE_D | GRADE_ID | |
| REQ_POSITION_ID | NUMBER | 38 | 0 | Position Identifier | DW_POSITION_D | POSITION_ID | |
| REQ_LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 | legal employer identifier | DW_LEGAL_EMPLOYER_D | LEGAL_EMPLOYER_ID | |
| REQ_HIRING_MANAGER_ID | NUMBER | 38 | 0 | Hiring Manager Identifier | DW_PERSON_D | PERSON_ID | |
| REQ_MANAGER_ASSIGNMENT_ID | NUMBER | 38 | 0 | Stores the Assignment Identifier of the hiring manager assignment for this Requisition | |||
| REQ_RECRUITER_ID | NUMBER | 38 | 0 | Recruiter identifier | DW_PERSON_D | PERSON_ID | |
| REQ_RECRUITER_ASSIGNMENT_ID | NUMBER | 38 | 0 | Stores the Assignment Identifier of the recruiters assignment for this Requisition | |||
| OFFER_ACCEPTED_DATE | TIMESTAMP | Stores last offer accepted date | |||||
| ASSIGNMENT_OFFER_ID | NUMBER | 38 | 0 | Assignment Offer Identifier | |||
| OBJECT_STATUS | VARCHAR2 | 32 | Stores the status of the object. | ||||
| CURRENCY_CODE | VARCHAR2 | 16 | Currency of salary amount | ||||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global Currency Code | ||||
| GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global Currency Conversion Exchange Rate | |||||
| ANNUALIZED_FULLTIME_SAL_AMOUNT | NUMBER | Annualized Salary Amount when the person FTE=1 | |||||
| ANNUALIZED_FULLTIME_SAL_GLOBAL_CRNCY | NUMBER | Annualized Salary Amount in the Global Currency Code when the person FTE=1 |