PERSON_IDPrompt Table: SPF_PRV_VW
SER_PROV_SRCH(SQL View) |
Index Back |
|---|---|
Service Provider Search recordService Provider Search record |
| SELECT DISTINCT PR.PERSON_ID , PR.FIRST_NAME , PR.LAST_NAME FROM PS_SPF_WORDERREC W , PS_BUS_UNIT_TBL_FS B , PS_ROLEXLATOPR O , PSOPRALIAS P , PS_SPB_PERSON_TBL PR WHERE W.WO_STATUS IN ('C', 'N', 'L', 'T') AND W.SERVICE_METHOD = 'R' AND W.BUSINESS_UNIT = B.BUSINESS_UNIT AND P.OPRID IN ( SELECT B.ROLEUSER FROM PS_SPB_SERVICE_PRV A , PS_ROLEXLATOPR B , PS_SPB_OPRALIAS_VW C , PS_SET_CNTRL_GROUP S WHERE A.SP_FUNCTION_TYPE = 'PRCT' AND A.VENDOR_ID = W.VENDOR_ID AND A.LOCATION = W.VNDR_LOC AND C.OPRALIASTYPE = 'SPP' AND C.PERSON_ID = A.PERSON_ID AND B.ROLEUSER = C.OPRID AND S.SETCNTRLVALUE = W.BUSINESS_UNIT AND S.REC_GROUP_ID = 'FS_38' AND S.SETID = A.VENDOR_SETID) AND P.OPRID = O.ROLEUSER AND PR.PERSON_ID = W.WO_CONID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: SPF_PRV_VW |
| 2 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 3 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |