CONTRACT_NUM01=01: January
02=02: February
03=03: March
04=04: April
05=05: May
06=06: June
07=07: July
08=08: August
09=09: September
10=10: October
11=11: November
12=12: December
GM_GBL_SRCH_SVW(SQL View) |
Index Back |
|---|---|
Grants Search ViewGrants Global Search View for PTSF Document date |
| SELECT A.CONTRACT_NUM , %Substring(%Cast(A.BEGIN_DT, Date, Character), 6, 2) FROM PS_GM_AWARD A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | SES_MONTH | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01: January 02=02: February 03=03: March 04=04: April 05=05: May 06=06: June 07=07: July 08=08: August 09=09: September 10=10: October 11=11: November 12=12: December |