1. Tables and Views for Project Management
  2. PJF_PRBS_MAP_GT

PJF_PRBS_MAP_GT

Global temporary table that stores transaction attribute data for which resource breakdown structure mapping is required.

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: TABLE

Columns

Name

SOURCE_ROW_IDROWIDIdentifier for transaction table row id for tie back process *****

SOURCE_IDNUMBER18Identifier used as primary key in transaction table for tie back process *****

TXN_ACCUM_HEADER_IDNUMBER18Identifier of the transaction attribute stored in PJS_TXN_BASE_HEADER.

PERSON_IDNUMBER18Identifier of the labor resource.

JOB_IDNUMBER18Identifier of the job.

ORGANIZATION_IDNUMBER18Identifier of the organization.

VENDOR_IDNUMBER18Identifier of the vendor.

PROJECT_ROLE_IDNUMBER18Identifier of the project role.

RESOURCE_CLASS_IDNUMBER18Identifier of the resource class.

INVENTORY_ITEM_IDNUMBER18Identifier of the inventory item.

ITEM_CATEGORY_IDNUMBER18Identifier of the item category.

EXPENDITURE_TYPE_IDNUMBER18Identifier of the expenditure type.

EVENT_TYPE_IDNUMBER18Identifier of the event type.

NON_LABOR_RESOURCE_IDNUMBER18Identifier of the nonlabor resource.

EXPENDITURE_CATEGORY_IDNUMBER18Identifier of the expenditure category.

REVENUE_CATEGORY_IDNUMBER18Identifier of the revenue category.

PERSON_TYPE_IDNUMBER18Identifier of the person type.

RBS_VERSION_IDNUMBER18Identifier of the resource breakdown structure version.

ATTRIBUTE1NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE2NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE3NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE4NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE5NUMBER18Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE6VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE7VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE8VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE9VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE10VARCHAR280Descriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE11DATEDescriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE12DATEDescriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE13DATEDescriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE14DATEDescriptive Flexfield: segment of the user descriptive flexfield.

ATTRIBUTE15DATEDescriptive Flexfield: segment of the user descriptive flexfield.