EOTP_PARTNERIDPrompt Table: EOTP_PARTNER
EOTP_SEQNUMY/N Table Edit
Default Value: N
Prompt Table: PSOPRDEFN
EOTP_PRTNRCNTCT(SQL Table) |
Index Back |
|---|---|
Partner ContactsPartner Contacts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOTP_PARTNERID |
Number(15,0) | DECIMAL(15) NOT NULL |
Partner ID
Prompt Table: EOTP_PARTNER |
| 2 | EOTP_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | EOTP_SALUTATION | Character(30) | VARCHAR2(30) NOT NULL | Salutation |
| 4 | EOTP_FIRSTNAME | Character(30) | VARCHAR2(30) NOT NULL | Partner Contact First Name |
| 5 | EOTP_LASTNAME | Character(30) | VARCHAR2(30) NOT NULL | Partner Contact Last Name |
| 6 | EOTP_TITLE | Character(35) | VARCHAR2(35) NOT NULL | Partner Title |
| 7 | EOTP_ROLEDESCR | Character(50) | VARCHAR2(50) NOT NULL | Role Description |
| 8 | EOTP_EMAILADDR | Character(70) | VARCHAR2(70) NOT NULL | Partner Contact Email Address |
| 9 | EOTP_PHONENUM | Character(24) | VARCHAR2(24) NOT NULL | Partner Contact Phone Number |
| 10 | EOTP_PHONEEXT | Character(5) | VARCHAR2(5) NOT NULL | Partner Contact Phone Extension |
| 11 | EOTP_FAXNUM | Character(24) | VARCHAR2(24) NOT NULL | Partner Contact Fax Number |
| 12 | EOTP_PRIMCNTCT | Character(1) | VARCHAR2(1) NOT NULL |
Primary Contact Flag
Y/N Table Edit Default Value: N |
| 13 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |