| name | type | length | unit | ucd | description |
| specobjid | bigint | 8 | | | 64 bit unique spectrum id f(p,mjd,fiber) |
| plate | int | 4 | | | plate number |
| mjd | int | 4 | | | Modified Julian Date of (last) observation |
| fiberid | int | 4 | | | Fiber number (1-640) 1-320 on spec#1 |
| fehspectype | varchar | 32 | | | SEGUE or SDSS target type abbrev. |
| ra | float | 8 | degrees | | RA (J2000) |
| dec | float | 8 | degrees | | DEC (J2000) |
| brun | int | 4 | | | SDSS Run number (target version of sky) |
| brerun | int | 4 | | | SDSS Rerun number (target version of sky) |
| bcamcol | int | 4 | | | SDSS Camcol number (target version of sky) |
| bfield | int | 4 | | | SDSS Field number (target version of sky) |
| bobj | int | 4 | | | SDSS object number (target version of sky) |
| zbsubclass | varchar | 32 | | | specBS subclass |
| zbelodiesptype | varchar | 32 | | | specBS ELODIE best match template |
| zbclass | varchar | 32 | | | SpecBS class |
| zbrchi2 | real | 4 | | | SpecBS rchi2 reduced chi-square per dof |
| zbdof | real | 4 | | | SpecBS dof measure for best fit template |
| zbvdisp | real | 4 | | | SpecBS Velocity dispersion (for galaxies) |
| zbvdisperr | real | 4 | km/s | | SpecBS error in Velocity disp |
| zbzwarning | real | 4 | | | SpecBS warning flag |
| spec_cln | int | 4 | | | Spectro1d(Chicago) class 1= star, 6= redstar |
| spz | varchar | 8 | | | |
| spzerr | varchar | 8 | | | |
| vel_dis | real | 4 | | | Spectro1d(Chicago) Vel disp (for galaxies) |
| vel_disperr | real | 4 | km/s | | Spectro1d(Chicago) Vel disp error |
| spz_conf | real | 4 | | | Spectro1d(Chicago) redshift confidence |
| spz_status | int | 4 | | | Spectro1d(Chicago) redshift status |
| spz_warning | int | 4 | | | Spectro1d(Chicago) redshift warning |
| eclass | real | 4 | | | Spectro1d(Chicago) galaxy Prin. comp. class |
| ecoeff1 | real | 4 | | | Galaxy Prin. comp. 1 (for galaxies) |
| ecoeff2 | real | 4 | | | Galaxy Prin. comp. 2 (for galaxies) |
| ecoeff3 | real | 4 | | | Galaxy Prin. comp. 3 (for galaxies) |
| ecoeff4 | real | 4 | | | Galaxy Prin. comp. 4 (for galaxies) |
| ecoeff5 | real | 4 | | | Galaxy Prin. comp. 5 (for galaxies) |