FO_SNDML_ATT_VW

(SQL View)
 Index Back

Send Email Attachment View


SELECT S.EMAIL_ID , S.SEQ_NUM , S.SCM_ATTACH_ID , S.ATT_VERSION , A.ATTACHUSERFILE , S.FROM_RESUME_TEXT FROM PS_PV_ATTACHMENTS A , PS_FO_SNDMAIL_ATT S WHERE S.SCM_ATTACH_ID = A.SCM_ATTACH_ID AND S.ATT_VERSION = A.ATT_VERSION AND S.FROM_RESUME_TEXT = 'N'

  • Parent record: FO_SNDMAIL_HIST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMAIL_ID Number(12,0) DECIMAL(12) NOT NULL Email ID
    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    3 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.
    4 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.
    5 RESUME_TEXT_FILE Character(64) VARCHAR2(64) NOT NULL Resume Text File
    6 FROM_RESUME_TEXT Character(1) VARCHAR2(1) NOT NULL From Resume Text

    Y/N Table Edit

    Default Value: N