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 |