ERE_ID_ESPCOMPANYPrompt Table: COMPANY_TBL
Prompt Table: PERSDATA_ESP_VW
ERE_REPRS_ESPVW(SQL View) |
Index Back |
|---|---|
Responsible Data ESPResponsible Data ESP with Phone and Mail data. |
| SELECT A.ERE_ID_ESP , A.COMPANY , A.RESPONSIBLE_ID , B.PHONE , C.EMAIL_ADDR FROM PS_ERE_CMP_DTA_ESP A LEFT OUTER JOIN PS_PERS_PHONE_BUSN B ON A.RESPONSIBLE_ID = B.EMPLID LEFT OUTER JOIN PS_PERS_EMAIL_BUSN C ON A.RESPONSIBLE_ID = C.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERE_ID_ESP |
Character(10) | VARCHAR2(10) NOT NULL | ERE ID |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSDATA_ESP_VW |
| 4 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 5 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |