STANDARD DATA DICTIONARY #910 -- ESP MASTER NAME INDEX FILE 6/27/25 PAGE 1
STORED IN ^ESP(910, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 1.0)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
The ESP MASTER NAME INDEX file contains demographic data (e.g., name, social security number, date of birth, age, AKA (also known
as or alias) of persons have a record with the VA Police. This file is pointed to by the name fields in the ESP POLICE
REGISTRATION LOG file (#910.2), ESP OFFENSE REPORT file (#912), ESP VIOLATION file (#914), and the ESP WANTS & WARRANTS file
(#913).
DD ACCESS: @
RD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
IDENTIFIED BY: SOCIAL SECURITY NUMBER (#.02), DOB (#.03), CATEGORY (#.04)[R]
POINTED TO BY: OWNER NAME field (#.03) of the ESP POLICE REGISTRATION LOG File (#910.2)
PARENT/GUARDIAN field (#4.05) of the ESP POLICE REGISTRATION LOG File (#910.2)
SPONSOR field (#5.01) of the ESP POLICE REGISTRATION LOG File (#910.2)
VEHICLE field (#6.01) of the ESP POLICE REGISTRATION LOG File (#910.2)
BICYCLE field (#6.02) of the ESP POLICE REGISTRATION LOG File (#910.2)
WEAPON field (#6.03) of the ESP POLICE REGISTRATION LOG File (#910.2)
PET field (#6.04) of the ESP POLICE REGISTRATION LOG File (#910.2)
GOLF field (#6.05) of the ESP POLICE REGISTRATION LOG File (#910.2)
RECEIVED FROM field (#.03) of the ITEM NUMBER sub-field (#910.81) of the ESP EVIDENCE File (#910.8)
OWNER field (#.04) of the ITEM NUMBER sub-field (#910.81) of the ESP EVIDENCE File (#910.8)
RECEIVED BY field (#.03) of the CHANGE OF CUSTODY DATE sub-field (#910.85) of the ESP EVIDENCE File (#910.8)
COMPLAINANT NAME field (#.02) of the COMPLAINANT sub-field (#912.03) of the ESP OFFENSE REPORT File (#912)
NAME field (#.02) of the VICTIM sub-field (#912.04) of the ESP OFFENSE REPORT File (#912)
NAME field (#.02) of the OFFENDER sub-field (#912.05) of the ESP OFFENSE REPORT File (#912)
NAME field (#.02) of the WITNESS sub-field (#912.06) of the ESP OFFENSE REPORT File (#912)
OWNER NAME field (#.11) of the VEHICLE INFORMATION sub-field (#912.09) of the ESP OFFENSE REPORT File (#912)
NAME field (#.01) of the ESP WANTS & WARRANTS File (#913)
OFFENDER field (#.09) of the ESP VIOLATIONS File (#914)
CROSS
REFERENCED BY: NAME(B), NAME(BS5), SOCIAL SECURITY NUMBER(BS5), AKA(C), DOB(DOB), NAME(SOUN), SOCIAL SECURITY NUMBER(SSN)
910,.01 NAME 0;1 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>30!($L(X)<3)!(X'?1U.UP1","1U.UP) X
LAST EDITED: JAN 23, 1997
HELP-PROMPT: Enter the name in 'Last,First Middle' format [3-30 characters].
DESCRIPTION: Enter the name in 'Last,First Middle' format between 3-30 characters. Do not use numerics or
lowercase alphabetic characters. With the exception of the comma, period, space, hyphen, dash, and
apostrophe, punctuation characters should be avoided.
DO NOT ENTER A SPACE BETWEEN THE COMMA AND THE FIRST NAME. DO NOT DELETE A MASTER NAME ENTRY.
THIS WILL REMOVE THE NAME FROM ALL REFERENCED FILES. EDIT THE NAME TO CORRECT ANY ERRORS, OR
CONTACT YOUR IRM REPRESENTATIVE.
DELETE TEST: .01,0)= I 1 W !?10,"DELETIONS ARE NOT ALLOWED"
DELETE AUTHORITY: @
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 910^B
1)= S ^ESP(910,"B",$E(X,1,30),DA)=""
2)= K ^ESP(910,"B",$E(X,1,30),DA)
CROSS-REFERENCE: 910^SOUN^SOUNDEX
1)= S I=$E(X,1,27) D SOU^DICM S ^ESP(910,"SOUN",X_I,DA)=""
2)= S I=$E(X,1,27) D SOU^DICM K ^ESP(910,"SOUN",X_I,DA)
3)= Do not delete. Used to reduce the change of duplicate entries.
CROSS-REFERENCE: 910^BS5^MUMPS
1)= Q:$P(^ESP(910,DA,0),U,2)']"" S ^ESP(910,"BS5",$E(X,1)_$E($P(^(0),U,2),6,9),DA)=""
2)= Q:$P(^ESP(910,DA,0),U,2)']"" K ^ESP(910,"BS5",$E(X,1)_$E($P(^(0),U,2),6,9),DA)
This cross-reference allows you to enter the first letter of the last name and the last 4 numbers
of the social security number. For example, if you enter A4607, then that would identify ADAMS
with a social security number 123-45-4607.
910,.02 SOCIAL SECURITY NUMBER 0;2 NUMBER
INPUT TRANSFORM: S X=$TR(X,"-","") K:X'?9N X I $D(X),$D(^ESP(910,"SSN",X)) W " SSN already exists in another entry"
K X
LAST EDITED: JAN 31, 1997
HELP-PROMPT: Enter 9-digit SSN.
DESCRIPTION:
Enter the individual's social security number as nine digits, i.e., 123456789.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 910^SSN
1)= S ^ESP(910,"SSN",$E(X,1,30),DA)=""
2)= K ^ESP(910,"SSN",$E(X,1,30),DA)
CROSS-REFERENCE: 910^BS5^MUMPS
1)= S ^ESP(910,"BS5",$E(^ESP(910,DA,0),1)_$E(X,6,9),DA)=""
2)= K ^ESP(910,"BS5",$E(^ESP(910,DA,0),1)_$E(X,6,9),DA)
910,.03 DOB 0;3 DATE
DATE OF BIRTH
INPUT TRANSFORM: S %DT="EP" D ^%DT S X=Y K:1701231>X!(DT30!($L(X)<1) X
LAST EDITED: MAY 22, 1992
HELP-PROMPT: Answer must be [1-30 characters].
DESCRIPTION:
Enter the place where the individual is employed.
910,.07 ID BADGE 0;7 FREE TEXT
INPUT TRANSFORM: K:$L(X)>6!($L(X)<2)!(X[" "!(X["-")) X
LAST EDITED: NOV 02, 1992
HELP-PROMPT: Answer must be [2-6 characters]. No spaces or hyphens allowed.
DESCRIPTION:
This is the ID badge # issued. It is 2-6 characters, no hyphens or spaces allowed.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
910,.08 SEX 0;8 SET
'M' FOR MALE;
'F' FOR FEMALE;
LAST EDITED: NOV 06, 1991
HELP-PROMPT: Enter 'M' for MALE or 'F' for FEMALE.
DESCRIPTION:
Enter 'M' if this individual is a male, or 'F' if female.
910,.09 RACE 0;9 POINTER TO RACE FILE (#10)
LAST EDITED: NOV 06, 1991
HELP-PROMPT: Select from the available listing the race which best identifies this individual.
DESCRIPTION:
Select from the available listing the proper race of this individual.
910,.1 DRIVER'S LICENSE # 0;10 FREE TEXT
INPUT TRANSFORM: K:$L(X)>20!($L(X)<3) X
LAST EDITED: NOV 06, 1991
HELP-PROMPT: Answer should be [3-20 characters].
DESCRIPTION:
Enter the individual's driver's license number [3-20 characters].
910,.11 STATE OF ISSUE 0;11 POINTER TO STATE FILE (#5)
LAST EDITED: NOV 06, 1991
HELP-PROMPT: Enter a State.
DESCRIPTION:
From the available listing choose the state that issued the driver's license.
910,1.01 HOME ADDRESS 1;1 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>35!($L(X)<3) X
LAST EDITED: MAY 26, 1992
HELP-PROMPT: Answer must be [3-35 characters].
DESCRIPTION:
Enter the first line of this individual's home address. It must be 3-35 characters.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
910,1.02 HOME ADDRESS [LINE 2] 1;2 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>30!($L(X)<3) X
LAST EDITED: MAY 26, 1992
HELP-PROMPT: Answer must be [3-35 characters].
DESCRIPTION:
If necessary, enter the second line of this individual's home address. It must be 3-35 characters.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
910,1.03 CITY 1;3 FREE TEXT
INPUT TRANSFORM: K:$L(X)>30!($L(X)<2) X
LAST EDITED: JUN 19, 1992
HELP-PROMPT: Answer must be 2-30 characters in length.
DESCRIPTION:
Enter the city where this individual resides [2-30 characters].
910,1.04 STATE 1;4 POINTER TO STATE FILE (#5)
LAST EDITED: OCT 28, 1991
HELP-PROMPT: From the available listing choose the state in which this individual resides.
DESCRIPTION:
Enter the state where this individual resides. You must choose from the available listing.
910,1.05 ZIP 1;5 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>15!($L(X)<5) X I $D(X) D ZIPIN^ESPUTIL
OUTPUT TRANSFORM: D ZIPOUT^ESPUTIL
LAST EDITED: SEP 28, 1993
HELP-PROMPT: Enter the zip code for the city in which this individual resides.
DESCRIPTION: Enter the zip code for the city in which this individual resides. Enter the 5 digit zip code or
ZIP + 4, ie. 12345-1234.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
910,1.06 PHONE NUMBER [RESIDENCE] 1;6 FREE TEXT
INPUT TRANSFORM: K:$L(X)>20!($L(X)<4) X
LAST EDITED: OCT 28, 1991
HELP-PROMPT: Answer must be [4-20 characters].
DESCRIPTION:
Enter the individual's home telephone number. Answer must be [4-20 characters].
910,2.01 STREET ADDRESS [WORK] 2;1 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>35!($L(X)<3) X
LAST EDITED: OCT 28, 1991
HELP-PROMPT: Answer must be [3-35 characters].
DESCRIPTION: Enter the first line of the address of the individual's place of employment. Answer must be [3-35
characters].
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
910,2.02 STREET ADDRESS [LINE 2] [WORK] 2;2 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>30!($L(X)<3) X
LAST EDITED: OCT 28, 1991
HELP-PROMPT: Answer must be [3-30 characters].
DESCRIPTION: If necessary, enter the second line of the address of the individual's place of employment. Answer
must be [3-30 characters].
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
910,2.03 CITY [WORK] 2;3 FREE TEXT
INPUT TRANSFORM: K:$L(X)>30!($L(X)<2) X
LAST EDITED: JUN 19, 1992
HELP-PROMPT: Answer must be [2-30 characters].
DESCRIPTION:
Enter the city of this individual's place of employment. Answer must be [2-30 characters].
910,2.04 STATE [WORK] 2;4 POINTER TO STATE FILE (#5)
LAST EDITED: OCT 28, 1991
HELP-PROMPT: Enter a State.
DESCRIPTION: Enter the state of this individual's place of employment. You must choose from the available
listing.
910,2.05 ZIP [WORK] 2;5 FREE TEXT
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>15!($L(X)<5) X I $D(X) D ZIPIN^ESPUTIL
OUTPUT TRANSFORM: D ZIPOUT^ESPUTIL
LAST EDITED: SEP 28, 1993
HELP-PROMPT: Enter the zip code for the city in which this individual is employed.
DESCRIPTION: Enter the zip code for the city in which this individual is employed. Enter the 5 digit zip code
or ZIP + 4, ie. 12345-1234.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
910,2.06 OFFICE PHONE 2;6 FREE TEXT
INPUT TRANSFORM: K:$L(X)>20!($L(X)<4) X
LAST EDITED: OCT 28, 1991
HELP-PROMPT: Answer must be [4-20 characters].
DESCRIPTION: Enter the telephone number of this individual's place of employment. Answer must be [4-20
characters].
910,3.01 HEIGHT 3;1 FREE TEXT
INPUT TRANSFORM: K:X'?1N1"-"2N X
LAST EDITED: JUL 01, 1993
HELP-PROMPT: Enter the individual's height [2-5 characters].
DESCRIPTION:
Enter the individual's height in the format 6-07 for 6 feet and 7 inches.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
910,3.02 WEIGHT 3;2 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: SEP 18, 1992
HELP-PROMPT: Enter the individual's weight.
DESCRIPTION:
Enter the individual's weight. Select between 1 and 999.
910,3.03 HAIR COLOR 3;3 POINTER TO ESP SELECTABLES FILE (#910.7)
INPUT TRANSFORM: S DIC("S")="I $D(^(1)),$P(^(1),U,1)" D ^DIC K DIC S DIC=DIE,X=+Y K:Y<0 X
LAST EDITED: SEP 18, 1992
HELP-PROMPT: Enter the individual's hair color.
DESCRIPTION:
Enter the hair color of the individual. You must choose from the available listing.
SCREEN: S DIC("S")="I $D(^(1)),$P(^(1),U,1)"
EXPLANATION: Enter a valid hair color.
910,3.04 EYE COLOR 3;4 POINTER TO ESP SELECTABLES FILE (#910.7)
INPUT TRANSFORM: S DIC("S")="I $D(^(1)),$P(^(1),U,2)" D ^DIC K DIC S DIC=DIE,X=+Y K:Y<0 X
LAST EDITED: SEP 18, 1992
HELP-PROMPT: Enter the individual's eye color.
DESCRIPTION:
Enter the color of the individual's eyes. You must choose from the available listing.
SCREEN: S DIC("S")="I $D(^(1)),$P(^(1),U,2)"
EXPLANATION: Enter a valid eye color.
910,3.05 SKIN TONE 3;5 POINTER TO ESP SELECTABLES FILE (#910.7)
INPUT TRANSFORM: S DIC("S")="I $D(^(1)),$P(^(1),U,6)" D ^DIC K DIC S DIC=DIE,X=+Y K:Y<0 X
LAST EDITED: SEP 18, 1992
HELP-PROMPT: Enter the skin tone of the individual.
DESCRIPTION:
Enter the skin tone of the individual. You must select from the available listing.
SCREEN: S DIC("S")="I $D(^(1)),$P(^(1),U,6)"
EXPLANATION: Enter a valid skin tone.
910,3.06 SCARS/MARKS 3;6 FREE TEXT
INPUT TRANSFORM: K:$L(X)>50!($L(X)<3) X
LAST EDITED: SEP 18, 1992
HELP-PROMPT: Answer must be [3-50 characters].
DESCRIPTION:
Enter any identifying scars or marks for the individual. Answer must be 3-50 characters in length.
910,10 AKA 10;0 Multiple #910.01
DESCRIPTION:
Enter the Also Known As name. Answer must be [2-30 characters].
910.01,.01 AKA 0;1 FREE TEXT (Multiply asked)
INPUT TRANSFORM: K:$L(X)>30!($L(X)<2) X
LAST EDITED: JUN 08, 1992
HELP-PROMPT: Answer must be [2-30 characters].
DESCRIPTION:
Enter the AKA 'Also Known As' name. Answer must be [2-30 characters].
CROSS-REFERENCE: 910.01^B
1)= S ^ESP(910,DA(1),10,"B",$E(X,1,30),DA)=""
2)= K ^ESP(910,DA(1),10,"B",$E(X,1,30),DA)
CROSS-REFERENCE: 910^C
1)= S ^ESP(910,"C",$E(X,1,30),DA(1),DA)=""
2)= K ^ESP(910,"C",$E(X,1,30),DA(1),DA)
910,20 REMARKS 20;0 WORD-PROCESSING #910.02
DESCRIPTION: This is a word-processing field where you may enter additional information which you feel is
pertinent to this individual.
LAST EDITED: OCT 28, 1991
HELP-PROMPT: Enter any additional descriptive information for this individual.
DESCRIPTION: This is a word-processing field. Enter any additional descriptive information for this
individual.
FILES POINTED TO FIELDS
ESP SELECTABLES (#910.7) HAIR COLOR (#3.03)
EYE COLOR (#3.04)
SKIN TONE (#3.05)
RACE (#10) RACE (#.09)
SERVICE/SECTION (#49) SERVICE (#.05)
STATE (#5) STATE OF ISSUE (#.11)
STATE (#1.04)
STATE [WORK] (#2.04)
INPUT TEMPLATE(S):
ESP BICYCLE REGISTRATION NOV 18, 1993@10:21 USER #1221
ESP COURTESY VIOLATION INPUT SEP 13, 1993@14:60 USER #0
ESP GOLF REGISTRATION SEP 13, 1993@15:01 USER #0
ESP PET REGISTRATION SEP 13, 1993@15:03 USER #0
ESP REGISTRATION JAN 22, 1997@10:27 USER #0
ESP USDCVN INPUT SEP 13, 1993@15:04 USER #0
ESP VEHICLE REGISTRATION SEP 13, 1993@15:06 USER #0
ESP WEAPON REGISTRATION SEP 13, 1993@15:07 USER #0
PRINT TEMPLATE(S):
ESP PERSONAL DESCRIPTOR LOOKUPMAY 06, 1993@09:11 USER #0 @
This print template provides a portion of the basic demographic
data on file for individuals contained within the ESP Master Name
Index file.
SORT TEMPLATE(S):
ESP PERSONAL DESCRIPTOR LOOKUPJUL 07, 1993@11:17 USER #0
SORT BY: RACE// (User is asked range)
WITHIN RACE, SORT BY: SEX// (User is asked range)
WITHIN SEX, SORT BY: HEIGHT// (User is asked range)
WITHIN HEIGHT, SORT BY: WEIGHT// (User is asked range)
FORM(S)/BLOCK(S):