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: PSP_ORGANIZATION_ACCOUNTS

Product:	PSP - Labor Distribution
Description:	Stores default and suspense accounts for organizations
Implementation/DBA Data:	PSP.PSP_ORGANIZATION_ACCOUNTS

Primary Key: PSP_ORGANIZATION_ACCOUNTS_PK

ORGANIZATION_ACCOUNT_ID

Primary Key: PSP_ORGANIZATION_ACCOUNTS_U1

ORGANIZATION_ID
ACCOUNT_TYPE_CODE
START_DATE_ACTIVE
GL_CODE_COMBINATION_ID
PROJECT_ID
EXPENDITURE_ORGANIZATION_ID
EXPENDITURE_TYPE
TASK_ID
AWARD_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSP_ORGANIZATION_ACCOUNTS	HR_ALL_ORGANIZATION_UNITS	PSP_ORGANIZATION_ACCOUNTS.ORGANIZATION_ID
PSP_ORGANIZATION_ACCOUNTS	GL_CODE_COMBINATIONS	PSP_ORGANIZATION_ACCOUNTS.GL_CODE_COMBINATION_ID
PSP_ORGANIZATION_ACCOUNTS	PA_PROJECTS_ALL	PSP_ORGANIZATION_ACCOUNTS.PROJECT_ID
PSP_ORGANIZATION_ACCOUNTS	PA_EXPENDITURE_TYPES	PSP_ORGANIZATION_ACCOUNTS.EXPENDITURE_TYPE
PSP_ORGANIZATION_ACCOUNTS	PA_TASKS	PSP_ORGANIZATION_ACCOUNTS.TASK_ID
PSP_ORGANIZATION_ACCOUNTS	GL_SETS_OF_BOOKS	PSP_ORGANIZATION_ACCOUNTS.SET_OF_BOOKS_ID
PSP_ADJUSTMENT_LINES	PSP_ORGANIZATION_ACCOUNTS	PSP_ADJUSTMENT_LINES.SUSPENSE_ORG_ACCOUNT_ID
PSP_ADJUSTMENT_LINES_HISTORY	PSP_ORGANIZATION_ACCOUNTS	PSP_ADJUSTMENT_LINES_HISTORY.SUSPENSE_ORG_ACCOUNT_ID
PSP_PRE_GEN_DIST_LINES	PSP_ORGANIZATION_ACCOUNTS	PSP_PRE_GEN_DIST_LINES.SUSPENSE_ORG_ACCOUNT_ID
PSP_PRE_GEN_DIST_LINES_HISTORY	PSP_ORGANIZATION_ACCOUNTS	PSP_PRE_GEN_DIST_LINES_HISTORY.SUSPENSE_ORG_ACCOUNT_ID