SCR_CNTCT_VW(SQL View) |
Index Back |
|---|---|
SCR contact view |
| SELECT A.SETID , A.VENDOR_ID , A.CNTCT_SEQ_NUM , A.EFFDT , A.EFFDT , A.EFF_STATUS , A.CONTACT_NAME , A.CONTACT_TYPE , a.CONTACT_TITLE , B.DESCR , A.ADDRESS_SEQ_NUM , A.EMAILID , A.URL , ( SELECT M.DESCR FROM PS_VNDR_ADDR_SCROL M WHERE A.SETID = M.SETID AND A.VENDOR_ID = M.VENDOR_ID AND A.ADDRESS_SEQ_NUM = M.ADDRESS_SEQ_NUM) AS DESCR FROM PS_VENDOR_CNTCT A , PS_VNDR_CNTCT_SCR B WHERE A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_VENDOR_CNTCT C WHERE A.SETID = C.SETID AND A.VENDOR_ID = C.VENDOR_ID AND A.CNTCT_SEQ_NUM = C.CNTCT_SEQ_NUM AND C.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A') AND A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTCT_SEQ_NUM = B.CNTCT_SEQ_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | CNTCT_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 4 | SCR_EFFDT | Date(10) | DATE | Approved Changes Take Effect |
| 5 | EFFDT | Date(10) | DATE | Effective Date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 8 | CONTACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
An attribute that describes the specific purpose of a given bank/counterparty contact person.
B=Billing Contact C=Contract Collaborator D=Commercial Paper Contact E=External Contact F=Cash Forecast G=General I=Internal Corporate Contact L=Line of Credit Contact M=Executive Management O=Investment Pool Contact P=Accounts Payable R=Broker S=Sales Contact V=Service Contact W=Warehousing/Shipping Contact |
| 9 | CONTACT_TITLE | Character(35) | VARCHAR2(35) NOT NULL | The professional title for a given bank/counterparty contact person. |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: VENDOR_ADDR_VW2 |
| 12 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 13 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 14 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |