STANDARD DATA DICTIONARY #702.001 -- CP_TRANSACTION_TIU_HISTORY FILE                                              3/24/25    PAGE 1
STORED IN ^MDD(702.001,  *** NO DATA STORED YET ***   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                     (VERSION 1.0)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This CP Transaction TIU History file stores all TIU notes that is associated with the CP Transaction study.  This will keep track
of multiple notes associated with one CP study.  


              DD ACCESS: @
              RD ACCESS: @
              WR ACCESS: @
             DEL ACCESS: @
           LAYGO ACCESS: @
           AUDIT ACCESS: @


INDEXED BY:    STUDY_ID & DATE_ASSIGNED & TIU_NOTE_ID (ADATE), STUDY_ID & TIU_NOTE_ID (ASTUDY), TIU_NOTE_ID & STUDY_ID &
               DATE_ASSIGNED (PK)




702.001,.01   STUDY_ID               0;1 POINTER TO CP TRANSACTION FILE (#702) (Required)

              LAST EDITED:      NOV 26, 2007 
              DESCRIPTION:
                                This field contains a pointer to the CP Transaction file (#702).  

              RECORD INDEXES:   ADATE (#280), ASTUDY (#509), PK (#510)

702.001,.02   TIU_NOTE_ID            0;2 POINTER TO TIU DOCUMENT FILE (#8925) (Required)

              LAST EDITED:      NOV 28, 2007 
              DESCRIPTION:      This field contains a pointer to the TIU Document file (#8925) representing the note that contains
                                the interpretation of this CP Transaction.  (Reference IA #3376) 

              RECORD INDEXES:   ADATE (#280), ASTUDY (#509), PK (#510)

702.001,.03   DATE_ASSIGNED          0;3 DATE (Required)

              INPUT TRANSFORM:  S %DT="ESTXR" D ^%DT S X=Y K:Y<1 X
              LAST EDITED:      NOV 26, 2007 
              DESCRIPTION:
                                This field contains the date/time when the TIU note was assigned to this transaction.  

              RECORD INDEXES:   ADATE (#280), PK (#510)


      FILES POINTED TO                      FIELDS

CP TRANSACTION (#702)             STUDY_ID (#.01)

TIU DOCUMENT (#8925)              TIU_NOTE_ID (#.02)


File #702.001

  Record Indexes:

  ADATE (#280)    RECORD    REGULAR    IR    SORTING ONLY
      Short Descr:  CHRONOLOGICAL INDEX OF NOTES BY STUDY
      Description:  This is a chronological index of TIU notes by study used for sorting.  
        Set Logic:  S ^MDD(702.001,"ADATE",$E(X(1),1,30),$E(X(2),1,30),$E(X(3),1,30),DA)=""
       Kill Logic:  K ^MDD(702.001,"ADATE",$E(X(1),1,30),$E(X(2),1,30),$E(X(3),1,30),DA)
       Whole Kill:  K ^MDD(702.001,"ADATE")
             X(1):  STUDY_ID  (702.001,.01)  (Subscr 1)  (Len 30)  (forwards)
             X(2):  DATE_ASSIGNED  (702.001,.03)  (Subscr 2)  (Len 30)  (forwards)
             X(3):  TIU_NOTE_ID  (702.001,.02)  (Subscr 3)  (Len 30)  (forwards)

  ASTUDY (#509)    RECORD    REGULAR    IR    SORTING ONLY
      Short Descr:  INDEX BY STUDY, TIU
      Description:  This is an index that is by study internal entry number and TIU Note internal entry number that is used for
                    sorting.  
        Set Logic:  S ^MDD(702.001,"ASTUDY",$E(X(1),1,30),$E(X(2),1,30),DA)=""
       Kill Logic:  K ^MDD(702.001,"ASTUDY",$E(X(1),1,30),$E(X(2),1,30),DA)
       Whole Kill:  K ^MDD(702.001,"ASTUDY")
             X(1):  STUDY_ID  (702.001,.01)  (Subscr 1)  (Len 30)  (forwards)
             X(2):  TIU_NOTE_ID  (702.001,.02)  (Subscr 2)  (Len 30)  (forwards)

  PK (#510)    RECORD    REGULAR    IR    LOOKUP & SORTING
      Short Descr:  INDEX BY NOTE, STUDY, DATE ASSIGNED
      Description:  This is an index by TIU notes, study, and date/time assigned that is used for lookup and sorting.  
        Set Logic:  S ^MDD(702.001,"PK",$E(X(1),1,30),$E(X(2),1,30),$E(X(3),1,30),DA)=""
       Kill Logic:  K ^MDD(702.001,"PK",$E(X(1),1,30),$E(X(2),1,30),$E(X(3),1,30),DA)
       Whole Kill:  K ^MDD(702.001,"PK")
             X(1):  TIU_NOTE_ID  (702.001,.02)  (Subscr 1)  (Len 30)  (forwards)
             X(2):  STUDY_ID  (702.001,.01)  (Subscr 2)  (Len 30)  (forwards)
             X(3):  DATE_ASSIGNED  (702.001,.03)  (Subscr 3)  (Len 30)  (forwards)


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):