FPAECAREERB_VW1 (SQL View)	Index Back
Select of Reclassifications 1

FPAECAREERB_VW1

(SQL View)

Select of Reclassifications 1

SELECT DISTINCT a.FP_CONVERSION_ID , a.EMPLID , a.EMPL_RCD FROM PS_FPAEECAREERBIS a

Parent record: FPAECAREERB_VW0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FP_CONVERSION_ID Character(20) VARCHAR2(20) NOT NULL Reclassification ID

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_CONVERSION_ID	Character(20)	VARCHAR2(20) NOT NULL	Reclassification ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr