HRS_DC_PERS_VW(SQL View) |
Index Back |
|---|---|
View for Data ConversionView for Data Conversion |
| SELECT 'AC' HRS_JO_SORT_BY , 'G' , 'Created by Me' DESCR FROM PSCLOCK UNION SELECT 'ASN' , 'H' , 'Primary Hiring Manager' FROM PSCLOCK UNION SELECT 'ASN' , 'P' , 'Primary Recruiter' FROM PSCLOCK UNION SELECT 'ASO' , 'M' , 'Hiring Manager' FROM PSCLOCK UNION SELECT 'ASO' , 'R' , 'Recruiter' FROM PSCLOCK UNION SELECT 'ASO' , 'T' , 'Team Member' FROM PSCLOCK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JO_SORT_BY | Character(3) | VARCHAR2(3) NOT NULL |
Job Opening 360 Sort By Dropdonw list
AC=Jobs Created by Me ALL=All Jobs ASN=Jobs Assigned to Me ASO=Jobs Associated with Me |
| 2 | HRS_ASSOCIATION_CD | Character(1) | VARCHAR2(1) NOT NULL |
Job opening association codes
A=Applied jobs G=Created by Me H=Primary Hiring Manager M=Hiring Manager N=Not applied Jobs P=Primary Recruiter R=Recruiter T=Team Member |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |