BUSINESS_UNITDefault Value: AUC_HDR.BUSINESS_UNIT
AUC_IDDefault Value: AUC_HDR.AUC_ID
AUC_ROUNDAUC_VERSIONLINE_NBRDefault Value: %date
AUC_EVENT_EXT(SQL Table) |
Index Back |
|---|---|
Auction Event Extension HistUsed to store history of end date extensions for an event. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AUC_HDR.BUSINESS_UNIT |
| 2 | AUC_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Event ID
Default Value: AUC_HDR.AUC_ID |
| 3 | AUC_ROUND |
Number(5,0) | INTEGER NOT NULL | Event Round |
| 4 | AUC_VERSION |
Number(5,0) | INTEGER NOT NULL | Event Version |
| 5 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | AUC_ORIGINAL_ENDDT | DateTime(26) | TIMESTAMP | Original End Date |
| 7 | AUC_DTTM_FINISH | DateTime(26) | TIMESTAMP | Date Time Finish |
| 8 | OPRID_MODIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase. |
| 9 | CREATE_DATE | Date(10) | DATE |
Creation Date
Default Value: %date |