HRS_COM_RANK_VW(SQL View) |
Index Back |
|---|---|
Comp. Recruitment Rank ViewUsed as a no auto-select grid for competetive candidates on the applicant rank component. |
| SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.JOBCODE ,A.STATUS_CODE ,A.STATUS_REASON ,A.HRS_STATUS_DT ,%subrec(HRS_SCR_SBR, A) FROM PS_HRS_RCMNT_JOB 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 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 4 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 5 | STATUS_REASON | Character(3) | VARCHAR2(3) NOT NULL | Identifies a reason associated with a particular status. |
| 6 | HRS_STATUS_DT | Date(10) | DATE | Recruiting Solutions Status Date field |
| 7 | GVT_APPL_COMP_STS | Character(1) | VARCHAR2(1) NOT NULL |
Applicant Competitive Status
0=Mark... C=Competitive N=Non-Competitive VRA O=Non-Competitive Other |
| 8 | GVT_RQSN_CERT_NBR | Character(10) | VARCHAR2(10) NOT NULL | Certificate of Eligibles Nbr |
| 9 | GVT_QUALS_DETERM | Character(1) | VARCHAR2(1) NOT NULL |
Qualifications Determination Flag
B=Best Qualified D=Does Not Meet Min Quals N=Eligible/Not Rated Q=Qualified W=Well Qualified |
| 10 | GVT_QUALS_DET_DATE | Date(10) | DATE | Qualifications Determ Date |
| 11 | GVT_MIN_QUAL_SCORE | Number(5,1) | DECIMAL(4,1) NOT NULL | Minimum Quals Score |
| 12 | GVT_APPL_AP_SCORE | Signed Number(6,1) | DECIMAL(4,1) NOT NULL | Augmentation Points for Applicants |
| 13 | GVT_APPL_VP_SCORE | Signed Number(3,0) | DECIMAL(2) NOT NULL | Veterans Preference Points |
| 14 | HRS_APP_SEL_SCORE | Signed Number(6,1) | DECIMAL(4,1) NOT NULL | Selective factor points earned by an applicant. |
| 15 | HRS_SCR_SCORE | Signed Number(6,1) | DECIMAL(4,1) NOT NULL | Screening score. Includes all points awarded to an applicant for a screening level, less veterans preference points, augmenting points, and selective factor points. |
| 16 | HRS_SCR_TTL_SCORE | Signed Number(6,1) | DECIMAL(4,1) NOT NULL | Screening score. Includes all points awarded to an applicant for a screening level, INCLUDING veterans preference points, augmenting factor points, and selective factor points. |
| 17 | GVT_RANK_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Ranking Category
1=Category 1 2=Category 2 3=Category 3 4=Category 4 |
| 18 | GVT_RANK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Ranking Status
N=Do Not Rank R=Rank Default Value: N |
| 19 | GVT_APPL_RANK | Number(3,0) | SMALLINT NOT NULL | Rank on Certificate |
| 20 | GVT_VET_RECR_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Recruitment Code
1=CPS 2=CP 3=XP 4=TP 5=NV |
| 21 | GVT_SORT_ORDER | Number(14,10) | DECIMAL(13,10) NOT NULL | Sort Order Field |
| 22 | GVT_PRIO_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Priority Placement Weight |
| 23 | GVT_PRIO_PLCMNT_CD | Character(3) | VARCHAR2(3) NOT NULL |
Priority Placement Code
Prompt Table: HRS_G_PR_PL_TBL |
| 24 | GVT_RQSN_SEL_CRITE | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Selection Criteria
1=None 2=Must Consider 3=Must Select |