HRS_CERT_ELG_VW

(SQL View)
Index Back

Certificate of Eligibles View

Certificate 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)