What Attributes Can be Queried in the Database?

The list is long and this should assist you to not only know what attribute(s) you can query in the database, but also explain what they mean!

Column Name in PCS User Friendly Term
ActualPop Actual Population
Aluminum Aluminum
Area Acres
ASNT Amino sugar nitrate test
BORON Boron Soil Test PPM
BoronRate Boron Applied Rate
CaBaseSat Calcium Soil Test Base Saturation Percentage
CaIndex Calcium Index
CALCIUM Calcium Soil Test PPM
CaMgRatio Calcium to Magnesium Ratio
CEC CEC (Cation Exchange Capacity) Soil Test Meq/100g
CheckTest Check
ChemCost Chemical Total Cost/Acre
ChemCost_Bu Chemical Total Cost/Bushel
Chmresis Seed Chemical Resistance Trait
Company Seed Company
Copper Copper Soil Test PPM
Cost_Bu Breakeven Total Cost/Bushel
CPU Common Production Unit
Crop Crop
CSR CSR Soils Index
CSR2 CSR2
CvrCrop Cover Crop
DEEP EC (Electrical Conductivity) Deep Value
DeepK Deep Potassium Soil Test PPM
DeepP Deep Phosphorous Soil Test PPM
Disresis Seed Disease Resistance Trait
DownForce Planter Down Force
DownMargin Planter Down Force Margin
Dry_Yield Dry Yield
DryCost Drying Cost/Acre
DryYldAvg Dry Yield Average Actual
DryYldMax Dry Yield Maximum
Elevation Elevation
FertCost Fertilizer Total Cost/Acre
FertCost_Bu Fertilizer Total Cost/Bushel
Foliar1 Foliar 1 Product
Foliar1$Ac Foliar 1 Cost/Acre
Foliar1Time Foliar 1 Application Timing
Foliar2 Foliar 2 Product
Foliar2$Ac Foliar 2 Cost/Acre
Foliar2Time Foliar 2 Application Timing
Foliar3 Foliar 3 Product
Foliar3$Ac Foliar 3 Cost/Acre
Foliar3Time Foliar 3 Application Timing
Fung1$Ac Fungicide 1 Cost/Acre
Fung1ApDate Fungicide 1 Application Timing
Fung1ApMthd Fungicide 1 Application Method
Fung1Rate Fungicide 1 Rate Applied
Fung2$Ac Fungicide 2 Cost/Acre
Fung2ApDate Fungicide 2 Application Timing
Fung2ApMthd Fungicide 2 Application Method
Fung2Rate Fungicide 2 Rate Applied
Fung3$Ac Fungicide 3 Cost/Acre
Fung3ApDate Fungicide 3 Application Timing
Fung3ApMthd Fungicide 3 Application Method
Fung3Rate Fungicide 3 Rate Applied
Fungicide1 Fungicide 1 Product
Fungicide2 Fungicide 2 Product
Fungicide3 Fungicide 3 Product
GenFertInd General Fertility Index
GrContact Planter Ground Contact
Harv_Plnt Harvest Date Minus Plant Date
HarvADF Harvest ADF Percent
HarvDate Harvest Date - Calendar
HarvDate# Harvest Date - Julian
HarvNDF Harvest NDF Percent
HarvProtein Harvest Crude Protein Percent
HarvSpeed Harvest Speed
HarvStarch Harvest Starch Percent
HarvSugar Harvest Sugar Percent
HBaseSat Hydrogen Soil Test Base Saturation Percentage
Iron Iron Soil Test PPM
IrrgType Irrigation Type
IrrigAmount Irrigation Amount (inches)
Irrigated Irrigation
Isc$Ac Insecticide Total Cost/Acre
Isc1$Ac Insecticide 1 Cost/Acre
Isc1ApDate Insecticide 1 Application Timing
Isc1Name Insecticide 1 Product
Isc1Rate Insecticide 1 Rate Applied
Isc2$Ac Insecticide 2 Cost/Acre
Isc2ApDate Insecticide 2 Application Timing
Isc2Name Insecticide 2 Product
Isc2Rate Insecticide 2 Rate Applied
Isc3$Ac Insecticide 3 Cost/Acre
Isc3ApDate Insecticide 3 Application Timing
Isc3Name Insecticide 3 Product
Isc3Rate Insecticide 3 Rate Applied
K$Ac Potassium Nutrient 1 Cost/Acre
K2$Ac Potassium Nutrient 2 Cost/Acre
K2ApMthd Potassium Nutrient 2 Application Method
K2Rate Potassium Nutrient 2 Rate Applied
K2Time Potassium Nutrient 2 Application Timing
K2Type Potassium Nutrient 2 Product
KApMthd Potassium Nutrient 1 Application Method
KBaseSat Potassium Soil Test Base Saturation Percentage
KMgIndex K:Mg (Potassium to Magnesium) Index
KMgRatio K:Mg (Potassium to Magnesium)
KRate Potassium Nutrient 1 Rate Applied
KRem Potassium Removal 1 Year
KRem2Yrs Potassium Removal 2 Years
KTime Potassium Nutrient 1 Application Timing
KType Potassium Nutrient 1 Product
Land$_Bu Land Cost/Bushel
Land$Ac Land Cost/Acre
Lime$Ac Lime Applied Cost/Acre
LimeECCE Lime ECCE
LimeRate Lime Rate Applied
LimeYear Lime Application Year
MAGNESIUM Magnesium Soil Test PPM
Man$Ac Manure Cost/Acre
ManAdd Manure Additive
MANGANESE Manganese Soil Test PPM
ManKRate Manure K (Potassium) Rate
ManNRate Manure N (Nitrogen) Rate
ManPRate Manure P (Phosphorus) Rate
ManSRate Manure S (Sulfur) Rate
ManureType Manure Type
MgBaseSat Magnesium Soil Test Base Saturation Percentage
MgIndex Magnesium Index
MgmtCost Management Total Cost/Acre
MgmtCost_Bu Management Total Cost/Bushel
MgmtZone Management Zone
Micro$Ac Micronutrient Cost/Acre
MicroApMthd Micronutrient Application Method
MicroName Micronutrient Product
MicroTime Micronutrient Application Timing
MnRate Manganese Rate Applied
Moisture Moisture
Na Sodium Soil Test PPM
nabasesat Sodium Soil Test Base Saturation Percentage
Ndex Ndex (yield divided by #N/bu)
NDVI NDVI (Normalized difference vegetation index)
NO3 NO3 (Nitrate)
NUsage Pounds N (Nitrogen) per bushel
OM Organic Matter Soil Test Percentage
OpsCost Operations Total Cost/Acre
OpsCost_Bu Operations Total Cost/Bushel
P$Ac Phosphorus Nutrient 1 Cost/Acre
P2$Ac Phosphorus Nutrient 2 Cost/Acre
P2Add Phosphorus Nutrient 2 Additive
P2ApMthd Phosphorus Nutrient 2 App Method
P2Rate Phosphorus Nutrient 2 Rate Applied
P2Time Phosphorus Nutrient 2 App Timing
P2Type Phosphorus Nutrient 2 Product
PAdd Phosphorus Nutrient 1 Additive
PApMthd Phosphorus Nutrient 1 Application Method
pcleanfur Planter Clean Furrow
pfurqual Planter Furrow Quality
pgoodcont Planter Good Contact
PH pH Soil Test Value
PHBUFFER pH Buffer Soil Test Value
PhosIndex Phosphorus Index
PHOSPHORUS Phosphorus Soil Test PPM
PhosSat Saturation of Phosphorus
Plnt_Spd Planting Speed
PlntDate Planting Date - Calendar
PlntDate# Planting Date - Julian
PN1Rate Phosphorus Nutrient 1 N Rate
PN2Rate Phosphorus Nutrient 2 N Rate
PostMethod Post Herbicide Trip 1 Application Method
PotassInd Potassium Index
POTASSIUM Potassium Soil Test PPM
PRate Phosphorus Nutrient 1 Rate Applied
Pre$Ac Pre Herbicide Total Cost/Acre
Pre1$Ac Pre Herbicide 1 Cost/Acre
Pre1Name Pre Herbicide 1 Product
Pre1Rate Pre Herbicide 1 Rate Applied
Pre2$Ac Pre Herbicide 2 Cost/Acre
Pre2Name Pre Herbicide 2 Product
Pre2Rate Pre Herbicide 2 Rate Applied
Pre3$Ac Pre Herbicide 3 Cost/Acre
Pre3Name Pre Herbicide 3 Product
Pre3Rate Pre Herbicide 3 Rate Applied
Pre6$Ac Pre Herbicide 6 Cost/Acre
Pre6AppDate Pre Herbicide 6 Application Timing
Pre6Method Pre Herbicide 6 Application Method
Pre6Name Pre Herbicide 6 Product
Pre6Rate Pre Herbicide 6 Rate Applied
Pre7$Ac Pre Herbicide 7 Cost/Acre
Pre7Name Pre Herbicide 7 Product
Pre7Rate Pre Herbicide 7 Rate Applied
Pre8$Ac Pre Herbicide 8 Cost/Acre
Pre8Name Pre Herbicide 8 Product
Pre8Rate Pre Herbicide 8 Rate Applied
PreAdd1 Pre Herbicide 1 Additive
PreAdd1$Ac Pre Herbicide 1 Additive Cost/Ac
PreAdd6 Pre Herbicide 6 Additive
PreAdd6$Ac Pre Herbicide 6 Additive Cost/Acre
PreAppDate Pre Herbicide 1 Application Timing
PRem Phosphorus Removal 1 Year
PRem2Yrs Phosphorus Removal 2 Years
PreMethod Pre Herbicide 1 Application Method
PrevCrop Previous Crop
PriN$Ac Primary N (Nitrogen) Cost/Acre
PriNAdd Primary N (Nitrogen) Additive
PriNApMthd Primary N (Nitrogen) Application Method
PriNRate Primary N (Nitrogen) Rate Applied
PriNTime Primary N (Nitrogen) Application Timing
PriNType Primary N (Nitrogen) Product
ProperSpce Planter Proper Spacing
psoilmoist Planter Soil Moisture
psoilom Planter Soil Organic Matter
psoiltemp Planter Soil Temperature (in Fahrenheit)
Pst$Ac Post Herbicide Total Cost/Acre
Pst1$Ac Post Herbicide 1 Cost/Acre
Pst1ApDate Post Herbicide Trip 1 Application Timing
Pst1Name Post Herbicide 1 Product
Pst1Rate Post Herbicide 1 Rate Applied
Pst2$Ac Post Herbicide 2 Cost/Acre
Pst2ApDate Post Herbicide Trip 2 Application Timing
Pst2Name Post Herbicide 2 Product
Pst2Rate Post Herbicide 2 Rate Applied
Pst3$Ac Post Herbicide 3 Cost/Acre
Pst30$Ac Post Herbicide 30 Cost/Acre
Pst30ApDate Post Herbicide Trip 30 App Timing
Pst30Name Post Herbicide 30 Product
Pst30Rate Post Herbicide 30 Rate Applied
Pst31$Ac Post Herbicide 31 Cost/Acre
Pst31Name Post Herbicide 31 Product
Pst31Rate Post Herbicide 31 Rate Applied
Pst32$Ac Post Herbicide 32 Cost/Acre
Pst32Name Post Herbicide 32 Product
Pst32Rate Post Herbicide 32 Rate Applied
Pst33$Ac Post Herbicide 33 Cost/Acre
Pst33Name Post Herbicide 33 Product
Pst33Rate Post Herbicide 33 Rate Applied
Pst3Name Post Herbicide 3 Product
Pst3Rate Post Herbicide 3 Rate Applied
Pst4$Ac Post Herbicide 4 Cost/Acre
Pst40$Ac Post Herbicide 40 Cost/Acre
Pst40ApDate Post Herbicide Trip 40 Application Timing
Pst40Name Post Herbicide 40 Product
Pst40Rate Post Herbicide 40 Rate Applied
Pst41$Ac Post Herbicide 41 Cost/Acre
Pst41Name Post Herbicide 41 Product
Pst41Rate Post Herbicide 41 Rate Applied
Pst42$Ac Post Herbicide 42 Cost/Acre
Pst42Name Post Herbicide 42 Product
Pst42Rate Post Herbicide 42 Rate Applied
Pst43$Ac Post Herbicide 43 Cost/Acre
Pst43Name Post Herbicide 43 Product
Pst43Rate Post Herbicide 43 Rate Applied
Pst4Name Post Herbicide 4 Product
Pst4Rate Post Herbicide 4 Rate Applied
Pst5$Ac Post Herbicide 5 Cost/Acre
Pst5Name Post Herbicide 5 Product
Pst5Rate Post Herbicide 5 Rate Applied
Pst6$Ac Post Herbicide 6 Cost/Acre
Pst6Name Post Herbicide 6 Product
Pst6Rate Post Herbicide 6 Rate Applied
Pst7$Ac Post Herbicide 7 Cost/Acre
Pst7Name Post Herbicide 7 Product
Pst7Rate Post Herbicide 7 Rate Applied
Pst8$Ac Post Herbicide 8 Cost/Acre
Pst8Name Post Herbicide 8 Product
Pst8Rate Post Herbicide 8 Rate Applied
PstAdd1 Post Herbicide Additive 1 Product
PstAdd1$Ac Post Herbicide Additive 1 Cost/Acre
PstAdd2 Post Herbicide Additive 2 Product
PstAdd2$Ac Post Herbicide Additive 2 Cost/Acre
PstAdd30 Post Herbicide Additive 30 Product
PstAdd30$Ac Post Herbicide Additive 30 Cost/Acre
PstAdd40 Post Herbicide Additive 40 Product
PstAdd40$Ac Post Herbicide Additive 40 Cost/Acre
PstMethod2 Post Herbicide Trip 2 Application Method
PstMethod30 Post Herbicide Trip 3 Application Method
PstMethod40 Post Herbicide Trip 4 Application Method
Pstresis Seed Pest Resistance Trait
PTime Phosphorus Nutrient 1 Application Timing
PType Phosphorus Nutrient 1 Product
Replant Replanted Area
RM Seed Relative Maturity
Row_Spc Row Spacing
SampleDate Soil Sample Date
Sc1N$Ac Secondary N (Nitrogen) 1 Cost/Acre
Sc1NAdd Secondary N (Nitrogen) 1 Additive
Sc1NApMthd Secondary N (Nitrogen) 1 App Method
Sc1NRate Secondary N (Nitrogen) 1 Rate Applied
Sc1NTime Secondary N (Nitrogen) 1 Application Timing
Sc1NType Secondary N (Nitrogen) 1 Product
Sc2N$Ac Secondary N (Nitrogen) 2 Cost/Acre
Sc2NAdd Secondary N (Nitrogen) 2 Additive
Sc2NApMthd Secondary N (Nitrogen) 2 Application Method
Sc2NRate Secondary N (Nitrogen) 2 Rate Applied
Sc2NTime Secondary N (Nitrogen) 2 Application Timing
Sc2NType Secondary N (Nitrogen) 2 Product
Sc3N$Ac Secondary N (Nitrogen) 3 Cost/Acre
Sc3NAdd Secondary N (Nitrogen) 3 Additive
Sc3NApMthd Secondary N (Nitrogen) 3 Application Method
Sc3NRate Secondary N (Nitrogen) 3 Rate Applied
Sc3NTime Secondary N (Nitrogen) 3 App Timing
Sc3NType Secondary N (Nitrogen) 3 Product
Sd$Ac Seed Cost/Acre
SdUsage Seed Usage
Seed$_Bu Seed Cost/Bushel
SeedCost Seed Plus Seed Treatment Cost/Acre
SeedCost_Bu Seed Plus Seed Treatment Cost/Bushel
SeedTreat Seed Treatment Product
SeedTrt$_Bu Seed Treatment Cost/Bushel
SeedTrt$Ac Seed Treatment Cost/Acre
SHALLOW EC (Electrical Conductivity) Shallow Value
Singulate Planter Singulation
SLOPE_RANG Soil Slope Range
SMS Soil Map Symbol
SoilGrtGroup Soil Great Group
SOILNAME Soil Type
SoilOrder Soil Order
SoilSubOrder Soil Sub Order
solsalt Soluble Salts
Spectrt Seed Specialty Trait
Str$Ac Starter Cost/Acre
StrKRate Starter K (Potassium) Rate Applied
StrNRate Starter N (Nitrogen) Rate Applied
StrPRate Starter P (Phosphorus) Rate Applied
StrSRate Starter S (Sulfur) Rate Applied
StrType Starter Product
StrZnRate Starter ZN (Zinc) Rate Applied
Sulf$Ac Sulfur Nutrient 1 Cost/Acre
Sulf2$Ac Sulfur Nutrient 2 Cost/Acre
Sulf2ApMthd Sulfur Nutrient 2  Application Method
Sulf2Prod Sulfur Nutrient 2 Product
Sulf2Rate Sulfur Nutrient 2 Rate Applied
Sulf2Time Sulfur Nutrient 2 Application Timing
SulfApMthd Sulfur Nutrient 1 Application Method
SulfN2Rate Sulfur Nutrient 2 N (Nitrogen) Rate Applied
SulfNRate Sulfur Nutrient 1 N (Nitrogen) Rate Applied
SulfProd Sulfur Nutrient 1 Product
SulfRate Sulfur Nutrient 1 Rate Applied
SulfTime Sulfur Nutrient 1 Application Timing
SULFUR Sulfur Soil Test PPM
TargPop Target Population
TEXTURE Soil Texture
Till_Type Tillage type
TotalCost Total Cost/Acre
TotGdd Total GDD (Growing Degree Days) Apr 1 Sep 30
TotK$Ac Total Potassium Cost/acre
TotKRate Total Potassium Nutrient Applied
TotNRate Total Nitrogen Applied
TotP$Ac Total Phosphorus Cost/acre
TotPRate Total Phosphorus Nutrient Applied
TotRain Total Rain April 1 - September 30
TotSulf$Ac Total Sulfur Cost/acre
TotSulfRate Total Sulfur Nutrient Applied
Variety Seed Variety
Water$Ac Irrigation Water Cost/Acre
WK14Rain Rainfall April 8-14
WK15Rain Rainfall April 15-21
WK16Rain Rainfall April 22-28
WK17Rain Rainfall Apr 29-May 5
WK18Rain Rainfall May 6-12
WK19Rain Rainfall May 13-19
WK20Rain Rainfall May 20-26
WK21Rain Rainfall May 27-June 2
WK22Rain Rainfall June 3-9
WK23Rain Rainfall June 10-16
WK24Rain Rainfall June 17-23
WK25Rain Rainfall June 24-30
WK26Rain Rainfall July 1-7
WK27Rain Rainfall July 8-14
WK28Rain Rainfall July 15-21
WK29Rain Rainfall July 22-28
WK30Rain Rainfall July 29-August 4
WK31Rain Rainfall August 5-11
WK32Rain Rainfall August 12-18
WK33Rain Rainfall August 19-25
WK34Rain Rainfall August 26-September 1
WK35Rain Rainfall September 2-8
WK36Rain Rainfall September 9-15
WK37Rain Rainfall September 16-22
WK38Rain Rainfall September 23-29
WK39Rain Rainfall September 30
ZINC Zinc Soil Test PPM
ZincRate Zinc Nutrient Rate Applied