SAD_PB_UPDEIDVW (SQL View)	Index Back
Update EMPID View for search Update Emplid View used in search record

SAD_PB_UPDEIDVW

(SQL View)

Update EMPID View for search

Update Emplid View used in search record

SELECT DISTINCT Institution ,sad_pb_fileid , emplid FROM %Table(sad_pb_upd_ext)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 SAD_PB_FILEID Character(50) VARCHAR2(50) NOT NULL Update File ID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SAD_PB_FILEID	Character(50)	VARCHAR2(50) NOT NULL	Update File ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID