STANDARD DATA DICTIONARY #712.5 -- GMT THRESHOLDS FILE                                                            3/24/25    PAGE 1
STORED IN ^EAS(712.5,  (78215 ENTRIES)   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                                  (VERSION 1.0)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------


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

PRIMARY KEY:        A (#28)
  Uniqueness Index: C (#192)
       File, Field: 1) GMT EFFECTIVE YEAR (712.5,.01)  2) FIPS CODE (712.5,.02)  3) MSA CODE (712.5,.05)

CROSS
REFERENCED BY: GMT EFFECTIVE YEAR(B)

INDEXED BY:    GMT EFFECTIVE YEAR & FIPS CODE & MSA CODE (AMSA), GMT EFFECTIVE YEAR & FIPS CODE & MSA CODE (C), GMT EFFECTIVE YEAR
               & FIPS CODE (GMT)




712.5,.01     GMT EFFECTIVE YEAR     0;1 DATE (Required) (Key field)

              INPUT TRANSFORM:  S %DT="E" D ^%DT S X=Y K:Y<1 X
              LAST EDITED:      DEC 10, 2007 
              DESCRIPTION:
                                This field contains the effective year of the GMT thresholds.  

                                UNEDITABLE
              CROSS-REFERENCE:  712.5^B 
                                1)= S ^EAS(712.5,"B",$E(X,1,30),DA)=""
                                2)= K ^EAS(712.5,"B",$E(X,1,30),DA)

              RECORD INDEXES:   AMSA (#191), C (#192), GMT (#193)

712.5,.02     FIPS CODE              0;2 NUMBER (Required) (Key field)

              INPUT TRANSFORM:  K:+X'=X!(X>99999)!(X<0)!(X?.E1"."1N.N) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Number between 0 and 99999, 0 Decimal Digits 
              DESCRIPTION:      This field contains the FIPS code associated with the GMT Threshold.  The FIPS code is a
                                combination of the STATE and COUNTY codes.  

                                UNEDITABLE
              RECORD INDEXES:   AMSA (#191), C (#192), GMT (#193)

712.5,.03     STATE                  0;3 POINTER TO STATE FILE (#5) (Required)

              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Answer must be 2 characters in length 
              DESCRIPTION:
                                This field contains the State Code associated with the GMT Threshold.  

                                UNEDITABLE

712.5,.04     COUNTY NAME            0;4 FREE TEXT (Required)

              INPUT TRANSFORM:  K:$L(X)>25!($L(X)<1) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Answer must be 1-25 characters in length. 
              DESCRIPTION:
                                This field contains the County Name associated with the GMT Threshold.  

                                UNEDITABLE

712.5,.05     MSA CODE               0;5 NUMBER (Required) (Key field)

              INPUT TRANSFORM:  K:+X'=X!(X>9999)!(X<0)!(X?.E1"."1N.N) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Number between 0 and 9999, 0 Decimal Digits 
              DESCRIPTION:
                                MSA Code associated with FIPS code for specific metropolitan area.  

                                UNEDITABLE
              RECORD INDEXES:   AMSA (#191), C (#192)

712.5,.11     GMT THRESHOLD 1        1;1 NUMBER (Required)

              INPUT TRANSFORM:  S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>999999)!(X<0) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Dollar Amount between 0 and 999999, 2 Decimal Digits 
              DESCRIPTION:      This field contains the geographical income level threshold associated with no dependants.  The
                                threshold is set yearly by the U.S. Department of Housing and Urban Development.  

                                UNEDITABLE

712.5,.12     GMT THRESHOLD 2        1;2 NUMBER (Required)

              INPUT TRANSFORM:  S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>999999)!(X<0) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Dollar Amount between 0 and 999999, 2 Decimal Digits 
              DESCRIPTION:      This field contains the geographical income level threshold associated with 1 dependant.  The
                                threshold is set yearly by the U.S. Department of Housing and Urban Development.  

                                UNEDITABLE

712.5,.13     GMT THRESHOLD 3        1;3 NUMBER (Required)

              INPUT TRANSFORM:  S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>999999)!(X<0) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Dollar Amount between 0 and 999999, 2 Decimal Digits 
              DESCRIPTION:      This field contains the geographical income level threshold associated with 2 dependants.  The
                                threshold is set yearly by the U.S. Department of Housing and Urban Development.  

                                UNEDITABLE

712.5,.14     GMT THRESHOLD 4        1;4 NUMBER (Required)

              INPUT TRANSFORM:  S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>999999)!(X<0) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Dollar Amount between 0 and 999999, 2 Decimal Digits 
              DESCRIPTION:      This field contains the geographical income level threshold associated with 3 dependants.  The
                                threshold is set yearly by the U.S. Department of Housing and Urban Development.  

                                UNEDITABLE

712.5,.15     GMT THRESHOLD 5        1;5 NUMBER (Required)

              INPUT TRANSFORM:  S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>999999)!(X<0) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Dollar Amount between 0 and 999999, 2 Decimal Digits 
              DESCRIPTION:      This field contains the geographical income level threshold associated with 4 dependants.  The
                                threshold is set yearly by the U.S. Department of Housing and Urban Development.  

                                UNEDITABLE

712.5,.16     GMT THRESHOLD 6        1;6 NUMBER (Required)

              INPUT TRANSFORM:  S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>999999)!(X<0) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Dollar Amount between 0 and 999999, 2 Decimal Digits 
              DESCRIPTION:      This field contains the geographical income level threshold associated with 5 dependants.  The
                                threshold is set yearly by the U.S. Department of Housing and Urban Development.  

                                UNEDITABLE

712.5,.17     GMT THRESHOLD 7        1;7 NUMBER (Required)

              INPUT TRANSFORM:  S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>999999)!(X<0) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Dollar Amount between 0 and 999999, 2 Decimal Digits 
              DESCRIPTION:      This field contains the geographical income level threshold associated with 6 dependants.  The
                                threshold is set yearly by the U.S. Department of Housing and Urban Development.  

                                UNEDITABLE

712.5,.18     GMT THRESHOLD 8        1;8 NUMBER (Required)

              INPUT TRANSFORM:  S:X["$" X=$P(X,"$",2) K:X'?.N.1".".2N!(X>999999)!(X<0) X
              LAST EDITED:      DEC 10, 2007 
              HELP-PROMPT:      Type a Dollar Amount between 0 and 999999, 2 Decimal Digits 
              DESCRIPTION:      This field contains the geographical income level threshold associated with 7 dependants.  The
                                threshold is set yearly by the U.S. Department of Housing and Urban Development.  

                                UNEDITABLE


      FILES POINTED TO                      FIELDS

STATE (#5)                        STATE (#.03)


File #712.5

  Record Indexes:

  AMSA (#191)    RECORD    REGULAR    IR    SORTING ONLY
      Short Descr:  NEW XREF
        Set Logic:  S ^EAS(712.5,"AMSA",X(1),X(2),X(3),DA)=""
       Kill Logic:  K ^EAS(712.5,"AMSA",X(1),X(2),X(3),DA)
       Whole Kill:  K ^EAS(712.5,"AMSA")
             X(1):  GMT EFFECTIVE YEAR  (712.5,.01)  (Subscr 1)  (forwards)
             X(2):  FIPS CODE  (712.5,.02)  (Subscr 2)  (forwards)
             X(3):  MSA CODE  (712.5,.05)  (Subscr 3)  (forwards)

  C (#192)    RECORD    REGULAR    IR    LOOKUP & SORTING
       Unique for:  Key A (#28), File #712.5
      Short Descr:  Uniqueness Index for Key 'A' of File #712.5
        Set Logic:  S ^EAS(712.5,"C",X(1),X(2),X(3),DA)=""
       Kill Logic:  K ^EAS(712.5,"C",X(1),X(2),X(3),DA)
       Whole Kill:  K ^EAS(712.5,"C")
             X(1):  GMT EFFECTIVE YEAR  (712.5,.01)  (Subscr 1)
             X(2):  FIPS CODE  (712.5,.02)  (Subscr 2)
             X(3):  MSA CODE  (712.5,.05)  (Subscr 3)

  GMT (#193)    RECORD    REGULAR    IR    LOOKUP & SORTING
      Short Descr:  Index is created for lookup thresholds using year and FIPS code
        Set Logic:  S ^EAS(712.5,"GMT",X(1),X(2),DA)=""
       Kill Logic:  K ^EAS(712.5,"GMT",X(1),X(2),DA)
       Whole Kill:  K ^EAS(712.5,"GMT")
             X(1):  GMT EFFECTIVE YEAR  (712.5,.01)  (Subscr 1)  (forwards)
             X(2):  FIPS CODE  (712.5,.02)  (Subscr 2)  (forwards)


INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):