PERSON_IDRC_AGT_PRSON_VW(SQL View) |
Index Back |
|---|---|
search on agent summaryTelemarketing application view |
| SELECT PR.PERSON_ID , BO.BO_NAME FROM PS_RD_PERSON PR , PS_BO_NAME BO WHERE PR.BO_ID = BO.BO_ID AND BO.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |