Interfaces Q14107 and Q12933 are very similar in form and function. This is because Q12933 was used as a template when Q14107 it was designed.

This differences between these interfaces are as follows:

• Last Run Date:
• Q12933 - The Last Run Date is updated to the last file read. This is how standard interfaces handle the last run date.
• Q14107 - The Last Run Date is updated only if any values are updated in the day (see example below). This is not how standard interfaces handle the last run date.
  
• Utility interface:
• Q12933 is a Utility Interface.
• Q14107 is not a Utility Interface.
  
• Future code changes to CommonImport:
• Will automatically be reflected in Q12933.
• May not be reflected in Q14107 until after a bug is reported.  

Bottom Line: Unless you are dealing with a situation that specifically needs an alternative method to handle the Last Run Date, it is better to use Q12933 over Q14107.

Last Run Date Logic Table:

The following table illustrates the differences between the two interfaces when the Last Run Date is updated.

1. Scenario A: The import location does not have any files.
2. Scenario B: The import location's files all contain null values.
3. Scenario C: The import location's files contain at least 1 non-null value (meaning at least 1 variable can be updated with a value).

	Q12933	Q14107
Scenario A	No	No
Scenario B	Yes	No
Scenario C	Yes	Yes