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):