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_TRANSACTION_CONTROLS

Product:	PA - Projects
Description:	Transaction controls of chargeable and billable status for projects and tasks
Implementation/DBA Data:	PA.PA_TRANSACTION_CONTROLS

Primary Key: PA_TRANSACTION_CONTROLS_PK

PROJECT_ID
TASK_ID
EXPENDITURE_CATEGORY
START_DATE_ACTIVE
PERSON_ID
EXPENDITURE_TYPE
NON_LABOR_RESOURCE

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_TRANSACTION_CONTROLS	PA_PROJECTS_ALL	PA_TRANSACTION_CONTROLS.PROJECT_ID
PA_TRANSACTION_CONTROLS	PA_TASKS	PA_TRANSACTION_CONTROLS.TASK_ID
PA_TRANSACTION_CONTROLS	PA_EXPENDITURE_CATEGORIES	PA_TRANSACTION_CONTROLS.EXPENDITURE_CATEGORY
PA_TRANSACTION_CONTROLS	PA_EXPENDITURE_TYPES	PA_TRANSACTION_CONTROLS.EXPENDITURE_TYPE
PA_TRANSACTION_CONTROLS	PA_NON_LABOR_RESOURCES	PA_TRANSACTION_CONTROLS.NON_LABOR_RESOURCE