HRS_SCREENING_IDHRS_LVL_DSCR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.HRS_SCREENING_ID , C.DESCR , B.HRS_JOB_OPENING_ID FROM PS_HRS_JO_SCR_LV_I A , PS_HRS_JO_SCR_SM_I B , PS_HRS_SCREEN_I C WHERE A.HRS_JO_SCR_SUMM_ID = B.HRS_JO_SCR_SUMM_ID AND A.HRS_SCREENING_ID = C.HRS_SCREENING_ID AND C.HRS_ONLINE_SCR_FLG <> 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_SCREENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Screening ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |