SAD_PB_REPFIDVW (SQL View)	Index Back
Update FileID View for search Update FileID View for search record

SAD_PB_REPFIDVW

(SQL View)

Update FileID View for search

Update FileID View for search record

SELECT DISTINCT institution , sad_pb_fileid ,SAD_PB_EXT_DATE FROM %Table(sad_pb_rep_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 Report File ID

3 SAD_PB_EXT_DATE Date(10) DATE Extract Date

#	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	Report File ID
3	SAD_PB_EXT_DATE	Date(10)	DATE	Extract Date