FO_E_CAND_VW(SQL View) |
Index Back |
|---|---|
events per statusStaffing Front Office Recruiting Funnel View of events per status |
| SELECT SO_ID , SO_LINE , EVENT_TYPE , FO_SUBEVENT , FO_FUN_COMPL , FO_FUN_OUT , FO_FUN_IP , FO_FUN_PART , DESCR FROM PS_FO_C_CAND_VW UNION SELECT SO_ID , SO_LINE , EVENT_TYPE , FO_SUBEVENT , FO_FUN_COMPL , FO_FUN_OUT , FO_FUN_IP , FO_FUN_PART , DESCR FROM PS_FO_O_CAND_VW UNION SELECT SO_ID , SO_LINE , EVENT_TYPE , FO_SUBEVENT , FO_FUN_COMPL , FO_FUN_OUT , FO_FUN_IP , FO_FUN_PART , DESCR FROM PS_FO_I_CAND_VW UNION SELECT SO_ID , SO_LINE , EVENT_TYPE , FO_SUBEVENT , FO_FUN_COMPL , FO_FUN_OUT , FO_FUN_IP , FO_FUN_PART , DESCR FROM PS_FO_P_CAND_VW |
| # | 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 |