eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: PA.PA_PROJECT_ASSIGNMENTS#

Source

View Text - Preformatted


select ASSIGNMENT_ID ASSIGNMENT_ID, ASSIGNMENT_NAME ASSIGNMENT_NAME, ASSIGNMENT_TYPE ASSIGNMENT_TYPE, MULTIPLE_STATUS_FLAG MULTIPLE_STATUS_FLAG, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, STATUS_CODE STATUS_CODE, PROJECT_ID PROJECT_ID, PROJECT_ROLE_ID PROJECT_ROLE_ID, RESOURCE_ID RESOURCE_ID, PROJECT_PARTY_ID PROJECT_PARTY_ID, DESCRIPTION DESCRIPTION, START_DATE START_DATE, END_DATE END_DATE, ASSIGNMENT_EFFORT ASSIGNMENT_EFFORT, EXTENSION_POSSIBLE EXTENSION_POSSIBLE, SOURCE_ASSIGNMENT_ID SOURCE_ASSIGNMENT_ID, ASSIGNMENT_TEMPLATE_ID ASSIGNMENT_TEMPLATE_ID, MIN_RESOURCE_JOB_LEVEL MIN_RESOURCE_JOB_LEVEL, MAX_RESOURCE_JOB_LEVEL MAX_RESOURCE_JOB_LEVEL, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, ADDITIONAL_INFORMATION ADDITIONAL_INFORMATION, WORK_TYPE_ID WORK_TYPE_ID, REVENUE_CURRENCY_CODE REVENUE_CURRENCY_CODE, REVENUE_BILL_RATE REVENUE_BILL_RATE, EXPENSE_OWNER EXPENSE_OWNER, EXPENSE_LIMIT EXPENSE_LIMIT, EXPENSE_LIMIT_CURRENCY_CODE EXPENSE_LIMIT_CURRENCY_CODE, FCST_TP_AMOUNT_TYPE FCST_TP_AMOUNT_TYPE, FCST_JOB_ID FCST_JOB_ID, LOCATION_ID LOCATION_ID, CALENDAR_TYPE CALENDAR_TYPE, CALENDAR_ID CALENDAR_ID, RESOURCE_CALENDAR_PERCENT RESOURCE_CALENDAR_PERCENT, 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, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PENDING_APPROVAL_FLAG PENDING_APPROVAL_FLAG, FCST_JOB_GROUP_ID FCST_JOB_GROUP_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS, EXPENDITURE_TYPE EXPENDITURE_TYPE, APPRVL_STATUS_CODE APPRVL_STATUS_CODE, NOTE_TO_APPROVER NOTE_TO_APPROVER, STAFFING_PRIORITY_CODE STAFFING_PRIORITY_CODE, TEMPLATE_FLAG TEMPLATE_FLAG, NO_OF_ACTIVE_CANDIDATES NO_OF_ACTIVE_CANDIDATES, MASS_WF_IN_PROGRESS_FLAG MASS_WF_IN_PROGRESS_FLAG, BILL_RATE_OVERRIDE BILL_RATE_OVERRIDE, BILL_RATE_CURR_OVERRIDE BILL_RATE_CURR_OVERRIDE, MARKUP_PERCENT_OVERRIDE MARKUP_PERCENT_OVERRIDE, TP_RATE_OVERRIDE TP_RATE_OVERRIDE, TP_CURRENCY_OVERRIDE TP_CURRENCY_OVERRIDE, TP_CALC_BASE_CODE_OVERRIDE TP_CALC_BASE_CODE_OVERRIDE, TP_PERCENT_APPLIED_OVERRIDE TP_PERCENT_APPLIED_OVERRIDE, MARKUP_PERCENT MARKUP_PERCENT, SEARCH_MIN_AVAILABILITY SEARCH_MIN_AVAILABILITY, SEARCH_COUNTRY_CODE SEARCH_COUNTRY_CODE, SEARCH_EXP_ORG_STRUCT_VER_ID SEARCH_EXP_ORG_STRUCT_VER_ID, SEARCH_EXP_START_ORG_ID SEARCH_EXP_START_ORG_ID, SEARCH_MIN_CANDIDATE_SCORE SEARCH_MIN_CANDIDATE_SCORE, LAST_AUTO_SEARCH_DATE LAST_AUTO_SEARCH_DATE, ENABLE_AUTO_CAND_NOM_FLAG ENABLE_AUTO_CAND_NOM_FLAG, COMPETENCE_MATCH_WEIGHTING COMPETENCE_MATCH_WEIGHTING, AVAILABILITY_MATCH_WEIGHTING AVAILABILITY_MATCH_WEIGHTING, JOB_LEVEL_MATCH_WEIGHTING JOB_LEVEL_MATCH_WEIGHTING, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE, RATE_DISC_REASON_CODE RATE_DISC_REASON_CODE, STAFFING_OWNER_PERSON_ID STAFFING_OWNER_PERSON_ID, TRANSFER_PRICE_RATE TRANSFER_PRICE_RATE, TRANSFER_PR_RATE_CURR TRANSFER_PR_RATE_CURR, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, ORIG_SYSTEM_CODE ORIG_SYSTEM_CODE, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE from "PA"."PA_PROJECT_ASSIGNMENTS"

View Text - HTML Formatted

SELECT ASSIGNMENT_ID ASSIGNMENT_ID
, ASSIGNMENT_NAME ASSIGNMENT_NAME
, ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, MULTIPLE_STATUS_FLAG MULTIPLE_STATUS_FLAG
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, STATUS_CODE STATUS_CODE
, PROJECT_ID PROJECT_ID
, PROJECT_ROLE_ID PROJECT_ROLE_ID
, RESOURCE_ID RESOURCE_ID
, PROJECT_PARTY_ID PROJECT_PARTY_ID
, DESCRIPTION DESCRIPTION
, START_DATE START_DATE
, END_DATE END_DATE
, ASSIGNMENT_EFFORT ASSIGNMENT_EFFORT
, EXTENSION_POSSIBLE EXTENSION_POSSIBLE
, SOURCE_ASSIGNMENT_ID SOURCE_ASSIGNMENT_ID
, ASSIGNMENT_TEMPLATE_ID ASSIGNMENT_TEMPLATE_ID
, MIN_RESOURCE_JOB_LEVEL MIN_RESOURCE_JOB_LEVEL
, MAX_RESOURCE_JOB_LEVEL MAX_RESOURCE_JOB_LEVEL
, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ADDITIONAL_INFORMATION ADDITIONAL_INFORMATION
, WORK_TYPE_ID WORK_TYPE_ID
, REVENUE_CURRENCY_CODE REVENUE_CURRENCY_CODE
, REVENUE_BILL_RATE REVENUE_BILL_RATE
, EXPENSE_OWNER EXPENSE_OWNER
, EXPENSE_LIMIT EXPENSE_LIMIT
, EXPENSE_LIMIT_CURRENCY_CODE EXPENSE_LIMIT_CURRENCY_CODE
, FCST_TP_AMOUNT_TYPE FCST_TP_AMOUNT_TYPE
, FCST_JOB_ID FCST_JOB_ID
, LOCATION_ID LOCATION_ID
, CALENDAR_TYPE CALENDAR_TYPE
, CALENDAR_ID CALENDAR_ID
, RESOURCE_CALENDAR_PERCENT RESOURCE_CALENDAR_PERCENT
, 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
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PENDING_APPROVAL_FLAG PENDING_APPROVAL_FLAG
, FCST_JOB_GROUP_ID FCST_JOB_GROUP_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, APPRVL_STATUS_CODE APPRVL_STATUS_CODE
, NOTE_TO_APPROVER NOTE_TO_APPROVER
, STAFFING_PRIORITY_CODE STAFFING_PRIORITY_CODE
, TEMPLATE_FLAG TEMPLATE_FLAG
, NO_OF_ACTIVE_CANDIDATES NO_OF_ACTIVE_CANDIDATES
, MASS_WF_IN_PROGRESS_FLAG MASS_WF_IN_PROGRESS_FLAG
, BILL_RATE_OVERRIDE BILL_RATE_OVERRIDE
, BILL_RATE_CURR_OVERRIDE BILL_RATE_CURR_OVERRIDE
, MARKUP_PERCENT_OVERRIDE MARKUP_PERCENT_OVERRIDE
, TP_RATE_OVERRIDE TP_RATE_OVERRIDE
, TP_CURRENCY_OVERRIDE TP_CURRENCY_OVERRIDE
, TP_CALC_BASE_CODE_OVERRIDE TP_CALC_BASE_CODE_OVERRIDE
, TP_PERCENT_APPLIED_OVERRIDE TP_PERCENT_APPLIED_OVERRIDE
, MARKUP_PERCENT MARKUP_PERCENT
, SEARCH_MIN_AVAILABILITY SEARCH_MIN_AVAILABILITY
, SEARCH_COUNTRY_CODE SEARCH_COUNTRY_CODE
, SEARCH_EXP_ORG_STRUCT_VER_ID SEARCH_EXP_ORG_STRUCT_VER_ID
, SEARCH_EXP_START_ORG_ID SEARCH_EXP_START_ORG_ID
, SEARCH_MIN_CANDIDATE_SCORE SEARCH_MIN_CANDIDATE_SCORE
, LAST_AUTO_SEARCH_DATE LAST_AUTO_SEARCH_DATE
, ENABLE_AUTO_CAND_NOM_FLAG ENABLE_AUTO_CAND_NOM_FLAG
, COMPETENCE_MATCH_WEIGHTING COMPETENCE_MATCH_WEIGHTING
, AVAILABILITY_MATCH_WEIGHTING AVAILABILITY_MATCH_WEIGHTING
, JOB_LEVEL_MATCH_WEIGHTING JOB_LEVEL_MATCH_WEIGHTING
, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE
, RATE_DISC_REASON_CODE RATE_DISC_REASON_CODE
, STAFFING_OWNER_PERSON_ID STAFFING_OWNER_PERSON_ID
, TRANSFER_PRICE_RATE TRANSFER_PRICE_RATE
, TRANSFER_PR_RATE_CURR TRANSFER_PR_RATE_CURR
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, ORIG_SYSTEM_CODE ORIG_SYSTEM_CODE
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
FROM "PA"."PA_PROJECT_ASSIGNMENTS"