[Home] [Help]
View: PSPBV_SCHEDULE_HIERARCHIES
Product: | PSP - Labor Distribution |
Description: | PSPBV_SCHEDULE_HIERARCHIES displays information about the schedule hierarchy level for an employee assignment. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PSH.SCHEDULE_HIERARCHY_ID
, PSH.SCHEDULING_TYPES_CODE
, PSH.ASSIGNMENT_ID
, PSH.ELEMENT_GROUP_ID
, PSH.ELEMENT_TYPE_ID
, PSH.BUSINESS_GROUP_ID
, PSH.SET_OF_BOOKS_ID
, PSH.LAST_UPDATE_DATE
, PSH.LAST_UPDATED_BY
, PSH.CREATED_BY
, PSH.CREATION_DATE
FROM PSP_SCHEDULE_HIERARCHY PSH WITH READ ONLY
Columns
Name |
SCHEDULE_HIERARCHY_ID |
SCHEDULING_TYPES_CODE |
ASSIGNMENT_ID |
ELEMENT_GROUP_ID |
ELEMENT_TYPE_ID |
BUSINESS_GROUP_ID |
SET_OF_BOOKS_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |