HRS_APP_PRPL_VW

(SQL View)
 Index Back

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , A.GVT_PRIO_PLCMNT_CD , A.GVT_PRIO_DT_END , A.GVT_PAY_PLAN , A.GVT_OCC_SERIES , A.GRADE , B.GVT_PRIO_WEIGHT , C.GVT_RQSN_SEL_CRITE , C.HRS_G_JO_TYPE , C.EFFDT FROM PS_HRS_G_PRI_PL_I A , PS_HRS_G_PR_PL_TBL B , PS_HRS_G_PR_PL_SEL C WHERE A.GVT_PRIO_PLCMNT_CD = B.GVT_PRIO_PLCMNT_CD AND B.GVT_PRIO_PLCMNT_CD = C.GVT_PRIO_PLCMNT_CD

# 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 GVT_PRIO_PLCMNT_CD Character(3) VARCHAR2(3) NOT NULL Priority Placement Code
4 GVT_PRIO_DT_END Date(10) DATE Priority Placement End Date
5 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
6 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
7 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
8 GVT_PRIO_WEIGHT Number(3,0) SMALLINT NOT NULL Priority Placement Weight
9 GVT_RQSN_SEL_CRITE Character(1) VARCHAR2(1) NOT NULL Job Opening Selection Criteria
1=None
2=Must Consider
3=Must Select
10 HRS_G_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Federal job requisition type
I=Internal
M=Merit Promotion
O=Open Competition
11 EFFDT Date(10) DATE Effective Date

Default Value: %date