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]

View: PSPBV_COSTED_PAYROLL_LINES

Product:	PSP - Labor Distribution
Description:	PSPBV_COSTED_PAYROLL_LINES displays information about the payroll lines imported from payroll systems.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PPL.PAYROLL_LINE_ID
, PPL.BALANCE_AMOUNT
, '_LA:PPL.DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, PPL.SET_OF_BOOKS_ID
, '_LA:PPL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PPL.EFFECTIVE_DATE
, PPL.CHECK_DATE
, PPL.EARNED_DATE
, PPL.COST_ALLOCATION_KEYFLEX_ID
, PPL.PAYROLL_CONTROL_ID
, PPL.ELEMENT_TYPE_ID
, PPL.ASSIGNMENT_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PPL.LAST_UPDATE_DATE
, PPL.LAST_UPDATED_BY
, PPL.CREATED_BY
, PPL.CREATION_DATE
FROM PSP_PAYROLL_LINES PPL
, GL_CODE_COMBINATIONS GCC
, PSP_EFFORT_REPORTS PER
, PER_ALL_PEOPLE_F PPF
WHERE PPL.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID WITH READ ONLY

Columns

Name
PAYROLL_LINE_ID
BALANCE_AMOUNT
"_LA:DEBIT_OR_CREDIT"
SET_OF_BOOKS_ID
"_LA:PAYROLL_LINE_STATUS_FLAG"
PAYROLL_LINE_EFFECTIVE_DATE
PAYROLL_CHECK_DATE
PAY_AMOUNT_EARNED_DATE
COST_ALLOCATION_KEYFLEX_NAME
PAYROLL_CONTROL_ID
ELEMENT_TYPE_ID
ASSIGNMENT_ID
"_KF:ACCOUNT_ID"
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE