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

Contnet 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