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_REP_DA_GRP1_V

Product:	PSP - Labor Distribution
Description:	Based on PSP_REP_DIST_PRJ_V and used in the Distribution History of Employees by Award report
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.SUSPENSE_ORG_ACCOUNT_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'SUSP' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_ORGANIZATION_ACCOUNTS B
WHERE A.SUSPENSE_ORG_ACCOUNT_ID = B.ORGANIZATION_ACCOUNT_ID UNION ALL SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.DEFAULT_ORG_ACCOUNT_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'DEF' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_ORGANIZATION_ACCOUNTS B
WHERE A.DEFAULT_ORG_ACCOUNT_ID = B.ORGANIZATION_ACCOUNT_ID UNION ALL SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.ELEMENT_ACCOUNT_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'EL_TYPE' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_ELEMENT_TYPE_ACCOUNTS B
WHERE A.ELEMENT_ACCOUNT_ID = B.ELEMENT_ACCOUNT_ID UNION ALL SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.ORG_SCHEDULE_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'LABOR' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_DEFAULT_LABOR_SCHEDULES B
WHERE A.ORG_SCHEDULE_ID = B.ORG_SCHEDULE_ID UNION ALL SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, A.PAYROLL_ID
, A.DISTRIBUTION_AMOUNT
, A.EFFECTIVE_DATE
, A.PERIOD_NAME
, A.SCHEDULE_LINE_ID ACCOUNT_ID
, B.AWARD_ID
, B.EXPENDITURE_TYPE
, 'SCH_LINE' AWARD_SOURCE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_REP_DIST_PRJ_V A
, PSP_SCHEDULE_LINES B
WHERE A.SCHEDULE_LINE_ID = B.SCHEDULE_LINE_ID

Columns

Name
PERSON_ID
ASSIGNMENT_ID
ELEMENT_TYPE_ID
TIME_PERIOD_ID
PAYROLL_ID
DISTRIBUTION_AMOUNT
EFFECTIVE_DATE
PERIOD_NAME
ACCOUNT_ID
AWARD_ID
EXPENDITURE_TYPE
AWARD_SOURCE
BUSINESS_GROUP_ID
SET_OF_BOOKS_ID