PERSON_IDDefault Value: NEXT
OPRIDBH=Coordinator/Provider Contact
PC=Service Provider/Coordinator
SC=Service Coordinator
SP=Service Provider
SPB_SCSRCH_VW(SQL View) |
Index Back |
|---|---|
Search record for Serv CoordSearch record for Serv Coord |
| SELECT A.PERSON_ID , B.ROLEUSER_SUPR , A.SPRO_PERSON_TYPE , A.FIRST_NAME , A.LAST_NAME FROM PSOPRALIAS P , PS_ROLEXLATOPR B , PS_SPB_PERSON_TBL A WHERE P.OPRID = B.OPRID AND A.PERSON_ID = P.PERSON_ID AND P.OPRALIASTYPE = 'SPP' AND (A.SPRO_PERSON_TYPE = 'SC' OR A.SPRO_PERSON_TYPE = 'BH' OR A.SPRO_PERSON_TYPE = 'PC') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Default Value: NEXT |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | SPRO_PERSON_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Person Type
BH=Coordinator/Provider Contact PC=Service Provider/Coordinator SC=Service Coordinator SP=Service Provider |
| 4 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |