HRS_APP_FPRF_VW

(SQL View)
 Index Back

Federal - Applicant Preference

Federal - Applicant Preference

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.BUSINESS_UNIT ,A.GVT_PREV_FED_EMPL ,A.GVT_PREV_AGCY_EMPL ,A.GVT_CURR_FED_EMPL ,A.GVT_CURR_AGCY_EMPL ,A.GVT_HIGH_PAY_PLAN ,A.GVT_HIGH_GRADE ,A.GVT_PAY_PLAN ,A.GRADE ,A.GVT_TENURE ,A.GVT_VET_PREF_APPT ,A.GVT_MIL_RESRVE_CAT ,A.GVT_MILITARY_COMP ,A.GVT_MIL_GRADE ,A.GVT_MIL_SEP_RET ,A.GVT_MIL_SVCE_START ,A.GVT_MIL_SVCE_END FROM PS_HRS_APP_PROFILE 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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 GVT_PREV_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Federal Employee
N=No
Y=Yes
5 GVT_PREV_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Agency Employee
N=No
Y=Yes
6 GVT_CURR_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Current Federal Employee
N=No
Y=Yes
7 GVT_CURR_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Current Agency Employee
N=No
Y=Yes
8 GVT_HIGH_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Highest Pay Plan
9 GVT_HIGH_GRADE Character(3) VARCHAR2(3) NOT NULL Highest Grade
10 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
11 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
12 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
13 GVT_VET_PREF_APPT Character(1) VARCHAR2(1) NOT NULL Veterans Preference
14 GVT_MIL_RESRVE_CAT Character(1) VARCHAR2(1) NOT NULL Reserve Category
A=IMA - Air Force
B=IMA - Army
C=IMA - Coast Guard
D=IMA - Marines
E=IMA - Navy
F=Selected Reserve - Air Force
G=Selected Reserve - Army
H=Selected Reserve - Coast Guard
I=Selected Reserve - Marine Corp
J=Selected Reserves - Navy
K=Air National Guard
L=Army National Guard
M=IRR - Air Force
N=IRR - Army
O=IRR - Coast Guard
P=IRR - Marine Corps
Q=IRR - Navy
S=Standby Reserve - Air Force
T=Standby Reserve - Army
U=Standby Reserve - Coast Guard
V=Standby Reserve - Marine Corps
W=Standby Reserve - Navy
X=Navy Reserve - Merchant Marine
Y=Draft Eligible
Z=Not Applicable
15 GVT_MILITARY_COMP Character(1) VARCHAR2(1) NOT NULL GVT_MILITARY_COMP
A=Air Force
C=Coast Guard
M=Marines
N=Navy
R=Army
16 GVT_MIL_GRADE Character(3) VARCHAR2(3) NOT NULL Military Grade
E1=E1
E2=E2
E3=E3
E4=E4
E5=E5
E6=E6
E7=E7
E8=E8
E9=E9
O1=O1
O10=O10
O2=O2
O3=O3
O4=O4
O5=O5
O6=O6
O7=O7
O8=O8
O9=O9
W1=W1
W2=W2
W3=W3
W4=W4
17 GVT_MIL_SEP_RET Character(1) VARCHAR2(1) NOT NULL Military Separation Status
R=Retired
S=Separated
Z=Not Applicable
18 GVT_MIL_SVCE_START Date(10) DATE Military Service Start Date
19 GVT_MIL_SVCE_END Date(10) DATE Military Service End Date