RA_CM_ATTACH_VW

(SQL View)
 Index Back

Campaign Notes Attachment VW

Campaign Notes Attachments View

SELECT A.BUSINESS_UNIT ,A.RA_CAMPAIGN_ID ,A.NOTE_SEQ_NBR ,A.ATTACH_SEQ_NBR ,C.RA_NOTE_SUMMARY ,A.ATTACHUSERFILE ,A.ATTACHSYSFILENAME ,A.DESCRIPTION ,A.ROW_ADDED_DTTM ,A.ROW_ADDED_OPRID ,A.ROW_LASTMANT_DTTM ,A.ROW_LASTMANT_OPRID FROM PS_RA_CMPGN_ATCH A , PS_RA_CAMPAIGN B ,PS_RA_CMPGN_NOTE C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.RA_CAMPAIGN_ID = C.RA_CAMPAIGN_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 RA_CAMPAIGN_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
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 RA_NOTE_SUMMARY Character(80) VARCHAR2(80) NOT NULL Note summary field
6 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
8 DESCRIPTION Character(35) VARCHAR2(35) NOT NULL Description
9 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
10 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
11 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
12 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.