Field

Example

Notes

caption

ELKS NATIONAL FOUNDATION

amount

10

position

1

Number to sort on for display on statements & posting grid

acctnumber

xxx.xx

GL Account

type

xx

Transaction Code

Field

Example

Notes

number

000134

members number

last

SCHROEDE R, DENNIS

Last

dues

04/01/1998

Dues Payment end date

type

01

Payment Type

amt

40.00

Payment Amount

date

01/04/1997

Date Payment was made

acctnumber

211-01

Payment Account number

exported

.F.

selected

.F.

Field

Example

Notes

begin

2008

Current Elk year

startno

Number of reported Elks Lodge Settings Screen

lifeno

Number of life members Lodge Settings Screen

membu

C

Default Drive to use for local backups

erfill

Exalted Ruler name in the Lodge Settings Screen

secfill

Lodge Secretary in the Lodge Settings Screen

reg

##.##

Regular Dues Lodge Settings Screen Lodge & Optional Dues Tab

regnew

##.##

Next Years Regular Dues Lodge Settings Screen "Lodge & Optional Dues" tab

lif

##.##

Current year Life Membership Dues Lodge Settings Screen "Lodge & Opt Dues" tab

lifnew

##.##

Next Years Life Membership Dues

ini

##.##

Initiation Fees 26 and over

inis

unknown

unknown

i26

##.##

Initiation Fees under 26

i26s

unknown

unknown

adh

##.##

Absolute Dimit

dnp

##.##

Dropped for Non-Pay

tdo

##.##

Initiation Fee Second Part to be paid 26 and older

dmi

##.##

Transfer Dimit from other

ctr

##.##

Absolute Dimit from other

unc

##.##

Unaffiliated Elk with a Ctf. Of Release

gli

##.##

GL Insurance Regular Current Year

glinew

##.##

GL Insurance Regular New Year

glf

##.##

GL Per Capita Current Year Regular Member

glfnew

##.##

GL Per Capita Next Year Life Member

aea

##.##

GL Assessments State Current Year Regular Member

aeanew

##.##

GL Assessments State Next Year Regular Member

glil

##.##

GL Insurance Current year Life Member

glilnew

##.##

GL Insurance Next Year Life member

glfl

##.##

GL Per Capita Current Year Life Member

glflnew

##.##

GL Per Capita Next Year Life Member

aeal

##.##

GL & SA Assessments State Current Year Life Member

aealnew

##.##

GL & SA Assessments State Next Year Life Member

otherr

##.##

GL & SA Assessments Other 1 Current Year Regular

otherl

##.##

GL & SA Assessments Other 1 Current Year Life

otherr2

##.##

GL & SA Assessments Other 2 Current Year Regular

otherl2

##.##

GL & SA Assessments Other 2 Current Year Life

otherrnew

##.##

GL & SA Assessments Other 1 Next Year Regular

otherlnew

##.##

GL & SA Assessments Other 1 Next Year Life

otherrnew2

##.##

GL & SA Assessments Other 2 Next Year Regular

otherlnew2

##.##

GL & SA Assessments Other 2 Next Year Life

e_dist

####

4 Digit Jurisdiction District Lodge Settings Screen

newl

LODGE NAME #5555

Lodge name supplied in either Lodge mailing address or Member screen defaults

e_number

5555

Lodge Number on Lodge Settings Screen

e_lodge

LODGE NAME #5555

Lodge name supplied in either Lodge mailing address or Member screen defaults

e_city

CITY NAME

City Name from the Member Screen Defaults on the Lodge Settings Screen

e_state

MN, IL, CA

State code under Member screen defaults

e_zip

#####-####

Zip Plus 4 under Member screen defaults on the Lodge Settings Screen

e_area

###

3 digit area number under Member screen defaults

e_laddress

Lodge Address on the Lodge Settings Screen Lodge Mailing Address

e_lzip

#####-####

Zip Plus 4 under Lodge Mailing Address on the Lodge Settings Screen

e_citydues

CITY NAME

City Name under Lodge Mailing Address on the Lodge Settings Screen

e_lodgcard

Line 1 card imprint under Lodge Settings screen on Card & Dues tab

e_lodgcard2

Line 2 card imprint under Lodge Settings screen on Card & Dues tab

e_recru

unknown

unable to determine where it's coming from

e_nrecru

unknown

unable to determine where it's coming from

inip1

##.##

Minimum Paid with application 26 and older - Initiation Fees Tab in Lodge Settings

inip2

##.##

Second part to be paid 26 and older - Initiation Fees Tab in Lodge Settings

i26p1

##.##

Minimum Paid with application under 26 - Initiation Fees Tab in Lodge Settings

i26p2

##.##

Second part to be paid under 26 - Initiation Fees Tab in Lodge Settings

inisp1

##.##

Initiation Fee for Applicant age 26 and over  Initiation Fees Tab Lodge Settings

i26sp1

##.##

Initiation Fee for Applicant age less than 26 Initiation Fees Tab Lodge Settings

mo1s

#

Special Fee begins this month Initiation Fees Tab Lodge Settings

mo2s

#

Special fee ends this month Initiation Fees Tab Lodge Settings

specrein

#

Special Fee begins this month Initiation Fees Tab Lodge Settings

emailsmtp

email@elks.org

Email set in Email Settings button on the Lodge Settings page

emailport

##

Port Number Set in Email Settings Button on the Lodge Settings page

emailuser

username

user name set in the Email Settings button of the Lodge Settings page

emailpass

password

Password set in the Email Settings button of the Lodge Settings Page

mo1sr

#

First month it applies Initiation Fees Tab of the Lodge Settings

mo2sr

#

Second month it applies Initiation Fees Tab of the Lodge Settings 

validserial

1

uses

5

glimported

.T.

datafix

0

clmsversion

1.101.316

CLMS Version number

locbkup

mm/dd/yyyy

Date of last local backup

offbkup

mm/dd/yyyy

date of last offline backup

use12due

.T. or .F.

Is This lodge set for 12 months dues on the Lodge & Opt Dues Tab of the Lodge Settings screen

mainpcname

OUTSIDE or PCName

Not the Main PC Yellow button = OUTSIDE, Main PC= Computer Name

duessimp1

Dues statement message imprint on the Cards & Dues Tab of the Lodge Settings

Field

Example

Notes

prefix

Hon, Dr, Prof, Sen, Judge, Mr, Ms, Misses, Mrs

Prefix from the Prfx drop down on the members edit screen

first

JOHN

First Name

middle

D.

Middle initial or name

last

DOE

Last Name

suffix

JR, SR, III, IV, II

Suffix from the Sufx field on the members edit screen

salutatn

LION TAMER

Nickname field on the members edit screen

elktitle

PEY, PER

Manually entered titles from the Elk Titles field on the Members Edit Screen

number

123456

6 digit member number

dues

mm/dd/yyyy

date dues are paid through

lady

JANE

spouse first name

ladycard

.T. or .F.

Is ID card checked off

address

425 W DIVERSEY PRKWY

Address field on the Cur Mail Tab

address1

APT 1

Address1 field on the Cur Mail Tab

city

CHICAGO

City field on the Cur Mail Tab

state

IL

State code from the Cur Mail Tab

zip

12345-1234

5 digit zip plus a dash and zip 4 Cur Mail Tab

country

PHILIPPINES

Country eneterd in the Country field on the "Cur Mail" tab

carrier

B005

Carrier route code Cur Mail Tab

dpc

numeric data

mailing address delivery point barcode check digit

lot

3 digit

123

result

S000010

cass code

addrn

WINTER, SUMMER

Description for Address "Cur" Mail tab

ladyborn

mm/dd

2 digit month and day of spouses birth.

anniv

mm/dd

wedding anniversary month and day

areah

###

3 digit area code for the home phone Ph/Email tab

home

###-####

Home Phone number on the Ph/Email tab

areaw

###

3 digit area code for the work phone Ph/Email tab

work

###-####

7 digit work phone number Ph/Email tab

areac

###

3 digit area code for the cell number Ph/Email tab

cell

###-####

7 digit cell phone number

areaf

###

3 digit fax area code Ph/Email tab

fax

###-####

7 digit fax number

email

johndoe@elks.org

email found on the Ph/Email Tab

veteran

.T. or .F.

Is the member checked as being a veteran

lodge

CHICAGO Lodge 1316

Lodge information shown on the members edit screen usually name and number - Lodge initiated in

proposer

name of person that proposed the member or candidate

occupation

Lawyer

occupation listed on the members edit screen

where

Place of Birth

born

mm/dd/yyyy

Date of Birth

proposed

mm/dd/yyyy

Proposed date

elected

mm/dd/yyyy

Elected Date

indoc

mm/dd/yyyy

Date indoctrinated

initiated

mm/dd/yyyy

Date initiated

dclnrejc

.T. or .F.

Rejected or did not join check box

invest

mm/dd/yyyy

Date investigated

age

50

Members calculated age based on birthdate

years

###

calculated Elk years

lostadj

##

Data-entry override for lostyears

lostyears

###

calculated lost years

affiliated

mm/dd/yyyy

affiliated date

transfer

mm/dd/yyyy

Transfer Date

absolute

mm/dd/yyyy

Absolute Dimit date

crelease

mm/dd/yyyy

Date that Certificate of Release was issued

from

RALEIGH #735

Lodge transferred from name and number

into

TUSCON EAST 2532

Lodge transferred to name and number

dropped

mm/dd/yyyy

Date member was dropped

suspfrom

mm/dd/yyyy

Suspension start date

suspto

mm/dd/yyyy

Suspension end date

expelled

mm/dd/yyyy

Date member was expelled

reinstated

mm/dd/yyyy

Date reinstated

deceased

mm/dd/yyyy

Date of Death

life

mm/dd/yyyy

Date member became life member

hlife

.T. or .F.

is member a honorary life member

charter

.T. or .F.

is member a charter member

elig

per

.T. or .F.

is member Past Exalted Ruler

peryear

2009

4 digit year member member became Past Exalted Ruler

poy

.T. or .F.

Past Officer of Year

poyyear

2009

Year made POY

pey

.T. or .F.

Past Elk of Year

peyyear

2009

Year made PEY

pdd

.T. or .F.

is Past District Deputy checked off

pddyear

2009

Year made PDD

officer

.T. or .F.

Is member an Officer

office

11 Trustee - Five Year

Current office held at Lodge

enf

.T. or .F.

ENF checked on the screen

enfamt

25

Amount recorded for the ENF

smp

.T. or .F.

State Major Project

smpamt

25

State Major Project dollar Amount

assisted

.T. or .F.

If assisted dues by Lodge

addressalt

Address from the Alt Mail Tab

addressal1

Address 1 from the Alt Mail Tab

cityalt

City from the Alt Mail Tab

statealt

State code from the Alt Mail Tab

zipalt

Zip code from the Alt Mail Tab

countrya

GUAM

Country eneterd in the Country field on the "Alt Mail" tab

carrieralt

Carrier route code Alt Mail Tab

dpcalt

numeric data

mailing address delivery point barcode check digit from the Alt Mail Tab

lotalt

3 digit

123

resultalt

unknown

unknown

addrnalt

unknown

unknown

addressp

Address from the GL Mail Tab

address1p

Address1 field on the GL Mail Tab

cityp

City from the GL Mail Tab

statep

State from the GL Mail Tab

zipp

5 digit zip plus 4

From the Zip field on the GL Mail Tab

carrierp

Alpha numeric code

From the Carrier Route from the GL Mail Tab

wrong

.T. or .F.

Cur Mail Tab Send No Mail checkbox

wrongalt

.T. or .F.

Alt Mail Tab Send No Mail checkbox

notem

.T. or .F.

Cur Mail Tab Send No TEM checkbox

notemalt

.T. or .F.

Alt Mail Tab Send No TEM checkbox

secretary

Secretary Full name for this lodge

er

Exalted Ruler for this lodge

remarks

From the remarks field on the members edit screen

undlv

.T. or .F.

Is undeliverable checked on the Cur Mail Tab

undlvalt

.T. or .F.

is undeliverable checked on the Alt Mail Tab

addressg

Address field on the GL Ship Tab

address1g

Address1 field on the GL Ship Tab

cityg

City on the GL Ship Tab

stateg

State on the GL Ship Tab

zipg

#####-####

Zip code from the GL Mail Tab