[Home] [Help]
View: PSPFV_EFFORT_REPORT_PERIODS
Product: | PSP - Labor Distribution |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PER.EFFORT_REPORT_PERIOD_NAME
, PER.EFFORT_REPORT_PERIOD_TYPE
, PER.EFFORT_REPORT_PERIOD_YEAR
, PER.DESCRIPTION
, PER.EFFORT_REPORT_PERIOD_NUMBER
, PER.START_DATE_ACTIVE
, PER.END_DATE_ACTIVE
, PER.EFFORT_REPORT_PERIOD_PREFIX
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATED_BY
, PER.CREATION_DATE
FROM PSP_EFFORT_REPORT_PERIODS PER WITH READ ONLY
Columns
Name |
EFFORT_REPORT_PERIOD_NAME |
EFFORT_REPORT_PERIOD_TYPE |
EFFORT_REPORT_PERIOD_YEAR |
DESCRIPTION_OF_PERIOD_NAME |
EFFORT_REPORT_PERIOD_NUMBER |
START_DATE_OF_EFFORT_PERIOD |
END_DATE_OF_EFFORT_PERIOD |
EFFORT_REPORT_PERIOD_PREFIX |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |