Interface Table Key Database Fields

The Projects Interface, Activities Interface, Resources Interface, and Transactions Interface tables use these key database fields, which must be populated for each row of data:

Term	Definition
Interface Identifier field (INTFC_ID)	Identifies a batch of transactions that you send to the interface table. The value increases by one every time that a batch populates the table. You can specify a range of interface identifiers to process multiple batches on the run control page.
Interface Line Number field (INTFC_LINE_NUM)	Uniquely identifies every line that belongs to a batch with the same interface ID.

Additional key database fields in the Projects Interface staging table are Business Unit (BUSINESS_UNIT) and Project (PROJECT_ID). Additional key database fields in the Activities Interface staging table are Business Unit, Project, and Activity (ACTIVITY_ID). Additional key database fields in the Resources Interface staging table are Business Unit, Project, Activity, Team Classification (TEAM_MEMBER_CLASS), Team Identifier (TEAM_MEMBER_IND), and Team Member (TEAM_MEMBER).