Interface Config Mockup

Data to capture:

This could probably be specified via a DTD.

  • Source SOR
  • Format
  • Version
  • Attributes
    • Version
    • Required/Optional/Not Permitted
    • Multiple
    • Length/Size
    • Syntax
    • Target Column

Example:

<field>
 <name>GivenName</name>
 <version>1</version>
 <!-- Max size determined by database mapping -->
 <mapping>prs_names:given_name</mapping>
 <normalization>CorrectCase</normalization>
</field>

<field>
 <name>NameType</name>
 <version>1</version>
 <mapping datatype="name">prs_names:name_t</mapping>
 <values>
  <value>FKA</value>
  <value>Maiden</value>
  <value>Nickname</value>
  <value>Official</value>
  <value>Preferred</value>
 </values>
</field>

<field>
 <name>EmployeeType</name>
 <version>1</version>
 <mapping>prs_role_records_employee:x_employee_type</mapping>
 <values>
  <value>...</value>
 </values>
</field>

<interface>
 <name>CommonInbound</name>
 <version>1</version>
 <field required="yes">SORID</field>
 <fieldset multiple="yes">
  <field required="yes">GivenName</field>
  <field required="no">Surame</field>
 </fieldset>
</interface>

<extension>
 <name>StudentInbound</name>
 <interface>CommonInbound</interface>
 <format>XML/Batch</format>
 <version>1</version>
 <fieldset>
  ...
 </fieldset>
</extension>