BID_FCTR_CNS_VW(SQL View) |
Index Back |
---|---|
Eligible bid factors for Const |
SELECT A.SETID AS BID_FACTOR_SETID , A.BID_FACTOR_CD , A.BID_FACTOR_TYPE , A.DESCR , A.AUC_MULTI_SEL_FLG FROM PS_BID_FACTOR_HDR A WHERE (A.BID_FACTOR_TYPE <> 'T' AND A.BID_FACTOR_TYPE <> 'S') AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_BID_FACTOR_HDR B WHERE B.SETID = A.SETID AND B.BID_FACTOR_CD = A.BID_FACTOR_CD AND B.BID_FACTOR_TYPE = A.BID_FACTOR_TYPE AND B.EFFDT <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BID_FACTOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Bid Factor Setid |
2 | BID_FACTOR_CD | Character(18) | VARCHAR2(18) NOT NULL | Bid Factor Code |
3 | BID_FACTOR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment C=Monetary D=Date L=List N=Numeric S=Separator T=Text Y=Yes/No |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | AUC_MULTI_SEL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Multiple Selections |