PA_RA_PERS_SRCH

(SQL View)

SELECT DISTINCT d.oprid , a.emplid , a.name , c.national_id , b.emplid , b.dependent_benef FROM PS_PERSON_NAME a , ps_pa_rt_emp_setup b , ps_pers_nid c , PS_PERS_SRCH_GBL d WHERE a.emplid=b.emplid_payee AND c.national_id_type = 'PR' AND a.emplid=c.emplid AND a.emplid = d.emplid

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

5 ORIG_EMPLID Character(11) VARCHAR2(11) NOT NULL Originating Emplid
Prompt Table: PA_RA_PERS_SRC2

6 ORIG_DEP_BENEF Character(2) VARCHAR2(2) NOT NULL Original Dependent Beneficiary

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
5	ORIG_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Originating Emplid Prompt Table: PA_RA_PERS_SRC2
6	ORIG_DEP_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Original Dependent Beneficiary