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.

[Home] [Help]

Table: PA_TASKS

Product:	PA - Projects
Description:	User-defined subdivisions of project work
Implementation/DBA Data:	PA.PA_TASKS

Primary Key: PA_TASKS_PK

TASK_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_TASKS	PA_LABOR_COST_MULTIPLIERS	PA_TASKS.LABOR_COST_MULTIPLIER_NAME
PA_TASKS	RA_ADDRESSES_ALL	PA_TASKS.ADDRESS_ID
PA_TASKS	PA_IND_RATE_SCHEDULES_ALL_BG	PA_TASKS.COST_IND_RATE_SCH_ID
PA_TASKS	PA_IND_RATE_SCHEDULES_ALL_BG	PA_TASKS.INV_IND_RATE_SCH_ID
PA_TASKS	PA_IND_RATE_SCHEDULES_ALL_BG	PA_TASKS.REV_IND_RATE_SCH_ID
PA_TASKS	HR_ALL_ORGANIZATION_UNITS	PA_TASKS.CARRYING_OUT_ORGANIZATION_ID
PA_TASKS	PA_PROJECTS_ALL	PA_TASKS.PROJECT_ID
PA_TASKS	HR_ALL_ORGANIZATION_UNITS	PA_TASKS.CARRYING_OUT_ORGANIZATION_ID
PA_TASKS	PA_CC_TP_SCHEDULES_BG	PA_TASKS.LABOR_TP_SCHEDULE_ID
PA_TASKS	PA_CC_TP_SCHEDULES_BG	PA_TASKS.NL_TP_SCHEDULE_ID
PA_TASKS	PA_WORK_TYPES_B	PA_TASKS.WORK_TYPE_ID
PA_TASKS	HZ_CUST_ACCT_SITES_ALL	PA_TASKS.ADDRESS_ID
PA_TASKS	PA_TASKS	PA_TASKS.PARENT_TASK_ID
PA_TASKS	PA_TASKS	PA_TASKS.TOP_TASK_ID
AHL_VISIT_TASKS_B	PA_TASKS	AHL_VISIT_TASKS_B.PROJECT_TASK_ID
AMW_AP_TASKS	PA_TASKS	AMW_AP_TASKS.TASK_ID
AP_DISTRIBUTION_SET_LINES_ALL	PA_TASKS	AP_DISTRIBUTION_SET_LINES_ALL.TASK_ID
%	PA_TASKS
AP_EXPENSE_REPORT_LINES_ALL	PA_TASKS	AP_EXPENSE_REPORT_LINES_ALL.TASK_ID
AP_EXP_REPORT_DISTS_ALL	PA_TASKS	AP_EXP_REPORT_DISTS_ALL.TASK_ID
AP_INVOICES_ALL	PA_TASKS	AP_INVOICES_ALL.TASK_ID
AP_INVOICE_DISTRIBUTIONS_ALL	PA_TASKS	AP_INVOICE_DISTRIBUTIONS_ALL.TASK_ID
%	PA_TASKS
CSI_ITEM_INSTANCES	PA_TASKS	CSI_ITEM_INSTANCES.PA_PROJECT_TASK_ID
FA_ASSET_INVOICES	PA_TASKS	FA_ASSET_INVOICES.TASK_ID
FA_DELETED_MASS_ADDITIONS	PA_TASKS	FA_DELETED_MASS_ADDITIONS.TASK_ID
%	PA_TASKS
FA_MASS_ADDITIONS	PA_TASKS	FA_MASS_ADDITIONS.TASK_ID
FA_MASS_RETIREMENTS	PA_TASKS	FA_MASS_RETIREMENTS.TASK_ID
FA_MC_ASSET_INVOICES	PA_TASKS	FA_MC_ASSET_INVOICES.TASK_ID
GMS_BALANCES	PA_TASKS	GMS_BALANCES.TASK_ID
GMS_BC_PACKETS	PA_TASKS	GMS_BC_PACKETS.TASK_ID
GMS_BC_PACKETS	PA_TASKS	GMS_BC_PACKETS.TOP_TASK_ID
GMS_OVERRIDE_SCHEDULES	PA_TASKS	GMS_OVERRIDE_SCHEDULES.TASK_ID
GMS_RESOURCE_ASSIGNMENTS	PA_TASKS	GMS_RESOURCE_ASSIGNMENTS.TASK_ID
IGC_CC_ACCT_LINES	PA_TASKS	IGC_CC_ACCT_LINES.TASK_ID
IGW_BUDGET_DETAILS	PA_TASKS	IGW_BUDGET_DETAILS.TASK_ID
JMF_SUBCONTRACT_ORDERS	PA_TASKS	JMF_SUBCONTRACT_ORDERS.TASK_ID
IGC_CC_ARC_ACCT_LINES	PA_TASKS	IGC_CC_ARC_ACCT_LINES.TASK_ID
IGC_CC_ACCT_LINES_INTERFACE	PA_TASKS	IGC_CC_ACCT_LINES_INTERFACE.TASK_ID
OKE_K_BILLING_EVENTS	PA_TASKS	OKE_K_BILLING_EVENTS.BILL_TASK_ID
OKE_K_COMMUNICATIONS	PA_TASKS	OKE_K_COMMUNICATIONS.TASK_ID
OKE_K_DELIVERABLES_B	PA_TASKS	OKE_K_DELIVERABLES_B.TASK_ID
OKE_K_FUND_ALLOCATIONS	PA_TASKS	OKE_K_FUND_ALLOCATIONS.TASK_ID
OKE_K_LINES	PA_TASKS	OKE_K_LINES.TASK_ID
OKE_K_LINES_H	PA_TASKS	OKE_K_LINES_H.TASK_ID
PA_ALLOC_EXCEPTIONS	PA_TASKS	PA_ALLOC_EXCEPTIONS.TASK_ID
PA_ALLOC_MISSING_COSTS	PA_TASKS	PA_ALLOC_MISSING_COSTS.TASK_ID
PA_ALLOC_RULES_ALL	PA_TASKS	PA_ALLOC_RULES_ALL.OFFSET_TASK_ID
PA_ALLOC_RUN_BASIS_DET	PA_TASKS	PA_ALLOC_RUN_BASIS_DET.TASK_ID
PA_ALLOC_RUN_SOURCE_DET	PA_TASKS	PA_ALLOC_RUN_SOURCE_DET.TASK_ID
PA_ALLOC_SOURCE_LINES	PA_TASKS	PA_ALLOC_SOURCE_LINES.TASK_ID
PA_ALLOC_TARGET_LINES	PA_TASKS	PA_ALLOC_TARGET_LINES.TASK_ID
PA_ALLOC_TXN_DETAILS	PA_TASKS	PA_ALLOC_TXN_DETAILS.TASK_ID
PA_ALLOC_TXN_DETAILS	PA_TASKS	PA_ALLOC_TXN_DETAILS.CINT_SOURCE_TASK_ID
PA_BC_BALANCES	PA_TASKS	PA_BC_BALANCES.TASK_ID
PA_BC_COMMITMENTS_ALL	PA_TASKS	PA_BC_COMMITMENTS_ALL.TOP_TASK_ID
PA_BC_COMMITMENTS_ALL	PA_TASKS	PA_BC_COMMITMENTS_ALL.TASK_ID
PA_BC_PACKETS	PA_TASKS	PA_BC_PACKETS.TASK_ID
PA_BILLING_ASSIGNMENTS_ALL	PA_TASKS	PA_BILLING_ASSIGNMENTS_ALL.TOP_TASK_ID
PA_BILLING_MESSAGES	PA_TASKS	PA_BILLING_MESSAGES.TASK_ID
PA_BUDGETARY_CONTROLS	PA_TASKS	PA_BUDGETARY_CONTROLS.TASK_ID
PA_BURDEN_COST_MULTIPLIERS	PA_TASKS	PA_BURDEN_COST_MULTIPLIERS.TASK_ID
PA_CC_DIST_LINES_ALL	PA_TASKS	PA_CC_DIST_LINES_ALL.TASK_ID
PA_COMPENSATION_RULE_SETS	PA_TASKS	PA_COMPENSATION_RULE_SETS.TASK_ID
PA_COMP_RULE_OT_DEFAULTS_ALL	PA_TASKS	PA_COMP_RULE_OT_DEFAULTS_ALL.TASK_ID
PA_COST_DISTRIBUTION_LINES_ALL	PA_TASKS	PA_COST_DISTRIBUTION_LINES_ALL.TASK_ID
PA_CREDIT_RECEIVERS	PA_TASKS	PA_CREDIT_RECEIVERS.TASK_ID
PA_DRAFT_INVOICE_DETAILS_ALL	PA_TASKS	PA_DRAFT_INVOICE_DETAILS_ALL.CC_TAX_TASK_ID
PA_DRAFT_INVOICE_ITEMS	PA_TASKS	PA_DRAFT_INVOICE_ITEMS.TASK_ID
PA_DRAFT_INVOICE_ITEMS	PA_TASKS	PA_DRAFT_INVOICE_ITEMS.CC_TAX_TASK_ID
PA_DRAFT_REVENUE_ITEMS	PA_TASKS	PA_DRAFT_REVENUE_ITEMS.TASK_ID
PA_EARNED_VALUES	PA_TASKS	PA_EARNED_VALUES.TASK_ID
PA_EMP_BILL_RATE_OVERRIDES	PA_TASKS	PA_EMP_BILL_RATE_OVERRIDES.TASK_ID
PA_EVENTS	PA_TASKS	PA_EVENTS.TASK_ID
PA_EXPENDITURE_ITEMS_ALL	PA_TASKS	PA_EXPENDITURE_ITEMS_ALL.TASK_ID
PA_EXPEND_ALIASES	PA_TASKS	PA_EXPEND_ALIASES.TASK_ID
PA_FIN_PLAN_ADJ_LINES	PA_TASKS	PA_FIN_PLAN_ADJ_LINES.TASK_ID
PA_FP_ADJ_ELEMENTS	PA_TASKS	PA_FP_ADJ_ELEMENTS.TASK_ID
PA_FP_ELEMENTS	PA_TASKS	PA_FP_ELEMENTS.TASK_ID
PA_FP_ELEMENTS	PA_TASKS	PA_FP_ELEMENTS.TOP_TASK_ID
PA_FP_EXCLUDED_ELEMENTS	PA_TASKS	PA_FP_EXCLUDED_ELEMENTS.TASK_ID
PA_IND_RATE_SCHEDULES_ALL_BG	PA_TASKS	PA_IND_RATE_SCHEDULES_ALL_BG.TASK_ID
PA_JOB_ASSIGNMENT_OVERRIDES	PA_TASKS	PA_JOB_ASSIGNMENT_OVERRIDES.TASK_ID
PA_JOB_BILL_RATE_OVERRIDES	PA_TASKS	PA_JOB_BILL_RATE_OVERRIDES.TASK_ID
PA_JOB_BILL_TITLE_OVERRIDES	PA_TASKS	PA_JOB_BILL_TITLE_OVERRIDES.TASK_ID
PA_LABOR_MULTIPLIERS	PA_TASKS	PA_LABOR_MULTIPLIERS.TASK_ID
PA_MASS_UPDATE_DETAILS	PA_TASKS	PA_MASS_UPDATE_DETAILS.TASK_ID
PA_MC_EVENTS	PA_TASKS	PA_MC_EVENTS.TASK_ID
PA_NL_BILL_RATE_OVERRIDES	PA_TASKS	PA_NL_BILL_RATE_OVERRIDES.TASK_ID
PA_OBJECTS	PA_TASKS	PA_OBJECTS.TASK_ID
PA_ORG_FCST_ELEMENTS	PA_TASKS	PA_ORG_FCST_ELEMENTS.TASK_ID
PA_ORG_FORECAST_LINES	PA_TASKS	PA_ORG_FORECAST_LINES.TASK_ID
PA_ORG_LABOR_SCH_RULE	PA_TASKS	PA_ORG_LABOR_SCH_RULE.OVERTIME_TASK_ID
PA_PERCENT_COMPLETES	PA_TASKS	PA_PERCENT_COMPLETES.TASK_ID
PA_PROJECT_ACCUM_HEADERS	PA_TASKS	PA_PROJECT_ACCUM_HEADERS.TASK_ID
PA_PROJECT_ASSET_ASSIGNMENTS	PA_TASKS	PA_PROJECT_ASSET_ASSIGNMENTS.TASK_ID
PA_PROJECT_ASSET_LINES_ALL	PA_TASKS	PA_PROJECT_ASSET_LINES_ALL.TASK_ID
PA_PROJECT_EVENT_ACCUM	PA_TASKS	PA_PROJECT_EVENT_ACCUM.TASK_ID
PA_PROJECT_EXP_ITEM_ACCUM	PA_TASKS	PA_PROJECT_EXP_ITEM_ACCUM.TASK_ID
PA_PROJECT_FUNDINGS	PA_TASKS	PA_PROJECT_FUNDINGS.TASK_ID
PA_PROJECT_RETENTIONS	PA_TASKS	PA_PROJECT_RETENTIONS.TASK_ID
PA_PROJ_RETN_BILL_RULES	PA_TASKS	PA_PROJ_RETN_BILL_RULES.TASK_ID
PA_PROJ_RETN_RULES	PA_TASKS	PA_PROJ_RETN_RULES.TASK_ID
PA_RESOURCE_ASSIGNMENTS	PA_TASKS	PA_RESOURCE_ASSIGNMENTS.TASK_ID
PA_SUBBUDGETS	PA_TASKS	PA_SUBBUDGETS.TASK_ID
PA_SUMMARY_PROJECT_FUNDINGS	PA_TASKS	PA_SUMMARY_PROJECT_FUNDINGS.TASK_ID
PA_SUMMARY_PROJECT_RETN	PA_TASKS	PA_SUMMARY_PROJECT_RETN.TASK_ID
PA_TASKS	PA_TASKS	PA_TASKS.PARENT_TASK_ID
PA_TASKS	PA_TASKS	PA_TASKS.TOP_TASK_ID
PA_TRANSACTION_CONTROLS	PA_TASKS	PA_TRANSACTION_CONTROLS.TASK_ID
PA_TRANSACTION_INTERFACE_ALL	PA_TASKS	PA_TRANSACTION_INTERFACE_ALL.TASK_ID
PA_TXN_ACCUM_DETAILS	PA_TASKS	PA_TXN_ACCUM_DETAILS.TASK_ID
PA_TXN_INTERFACE_AUDIT_AR	PA_TASKS	PA_TXN_INTERFACE_AUDIT_AR.TASK_ID
PA_TXN_INTERFACE_AUDIT_ALL	PA_TASKS	PA_TXN_INTERFACE_AUDIT_ALL.TASK_ID
PA_BC_BALANCES	PA_TASKS	PA_BC_BALANCES.PTK_TASK_ID
PA_BUDGETARY_CONTROLS	PA_TASKS	PA_BUDGETARY_CONTROLS.PTK_TASK_ID
PA_COMP_RULE_OT_DEFAULTS_ALL	PA_TASKS	PA_COMP_RULE_OT_DEFAULTS_ALL.TASK_ID
PJM_BORROW_PAYBACKS	PA_TASKS	PJM_BORROW_PAYBACKS.BORROW_TASK_ID
PJM_BORROW_PAYBACKS	PA_TASKS	PJM_BORROW_PAYBACKS.LENDING_TASK_ID
PJM_BORROW_TRANSACTIONS	PA_TASKS	PJM_BORROW_TRANSACTIONS.BORROW_TASK_ID
PJM_BORROW_TRANSACTIONS	PA_TASKS	PJM_BORROW_TRANSACTIONS.LENDING_TASK_ID
PJM_DEFAULT_TASKS	PA_TASKS	PJM_DEFAULT_TASKS.TASK_ID
PJM_TASK_WIP_ACCT_CLASSES	PA_TASKS	PJM_TASK_WIP_ACCT_CLASSES.TASK_ID
PN_SPACE_ASSIGN_CUST_ALL	PA_TASKS	PN_SPACE_ASSIGN_CUST_ALL.TASK_ID
PN_SPACE_ASSIGN_EMP_ALL	PA_TASKS	PN_SPACE_ASSIGN_EMP_ALL.TASK_ID
PON_AUCTION_ITEM_PRICES_ALL	PA_TASKS	PON_AUCTION_ITEM_PRICES_ALL.PROJECT_TASK_ID
PON_AUC_PAYMENTS_SHIPMENTS	PA_TASKS	PON_AUC_PAYMENTS_SHIPMENTS.PROJECT_TASK_ID
PON_ITEM_PRICES_INTERFACE	PA_TASKS	PON_ITEM_PRICES_INTERFACE.PROJECT_TASK_ID
PO_DISTRIBUTIONS_DRAFT_ALL	PA_TASKS	PO_DISTRIBUTIONS_DRAFT_ALL.TASK_ID
PO_DISTRIBUTIONS_ALL	PA_TASKS	PO_DISTRIBUTIONS_ALL.TASK_ID
PO_REQUISITIONS_INTERFACE_ALL	PA_TASKS	PO_REQUISITIONS_INTERFACE_ALL.TASK_ID
PO_REQ_DISTRIBUTIONS_ALL	PA_TASKS	PO_REQ_DISTRIBUTIONS_ALL.TASK_ID
PSP_ADJUSTMENT_LINES	PA_TASKS	PSP_ADJUSTMENT_LINES.TASK_ID
PSP_ADJUSTMENT_LINES_HISTORY	PA_TASKS	PSP_ADJUSTMENT_LINES_HISTORY.TASK_ID
PSP_DEFAULT_LABOR_SCHEDULES	PA_TASKS	PSP_DEFAULT_LABOR_SCHEDULES.TASK_ID
PSP_DISTRIBUTION_INTERFACE	PA_TASKS	PSP_DISTRIBUTION_INTERFACE.TASK_ID
PSP_EFFORT_REPORT_DETAILS	PA_TASKS	PSP_EFFORT_REPORT_DETAILS.TASK_ID
PSP_EFFORT_REPORT_TEMPLATES	PA_TASKS	PSP_EFFORT_REPORT_TEMPLATES.TASK_ID
PSP_ELEMENT_TYPE_ACCOUNTS	PA_TASKS	PSP_ELEMENT_TYPE_ACCOUNTS.TASK_ID
PSP_ORGANIZATION_ACCOUNTS	PA_TASKS	PSP_ORGANIZATION_ACCOUNTS.TASK_ID
PSP_PRE_GEN_DIST_LINES	PA_TASKS	PSP_PRE_GEN_DIST_LINES.TASK_ID
PSP_PRE_GEN_DIST_LINES_HISTORY	PA_TASKS	PSP_PRE_GEN_DIST_LINES_HISTORY.TASK_ID
PSP_SCHEDULE_LINES	PA_TASKS	PSP_SCHEDULE_LINES.TASK_ID
PSP_SUMMARY_LINES	PA_TASKS	PSP_SUMMARY_LINES.TASK_ID
ZX_REC_NREC_DIST	PA_TASKS	ZX_REC_NREC_DIST.TASK_ID