# DW_POSITION_D

DW_POSITION_D stores all the positions with their attributes.

## Details

Module: Global Human Resources

## Key Columns

POSITION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
POSITION_ID | NUMBER | 38 | 0 | True | Transaction system generated primary key column.For translation refer table DW_POSITION_D_TL joining this ID.#1 | DW_POSITION_D_TL | POSITION_ID
EFFECTIVE_START_DATE | DATE |  |  | True | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. |  |
EFFECTIVE_END_DATE | DATE |  |  | True | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier This column contains POSITION_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. |  |
POSITION_CODE | VARCHAR2 | 32 |  |  | Code of the position |  |
ACTIVE_STATUS | VARCHAR2 | 32 |  |  | Indicates if a position is active or inactive. |  |
POSITION_TYPE | VARCHAR2 | 32 |  |  | Indicates the type of the position for example pooled or single. |  |
MAX_PERSONS | NUMBER | 38 | 0 |  | Position headcount |  |
SECURITY_CLEARANCE | VARCHAR2 | 32 |  |  | Indicates the security clearance of a position. |  |
OVERLAP_ALLOWED | VARCHAR2 | 32 |  |  | Indicates if overlap is allowed. |  |
SEASONAL_FLAG | VARCHAR2 | 32 |  |  | Indicates if a position is seasonal. |  |
SEASONAL_START_DATE | DATE |  |  |  | Seasonal start date. |  |
SEASONAL_END_DATE | DATE |  |  |  | Seasonal end date. |  |
FTE | NUMBER |  |  |  | FTE of Position |  |
DELEGATE_POSITION_ID | NUMBER | 38 | 0 |  | Delegate Position identifier |  |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Identifier |  |
ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier |  |
JOB_ID | NUMBER | 38 | 0 |  | Job Identifier |  |
LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier |  |
ENTRY_GRADE_ID | NUMBER | 38 | 0 |  | Identifier of the entry grade |  |
ACTION_OCCURRENCE_ID | NUMBER | 38 | 0 |  | Action occurrence identifier |  |
ACTION_REASON_ID | NUMBER | 38 | 0 |  | Action reason identifier |  |
REQUISITION_TEMPLATE_ID | NUMBER | 38 | 0 |  | Requisition template Identifier |  |
SUPERVISOR_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Supervisor Assignmnet Identifier |  |
SUPERVISOR_ID | NUMBER | 38 | 0 |  | Supervisor Identifier |  |
COST_CENTER | VARCHAR2 | 32 |  |  | Cost center |  |
ASSIGNMENT_CATEGORY | VARCHAR2 | 32 |  |  | Assignment category |  |
HIRING_STATUS | VARCHAR2 | 32 |  |  | Indicates the hiring status of the position, for example approved or frozen. |  |
FULL_PART_TIME | VARCHAR2 | 32 |  |  | Indicates if a position is full-time or part-time |  |
PERMANENT_TEMPORARY_FLAG | VARCHAR2 | 32 |  |  | Indicates if a position is regular or temporary |  |
PROBATION_PERIOD | NUMBER |  |  |  | Number of the probation period |  |
PROBATION_PERIOD_UNIT | VARCHAR2 | 32 |  |  | Unit of measure code for the probation period |  |
BARGAINING_UNIT | VARCHAR2 | 32 |  |  | Code of the bargaining uni |  |
WORKING_HOURS | NUMBER |  |  |  | working hours |  |
FREQUENCY | VARCHAR2 | 32 |  |  | Frequency |  |
STANDARD_WORKING_HOURS | NUMBER |  |  |  | Number of standard working hours |  |
STANDARD_WORKING_FREQUENCY | VARCHAR2 | 32 |  |  | Frequency for the standard working hours |  |
TIME_NORMAL_START | VARCHAR2 | 16 |  |  | Regular start time |  |
TIME_NORMAL_FINISH | VARCHAR2 | 16 |  |  | Regular end time |  |
CALCULATE_FTE | VARCHAR2 | 16 |  |  | Indicates whether FTE should be calculated for this position |  |
BUDGET_AMOUNT | NUMBER |  |  |  | Indicates budget amount |  |
BUDGET_AMOUNT_CURRENCY | VARCHAR2 | 32 |  |  | Used to identify currency for Budget Amount |  |
BUDGETED_POSITION_FLAG | VARCHAR2 | 16 |  |  | Budgeted flag |  |
FUNDED_BY_EXISTING_POSITION | VARCHAR2 | 16 |  |  | Flag to indicate funded by existing position |  |

## Notes

#1 DW_POSITION_D_TL is date effective. Along with POSITION_ID join on dates.

Copyright © 2019, 2026, Oracle and/or its affiliates.