INTERVIEWERBUSINESS_UNITREQ_IDSPF_INTRVW_REQS(SQL View) |
Index Back |
|---|---|
Interview Req Ids lookup viewThis view is used as the prompt for REQ_ID field for Scheduled Interviews. |
| SELECT DISTINCT I.INTERVIEWER , I.BUSINESS_UNIT , X.REQ_ID FROM PS_SPF_INTERVIEW I , PS_PV_REQ_LN_XREF X WHERE X.BUSINESS_UNIT = I.BUSINESS_UNIT AND X.SP_REQ_ID = I.SP_REQ_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTERVIEWER |
Character(30) | VARCHAR2(30) NOT NULL | The sPro user that is scheduled to interview a submitted candidate |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |