RS_SCP_SUPPLY(SQL View) |
Index Back |
|---|---|
SCP HomePage Supply gridSCP - View for the Supply Forecast grid in SCP HomePage |
| SELECT A.OPRID ,A.FORECAST_ID_FRM ,B.FROM_MONTH_SCP ,B.FROM_YEAR ,B.TO_MONTH_SCP ,B.TO_YEAR ,B.FMS_OPRID ,A.DATETIME_STAMP FROM %Table(RS_SCP_HOMEPAGE) A , %Table(RS_FR_SUP_HDR) B WHERE A.FORECAST_TYPE = '1' AND A.FORECAST_ID_FRM = B.FORECAST_ID_SUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | FORECAST_ID_SUP | Character(15) | VARCHAR2(15) NOT NULL | Supply Forecast ID |
| 3 | FROM_MONTH_SCP | Character(2) | VARCHAR2(2) NOT NULL |
SCP- From Month
1=01 - January 10=10 - October 11=11 - November 12=12 - December 2=02 - February 3=03 - March 4=04 - April 5=05 - May 6=06 - June 7=07 - July 8=08 - August 9=09 - September |
| 4 | FROM_YEAR | Number(4,0) | SMALLINT NOT NULL | From Year |
| 5 | TO_MONTH_SCP | Character(2) | VARCHAR2(2) NOT NULL |
SCP- To Month
1=01 - January 10=10 - October 11=11 - November 12=12 - December 2=02 - February 3=03 - March 4=04 - April 5=05 - May 6=06 - June 7=07 - July 8=08 - August 9=09 - September |
| 6 | TO_YEAR | Number(4,0) | SMALLINT NOT NULL | To Year |
| 7 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 8 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |