HRS_PERSON_IDHRS_RCMNT_IDHRS_JOB_OPENING_IDHRS_SCREENING_IDHRS_JO_TMPL_SCTN12HRS_RCM_SCR6_VW(SQL View) |
Index Back |
|---|---|
JO Screening Results ViewThis view is used to display applicants associated with the job opening and applicants' status as s/he moves through the job opening screening process. It is used as a no-autoselect derived display grid on the job opening screening component. This view should not be exposed through query and should not be used for any other purpose. The view one row for each Content Types in the Screening process containing the aggregated screening score for all items in that content type. |
| SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_JOB_OPENING_ID ,A.HRS_SCREENING_ID ,A.HRS_JO_TMPL_SCTN12 ,A.HRS_SCR_CONT_SCORE ,%subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_SCRITM_RSLT A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_RCMNT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 3 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 4 | HRS_SCREENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Screening ID |
| 5 | HRS_JO_TMPL_SCTN12 |
Character(12) | VARCHAR2(12) NOT NULL | Job Opening Template Sections |
| 6 | HRS_SCR_CONT_SCORE | Signed Number(4,0) | DECIMAL(3) NOT NULL | Tracks the applicant score for a content type during job opening screening. |
| 7 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 8 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 9 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 10 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |