Share this page

# FACT_POSITIONS_REQUESTS

This table stores the line items - positions of a staffing profile.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DIM_ POSITIONS | PK_POSITIONS_ID | PK_POSITIONS_ID
DIM_PERSON | REQUESTED_BY_ID | PK_PERSON_ID
DIM_PERSON | RESOURCE_REQUESTED_ID | PK_PERSON_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PK_POSITIONS_ID | Nullable | INT | System-generated identifier
MD_BUSINESS_KEY | Nullable | VARCHAR (1000) | Primary key that is mapped to one or more source columns
MD_ENTERPRISE_KEY | Nullable | INT | Unique identifier for entity
POSITION_ID | Nullable | INT | Unique identifier for positions
POSITION_BUSINESS_ KEY | Nullable | VARCHAR (1000) | Foreign key that is mapped to DIM_POSITIONS
POSITION_ENTERPRISE_ KEY | Nullable | INT | Unique identifier for foreign key
ASK_DATE | Nullable | DATE | Indicates the date by which the response is needed by the resource pool manager when a position's demand is requested
NEED_BY_DATE | Nullable | DATE | This is the date mentioned for the position's response needed by date
REQUESTED_BY_ID | Nullable | INT | Unique identifier for the user who sent the position's unmet demand request
REQUESTED_BY_ BUSINESS_KEY | Nullable | VARCHAR (1000) | Foreign key that is mapped to DIM_PERSON
REQUESTED_BY_ ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
RESOURCE_ REQUESTED_ID | Nullable | VARCHAR | Unique identifier for the specific resource this position would like to be filled by
RESOURCE_ REQUESTED_BUSINESS_ KEY | Nullable | VARCHAR (1000) | Foreign key that is mapped to DIM_PERSON
RESOURCE_ REQUESTED_ ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
MD_BATCH_ID | Nullable | INT | ID of data batch
MD_PROCESS_ID | Nullable | INT | ID of ETL process running on a specific task
MD_SOURCE_INSTANCE_ ID | Nullable | INT | Content pack ID of source instance
MD_CREATEDDATE | Nullable | DATETIME | Date of the record being inserted
MD_DELETEDDATE | Nullable | DATETIME | Date of the record being deleted
MD_LASTMODDDATE | Nullable | DATETIME | Date of the record being updated
MD_ACTIVESTATUSIND | Nullable | VARCHAR (1) | Flags whether or not the old record is deleted
MD_HASH_CODE | Nullable | VARCHAR (40) | Hash code that is generated

## 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
PERSON_ENTERPRISE_XREF_SEQ | PERSON_ENTERPRISE_KEY
PERSON_KEY_LOOKUP_SEQ | PERSON_ID

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: