[Home] [Help]
View: PSPBV_EFFORT_REPORTS
| Product: | PSP - Labor Distribution |
|---|
| Description: | PSPBV_EFFORT_REPORTS displays the total effort of an employee in a period distributed between the tasks and projects. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PER.EFFORT_REPORT_ID
, PER.VERSION_NUM
, PER.VERSION_CREATION_DATE
, PER.MESSAGE_ID
, PER.REPORT_COMMENT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PER.TEMPLATE_ID
, PER.PREV_EFFORT_REPORT_ID
, PER.PERSON_ID
, PER.BUSINESS_GROUP_ID
, PER.SET_OF_BOOKS_ID
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATED_BY
, PER.CREATION_DATE
FROM PSP_EFFORT_REPORTS PER WITH READ ONLY
Columns
| Name |
| EFFORT_REPORT_ID |
| VERSION_NUMBER |
| VERSION_CREATION_DATE |
| MESSAGE_ID |
| RETURN_WITH_COMMENTS |
| "_LA:STATUS_OF_EFFORT_REPORT" |
| TEMPLATE_ID |
| PREVIOUS_EFFORT_REPORT_ID |
| PERSON_ID |
| BUSINESS_GROUP_ID |
| SET_OF_BOOKS_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |