RBF_WORKER_SRCH (SQL View)	Index Back
Worker Search record for FSI Worker Search record for FSI. It lists out all the workers whose market value are "FIN."

RBF_WORKER_SRCH

(SQL View)

Worker Search record for FSI

Worker Search record for FSI. It lists out all the workers whose market value are "FIN."

SELECT A.PERSON_ID ,C.NAME ,C.LAST_NAME_SRCH ,B.SETID_DEPT ,B.DEPTID ,C.NAME_AC ,A.EMPLID , A.BO_ID FROM PS_RD_PERSON A ,PS_RB_WORKER B ,PS_RD_PERSON_NAME C WHERE A.PERSON_ID = B.PERSON_ID AND C.PERSON_ID = A.PERSON_ID AND A.MARKET = 'FIN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Default Value: NEXT

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

3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

4 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
Prompt Table: SP_SETID_NONVW

5 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
Prompt Table: RB_WORK_DEPT_VW

6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)

7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

8 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Default Value: NEXT
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
4	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Prompt Table: SP_SETID_NONVW
5	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department Prompt Table: RB_WORK_DEPT_VW
6	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID