LOADING
Database Controls
Controls
*
-- Select Control --
Check UseI for missing PID and missing NACE codes
Calculate the html reference to the drawing from the smiles code.
Calculates cas-no according to pid and vice versa, in SPINname.
Update SPINstof preferred name (CAS, COM, DK, NO, FI)
Not used. Update SPINstof preferred name step 2 (COM)
Not used. Update SPINstof preferred name step 3 (PRD)
Calculate cas-no according to pid and vice versa, in SPINstof
Calculates ec-no according to ecno and vice versa, in SPINstof.
Calculates indexno according to index-no and vice versa, in SPINstof.
Calculates compno according to comp-no and vice versa, in SPINcomp.
Calculates refpid according to ref-no and vice versa, in SPINref.
Find missing substances in SPINstof
Convert PRD, PRN, FIN names to DK, NO, FI, respectively.
Add a leading 0 to single digit UsePC(product category) codes.
OECD table (1), update with new substances.
OECD table (2), generate url links for export.
Spinref, calculates reference no(ref_no) with dashes.
Spinref, adds reference name(refname) from spinstof preferred name.
Spincomp, calculates component no(comp_no) with dashes.
Spincomp, adds component name(compname) from spinstof preferred name.
Updates inventory text, based on the code_inventories table, in spinlist.
Updates code text, based on the code_functions table, in spinscat.
Clear amount and number if total use is confidential.
Copy values from temp_spinname to spinname, replacing duplicates
Add new spinstof from spinname
Add spinstof from usedata
Add new spinname from spinstof
Find diff for usei DK
Find diff for usei NO
Find diff for usei SE
Find diff for usei FI
Find diff for useid DK
Find diff for useid NO
Find diff for useid SE
Find diff for useid FI
Find diff for usepc DK
Find diff for usepc NO
Find diff for usepc SE
Find diff for usepc FI
Find diff for usepcd DK
Find diff for usepcd NO
Find diff for usepcd SE
Find diff for usepcd FI
Find diff for uset DK
Find diff for uset NO
Find diff for uset SE
Find diff for uset FI
Submit