[Home] [Help]
View: OKI_YOY_RENEWAL_AMT_V
| Product: | OKI - Contracts Intelligence (Obsolete) |
|---|
| Description: | Holds information about the value of renewed contracts on a historical basis. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT YOY.ID
, YOY.PERIOD_NAME
, YOY.PERIOD_SET_NAME
, YOY.PERIOD_TYPE
, YOY.AUTHORING_ORG_ID
, YOY.AUTHORING_ORG_NAME
, YOY.YEAR
, YOY.MONTH
, YOY.SCS_CODE
, YOY.BASE_CONTRACT_AMOUNT
, YOY.REQUEST_ID
, YOY.PROGRAM_APPLICATION_ID
, YOY.PROGRAM_ID
, YOY.PROGRAM_UPDATE_DATE
FROM OKI_YOY_RENEWAL_AMT YOY
Columns
| Name |
| ID |
| PERIOD_NAME |
| PERIOD_SET_NAME |
| PERIOD_TYPE |
| AUTHORING_ORG_ID |
| AUTHORING_ORG_NAME |
| YEAR |
| MONTH |
| SCS_CODE |
| BASE_CONTRACT_AMOUNT |
| REQUEST_ID |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |