HRS_JOSTAT_VW(SQL View) |
Index Back |
|---|---|
Job Opening StatsJob Opening Stats |
| SELECT A.HRS_JOB_OPENING_ID ,C.HRS_JO_PST_OPN_DT ,C.HRS_JO_PST_CLS_DT ,C.HRS_DAYS_OPEN ,C.HRS_DAYS_TO_FILL ,C.HRS_DAYS_CLOSE , COUNT(B.HRS_JOB_OPENING_ID) FROM PS_HRS_JOB_OPENING A LEFT OUTER JOIN PS_HRS_RCMNT B ON (A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID) ,PS_HRS_JOBPOST_VW C WHERE A.HRS_JOB_OPENING_ID = C.HRS_JOB_OPENING_ID GROUP BY A.HRS_JOB_OPENING_ID,C.HRS_JO_PST_OPN_DT,C.HRS_JO_PST_CLS_DT,C.HRS_DAYS_OPEN,C.HRS_DAYS_TO_FILL,C.HRS_DAYS_CLOSE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | HRS_JO_PST_OPN_DT | Date(10) | DATE | Job opening posting open date |
| 3 | HRS_JO_PST_CLS_DT | Date(10) | DATE | Job opening post close date |
| 4 | HRS_DAYS_OPEN | Number(5,0) | INTEGER NOT NULL | Days Open |
| 5 | HRS_DAYS_TO_FILL | Number(5,0) | INTEGER NOT NULL | Days to Fill |
| 6 | HRS_DAYS_CLOSE | Character(30) | VARCHAR2(30) NOT NULL | Days Left To Close |
| 7 | HRS_TOTAL_APPS | Number(5,0) | INTEGER NOT NULL | This field is used to track the total number of applicants that have applied to a job opening. |