USERIDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
SP_REQ_IDLINE_NBRBID_IDINTERVIEWERPrompt Table: SPF_INTERVIEWER
SPF_DATEFIELDSPF_TIMESRVC_PROVIDER_IDSPF_E_INTRVW_VW(SQL View) |
Index Back |
|---|---|
Interview ScheduleInterview Schedule view for pagelet /*Code Modified for bug id:13245966 in order to show only the pending interviews for the interviewer by SOW*/ |
| SELECT I.INTERVIEWER , I.BUSINESS_UNIT , I.SP_REQ_ID , I.LINE_NBR , I.BID_ID , I.INTERVIEWER , I.SPF_DATEFIELD , I.SPF_TIME , B.SRVC_PROVIDER_ID , P.NAME , I.INTERVIEWLOCATION FROM PS_SPF_INTERVIEW I , PS_SPB_PERSON_TBL P , PS_SPF_BID_HDR B WHERE I.BID_ID = B.BID_ID AND B.SRVC_PROVIDER_ID = P.PERSON_ID AND I.INTERVW_COMPLETED = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 3 | SP_REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 4 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | BID_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Bid Id |
| 6 | INTERVIEWER |
Character(30) | VARCHAR2(30) NOT NULL |
The sPro user that is scheduled to interview a submitted candidate
Prompt Table: SPF_INTERVIEWER |
| 7 | SPF_DATEFIELD |
Date(10) | DATE | Date |
| 8 | SPF_TIME |
Time(15) | TIMESTAMP | Time |
| 9 | SRVC_PROVIDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Provider |
| 10 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 11 | INTERVIEWLOCATION | Character(50) | VARCHAR2(50) NOT NULL | The location where the interview is to take place. |