| Description | North Coast Surety XML | agcXML (Contractor's XML) |
ACORD
XML (Surety XML) |
XBRL (Accountants, Business, Finance) |
||||
| Bidlist Connection |
Bondlist Connection |
CHICO Common App | Subcontractor Status Connection |
Project Status Connection |
||||
| Contractor Company Name | CompInfo.CompanyName | tblProjects.PrincipalName | Q_tblQuestionnaire.CI_company | Sender | Recipient | Notifiee:{Organization}.Name | ||||
| Contractor Contact Courtest Title (ex: Mr.) | Q_tblQuestionnaire.CI_contact_courtesy | |||||||
| Contractor Contact Firstname | Q_tblQuestionnaire.CI_contact_first | |||||||
| Contractor Contact Middle Initial | Q_tblQuestionnaire.CI_contact_MI | |||||||
| Contractor Contact Lastname | Q_tblQuestionnaire.CI_contact_last | |||||||
| Contractor Contact Name | CompInfo.CompanyContact | Sender | Recipient |
Notifiee:{Organization}.Representative.GivenName + Sender | Recipient | Notifiee:{Organization}.Representative.FamilyName |
||||||
| Contractor Company Address1 | CompInfo.Comp_Address1 | Q_tblQuestionnaire.CI_address | Sender | Recipient | Notifiee:{Organization}.PostalAddress.AddressLine1 | |||||
| Contractor Company Address2 | CompInfo.Comp_Address2 | Q_tblQuestionnaire.CI_address2 | Sender | Recipient | Notifiee:{Organization}.PostalAddress.AddressLine2 | |||||
| Contractor Company City | CompInfo.Comp_City | Q_tblQuestionnaire.CI_city | Sender | Recipient | Notifiee:{Organization}.PostalAddress.Town | |||||
| Contractor Company State | CompInfo.Comp_State | Q_tblQuestionnaire.CI_state | Sender | Recipient | Notifiee:{Organization}.PostalAddress.Region | |||||
| Contractor Company Zipcode | CompInfo.Comp_ZipCode | Q_tblQuestionnaire.CI_zip | Sender | Recipient | Notifiee:{Organization}.PostalAddress.PostalCode | |||||
| Contractor Company Phone | CompInfo.Comp_Phone | Q_tblQuestionnaire.CI_phone | Sender | Recipient | Notifiee:{Organization}.TelecomAddress.Telephone | |||||
| Contractor Company Fax | CompInfo.Comp_FAX | Q_tblQuestionnaire.CI_fax | Sender | Recipient | Notifiee:{Organization}.TelecomAddress.Facsimile | |||||
| Contractor Company Email Address | CompInfo.Comp_BidEMailAddress | Q_tblQuestionnaire.CI_email | Sender | Recipient | Notifiee:{Organization}.Representative.TelecomAddress.Email | |||||
| Electronic Surety Provider | CompInfo.Comp_DigSig | |||||||
| Contractor Company Website | CompInfo.Comp_Web | Q_tblQuestionnaire.CI_website | <submit to AGC to add this> | |||||
| Estimator's Email Address | CompInfo.Comp_email_notify | Sender | Recipient | Notifiee:{Organization}.Representative.TelecomAddress.Email | ||||||
| Default estimator's name | CompInfo.Comp_default_estimator | Sender | Recipient |
Notifiee:{Organization}.Representative.GivenName + Sender | Recipient | Notifiee:{Organization}.Representative.FamilyName |
||||||
| Default URL (link) for plans | CompInfo.Comp_default_Plans_URL | <submit to AGC to add this> | ||||||
| Type: Sub or Prime contractor | CompInfo.Comp_typeContractor | {Organization} type | ||||||
| State Of Domestication | Q_tblQuestionnaire.CI_stateInc | <submit to AGC to add this> | ||||||
| Year Company was started | Q_tblQuestionnaire.CI_yearStarted | <submit to AGC to add this> | ||||||
| Contractor License Number | <add this> | ContractorInformation.License.Number | ||||||
| Contractor License Jurisdiction City | <add this> | ContractorInformation.License.JurisdictionTown | ||||||
| Contractor License Jurisdiction State | <add this> | ContractorInformation.License.JurisdictionState | ||||||
| Federal tax ID | Q_tblQuestionnaire.CI_taxID | <submit to AGC to add this> | ||||||
| Is the company unionized? | Q_tblQuestionnaire.CI_union | <submit to AGC to add this> | ||||||
| Contracting specialty | Q_tblQuestionnaire.CI_specialty | <submit to AGC to add this> | ||||||
| Primary NAICS industry code | Q_tblQuestionnaire.CI_naics1 | <submit to AGC to add this> | ||||||
| Additional NAICS industry code | Q_tblQuestionnaire.CI_naics2 | <submit to AGC to add this> | ||||||
| Additional NAICS industry code | Q_tblQuestionnaire.CI_naics3 | <submit to AGC to add this> | ||||||
| Additional NAICS industry code | Q_tblQuestionnaire.CI_naics4 | <submit to AGC to add this> | ||||||
| Additional NAICS industry code | Q_tblQuestionnaire.CI_naics5 | <submit to AGC to add this> | ||||||
| Areas of operation | Q_tblQuestionnaire.CI_areaOp | <submit to AGC to add this> | ||||||
| FIPS county code areas of operation. 0-infinite iterations of thi | FIPScounty | FIPScounty | <submit to AGC to add this> | |||||
| SB (or other) certification name, usually an acronym ex: DVBE | Q_tblQuestionnaire_tblCert.certName | <submit to AGC to add this> | ||||||
| certification description | Q_tblQuestionnaire_tblCert.certDesc | <submit to AGC to add this> | ||||||
| URL to certification body, ex: http://www.pd.dgs.ca.gov/smbus/default.htm | Q_tblQuestionnaire_tblCert.certURL | <submit to AGC to add this> | ||||||
| certification number | Q_tblQuestionnaire_tblCert.certNumber | <submit to AGC to add this> | ||||||
| location code for jurisdiction size. Ex: city, county, state, natio | Q_tblQuestionnaire_tblCert.locationCode | <submit to AGC to add this> | ||||||
| FIPS code for jurisdiction, could be FIPS for place, county, state | Q_tblQuestionnaire_tblCert.location | <submit to AGC to add this> | ||||||
| date cerification starts | Q_tblQuestionnaire_tblCert.startDate | <submit to AGC to add this> | ||||||
| date certification ends | Q_tblQuestionnaire_tblCert.endDate | <submit to AGC to add this> | ||||||
| Type of legal business entity | Q_tblQuestionnaire.CI_entity | <submit to AGC to add this> | ||||||
| Date the contractor info is current as of | Q_tblQuestionnaire.CI_updateDate | |||||||
| Does contractor wish to be publicly viewed? | Q_tblQuestionnaire.CI_include | |||||||
| What types of trades does contractor do? | Q_tblQuestionnaire.OCI_trades | <submit to AGC to add this> | ||||||
| Percentage of work "subbed" out. | Q_tblQuestionnaire.OCI_percentSub | <submit to AGC to add this> | ||||||
| Types of trades "subbed" out. | Q_tblQuestionnaire.OCI_tradesSub | <submit to AGC to add this> | ||||||
| Sub bonding policy | Q_tblQuestionnaire.OCI_subPolicy | <submit to AGC to add this> | ||||||
| largest uncompleted backlog amount | Q_tblQuestionnaire.OCI_uncompleteAmt | <submit to AGC to add this> | ||||||
| largest uncompleted backlog year | Q_tblQuestionnaire.OCI_uncompleteYear | <submit to AGC to add this> | ||||||
| expected amount of next year's largest job | Q_tblQuestionnaire.OCI_largest | <submit to AGC to add this> | ||||||
| next year's expected backlog | Q_tblQuestionnaire.OCI_expectedBacklog | <submit to AGC to add this> | ||||||
| expected annual volume | Q_tblQuestionnaire.OCI_volume | <submit to AGC to add this> | ||||||
| does contractor lease equipment | Q_tblQuestionnaire.OCI_lease | <submit to AGC to add this> | ||||||
| type of lease | Q_tblQuestionnaire.OCI_leaseType | <submit to AGC to add this> | ||||||
| terms of leased equipment | Q_tblQuestionnaire.OCI_terms | <submit to AGC to add this> | ||||||
| has contractor gone bankrupt, defaulted? | Q_tblQuestionnaire.OCI_bankruptcy | <submit to AGC to add this> | ||||||
| Is firm or owners involved in litigation? | Q_tblQuestionnaire.OCI_litigation | <submit to AGC to add this> | ||||||
| Percentage of work done for government | Q_tblQuestionnaire.OCI_government | <submit to AGC to add this> | ||||||
| Percentage of work done for private owners | Q_tblQuestionnaire.OCI_private | <submit to AGC to add this> | ||||||
| NOTE: owner's info below is repeated 5 times in our database, to allow for up to 5 different owners | ||||||||
| title/position | Q_tblQuestionnaire.OI_position | <submit to AGC to add this> | ||||||
| percent of ownership | Q_tblQuestionnaire.OI_percent | <submit to AGC to add this> | ||||||
| Spouse's name | Q_tblQuestionnaire.OI_spouse | <submit to AGC to add this> | ||||||
| courtesy title | Q_tblQuestionnaire.OI_courtesy | <submit to AGC to add this> | ||||||
| firstname | Q_tblQuestionnaire.OI_first | <submit to AGC to add this> | ||||||
| middle initial | Q_tblQuestionnaire.OI_MI | <submit to AGC to add this> | ||||||
| last name | Q_tblQuestionnaire.OI_last | <submit to AGC to add this> | ||||||
| date of birth | Q_tblQuestionnaire.OI_DOB | <submit to AGC to add this> | ||||||
| trust | Q_tblQuestionnaire.OI_trust | <submit to AGC to add this> | ||||||
| phone number | Q_tblQuestionnaire.OI_phone | <submit to AGC to add this> | ||||||
| phone extension | Q_tblQuestionnaire.OI_phoneExt | <submit to AGC to add this> | ||||||
| fax number | Q_tblQuestionnaire.OI_fax | <submit to AGC to add this> | ||||||
| cell number | Q_tblQuestionnaire.OI_cell | <submit to AGC to add this> | ||||||
| Home address #1 | Q_tblQuestionnaire.OI_address | <submit to AGC to add this> | ||||||
| Home address #2 | Q_tblQuestionnaire.OI_address2 | <submit to AGC to add this> | ||||||
| Home City | Q_tblQuestionnaire.OI_city | <submit to AGC to add this> | ||||||
| Home State | Q_tblQuestionnaire.OI_state | <submit to AGC to add this> | ||||||
| Home Zipcode | Q_tblQuestionnaire.OI_zip | <submit to AGC to add this> | ||||||
| Will the owners personally indemnify? | Q_tblQuestionnaire.OI_Indemnify | <submit to AGC to add this> | ||||||
| if they won't indemnify, explain why. | Q_tblQuestionnaire.OI_explain | <submit to AGC to add this> | ||||||
| is there a buy/sell agreement between owners? | Q_tblQuestionnaire.OI_agreement | <submit to AGC to add this> | ||||||
| is the agreement funded by life insurance? | Q_tblQuestionnaire.OI_lifeIns | <submit to AGC to add this> | ||||||
| Contractor's accounting company name | Q_tblQuestionnaire.FI_CPA | <submit to AGC to add this> | ||||||
| accounting company address1 | Q_tblQuestionnaire.FI_address | <submit to AGC to add this> | ||||||
| accounting company address2 | Q_tblQuestionnaire.FI_address2 | <submit to AGC to add this> | ||||||
| accountant website | Q_tblQuestionnaire.FI_website | <submit to AGC to add this> | ||||||
| accountant city | Q_tblQuestionnaire.FI_city | <submit to AGC to add this> | ||||||
| accountant state | Q_tblQuestionnaire.FI_state | <submit to AGC to add this> | ||||||
| accountant zip | Q_tblQuestionnaire.FI_zip | <submit to AGC to add this> | ||||||
| accountant company phone | Q_tblQuestionnaire.FI_phone | <submit to AGC to add this> | ||||||
| accountant company fax | Q_tblQuestionnaire.FI_fax | <submit to AGC to add this> | ||||||
| accountant contact courtesy title (ex: mr.) | Q_tblQuestionnaire.FI_courtesy | <submit to AGC to add this> | ||||||
| accountant contact firstname | Q_tblQuestionnaire.FI_first | <submit to AGC to add this> | ||||||
| accountant contact middle initial | Q_tblQuestionnaire.FI_MI | <submit to AGC to add this> | ||||||
| accountant contact lastname | Q_tblQuestionnaire.FI_last | <submit to AGC to add this> | ||||||
| accountant contact email | Q_tblQuestionnaire.FI_contactEmail | <submit to AGC to add this> | ||||||
| accountant contact phone number | Q_tblQuestionnaire.FI_contactPhone | <submit to AGC to add this> | ||||||
| accountant contact phone number extension | Q_tblQuestionnaire.FI_contactPhoneExt | <submit to AGC to add this> | ||||||
| accountant contact fax number | Q_tblQuestionnaire.FI_contactFax | <submit to AGC to add this> | ||||||
| accountant contact cell number | Q_tblQuestionnaire.FI_contactCell | <submit to AGC to add this> | ||||||
| does contractor have a full time accountant? | Q_tblQuestionnaire.FI_fullTime | <submit to AGC to add this> | ||||||
| full time accountant's designations (ex: cma) | Q_tblQuestionnaire.FI_designations | <submit to AGC to add this> | ||||||
| contractor's accounting software | Q_tblQuestionnaire.FI_accounting | <submit to AGC to add this> | ||||||
| contractor's estimating software | Q_tblQuestionnaire.FI_estimating | <submit to AGC to add this> | ||||||
| contractor's job cost software | Q_tblQuestionnaire.FI_jobCost | <submit to AGC to add this> | ||||||
| fiscal year end (month) | Q_tblQuestionnaire.FI_FYE | <submit to AGC to add this> | ||||||
| tax payment basis (ex: accrual) | Q_tblQuestionnaire.FI_taxBasis | <submit to AGC to add this> | ||||||
| financial statement preparation basis (ex: cash) | Q_tblQuestionnaire.FI_statementBasis | <submit to AGC to add this> | ||||||
| level of assurance - financial statements (ex: CPA, qualified) | Q_tblQuestionnaire.FI_assuranceLevel | <submit to AGC to add this> | ||||||
| financial statement preparation interval (ex: quarterly) | Q_tblQuestionnaire.FI_statementInterval | <submit to AGC to add this> | ||||||
| work on hand statement preparation interval (ex: quarterly) | Q_tblQuestionnaire.FI_WOHInterval | <submit to AGC to add this> | ||||||
| Name of contractor's bank | Q_tblQuestionnaire.FI_Bank | <submit to AGC to add this> | ||||||
| Bank's website | Q_tblQuestionnaire.FI_BankWebsite | <submit to AGC to add this> | ||||||
| Bank address 1 | Q_tblQuestionnaire.FI_BankAddress | <submit to AGC to add this> | ||||||
| Bank address 2 | Q_tblQuestionnaire.FI_BankAddress2 | <submit to AGC to add this> | ||||||
| Bank city | Q_tblQuestionnaire.FI_BankCity | <submit to AGC to add this> | ||||||
| Bank state | Q_tblQuestionnaire.FI_BankState | <submit to AGC to add this> | ||||||
| Bank zipcode | Q_tblQuestionnaire.FI_BankZip | <submit to AGC to add this> | ||||||
| Bank Phone number | Q_tblQuestionnaire.FI_BankPhone | <submit to AGC to add this> | ||||||
| Bank fax number | Q_tblQuestionnaire.FI_BankFax | <submit to AGC to add this> | ||||||
| Bank contact courtesy title (ex: mr.) | Q_tblQuestionnaire.FI_BankCourtesy | <submit to AGC to add this> | ||||||
| Bank contact firstname | Q_tblQuestionnaire.FI_BankFirst | <submit to AGC to add this> | ||||||
| Bank contact middle initial | Q_tblQuestionnaire.FI_BankMI | <submit to AGC to add this> | ||||||
| Bank contact lastname | Q_tblQuestionnaire.FI_BankLast | <submit to AGC to add this> | ||||||
| Bank contact email | Q_tblQuestionnaire.FI_BankContactEmail | <submit to AGC to add this> | ||||||
| Bank contact Phone number | Q_tblQuestionnaire.FI_BankContactPhone | <submit to AGC to add this> | ||||||
| Bank contact Phone number extension | Q_tblQuestionnaire.FI_BankContactPhoneExt | <submit to AGC to add this> | ||||||
| Bank contact fax number | Q_tblQuestionnaire.FI_BankContactFax | <submit to AGC to add this> | ||||||
| Bank contact cell number | Q_tblQuestionnaire.FI_BankContactCell | <submit to AGC to add this> | ||||||
| Line of credit amount, total | Q_tblQuestionnaire.FI_LOC | <submit to AGC to add this> | ||||||
| Line of credit amount, in use | Q_tblQuestionnaire.FI_LOCinUse | <submit to AGC to add this> | ||||||
| Line of credit in use as of date | Q_tblQuestionnaire.FI_InUseAsOf | <submit to AGC to add this> | ||||||
| Line of credit expiration date | Q_tblQuestionnaire.Fi_LOCExp | <submit to AGC to add this> | ||||||
| NOTE: key personnel info below is repeated 5 times in our database, to allow for up to 5 different personnel | ||||||||
| Name of personnel member | Q_tblQuestionnaire.KP_name | <submit to AGC to add this> | ||||||
| Member's position | ||||||||