EOTP_RECPTNR_VW(SQL View) |
Index Back |
|---|---|
Partners to Recruit.Partners to Recruit. |
| SELECT a.BUSINESS_UNIT ,a.EOTP_RECRUITID ,a.EOTP_PARTNERID , a.EOTP_SEQNUM ,b.EOTP_FIRSTNAME ,b.EOTP_LASTNAME ,b.EOTP_EMAILADDR FROM PS_EOTP_RECPARTNR a , PS_EOTP_PRTNRCNTCT b WHERE a.EOTP_PARTNERID=b.EOTP_PARTNERID AND a.EOTP_SEQNUM = b.EOTP_SEQNUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EOTP_RECRUITID | Number(15,0) | DECIMAL(15) NOT NULL | Recruit ID |
| 3 | EOTP_PARTNERID | Number(15,0) | DECIMAL(15) NOT NULL | Partner ID |
| 4 | EOTP_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | EOTP_FIRSTNAME | Character(30) | VARCHAR2(30) NOT NULL | Partner Contact First Name |
| 6 | EOTP_LASTNAME | Character(30) | VARCHAR2(30) NOT NULL | Partner Contact Last Name |
| 7 | EOTP_EMAILADDR | Character(70) | VARCHAR2(70) NOT NULL | Partner Contact Email Address |