PERSON_IDBH=Coordinator/Provider Contact
PC=Service Provider/Coordinator
SC=Service Coordinator
SP=Service Provider
0=Inactive
1=Active
2=Pending Registration
Default Value: 1
SPB_PERSON_VW(SQL View) |
Index Back |
|---|---|
Service Procurement User TableService Procurement Generic User Table |
| SELECT DISTINCT A.PERSON_ID , A.SPRO_PERSON_TYPE , A.USER_ACC_STATUS , A.FIRST_NAME , A.MIDDLE_NAME , A.LAST_NAME , A.NAME FROM PS_SPB_PERSON_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | 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 |
| 3 | USER_ACC_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Account Status
0=Inactive 1=Active 2=Pending Registration Default Value: 1 |
| 4 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 6 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |