HRS_CERT_ELG_VW(SQL View) |
Index Back |
---|---|
Certificate of Eligibles ViewCertificate of Eligibles View |
SELECT A.HRS_JOB_OPENING_ID , A.JOBCODE , A.HRS_JO_RQMT_SEQ , A.HRS_JO_PRM_JCD_FLG , A.GVT_RQSN_CERT_NBR , A.GVT_RQSN_CERT_SRC , A.GVT_RQSN_CERT_STS , A.DT_DUE , A.DT_ISSUED , A.DT_RECVD , A.DT_REQUESTED , A.DT_RETURNED , A.GVT_DT_EXTENDED , A.GVT_DT_RET_FRM_SO , A.GVT_DT_SENT_TO_SO , A.GVT_SUMMER_APPT , A.GVT_NTE_DATE , A.GVT_NTE_DAYS , A.GVT_LEO_POSITION , A.GVT_POSN_SENS_CD , A.GVT_TYPE_OF_APPT FROM PS_HRS_JO_RQMT A WHERE A.JOBCODE <> ' ' AND A.GVT_RQSN_CERT_NBR <> ' ' |
# | 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
Prompt Table: HRS_JO_I |
2 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: HRS_JOBCODE_I |
3 | HRS_JO_RQMT_SEQ | Number(3,0) | SMALLINT NOT NULL | Job opening requirement sequence |
4 | HRS_JO_PRM_JCD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Primary job code for job opening
Y/N Table Edit Default Value: N |
5 | GVT_RQSN_CERT_NBR | Character(10) | VARCHAR2(10) NOT NULL | Certificate of Eligibles Nbr |
6 | GVT_RQSN_CERT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Certificate Source
I=Generated Internally O=Requested from OPM |
7 | GVT_RQSN_CERT_STS | Character(1) | VARCHAR2(1) NOT NULL |
Certificate Status
C=Cancelled F=Forwarded by Selecting Off I=Issued/Received M=Pending Min Qual Determination P=Pending Ratings R=Requested S=Re-Issued T=Returned by Selecting Official U=Returned to Issuer W=Waiting Applicants |
8 | DT_DUE | Date(10) | DATE | Due Date |
9 | DT_ISSUED | Date(10) | DATE | Issue Date |
10 | DT_RECVD | Date(10) | DATE | Date Received |
11 | DT_REQUESTED | Date(10) | DATE | Date of Request |
12 | DT_RETURNED | Date(10) | DATE | Date Returned |
13 | GVT_DT_EXTENDED | Date(10) | DATE | Extension Date |
14 | GVT_DT_RET_FRM_SO | Date(10) | DATE | Date Returned from SO |
15 | GVT_DT_SENT_TO_SO | Date(10) | DATE | Date Sent to SO |
16 | GVT_SUMMER_APPT | Character(1) | VARCHAR2(1) NOT NULL |
Summer Appointment
C=Cooperative Education F=Federal Internship Program N=Not Student Opportunity S=Summer Employment T=Student Temporary Educ Program V=Volunteer Service W=University Work Study |
17 | GVT_NTE_DATE | Date(10) | DATE | Not To Exceed Date |
18 | GVT_NTE_DAYS | Number(4,0) | SMALLINT NOT NULL | Not-to-Exceed Days |
19 | GVT_LEO_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
LEO/Fire Position
5=5USC 5305 LEO C=D.C. Police Forces F=Fire Fighter N=Not Applicable P=Primary FEPCA S=Secondary FEPCA |
20 | GVT_POSN_SENS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Sensitivity Code
1=Non Sensitive 2=Non-Critical, Sensitive 3=Critical Sensitive 4=Special Sensitive |
21 | GVT_TYPE_OF_APPT | Character(2) | VARCHAR2(2) NOT NULL |
Type of Appointment
10=Career (Competitive Svc Perm) 15=Career-Conditional (Comp Perm) 20=Nonpermanent (Comp NonPerm) 30=Schedule A (Except Svc Perm) 32=Schedule B (Except Svc Perm) 34=Schedule C (Except Svc Perm) 36=Executive (Except Svc Perm) 38=Other (Except Svc Perm) 40=Schedule A (Except NonPerm) 42=Schedule B (Except NonPerm) 44=Schedule C (Except NonPerm) 46=Executive (Except NonPerm) 48=Other (Except NonPerm) 50=Career (Senior Exec Perm) 55=Noncareer (Senior Exec Perm) 60=Limited Term (Senior Exec NPrm 65=Limited Emergency (SES NPerm) |