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