Share this page
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 |
