SCC_PERUSF_VW

(SQL View)
 Index Back

Person Data USF View

Person Data USF View used by personal data view SCC_PERDATA_VW.

SELECT P.EMPLID , %subrec(PERS_DTFED3_SBR, U) FROM PS_PERSON P , PS_PERS_DATA_USF U , PS_PERSON_DT_SETUP S WHERE U.EMPLID = P.EMPLID AND %EffdtCheck(PERS_DATA_USF U2, U, %CURRENTDATEIN) AND S.USF_FLG = 'Y' UNION SELECT PX.EMPLID , ' ' , ' ' , ' ' , ' ' , ' ' , %DateNull , %DateNull , ' ' , 0 , ' ' , ' ' , 'N' , ' ' , ' ' , %DateNull , ' ' , 'N' , '05' , ' ' , '0000' , 'N' , 'N' , ' ' , ' ' , 'N' , 'N' , ' ' , %DateNull , ' ' , ' ' , ' ' FROM PS_PERSON PX WHERE NOT EXISTS ( SELECT 'X' FROM PS_PERS_DATA_USF UX , PS_PERSON_DT_SETUP SX WHERE UX.EMPLID = PX.EMPLID AND %EffdtCheck(PERS_DATA_USF UX2, UX, %CURRENTDATEIN) AND SX.USF_FLG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: PERS_DATA_EFFDT.EMPLID

Prompt Table: PERSON

2 GVT_CRED_MIL_SVCE Character(4) VARCHAR2(4) NOT NULL Creditable Military Service
3 GVT_MILITARY_COMP Character(1) VARCHAR2(1) NOT NULL Uniformed Service
A=Air Force
C=Coast Guard
M=Marines
N=Navy
R=Army
4 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
5 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
6 GVT_MIL_SEP_RET Character(1) VARCHAR2(1) NOT NULL Military Separation Status
R=Retired
S=Separated
Z=Not Applicable
7 GVT_MIL_SVCE_END Date(10) DATE Military Service End Date
8 GVT_MIL_SVCE_START Date(10) DATE Military Service Start Date
9 GVT_MIL_VERIFY Character(1) VARCHAR2(1) NOT NULL Military Service Verified
10 GVT_PAR_NBR_LAST Number(6,0) INTEGER NOT NULL Last Personnel Action Reqst #
11 GVT_UNIF_SVC_CTR Character(1) VARCHAR2(1) NOT NULL Notify Military Pay Center
12 GVT_VET_PREF_APPT Character(1) VARCHAR2(1) NOT NULL Veterans Preference
13 GVT_VET_PREF_RIF Character(1) VARCHAR2(1) NOT NULL Veterans Preference RIF

Default Value: N

14 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag
15 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
16 GVT_YR_ATTAINED Date(10) DATE Year Attained
17 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran

Y/N Table Edit

18 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

Default Value: N

19 GVT_DISABILITY_CD Character(2) VARCHAR2(2) NOT NULL Disability Code

Default Value: 05

20 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
21 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

Default Value: 0000

22 GVT_CURR_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Current Agency Employee

Y/N Table Edit

Default Value: N

23 GVT_CURR_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Current Federal Employee

Y/N Table Edit

Default Value: N

24 GVT_HIGH_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Highest Pay Plan
25 GVT_HIGH_GRADE Character(3) VARCHAR2(3) NOT NULL Highest Grade
26 GVT_PREV_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Agency Employee

Y/N Table Edit

Default Value: N

27 GVT_PREV_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Federal Employee

Y/N Table Edit

Default Value: N

28 GVT_SEP_INCENTIVE Character(1) VARCHAR2(1) NOT NULL Separation Incentive
B=Buyout/VSIP
E=Early Retirement
O=Other Incentive
29 GVT_SEP_INCENT_DT Date(10) DATE Separation Incentive Date
30 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
31 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
32 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2