GovWin IQ Web Service Field Mapping
You can review mapping guidelines to see how GovWin IQ fields are transferred to the Vision database.
The abbreviation OCTF means OpportunityCustomTabFields.
| INPUT Field | Vision Table | Vision Col | Vision Col Type | Subscr. Type | Comments |
|---|---|---|---|---|---|
|
<programName> |
Opportunity |
Name |
Basic, Premium | ||
|
<programName> |
OCTF | custInputProgramName | Basic, Premium | ||
|
<acronym> |
OCTF | custInputAcronym | Basic, Premium | ||
|
<department> |
OCTF | custInputDepartment | Basic, Premium | ||
|
<agency> |
OCTF | custInputAgency | Basic, Premium | ||
|
<opportunityID> |
Opportunity | OpportunityID | Varchar(32) | Basic, Premium | PK |
|
<opportunityID> |
OCTF | custInputID | Varchar(32) | Basic, Premium | |
|
<updated> |
OCTF | custInputLastUpdate | Datetime | Basic, Premium | |
|
<status> |
OCTF | custInputCurrentStatus | Memo | Basic, Premium | |
|
<RFPNumber> |
OCTF | custInputSolicitationNumber | Basic, Premium | ||
|
<estValue> |
OCTF | custINPUTEstimatedValue | Numeric | Basic, Premium | |
|
<competitionType> |
OCTF | custInputCompetitionType | Basic, Premium | ||
|
<NAICS> |
OCTF | custInputNAICSCode | Basic, Premium | ||
|
<comments> |
OCTF | custInputComments | Memo | Basic, Premium | |
|
<governmentWebSite> |
OCTF | custInputAgencyWebSite | URL | Basic, Premium | |
|
<primaryOffering> |
OCTF | custInputPrimaryOffering | Memo | Basic, Premium | |
|
<summary> |
OCTF | custInputSummary | Memo | Basic, Premium | |
|
<potentialParticipants> |
OCTF | custInputPotentialBidders | Memo | Basic, Premium | |
|
<duration> |
OCTF | custInputDuration | Basic, Premium | ||
|
<procurementActivity> |
OCTF | custInputProcurementActivity | Memo | Basic, Premium | |
|
<contractType> |
OCTF | custInputContractType | Basic, Premium | ||
|
<programDescription> |
OCTF | custInputProgramDescription | Memo | Premium | HTML field |
|
<programDescription> |
Opportunity | Description | Memo | Premium | HTML field |
|
Group: (1:M) <keyContacts> |
Opportunities_INPUTKeyContacts | Premium | Table for Custom Grid | ||
|
<contactID> |
Opportunities_INPUTKeyContacts | Seq | Premium | ||
|
<firstName> |
Opportunities_INPUTKeyContacts | custInputFirstName | Premium | ||
|
<lastName> |
Opportunities_INPUTKeyContacts | custInputLastName | Premium | ||
|
<title> |
Opportunities_INPUTKeyContacts | custInputTitle | Premium | ||
|
<phone> |
Opportunities_INPUTKeyContacts | custInputPhone | Premium | ||
|
<email> |
Opportunities_INPUTKeyContacts | custInputEmail | Premium | ||
|
<contactType> |
Opportunities_INPUTKeyContacts | custInputContactType | Premium | ||
|
Group: (1:M) <milestoneDates> |
Opportunities_KeyDates | Premium | Table for Custom Grid | ||
|
<date> |
Opportunities_KeyDates | custInputDate | Basic, Premium | ||
|
<label> |
Opportunities_KeyDates | custInputMilestone | Basic, Premium |