DIM_RESOURCE_POOLS

RESOURCE_POOL_ID

PK_ RESOURCE_POOLS _ID

DIM_REQUESTS

REQUEST_ID

PK_REQUESTS_ID

DIM_CONTACTS

CONTACT_ID

PK_CONTACTS_ID

PK_PROJECTS_ ID

Nullable

INT

System-generated identifier

No

MD_ ENTERPRISE_ KEY

Nullable

VARCHA R(1000)

Primary key that is mapped to one or more source columns

No

MD_BUSINESS_ KEY

Nullable

INT

Unique identifier for entity

No

STAFFING_ PROFILE_ID

Nullable

Staffing profile ID

No

STAFFING_ PROFILE _ STATUS_CODE

Nullable

INT

Indicates the status of the staffing profile that is decoded by the application. Examples of status_code includes In Planning, Active, Completed, and so on.

No

STAFFING_ PROFILE _ STATUS_NAME

Nullable

VARCHA R(150)

Indicates the status name of the staffing profile

No

STAFFING_ PROFILE_NAME

Not Null

VARCHAR(300)

User entered name for this staffing profile

No

FINANCIAL_ SUMMARY_ID

Nullable

INT

Financial summary ID

No

FINANCIAL_ SUMMARY _ NAME

Nullable

VARCHA R(1300)

Name of the financial summary

No

FINANCIAL_ SUMMARY_ DESCRIPTION

Nullable

VARCHA R(1300)

Description of the financial summary

No

FINANCIAL_ SUMMARY_ CURRENCY_ CODE

Nullable

VARCHA R(40)

Currency code that indicates the local currency used for the financial summary

No

APPROVED_ BUDGET_ID

Nullable

INT

Identifier of financial summary to which the approved budget belongs

No

APPROVED_ BUDGET_NAME

Nullable

VARCHA R(200)

Name of the approved budget

No

APPROVED_ BUDGET_ EXPENSE_ TYPE_CODE

Nullable

VARCHA R(40)

Expense type for which the budget is approved. Possible values are: CAPITAL, OPERATING.

No

APPROVED_ BUDGET_ AMOUNT_LCL

Nullable

NUMERIC

Amount of approved budget in local currency

No

APPROVED_ BUDGET_ AMOUNT_BSE

Nullable

NUMERIC

Amount of approved budget in base currency

No

APPROVED_ BUDGET_ NOTES

Nullable

VARCHA R(1000)

Notes of approved budget

No

APPROVED_ BUDGET_DATE

Nullable

DATE

Date at which the budget is approved

No

IS_SYNCH_ BUDGET

Nullable

VARCHA R(1)

If the approved budget is synchronized, it describes the source. If the approved budget is not synchronized, the value is N. For example, synch_source_flag could be FSR for Financial Summary Rollup.

No

STAFFING_ PROFILE_ DESCRIPTION

Nullable

VARCHA R(650)

Indicates the description of the staffing profile

No

STAFFING_ PROFILE_USER_ DATA1-20

Nullable

VARCHA R(255)

User data segment

No

STAFFING_ PROFILE_ VISIBLE_USER_ DATA1-20

Nullable

VARCHA R(255)

User data segment

No

DEFAULT_VIEW_ EFFORT_TYPE_ CODE

Nullable

INT

User preferred effort type (FTE, month, Person Days) to view position's demand.

0: FTE; 1:HOURS; 2:PERSON_DAYS

No

DEFAULT_VIEW_ EFFORT_TYPE_ NAME

Nullable

VARCHA R(20)

DECODE (DEFAULT_VIEW_EFFORT_TYPE_ CODE; 0: FTE; 1:HOURS; 2:PERSON_DAYS; UNKNOWN)

No

IS_ACTIVE_FLAG

Nullable

VARCHA R(1)

Used to flag if the staffing profile is active or not. Used mainly when a baseline is created and the flag is set to N

Yes

STAFFING_ PROFILE_ START_DATE

Nullable

DATE

The start date of this staffing profile.

No

STAFFING_ PROFILE_ FINISH_DATE

Nullable

DATE

The finishing date of this staffing profile

No

STAFFING_ PROFILE_ REGIONS_ID

Nullable

INT

Region with which this staffing profile is associated with

Yes

STAFFING_ PROFILE_ REGION_NAME

Nullable

VARCHA R(100)

Region name with which this staffing profile is associated with

Yes

RESOURCCE_ POOL_ID

Nullable

INT

Unique identifier for resource pool

Yes

RESOURCE_ POOL_ BUSINESS_KEY

Nullable

VARCHA R(1000)

Foreign key that is mapped to DIM_RESOURCE_POOLS

Yes

RESOURCE_ POOL_ ENTERPRISE_ KEYS

Nullable

INT

Unique identifier for foreign key

Yes

RESOURCE_ POOL_NAME

Nullable

VARCHA R(260)

The resource pool associated to this staffing profile. Positions inherit this resource pool by default but can be overridden.

Yes

IS_ CONSIDERED_ WORKLOAD_ FLAG

Nullable

VARCHA R(1)

A flag to indicate if this staffing profile should show as workload. Values can be Y or N.

Yes

WORK_LOAD_ CATEGORY_ CODE

Nullable

VARCHA R(255)

Indicates what this staffing profile is used for - strategic projects, legacy systems, and so on.

Yes

CONTAINER_ ENTITY_ID

Nullable

INT

Container entity ID related to this table

No

CONTAINER_ ENTITY_TYPE_ CODE

Nullable

INT

Specifies if this staffing profile is for project, ORG_UNIT. asset, or freestanding. The entity type is decoded by the application.

No

DEF_VIEW_ PERIOD_TYPE

Nullable

INT

Indicates the default period type while viewing the staffing profile.

8: WEEK

4: MONTH

5: QUARTER

7: HALF_YEAR

6: YEAR

No

DEF_VIEW_ PERIOD_TYPE_ NAME

Nullable

VARCHA R(10)

DECODE (DEF_VIEW_PERIOD_ TYPE;4: MONTH; 5: QUARTER; 6: YEAR; 7: HALF_YEAR; 8: WEEK; UNKNOWN)

No

PROJECT_ REGION_ID

Nullable

INT

Provides region information for this project

Yes

PROJECT_ REGION_NAME

Nullable

VARCHA R(100)

Provides region name information for this project

Yes

ROLLUP_ID

Nullable

INT

Provides foreign key reference to the PM_PROJECT_ROLLUP table

No

SCHEDULE_ HEALTH_ INDICATOR

Nullable

VARCHA R(255)

Stores project schedule health information

No

OVERRIDE_ DESCRIPTION

Nullable

VARCHA R(750)

Stores the description for overriding the project health

No

OVERRIDE_ DATE

Nullable

DATE

Stores date the project health was overridden

No

OVERALL_ HEALTH_ INDICATOR

Nullable

VARCHA R(255)

Stores the overall health information for the project

No

COST_HEALTH_ INDICATOR

Nullable

VARCHAR(255)

Stores the cost health information for the project

No

BUDGET_ OVERRUN

Nullable

FLOAT

Stores the project budget overrun information

No

ISSUE_HEALTH_ INDICATOR

Nullable

VARCHAR(255)

Stores the project health information

No

PROJECT_NAME

Nullable

VARCHAR(300)

Stores the name of the project record

No

PROJECT_ DESCRIPTION

Nullable

VARCHAR(650)

Stores the description of the project record

No

ASSOCIATED_ MSP_PROJECT

Nullable

VARCHA R(255)

Stores the file name and path of the microsoft project if the project is integrated with any MSP file

No

PROJECT_ START_DATE

Nullable

DATE

Provides start period of the project

No

PROJECT_END_ DATE

Nullable

DATE

Provides end period of the project

No

PROJECT_TYPE_ ID

Nullable

INT

Provides project type information for the project

Yes

PPROJECT_ TYPE_NAME

Nullable

VARCHAR(255)

Provides project type name for the project

Yes

PEOJECT_TYPE_ DESCRIPTION

Nullable

VARCHAR(650)

Provides project type description for the project

No

PROJECT_ REQUEST_ TYPE_ID

Nullable

INT

Stores the request information associated with each project

entity. It is a foreign key reference to REQUEST_ID of DIM_REQUESTS table.

Yes

PROJECT_ REQUEST_NAME

Nullable

VARCHAR(255)

Stores the request name associated with each project entity

Yes

ISSUE_ REQUEST_ TYPE_ID

Nullable

INT

Provides issue request type information for the project

Yes

ISSUE_ REQUEST_ TYPE_NAME

Nullable

VARCHA R(255)

Provides issue request type name for the project

Yes

RISK_REQUEST_ TYPE_ID

Nullable

INT

Provides risk request type information for the project

Yes

RISK_REQUEST_ TYPE_NAME

Nullable

VARCHAR(255)

Provides risk request type name for the project

Yes

SCOPE_ CHANGE_ TYPE_ ID

Nullable

INT

Provides scope change request type information for the project

Yes

SCOPE_ CHANGE_TYPE_ NAME

Nullable

VARCHA R(255)

Provides scope change request type name for the project

Yes

PROJECT_PT_ SETTINGS_KEY

Nullable

INT

Stores the foreign key to ITG_ SETTINGS_CONTAINERS table

No

PROJECT_ CONTEXT_PATH

Nullable

VARCHA R(255)

Stores unique name of the containers

No

PROJECT_ WORK_LOAD_ CATEGORY_ CODE

Nullable

VARCHA R(255)

Represents the workload category. This is the same value from the project settings but allocated a dedicated column for performance reasons.

Yes

PFM_REQUEST_ ID

Nullable

INT

Unique identifier for request

Yes

PFM_REQUEST_ BUSINESS_KEY

Nullable

VARCHAR(1000)

Foreign key that is mapped to DIM_REQUEST

Yes

PFM_REQUEST_ ENTERPRISE_ KEY

Nullable

INT

Unique identifier for foreign key

Yes

REQUEST_ DESCRIPTION

Nullable

VARCHAR(400)

Short description of the selected request

No

REQUEST_ RELEASE_DATE

Nullable

DATE

Date wherein this request was released

No

REQUEST_ STATUS_ID

Nullable

INT

Identifier for the current request status

No

REQUEST_ DEPARTMENT_ CODE

Nullable

VARCHAR(30)

Lookup code for DEPARTMENT

Yes

REQUEST_ DEPARTMENT_ NAME

Nullable

VARCHA R(150)

Department name of the request

Yes

REQUEST_ PRIORITY_CODE

Nullable

VARCHAR(30)

Lookup code for PRIORITY

No

REQUEST_ PRIORITY_NAME

Nullable

VARCHA R(150)

priority name of the request

No

REQUEST_ APPLICATION

Nullable

VARCHAR(30)

Lookup code for APPLICATION

No

REQUEST_ APPLICATION_ NAME

Nullable

VARCHAR(150)

Application name of the request

No

REQUEST_ PROJECT_CODE

Nullable

VARCHA R(30)

Lookup code for REQUEST_ GROUP

No

REQUEST_ PROJECT_NAME

Nullable

VARCHA R(150)

Project name of the request

No

REQUEST_ CONTACT_ID

Nullable

INT

Identifier for the contacts associated with this record

No

REQUEST_ CONTACT_ BUSINESS_KEY

Nullable

VARCHA R(1000)

Foreign key that is mapped to DIM_CONTACTS

No

REQUEST_ CONTACT_ ENTERPRISE_ KEY

Nullable

INT

Unique identifier for foreign key

No

REQUEST_ CONTACT_NAME

Nullable

VARCHAR(200)

Contact name related with the request

No

REQUEST_ CONTACT_ EMAIL_ ADDRESS

Nullable

VARCHA R(80)

Contact’s email address related with the request

No

REQUEST_ CONTACT_ PHONE_ NUMBER

Nullable

VARCHA R(30)

Contact’s phone number related with the request

No

REQUEST_ COMPANY

Nullable

VARCHA R(30)

Contact’s company related with the request

No

REQUEST_ STATUS_CODE

Nullable

VARCHAR(30)

No

REQUEST_ STATUS_NAME

Nullable

VARCHAR(150)

Status name of the request

No

REQUEST_ PERCENT_ COMPLETE

Nullable

NUMERIC

Percentage of completion of this request (100 if the request is closed)

No

PROJECT_ DISPLAY_ STATUS

Nullable

VARCHAR(255)

This is the status end user sees from the application, which can be different from the internal status that is stored in the STATUS column.

No

PROJECT _ STATUS

Nullable

INT

Provides the project internal status, which must not be visible to the end user and is used internally to keep in sync with the associated request's internal status.

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_ ACTIVESTATUSI ND

Nullable

VARCHA R(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

PROJECTS_ENTERPRISE_XREF_SEQ

MD_ENTERPRISE_KEY

PROJECTS_KEY_LOOKUP_SEQ

PK_ PROJECTS_ID

RESOURCE_POOLS_ENTERPRISE_XREF_SEQ

RESOURCE_POOL_ENTERPRISE_KEY

RESOURCE_POOLS_KEY_LOOKUP_SEQ

RESOURCE_POOL_ID

REQUESTS_ENTERPRISE_XREF_SEQ

REQUEST_ENTERPRISE_KEY

REQUESTS_KEY_LOOKUP_SEQ

REQUEST_ID

CONTACTS_ENTERPRISE_XREF_SEQ

CONTACT_ENTERPRISE_KEY

CONTACTS_KEY_LOOKUP_SEQ

CONTACT_ID