FO_O_CAND_VW(SQL View) |
Index Back |
|---|---|
outstanding eventsStaffing Front Office Recruiting Funnel View of outstanding events |
| SELECT A.SO_ID , A.SO_LINE , A.EVENT_TYPE , A.FO_SUBEVENT , 0 , COUNT(*) , 0 , 0 , A.DESCR FROM PS_FO_FUN_CAND_VW A WHERE A.FO_EVENT_STAT = 'O' GROUP BY A.SO_ID, SO_LINE, EVENT_TYPE, FO_SUBEVENT, 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 | FO_SUBEVENT | Character(10) | VARCHAR2(10) NOT NULL | Staffing Front Office Recruiting Funnel SubEvent |
| 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 |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |