STANDARD DATA DICTIONARY #704.118 -- OBS_QUALIFIER FILE                                                           3/24/25    PAGE 1
STORED IN ^MDC(704.118,  *** 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 relationships between observations and qualifiers.  


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

PRIMARY KEY:        A (#111)
  Uniqueness Index: PK (#959)
       File, Field: 1) OBS_ID (704.118,.01)  2) QUALIFIER_ID (704.118,.02)


INDEXED BY:    OBS_ID & QUALIFIER_ID (PK)




704.118,.01   OBS_ID                 0;1 POINTER TO OBS FILE (#704.117) (Required) (Key field)

              LAST EDITED:      APR 23, 2009 
              HELP-PROMPT:      Answer with an identifier of the observation for this observation/qualifier pair. 
              DESCRIPTION:
                                This identifies the observation part of this observation/qualifier pair.  

              RECORD INDEXES:   PK (#959)

704.118,.02   QUALIFIER_ID           0;2 POINTER TO TERM FILE (#704.101) (Required) (Key field)

              LAST EDITED:      APR 23, 2009 
              HELP-PROMPT:      Answer with an identifier of the qualifier for this observation/qualifier pair.  
              DESCRIPTION:
                                This identifies the qualifier part of this observation/qualifier pair.  

              RECORD INDEXES:   PK (#959)


      FILES POINTED TO                      FIELDS

OBS (#704.117)                    OBS_ID (#.01)

TERM (#704.101)                   QUALIFIER_ID (#.02)


File #704.118

  Record Indexes:

  PK (#959)    RECORD    REGULAR    IR    LOOKUP & SORTING
       Unique for:  Key A (#111), File #704.118
      Short Descr:  Uniqueness Index for Key 'A' of File #704.118
      Description:  This provides a quick index of unique observation/qualifier pairs.  
        Set Logic:  S ^MDC(704.118,"PK",$E(X(1),1,38),$E(X(2),1,38),DA)=""
       Kill Logic:  K ^MDC(704.118,"PK",$E(X(1),1,38),$E(X(2),1,38),DA)
       Whole Kill:  K ^MDC(704.118,"PK")
             X(1):  OBS_ID  (704.118,.01)  (Subscr 1)  (Len 38)
             X(2):  QUALIFIER_ID  (704.118,.02)  (Subscr 2)  (Len 38)


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):