| point_id |
| Logical Only | NO |
| Definition | Unique ID assigned to each point by the NCRDS database software |
| Note |
| point_id Logical Attribute Properties |
| Logical Attribute Name | point_id |
| Datatype | INTEGER |
| Nullable | NO |
| point_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| point_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | point_id | point_id | unit | INTEGER | point_id | Unique ID assigned to each point by the NCRDS database software |
| point_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| unit_id |
| Logical Only | NO |
| Definition | Stratigraphic unit ID, part of primary key along with point_id column |
| Note |
| unit_id Logical Attribute Properties |
| Logical Attribute Name | unit_id |
| Datatype | NUMERIC(4, 0) |
| Nullable | NO |
| unit_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| unit_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | unit_id | unit_id | unit | NUMERIC | unit_id | Stratigraphic unit ID, part of primary key along with point_id column |
| unit_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| unit_qualifier_cd |
| Logical Only | NO |
| Definition | 1-4 letter codes to qualify or highlight specific information for the rock unit. A - sample analysis done: lab number in Unit Comment. B - boundary (base or top of group, formation, etc.): detail in Unit Comment. C - coal thickness for resource calculation if different than thickness measurement: thickness entered in Unit Comment. D - interbedded: all interbedded lithologies listed in Unit Comment. E - elevation recorded: elevation value recorded in Unit Comment. F - floor rock G - gradational I - incomplete thickness. K - coal burned: may be no thickness measurement. L - change in log type: indicated in Unit Comment. M - estimated thickness, +/- value presented. N - interlaminated: all lithologies listed in Unit Comment. O - no thickness measurement available, but bed is, or was present, as in inferred on mine map but thickness value not released by company. R - roof rock S - sample has been collected. U - uncertain - refers to name of bed. V - validated (if only part of the section has been validated). W - weathering: described in Unit Comment with weathering code. X - extrapolated thickness: do not use this unit for coal resource calculation. Y - May be mine map data with elevation but thickness not revealed. Bed may be X feet below observed marker bed, therefore, both elevation and thickness are derived. May be useful for control of isopach or structure contour. Z - zone |
| Note |
| unit_qualifier_cd Logical Attribute Properties |
| Logical Attribute Name | unit_qualifier_cd |
| Datatype | VARCHAR(4) |
| Nullable | NO |
| unit_qualifier_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| unit_qualifier_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | unit_qualifier_cd | unit_qualifier_cd | unit | VARCHAR | unit_qualifier_cd | 1-4 letter codes to qualify or highlight specific information for the rock unit. A - sample analysis done: lab number in Unit Comment. B - boundary (base or top of group, formation, etc.): detail in Unit Comment. C - coal thickness for resource calculation if different than thickness measurement: thickness entered in Unit Comment. D - interbedded: all interbedded lithologies listed in Unit Comment. E - elevation recorded: elevation value recorded in Unit Comment. F - floor rock G - gradational I - incomplete thickness. K - coal burned: may be no thickness measurement. L - change in log type: indicated in Unit Comment. M - estimated thickness, +/- value presented. N - interlaminated: all lithologies listed in Unit Comment. O - no thickness measurement available, but bed is, or was present, as in inferred on mine map but thickness value not released by company. R - roof rock S - sample has been collected. U - uncertain - refers to name of bed. V - validated (if only part of the section has been validated). W - weathering: described in Unit Comment with weathering code. X - extrapolated thickness: do not use this unit for coal resource calculation. Y - May be mine map data with elevation but thickness not revealed. Bed may be X feet below observed marker bed, therefore, both elevation and thickness are derived. May be useful for control of isopach or structure contour. Z - zone |
| unit_qualifier_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| from_depth_va |
| Logical Only | NO |
| Definition | Depth below surface to top of stratigraphic unit in meters. |
| Note |
| from_depth_va Logical Attribute Properties |
| Logical Attribute Name | from_depth_va |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| from_depth_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| from_depth_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | from_depth_va | from_depth_va | unit | NUMERIC | from_depth_va | Depth below surface to top of stratigraphic unit in meters. |
| from_depth_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| to_depth_va |
| Logical Only | NO |
| Definition | Depth below surface to bottom of stratigraphic unit in decimal meters. |
| Note |
| to_depth_va Logical Attribute Properties |
| Logical Attribute Name | to_depth_va |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| to_depth_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| to_depth_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | to_depth_va | to_depth_va | unit | NUMERIC | to_depth_va | Depth below surface to bottom of stratigraphic unit in decimal meters. |
| to_depth_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| thickness_va |
| Logical Only | NO |
| Definition | Thickness of stratigraphic unit in meters. |
| Note |
| thickness_va Logical Attribute Properties |
| Logical Attribute Name | thickness_va |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| thickness_va Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| thickness_va Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | thickness_va | thickness_va | unit | NUMERIC | thickness_va | Thickness of stratigraphic unit in meters. |
| thickness_va User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| formation_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_formation |
| Note |
| formation_id Logical Attribute Properties |
| Logical Attribute Name | formation_id |
| Datatype | INTEGER |
| Nullable | NO |
| formation_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| formation_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | formation_id | formation_id | unit | INTEGER | formation_id | Unique ID for code table, d_formation |
| formation_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| bed_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_bed |
| Note |
| bed_id Logical Attribute Properties |
| Logical Attribute Name | bed_id |
| Datatype | INTEGER |
| Nullable | NO |
| bed_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| bed_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | bed_id | bed_id | unit | INTEGER | bed_id | Unique ID for code table, d_bed |
| bed_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| subzone_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_subzone |
| Note |
| subzone_id Logical Attribute Properties |
| Logical Attribute Name | subzone_id |
| Datatype | INTEGER |
| Nullable | NO |
| subzone_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| subzone_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | subzone_id | subzone_id | unit | INTEGER | subzone_id | Unique ID for code table, d_subzone |
| subzone_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| resource_zone_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_resource_zone |
| Note |
| resource_zone_id Logical Attribute Properties |
| Logical Attribute Name | resource_zone_id |
| Datatype | INTEGER |
| Nullable | NO |
| resource_zone_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| resource_zone_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | resource_zone_id | resource_zone_id | unit | INTEGER | resource_zone_id | Unique ID for code table, d_resource_zone |
| resource_zone_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| analyticalid_cd |
| Logical Only | NO |
| Definition | Coal quality database ID assigned to the coal interval |
| Note |
| analyticalid_cd Logical Attribute Properties |
| Logical Attribute Name | analyticalid_cd |
| Datatype | VARCHAR(28) |
| Nullable | NO |
| analyticalid_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| analyticalid_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | analyticalid_cd | analyticalid_cd | unit | VARCHAR | analyticalid_cd | Coal quality database ID assigned to the coal interval |
| analyticalid_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| unit_usage_id |
| Logical Only | NO |
| Definition | Unique ID for code table, d_unit_usage |
| Note |
| unit_usage_id Logical Attribute Properties |
| Logical Attribute Name | unit_usage_id |
| Datatype | INTEGER |
| Nullable | NO |
| unit_usage_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| unit_usage_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | unit_usage_id | unit_usage_id | unit | INTEGER | unit_usage_id | Unique ID for code table, d_unit_usage |
| unit_usage_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| lithology_id |
| Logical Only | NO |
| Definition | Unique ID for d_lithology code table |
| Note |
| lithology_id Logical Attribute Properties |
| Logical Attribute Name | lithology_id |
| Datatype | INTEGER |
| Nullable | NO |
| lithology_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| lithology_id Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | lithology_id | lithology_id | unit | INTEGER | lithology_id | Unique ID for d_lithology code table |
| lithology_id User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| lith_modifier_cd |
| Logical Only | NO |
| Definition | Code to indicate additional lithology(ies) observed. |
| Note |
| lith_modifier_cd Logical Attribute Properties |
| Logical Attribute Name | lith_modifier_cd |
| Datatype | VARCHAR(12) |
| Nullable | NO |
| lith_modifier_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| lith_modifier_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | lith_modifier_cd | lith_modifier_cd | unit | VARCHAR | lith_modifier_cd | Code to indicate additional lithology(ies) observed. |
| lith_modifier_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| color_cd |
| Logical Only | NO |
| Definition | GSA international standard color abbreviations are preferable. Use dash (-) instead of slash (/), e.g., 10yr7-4. If GSA abbreviations list available, use NCRDS abbreviation list; the only acceptable punctuation is a dash (-) or ampersand. |
| Note |
| color_cd Logical Attribute Properties |
| Logical Attribute Name | color_cd |
| Datatype | VARCHAR(8) |
| Nullable | NO |
| color_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| color_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | color_cd | color_cd | unit | VARCHAR | color_cd | The organization for which the original collector of the data works (abbreviated). |
| color_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| grain_size_cd |
| Logical Only | NO |
| Definition | Grain size from Wentworth scale. |
| Note |
| grain_size_cd Logical Attribute Properties |
| Logical Attribute Name | grain_size_cd |
| Datatype | VARCHAR(8) |
| Nullable | NO |
| grain_size_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| grain_size_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | grain_size_cd | grain_size_cd | unit | VARCHAR | grain_size_cd | Grain size from Wentworth scale. |
| grain_size_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| grain_shape_cd |
| Logical Only | NO |
| Definition | Description of grain shape, using NCRDS abbreviation list. |
| Note |
| grain_shape_cd Logical Attribute Properties |
| Logical Attribute Name | grain_shape_cd |
| Datatype | VARCHAR(8) |
| Nullable | NO |
| grain_shape_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| grain_shape_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | grain_shape_cd | grain_shape_cd | unit | VARCHAR | grain_shape_cd | Description of grain shape, using NCRDS abbreviation list. |
| grain_shape_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| mineral_cd |
| Logical Only | NO |
| Definition | Primary mineralogy of unit, if known. |
| Note |
| mineral_cd Logical Attribute Properties |
| Logical Attribute Name | mineral_cd |
| Datatype | VARCHAR(12) |
| Nullable | NO |
| mineral_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| mineral_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | mineral_cd | mineral_cd | unit | VARCHAR | mineral_cd | Primary mineralogy of unit, if known. |
| mineral_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| bedding_cd |
| Logical Only | NO |
| Definition | Description of bedding type in NCRDS abbreviation list |
| Note |
| bedding_cd Logical Attribute Properties |
| Logical Attribute Name | bedding_cd |
| Datatype | VARCHAR(8) |
| Nullable | NO |
| bedding_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| bedding_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | bedding_cd | bedding_cd | unit | VARCHAR | bedding_cd | Description of bedding type in NCRDS abbreviation list |
| bedding_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| contact_cd |
| Logical Only | NO |
| Definition | Type of contact found between beds. Example values are S sharp, G graditional, U undulating, I irregular, N unconformable, L slump, O other. |
| Note |
| contact_cd Logical Attribute Properties |
| Logical Attribute Name | contact_cd |
| Datatype | VARCHAR(1) |
| Nullable | NO |
| contact_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| contact_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | contact_cd | contact_cd | unit | VARCHAR | contact_cd | Type of contact found between beds. Example values are S sharp, G graditional, U undulating, I irregular, N unconformable, L slump, O other. |
| contact_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| fossil_cd |
| Logical Only | NO |
| Definition | Fossil code for type of fossils found if any. Examples are P plant, I invertebrate, V vertebrate, F freshwater, B brackish, M marine, O other. |
| Note |
| fossil_cd Logical Attribute Properties |
| Logical Attribute Name | fossil_cd |
| Datatype | VARCHAR(1) |
| Nullable | NO |
| fossil_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| fossil_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | fossil_cd | fossil_cd | unit | VARCHAR | fossil_cd | Fossil code for type of fossils found if any. Examples are P plant, I invertebrate, V vertebrate, F freshwater, B brackish, M marine, O other. |
| fossil_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| fract_joint_cleat_cd |
| Logical Only | NO |
| Definition | If applicable, one or more of three letters entered (F, J, and/or C) to indicate presence of condition(s) and described in Point Comment. |
| Note |
| fract_joint_cleat_cd Logical Attribute Properties |
| Logical Attribute Name | fract_joint_cleat_cd |
| Datatype | VARCHAR(3) |
| Nullable | NO |
| fract_joint_cleat_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| fract_joint_cleat_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | fract_joint_cleat_cd | fract_joint_cleat_cd | unit | VARCHAR | fract_joint_cleat_cd | If applicable, one or more of three letters entered (F, J, and/or C) to indicate presence of condition(s) and described in Point Comment. |
| fract_joint_cleat_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| misc_char_cd |
| Logical Only | NO |
| Definition | User-defined alphanumeric field. Data are of special meaning to the collector. |
| Note |
| misc_char_cd Logical Attribute Properties |
| Logical Attribute Name | misc_char_cd |
| Datatype | VARCHAR(4) |
| Nullable | NO |
| misc_char_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| misc_char_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | misc_char_cd | misc_char_cd | unit | VARCHAR | misc_char_cd | User-defined alphanumeric field. Data are of special meaning to the collector. |
| misc_char_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| misc_num_cd |
| Logical Only | NO |
| Definition | User-defined numeric field for decimal values. Data are of special meaning to the collector. |
| Note |
| misc_num_cd Logical Attribute Properties |
| Logical Attribute Name | misc_num_cd |
| Datatype | VARCHAR(8) |
| Nullable | NO |
| misc_num_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| misc_num_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | misc_num_cd | misc_num_cd | unit | VARCHAR | misc_num_cd | User-defined numeric field for decimal values. Data are of special meaning to the collector. |
| misc_num_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| unit_comment_tx |
| Logical Only | NO |
| Definition | Comment about specific unit, entered by geologist collecting the point data. |
| Note |
| unit_comment_tx Logical Attribute Properties |
| Logical Attribute Name | unit_comment_tx |
| Datatype | VARCHAR(40) |
| Nullable | NO |
| unit_comment_tx Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| unit_comment_tx Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | unit_comment_tx | unit_comment_tx | unit | VARCHAR | unit_comment_tx | Comment about specific unit, entered by geologist collecting the point data. |
| unit_comment_tx User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| last_update_dt |
| Logical Only | NO |
| Definition | Date data was last updated in YYYYMMDD format. |
| Note |
| last_update_dt Logical Attribute Properties |
| Logical Attribute Name | last_update_dt |
| Datatype | NUMERIC(10, 0) |
| Nullable | YES |
| last_update_dt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| last_update_dt Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | last_update_dt | last_update_dt | unit | NUMERIC | last_update_dt | Date data was last updated in YYYYMMDD format. |
| last_update_dt User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| entry_person_cd |
| Logical Only | NO |
| Definition | Primary key for code table, d_entry_person. Numeric code identifying person who entered data into database |
| Note |
| entry_person_cd Logical Attribute Properties |
| Logical Attribute Name | entry_person_cd |
| Datatype | INTEGER |
| Nullable | NO |
| entry_person_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| entry_person_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | entry_person_cd | entry_person_cd | unit | INTEGER | entry_person_cd | Primary key for code table, d_entry_person. Numeric code identifying person who entered data into database |
| entry_person_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |
| unit_key_cd |
| Logical Only | NO |
| Definition | Generated by system by combining point_id (7 digits) plus unit_id (4 digits) |
| Note |
| unit_key_cd Logical Attribute Properties |
| Logical Attribute Name | unit_key_cd |
| Datatype | DECIMAL(11, 0) |
| Nullable | NO |
| unit_key_cd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| unit_key_cd Where Used |
| Model | Name | RoleName | Base Entity | Datatype | Domain | Definition |
| Logical | unit_key_cd | unit_key_cd | unit | DECIMAL | unit_key_cd | Generated by system by combining point_id (7 digits) plus unit_id (4 digits) |
| unit_key_cd User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Definition |