RBF_PERSON_VW (SQL View)	Index Back
FSI Person view This view brings TIN number for all FSI persons

RBF_PERSON_VW

(SQL View)

FSI Person view

This view brings TIN number for all FSI persons

SELECT DISTINCT P.BO_ID , PE.NATIONAL_ID , N.NAME FROM PS_RD_PERSON P , PS_RD_PERS_NID PE , PS_BO_NAME N WHERE P.PERSON_ID = PE.PERSON_ID AND P.BO_ID = N.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUS_CONTACT_ID Number(31,0) DECIMAL(31) NOT NULL Business Contact Id

2 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL Social Security Number

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUS_CONTACT_ID	Number(31,0)	DECIMAL(31) NOT NULL	Business Contact Id
2	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Social Security Number
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name