DW_POSITION_D

DW_POSITION_D stores all the positions with their attributes.

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, POSITION_ID

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.