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 |