How do I interpret all the timestamp, duration, and related fields?

Timestamps 101

  1. Message Submitted Timestamp    Date and time of the submission of the report to the trade repository. (derived by KOR SDR)
  2. Message Processed Timestamp    Date and time KOR SDR completed processing of the submission. (derived by KOR SDR)
  3. Message Processing Duration    How long KOR took to fully process a message
    Message Status    The status of the processed message. (derived by KOR SDR)
    1. Message Processed Timestamp - Message Submitted Timestamp = Message Processing Duration
  4. Dissemination Status    The dissemination status of the processed message. (derived by KOR SDR)
  5. Rejection Status    The status of the rejected message. (derived by KOR SDR)
  6. Message Required Submission Timestamp    KOR SDRs calculation of when the message is required to be reported. (link)
  7. Message Required Submission Calculation    How long KOR identified as time to report
  8. Message Submission Late Indicator    Based on KOR's value in the field: Message Required Submission Timestamp, once the submission passes all validations, then KOR shall evaluate if the message was submitted late or not. (link)
  9. Message Submission Late Duration    When KOR's value in the field: Message Submission Late, is "True" then KOR SRD shall calculate the length of time the message is late by. (link)
  10. KOR Disseminated Timely Indicator    If KOR disseminated the message in accordance with regulations
  11. Calculated Trade Close Date    Date when the swap was closed or will be closed, generated by the SDR based on expiration date, action type and event timestamps. (link)

 

Timestamp format

In alignment with the CDE, KOR only accepts timestamps in the format of YYYY-MM-DDThh:mm:ssZ, based on UTC.

ISO 8601 is an international standard covering the worldwide exchange and communication of date and time-related data. It is maintained by the Geneva-based International Organization for Standardization (ISO) 

  • YYYY-MM-DDThh:mm:ssZ, based on UTC
    • YYYY = four-digit year
    • MM = two-digit month (01=January, etc.)
    • DD = two-digit day of month (01 through 31)
    • hh = two digits of hour (00 through 23) (am/pm NOT allowed)
    • mm = two digits of minute (00 through 59)
    • ss = two digits of second (00 through 59)
  • Times are expressed in UTC (Coordinated Universal Time), with a special UTC designator ("Z").

 

Duration format

Durations define the amount of intervening time in a time interval and are represented by the format P[n]Y[n]M[n]DT[n]H[n]M[n]S or P[n]W as shown on the aside. In these representations, the [n] is replaced by the value for each of the date and time elements that follow the [n]. Leading zeros are not required, but the maximum number of digits for each element should be agreed to by the communicating parties. The capital letters PYMWDTHM, and S are designators for each of the date and time elements and are not replaced.

  • P is the duration designator (for period) placed at the start of the duration representation.
    • Y is the year designator that follows the value for the number of calendar years.
    • M is the month designator that follows the value for the number of calendar months.
    • W is the week designator that follows the value for the number of weeks.
    • D is the day designator that follows the value for the number of calendar days.
  • T is the time designator that precedes the time components of the representation.
    • H is the hour designator that follows the value for the number of hours.
    • M is the minute designator that follows the value for the number of minutes.
    • S is the second designator that follows the value for the number of seconds.

For example, "P3Y6M4DT12H30M5S" represents a duration of "three years, six months, four days, twelve hours, thirty minutes, and five seconds".

Date and time elements including their designator may be omitted if their value is zero, and lower-order elements may also be omitted for reduced precision. For example, "P23DT23H" and "P4Y" are both acceptable duration representations. However, at least one element must be present, thus "P" is not a valid representation for a duration of 0 seconds. "PT0S" or "P0D", however, are both valid and represent the same duration.