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_TASKS

Object Details

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

PA_TASKS stores user-defined subdivisions of project
work. Tasks can be broken down into multiple levels
of subtasks. The depth and width of the work
breakdown structure (WBS) are unlimited.
The WBS is held using the TASK_ID and PARENT_TASK_ID columns.
Two columns related to the WBS are denormalized: TOP_TASK_ID and
WBS_LEVEL.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_TASKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TASK_ID
PA_TASKS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_NUMBER
PA_TASKS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LABOR_BILL_RATE_ORG_ID LABOR_STD_BILL_RATE_SCHDL
PA_TASKS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADDRESS_ID
PA_TASKS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_BILL_RATE_SCHEDULE_ID
PA_TASKS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMP_BILL_RATE_SCHEDULE_ID
PA_TASKS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NON_LAB_STD_BILL_RT_SCH_ID
PA_TASKS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TASK_ID PROJECT_ID
PA_TASKS_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID READY_TO_BILL_FLAG TASK_ID
PA_TASKS_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID READY_TO_BILL_FLAG TASK_ID TOP_TASK_ID INVOICE_METHOD
PA_TASKS_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TASK_ID TASK_ID
PA_TASKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CARRYING_OUT_ORGANIZATION_ID
PA_TASKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SERVICE_TYPE_CODE
PA_TASKS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TASK_ID TASK_NUMBER
PA_TASKS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NON_LABOR_BILL_RATE_ORG_ID NON_LABOR_STD_BILL_RATE_SCHDL
PA_TASKS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_MANAGER_PERSON_ID
PA_TASKS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOP_TASK_ID
PA_TASKS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID PM_TASK_REFERENCE
PA_TASKS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADW_NOTIFY_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the task
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the task is a unit of work
TASK_NUMBER	VARCHAR2	(25)	Yes	User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. However note: task numbers do not record the wbs structure
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
TASK_NAME	VARCHAR2	(20)	Yes	User-defined short name of the task
TOP_TASK_ID	NUMBER	(15)	Yes	The identifier of the top task to which this tasks rolls up. If the task is a top task, the top_task_id is set to its own task_id.
WBS_LEVEL	NUMBER	(3)	Yes	The level of the task in the work breakdown structure
READY_TO_BILL_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the task is authorized to be invoiced. The flag is set only for top tasks, defaults to 'Y' upon creation of the task and is set to 'Y' or 'N' in the Control Revenue and Billing by Top Task form
READY_TO_DISTRIBUTE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the task is authorized for revenue accrual. The flag is set only for top tasks, defaults to 'Y' upon creation of the task, and is set to 'Y' or 'N' in the Control Revenue and Billing by Top Task form
PARENT_TASK_ID	NUMBER	(15)		The identifier of the task that is the parent of the task in the project work breakdown structure
DESCRIPTION	VARCHAR2	(250)		Description of the task
CARRYING_OUT_ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier of the organization that is responsible for the task work. The project organization is defaulted to the task organization upon creation of the task
SERVICE_TYPE_CODE	VARCHAR2	(30)		The type of work performed on the task
TASK_MANAGER_PERSON_ID	NUMBER	(9)		The identifier of the employee that manages the task.
CHARGEABLE_FLAG	VARCHAR2	(1)		Flag that indicates if expenditure items can be charged to the task. Only lowest level tasks can be chargeable
BILLABLE_FLAG	VARCHAR2	(1)		Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). For capital projects this flag is used as capitalizable_flag. For indirect projects this flag is set to N and is not used.
LIMIT_TO_TXN_CONTROLS_FLAG	VARCHAR2	(1)		Flag that indicates if users can only charge expenditures to the task that are listed in task's transaction controls. If flag =Y, then only items listed in controls are allowed. If flag = 'N' or null, then items not listed are allowed
START_DATE	DATE			The date on which the task starts; expenditure items with item dates before the start date cannot be entered for the task
COMPLETION_DATE	DATE			The date on which the task is completed; expenditure items with item dates after the task completion date cannot be entered for the task. You must enter a start date to enter a completion date.
ADDRESS_ID	NUMBER	(15)		The identifier of the customer address that is the task work site. This value is defaulted from the project customer work site if only one project customer exists
LABOR_BILL_RATE_ORG_ID	NUMBER	(15)		The identifier of the organization that owns the labor standard bill rate schedule
LABOR_STD_BILL_RATE_SCHDL	VARCHAR2	(20)		The labor standard bill rate schedule that is used to calculate revenue for labor expenditure items charged to the task
LABOR_SCHEDULE_FIXED_DATE	DATE			The date used to determine the effective bill rates of the task standard labor bill rate schedule. If no fixed date is entered, the expenditure item date is used to determine the effective bill rate for the item
LABOR_SCHEDULE_DISCOUNT	NUMBER	(7)		The percentage to be discounted from the task standard labor bill rate schedule
NON_LABOR_BILL_RATE_ORG_ID	NUMBER	(15)		The identifier of the organization that owns the non-labor standard bill rate schedule
NON_LABOR_STD_BILL_RATE_SCHDL	VARCHAR2	(30)		The non-labor standard bill rate schedule that is used to calculate revenue for non-labor expenditure items charged to the task
NON_LABOR_SCHEDULE_FIXED_DATE	DATE			The fixed date used to determine the effective bill rates of the standard non-labor bill rate schedule. If no fixed date is entered, the expenditure item date is used to determine the effective bill rate of the item
NON_LABOR_SCHEDULE_DISCOUNT	NUMBER	(7)		The percentage to be discounted from the task standard non-labor bill rate schedule
LABOR_COST_MULTIPLIER_NAME	VARCHAR2	(20)		The labor cost multiplier defined for the task of a premium project. The labor cost multiplier is populated for all overtime expenditure items charged to the task upon manual entry of the items or in the Overtime Calculation program
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
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
COST_IND_RATE_SCH_ID	NUMBER	(15)		The identifier of default costing burden schedule
REV_IND_RATE_SCH_ID	NUMBER	(15)		The identifier of default revenue burden schedule
INV_IND_RATE_SCH_ID	NUMBER	(15)		The identifier of default invoice burden schedule
COST_IND_SCH_FIXED_DATE	DATE			The schedule fixed date of firm costing burden schedule
REV_IND_SCH_FIXED_DATE	DATE			The schedule fixed date of firm revenue burden schedule
INV_IND_SCH_FIXED_DATE	DATE			The schedule fixed date of firm invoice burden schedule
LABOR_SCH_TYPE	VARCHAR2	(1)		The schedule type of labor expenditure items
NON_LABOR_SCH_TYPE	VARCHAR2	(1)		The schedule type of non-labor expenditure items
OVR_COST_IND_RATE_SCH_ID	NUMBER	(15)		This column is not used
OVR_INV_IND_RATE_SCH_ID	NUMBER	(15)		This column is not used
OVR_REV_IND_RATE_SCH_ID	NUMBER	(15)		This column is not used
PM_PRODUCT_CODE	VARCHAR2	(30)		The identifier of the external project management system from which the task was imported.
PM_TASK_REFERENCE	VARCHAR2	(25)		The identifier of the task in the external project management system from which the budget was imported.
ACTUAL_START_DATE	DATE			The actual start date of the project. Applicable only for a project that has originated from an external system.
ACTUAL_FINISH_DATE	DATE			The actual end date of the project. Applicable only for a project that has originated from an external system.
EARLY_START_DATE	DATE			The early start date of the project. Applicable only for a project that has originated from an external system.
EARLY_FINISH_DATE	DATE			The early finish date of the project. Applicable only for a project that has originated from an external system.
LATE_START_DATE	DATE			The late start date of the project. Applicable only for a project that has originated from an external system.
LATE_FINISH_DATE	DATE			The late finish date of the project. Applicable only for a project that has originated from an external system.
SCHEDULED_START_DATE	DATE			The scheduled start date of the project. Applicable only for a project that has originated from an external system.
SCHEDULED_FINISH_DATE	DATE			The scheduled finish date of the project. Applicable only for a project that has originated from an external system.
ADW_NOTIFY_FLAG	VARCHAR2	(1)		The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
ALLOW_CROSS_CHARGE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether cross charge are allowed
PROJECT_RATE_DATE	DATE			Task level default value for project rate date
PROJECT_RATE_TYPE	VARCHAR2	(30)		Task level default value for project rate type
CC_PROCESS_LABOR_FLAG	VARCHAR2	(1)	Yes	Flag that indicates cross charge processing is to be performed for labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date
LABOR_TP_SCHEDULE_ID	NUMBER			Identifier for transfer price schedule to use for cross charged labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. If cc_process_labor_flag is set to Y, this field is required
LABOR_TP_FIXED_DATE	DATE			Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date
CC_PROCESS_NL_FLAG	VARCHAR2	(1)	Yes	Flag that indicates cross charge processing is to be performed for non-labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date
NL_TP_SCHEDULE_ID	NUMBER			Identifier for transfer price schedule to use for cross charged non-labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. If cc_process_nl_flag is set to Y, this field is required
NL_TP_FIXED_DATE	DATE			Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for non-labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date
RECEIVE_PROJECT_INVOICE_FLAG	VARCHAR2	(1)		Flag that indicates that the task may receive charges from internal supplies via inter-project billing
WORK_TYPE_ID	NUMBER	(15)		Work Types are predefined types of work, for example, Vacation, Training, and Administration.
RECORD_VERSION_NUMBER	NUMBER	(15)		Stores locking sequence number
JOB_BILL_RATE_SCHEDULE_ID	NUMBER			Stores the job based bill rate schedule ID for the project.
EMP_BILL_RATE_SCHEDULE_ID	NUMBER			Stores the employee based bill rate schedule ID for the project.
TASKFUNC_COST_RATE_TYPE	VARCHAR2	(30)		Task level default value for project functional cost rate type.
TASKFUNC_COST_RATE_DATE	DATE			Task level default value for project functional cost rate date.
NON_LAB_STD_BILL_RT_SCH_ID	NUMBER	(15)		Non labor standard bill rate schedule ID
LABOR_DISC_REASON_CODE	VARCHAR2	(30)		Reason code for labor discount
NON_LABOR_DISC_REASON_CODE	VARCHAR2	(30)		Reason code for non labor discount
LONG_TASK_NAME	VARCHAR2	(240)		Task Long Name
RETIREMENT_COST_FLAG	VARCHAR2	(1)		Flag to identify tasks for retirement cost collection.
CINT_ELIGIBLE_FLAG	VARCHAR2	(1)		Flag used to determine whether the project is eligible for capitalized interest.
CINT_STOP_DATE	DATE			Stop date for capital interest calculation.
REVENUE_ACCRUAL_METHOD	VARCHAR2	(30)		Indiactes the Revenue Method for Task.
INVOICE_METHOD	VARCHAR2	(30)		Indiactes the Invoice Method for Task.
CUSTOMER_ID	NUMBER			Indicates the Customer ID attached at Top Task.
GEN_ETC_SOURCE_CODE	VARCHAR2	(30)		Estimate to Complete Source.
BILL_SCHE_OVRD_FLAG	VARCHAR2	(1)		Billing Schedules Override Flag
ADJ_ON_STD_INV	VARCHAR2	(2)		Adjustments included on Standard Invoice

Query Text

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


SELECT TASK_ID
,      PROJECT_ID
,      TASK_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TASK_NAME
,      TOP_TASK_ID
,      WBS_LEVEL
,      READY_TO_BILL_FLAG
,      READY_TO_DISTRIBUTE_FLAG
,      PARENT_TASK_ID
,      DESCRIPTION
,      CARRYING_OUT_ORGANIZATION_ID
,      SERVICE_TYPE_CODE
,      TASK_MANAGER_PERSON_ID
,      CHARGEABLE_FLAG
,      BILLABLE_FLAG
,      LIMIT_TO_TXN_CONTROLS_FLAG
,      START_DATE
,      COMPLETION_DATE
,      ADDRESS_ID
,      LABOR_BILL_RATE_ORG_ID
,      LABOR_STD_BILL_RATE_SCHDL
,      LABOR_SCHEDULE_FIXED_DATE
,      LABOR_SCHEDULE_DISCOUNT
,      NON_LABOR_BILL_RATE_ORG_ID
,      NON_LABOR_STD_BILL_RATE_SCHDL
,      NON_LABOR_SCHEDULE_FIXED_DATE
,      NON_LABOR_SCHEDULE_DISCOUNT
,      LABOR_COST_MULTIPLIER_NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      COST_IND_RATE_SCH_ID
,      REV_IND_RATE_SCH_ID
,      INV_IND_RATE_SCH_ID
,      COST_IND_SCH_FIXED_DATE
,      REV_IND_SCH_FIXED_DATE
,      INV_IND_SCH_FIXED_DATE
,      LABOR_SCH_TYPE
,      NON_LABOR_SCH_TYPE
,      OVR_COST_IND_RATE_SCH_ID
,      OVR_INV_IND_RATE_SCH_ID
,      OVR_REV_IND_RATE_SCH_ID
,      PM_PRODUCT_CODE
,      PM_TASK_REFERENCE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      EARLY_START_DATE
,      EARLY_FINISH_DATE
,      LATE_START_DATE
,      LATE_FINISH_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      ADW_NOTIFY_FLAG
,      ALLOW_CROSS_CHARGE_FLAG
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      CC_PROCESS_LABOR_FLAG
,      LABOR_TP_SCHEDULE_ID
,      LABOR_TP_FIXED_DATE
,      CC_PROCESS_NL_FLAG
,      NL_TP_SCHEDULE_ID
,      NL_TP_FIXED_DATE
,      RECEIVE_PROJECT_INVOICE_FLAG
,      WORK_TYPE_ID
,      RECORD_VERSION_NUMBER
,      JOB_BILL_RATE_SCHEDULE_ID
,      EMP_BILL_RATE_SCHEDULE_ID
,      TASKFUNC_COST_RATE_TYPE
,      TASKFUNC_COST_RATE_DATE
,      NON_LAB_STD_BILL_RT_SCH_ID
,      LABOR_DISC_REASON_CODE
,      NON_LABOR_DISC_REASON_CODE
,      LONG_TASK_NAME
,      RETIREMENT_COST_FLAG
,      CINT_ELIGIBLE_FLAG
,      CINT_STOP_DATE
,      REVENUE_ACCRUAL_METHOD
,      INVOICE_METHOD
,      CUSTOMER_ID
,      GEN_ETC_SOURCE_CODE
,      BILL_SCHE_OVRD_FLAG
,      ADJ_ON_STD_INV
FROM PA.PA_TASKS;

Dependencies

[top of page]

PA.PA_TASKS does not reference any database object

PA.PA_TASKS is referenced by following:

PA: PA_TASKS#