NMR-STAR dictionary: database table: SystematicChemShiftOffset

Detailed description of the fields

_Systematic_chem_shift_offset.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Systematic_chem_shift_offset.Type 
DescriptionNMR-STAR name: _Systematic_chem_shift_offset.Type
The kind of chemical shift offset that should be applied to all chemical shifts observed for a specific type of atom.  
Database field nameType 
SQL Database typeVARCHAR(127) 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptOffset type  
ExamplesTROSY effect  
Help text 

_Systematic_chem_shift_offset.Atom_type (AtomType)

(go to parent tag category listing)
NMR-STAR tag name_Systematic_chem_shift_offset.Atom_type 
DescriptionNMR-STAR name: _Systematic_chem_shift_offset.Atom_type
Select the type of atom that is affected by the systematic chemical shift offset. This may be a selected set of atoms or all atoms of a specific element. If more than one type of atom is affected, please enter multiple rows in the table, one for each type of atom.  
Database field nameAtomType 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptAffected atom type  
Examplesamide nitrogens  
Help text 

_Systematic_chem_shift_offset.Atom_isotope_number (AtomIsotopeNumber)

(go to parent tag category listing)
NMR-STAR tag name_Systematic_chem_shift_offset.Atom_isotope_number 
DescriptionNMR-STAR name: _Systematic_chem_shift_offset.Atom_isotope_number
Isotope number for the specified atom.  
Database field nameAtomIsotopeNumber 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAtom isotope number  
Examples1  
Help text 

_Systematic_chem_shift_offset.Val (Val)

(go to parent tag category listing)
NMR-STAR tag name_Systematic_chem_shift_offset.Val 
DescriptionNMR-STAR name: _Systematic_chem_shift_offset.Val
Chemical shift value that has been applied to all of the reported chemical shifts to bring their values in line with values expected to be observed for the chemical shift referencing that was used.  
Database field nameVal 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptOffset value  
Examples0.75  
Help text 

_Systematic_chem_shift_offset.Val_err (ValErr)

(go to parent tag category listing)
NMR-STAR tag name_Systematic_chem_shift_offset.Val_err 
DescriptionNMR-STAR name: _Systematic_chem_shift_offset.Val_err
Error in the reported chemical shift offset value used.  
Database field nameValErr 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptOffset value error  
Examples0.0067  
Help text 

_Systematic_chem_shift_offset.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Systematic_chem_shift_offset.Sf_ID 
DescriptionNMR-STAR name: _Systematic_chem_shift_offset.Sf_ID
Pointer to '_Assigned_chem_shift_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAssigned_chem_shift_list, Sf_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagyes
This field's data is for internal use only and should be hidden in public versiond of the data. 
Nulls allowed in database?yes 
PromptSf ID  
Examples
Help text 

_Systematic_chem_shift_offset.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Systematic_chem_shift_offset.Entry_ID 
DescriptionNMR-STAR name: _Systematic_chem_shift_offset.Entry_ID
Pointer to '_Entry.ID'  
Database field nameEntryID 
SQL Database typeCHAR(12) 
Part of primary Keyyes 
Foreign Key on table, columnAssigned_chem_shift_list, Entry_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptEntry ID  
Examples
Help text 

_Systematic_chem_shift_offset.Assigned_chem_shift_list_ID (AssignedChemShiftListID)

(go to parent tag category listing)
NMR-STAR tag name_Systematic_chem_shift_offset.Assigned_chem_shift_list_ID 
DescriptionNMR-STAR name: _Systematic_chem_shift_offset.Assigned_chem_shift_list_ID
Pointer to '_Assigned_chem_shift_list.ID'  
Database field nameAssignedChemShiftListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnAssigned_chem_shift_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAssigned chem shift list ID  
Examples
Help text