SCR_PRF_ATT_VW (SQL View)	Index Back
Supplier Prof Resp Attachments Supplier Profile Response Attachments

SCR_PRF_ATT_VW

(SQL View)

Supplier Prof Resp Attachments

Supplier Profile Response Attachments

SELECT a.setid ,a.vendor_id ,a.question_id ,a.scm_attach_id ,a.att_version ,c.sup_ob_template_id , 'N' ,b.ATTACH_DESCR ,b.ATTACHUSERFILE ,b.server_id ,b.server_type ,b.server_path ,b.attachsysfilename ,%subrec(FMS_WHO_SBR, a) FROM PS_SUP_PRF_RSP_ATT a , PS_PV_ATTACHMENTS b , PS_SCR_PROF_QST_V c WHERE a.scm_attach_id = b.scm_attach_id AND a.att_version = b.att_version AND a.att_version <> 0 AND a.scm_attach_id <> ' ' AND c.question_id = a.question_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Event ID

4 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.

5 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.

6 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id

7 SCR_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove Contact
Y/N Table Edit

8 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.

9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

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

11 SERVER_TYPE Character(1) VARCHAR2(1) NOT NULL One of type ftp or DB, marks each registered attachment server.
D=Database server
F=FTP server
U=URL Server

12 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.

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

14 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.

15 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.

16 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

17 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	QUESTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
4	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.
5	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.
6	SUP_OB_TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Supplier On boarding template Id
7	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact Y/N Table Edit
8	ATTACH_DESCR	Character(100)	VARCHAR2(100) NOT NULL	A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
9	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
10	SERVER_ID	Number(4,0)	SMALLINT NOT NULL	File Server ID
11	SERVER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	One of type ftp or DB, marks each registered attachment server. D=Database server F=FTP server U=URL Server
12	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.
13	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
14	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
15	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
16	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
17	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.