SPF_MY_INTERVW(SQL View) |
Index Back |
|---|---|
My Interview Schedule viewThis view selects records from the interview table by interviewer rather than by the bid ids |
| SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR ,A.WORK_ORDER_ID ,A.SEQNBR , A.BID_ID , A.INTERVIEWER , A.INTERVW_COMPLETED , A.SPF_DATEFIELD , A.SPF_TIME , A.INTERVIEWLOCATION , B.SRVC_PROVIDER_ID , A.SPF_DATETIME , B.VENDOR_ID , ' ' FROM PS_SPF_INTERVIEW A , PS_SPF_BID_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SP_REQ_ID = B.SP_REQ_ID AND A.LINE_NBR = B.LINE_NBR AND A.BID_ID = B.BID_ID AND A.WORK_ORDER_ID =B.WORK_ORDER_ID AND A.SEQNBR =B.SEQNBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SP_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 5 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | BID_ID | Number(10,0) | DECIMAL(10) NOT NULL | Bid Id |
| 7 | INTERVIEWER | Character(30) | VARCHAR2(30) NOT NULL | The sPro user that is scheduled to interview a submitted candidate |
| 8 | INTERVW_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Interview Completed
N=No Y=Yes Y/N Table Edit |
| 9 | SPF_DATEFIELD | Date(10) | DATE | Date |
| 10 | SPF_TIME | Time(15) | TIMESTAMP | Time |
| 11 | INTERVIEWLOCATION | Character(50) | VARCHAR2(50) NOT NULL | The location where the interview is to take place. |
| 12 | SRVC_PROVIDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider |
| 13 | SPF_DATETIME | DateTime(26) | TIMESTAMP | Date and Time |
| 14 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPB_VENDOR_VW2 |
| 15 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |