lab_combine_nasis_ncss (This table is a linkage betwwen NASIS Pedon morphological and the Lab data. This table stores information about locations, layers or horizons of a pedon that has had samples submitted to the SSL at the National Soil Survey Center or one of the various laboratories at NCSS cooperating universities. Data is periodically transferred from the SSL database to this table.)

pedon_key: An integer number that uniquely identifies a particular pedon
site_key: An integer number that uniquely identifies a particular site
pedlabsampnum: An identifier for the pedon sample that is assigned by the Kellogg Soil Survey Laboratory. This identifier is used to link the morphological pedon description with the associated measured property values from the laboratory.
pedoniid: An internal ID (integer) that is part (or all) of a key that uniquely identifies a NASIS pedon record. Also known as part (or all) of the "primary key". This value is managed by NASIS and cannot be edited.
upedonid: A short label to help a user identify a particular pedon.
country_key: A Foreign key for a Country (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the "primary key".
state_key: A Foreign key for a State (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the "primary key".
county_key: A Foreign key for a County (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the "primary key".
ssa_key: A Foreign key for a Soil Survey Area (integer) r) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the "primary key".
npark_key: A Foreign key for a National Park (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the "primary key".
nforest_key: A Foreign key for a National Forest (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the "primary key".