GVT_AGENCY_SRCH

(SQL View)
 Index Back

Employee Agency search


SELECT DISTINCT A.OPRID ,A.company FROM PS_GVT_EE_SRCH A , PS_GVT_AGCY_PHRET B WHERE A.COMPANY=B.COMPANY AND B.EFFDT= ( SELECT MAX(BED.EFFDT) FROM pS_GVT_AGCY_PHRET BED WHERE BED.COMPANY=B.COMPANY AND B.EFFDT<= %CurrentDateIn) AND B.GVT_PHASED_RET='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company