EOTF_MAP_NAMEEOTF_DOMAIN_NAMEEOTF_COMMONELEMENTPERSON_IDRC_EBSPSFTID_VW(SQL View) |
Index Back |
|---|---|
EBS Employee Person IDThis view contains an EBS Employee's PeopleSoft CRM PERSON_ID and BO_ID. |
| SELECT A.EOTF_MAP_NAME , A.EOTF_DOMAIN_NAME , A.EOTF_COMMONELEMENT , A.EOTF_ELEMENT001 , B.BO_ID FROM PS_EOTF_XREF_DATA A , PS_RD_PERSON B WHERE A.EOTF_DOMAIN_NAME = 'PSFT' AND A.EOTF_ELEMENT001 = B.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOTF_MAP_NAME |
Character(150) | VARCHAR2(150) NOT NULL | Map Name |
| 2 | EOTF_DOMAIN_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Domain Name |
| 3 | EOTF_COMMONELEMENT |
Character(36) | VARCHAR2(36) NOT NULL | Common Element |
| 4 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 5 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |