RQ_FX_ATTACH_VW

(SQL View)
 Index Back

Fix Notes Attchment VW

Fix Notes Attachments View

SELECT A.BUSINESS_UNIT , A.R_FIX_ID , A.NOTE_SEQ_NBR , A.ATTACH_SEQ_NBR , A.ATTACHUSERFILE , A.ATTACHSYSFILENAME , A.DESCRIPTION , A.ROW_ADDED_DTTM , A.ROW_ADDED_OPRID , A.ROW_LASTMANT_DTTM , A.ROW_LASTMANT_OPRID , C.R_NOTE_SUMMARY FROM PS_RQ_FIX_ATCH A , PS_RQ_FIX B ,PS_RQ_FIX_NOTE C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.R_FIX_ID = B.R_FIX_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.R_FIX_ID = C.R_FIX_ID AND A.NOTE_SEQ_NBR = C.NOTE_SEQ_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 R_FIX_ID Character(15) VARCHAR2(15) NOT NULL Fix Identification
3 NOTE_SEQ_NBR Number(6,0) INTEGER NOT NULL Note ID
4 ATTACH_SEQ_NBR Number(6,0) INTEGER NOT NULL Attachment Sequence Number
5 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
7 DESCRIPTION Character(35) VARCHAR2(35) NOT NULL Description
8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
10 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
12 R_NOTE_SUMMARY Character(80) VARCHAR2(80) NOT NULL Note Summary