SLA/KPI fields

This table contains low-level information regarding each CHECK command run (that is, each checkpoint). 

Note: Only CHECK commands that contain the ConditionsMet parameter are recorded in the VLTrader enterprise database.

VLSLAKPI database table

Column Name Data Type Length Description
TransferID VARCHAR 30 TransferID in VLTransfers table
VLSerial VARCHAR 6 VLSerial in VLTransfers table
CheckType VARCHAR 30 Contains one of these values:
  • File Age
  • Directory Age
  • Transfer
  • Transfer EDI Ack
  • Transfer Response
Class VARCHAR 20 Contains one of these values:
  • SLA
  • KPI
  • BLANK
Subclass VARCHAR 30 Contains one of these values:
  • user-specified string
  • BLANK
TimeCondition VARCHAR 100 Contains a common-language summary of the primary time condition.
Direction VARCHAR 20 Contains one of these values:
  • Inbound
  • Outbound
  • n/a
Recursive VARCHAR 10 Contains one of these values:
  • True
  • False
  • n/a
Status VARCHAR 20 Contains one of these values:
  • Delivered
  • Completed
  • Any
  • n/a
Count VARCHAR 20 Contains one of these values:
  • 1-99999
  • All
  • n/a
Sender VARCHAR 500 Contains one of these values:
  • user-specified string
  • BLANK
  • ‘n/a’
Receiver VARCHAR 500 Contains one of these values:
  • user-specified string
  • BLANK
  • n/a
FunctionalGroupSender VARCHAR 500 Contains one of these values:
  • user-specified string
  • BLANK
  • n/a
FunctionalGroupReceiver VARCHAR 500 Contains one of these values:
  • user-specified string
  • BLANK
  • n/a
TransactionType VARCHAR 6 Contains one of these values:
  • user-specified string
  • BLANK
  • n/a
DocumentType VARCHAR 255 Contains one of these values:
  • user-specified string (planned)
  • BLANK
  • n/a(planned)
ResponseMatchCondition VARCHAR 100 Contains one of these values:
  • user-specified string (planned)
  • n/a(planned)
ConditionsMetClassification VARCHAR 20 Contains one of these values:
  • Success
  • Error
ConditionsMet BIT   true if overall conditions of CHECK were met; false otherwise