contact.contact_date
General info
Column name contact_date
Table name contact
Primary key NO
Foreign key NO
Data type dbDate
Not null YES
Unique NO
Default Date()
Description
Date on which the contact occurred.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact.contact_id
General info
Column name contact_id
Table name contact
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique value on each row of this table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


contact.contact_method_defn_id
General info
Column name contact_method_defn_id
Table name contact
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value indicating the row of the contact_method table representing the contact method (for example, "phone call", "meeting", etc.)
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact.party_id
General info
Column name party_id
Table name contact
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the party involved in the contact.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact.rec_mod_date
General info
Column name rec_mod_date
Table name contact
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact.remk
General info
Column name remk
Table name contact
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about the contact.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact.staff_mbr_id
General info
Column name staff_mbr_id
Table name contact
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value indicating the row of the staff_mbr table representing the staff member involved in the contact.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact_method_defn.abbr
General info
Column name abbr
Table name contact_method_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify the contact method in short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact_method_defn.contact_method_defn_id
General info
Column name contact_method_defn_id
Table name contact_method_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique identifying value on each row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


contact_method_defn.defn
General info
Column name defn
Table name contact_method_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of contact method
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact_subject.contact_id
General info
Column name contact_id
Table name contact_subject
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Number indicating the row of the contact table representing the contact to which this row associates a contact subject.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact_subject.contact_subject_defn_id
General info
Column name contact_subject_defn_id
Table name contact_subject
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value indicating which row of the contact_subject_defn table represents the subject associated with the contact table row indicated on this row.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact_subject.contact_subject_id
General info
Column name contact_subject_id
Table name contact_subject
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique value for each row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


contact_subject_defn.abbr
General info
Column name abbr
Table name contact_subject_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify contact subject within short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


contact_subject_defn.contact_subject_defn_id
General info
Column name contact_subject_defn_id
Table name contact_subject_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned to unique value for each row of table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


contact_subject_defn.defn
General info
Column name defn
Table name contact_subject_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of contact subject.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


county_defn.abbr
General info
Column name abbr
Table name county_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique YES
Description
Abbreviation used to indicate county in short concise displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


county_defn.county_defn_id
General info
Column name county_defn_id
Table name county_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique identifying value for each row of table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


county_defn.defn
General info
Column name defn
Table name county_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full name of county.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.amt_provided
General info
Column name amt_provided
Table name donation
Primary key NO
Foreign key NO
Data type dbCurrency
Not null NO
Unique NO
Description
If the donation is a direct donation (cash, fund transfer, etc.), this column contains the dollar value of the donation.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.donation_date
General info
Column name donation_date
Table name donation
Primary key NO
Foreign key NO
Data type dbDate
Not null YES
Unique NO
Default Date()
Description
The date on which the donation was received, or (for pledged future donations), the date on which the donation is promised.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.donation_id
General info
Column name donation_id
Table name donation
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned to uniquely identify this row within this table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


donation.donation_type_defn_id
General info
Column name donation_type_defn_id
Table name donation
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value representing the row of the donation_type_defn table representing the donation type assigned to this row.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.donation_value
General info
Column name donation_value
Table name donation
Primary key NO
Foreign key NO
Data type dbCurrency
Not null NO
Unique NO
Description
For non-monetary donations, this column contains the estimated dollar value of the donation.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.final_donor_party_id
General info
Column name final_donor_party_id
Table name donation
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value the party to actually transfer funds to the organization. For proxy donations, this references the proxy donor.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.fund_defn_id
General info
Column name fund_defn_id
Table name donation
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referring to the row of the fund_defn table that represents the fund into which this donation will be placed.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.income_category_defn_id
General info
Column name income_category_defn_id
Table name donation
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
Value indicating row of income_category_defn table representing the type of income
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.orig_donor_party_id
General info
Column name orig_donor_party_id
Table name donation
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
In the case of a proxy donation, value identifying the originating donor. The proxy donor will be referenced by the value of the final_donor_party_id column.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.pledge_amt
General info
Column name pledge_amt
Table name donation
Primary key NO
Foreign key NO
Data type dbCurrency
Not null NO
Unique NO
Description
If the donation record is a promised future donation offered as part of a pledge, this column indicates the dollar value of the part of the donation to be paid on the donation date.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.pledge_id
General info
Column name pledge_id
Table name donation
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
For promised donations associated with a pledge, a value referring to the row of the pledge table describing the pledge.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.pledge_yn
General info
Column name pledge_yn
Table name donation
Primary key NO
Foreign key NO
Data type dbBoolean
Not null YES
Unique NO
Default 0
Description
Yes/no indicating whether the row represents a promised donation resulting from a pledge.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.proxy_donation_yn
General info
Column name proxy_donation_yn
Table name donation
Primary key NO
Foreign key NO
Data type dbBoolean
Not null NO
Unique NO
Default 0
Description
Yes/no variable indicating whether the row represents a donation provided for the original donor through a final or proxy donor.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.rec_mod_date
General info
Column name rec_mod_date
Table name donation
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation.remk
General info
Column name remk
Table name donation
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about the donation.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation_type_defn.abbr
General info
Column name abbr
Table name donation_type_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify this donation type in short displays
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation_type_defn.defn
General info
Column name defn
Table name donation_type_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of the donation type
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


donation_type_defn.donation_type_defn_id
General info
Column name donation_type_defn_id
Table name donation_type_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned to uniquely identify this row within this table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


easement_proj.abbr
General info
Column name abbr
Table name easement_proj
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null NO
Unique NO
Description
Abbreviation used to identify the project in pick lists, short displays in reports, etc.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.area_ac
General info
Column name area_ac
Table name easement_proj
Primary key NO
Foreign key NO
Data type dbLong
Not null NO
Unique NO
Description
Area involved in easement, in acres
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.completed_date
General info
Column name completed_date
Table name easement_proj
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.defn
General info
Column name defn
Table name easement_proj
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text name of the project.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.easement_nbr
General info
Column name easement_nbr
Table name easement_proj
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null NO
Unique NO
Description
Identifying number assigned in hard copy filing system
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.easement_proj_id
General info
Column name easement_proj_id
Table name easement_proj
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique value for each row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


easement_proj.ecosystem_defn_id
General info
Column name ecosystem_defn_id
Table name easement_proj
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
Value identifying the row of the ecosystem defn table representing the ecosystem in which the project is located
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.prop_name
General info
Column name prop_name
Table name easement_proj
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
Name of the property involved in the project.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.rec_mod_date
General info
Column name rec_mod_date
Table name easement_proj
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.region_defn_id
General info
Column name region_defn_id
Table name easement_proj
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the row of the region table representing the region in which this project is located.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj.remk
General info
Column name remk
Table name easement_proj
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about the project.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_county.area_ac
General info
Column name area_ac
Table name easement_proj_county
Primary key NO
Foreign key NO
Data type dbSingle
Not null NO
Unique NO
Description
Area involved in easement and falling within the county, in acres
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_county.county_defn_id
General info
Column name county_defn_id
Table name easement_proj_county
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the row of the county defn table representing the county associated with the easement project
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_county.easement_proj_county_id
General info
Column name easement_proj_county_id
Table name easement_proj_county
Primary key YES
Foreign key NO
Data type dbLong
Not null NO
Unique YES
Description
Number assigned a unique value for each row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


easement_proj_county.easement_proj_id
General info
Column name easement_proj_id
Table name easement_proj_county
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the row of the easement project table representing the project associated with the county
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_milestone.easement_proj_id
General info
Column name easement_proj_id
Table name easement_proj_milestone
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the row of the easement_proj table representing the project.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_milestone.easement_proj_milestone_id
General info
Column name easement_proj_milestone_id
Table name easement_proj_milestone
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique value in each row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


easement_proj_milestone.milestone_date
General info
Column name milestone_date
Table name easement_proj_milestone
Primary key NO
Foreign key NO
Data type dbDate
Not null YES
Unique NO
Default Date()
Description
Date on which the milestone represented by this row was reached.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_milestone.milestone_type_id
General info
Column name milestone_type_id
Table name easement_proj_milestone
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the row of the easement milestone table representing the milestone documented here
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_milestone.rec_mod_date
General info
Column name rec_mod_date
Table name easement_proj_milestone
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_party.easement_proj_id
General info
Column name easement_proj_id
Table name easement_proj_party
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the row of the easement_proj table representing the project.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_party.easement_proj_party_id
General info
Column name easement_proj_party_id
Table name easement_proj_party
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique value for each row of the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


easement_proj_party.easement_proj_role_defn_id
General info
Column name easement_proj_role_defn_id
Table name easement_proj_party
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_party.party_id
General info
Column name party_id
Table name easement_proj_party
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the row representing the involved party
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_role_defn.abbr
General info
Column name abbr
Table name easement_proj_role_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique YES
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_role_defn.defn
General info
Column name defn
Table name easement_proj_role_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_role_defn.easement_proj_role_defn_id
General info
Column name easement_proj_role_defn_id
Table name easement_proj_role_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


easement_proj_staff.easement_proj_id
General info
Column name easement_proj_id
Table name easement_proj_staff
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the row of the easement_proj table that represents the project referenced by this row.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_staff.easement_proj_role_defn_id
General info
Column name easement_proj_role_defn_id
Table name easement_proj_staff
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


easement_proj_staff.easement_proj_staff_id
General info
Column name easement_proj_staff_id
Table name easement_proj_staff
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique value for each row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


easement_proj_staff.staff_mbr_id
General info
Column name staff_mbr_id
Table name easement_proj_staff
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value indicating the row of the staff_mbr table identifying the staff member who's role in an easement project is defined by this row.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


ecosystem_defn.abbr
General info
Column name abbr
Table name ecosystem_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to describe region in short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


ecosystem_defn.defn
General info
Column name defn
Table name ecosystem_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition/name of region.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


ecosystem_defn.ecosystem_defn_id
General info
Column name ecosystem_defn_id
Table name ecosystem_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique identifying value for each row of table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


email.address
General info
Column name address
Table name email
Primary key NO
Foreign key NO
Data type dbText Length 60
Not null NO
Unique NO
Description
Full email address.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


email.email_id
General info
Column name email_id
Table name email
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


email.party_id
General info
Column name party_id
Table name email
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value indicating which row of the relation table contains the row this row is associated with.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


email.primary_yn
General info
Column name primary_yn
Table name email
Primary key NO
Foreign key NO
Data type dbBoolean
Not null NO
Unique NO
Description
Yes/no indicating whether the email address on this row is the primary email address to be used for contacting this relation. If several email addresses are entered for one relation, only one of those rows should have a "yes" entered for this column.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


email.rec_mod_date
General info
Column name rec_mod_date
Table name email
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


email.remk
General info
Column name remk
Table name email
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Ancillary information/comments about the email address represented on this row.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


fund_defn.abbr
General info
Column name abbr
Table name fund_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify the fund in short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


fund_defn.defn
General info
Column name defn
Table name fund_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of the fund
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


fund_defn.fund_defn_id
General info
Column name fund_defn_id
Table name fund_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned to uniquely identify this row within this table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


fund_defn.remk
General info
Column name remk
Table name fund_defn
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about fund.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_defn.abbr
General info
Column name abbr
Table name group_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
The abbreviation used to refer to this group in pull-down lists, concise report displays, etc.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_defn.defn
General info
Column name defn
Table name group_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of the group.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_defn.group_defn_id
General info
Column name group_defn_id
Table name group_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


group_defn.group_type_defn_id
General info
Column name group_type_defn_id
Table name group_defn
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referencing the row of the group_type_defn table that describes the group type applied to this group
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_defn.remk
General info
Column name remk
Table name group_defn
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about this group.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_mbr_period.date_end
General info
Column name date_end
Table name group_mbr_period
Primary key NO
Foreign key NO
Data type dbDate
Not null YES
Unique NO
Default DateAdd("yyyy",1,Date())
Description
The end date of the group membership period
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_mbr_period.date_start
General info
Column name date_start
Table name group_mbr_period
Primary key NO
Foreign key NO
Data type dbDate
Not null YES
Unique NO
Default Date()
Description
The start date of the group membership period
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_mbr_period.group_defn_id
General info
Column name group_defn_id
Table name group_mbr_period
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referencing the row of the group table defining the group to which the membership period applies.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_mbr_period.group_mbr_period_id
General info
Column name group_mbr_period_id
Table name group_mbr_period
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


group_mbr_period.party_id
General info
Column name party_id
Table name group_mbr_period
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the party to who the membership is assigned.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_mbr_period.remk
General info
Column name remk
Table name group_mbr_period
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary/comments about the group membership period represented in this record.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_type_defn.abbr
General info
Column name abbr
Table name group_type_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify the group type within short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_type_defn.defn
General info
Column name defn
Table name group_type_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of group type.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


group_type_defn.group_type_defn_id
General info
Column name group_type_defn_id
Table name group_type_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


income_category_defn.abbr
General info
Column name abbr
Table name income_category_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


income_category_defn.defn
General info
Column name defn
Table name income_category_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


income_category_defn.income_category_defn_id
General info
Column name income_category_defn_id
Table name income_category_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


loctn.address_1
General info
Column name address_1
Table name loctn
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
First line of street address
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.address_2
General info
Column name address_2
Table name loctn
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
Second line of street address
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.city
General info
Column name city
Table name loctn
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
The city where this location is found
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.country
General info
Column name country
Table name loctn
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
The name of the country the location falls in
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.county_defn_id
General info
Column name county_defn_id
Table name loctn
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
Foreign key referencing a row of the county table that is defined to represent the county in which this location is located.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.loctn_id
General info
Column name loctn_id
Table name loctn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


loctn.loctn_type_defn_id
General info
Column name loctn_type_defn_id
Table name loctn
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Foreign key referencing the row of the loctn_type_defn table that describes the type of loction represented in the current row
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.organization_name
General info
Column name organization_name
Table name loctn
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
If the location is a business location, the name of the business. This is included here as an elaboration of "address" information, rather than as a record formally representing the business.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.party_id
General info
Column name party_id
Table name loctn
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the party this location is used by
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.postal_code
General info
Column name postal_code
Table name loctn
Primary key NO
Foreign key NO
Data type dbText Length 15
Not null NO
Unique NO
Description
Postal code for the location
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.primary_yn
General info
Column name primary_yn
Table name loctn
Primary key NO
Foreign key NO
Data type dbBoolean
Not null NO
Unique NO
Description
Yes/no indicating whether the location is to be used as the primary location for contacting the "party".
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.rec_mod_date
General info
Column name rec_mod_date
Table name loctn
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.region_defn_id
General info
Column name region_defn_id
Table name loctn
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
Foreign key referencing the row in the region_defn table defined to represent the region in which this location is found.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn.state
General info
Column name state
Table name loctn
Primary key NO
Foreign key NO
Data type dbText Length 30
Not null NO
Unique NO
Description
State/Province where the location is found. For U.S., a two-letter USPS abbreviation.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn_type_defn.abbr
General info
Column name abbr
Table name loctn_type_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique YES
Description
Code used to identify loctn type in concise report displays, etc.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn_type_defn.defn
General info
Column name defn
Table name loctn_type_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text description of the meaning of the location type represented on a row
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


loctn_type_defn.loctn_type_defn_id
General info
Column name loctn_type_defn_id
Table name loctn_type_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


loctn_type_defn.remk
General info
Column name remk
Table name loctn_type_defn
Primary key NO
Foreign key NO
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing meaningful ancillary information or details about the location type represented by a row
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


milestone_type_defn.abbr
General info
Column name abbr
Table name milestone_type_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique YES
Description
Character abbreviation used to label milestone in concise displays such as reports, etc.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


milestone_type_defn.defn
General info
Column name defn
Table name milestone_type_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text description of the milestone
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


milestone_type_defn.milestone_type_id
General info
Column name milestone_type_id
Table name milestone_type_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Counting number assigned to uniquely identify each row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


party.add_date
General info
Column name add_date
Table name party
Primary key NO
Foreign key NO
Data type dbDate
Not null YES
Unique NO
Default Date()
Description
The date on which the row was created.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party.assigned_staff_mbr_id
General info
Column name assigned_staff_mbr_id
Table name party
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Default 25
Description
Value identifying the staff_mbr assigned as primary staff contact.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party.name
General info
Column name name
Table name party
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
The name of the party. For example: "Bradley Family", "George and William Smith", "Mr. and Mrs. Jonnie Johnson", "Buffalo Bros Guitars", "John Henry", etc.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party.party_id
General info
Column name party_id
Table name party
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique identifying value for each row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


party.party_type_defn_id
General info
Column name party_type_defn_id
Table name party
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Indicates the "type" of the "party" (i.e. "business", "familty"...)
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party.rec_mod_date
General info
Column name rec_mod_date
Table name party
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party.remk
General info
Column name remk
Table name party
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Free-text comments about party
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party.salutation
General info
Column name salutation
Table name party
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
Salutation used for the party in letters, etc.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_category.party_category_defn_id
General info
Column name party_category_defn_id
Table name party_category
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the category to be applied.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_category.party_category_id
General info
Column name party_category_id
Table name party_category
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


party_category.party_id
General info
Column name party_id
Table name party_category
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the party to which the category is applied.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_category_defn.abbr
General info
Column name abbr
Table name party_category_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify relation class within short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_category_defn.defn
General info
Column name defn
Table name party_category_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of category
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_category_defn.party_category_defn_id
General info
Column name party_category_defn_id
Table name party_category_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


party_category_defn.remk
General info
Column name remk
Table name party_category_defn
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about the class.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_mbr.party_id
General info
Column name party_id
Table name party_mbr
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the party.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_mbr.party_mbr_id
General info
Column name party_mbr_id
Table name party_mbr
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Unique number assigned to each row of this table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


party_mbr.party_mbr_role_defn_id
General info
Column name party_mbr_role_defn_id
Table name party_mbr
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
Indicates the role played in the "party" by this person (i.e. "mgr", "employee", etc.)
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_mbr.person_id
General info
Column name person_id
Table name party_mbr
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value identifying the person.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_mbr.primary_yn
General info
Column name primary_yn
Table name party_mbr
Primary key NO
Foreign key NO
Data type dbBoolean
Not null NO
Unique NO
Description
Yes/no indicating whether the person plays the role of primary contact for this party (only one "primary" per party)
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_mbr.rec_mod_date
General info
Column name rec_mod_date
Table name party_mbr
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_mbr_role_defn.abbr
General info
Column name abbr
Table name party_mbr_role_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique YES
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_mbr_role_defn.defn
General info
Column name defn
Table name party_mbr_role_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_mbr_role_defn.party_mbr_role_defn_id
General info
Column name party_mbr_role_defn_id
Table name party_mbr_role_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


party_type_defn.abbr
General info
Column name abbr
Table name party_type_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique YES
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_type_defn.defn
General info
Column name defn
Table name party_type_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


party_type_defn.party_type_defn_id
General info
Column name party_type_defn_id
Table name party_type_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


person.birthdate
General info
Column name birthdate
Table name person
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person.name_first
General info
Column name name_first
Table name person
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
First name
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person.name_last
General info
Column name name_last
Table name person
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
Last name
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person.name_middle
General info
Column name name_middle
Table name person
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
Middle name or initial
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) Yes
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person.name_prefix
General info
Column name name_prefix
Table name person
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
Name prefix ("Ms.","Dr.", etc.)
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) Yes
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person.name_suffix
General info
Column name name_suffix
Table name person
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
Name suffix ("III", "PhD", etc.)
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) Yes
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person.person_id
General info
Column name person_id
Table name person
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Unique number assigned to every row in this table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


person.rec_mod_date
General info
Column name rec_mod_date
Table name person
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person.remk
General info
Column name remk
Table name person
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about this person.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) Yes
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person_event.event_date
General info
Column name event_date
Table name person_event
Primary key NO
Foreign key NO
Data type dbDate
Not null YES
Unique NO
Default Date()
Description
The date on which the event occurred.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person_event.person_event_id
General info
Column name person_event_id
Table name person_event
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


person_event.person_event_type_defn_id
General info
Column name person_event_type_defn_id
Table name person_event
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referencing the row of the person_event_type_defn table that properly categorizes the event
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person_event.person_id
General info
Column name person_id
Table name person_event
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referencing the row of the person table describing the person to who the event occurred.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person_event.rec_mod_date
General info
Column name rec_mod_date
Table name person_event
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person_event.remk
General info
Column name remk
Table name person_event
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about the event.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person_event_type_defn.abbr
General info
Column name abbr
Table name person_event_type_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify personal event type in short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person_event_type_defn.defn
General info
Column name defn
Table name person_event_type_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of the personal event type.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


person_event_type_defn.person_event_type_defn_id
General info
Column name person_event_type_defn_id
Table name person_event_type_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


phone.area_code
General info
Column name area_code
Table name phone
Primary key NO
Foreign key NO
Data type dbInteger
Not null YES
Unique NO
Description
Area code portion of the phone number
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.country_code
General info
Column name country_code
Table name phone
Primary key NO
Foreign key NO
Data type dbInteger
Not null NO
Unique NO
Description
Country code portion of the phone number
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.ext
General info
Column name ext
Table name phone
Primary key NO
Foreign key NO
Data type dbInteger
Not null NO
Unique NO
Description
Extension portion of the phone number
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.loctn_id
General info
Column name loctn_id
Table name phone
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
Value referencing the row of the location table to which a phone is related. Mobile phones may be related to a person rather than to a location.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.nbr
General info
Column name nbr
Table name phone
Primary key NO
Foreign key NO
Data type dbText Length 15
Not null NO
Unique NO
Description
Main portion of the phone number. Area code, country code and extension should be stored in other fields designated for that purpose.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.party_id
General info
Column name party_id
Table name phone
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
Description
Value identifying the party using this phone number. If the phone is a mobile phone, it should probably be referenced directly to a party, If it is not a mobile phone, it should probably not be referenced to a "party", but instead to a location.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.phone_id
General info
Column name phone_id
Table name phone
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


phone.phone_type_defn_id
General info
Column name phone_type_defn_id
Table name phone
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referncing the row of the phone_type_defn table defining the type of phone number stored in this row.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.primary_yn
General info
Column name primary_yn
Table name phone
Primary key NO
Foreign key NO
Data type dbBoolean
Not null YES
Unique NO
Description
Yes/no indicating whether this phone is the primary one that should be used for this relation. If several phones are associated with a relation, only one should have a "yes" entered for this column.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.rec_mod_date
General info
Column name rec_mod_date
Table name phone
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone.remk
General info
Column name remk
Table name phone
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone_type_defn.abbr
General info
Column name abbr
Table name phone_type_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique YES
Description
Abbreviation used to identify phone type in short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone_type_defn.defn
General info
Column name defn
Table name phone_type_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of phone type.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


phone_type_defn.phone_type_defn_id
General info
Column name phone_type_defn_id
Table name phone_type_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique identifying value for each row of table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


pledge.party_id
General info
Column name party_id
Table name pledge
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referncing row of party table describing the party making the pledge
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pledge.pledge_date
General info
Column name pledge_date
Table name pledge
Primary key NO
Foreign key NO
Data type dbDate
Not null YES
Unique NO
Description
Date on which the pledge was made
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pledge.pledge_id
General info
Column name pledge_id
Table name pledge
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned to uniquely identify this row among all rows in this table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


pledge.rec_mod_date
General info
Column name rec_mod_date
Table name pledge
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The date on which the record was last modified
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pledge.remk
General info
Column name remk
Table name pledge
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing description, ancillary information and/or comments about the pledge.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pub.abbr
General info
Column name abbr
Table name pub
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique YES
Description
A short abbreviation used to represent a row of the table in concise reports, displays, etc.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pub.defn
General info
Column name defn
Table name pub
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full-text description of the publication represented by the row.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pub.group_defn_id
General info
Column name group_defn_id
Table name pub
Primary key NO
Foreign key YES
Data type dbLong
Not null NO
Unique NO
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pub.pub_id
General info
Column name pub_id
Table name pub
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique NO
Description
Counting number assigned to uniquely identify each row in table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


pub.remk
General info
Column name remk
Table name pub
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Miscellaneous comments about the publication represented by this row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pub_issue.pub_date
General info
Column name pub_date
Table name pub_issue
Primary key NO
Foreign key NO
Data type dbDate
Not null NO
Unique NO
Default Date()
Description
The publication date of the volume/iissue
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pub_issue.pub_id
General info
Column name pub_id
Table name pub_issue
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Number identifying a single associated row of the "pub" table that characterizes the publication represented by this row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pub_issue.pub_issue_id
General info
Column name pub_issue_id
Table name pub_issue
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique NO
Description
Counting number assigned a unique identifying value for each row of the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


pub_issue.remk
General info
Column name remk
Table name pub_issue
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Miscelaneous comments about the volume represented by this row of the table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


pub_issue.title
General info
Column name title
Table name pub_issue
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Title of the publication issue/volume represented by this row of the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


region_defn.abbr
General info
Column name abbr
Table name region_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to describe eocystem in short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


region_defn.defn
General info
Column name defn
Table name region_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition/name of ecosystem.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


region_defn.region_defn_id
General info
Column name region_defn_id
Table name region_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique identifying value for each row of table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


related_person.person_id
General info
Column name person_id
Table name related_person
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referencing the row of the person table to whom the related person applies
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


related_person.related_person_id
General info
Column name related_person_id
Table name related_person
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


related_person.related_person_person_id
General info
Column name related_person_person_id
Table name related_person
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referencing the row of the person table describing the related person.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


related_person.related_person_role_defn_id
General info
Column name related_person_role_defn_id
Table name related_person
Primary key NO
Foreign key YES
Data type dbLong
Not null YES
Unique NO
Description
Value referencing the row of the related_person_role_defn table that defines the relationship of the end person to the start person.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


related_person.remk
General info
Column name remk
Table name related_person
Primary key NO
Foreign key NO
Domain mlr_remk
Data type dbText Length 150
Not null NO
Unique NO
Description
Text providing ancillary information/comments about the relationship represented on this row.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


related_person_role_defn.abbr
General info
Column name abbr
Table name related_person_role_defn
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify related person role in short displays.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


related_person_role_defn.defn
General info
Column name defn
Table name related_person_role_defn
Primary key NO
Foreign key NO
Domain mlr_def
Data type dbText Length 60
Not null NO
Unique NO
Description
Full text definition of role
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


related_person_role_defn.related_person_role_defn_id
General info
Column name related_person_role_defn_id
Table name related_person_role_defn
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Uniquely identifies each row in the table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


rpt_row.row_id_val
General info
Column name row_id_val
Table name rpt_row
Primary key NO
Foreign key NO
Data type dbLong
Not null YES
Unique NO
Description
The primary key value of a row that should be summarized in the report
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


rpt_row.rpt_key
General info
Column name rpt_key
Table name rpt_row
Primary key NO
Foreign key NO
Data type dbText Length 6
Not null YES
Unique NO
Description
Synthesized value that should uniquely identify each report execution for which rows are stored in this table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


rpt_row.rpt_row_id
General info
Column name rpt_row_id
Table name rpt_row
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Integer value uniquely identifying each row in table
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random


staff_mbr.abbr
General info
Column name abbr
Table name staff_mbr
Primary key NO
Foreign key NO
Domain mlr_abbr
Data type dbText Length 25
Not null YES
Unique NO
Description
Abbreviation used to identify the staff member in concise displays like pick lists, reports, etc.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


staff_mbr.current_staff_yn
General info
Column name current_staff_yn
Table name staff_mbr
Primary key NO
Foreign key NO
Data type dbBoolean
Not null NO
Unique NO
Description
Yes/no indicating whether the individual is a current staff member.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


staff_mbr.name_first
General info
Column name name_first
Table name staff_mbr
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
First name of staff member
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


staff_mbr.name_last
General info
Column name name_last
Table name staff_mbr
Primary key NO
Foreign key NO
Data type dbText Length 50
Not null NO
Unique NO
Description
Last name of staff member.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Increment


staff_mbr.staff_mbr_id
General info
Column name staff_mbr_id
Table name staff_mbr
Primary key YES
Foreign key NO
Data type dbLong
Not null YES
Unique YES
Description
Number assigned a unique value for each row in table.
User-defined variables
Name Value
Decimal precision for numeric types
Validation text
Format None
Input Mask
Caption
Allow zero length (for text,memo and hyperlink data types) No
Own format
Descending primary key No
Compress unicode (for text,memo and hyperlink data types) No
Auto number type Random