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: PSP.PSP_PAYROLL_LINES#

Source

View Text - Preformatted


select PAYROLL_LINE_ID PAYROLL_LINE_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PERSON_ID PERSON_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, PAY_AMOUNT PAY_AMOUNT, STATUS_CODE STATUS_CODE, PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID, CHECK_DATE CHECK_DATE, EARNED_DATE EARNED_DATE, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID, BALANCE_AMOUNT BALANCE_AMOUNT, DR_CR_FLAG DR_CR_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, EFFECTIVE_DATE EFFECTIVE_DATE, COST_ID COST_ID, ACCOUNTING_DATE ACCOUNTING_DATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, PAYROLL_ACTION_TYPE PAYROLL_ACTION_TYPE, OR_GL_CODE_COMBINATION_ID OR_GL_CODE_COMBINATION_ID, OR_PROJECT_ID OR_PROJECT_ID, OR_TASK_ID OR_TASK_ID, OR_AWARD_ID OR_AWARD_ID, OR_EXPENDITURE_ORG_ID OR_EXPENDITURE_ORG_ID, OR_EXPENDITURE_TYPE OR_EXPENDITURE_TYPE from "PSP"."PSP_PAYROLL_LINES"

View Text - HTML Formatted

SELECT PAYROLL_LINE_ID PAYROLL_LINE_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PERSON_ID PERSON_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PAY_AMOUNT PAY_AMOUNT
, STATUS_CODE STATUS_CODE
, PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID
, CHECK_DATE CHECK_DATE
, EARNED_DATE EARNED_DATE
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID
, BALANCE_AMOUNT BALANCE_AMOUNT
, DR_CR_FLAG DR_CR_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, COST_ID COST_ID
, ACCOUNTING_DATE ACCOUNTING_DATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, PAYROLL_ACTION_TYPE PAYROLL_ACTION_TYPE
, OR_GL_CODE_COMBINATION_ID OR_GL_CODE_COMBINATION_ID
, OR_PROJECT_ID OR_PROJECT_ID
, OR_TASK_ID OR_TASK_ID
, OR_AWARD_ID OR_AWARD_ID
, OR_EXPENDITURE_ORG_ID OR_EXPENDITURE_ORG_ID
, OR_EXPENDITURE_TYPE OR_EXPENDITURE_TYPE
FROM "PSP"."PSP_PAYROLL_LINES"