SS_EXT_USER_REG(SQL View) |
Index Back |
|---|---|
View for Self Service UserThis view pulls out the information from Customer Data Model for existing user. |
| SELECT E.PERSON_ID , EMAIL_ADDR , E.FIRST_NAME , E.LAST_NAME FROM PS_BO_SRCH_EML C , PS_RD_PERSON D , PS_RD_PERSON_NAME E WHERE C.PRIMARY_IND='Y' AND C.BO_ID=D.BO_ID AND D.PERSON_ID = E.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |