REQ_SE_ATT1 (SQL View)	Index Back
Search comments and attach Core Req comments with attachments

REQ_SE_ATT1

(SQL View)

Search comments and attach

Core Req comments with attachments

SELECT A.SERVER_ID , A.SERVER_PATH , A.ATTACHSYSFILENAME , SRV.PV_URL_ID , SRV.ATT_SRV_NAME , A.SCM_ATTACH_ID , A.ATT_VERSION FROM PS_PV_ATTACHMENTS A , PS_PV_ATT_SERVERS SRV WHERE A.SERVER_ID = SRV.SERVER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SERVER_ID Number(4,0) SMALLINT NOT NULL File Server ID

2 SERVER_PATH Character(254) VARCHAR2(254) NOT NULL For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found.

3 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

4 PV_URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier

5 ATT_SRV_NAME Character(254) VARCHAR2(254) NOT NULL Name of attachment server, if it is an ftp server; name of the database record which holds attached files, if attachments are to be stored in the database

6 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.

7 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SERVER_ID	Number(4,0)	SMALLINT NOT NULL	File Server ID
2	SERVER_PATH	Character(254)	VARCHAR2(254) NOT NULL	For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found.
3	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
4	PV_URL_ID	Character(30)	VARCHAR2(30) NOT NULL	URL Identifier
5	ATT_SRV_NAME	Character(254)	VARCHAR2(254) NOT NULL	Name of attachment server, if it is an ftp server; name of the database record which holds attached files, if attachments are to be stored in the database
6	SCM_ATTACH_ID	Character(64)	VARCHAR2(64) NOT NULL	The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
7	ATT_VERSION	Number(3,0)	SMALLINT NOT NULL	The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.