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_PROJECT_TYPES_ALL

Product:	PA - Projects
Description:	Implementation-defined project classifications that supply default information and drive some project processing
Implementation/DBA Data:	PA.PA_PROJECT_TYPES_ALL

Primary Key: PA_PROJECT_TYPES_PK

PROJECT_TYPE
ORG_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_PROJECT_TYPES_ALL	PER_JOB_GROUPS	PA_PROJECT_TYPES_ALL.BILL_JOB_GROUP_ID
PA_PROJECT_TYPES_ALL	PA_INVOICE_FORMATS	PA_PROJECT_TYPES_ALL.LABOR_INVOICE_FORMAT_ID
PA_PROJECT_TYPES_ALL	PA_RESOURCE_LISTS_ALL_BG	PA_PROJECT_TYPES_ALL.DEFAULT_RESOURCE_LIST_ID
PA_PROJECT_TYPES_ALL	PA_RESOURCE_LISTS_ALL_BG	PA_PROJECT_TYPES_ALL.COST_BUDGET_RESOURCE_LIST_ID
PA_PROJECT_TYPES_ALL	PA_RESOURCE_LISTS_ALL_BG	PA_PROJECT_TYPES_ALL.REV_BUDGET_RESOURCE_LIST_ID
PA_PROJECT_TYPES_ALL	PA_BILLING_CYCLES	PA_PROJECT_TYPES_ALL.BILLING_CYCLE_ID
PA_PROJECT_TYPES_ALL	PER_JOB_GROUPS	PA_PROJECT_TYPES_ALL.BILL_JOB_GROUP_ID
PA_PROJECT_TYPES_ALL	PER_JOB_GROUPS	PA_PROJECT_TYPES_ALL.COST_JOB_GROUP_ID
PA_PROJECT_TYPES_ALL	PA_INVOICE_FORMATS	PA_PROJECT_TYPES_ALL.NON_LABOR_INVOICE_FORMAT_ID
PA_PROJECT_TYPES_ALL	PA_IND_RATE_SCHEDULES_ALL_BG	PA_PROJECT_TYPES_ALL.CINT_RATE_SCH_ID
PA_PROJECT_TYPES_ALL	PA_STD_BILL_RATE_SCHEDULES_ALL	PA_PROJECT_TYPES_ALL.LABOR_BILL_RATE_ORG_ID PA_PROJECT_TYPES_ALL.LABOR_STD_BILL_RATE_SCHDL PA_PROJECT_TYPES_ALL.ORG_ID
PA_PROJECT_TYPES_ALL	PA_STD_BILL_RATE_SCHEDULES_ALL	PA_PROJECT_TYPES_ALL.NON_LABOR_BILL_RATE_ORG_ID PA_PROJECT_TYPES_ALL.NON_LABOR_STD_BILL_RATE_SCHDL PA_PROJECT_TYPES_ALL.ORG_ID
PA_PROJECT_TYPES_ALL	PA_IND_RATE_SCHEDULES_ALL_BG	PA_PROJECT_TYPES_ALL.COST_IND_RATE_SCH_ID
PA_PROJECT_TYPES_ALL	PA_IND_RATE_SCHEDULES_ALL_BG	PA_PROJECT_TYPES_ALL.REV_IND_RATE_SCH_ID
PA_PROJECT_TYPES_ALL	PA_IND_RATE_SCHEDULES_ALL_BG	PA_PROJECT_TYPES_ALL.INV_IND_RATE_SCH_ID
PA_PROJECT_TYPES_ALL	PA_BUDGET_ENTRY_METHODS	PA_PROJECT_TYPES_ALL.REV_BUDGET_ENTRY_METHOD_CODE
PA_PROJECT_TYPES_ALL	PA_BUDGET_ENTRY_METHODS	PA_PROJECT_TYPES_ALL.COST_BUDGET_ENTRY_METHOD_CODE
PA_PROJECT_TYPES_ALL	PER_JOB_GROUPS	PA_PROJECT_TYPES_ALL.COST_JOB_GROUP_ID
PA_ALLOC_RUNS_ALL	PA_PROJECT_TYPES_ALL	PA_ALLOC_RUNS_ALL.PPL_PROJECT_TYPE PA_ALLOC_RUNS_ALL.PPL_ORG_ID
PA_BILLING_ASSIGNMENTS_ALL	PA_PROJECT_TYPES_ALL	PA_BILLING_ASSIGNMENTS_ALL.PROJECT_TYPE PA_BILLING_ASSIGNMENTS_ALL.ORG_ID
PA_EMPLOYEE_ACCUM_ALL	PA_PROJECT_TYPES_ALL	PA_EMPLOYEE_ACCUM_ALL.PROJECT_TYPE PA_EMPLOYEE_ACCUM_ALL.ORG_ID
PA_EMPLOYEE_ORG_ACCUM_ALL	PA_PROJECT_TYPES_ALL	PA_EMPLOYEE_ORG_ACCUM_ALL.PROJECT_TYPE PA_EMPLOYEE_ORG_ACCUM_ALL.ORG_ID
PA_PROJECTS_ALL	PA_PROJECT_TYPES_ALL	PA_PROJECTS_ALL.PROJECT_TYPE PA_PROJECTS_ALL.ORG_ID
PA_PROJ_TYPE_DISTRIBUTIONS_ALL	PA_PROJECT_TYPES_ALL	PA_PROJ_TYPE_DISTRIBUTIONS_ALL.PROJECT_TYPE PA_PROJ_TYPE_DISTRIBUTIONS_ALL.ORG_ID