EX_CA_ATCH_H_VW (SQL View)	Index Back
Cash Advance Header Attachment Cash Advance Header Attachment for Fluid Approvals

EX_CA_ATCH_H_VW

(SQL View)

Cash Advance Header Attachment

Cash Advance Header Attachment for Fluid Approvals

SELECT A.ADVANCE_ID , A.SCM_ATTACH_ID , A.ATT_VERSION , P.ATTACHUSERFILE , P.ATTACHSYSFILENAME , H.ADVANCE_NAME , P.ATTACH_DESCR , A.FMS_LASTUPDOPRID , OP.OPRDEFNDESC , A.FMS_LASTUPDDTTM FROM PS_EX_ADV_HDR H , PS_EX_CA_ATT_HDR A FULL OUTER JOIN PS_PV_ATTACHMENTS P ON A.SCM_ATTACH_ID = P.SCM_ATTACH_ID AND A.ATT_VERSION = P.ATT_VERSION , PSOPRDEFN OP WHERE H.ADVANCE_ID = A.ADVANCE_ID AND OP.OPRID = A.FMS_LASTUPDOPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID

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

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

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

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

6 ADVANCE_NAME Character(30) VARCHAR2(30) NOT NULL Advance Description

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

8 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

9 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
2	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.
3	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.
4	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
5	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
6	ADVANCE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Advance Description
7	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.
8	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
9	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.