STANDARD DATA DICTIONARY #704.107 -- TERM_RANGE_CHECK FILE                                                        3/24/25    PAGE 1
STORED IN ^MDC(704.107,  *** 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 value ranges for related observations/terms.  
 
An example could be a TERM RANGE CHECK entry that would result in an observed TEMPERATURE of 80 DEGREES FAHRENHEIT for a MALE
between 55-150 years of AGE, triggering a "CRITICAL LOW" response by the Clinical Flowsheets application.  


              DD ACCESS: @
              RD ACCESS: @
              WR ACCESS: @
             DEL ACCESS: @
           LAYGO ACCESS: @
           AUDIT ACCESS: @
IDENTIFIED BY: DESCRIPTION (#.09)

PRIMARY KEY:        A (#95)
  Uniqueness Index: PK (#999)
       File, Field: 1) TERM_ID (704.107,.01)  2) SEX (704.107,.03)  3) AGE_MINIMUM (704.107,.04)  4) AGE_MAXIMUM (704.107,.05)


INDEXED BY:    PATIENT_ID & TERM_ID (APT), TERM_ID & UNIT_ID & SEX & AGE_MINIMUM & AGE_MAXIMUM (ATR), TERM_ID & SEX & AGE_MINIMUM &
               AGE_MAXIMUM (PK)




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

              LAST EDITED:      APR 10, 2009 
              HELP-PROMPT:      Answer with an identifier of the applicable TERM. 
              DESCRIPTION:      This field indentifies the term to which a term range check is applicable.  
                                 
                                A sample TERM ID could identify the term "TEMPERATURE".  

              RECORD INDEXES:   APT (#928), ATR (#929), PK (#999)

704.107,.02   UNIT_ID                0;2 POINTER TO TERM FILE (#704.101) (Required)

              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Answer with an identifier of the units in which the term is presented. 
              DESCRIPTION:      This identifies the unit of measurement related to the TERM_ID (field #.01).  
                                 
                                A sample UNIT ID could identify "DEGREES F".  

              RECORD INDEXES:   ATR (#929)

704.107,.03   SEX                    0;3 SET (Key field)

                                'M' FOR Male; 
                                'F' FOR Female; 
                                'N' FOR Non-Specific; 
              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Select the gender for which this range check is applicable.  
              DESCRIPTION:      This field indicates the gender to which a term range check is applicable.  A sample SEX could be
                                "Male".  

              RECORD INDEXES:   ATR (#929), PK (#999)

704.107,.04   AGE_MINIMUM            0;4 NUMBER (Key field)

              INPUT TRANSFORM:  K:+X'=X!(X>150)!(X<0)!(X?.E1"."1.N) X
              LAST EDITED:      APR 20, 2009 
              HELP-PROMPT:      Type a number between 0 and 150, 0 Decimal Digits 
              DESCRIPTION:      This is the minimum age which the term range check is applicable.  A sample AGE MINIMUM could be
                                "55".  

              RECORD INDEXES:   ATR (#929), PK (#999)

704.107,.05   AGE_MAXIMUM            0;5 NUMBER (Key field)

              INPUT TRANSFORM:  K:+X'=X!(X>150)!(X<0)!(X?.E1"."1.N) X
              LAST EDITED:      APR 20, 2009 
              HELP-PROMPT:      Type a number between 0 and 150, 0 Decimal Digits 
              DESCRIPTION:      This is the maximum age which the term range check is applicable.  A sample AGE MAXIMUM could be
                                "150".  

              RECORD INDEXES:   ATR (#929), PK (#999)

704.107,.08   PATIENT_ID             0;8 POINTER TO PATIENT FILE (#2)

              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Answer with a PATIENT IDentifier. 
              DESCRIPTION:      This field identifies a patient for which the term range check is applicable.  
                                 
                                A sample PATIENT ID could identify "CP FLOWSHEETS,PATIENT1".  

              RECORD INDEXES:   APT (#928)

704.107,.09   DESCRIPTION            0;9 FREE TEXT

              INPUT TRANSFORM:  K:$L(X)>150!($L(X)<1) X
              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Answer must be 1-150 characters in length. 
              DESCRIPTION:      This field is a DESCRIPTION of the term range check entry.  A sample DESCRIPTION could be "Senior
                                male temperature".  


704.107,.11   CRITICAL_LOW           .1;1 NUMBER (Required)

              INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."8.N) X
              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Type a number between -9999999 and 9999999, 7 Decimal Digits 
              DESCRIPTION:      This is the value that will cause a "CRITICAL LOW" result when the term range check is applied.  A
                                sample CRITICAL LOW could be "80".  


704.107,.12   ABNORMAL_LOW           .1;2 NUMBER (Required)

              INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."8.N) X
              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Type a number between -9999999 and 9999999, 7 Decimal Digits 
              DESCRIPTION:      This is the value that will cause a "ABNORMAL LOW" result when the term range check is applied.  A
                                sample ABNORMAL LOW could be "85".  


704.107,.13   NORMAL_LOW             .1;3 NUMBER (Required)

              INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."8.N) X
              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Type a number between -9999999 and 9999999, 7 Decimal Digits 
              DESCRIPTION:      This is the value that will cause a "NORMAL LOW" result when the term range check is applied.  A
                                sample NORMAL LOW could be "90".  


704.107,.14   NORMAL_HIGH            .1;4 NUMBER (Required)

              INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."8.N) X
              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Type a number between -9999999 and 9999999, 7 Decimal Digits 
              DESCRIPTION:      This is the value that will cause a "NORMAL HIGH" result when the term range check is applied.  A
                                sample NORMAL HIGH could be "100".  


704.107,.15   ABNORMAL_HIGH          .1;5 NUMBER (Required)

              INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."8N.N) X
              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Type a Number between -9999999 and 9999999, 7 Decimal Digits 
              DESCRIPTION:      This is the value that will cause a "ABNORMAL HIGH" result when the term range check is applied.  A
                                sample ABNORMAL HIGH could be "103".  


704.107,.16   CRITICAL_HIGH          .1;6 NUMBER (Required)

              INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<-9999999)!(X?.E1"."8N.N) X
              LAST EDITED:      APR 09, 2009 
              HELP-PROMPT:      Type a Number between -9999999 and 9999999, 7 Decimal Digits 
              DESCRIPTION:      This is the value that will cause a CRITICAL HIGH"" result when the term range check is applied.  A
                                sample CRITICAL HIGH could be "106".  



      FILES POINTED TO                      FIELDS

PATIENT (#2)                      PATIENT_ID (#.08)

TERM (#704.101)                   TERM_ID (#.01)
                                  UNIT_ID (#.02)


File #704.107

  Record Indexes:

  APT (#928)    RECORD    REGULAR    IR    SORTING ONLY
      Short Descr:  PATIENT SPECIFIC
      Description:  This will quickly identify entries relating to specific PATIENT and TERMs.  
        Set Logic:  S ^MDC(704.107,"APT",$E(X(1),1,30),$E(X(2),1,38),DA)=""
       Kill Logic:  K ^MDC(704.107,"APT",$E(X(1),1,30),$E(X(2),1,38),DA)
       Whole Kill:  K ^MDC(704.107,"APT")
             X(1):  PATIENT_ID  (704.107,.08)  (Subscr 1)  (Len 30)  (forwards)
             X(2):  TERM_ID  (704.107,.01)  (Subscr 2)  (Len 38)  (forwards)

  ATR (#929)    RECORD    REGULAR    IR    SORTING ONLY
      Short Descr:  TERMINOLOGY LOADER INDEX
      Description:  This will quickly sort out related terms, units, gender, and age.  
        Set Logic:  S ^MDC(704.107,"ATR",$E(X(1),1,38),$E(X(2),1,38),$E(X(3),1,1),$E(X(4),1,3),$E(X(5),1,3),DA)=""
       Kill Logic:  K ^MDC(704.107,"ATR",$E(X(1),1,38),$E(X(2),1,38),$E(X(3),1,1),$E(X(4),1,3),$E(X(5),1,3),DA)
       Whole Kill:  K ^MDC(704.107,"ATR")
             X(1):  TERM_ID  (704.107,.01)  (Subscr 1)  (Len 38)  (forwards)
             X(2):  UNIT_ID  (704.107,.02)  (Subscr 2)  (Len 38)  (forwards)
             X(3):  SEX  (704.107,.03)  (Subscr 3)  (Len 1)  (forwards)
             X(4):  AGE_MINIMUM  (704.107,.04)  (Subscr 4)  (Len 3)  (forwards)
             X(5):  AGE_MAXIMUM  (704.107,.05)  (Subscr 5)  (Len 3)  (forwards)

  PK (#999)    RECORD    REGULAR    IR    LOOKUP & SORTING
       Unique for:  Key A (#95), File #704.107
      Short Descr:  Uniqueness Index for Key 'A' of File #704.107
      Description:  This will quickly sort out related terms, gender, and age.  
        Set Logic:  S ^MDC(704.107,"PK",$E(X(1),1,38),$E(X(2),1,1),$E(X(3),1,3),$E(X(4),1,3),DA)=""
       Kill Logic:  K ^MDC(704.107,"PK",$E(X(1),1,38),$E(X(2),1,1),$E(X(3),1,3),$E(X(4),1,3),DA)
       Whole Kill:  K ^MDC(704.107,"PK")
             X(1):  TERM_ID  (704.107,.01)  (Subscr 1)  (Len 38)
             X(2):  SEX  (704.107,.03)  (Subscr 2)  (Len 1)
             X(3):  AGE_MINIMUM  (704.107,.04)  (Subscr 3)  (Len 3)
             X(4):  AGE_MAXIMUM  (704.107,.05)  (Subscr 4)  (Len 3)


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):