SS_EVT_TYPE_SVW(SQL View) |
Index Back |
---|---|
Sourcing Event Type XLAT |
SELECT B.FIELDVALUE , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'AUC_TYPE' AND %EffdtCheck(PSXLATITEM A, B, %CURRENTDATEIN) AND B.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | AUC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx |
2 | AUC_XLAT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Unit of Measure |