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.

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

VIEW: PA.PA_ASSIGNMENTS_HISTORY#

Object Details

Object Name:	PA_ASSIGNMENTS_HISTORY#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ASSIGNMENT_ID	NUMBER		Yes
ASSIGNMENT_NAME	VARCHAR2	(80)	Yes
ASSIGNMENT_TYPE	VARCHAR2	(30)	Yes
MULTIPLE_STATUS_FLAG	VARCHAR2	(1)	Yes
RECORD_VERSION_NUMBER	NUMBER		Yes
CHANGE_ID	NUMBER		Yes
APPRVL_STATUS_CODE	VARCHAR2	(30)
STATUS_CODE	VARCHAR2	(30)
PROJECT_ID	NUMBER
PROJECT_ROLE_ID	NUMBER
RESOURCE_ID	NUMBER
PROJECT_PARTY_ID	NUMBER
DESCRIPTION	VARCHAR2	(2000)
NOTE_TO_APPROVER	VARCHAR2	(240)
START_DATE	DATE
END_DATE	DATE
ASSIGNMENT_EFFORT	NUMBER
EXTENSION_POSSIBLE	VARCHAR2	(1)
SOURCE_ASSIGNMENT_ID	NUMBER
ASSIGNMENT_TEMPLATE_ID	NUMBER
MIN_RESOURCE_JOB_LEVEL	NUMBER
MAX_RESOURCE_JOB_LEVEL	NUMBER
ASSIGNMENT_NUMBER	NUMBER
ADDITIONAL_INFORMATION	VARCHAR2	(2000)
WORK_TYPE_ID	NUMBER
REVENUE_CURRENCY_CODE	VARCHAR2	(15)
REVENUE_BILL_RATE	NUMBER
EXPENSE_OWNER	VARCHAR2	(30)
EXPENSE_LIMIT	NUMBER	(15)
EXPENSE_LIMIT_CURRENCY_CODE	VARCHAR2	(15)
FCST_TP_AMOUNT_TYPE	VARCHAR2	(30)
FCST_JOB_ID	NUMBER
FCST_JOB_GROUP_ID	NUMBER
EXPENDITURE_ORG_ID	NUMBER
EXPENDITURE_ORGANIZATION_ID	NUMBER
EXPENDITURE_TYPE_CLASS	VARCHAR2	(30)
EXPENDITURE_TYPE	VARCHAR2	(30)
LOCATION_ID	NUMBER
CALENDAR_TYPE	VARCHAR2	(30)
CALENDAR_ID	NUMBER
RESOURCE_CALENDAR_PERCENT	NUMBER
PENDING_APPROVAL_FLAG	VARCHAR2	(1)
LAST_APPROVED_FLAG	VARCHAR2	(1)
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)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
STAFFING_PRIORITY_CODE	VARCHAR2	(30)
PROJECT_SUBTEAM_ID	NUMBER
NO_OF_ACTIVE_CANDIDATES	NUMBER
TEMPLATE_FLAG	VARCHAR2	(1)
COMPETENCE_MATCH_WEIGHTING	NUMBER
AVAILABILITY_MATCH_WEIGHTING	NUMBER
JOB_LEVEL_MATCH_WEIGHTING	NUMBER
SEARCH_MIN_AVAILABILITY	NUMBER
SEARCH_COUNTRY_CODE	VARCHAR2	(2)
SEARCH_EXP_ORG_STRUCT_VER_ID	NUMBER	(15)
SEARCH_EXP_START_ORG_ID	NUMBER	(15)
SEARCH_MIN_CANDIDATE_SCORE	NUMBER
LAST_AUTO_SEARCH_DATE	DATE
ENABLE_AUTO_CAND_NOM_FLAG	VARCHAR2	(1)
MASS_WF_IN_PROGRESS_FLAG	VARCHAR2	(1)
BILL_RATE_OVERRIDE	NUMBER
BILL_RATE_CURR_OVERRIDE	VARCHAR2	(30)
MARKUP_PERCENT_OVERRIDE	NUMBER
TP_RATE_OVERRIDE	NUMBER
TP_CURRENCY_OVERRIDE	VARCHAR2	(30)
TP_CALC_BASE_CODE_OVERRIDE	VARCHAR2	(30)
TP_PERCENT_APPLIED_OVERRIDE	NUMBER
MARKUP_PERCENT	NUMBER
STAFFING_OWNER_PERSON_ID	NUMBER
TRANSFER_PRICE_RATE	NUMBER
TRANSFER_PR_RATE_CURR	VARCHAR2	(15)
DISCOUNT_PERCENTAGE	NUMBER
RATE_DISC_REASON_CODE	VARCHAR2	(30)

Query Text

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


SELECT ASSIGNMENT_ID
,      ASSIGNMENT_NAME
,      ASSIGNMENT_TYPE
,      MULTIPLE_STATUS_FLAG
,      RECORD_VERSION_NUMBER
,      CHANGE_ID
,      APPRVL_STATUS_CODE
,      STATUS_CODE
,      PROJECT_ID
,      PROJECT_ROLE_ID
,      RESOURCE_ID
,      PROJECT_PARTY_ID
,      DESCRIPTION
,      NOTE_TO_APPROVER
,      START_DATE
,      END_DATE
,      ASSIGNMENT_EFFORT
,      EXTENSION_POSSIBLE
,      SOURCE_ASSIGNMENT_ID
,      ASSIGNMENT_TEMPLATE_ID
,      MIN_RESOURCE_JOB_LEVEL
,      MAX_RESOURCE_JOB_LEVEL
,      ASSIGNMENT_NUMBER
,      ADDITIONAL_INFORMATION
,      WORK_TYPE_ID
,      REVENUE_CURRENCY_CODE
,      REVENUE_BILL_RATE
,      EXPENSE_OWNER
,      EXPENSE_LIMIT
,      EXPENSE_LIMIT_CURRENCY_CODE
,      FCST_TP_AMOUNT_TYPE
,      FCST_JOB_ID
,      FCST_JOB_GROUP_ID
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE_CLASS
,      EXPENDITURE_TYPE
,      LOCATION_ID
,      CALENDAR_TYPE
,      CALENDAR_ID
,      RESOURCE_CALENDAR_PERCENT
,      PENDING_APPROVAL_FLAG
,      LAST_APPROVED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      STAFFING_PRIORITY_CODE
,      PROJECT_SUBTEAM_ID
,      NO_OF_ACTIVE_CANDIDATES
,      TEMPLATE_FLAG
,      COMPETENCE_MATCH_WEIGHTING
,      AVAILABILITY_MATCH_WEIGHTING
,      JOB_LEVEL_MATCH_WEIGHTING
,      SEARCH_MIN_AVAILABILITY
,      SEARCH_COUNTRY_CODE
,      SEARCH_EXP_ORG_STRUCT_VER_ID
,      SEARCH_EXP_START_ORG_ID
,      SEARCH_MIN_CANDIDATE_SCORE
,      LAST_AUTO_SEARCH_DATE
,      ENABLE_AUTO_CAND_NOM_FLAG
,      MASS_WF_IN_PROGRESS_FLAG
,      BILL_RATE_OVERRIDE
,      BILL_RATE_CURR_OVERRIDE
,      MARKUP_PERCENT_OVERRIDE
,      TP_RATE_OVERRIDE
,      TP_CURRENCY_OVERRIDE
,      TP_CALC_BASE_CODE_OVERRIDE
,      TP_PERCENT_APPLIED_OVERRIDE
,      MARKUP_PERCENT
,      STAFFING_OWNER_PERSON_ID
,      TRANSFER_PRICE_RATE
,      TRANSFER_PR_RATE_CURR
,      DISCOUNT_PERCENTAGE
,      RATE_DISC_REASON_CODE
FROM PA.PA_ASSIGNMENTS_HISTORY#;

Dependencies

[top of page]

PA.PA_ASSIGNMENTS_HISTORY# references the following:

PA: PA_ASSIGNMENTS_HISTORY

PA.PA_ASSIGNMENTS_HISTORY# is referenced by following:

APPS: PA_ASSIGNMENTS_HISTORY