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 |
