AUC_BDR_CNTCT(SQL View) |
Index Back |
|---|---|
Bidder/Supplier Contact(s) |
| SELECT B.SETID , B.VENDOR_ID , 'V' , B.CNTCT_SEQ_NUM , B.CONTACT_NAME , D.OPRID FROM PS_VENDOR_CNTCT B , PSOPRDEFN D , PSOPRALIAS E WHERE B.CONTACT_NAME = D.OPRDEFNDESC AND E.OPRALIASTYPE = 'VND' AND B.VENDOR_ID = E.VENDOR_ID AND B.SETID = E.SETID AND D.OPRID = E.OPRID UNION SELECT SETID , BIDDER_ID , 'B' , CONTACT_SEQ_NUM , (FIRST_NAME || ' ' || LAST_NAME) ,OPRID FROM PS_AUC_CONTACT_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 3 | BIDDER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |
| 4 | CONTACT_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | A numeric key value utilized to sequence multiple contact people for a given bank/counterpar |
| 5 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |