PERSON_IDRC_OM_1PRADR_VW(SQL View) |
Index Back |
|---|---|
Telemarketing type 9 addressTelemarketing - find address type 9 |
| SELECT a.PERSON_ID , a.ADDRESS1 , a.CITY , a.STATE , a.POSTAL FROM PS_RT_PRSNCM_ADDR a WHERE a.PRIMARY_IND = 'Y' AND a.CM_USE_START_DT = ( SELECT MAX(CM_USE_START_DT) FROM PS_RT_PRSNCM_ADDR WHERE PERSON_ID = a.PERSON_ID AND a.CM_TYPE_ID = 1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 3 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 4 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 5 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |