d_point_description 
EntityType  Independent 
Logical Entity Name  d_point_description 
Default Table Name  d_point_description 
Logical Only  NO 
Definition  
Description or log of point data
 
Note 
 

d_point_description Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
point_description_id(PK)  point_description_id  INTEGER  NO  
Unique ID fo code table, d_point_description
 
point_description_tx  point_description_tx  CHAR(20)  NO  
Type of log data with a three digit code prefix: all descriptions are preceded by "1", all logs by "2". e.g., outcrop = 102; coal test = 216



I. Description

     01 roadcut

     02 outcrop

     03 underground

     04 surface mine

     05 prospect pit

*1) 06 measured section (multiple point locations) A-Z top to bottom                             

     07 mine mouth

*2) 08 composite section

     09 company mine map



*1)  See "Measured Section" description for details

*2)  "Composite section": represents a derived stratigraphic section from a variety of sources, e.g. several different publications, field notes, etc.



II. Log

    01 core

    02 drill hole

    03 rotary

    04 drillers log

    05 electric

    06 geophysical

    07 gamma (natural)

    08 density (gamma-gamma)

    09 neutron (activation)

    10 resistivity

    11 spontaneous potential

    12 sonic

    13 laterolog

    14 seismic

    15 caliper

    16 coal test

    17 oil and gas

    18 water well

    19 soil test

    20 power line hole

    21 pump hole

    22 ventilation shaft

    23 gamma & neutron

    24 gamma & density

    25 rotary * core

    30 multiple: if more than one type of log in vertical sequence, list string of abbrev. in point_comment_tx field. See also explanation for Unit Qualifire for "L".

    31 combination: for combination of types for the entire log enter string of codes in point_comment_tx field.
 

d_point_description Keys 
Key Name  Key Type  Keys 
None  PrimaryKey  point_description_id 

d_point_description Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
point  Non-Identifying  One To Zero or More          NO 

d_point_description Security Types 
Name  Current Value 

d_point_description Attachments 
Name  Current Value