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