FR_AF_ATCH_VW

(SQL View)
 Index Back

Fluid CBJ Approval Attachment

Attachment view for Fluid Control Budget Journal Approval

SELECT J.FLD_REQUEST_ID , F.SCM_ATTACH_ID , F.ATT_VERSION , F.ATTACHSYSFILENAME , F.ATTACHUSERFILE , F.ATTACH_DESCR , J.FMS_OPRID , OP.OPRDEFNDESC , J.FMS_DTTM_STAMP , J.FMS_LASTUPDDTTM FROM PS_FLD_REQUEST_ATT J , PS_PV_ATTACHMENTS F , PSOPRDEFN OP WHERE F.SCM_ATTACH_ID = J.SCM_ATTACH_ID AND F.ATT_VERSION = J.ATT_VERSION AND OP.OPRID = J.FMS_OPRID AND J.SHOW_APPROVAL = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FLD_REQUEST_ID Character(30) VARCHAR2(30) NOT NULL Field Request 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 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
5 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
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 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
8 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
9 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
10 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.