DW_POSITION_CURRENT_D

It stores records for all the current positions.

Details

Module: Global Human Resources

Key Columns

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_CURRENT_TL joining this ID. DW_POSITION_D_CURRENT_TL POSITION_ID
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Unique Source Record Identifier This column contains JOB_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    

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