EOTP_EMAILADDREOTP_EMAIL_VW2(SQL View) |
Index Back |
|---|---|
TPM email addresses viewTPM email addresses view-used in recruitment of contacts |
| SELECT a.EOTP_EMAILADDR ,a.EOTP_PARTNERID ,a.EOTP_SEQNUM ,a.EOTP_LASTNAME ,a.EOTP_FIRSTNAME FROM PS_EOTP_PRTNRCNTCT a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOTP_EMAILADDR |
Character(70) | VARCHAR2(70) NOT NULL | Partner Contact Email Address |
| 2 | EOTP_PARTNERID | Number(15,0) | DECIMAL(15) NOT NULL | Partner ID |
| 3 | EOTP_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | EOTP_LASTNAME | Character(30) | VARCHAR2(30) NOT NULL | Partner Contact Last Name |
| 5 | EOTP_FIRSTNAME | Character(30) | VARCHAR2(30) NOT NULL | Partner Contact First Name |