DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_RESOURCE_ASSIGNMENTS#

Object Details
Object Name: PA_RESOURCE_ASSIGNMENTS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ASSIGNMENT_ID NUMBER (15) Yes
BUDGET_VERSION_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
TASK_ID NUMBER (15) Yes
RESOURCE_LIST_MEMBER_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
UNIT_OF_MEASURE VARCHAR2 (30)
TRACK_AS_LABOR_FLAG VARCHAR2 (1)
STANDARD_BILL_RATE NUMBER

AVERAGE_BILL_RATE NUMBER

AVERAGE_COST_RATE NUMBER

PROJECT_ASSIGNMENT_ID NUMBER (15) Yes
PLAN_ERROR_CODE VARCHAR2 (30)
TOTAL_PLAN_REVENUE NUMBER

TOTAL_PLAN_RAW_COST NUMBER

TOTAL_PLAN_BURDENED_COST NUMBER

TOTAL_PLAN_QUANTITY NUMBER

AVERAGE_DISCOUNT_PERCENTAGE NUMBER

TOTAL_BORROWED_REVENUE NUMBER

TOTAL_TP_REVENUE_IN NUMBER

TOTAL_TP_REVENUE_OUT NUMBER

TOTAL_REVENUE_ADJ NUMBER

TOTAL_LENT_RESOURCE_COST NUMBER

TOTAL_TP_COST_IN NUMBER

TOTAL_TP_COST_OUT NUMBER

TOTAL_COST_ADJ NUMBER

TOTAL_UNASSIGNED_TIME_COST NUMBER

TOTAL_UTILIZATION_PERCENT NUMBER

TOTAL_UTILIZATION_HOURS NUMBER

TOTAL_UTILIZATION_ADJ NUMBER

TOTAL_CAPACITY NUMBER

TOTAL_HEAD_COUNT NUMBER

TOTAL_HEAD_COUNT_ADJ NUMBER

RESOURCE_ASSIGNMENT_TYPE VARCHAR2 (30)
TOTAL_PROJECT_RAW_COST NUMBER

TOTAL_PROJECT_BURDENED_COST NUMBER

TOTAL_PROJECT_REVENUE NUMBER

PARENT_ASSIGNMENT_ID NUMBER

WBS_ELEMENT_VERSION_ID NUMBER (15)
RBS_ELEMENT_ID NUMBER (15)
PLANNING_START_DATE DATE

PLANNING_END_DATE DATE

SPREAD_CURVE_ID NUMBER (15)
ETC_METHOD_CODE VARCHAR2 (30)
RES_TYPE_CODE VARCHAR2 (30)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
FC_RES_TYPE_CODE VARCHAR2 (30)
RESOURCE_CLASS_CODE VARCHAR2 (30)
ORGANIZATION_ID NUMBER (15)
JOB_ID NUMBER (15)
PERSON_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_CATEGORY VARCHAR2 (30)
REVENUE_CATEGORY_CODE VARCHAR2 (30)
EVENT_TYPE VARCHAR2 (30)
SUPPLIER_ID NUMBER (15)
PROJECT_ROLE_ID NUMBER (15)
PERSON_TYPE_CODE VARCHAR2 (30)
NON_LABOR_RESOURCE VARCHAR2 (20)
BOM_RESOURCE_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
ITEM_CATEGORY_ID NUMBER (15)
RECORD_VERSION_NUMBER NUMBER

BILLABLE_PERCENT NUMBER

TRANSACTION_SOURCE_CODE VARCHAR2 (30)
MFC_COST_TYPE_ID NUMBER (15)
PROCURE_RESOURCE_FLAG VARCHAR2 (1)
ASSIGNMENT_DESCRIPTION VARCHAR2 (240)
INCURRED_BY_RES_FLAG VARCHAR2 (1)
RATE_JOB_ID NUMBER (15)
RATE_EXPENDITURE_TYPE VARCHAR2 (30)
TA_DISPLAY_FLAG VARCHAR2 (1)
SP_FIXED_DATE DATE

RATE_BASED_FLAG VARCHAR2 (1)
USE_TASK_SCHEDULE_FLAG VARCHAR2 (1)
RATE_EXP_FUNC_CURR_CODE VARCHAR2 (30)
RATE_EXPENDITURE_ORG_ID NUMBER (15)
INCUR_BY_RES_CLASS_CODE VARCHAR2 (30)
INCUR_BY_ROLE_ID NUMBER (15)
RESOURCE_CLASS_FLAG VARCHAR2 (1)
NAMED_ROLE VARCHAR2 (80)
TXN_ACCUM_HEADER_ID NUMBER (15)
PM_PRODUCT_CODE VARCHAR2 (30)
PM_RES_ASSIGNMENT_REFERENCE VARCHAR2 (25)
SCHEDULE_START_DATE DATE

SCHEDULE_END_DATE DATE

UNPLANNED_FLAG VARCHAR2 (1)
SCHEDULED_DELAY NUMBER

RESOURCE_RATE_BASED_FLAG VARCHAR2 (1)
CBS_ELEMENT_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESOURCE_ASSIGNMENT_ID
,      BUDGET_VERSION_ID
,      PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UNIT_OF_MEASURE
,      TRACK_AS_LABOR_FLAG
,      STANDARD_BILL_RATE
,      AVERAGE_BILL_RATE
,      AVERAGE_COST_RATE
,      PROJECT_ASSIGNMENT_ID
,      PLAN_ERROR_CODE
,      TOTAL_PLAN_REVENUE
,      TOTAL_PLAN_RAW_COST
,      TOTAL_PLAN_BURDENED_COST
,      TOTAL_PLAN_QUANTITY
,      AVERAGE_DISCOUNT_PERCENTAGE
,      TOTAL_BORROWED_REVENUE
,      TOTAL_TP_REVENUE_IN
,      TOTAL_TP_REVENUE_OUT
,      TOTAL_REVENUE_ADJ
,      TOTAL_LENT_RESOURCE_COST
,      TOTAL_TP_COST_IN
,      TOTAL_TP_COST_OUT
,      TOTAL_COST_ADJ
,      TOTAL_UNASSIGNED_TIME_COST
,      TOTAL_UTILIZATION_PERCENT
,      TOTAL_UTILIZATION_HOURS
,      TOTAL_UTILIZATION_ADJ
,      TOTAL_CAPACITY
,      TOTAL_HEAD_COUNT
,      TOTAL_HEAD_COUNT_ADJ
,      RESOURCE_ASSIGNMENT_TYPE
,      TOTAL_PROJECT_RAW_COST
,      TOTAL_PROJECT_BURDENED_COST
,      TOTAL_PROJECT_REVENUE
,      PARENT_ASSIGNMENT_ID
,      WBS_ELEMENT_VERSION_ID
,      RBS_ELEMENT_ID
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      SPREAD_CURVE_ID
,      ETC_METHOD_CODE
,      RES_TYPE_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      FC_RES_TYPE_CODE
,      RESOURCE_CLASS_CODE
,      ORGANIZATION_ID
,      JOB_ID
,      PERSON_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY_CODE
,      EVENT_TYPE
,      SUPPLIER_ID
,      PROJECT_ROLE_ID
,      PERSON_TYPE_CODE
,      NON_LABOR_RESOURCE
,      BOM_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      RECORD_VERSION_NUMBER
,      BILLABLE_PERCENT
,      TRANSACTION_SOURCE_CODE
,      MFC_COST_TYPE_ID
,      PROCURE_RESOURCE_FLAG
,      ASSIGNMENT_DESCRIPTION
,      INCURRED_BY_RES_FLAG
,      RATE_JOB_ID
,      RATE_EXPENDITURE_TYPE
,      TA_DISPLAY_FLAG
,      SP_FIXED_DATE
,      RATE_BASED_FLAG
,      USE_TASK_SCHEDULE_FLAG
,      RATE_EXP_FUNC_CURR_CODE
,      RATE_EXPENDITURE_ORG_ID
,      INCUR_BY_RES_CLASS_CODE
,      INCUR_BY_ROLE_ID
,      RESOURCE_CLASS_FLAG
,      NAMED_ROLE
,      TXN_ACCUM_HEADER_ID
,      PM_PRODUCT_CODE
,      PM_RES_ASSIGNMENT_REFERENCE
,      SCHEDULE_START_DATE
,      SCHEDULE_END_DATE
,      UNPLANNED_FLAG
,      SCHEDULED_DELAY
,      RESOURCE_RATE_BASED_FLAG
,      CBS_ELEMENT_ID
FROM PA.PA_RESOURCE_ASSIGNMENTS#;

Dependencies

[top of page]

PA.PA_RESOURCE_ASSIGNMENTS# references the following:

SchemaPA
TablePA_RESOURCE_ASSIGNMENTS
PA.PA_RESOURCE_ASSIGNMENTS# is referenced by following:

SchemaAPPS
SynonymPA_RESOURCE_ASSIGNMENTS