ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
SWAMP Master LookUp Code
Request Form
2
Version: April 2024
3
4
This workbook includes new vocabulary request templates and instructions for the following
SWAMP/CEDEN LookUp list codes:
5
6
7
Station
8
Project
9
Agency
10
Parent Project
11
Program
12
Personnel
13
QAPP
14
Protocol
15
Collection Device
16
Analyte
17
Constituent
18
Method
19
Digest Extract
20
21
Important Notes:
22
1. Refer to "README" tabs prior to completing Request tabs (where provided)
23
2. Examples of exisiting codes are provided in blue text for reference (but may not include all code types), within code request tabs. You can chose to erase or write below the example text
24
25
3. Some column headers provide required character limits for the values requested (tip for checking character counts: In a different cell, use the formula =len(cell), where cell equals the cell to count)
26
27
4. Some column headers have hidden comments with additional guidance (as indicated by flag in cell corner). Hover over the cell to view each comment or change the note-viewing settings in the Review tab to view all
28
29
5. Please first cross-check requested codes with those existing in SWAMP/CEDEN LookUp lists, in order to avoid duplication of similar codes and check for consistency of associated values (tip for checking LookUps: Download the Excel files and use the filter feature to more easily search/filter)
30
31
32
33
For more information, questions or comments, please contact your Regional Liaison or:
34
SWAMP-IQ Center HelpDesk (OIMA-Helpdesk@waterboards.ca.gov)
35
36
Find SWAMP data management & quality assurance information and resources here:
37
SWAMP-IQ Center Webpage (https://www.waterboards.ca.gov/water_issues/programs/swamp/swamp_iq/)
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100