Skip to content

MTPASA_OFFERFILETRK

Participant submitted Offers for MTPASA process.

Package

BIDS

Visibility

Private

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
PARTICIPANTID varchar(20) 🔑 varchar(20) 🔑 Unique participant identifier
OFFERDATETIME datetime(3) 🔑 datetime2(0) 🔑 Date time file processed
FILENAME varchar(200) varchar(200) Submitted file name

Official MMS data model indexes

Index name Index type Index columns (in order)
MTPASA_OFFERFILETRK_PK clustered, unique, primary key PARTICIPANTID, OFFERDATETIME

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_MTPASA_OFFERFILETRK clustered, unique, primary key PARTICIPANTID, OFFERDATETIME

Historical-MMS data model indexes

Index name Index type Index columns (in order)
MTPASA_OFFERFILETRK_PK clustered, unique, primary key PARTICIPANTID, OFFERDATETIME