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_PAYROLL_SUB_LINES

Product:	PSP - Labor Distribution
Description:	PSPBV_PAYROLL_SUB_LINES displays information about Oracle sublines or non-Oracle payroll sublines.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PPS.PAYROLL_SUB_LINE_ID
, PPS.SUB_LINE_START_DATE
, PPS.SUB_LINE_END_DATE
, PPS.ASSIGNMENT_END_DATE
, '_LA:REASON_CODE:PSP_LOOKUPS:PSP_SUBLINE_REASONS:MEANING'
, PPS.PAY_AMOUNT
, PPS.DAILY_RATE
, PPS.SALARY_USED
, PPS.CURRENT_SALARY
, PPS.FTE
, PPS.EMPLOYMENT_BEGIN_DATE
, PPS.EMPLOYMENT_END_DATE
, PPS.EMPLOYEE_STATUS_INACTIVE_DATE
, PPS.EMPLOYEE_STATUS_ACTIVE_DATE
, PPS.ASSIGNMENT_BEGIN_DATE
, PPS.ORGANIZATION_ID
, PPS.JOB_ID
, PPS.POSITION_ID
, PPS.PAYROLL_LINE_ID
, PPS.LAST_UPDATE_DATE
, PPS.LAST_UPDATED_BY
, PPS.CREATED_BY
, PPS.CREATION_DATE
FROM PSP_PAYROLL_SUB_LINES PPS
WHERE '_SEC:PPS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
SUBLINE_ID
SUBLINE_START_DATE
SUBLINE_END_DATE
ASSIGNMENT_END_DATE
"_LA:REASON_CODE"
SUBLINE_AMOUNT
SUBLINE_DAILY_RATE
SUBLINE_SALARY_AMOUNT
CURRENT_SALARY
FULL_TIME_EQUIVALENT
EMPLOYMENT_BEGIN_DATE
EMPLOYMENT_END_DATE
EMPLOYMENT_STATUS_INACTIVE_DT
EMPLOYMENT_STATUS_ACTIVE_DATE
ASSIGNMENT_BEGIN_DATE
ORGANIZATION_ID
JOB_ID
POSITION_ID
PAYROLL_LINE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE