Column name | contact_date | ||||
Table name | contact | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | YES | ||||
Unique | NO | ||||
Default | Date() |
Date on which the contact occurred. |
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 |
Column name | contact_id | ||||
Table name | contact | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned a unique value on each row of this table. |
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 |
Column name | contact_method_defn_id | ||||
Table name | contact | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value indicating the row of the contact_method table representing the contact method (for example, "phone call", "meeting", etc.) |
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 |
Column name | party_id | ||||
Table name | contact | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the party involved in the contact. |
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 |
Column name | rec_mod_date | ||||
Table name | contact | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | Date() |
The date on which the record was last modified |
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 |
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 |
Text providing ancillary information/comments about the contact. |
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 |
Column name | staff_mbr_id | ||||
Table name | contact | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value indicating the row of the staff_mbr table representing the staff member involved in the contact. |
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 |
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 |
Abbreviation used to identify the contact method in short displays. |
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 |
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 |
Number assigned a unique identifying value on each row of the table. |
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 |
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 |
Full text definition of contact method |
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 |
Column name | contact_id | ||||
Table name | contact_subject | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Number indicating the row of the contact table representing the contact to which this row associates a contact subject. |
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 |
Column name | contact_subject_defn_id | ||||
Table name | contact_subject | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value indicating which row of the contact_subject_defn table represents the subject associated with the contact table row indicated on this row. |
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 |
Column name | contact_subject_id | ||||
Table name | contact_subject | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned a unique value for each row of the table. |
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 |
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 |
Abbreviation used to identify contact subject within short displays. |
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 |
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 |
Number assigned to unique value for each row of table. |
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 |
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 |
Full text definition of contact subject. |
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 |
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 |
Abbreviation used to indicate county in short concise displays. |
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 |
Column name | county_defn_id | ||||
Table name | county_defn | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned a unique identifying value for each row of table. |
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 |
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 |
Full name of county. |
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 |
Column name | amt_provided | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbCurrency | ||||
Not null | NO | ||||
Unique | NO |
If the donation is a direct donation (cash, fund transfer, etc.), this column contains the dollar value of the donation. |
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 |
Column name | donation_date | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | YES | ||||
Unique | NO | ||||
Default | Date() |
The date on which the donation was received, or (for pledged future donations), the date on which the donation is promised. |
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 |
Column name | donation_id | ||||
Table name | donation | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned to uniquely identify this row within this table |
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 |
Column name | donation_type_defn_id | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value representing the row of the donation_type_defn table representing the donation type assigned to this row. |
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 |
Column name | donation_value | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbCurrency | ||||
Not null | NO | ||||
Unique | NO |
For non-monetary donations, this column contains the estimated dollar value of the donation. |
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 |
Column name | final_donor_party_id | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value the party to actually transfer funds to the organization. For proxy donations, this references the proxy donor. |
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 |
Column name | fund_defn_id | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value referring to the row of the fund_defn table that represents the fund into which this donation will be placed. |
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 |
Column name | income_category_defn_id | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
Value indicating row of income_category_defn table representing the type of income |
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 |
Column name | orig_donor_party_id | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
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. |
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 |
Column name | pledge_amt | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbCurrency | ||||
Not null | NO | ||||
Unique | NO |
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. |
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 |
Column name | pledge_id | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
For promised donations associated with a pledge, a value referring to the row of the pledge table describing the pledge. |
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 |
Column name | pledge_yn | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbBoolean | ||||
Not null | YES | ||||
Unique | NO | ||||
Default | 0 |
Yes/no indicating whether the row represents a promised donation resulting from a pledge. |
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 |
Column name | proxy_donation_yn | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbBoolean | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | 0 |
Yes/no variable indicating whether the row represents a donation provided for the original donor through a final or proxy donor. |
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 |
Column name | rec_mod_date | ||||
Table name | donation | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | Date() |
The date on which the record was last modified |
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 |
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 |
Text providing ancillary information/comments about the donation. |
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 |
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 |
Abbreviation used to identify this donation type in short displays |
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 |
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 |
Full text definition of the donation type |
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 |
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 |
Number assigned to uniquely identify this row within this table. |
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 |
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 |
Abbreviation used to identify the project in pick lists, short displays in reports, etc. |
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 |
Column name | area_ac | ||||
Table name | easement_proj | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
Area involved in easement, in acres |
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 |
Column name | completed_date | ||||
Table name | easement_proj | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO |
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 |
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 |
Full text name of the project. |
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 |
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 |
Identifying number assigned in hard copy filing system |
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 |
Column name | easement_proj_id | ||||
Table name | easement_proj | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned a unique value for each row of the table. |
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 |
Column name | ecosystem_defn_id | ||||
Table name | easement_proj | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
Value identifying the row of the ecosystem defn table representing the ecosystem in which the project is located |
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 |
Column name | prop_name | ||||
Table name | easement_proj | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
Name of the property involved in the project. |
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 |
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() |
The date on which the record was last modified |
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 |
Column name | region_defn_id | ||||
Table name | easement_proj | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the row of the region table representing the region in which this project is located. |
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 |
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 |
Text providing ancillary information/comments about the project. |
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 |
Column name | area_ac | ||||
Table name | easement_proj_county | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbSingle | ||||
Not null | NO | ||||
Unique | NO |
Area involved in easement and falling within the county, in acres |
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 |
Column name | county_defn_id | ||||
Table name | easement_proj_county | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the row of the county defn table representing the county associated with the easement project |
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 |
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 |
Number assigned a unique value for each row of the table. |
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 |
Column name | easement_proj_id | ||||
Table name | easement_proj_county | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the row of the easement project table representing the project associated with the county |
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 |
Column name | easement_proj_id | ||||
Table name | easement_proj_milestone | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the row of the easement_proj table representing the project. |
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 |
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 |
Number assigned a unique value in each row of the table. |
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 |
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() |
Date on which the milestone represented by this row was reached. |
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 |
Column name | milestone_type_id | ||||
Table name | easement_proj_milestone | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the row of the easement milestone table representing the milestone documented here |
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 |
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() |
The date on which the record was last modified |
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 |
Column name | easement_proj_id | ||||
Table name | easement_proj_party | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the row of the easement_proj table representing the project. |
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 |
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 |
Number assigned a unique value for each row of the table |
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 |
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 |
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 |
Column name | party_id | ||||
Table name | easement_proj_party | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the row representing the involved party |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Column name | easement_proj_id | ||||
Table name | easement_proj_staff | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the row of the easement_proj table that represents the project referenced by this row. |
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 |
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 |
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 |
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 |
Number assigned a unique value for each row of the table. |
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 |
Column name | staff_mbr_id | ||||
Table name | easement_proj_staff | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
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. |
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 |
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 |
Abbreviation used to describe region in short displays. |
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 |
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 |
Full text definition/name of region. |
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 |
Column name | ecosystem_defn_id | ||||
Table name | ecosystem_defn | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned a unique identifying value for each row of table. |
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 |
Column name | address | ||||
Table name | |||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 60 | ||
Not null | NO | ||||
Unique | NO |
Full email address. |
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 |
Column name | email_id | ||||
Table name | |||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Uniquely identifies each row in the table |
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 |
Column name | party_id | ||||
Table name | |||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value indicating which row of the relation table contains the row this row is associated with. |
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 |
Column name | primary_yn | ||||
Table name | |||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbBoolean | ||||
Not null | NO | ||||
Unique | NO |
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. |
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 |
Column name | rec_mod_date | ||||
Table name | |||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | Date() |
The date on which the record was last modified |
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 |
Column name | remk | ||||
Table name | |||||
Primary key | NO | ||||
Foreign key | NO | ||||
Domain | mlr_remk | ||||
Data type | dbText | Length | 150 | ||
Not null | NO | ||||
Unique | NO |
Ancillary information/comments about the email address represented on this row. |
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 |
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 |
Abbreviation used to identify the fund in short displays. |
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 |
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 |
Full text definition of the fund |
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 |
Column name | fund_defn_id | ||||
Table name | fund_defn | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned to uniquely identify this row within this table |
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 |
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 |
Text providing ancillary information/comments about fund. |
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 |
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 |
The abbreviation used to refer to this group in pull-down lists, concise report displays, etc. |
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 |
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 |
Full text definition of the group. |
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 |
Column name | group_defn_id | ||||
Table name | group_defn | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Uniquely identifies each row in the table |
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 |
Column name | group_type_defn_id | ||||
Table name | group_defn | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value referencing the row of the group_type_defn table that describes the group type applied to this group |
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 |
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 |
Text providing ancillary information/comments about this group. |
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 |
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()) |
The end date of the group membership period |
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 |
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() |
The start date of the group membership period |
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 |
Column name | group_defn_id | ||||
Table name | group_mbr_period | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value referencing the row of the group table defining the group to which the membership period applies. |
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 |
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 |
Uniquely identifies each row in the table |
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 |
Column name | party_id | ||||
Table name | group_mbr_period | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the party to who the membership is assigned. |
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 |
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 |
Text providing ancillary/comments about the group membership period represented in this record. |
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 |
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 |
Abbreviation used to identify the group type within short displays. |
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 |
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 |
Full text definition of group type. |
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 |
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 |
Uniquely identifies each row in the table |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Column name | address_1 | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
First line of street address |
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 |
Column name | address_2 | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
Second line of street address |
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 |
Column name | city | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
The city where this location is found |
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 |
Column name | country | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
The name of the country the location falls in |
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 |
Column name | county_defn_id | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
Foreign key referencing a row of the county table that is defined to represent the county in which this location is located. |
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 |
Column name | loctn_id | ||||
Table name | loctn | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Uniquely identifies each row in the table |
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 |
Column name | loctn_type_defn_id | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Foreign key referencing the row of the loctn_type_defn table that describes the type of loction represented in the current row |
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 |
Column name | organization_name | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
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. |
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 |
Column name | party_id | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the party this location is used by |
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 |
Column name | postal_code | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 15 | ||
Not null | NO | ||||
Unique | NO |
Postal code for the location |
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 |
Column name | primary_yn | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbBoolean | ||||
Not null | NO | ||||
Unique | NO |
Yes/no indicating whether the location is to be used as the primary location for contacting the "party". |
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 |
Column name | rec_mod_date | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | Date() |
The date on which the record was last modified |
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 |
Column name | region_defn_id | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
Foreign key referencing the row in the region_defn table defined to represent the region in which this location is found. |
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 |
Column name | state | ||||
Table name | loctn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 30 | ||
Not null | NO | ||||
Unique | NO |
State/Province where the location is found. For U.S., a two-letter USPS abbreviation. |
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 |
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 |
Code used to identify loctn type in concise report displays, etc. |
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 |
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 |
Full text description of the meaning of the location type represented on a row |
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 |
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 |
Uniquely identifies each row in the table |
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 |
Column name | remk | ||||
Table name | loctn_type_defn | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 150 | ||
Not null | NO | ||||
Unique | NO |
Text providing meaningful ancillary information or details about the location type represented by a row |
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 |
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 |
Character abbreviation used to label milestone in concise displays such as reports, etc. |
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 |
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 |
Full text description of the milestone |
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 |
Column name | milestone_type_id | ||||
Table name | milestone_type_defn | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Counting number assigned to uniquely identify each row of the table. |
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 |
Column name | add_date | ||||
Table name | party | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | YES | ||||
Unique | NO | ||||
Default | Date() |
The date on which the row was created. |
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 |
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 |
Value identifying the staff_mbr assigned as primary staff contact. |
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 |
Column name | name | ||||
Table name | party | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
The name of the party. For example: "Bradley Family", "George and William Smith", "Mr. and Mrs. Jonnie Johnson", "Buffalo Bros Guitars", "John Henry", etc. |
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 |
Column name | party_id | ||||
Table name | party | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned a unique identifying value for each row of the table. |
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 |
Column name | party_type_defn_id | ||||
Table name | party | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Indicates the "type" of the "party" (i.e. "business", "familty"...) |
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 |
Column name | rec_mod_date | ||||
Table name | party | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO |
The date on which the record was last modified |
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 |
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 |
Free-text comments about party |
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 |
Column name | salutation | ||||
Table name | party | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
Salutation used for the party in letters, etc. |
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 |
Column name | party_category_defn_id | ||||
Table name | party_category | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the category to be applied. |
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 |
Column name | party_category_id | ||||
Table name | party_category | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Uniquely identifies each row in the table |
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 |
Column name | party_id | ||||
Table name | party_category | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the party to which the category is applied. |
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 |
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 |
Abbreviation used to identify relation class within short displays. |
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 |
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 |
Full text definition of category |
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 |
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 |
Uniquely identifies each row in the table |
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 |
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 |
Text providing ancillary information/comments about the class. |
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 |
Column name | party_id | ||||
Table name | party_mbr | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the party. |
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 |
Column name | party_mbr_id | ||||
Table name | party_mbr | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Unique number assigned to each row of this table. |
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 |
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 |
Indicates the role played in the "party" by this person (i.e. "mgr", "employee", etc.) |
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 |
Column name | person_id | ||||
Table name | party_mbr | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value identifying the person. |
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 |
Column name | primary_yn | ||||
Table name | party_mbr | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbBoolean | ||||
Not null | NO | ||||
Unique | NO |
Yes/no indicating whether the person plays the role of primary contact for this party (only one "primary" per party) |
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 |
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() |
The date on which the record was last modified |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Column name | birthdate | ||||
Table name | person | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO |
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 |
Column name | name_first | ||||
Table name | person | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
First name |
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 |
Column name | name_last | ||||
Table name | person | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
Last name |
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 |
Column name | name_middle | ||||
Table name | person | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
Middle name or initial |
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 |
Column name | name_prefix | ||||
Table name | person | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
Name prefix ("Ms.","Dr.", etc.) |
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 |
Column name | name_suffix | ||||
Table name | person | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
Name suffix ("III", "PhD", etc.) |
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 |
Column name | person_id | ||||
Table name | person | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Unique number assigned to every row in this table |
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 |
Column name | rec_mod_date | ||||
Table name | person | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | Date() |
The date on which the record was last modified |
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 |
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 |
Text providing ancillary information/comments about this person. |
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 |
Column name | event_date | ||||
Table name | person_event | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | YES | ||||
Unique | NO | ||||
Default | Date() |
The date on which the event occurred. |
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 |
Column name | person_event_id | ||||
Table name | person_event | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Uniquely identifies each row in the table |
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 |
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 |
Value referencing the row of the person_event_type_defn table that properly categorizes the event |
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 |
Column name | person_id | ||||
Table name | person_event | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value referencing the row of the person table describing the person to who the event occurred. |
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 |
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() |
The date on which the record was last modified |
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 |
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 |
Text providing ancillary information/comments about the event. |
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 |
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 |
Abbreviation used to identify personal event type in short displays. |
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 |
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 |
Full text definition of the personal event type. |
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 |
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 |
Uniquely identifies each row in the table |
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 |
Column name | area_code | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbInteger | ||||
Not null | YES | ||||
Unique | NO |
Area code portion of the phone number |
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 |
Column name | country_code | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbInteger | ||||
Not null | NO | ||||
Unique | NO |
Country code portion of the phone number |
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 |
Column name | ext | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbInteger | ||||
Not null | NO | ||||
Unique | NO |
Extension portion of the phone number |
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 |
Column name | loctn_id | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
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. |
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 |
Column name | nbr | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 15 | ||
Not null | NO | ||||
Unique | NO |
Main portion of the phone number. Area code, country code and extension should be stored in other fields designated for that purpose. |
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 |
Column name | party_id | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
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. |
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 |
Column name | phone_id | ||||
Table name | phone | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Uniquely identifies each row in the table |
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 |
Column name | phone_type_defn_id | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value referncing the row of the phone_type_defn table defining the type of phone number stored in this row. |
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 |
Column name | primary_yn | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbBoolean | ||||
Not null | YES | ||||
Unique | NO |
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. |
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 |
Column name | rec_mod_date | ||||
Table name | phone | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | Date() |
The date on which the record was last modified |
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 |
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 |
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 |
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 |
Abbreviation used to identify phone type in short displays. |
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 |
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 |
Full text definition of phone type. |
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 |
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 |
Number assigned a unique identifying value for each row of table. |
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 |
Column name | party_id | ||||
Table name | pledge | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value referncing row of party table describing the party making the pledge |
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 |
Column name | pledge_date | ||||
Table name | pledge | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | YES | ||||
Unique | NO |
Date on which the pledge was made |
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 |
Column name | pledge_id | ||||
Table name | pledge | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned to uniquely identify this row among all rows in this table. |
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 |
Column name | rec_mod_date | ||||
Table name | pledge | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | Date() |
The date on which the record was last modified |
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 |
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 |
Text providing description, ancillary information and/or comments about the pledge. |
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 |
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 |
A short abbreviation used to represent a row of the table in concise reports, displays, etc. |
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 |
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 |
Full-text description of the publication represented by the row. |
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 |
Column name | group_defn_id | ||||
Table name | pub | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | NO | ||||
Unique | NO |
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 |
Column name | pub_id | ||||
Table name | pub | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Counting number assigned to uniquely identify each row in table |
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 |
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 |
Miscellaneous comments about the publication represented by this row of the table. |
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 |
Column name | pub_date | ||||
Table name | pub_issue | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbDate | ||||
Not null | NO | ||||
Unique | NO | ||||
Default | Date() |
The publication date of the volume/iissue |
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 |
Column name | pub_id | ||||
Table name | pub_issue | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Number identifying a single associated row of the "pub" table that characterizes the publication represented by this row of the table. |
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 |
Column name | pub_issue_id | ||||
Table name | pub_issue | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Counting number assigned a unique identifying value for each row of the table |
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 |
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 |
Miscelaneous comments about the volume represented by this row of the table. |
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 |
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 |
Title of the publication issue/volume represented by this row of the table |
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 |
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 |
Abbreviation used to describe eocystem in short displays. |
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 |
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 |
Full text definition/name of ecosystem. |
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 |
Column name | region_defn_id | ||||
Table name | region_defn | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned a unique identifying value for each row of table. |
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 |
Column name | person_id | ||||
Table name | related_person | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value referencing the row of the person table to whom the related person applies |
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 |
Column name | related_person_id | ||||
Table name | related_person | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Uniquely identifies each row in the table |
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 |
Column name | related_person_person_id | ||||
Table name | related_person | ||||
Primary key | NO | ||||
Foreign key | YES | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
Value referencing the row of the person table describing the related person. |
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 |
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 |
Value referencing the row of the related_person_role_defn table that defines the relationship of the end person to the start person. |
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 |
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 |
Text providing ancillary information/comments about the relationship represented on this row. |
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 |
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 |
Abbreviation used to identify related person role in short displays. |
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 |
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 |
Full text definition of role |
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 |
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 |
Uniquely identifies each row in the table |
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 |
Column name | row_id_val | ||||
Table name | rpt_row | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | NO |
The primary key value of a row that should be summarized in the report |
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 |
Column name | rpt_key | ||||
Table name | rpt_row | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 6 | ||
Not null | YES | ||||
Unique | NO |
Synthesized value that should uniquely identify each report execution for which rows are stored in this table |
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 |
Column name | rpt_row_id | ||||
Table name | rpt_row | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Integer value uniquely identifying each row in table |
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 |
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 |
Abbreviation used to identify the staff member in concise displays like pick lists, reports, etc. |
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 |
Column name | current_staff_yn | ||||
Table name | staff_mbr | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbBoolean | ||||
Not null | NO | ||||
Unique | NO |
Yes/no indicating whether the individual is a current staff member. |
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 |
Column name | name_first | ||||
Table name | staff_mbr | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
First name of staff member |
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 |
Column name | name_last | ||||
Table name | staff_mbr | ||||
Primary key | NO | ||||
Foreign key | NO | ||||
Data type | dbText | Length | 50 | ||
Not null | NO | ||||
Unique | NO |
Last name of staff member. |
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 |
Column name | staff_mbr_id | ||||
Table name | staff_mbr | ||||
Primary key | YES | ||||
Foreign key | NO | ||||
Data type | dbLong | ||||
Not null | YES | ||||
Unique | YES |
Number assigned a unique value for each row in table. |
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 |