STANDARD DATA DICTIONARY #704.103 -- TERM_QUALIFIER_PAIR FILE                                                     3/24/25    PAGE 1
STORED IN ^MDC(704.103,  (5271 ENTRIES)   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                                 (VERSION 1.0)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
NOTICE: This file is maintained exclusively by the CP Terminology group and must not be modified or edited in any way. Subsequent
releases of CP Terminology may create lasting errors in the CliO data store if this file is changed.  
 
This file is a join table for the Clinical Data Model that matches observations to their allowable qualifiers.  A sample could be
the observation equating to "weight" and the paired qualifier equating to "lift scale".  


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

PRIMARY KEY:        A (#91)
  Uniqueness Index: PK (#924)
       File, Field: 1) TERM_ID (704.103,.01)  2) QUALIFIER_ORDER (704.103,.02)  3) QUALIFIER_ID (704.103,.03)


INDEXED BY:    TERM_ID & QUALIFIER_ORDER & QUALIFIER_ID (PK)




704.103,.01   TERM_ID                0;1 POINTER TO TERM FILE (#704.101) (Required) (Key field)

              LAST EDITED:      APR 02, 2009 
              HELP-PROMPT:      Answer with an identifier for the primary TERM for this pairing. 
              DESCRIPTION:      This field identifies the primary TERM file (#704.101) entry in the Clinical Data Model for this
                                pairing.  

              RECORD INDEXES:   PK (#924)

704.103,.02   QUALIFIER_ORDER        0;2 NUMBER (Required) (Key field)

              INPUT TRANSFORM:  K:+X'=X!(X>9999)!(X<0)!(X?.E1"."1N.N) X
              LAST EDITED:      MAR 11, 2009 
              HELP-PROMPT:      Type a Number between 0 and 9999, 0 Decimal Digits 
              DESCRIPTION:      This represents the order that this qualifier will be displayed with the term as well as the order
                                of interpretation for complex terms.  

              RECORD INDEXES:   PK (#924)

704.103,.03   QUALIFIER_ID           0;3 POINTER TO TERM FILE (#704.101) (Required) (Key field)

              LAST EDITED:      APR 03, 2009 
              HELP-PROMPT:      Answer with an identifier for the secondary TERM for this pairing.  
              DESCRIPTION:
                                This field identifies the qualifier term or subcomponent for this pair.  

              RECORD INDEXES:   PK (#924)

704.103,.04   RANKING                0;4 NUMBER

              INPUT TRANSFORM:  K:+X'=X!(X>999999999)!(X<-999999999)!(X?.E1"."10.N) X
              LAST EDITED:      APR 03, 2009 
              HELP-PROMPT:      Type a number between -999999999 and 999999999, 9 Decimal Digits 
              DESCRIPTION:      This value will be used in calculations for this pairing as well as future graphing capabilities
                                for pick-list values.  



      FILES POINTED TO                      FIELDS

TERM (#704.101)                   TERM_ID (#.01)
                                  QUALIFIER_ID (#.03)


File #704.103

  Record Indexes:

  PK (#924)    RECORD    REGULAR    IR    LOOKUP & SORTING
       Unique for:  Key A (#91), File #704.103
      Short Descr:  Uniqueness Index for Key 'A' of File #704.103
      Description:  This will provide a quick reference per Terms and related Qualifiers.  
        Set Logic:  S ^MDC(704.103,"PK",$E(X(1),1,38),$E(X(2),1,4),$E(X(3),1,38),DA)=""
       Kill Logic:  K ^MDC(704.103,"PK",$E(X(1),1,38),$E(X(2),1,4),$E(X(3),1,38),DA)
       Whole Kill:  K ^MDC(704.103,"PK")
             X(1):  TERM_ID  (704.103,.01)  (Subscr 1)  (Len 38)
                      Lookup Prompt:  TERM ID
             X(2):  QUALIFIER_ORDER  (704.103,.02)  (Subscr 2)  (Len 4)
                      Lookup Prompt:  ORDER
             X(3):  QUALIFIER_ID  (704.103,.03)  (Subscr 3)  (Len 38)
                      Lookup Prompt:  QUALIFIER


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):