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

Product:	PSB - Public Sector Budgeting
Description:	Data extract definitions. All position related data are partitioned by data extract.
Implementation/DBA Data:	PSB.PSB_DATA_EXTRACTS

Primary Key: DATA_EXTRACTS_PK

DATA_EXTRACT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSB_DATA_EXTRACTS	GL_SETS_OF_BOOKS_11I	PSB_DATA_EXTRACTS.SET_OF_BOOKS_ID
PSB_DATA_EXTRACTS	PSB_BUDGET_GROUPS	PSB_DATA_EXTRACTS.BUDGET_GROUP_ID
PSB_ACCOUNT_POSITION_SETS	PSB_DATA_EXTRACTS	PSB_ACCOUNT_POSITION_SETS.DATA_EXTRACT_ID
PSB_ATTRIBUTE_VALUES_I	PSB_DATA_EXTRACTS	PSB_ATTRIBUTE_VALUES_I.DATA_EXTRACT_ID
PSB_BUDGET_POSITIONS	PSB_DATA_EXTRACTS	PSB_BUDGET_POSITIONS.DATA_EXTRACT_ID
PSB_BUDGET_WORKFLOW_RULES	PSB_DATA_EXTRACTS	PSB_BUDGET_WORKFLOW_RULES.DATA_EXTRACT_ID
PSB_COST_DISTRIBUTIONS_I	PSB_DATA_EXTRACTS	PSB_COST_DISTRIBUTIONS_I.DATA_EXTRACT_ID
PSB_EMPLOYEES_I	PSB_DATA_EXTRACTS	PSB_EMPLOYEES_I.DATA_EXTRACT_ID
PSB_EMPLOYEE_ASSIGNMENTS_I	PSB_DATA_EXTRACTS	PSB_EMPLOYEE_ASSIGNMENTS_I.DATA_EXTRACT_ID
PSB_PAY_ELEMENTS	PSB_DATA_EXTRACTS	PSB_PAY_ELEMENTS.DATA_EXTRACT_ID
PSB_POSITIONS	PSB_DATA_EXTRACTS	PSB_POSITIONS.DATA_EXTRACT_ID
PSB_POSITION_PAY_DISTRIBUTIONS	PSB_DATA_EXTRACTS	PSB_POSITION_PAY_DISTRIBUTIONS.DATA_EXTRACT_ID