Cemetery FAQ
Data Dictionary
.
01/07/02 NEMRC Customer Support Page 1
04:24 pm Filename: CMLOCA
File Description: Plot Locator File
No Field Name Type Len Dec Description of field
--------------------------------------------------------------------------------
1 L_LOCATION C 3 0 PLOT LOCATION
2 L_DESC C 20 0 DESCRIPTION OF LOCATION
3 L_NUMPLOTS N 5 0 TOTAL NUMBER OF PLOTS FOR LOCATION
4 L_CARETAKE C 30 0 CARETAKER OF THE LOCATION
5 L_DELFLAG C 1 0 * IF DELETED
6 L_NETSTAMP N 2 0 NETWORK STAMP
--------------------------------------------------------------------------------
TOTAL LENGTH OF ALL 6 FIELDS = 61
Related Indexes
CMLOCA : L_DELFLAG+L_LOCATION .
01/07/02 NEMRC Customer Support Page 1
04:24 pm Filename: CMPLOT
File Description: Cemetary Plot File
No Field Name Type Len Dec Description of field
--------------------------------------------------------------------------------
1 P_LNAME C 25 0 DECEASED LAST NAME
2 P_FNAME C 25 0 DEACESED FIRST NAME
3 P_OLNAME C 25 0 OWNER LAST NAME
4 P_SEX C 1 0 MALE FEMALE
5 P_MAIDEN C 25 0 DECEASED MAIDEN NAME, IF FEMALE
6 P_FILLDATE D 8 0 DATE THE GRAVE WAS FILLED
7 P_OFNAME C 25 0 OWNER FIRST NAME
8 P_LOTNUM C 5 0 PLOT ID NUMBER
9 P_PURDATE D 8 0 DATE PLOT WAS FUNDED
10 P_COST N 9 2 COST OF THE PLOT
11 P_BALANCE N 9 2 BALANCE OWED ON PLOT
12 P_ROWNUM C 4 0 ROW NUMBER
13 P_GRAVENUM C 4 0 GRAVE NUMBER
14 P_LOCATION C 3 0 LOCATION OF PLOT
15 P_PLOTSIZE N 2 0 PLOT SIZE
16 P_CREAMATE C 1 0 CREAMATED STATUS
17 P_GRAVETYP C 1 0 GRAVE TYPE
18 P_LIFEB C 4 0 DATE LIFE BEGAN
19 P_LIFEE C 4 0 DATE LIFE ENDED
20 P_WAR C 25 0 WAR SERVED IN, IF ANY
21 P_NOTES M 0 0 ANTHING THE USER WANT TO ENTER
22 P_MISC0 C 25 0 MISC FIELD 0
23 P_MISC1 C 25 0 MISC FIELD 1
24 P_MISC2 C 25 0 MISC FIELD 2
25 P_MISC3 C 25 0 MISC FIELD 3
26 P_MISC4 C 25 0 MISC FIELD 4
27 P_MISC5 C 25 0 MISC FIELD 5
28 P_MISC6 C 25 0 MISC FIELD 6
29 P_MISC7 C 25 0 MISC FIELD 7
30 P_MISC8 C 25 0 MISC FIELD 8
31 P_MISC9 C 25 0 MISC FIELD 9
32 P_DELFLAG C 1 0 * IF DELETED
33 P_NETSTAMP N 2 0 NETWORK STAMP
--------------------------------------------------------------------------------
TOTAL LENGTH OF ALL 33 FIELDS = 466
Related Indexes
CMPLOT : P_DELFLAG+P_LOCATION+P_LOTNUM+P_ROWNUM+P_GRAVENUM
CMDNAM : P_DELFLAG+P_LNAME+P_FNAME
CMONAM : P_DELFLAG+P_OLNAME+P_OFNAME
CMLCOW : P_DELFLAG+P_LOCATION+P_OLNAME+P_OFNAME
CMLCDM : P_DELFLAG+P_LOCATION+P_LNAME+P_FNAME .
01/07/02 NEMRC Customer Support Page 1
04:24 pm Filename: CMSYST
File Description: Cemetery System File
No Field Name Type Len Dec Description of field
--------------------------------------------------------------------------------
1 S_F05 C 30 0 FUNCTION KEY F5
2 S_F06 C 30 0 FUNCTION KEY F6
3 S_F07 C 30 0 FUNCTION KEY F7
4 S_F08 C 30 0 FUNCTION KEY F8
5 S_F09 C 30 0 FUNCTION KEY F9
6 S_F10 C 30 0 FUNCTION KEY F10
7 S_F11 C 30 0 FUNCTION KEY F11
8 S_F12 C 30 0 FUNCTION KEY F12
9 S_MISC0 C 10 0 MISC DESCRIPTION
10 S_MISC1 C 10 0 MISC DESCRIPTION
11 S_MISC2 C 10 0 MISC DESCRIPTION
12 S_MISC3 C 10 0 MISC DESCRIPTION
13 S_MISC4 C 10 0 MISC DESCRIPTION
14 S_MISC5 C 10 0 MISC DESCRIPTION
15 S_MISC6 C 10 0 MISC DESCRIPTION
16 S_MISC7 C 10 0 MISC DESCRIPTION
17 S_MISC8 C 10 0 MISC DESCRIPTION
18 S_MISC9 C 10 0 MISC DESCRIPTION
19 S_ALLOW0 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
20 S_ALLOW1 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
21 S_ALLOW2 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
22 S_ALLOW3 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
23 S_ALLOW4 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
24 S_ALLOW5 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
25 S_ALLOW6 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
26 S_ALLOW7 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
27 S_ALLOW8 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
28 S_ALLOW9 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N)
29 S_NETSTAMP N 2 0 NETWORK STAMP
30 S_VERSION C 4 0 NEMRC EXECUTABLE THAT MATCHES THIS DATA
31 S_OLDVER C 4 0 PREVIOUS INSTALLED VERSION OF THE MODULE
32 S_UPVER D 8 0 DATE THE NEW VERSION WAS INSTALLED
--------------------------------------------------------------------------------
TOTAL LENGTH OF ALL 32 FIELDS = 368
:
