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

Contnet 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