VIEW: PA.PA_RESOURCE_ASSIGNMENTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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