CLMS Extraction Fields

Description

Example

Comm Member Number

6 digit member number for committeeman

123456

Comm Number

Alpahbetic + digits

stat25

Comm Position

Committee Position Name

Chairperson, Coordinator, Member

CLMS Extraction Fields

Description

Example

Committee Name

Committee Name

Accident, Drug Aware, Youth Activities

Committee Number

2 digit committee number

1, 4, 19 numbers reflect committee names above

CLMS Extraction Fields

Description

Example

Absolute Dimit Date

Absolute Dimit Effective Date

mm/dd/yyyy

Active Members

Member Active

True/False

Added Members this year

Member was added during current year

True/False

Address - First Part

Address text box on the current Address tab

Address - Second Part

Address 1 text box on the current Address tab

ADDRESS ALL

Address - 2nd Part, followed by CR, then Address - 1st Part

UNIT 1

425 N DIVERSEY PRKWAY

Affiliation Date

Date Affiliated with this lodge

mm/dd/yyyy

Age

members/candidates age

Anniversary

wedding anniversary month/day for sending cards

mm/dd

Area Code for Home Phone

3 digit area code for home number

Area Code for Work Phone

3 digit area code for work phone

Assisted - Dues Remitted

If assisted dues by Lodge

T/F

Birth "Day"

birth day number format

numbers 1 through 31

Birth "Month"

birth date month

1-12

Birth "Year"

4 digit birth year

YYYY

Birth Date

Complete bith date

mm/dd/yyyy

Bulletin Label List

Indicates if Send no mail is checked on the current address tab

T if checked F if blank

Carrier Route

carrier route code on the Cur Mail tab

Cell Area Code

3 digit cell area code

Cell Number

7 digit phone number

Cert. of Release

Certificate of release issued date

mm/dd/yyyy

City of Residence

City for primary residence in Cur Mail Tab

City State Zip

City State and Zip from Cur Mail Tab

City, St #####

Date Dues Paid To

Date dues are paid to

mm/dd/yyyy

Date today

Today's Date

mm/dd/yyyy

Deceased Date

Date of candidates/members death

mm/dd/yyyy

Delinquent members - ALL

Is member delinquent

T/F

Dpc

mailing address delivery point barcode check digit

numeric data

Dropped Date for non-pay

Date dropped for nonpayment of dues

mm/dd/yyyy

Elected Date into order

Date elected

mm/dd/yyyy

Elks National Foundation

ENF checked on the screen

T/F

ELKYEAR

starting date for the current elk year

mm/dd/yyyy

E-mail Address

member/candidate's email

Exalted Ruler at Entry

Name of the Exalted Ruler at time of entry into Lodge

Expelled From Order Date

Date member was expelled

mm/dd/yyyy

Fax Area Code

members/candidates Fax 3 digit area code

Fax Number

members/candidates Fax 7 digit number

First Middle Last

members/candidates name first middle initial last

JOHN D DOE

First Name

members/candidates first name

Frank Addressal1

Address1 from Alt Mail Tab

Frank Addressalt

Address from the Alt Mail Tab

Frank Carrieralt

Carrier route code from Alt Mail Tab

Frank Charter

Is this a charter member

T/F

Frank Cityalt

members/candidates City Alt Mail Tab

Frank DpcALT

mailing address delivery point barcode check digit

numeric data

Frank Enfamt

Amount recorded for ENF to the right of the ENF check box on members edit screen

Frank Forum

Affiliated with Forum

T/F

Frank Lot

3 digit

123

Frank Lotp

3 digit

123

Frank Pdd

Past District Deputy PDD check box on members edit screen

Frank Pddyear

The year the person became a PDD to the right of the PDD check box

Frank Pey

Past Elk of Year

T/F

Frank Peyyear

Year made PEY

YYYY

Frank Poy

Past Officer of Year

T/F

Frank Poyyear

Year made POY

YYYY

Frank Smp

State Major Project

T/F

Frank Smpamt

State Major Project Amount

dollar amount

Frank Statealt

State Code from the Alt Mail Tab

IL, NY, CA

Frank Statep

State Code from the GL Mail Tab

Frank Zipalt

Zip code from the Alt Mail Tab

Frank Zipp

Zip + 4 digit carrier route code from the GL Mail Tab

12345-6789

Home Telephone Number

7 digit home phone number from Ph/email Tab

Indoctrination Date

Date of Indoctrination on members edit screen

mm/dd/yyyy

Initiation Date into order

Date of Initiation on members edit screen

mm/dd/yyyy

Initiation Month

Full name of month initiated

November, December, July

Is Honorary Life Member

Indicates whether the Honorary check box is checked on the members edit screen

T/F

Is Officer

Is member an officer

T/F

Last Name, First & Middle

Last Name followed by a comma First Name space then  middle initial and a period

DOE, JOHN D.

Last, First Middle

Last Name followed by a comma First Name space then  middle initial and a period

DOE, JOHN D.

Life - Date made Life Memb

Date member became life member

mm/dd/yyyy

Lodge from into ours

Lodge transferred from name and number

RALEIGH NC #735 

Lodge into from ours

Lodge transferred to name and number

TUCSON EAST 2532   

Lodge of Initiatioin

Original Lodge initiated in 4 digit lodge number

MESA BUCKHORN #2656  

Lost Years in the Order

Lost years shown on the members edit screen

Member's Number

Member's 6 digit member number

123456

Middle Name

Middle name only

Month - Affiliated

Fully spelled month that member was affiliated

July, August, November

Month - Initiated

Initiated Month full name

November, July, August

Month - Reinstated

Reinstatement Month full name

November, July, August

Month of the YEAR

Current Numeric Month

1-12

New Members

Initiated in current year?

T/F

Occupation now or retired

Description of occupation

Office in the Lodge now

Current office held at the lodge

09 Trustee - Three Year

Past Exalted Ruler

Is member a Past Exalted Ruler

T/F

PER Year XX.XX

4 digit year member became an Past Exalted Ruler

YYYY

Proposed Date

Date Member/Candidate was proposed

mm/dd/yyyy

Proposer Into the Order

name of member that proposed member/candidate

Record number

number of record in database

Reinstatement Date

Date of reinstatement

mm/dd/yyyy

Salutation

Usually First Name

Secretary at time of entry

Name of the Secretary at time of entry into this lodge

Send no mail

is no mail checked on current address tab

T/F

Spouse Birthdate

Spouse's month and day of birth

mm/dd

Spouse Cards to Print

Is ID Card checkbox checked on members edit screen

T/F

Spouse First Name

First name of spouse

Spouse Full Name

Spouse's full name

JANE DOE/JOHN DOE

State

Two Character State code on the Cur Mail tab

IL, CA, HI

Suspension End Date

Date a suspension ends

mm/dd/yyyy

Suspension Start Date

Date a suspension starts

mm/dd/yyyy

Transfer Out Date

Members Transfer date

mm/dd/yyyy

Veteran

Is person a veteran

T/F

Where Born

Location of birth

Work Phone Number

7 digit phone number located on the Ph/email tab

Years an Elks

Years member has been an ELK

ZIP 5

5 digit zip code

12345

ZIP Code

5 digit zip code + "-" + zip4

12345-1234