C4 simple scenario 1

  1. RETSOUTH and RETEAST enter these report parameters:

  2. Parameter

    Value

    Report Start Date

    31-Mar-2002

    Report End Date

    6-Apr-2002

    Report As At Date

    1-Jul-2002
  1. MSATS applies the report parameters to the Last modified: 27 May 2025finding the following record:

  2. ID

    NMI

    TNI code

    DLF code

    Start date

    End date

    MAINTUPDTDT

    MAINTACTFLG

    MAINTCREATEDT

    3

    XXXXXXXX24

    VHTS

    LELS

    1-Mar-2002

    31-Dec-9999

    11-Jul-2002 1:02

    I

    2-Mar-2002 1:02
  3. Next, MSATS applies the Standing Data Access Rules to the Last modified: 27 May 2025.
  4. RETEAST can see record 3. It cannot see record 2 because its End Date is before the Start Date of the relationship record.
  5. RETSOUTH can see record 2. It cannot see record 3 because its Start Date is after the End Date of the relationship record.

  6. ID

    Participant ID

    NMI

    Role ID

    Start date

    End date

    MAINTACTFLG

    MAINTUPDTDT

    MAINTCREATEDT

    2

    RETSOUTH

    XXXXXXXX24

    FRMP

    1-Feb-2002

    31-Mar-2002

    A

    9-Nov-2002 1:20

    2-Feb-2002 1:44

    3

    RETEAST

    XXXXXXXX24

    FRMP

    1-Apr-2002

    31-Dec-9999

    A

    9-Nov-2002 1:20

    3-Apr-2002 1:04