SS_DATE_SVW(SQL View) |
Index Back |
|---|---|
PTSF Date View - Sourcing |
| SELECT A.BUSINESS_UNIT ,A.AUC_ID ,A.AUC_ROUND ,A.AUC_VERSION , %Substring(%Cast(A.AUC_DTTM_START, DateTime, Character), 6, 2) , %Substring(%Cast(A.AUC_DTTM_START, DateTime, Character), 6, 2) ,%DatePart(A.AUC_DTTM_START) ,%DatePart(A.AUC_DTTM_FINISH) ,A.BLIND_FLG ,A.OPRID_ENTERED_BY FROM PS_AUC_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | AUC_ID | Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 3 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 4 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 5 | 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 |
| 6 | SES_MONTH2 | 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 |
| 7 | AUC_START_DATE | Date(10) | DATE | Start Date |
| 8 | AUC_END_DATE | Date(10) | DATE | End Date |
| 9 | BLIND_FLAG | Character(3) | VARCHAR2(3) NOT NULL |
Sealed Event
N=No Y=Yes |
| 10 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |