Share this page

# DIM_POSITIONS

This table stores the line items - positions of a staffing profile. These are the items used to forecast the resource demand and request them from the resource pools.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DIM_ RESOURCE_POOLS | RESOURCE_POOL_ID | PK_ RESOURCE_POOLS_ID

## Column Descriptions

Column Name | Null? | Data Type | Description | SCD2
--- | --- | --- | --- | ---
PK_POSITIONS_ID | Not Null | INT | System-generated identifier | No
MD_BUSINESS_ KEY | Not Null | VARCHAR (1000) | Primary key that is mapped to one or more source columns | No
MD_ENTERPRISE_ KEY | Not Null | INT | Unique identifier for entity | No
STATUS_CODE | Nullable | INT | Indicates the position's status. It is a code and it is then decoded in the application to meaningful words. | No
STATUS_NAME | Nullable | VARCHAR (150) | Status name | No
VIEW_EFFORT_ TYPE | Nullable | INT | 0: FTE; 1:HOURS; 2:PERSON_DAYS | No
VIEW_EFFORT_ TYPE_NAME | Nullable | VARCHAR (20) | DECODE(VIEW_EFFORT_ TYPE,0,’FTE’,1,’HOURS’,2,’PERSON_ DAYS’, ‘UNKNOWN’) | No
RESOURCE_TYPE_ CODE | Nullable | VARCHAR (255) | Indicates the type of resource needed by this position; for example, full time, part time, contractor, and so on. | Yes
RESOURCE_ POOL_ID | Nullable | INT | Unique identifier for the resource pool from which the position's demand for resources is assigned from. | Yes
RESOURCE_ POOL_BUSINESS_ KEY | Nullable | VARCHAR (1000) | Foreign key that is mapped to DIM_RESOURCE_POOLS | Yes
RESOURCE_ POOL_ ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key | Yes
RESOURCE_ POOL_NAME | Nullable | VARCHAR (260) | Related resource pool name | Yes
POSITION_NAME | Nullable | VARCHAR (255) | Indicates the user entered name to the position | No
ROLE_ID | Not Null | INT | The role this position needs to be filled by. This is a foreign key to the DIM_ROLES table. | Yes
ROLE_NAME | Not Null | VARCHAR (260) | Related role name | Yes
STAFFING_ PROFILE_ID | Nullable | INT | Indicates the staffing profile this position belongs to | Yes
STAFFING_ PROFILE_NAME | Nullable | VARCHAR (300) | Related staffing profile name | Yes
USER_DATA1-100 | Nullable | VARCHAR (255) | User data segment | No
VISIBLE_USER_ DATA1-100 | Nullable | VARCHAR (255) | User data segment | No
POSITION_ COMMENT | Nullable | VARCHAR (2000) | The text entered by the user who created/updated this position | No
EXPENSE_TYPE | Nullable | VARCHAR (255) | Indicates the selection user made between capex or opex or both | No
CAPITAL_RATIO | Nullable | NUMERIC | Indicates the ratio between capital and operating cost. Filled in when both the expense types are selected in expense_type column. | No
LABOR_ CATEGORY | Nullable | VARCHAR (255) | Labor category code | Yes
LABOR_ CATEGORY_NAME | Nullable | VARCHAR (150) | Related labor category name; for example, employee, contractor, and so on. | Yes
DEF_VIEW_ PERIOD_TYPE | Nullable | INT | Default value of fiscal period type | No
MD_BATCH_ID | Nullable | INT | ID of data batch | No
MD_PROCESS_ID | Nullable | INT | ID of ETL process running on a specific task | No
MD_SOURCE_ INSTANCE_ID | Nullable | INT | Content pack ID of source instance | No
MD_ CREATEDDATE | Nullable | DATETIME | Date of the record being inserted | No
MD_DELETEDDATE | Nullable | DATETIME | Date of the record being deleted | No
MD_ LASTMODDATE | Nullable | DATETIME | Date of the record being updated | No
MD_ TRANSLASTIND | Nullable | VARCHAR (1) | Flags whether or not there is SCD2 last record | No
MD_ TRANSENDDATE | Nullable | DATETIME | End date of the record being effective | No
MD_ ACTIVESTATUSIND | Nullable | VARCHAR (1) | Flags whether or not the old record is deleted | No
MD_HASH_CODE_ SCD1 | Nullable | VARCHAR (40) | (Only for dimension table) Hash code that is generated by SCD1 columns | No
MD_HASH_CODE_ SCD2 | Nullable | VARCHAR (40) | (Only for dimension table) Hash code that is generated by SCD2 columns | No

## Projections

This table uses no projections.

## Sequences

Sequence Name | Sequence Type
--- | ---
POSITIONS_ENTERPRISE_XREF_SEQ | MD_ENTERPRISE_KEY
POSITIONS_KEY_LOOKUP_SEQ | PK_POSITIONS_ID
RESOURCE_POOLS_ENTERPRISE_XREF_SEQ | RESOURCE_POOL_ENTERPRISE_KEY
RESOURCE_POOLS_KEY_LOOKUP_SEQ | RESOURCE_POOL_PK

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: