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_PAYROLL_INTERFACE

Product:	PSP - Labor Distribution
Description:	Contains non-Oracle payroll sublines information to be imported to Labor Distribution
Implementation/DBA Data:	PSP.PSP_PAYROLL_INTERFACE

Primary Key: PSP_PAYROLL_INTERFACE_PK

BATCH_NAME
PAYROLL_INTERFACE_ID

Primary Key: PSP_PAYROLL_INTERFACE_U1

ASSIGNMENT_ID
PAYROLL_PERIOD_ID
ELEMENT_TYPE_ID
SUB_LINE_START_DATE
SUB_LINE_END_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PSP_PAYROLL_INTERFACE		PER_TIME_PERIODS	PSP_PAYROLL_INTERFACE.PAYROLL_PERIOD_ID
PSP_PAYROLL_INTERFACE		GL_SETS_OF_BOOKS	PSP_PAYROLL_INTERFACE.SET_OF_BOOKS_ID