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]

TABLE: PA.PA_PROJECT_ASSIGNMENTS

Object Details

Object Name:	PA_PROJECT_ASSIGNMENTS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJECT_ASSIGNMENTS
Subobject Name:
Status:	VALID

PA_PROJECT_ASSIGNMENTS stores details of assignments and requirements belonging to projects, as well as template requirements belong to team template.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECT_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID
PA_PROJECT_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID ASSIGNMENT_TYPE
PA_PROJECT_ASSIGNMENTS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPRVL_STATUS_CODE
PA_PROJECT_ASSIGNMENTS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_MEMBER_ID
PA_PROJECT_ASSIGNMENTS_N12	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TO_CHAR("ASSIGNMENT_NUMBER")
PA_PROJECT_ASSIGNMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID
PA_PROJECT_ASSIGNMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_TEMPLATE_ID
PA_PROJECT_ASSIGNMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MIN_RESOURCE_JOB_LEVEL MAX_RESOURCE_JOB_LEVEL START_DATE ASSIGNMENT_TYPE PROJECT_ROLE_ID STAFFING_PRIORITY_CODE LOCATION_ID
PA_PROJECT_ASSIGNMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ASSIGNMENT_ID
PA_PROJECT_ASSIGNMENTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_PARTY_ID
PA_PROJECT_ASSIGNMENTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ROLE_ID
PA_PROJECT_ASSIGNMENTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STAFFING_OWNER_PERSON_ID
PA_PROJECT_ASSIGNMENTS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
PA_PROJECT_ASSIGNMENTS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ID	NUMBER		Yes	The system generated number that uniquely identifies the assignment
ASSIGNMENT_NAME	VARCHAR2	(80)	Yes	The user-defined name that identifies the requirement or assignment
ASSIGNMENT_TYPE	VARCHAR2	(30)	Yes	Indicates whether it is a requirement or assignment
MULTIPLE_STATUS_FLAG	VARCHAR2	(1)	Yes	Indicates whether the underlying schedule for the requirement or assignment has more than one status
RECORD_VERSION_NUMBER	NUMBER		Yes	Indicates the version of the requirement or assignment record. The column increments by one upon each saved modification to the requirement or assignment record.
STATUS_CODE	VARCHAR2	(30)		Indicates the status of the requirement or assignment. This column may be null if the underlying schedule has multiple status codes.
PROJECT_ID	NUMBER			The identifier of the project to which this requirement or assignment belongs
PROJECT_ROLE_ID	NUMBER			The identifier of the project role for the requirement or assignment
RESOURCE_ID	NUMBER			The identifier of the project resource
PROJECT_PARTY_ID	NUMBER			The identifier of the project party on an assignment
DESCRIPTION	VARCHAR2	(2000)		The free text description of the requirement or assignment
START_DATE	DATE			The start date of the requirement or assignment
END_DATE	DATE			The end date of the requirement or assignment
ASSIGNMENT_EFFORT	NUMBER			Total number of hours of the requirement or assignment
EXTENSION_POSSIBLE	VARCHAR2	(1)		Indicates whether it is possible to extend the requirement or assignment
SOURCE_ASSIGNMENT_ID	NUMBER			Identifies the requirement from which this requirement or assignment record originated
ASSIGNMENT_TEMPLATE_ID	NUMBER			The identifier of the team template to which this requirement belongs, if any.
MIN_RESOURCE_JOB_LEVEL	NUMBER			Indicates the minimum acceptable job level for a requirement. The default value for this column on new requirement records is retrieved from the project role setup.
MAX_RESOURCE_JOB_LEVEL	NUMBER			Indicates the maximum acceptable job level for a requirement. The default value for this column on new requirement records is retrieved from the project role setup.
ASSIGNMENT_NUMBER	NUMBER			A reference number that uniquely identifies a requirement
ADDITIONAL_INFORMATION	VARCHAR2	(2000)		The free text for additional information on a requirement or assignment
WORK_TYPE_ID	NUMBER			Identifies the type of work being carried out. The default value for this column is retrieved from the project for both requirements and assignments not created from a requirement
REVENUE_CURRENCY_CODE	VARCHAR2	(15)		The currency of the revenue bill rate
REVENUE_BILL_RATE	NUMBER			The revenue bill rate
EXPENSE_OWNER	VARCHAR2	(30)		The owner of the expenses for the requirement or assignment
EXPENSE_LIMIT	NUMBER			The maximum amount that expense owner is willing to pay
EXPENSE_LIMIT_CURRENCY_CODE	VARCHAR2	(15)		The currency code of the expense limit
FCST_TP_AMOUNT_TYPE	VARCHAR2	(30)		Indicates whether the requirement or assignment is classified as cost transfer or revenue transfer for forecasting
FCST_JOB_ID	NUMBER			The identifier for the job for the forecast of the requirement. This column would be used to determine cost, revenue, and transfer price rates for the requirement during forecast processing
LOCATION_ID	NUMBER			The identifier of the location of the requirement or assignment. The default value for this column on new requirement or assignment records is retrieved from the project.
CALENDAR_TYPE	VARCHAR2	(30)		Indicates the base calendar used for generating schedules.
CALENDAR_ID	NUMBER			The identifier of the calendar for the requirement or assignment. The default value for this column on new requirement or assignment records is retrieved from the project.
RESOURCE_CALENDAR_PERCENT	NUMBER			The percentage of the resource's calendar that the resource is allocated on the assignment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PENDING_APPROVAL_FLAG	VARCHAR2	(1)		Indicates whether workflow approval is pending for the assignment
FCST_JOB_GROUP_ID	NUMBER			Indicates the job group associated with the forecasting job. This value defaults from the Team Role.
EXPENDITURE_ORG_ID	NUMBER			Indicates the default operating unit for requirements and assignments. For assignments, this value represents the operating unit of the assigned resource.
EXPENDITURE_ORGANIZATION_ID	NUMBER			Indicates the expenditure organization for the assignment. It defaults to the project organization for requirements and to the resource organization for assignments.
EXPENDITURE_TYPE_CLASS	VARCHAR2	(30)		Identifies the Expenditure Type Class to use to generate forecast transactions. This value defaults from Forecasting Options.
EXPENDITURE_TYPE	VARCHAR2	(30)		Identifies the expenditure type that will be used for this team role for generating forecast transactions. This value defaults from the Forecasting Options.
APPRVL_STATUS_CODE	VARCHAR2	(30)		Indicates the approval status of the assignment.
NOTE_TO_APPROVER	VARCHAR2	(240)		The descriptive reason for modification.
STAFFING_PRIORITY_CODE	VARCHAR2	(30)		The staffing priority of the requirement
TEMPLATE_FLAG	VARCHAR2	(1)		Indicates the requirement is a template requirement.
NO_OF_ACTIVE_CANDIDATES	NUMBER			Holds the number of candidates with a system status of PENDING_REVIEW or UNDER_REVIEW or SUITABLE.
MASS_WF_IN_PROGRESS_FLAG	VARCHAR2	(1)		Indicates if a deferred mass workflow process is in progress for this assignment
BILL_RATE_OVERRIDE	NUMBER			The overriding bill rate used to determine the revenue or bill amount for the item
BILL_RATE_CURR_OVERRIDE	VARCHAR2	(30)		The overriding currency code of the overriding bill rate
MARKUP_PERCENT_OVERRIDE	NUMBER			The overriding markup percentage over raw cost used to determine the revenue or bill amount for the item
TP_RATE_OVERRIDE	NUMBER			The overriding transfer price rate used to determine the cross charge amount of the assignment
TP_CURRENCY_OVERRIDE	VARCHAR2	(30)		The overriding currency code of the overriding transfer price rate
TP_CALC_BASE_CODE_OVERRIDE	VARCHAR2	(30)		The overriding transaction amount on which the transfer price will be based when calculated using applied percentage
TP_PERCENT_APPLIED_OVERRIDE	NUMBER			The overriding percentage applied on the selected transaction determine the cross charge amount for the assignment.
MARKUP_PERCENT	NUMBER			The markup percent
SEARCH_MIN_AVAILABILITY	NUMBER			The minimum required availability of a resource to be returned in the search result
SEARCH_COUNTRY_CODE	VARCHAR2	(2)		Identifies the country for the search
SEARCH_EXP_ORG_STRUCT_VER_ID	NUMBER			Identifies the organization hierarchy for the search
SEARCH_EXP_START_ORG_ID	NUMBER			Identifies the starting organization for the search
SEARCH_MIN_CANDIDATE_SCORE	NUMBER			The minimum score required for a resource to be nominated as candidate on a requirement
LAST_AUTO_SEARCH_DATE	DATE			The most recent date and time when the automated process was run to nominate system generated candidates for the requirement
ENABLE_AUTO_CAND_NOM_FLAG	VARCHAR2	(1)		Indicates whether or not automated candidate nomination for the requirement is enabled
COMPETENCE_MATCH_WEIGHTING	NUMBER			The competence match weighting for a requirement
AVAILABILITY_MATCH_WEIGHTING	NUMBER			The availability match weighting for a requirement
JOB_LEVEL_MATCH_WEIGHTING	NUMBER			The job level match weighting for a requirement
DISCOUNT_PERCENTAGE	NUMBER			Audit column for rate derivation. The discount percentage is used to derive the adjusted revenue and rate
RATE_DISC_REASON_CODE	VARCHAR2	(30)		Reason code for dicount,discount override or rate override
STAFFING_OWNER_PERSON_ID	NUMBER			Identifier of the staffing owner of the team role
TRANSFER_PRICE_RATE	NUMBER			The transfer price rate of the assignment or requirement
TRANSFER_PR_RATE_CURR	VARCHAR2	(15)		Currency of the transfer price rate
RESOURCE_LIST_MEMBER_ID	NUMBER			Planning resource associated with this team role
ORIG_SYSTEM_CODE	VARCHAR2	(80)		The identifier of the external project management system from which the assignment and requirement data was imported.
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		The identifier of the assignment and requirement data in the external project management system from which the assignment and requirement data was imported.

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
,      STATUS_CODE
,      PROJECT_ID
,      PROJECT_ROLE_ID
,      RESOURCE_ID
,      PROJECT_PARTY_ID
,      DESCRIPTION
,      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
,      LOCATION_ID
,      CALENDAR_TYPE
,      CALENDAR_ID
,      RESOURCE_CALENDAR_PERCENT
,      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
,      PENDING_APPROVAL_FLAG
,      FCST_JOB_GROUP_ID
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE_CLASS
,      EXPENDITURE_TYPE
,      APPRVL_STATUS_CODE
,      NOTE_TO_APPROVER
,      STAFFING_PRIORITY_CODE
,      TEMPLATE_FLAG
,      NO_OF_ACTIVE_CANDIDATES
,      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
,      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
,      COMPETENCE_MATCH_WEIGHTING
,      AVAILABILITY_MATCH_WEIGHTING
,      JOB_LEVEL_MATCH_WEIGHTING
,      DISCOUNT_PERCENTAGE
,      RATE_DISC_REASON_CODE
,      STAFFING_OWNER_PERSON_ID
,      TRANSFER_PRICE_RATE
,      TRANSFER_PR_RATE_CURR
,      RESOURCE_LIST_MEMBER_ID
,      ORIG_SYSTEM_CODE
,      ORIG_SYSTEM_REFERENCE
FROM PA.PA_PROJECT_ASSIGNMENTS;

Dependencies

[top of page]

PA.PA_PROJECT_ASSIGNMENTS does not reference any database object

PA.PA_PROJECT_ASSIGNMENTS is referenced by following:

PA: PA_PROJECT_ASSIGNMENTS#