Announcement content import file mapping

This section shows mapping between the IPF 4.x table/columns to the incoming XML elements in the corresponding files.

Certain audit columns in every table have these default values:

Column Comments
announcement_id <Auto generated>
CreatedBy ID of SQL user creating the record
ModifiedBy ID of SQL user updating the record
CreateDate System Date
ModifiedDate System Date

IPF4.x table: announcement

Input XML file: announcement.xml

Table column XML element Required?
announcement_date AnnouncementDate
attachment_name AttachmentName
Attachment Attachment
Title Title
Announcement Announcement Yes