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

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file maintains flowsheets (file #704.112) and observation totals (file #704.113) relationships.  


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

PRIMARY KEY:        A (#104)
  Uniqueness Index: PK (#942)
       File, Field: 1) FLOWSHEET_ID (704.1123,.01)  2) TOTAL_ORDER (704.1123,.03)  3) TOTAL_ID (704.1123,.02)


INDEXED BY:    TOTAL_ID (FKTOTAL), FLOWSHEET_ID & TOTAL_ORDER & TOTAL_ID (PK)




704.1123,.01  FLOWSHEET_ID           0;1 POINTER TO OBS_FLOWSHEET FILE (#704.112) (Required) (Key field)

              LAST EDITED:      APR 22, 2009 
              HELP-PROMPT:      Answer with an identifier for the flowsheet for this total. 
              DESCRIPTION:
                                This identifies the flowsheet file entry for this flowsheet total entry.  

              RECORD INDEXES:   PK (#942)

704.1123,.02  TOTAL_ID               0;2 POINTER TO OBS_TOTAL FILE (#704.113) (Required) (Key field)

              LAST EDITED:      APR 22, 2009 
              HELP-PROMPT:      Answer with an observation total identifier. 
              DESCRIPTION:
                                This identifies an observation total file entry to correlate with this flowsheet total entry.  

              FIELD INDEX:      FKTOTAL (#941)    REGULAR    IR    LOOKUP & SORTING
                  Short Descr:  Foreign key for OBS_TOTAL
                  Description:  This will provide a quick sort of the OBS Total file (#704.113) entries in this file.  
                    Set Logic:  S ^MDC(704.1123,"FKTOTAL",$E(X,1,38),DA)=""
                   Kill Logic:  K ^MDC(704.1123,"FKTOTAL",$E(X,1,38),DA)
                   Whole Kill:  K ^MDC(704.1123,"FKTOTAL")
                         X(1):  TOTAL_ID  (704.1123,.02)  (Subscr 1)  (Len 38)  (forwards)

              RECORD INDEXES:   PK (#942)

704.1123,.03  TOTAL_ORDER            0;3 NUMBER (Required) (Key field)

              INPUT TRANSFORM:  K:+X'=X!(X>99)!(X<1)!(X?.E1"."1.N) X
              LAST EDITED:      APR 22, 2009 
              HELP-PROMPT:      Type a number between 1 and 99, 0 Decimal Digits 
              DESCRIPTION:
                                This field determines the order in which this flowsheet total will be executed and displayed.  

              RECORD INDEXES:   PK (#942)


      FILES POINTED TO                      FIELDS

OBS_FLOWSHEET (#704.112)          FLOWSHEET_ID (#.01)

OBS_TOTAL (#704.113)              TOTAL_ID (#.02)


File #704.1123

  Record Indexes:

  PK (#942)    RECORD    REGULAR    IR    LOOKUP & SORTING
       Unique for:  Key A (#104), File #704.1123
      Short Descr:  Uniqueness Index for Key 'A' of File #704.1123
      Description:  This will provide a quick sort of unique file entries.  
        Set Logic:  S ^MDC(704.1123,"PK",$E(X(1),1,38),$E(X(2),1,2),$E(X(3),1,38),DA)=""
       Kill Logic:  K ^MDC(704.1123,"PK",$E(X(1),1,38),$E(X(2),1,2),$E(X(3),1,38),DA)
       Whole Kill:  K ^MDC(704.1123,"PK")
             X(1):  FLOWSHEET_ID  (704.1123,.01)  (Subscr 1)  (Len 38)
             X(2):  TOTAL_ORDER  (704.1123,.03)  (Subscr 2)  (Len 2)
             X(3):  TOTAL_ID  (704.1123,.02)  (Subscr 3)  (Len 38)


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):