SPF_PL_FA_CAVF (SQL View)	Index Back
Progress Log Fluid Approvals CAVF Source view for Fluid progress Log Approvals

SPF_PL_FA_CAVF

(SQL View)

Progress Log Fluid Approvals

CAVF Source view for Fluid progress Log Approvals

SELECT C.BUSINESS_UNIT , C.PLOG_ID ,C.COMMENTS , A.SCM_ATTACH_ID , A.ATT_VERSION , B.ATTACH_DESCR , B.SERVER_ID , B.SERVER_TYPE , B.SERVER_PATH , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE FROM PS_SPA_PLOG_ATTACH A INNER JOIN PS_PV_ATTACHMENTS B ON A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION FULL OUTER JOIN PS_SPA_PLOG_HDR C ON A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PLOG_ID = C.PLOG_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PLOG_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)

3 COMMENTS Long Character CLOB Comment

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

7 SERVER_ID Number(4,0) SMALLINT NOT NULL File Server ID
Prompt Table: PV_ATT_SERVERS

8 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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PLOG_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
3	COMMENTS	Long Character	CLOB	Comment
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	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.
7	SERVER_ID	Number(4,0)	SMALLINT NOT NULL	File Server ID Prompt Table: PV_ATT_SERVERS
8	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
9	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.
10	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
11	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File