SO_IDSO_LINEEVENT_TYPEFO_E2_CAND_VW(SQL View) |
Index Back |
|---|---|
events in each statusStaffing Front Office Recruiting Funnel View of total number of events in each status |
| SELECT A.SO_ID , A.SO_LINE , A.EVENT_TYPE , C.DESCR , SUM(CASE WHEN A.FO_EVENT_STAT = 'C' THEN 1 ELSE 0 END) , SUM(CASE WHEN A.FO_EVENT_STAT = 'O' THEN 1 ELSE 0 END) , SUM(CASE WHEN A.FO_EVENT_STAT = 'I' THEN 1 ELSE 0 END) , SUM(CASE WHEN A.FO_EVENT_STAT = 'P' THEN 1 ELSE 0 END) FROM PS_FO_RF_ENTRY A , PS_FO_CANDIDATE_W B , PS_FO_EVENTS_SETUP C WHERE A.SO_LINE <> 0 AND A.FO_SUBEVENT = ' ' AND B.CANDIDATE_ID = A.CANDIDATE_ID AND C.EVENT_TYPE = A.EVENT_TYPE AND EXISTS ( SELECT 'X' FROM PS_FO_SO_LINE_MTCH Q WHERE Q.FO_FUN_UCONS = 'Y' AND Q.SO_ID = A.SO_ID AND Q.SO_LINE = A.SO_LINE AND Q.CANDIDATE_ID = A.CANDIDATE_ID) GROUP BY A.SO_ID , A.SO_LINE , A.EVENT_TYPE , C.DESCR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 2 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 3 | EVENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Event Type |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | FO_FUN_COMPL | Number(3,0) | SMALLINT NOT NULL | Staffing Front Office Recruiting Funnel Completed Indicator |
| 6 | FO_FUN_OUT | Number(9,0) | DECIMAL(9) NOT NULL | Staffing Front Office Recruiting Funnel Outstanding Indicator |
| 7 | FO_FUN_IP | Number(9,0) | DECIMAL(9) NOT NULL | Staffing Front Office Recruiting Funnel In Progress Indicator |
| 8 | FO_FUN_PART | Number(9,0) | DECIMAL(9) NOT NULL | Staffing Front Office Recruiting Funnel Partially Complete Indicator |