| name | type | length | unit | ucd | description |
| specObjID | numeric | 13 | | ID_CATALOG | Unique ID |
| plateid | smallint | 2 | | | Plate number |
| mjd | int | 4 | | | Modified Julian Date of plate observation |
| fiberid | smallint | 2 | | | Fiber number (1 - 640) |
| ra | real | 4 | degrees | | Right Ascention of drilled fiber position |
| dec | real | 4 | degrees | | Declination of drilled fiber position |
| primtarget | smallint | 2 | | | Primary Target Flag (MAIN galaxy = 64) |
| sectarget | smallint | 2 | | | Secondary Target Flag (QA = 8) |
| targettype | varchar | 32 | | | Text version of primary target (GALAXY/QA/QSO/ROSAT_D) |
| spectrotype | varchar | 32 | | | Schlegel classification of spectrum ... code is only run where this is set to "GALAXY" |
| subclass | varchar | 32 | | | Schlegel subclass from PCA analysis -- not alwasy correct!! AGN/BROADLINE/STARBURST/STARFORMING |
| z | real | 4 | | | Redshift from Schlegel |
| z_err | real | 4 | | | Redshift error |
| z_warning | smallint | 2 | | | Bad redshift if this is non-zero -- see Schlegel data model |
| v_disp | real | 4 | km/s | | Velocity dispersion from Schlegel |
| v_disp_err | real | 4 | km/s | | Velocity dispersion error (negative for invalid fit) |
| sn_median | real | 4 | | | Median S/N per pixel of the whole spectrum |
| e_bv_sfd | real | 4 | | | E(B-V) of foreground reddening from SFD maps |
| release | varchar | 32 | | | Data Release (dr1/dr2/dr3/dr4) |
| reliable | smallint | 2 | | | has "reliable" line measurements and physical parameters |
