Page Comparison

Document Templates and Notification Templates make available a standard set of datasources used to select and insert merge fields into a template. The standard datasources are listed below.

...

Ui expand

expanded	true
title	Document/Notification Template Fields

Ui expand

title	Application/Request Fields (Application Request Standard for Documents)

The view name for this data source in database is VW_SVC_DATASRC_APP_REQUEST_STDRD_NOPARSE

Subject Area	Insertable Field Name	Description
Submission Information	Id	System Submission ID
	SubmissionReferenceNumber	Submission Reference Number
	SubmissionFormNumber	nFORM submission number
	SubmissionFormName	Form Name
	SubmissionFormType	Action Type
	SubmissionActionType	Submission Type (Application, Permit Change, etc..)
	SubmissionProjectName	Project Name
	SubmissionReceivedDate	Submission Received Date (yyyy-MM-dd HH:MM:SS)
	SubmissionCompleteDate	Submission Completed Date (yyyy-MM-dd HH:MM:SS)
	SubmissionPriority	Submission Priority
	SubmissionProcessDueDate	Submission Due Date (yyyy-MM-dd HH:MM:SS)
	SubmissionReviewCompleteDate	Submission Review Completed Date (yyyy-MM-dd HH:MM:SS)
Submission Contact (Applicant contact role)	ApplicantPrefix	Applicant Prefix (Mr, Ms, Mrs., etc.)
	ApplicantName	Applicant Display Name
	ApplicantFirstName	Applicant First Name
	ApplicantLastName	Applicant Last Name
	ApplicantAddress1	Applicant Address Line 1
	ApplicantAddress2	Applicant Address Line 2
	ApplicantCity	Applicant City
	ApplicantStateCode	Applicant State (2 letters format)
	ApplicantZip	Applicant Zipcode
	ApplicantPhone	Applicant Phone formatted with Extension if available
	ApplicantTitle	Applicant Title
	ApplicantOrganization	Applicant Organization
Assigned Staff	SubmissionStaffWorkgroupName	Assigned Workgroup Name
	SubmissionStaffDisplayName	Staff Display Name who's the application is assigned to
	SubmissionStaffFirstName	Staff First Name
	SubmissionStaffLastName	Staff Last Name
	SubmissionStaffEmail	Staff Email address
	SubmissionStaffPhone	Staff Phone Number with extinction if available
	SubmissionStaffOrganization	Staff Organization Name
	SubmissionStaffWorkgroupSupervisorName	Staff Supervisor Name
System Info	AgencyAcronym	Agency Acronym
	AgencyFullName	Agency Full Name
	SystemContactUrl	Website address for agency contact information
	SystemName	System Name
	SystemUrl	System website address
	SystemIsProduction	System is Production (1 or 0 values)
Site	SiteNumber	Site Number
	SiteName	Site Name
	SiteAddress	Site full address, Address Line 1 Address Line 2 City, State Zip-Code
	SiteAddress1	Site Address line 1
	SiteAddress2	Site Address line 2
	SiteCity	Site City
	SiteStateCode	Site State (2 letters format)
	SiteZipCode	Site Zipcode
	SiteTaxParcelNumber	Site Parcel Id
	SiteAddressComments	Site Address Comments
	SiteOwnrshType	Owner Type (Public, Private, etc..)
	SiteSicList	Standard Industrial Classification Code (SIC)
	SiteNaicsList	North American Industry Classification System Code (NAICS)
	AccountVerificationCode	Account Verification Code
Site Location	SiteLatitude	Site Latitude
	SiteLongitude	Site Longitude
	SiteCounty	Site County Name
	SiteFipsCode	Site FIPS Code (Federal Information Processing Standard)
Site Alt Name	SiteAltNames_SiteAltNameTypeDescription	Site Alternative Name Description (Master ID, Historical Name, etc..)
	SiteAltNames_SiteAltNameTypeCode	Site Alternative Name Tag
	SiteAltNames_SiteAltName	Site Alternative Name Description
District Office	DistrictOfficeName	Name of District Office (Based on County defined in District Office Lookups)
	DistrictSupervisorName	District Office Supervisor Name
	DistrictOfficeAddress	District Office full address, Address Line 1 Address Line 2 City, State Zip-Code
	DistrictOfficeAddress1	District Office Address Line 1
	DistrictOfficeAddress2	District Office Address Line 2
	DistrictOfficeCity	District Office City
	DistrictOfficeState	District Office State (2 Letters Format)
	DistrictOfficeZip	District Office Zip code
	DistrictOfficePhone	District Office Phone formatted with Extension if available
	DistrictOfficeFax	District Office Fax number
Contact
	9	Contact Prefix (Mr, Ms, Mrs., etc.)
	10	First Name
	11	Last Name
	12	Display Name
	13	Organization Name
	14	Title
	15	Address Line 1
	16	Address Line 2
	17	City
	18	Contact State (2 letters format)
	19	Zip Code
	20	City, State Zip Code (Portland, OR 97239)
	21	Email
	22	Contact Affiliation Code, a List of types is configured in Admin → Lookups → Affiliation Types (Roles)
	23	Contact Affiliation Description, a List of types is configured in Admin → Lookups → Affiliation Types (Roles)
	24	Phone Number
	25	Phone Extension
	26	Phone Type (Home, Mobile, etc..)
Permit Info	PermitNumber	Permit Number
	PermitVersion	Permit Version this is the major version before the decimal ( 1 .x)
	PermitRevision	permit revision, this is the first decimal after the version (x. 1 )
	PermitNumberAndVersion	Permit number and version eg. (PRMT0001 v 1.0)
	PermitCategory	Permit Category
	PermitType	Permit Type
	PermitStatus	Permit Status (In Effect, Expired, etc...)
	PermitIssueDate	Permit Issue Date (yyyy-MM-dd HH:MM:SS)
	PermitEffectiveDate	Permit Effective Date (yyyy-MM-dd HH:MM:SS)
	PermitExpireDate	Permit Expiration Date (yyyy-MM-dd HH:MM:SS)
Events	EventComments	Event comments
	EventEndDate	Event end date (yyyy-MM-dd HH:MM:SS)
	EvnetStartDate	Event start date (yyyy-MM-dd HH:MM:SS)
	EventTypeDescription	Event type description
	EventTypeId	Event type ID

Ui expand

title	Permit Fields (Permit Standard for Documents)

The view name for this data source in database is VW_SVC_DATASRC_PERMIT_STDRD_NOPARSE

Subject Area	Insertable Field Name	Description
Assigned Staff	AgencyContactOrganization	Agency Contact Organization
	AgencyContactUserDisplayName	Agency Contact User Display Name
	AgencyContactUserEmail	Agency Contact User Email
	AgencyContactUserFirstName	Agency Contact User First Name
	AgencyContactUserLastName	Agency Contact User Last Name
	AgencyContactUserPhone	Agency Contact User Phone formatted with Extension if available
	AgencyContactWorkgroupName	Agency Contact Workgroup Name
	AgencyContactWorkgroupSupervisorName	Agency Contact Workgroup Supervisor Name
Compliance Staff	ComplianceManagerDisplayName	Compliance Manager Dipslay Name
	ComplianceManagerEmail	Compliance Manager Email
	ComplianceManagerFirstName	Compliance Manager First Name
	ComplianceManagerLastName	Compliance Manager Last Name
	ComplianceManagerOrganization	Compliance Manager Organization
	ComplianceManagerPhone	Compliance Manager Phone formatted with Extension if available
	ComplianceManagerWorkgroupName	Compliance Manager Workgroup Name
	ComplianceManagerWorkgroupSupervisorName	Compliance Manager Workgroup Supervisor Name
Contact	Contacts_AffiliationTypeCode	Contact Affiliation Code, a List of types is configured in Admin → Lookups → Affiliation Types (Roles)
	Contacts_AffiliationTypeDescription	Contact Affiliation Description, a List of types is configured in Admin → Lookups → Affiliation Types (Roles)
	Contacts_ContactAddress1	Contact Address Line 1
	Contacts_ContactAddress2	Contact Address Line 2
	Contacts_ContactCity	Contact City
	Contacts_ContactCityStateZip	City, State Zip Code (Portland, OR 97239)
	Contacts_ContactEmail	Contact Email
	Contacts_ContactFirstName	Contact First Name
	Contacts_ContactLastName	Contact Last Name
	Contacts_ContactName	Contact Name
	Contacts_ContactOrganizationName	Contact Organization Name
	Contacts_ContactPhone	Contact Phone
	Contacts_ContactPhoneExtension	Contact Phone Extension
	Contacts_ContactPhoneTypeDescription	Phone Type (Home, Mobile, etc..)
	Contacts_ContactPrefix	Contact Prefix (Mr, Ms, Mrs., etc.)
	Contacts_ContactState	Contact State (2 letters format)
	Contacts_ContactTitle	Contact Title
	Contacts_ContactZipCode	Contact Zip Code
	Contacts_FunctionalAreaId	Functional Area Id
Account code	Id	Id
Account code	AccountVerificationCode	Account Verification Code
Permit Contact Info (Permittee contact role)	PermitteeAddress1	Permittee Address Line 1
	PermitteeAddress2	Permittee Address Line 2
	PermitteeCity	Permittee City
	PermitteeFirstName	Permittee First Name
	PermitteeLastName	Permittee Last Name
	PermitteeName	Permittee Display Name
	PermitteeOrganization	Permittee Organization
	PermitteePhone	Permittee Phone formatted with Extension if available
	PermitteePrefix	Permittee Prefix (Mr, Ms, Mrs., etc.)
	PermitteeState	Permittee State (2 letters format)
	PermitteeTitle	Permittee Title
	PermitteeZip	Permittee Zip
District Office	DistrictOfficeAddress	District Office full address, Address Line 1 Address Line 2 City, State Zip-Code
	DistrictOfficeAddress1	District Office Address Line 1
	DistrictOfficeAddress2	District Office Address Line 2
	DistrictOfficeCity	District Office City
	DistrictOfficeFax	District Office Fax
	DistrictOfficeName	Name of District Office (Based on County defined in District Office Lookups)
	DistrictOfficePhone	District Office Phone formatted with Extension if available
	DistrictOfficeState	District Office State (2 letters format)
	DistrictOfficeZip	District Office Zip code
	DistrictSupervisorName	District Office supervisor name
Permit Info	PermitApplicationDueDate	Permit application due date (yyyy-MM-dd HH:MM:SS)
	PermitCategory	Permit category
	PermitComments	Permit comments
	PermitEffectiveDate	Permit effective date (yyyy-MM-dd HH:MM:SS)
	PermitExpireDate	Permit expiry date (yyyy-MM-dd HH:MM:SS)
	PermitIsAfterTheFact	Permit is after the fact (1 or 0 value)
	PermitIssueDate	Permit issue date (yyyy-MM-dd HH:MM:SS)
	PermitNumber	Permit number
	PermitNumberAndVersion	Permit number and version eg. (PRMT0001 v 1.0)
	PermitRevision	permit revision, this is the first decimal after the version (x. 1 )
	PermitStatus	Permit status
	PermitTerminationDate	Permit Termination Date (yyyy-MM-dd HH:MM:SS)
	PermitType	Permit Type
	PermitVersion	Permit Version this is the major version before the decimal ( 1 .x)
Schedule	Schedules_IsReoccurring	Schedules is Reoccurring (1 and 0 value)
	Schedules_NumDaysBeforeDueAllowSubmission	Number of Days before schedule submission is allowed
	Schedules_ScheduleAchievedDate	Schedule achieved date (yyyy-MM-dd HH:MM:SS)
	Schedules_ScheduleDecisionDate	Schedule decision date (yyyy-MM-dd HH:MM:SS)
	Schedules_ScheduleDueDate	Schedule due date (yyyy-MM-dd HH:MM:SS)
	Schedules_ScheduleDueDateTypeDescription	Type of schedule due date (as needed, specific due date, etc..)
	Schedules_ScheduleGroupName	Schedule group name
	Schedules_ScheduleName	Schedule name
	Schedules_ScheduleReceivedDate	Schedule received date (yyyy-MM-dd HH:MM:SS)
	Schedules_ScheduleSequenceNumber	Schedule sequence number
	Schedules_ScheduleStatusDescription	Schedule status description (Received, Not Submitted, etc..)
	Schedules_SubmissionDecisionDate	Schedule submission decision date (yyyy-MM-dd HH:MM:SS)
	Schedules_SubmissionDecisionDescription	Schedule submission decision description
	Schedules_SubmissionReceivedDate	Schedule submission received date (yyyy-MM-dd HH:MM:SS)
	Schedules_SubmissionVersionNumber	Schedule submission version number
Site	SiteAddress	Site full address, Address Line 1 Address Line 2 City, State Zip-Code
	SiteAddress1	Site address line 1
	SiteAddress2	Site address line 2
	SiteAddressComments	Site address comments
	SiteCity	Site city
	SiteNaicsList	North American Industry Classification System Code (NAICS)
	SiteName	Site name
	SiteNumber	Site number
	SiteOwnrshType	Site ownership type
	SiteSicList	Standard Industrial Classification Code (SIC)
	SiteState	Site state (2 letters format)
	SiteTaxParcelNumber	Site tax parcel number
	SiteZip	Site zip code
	AccountVerificationCode	Account Verification Code
Site Alt Name	SiteAltNames_SiteAltName	Site alternative name
	SiteAltNames_SiteAltNameTypeCode	Site alternative name type code
	SiteAltNames_SiteAltNameTypeDescription	Site Alternative Name Description (Master ID, Historical Name, etc..)
Site Location	SiteCounty	Site county
	SiteFipsCode	Site FIPS Code (Federal Information Processing Standard)
	SiteLatitude	Site location Latitude
	SiteLongitude	Site location Longitude
Submission Info	SubmissionActionType	Submission Type (Application, Permit Change, etc..)
	SubmissionCompleteDate	Submission completed date (yyyy-MM-dd HH:MM:SS)
	SubmissionFormName	Submission form name
	SubmissionFormNumber	nFORM submission number
	SubmissionFormType	Submission form type
	SubmissionProjectName	Submission project name
	SubmissionReceivedDate	Submission received date (yyyy-MM-dd HH:MM:SS)
	SubmissionReferenceNumber	Submission referenced number
System Info	AgencyAcronym	Agency Acronym
	AgencyFullName	Agency full name
	SystemContactUrl	Agency website for contact information
	SystemIsProduction	System is Production (1 or 0 values)
	SystemName	System name
	SystemUrl	Website link to the system
Events	EventComments	Event comments
	EventEndDate	Event end date (yyyy-MM-dd HH:MM:SS)
	EvnetStartDate	Event start date (yyyy-MM-dd HH:MM:SS)
	EventTypeDescription	Event type description
	EventTypeId	Event type ID

Ui expand

title	Evaluation Fields (Evaluation Standard for Documents)

The view name for this data source in database is VW_SVC_DATASRC_EVAL_STDRD_NOPARSE

Subject Area	Insertable Field Name	Description
Assigned Staff	EvaluationAssignedUserDisplayName	Inspector display name
	EvaluationAssignedUserEmail	Inspector email
	EvaluationAssignedUserFirstName	Inspector first name
	EvaluationAssignedUserLastName	Inspector last name
	EvaluationAssignedUserOrganization	inspector organization
	EvaluationAssignedUserPhone	Inspector Phone formatted with Extension if available
	EvaluationAssignedWorkgroupName	Inspector work group
	EvaluationAssignedWorkgroupSupervisorName	Inspector work group supervisor name
Compliance Info	ComplianceActionCaseNumber	Compliance action case number
	ComplianceActionCategory	Compliance action category
	ComplianceActionDate	Compliance action date (yyyy-MM-dd HH:MM:SS)
	ComplianceActionNumber	Compliance action number
	ComplianceActionProgramArea	Compliance action program area
	ComplianceActionResolutionDate	Compliance action resolution date (yyyy-MM-dd HH:MM:SS)
	ComplianceActionResolutionDescription	Compliance action resolution description
	ComplianceActionStatus	Compliance action status
	ComplianceActionType	Compliance action type
Contact	Contacts_AffiliationTypeCode	Contact Affiliation Code, a List of types is configured in Admin → Lookups → Affiliation Types (Roles)
	Contacts_AffiliationTypeDescription	Contact Affiliation Description, a List of types is configured in Admin → Lookups → Affiliation Types (Roles)
	Contacts_ContactAddress1	Contact Address Line 1
	Contacts_ContactAddress2	Contact Address Line 2
	Contacts_ContactCity	Contact City
	Contacts_ContactCityStateZip	City, State Zip Code (Portland, OR 97239)
	Contacts_ContactEmail	Contact Email
	Contacts_ContactFirstName	Contact First Name
	Contacts_ContactLastName	Contact Last Name
	Contacts_ContactName	Contact Display Name
	Contacts_ContactOrganizationName	Contact Organization Name
	Contacts_ContactPhone	Contact Phone
	Contacts_ContactPhoneExtension	Contact Phone Extension
	Contacts_ContactPhoneTypeDescription	Phone Type (Home, Mobile, etc..)
	Contacts_ContactPrefix	Contact Prefix (Mr, Ms, Mrs., etc.)
	Contacts_ContactState	Contact State (2 letters format)
	Contacts_ContactTitle	Contact Title
	Contacts_ContactZipCode	Contact Zip Code
	Contacts_FunctionalAreaId	Functional Area Id
Permittee and Inspection Contact (Inspection Contact contact role)	InspectionContactAddress1	Facility inspection contact address line 1
	InspectionContactAddress2	Facility inspection contact address line 2
	InspectionContactCity	Facility inspection contact city
	InspectionContactFirstName	Facility inspection contact first name
	InspectionContactLastName	Facility inspection contact last name
	InspectionContactName	Facility inspection contact display name
	InspectionContactOrganization	Facility inspection contact organization name
	InspectionContactPhone	Facility inspection contact Phone formatted with Extension if available
	InspectionContactPrefix	Facility inspection contact name Prefix (Mr, Ms, Mrs., etc.)
	InspectionContactState	Facility inspection contact state (2 letters format)
	InspectionContactTitle	Facility inspection contact title
	InspectionContactZip	Facility inspection contact zip code
	PermitteeAddress1	Permittee address line 1
	PermitteeAddress2	Permittee address line 2
	PermitteeCity	Permittee address city
	PermitteeFirstName	Permittee first name
	PermitteeLastName	Permittee last name
	PermitteeName	Permittee display name
	PermitteeOrganization	Permittee organization name
	PermitteePhone	Permittee Phone formatted with Extension if available
	PermitteePrefix	Permittee name Prefix (Mr, Ms, Mrs., etc.)
	PermitteeState	Permittee state (2 letters format)
	PermitteeTitle	Permittee title
	PermitteeZip	Permittee zip code
District Office	DistrictOfficeAddress	Agency district office full address Address Line 1 Address Line 2 City, State Zip-Code
	DistrictOfficeAddress1	Agency district office address line 1
	DistrictOfficeAddress2	Agency district office address line 2
	DistrictOfficeCity	Agency district office city
	DistrictOfficeFax	Agency district office fax number
	DistrictOfficeName	Name of District Office (Based on County defined in District Office Lookups)
	DistrictOfficePhone	Agency district office Phone formatted with Extension if available
	DistrictOfficeState	Agency district office state (2 letters format)
	DistrictOfficeZip	Agency district office zip code
	DistrictSupervisorName	Agency district office supervisor name
Evaluation Info	EvaluationComments	Evaluation comments
	EvaluationDecision	Evaluation decision
	EvaluationDecisionDate	Evaluation decision date (yyyy-MM-dd HH:MM:SS)
	EvaluationEndDate	Evaluation end date (yyyy-MM-dd HH:MM:SS)
	EvaluationNumber	Evaluation number
	EvaluationReportTransmittedDate	Evaluation report transmitted date (yyyy-MM-dd HH:MM:SS)
	EvaluationSamplesTransmittedDate	Evaluation samples transmitted date (yyyy-MM-dd HH:MM:SS)
	EvaluationScheduledDate	Evaluation scheduled date (yyyy-MM-dd HH:MM:SS)
	EvaluationStartDate	Evaluation start date (yyyy-MM-dd HH:MM:SS)
	EvaluationStatus	Evaluation status
	EvaluationStatusDescription	Evaluation status description
	EvaluationType	Evaluation type
Permit Info	PermitApplicationDueDate	Permit application due date (yyyy-MM-dd HH:MM:SS)
	PermitCategory	Permit category
	PermitComments	Permit comments
	PermitEffectiveDate	Permit effective date (yyyy-MM-dd HH:MM:SS)
	PermitExpireDate	Permit expire date (yyyy-MM-dd HH:MM:SS)
	PermitIsAfterTheFact	Permit is after the fact (1 or 0 value)
	PermitIssueDate	Permit issue date (yyyy-MM-dd HH:MM:SS)
	PermitNumber	Permit number
	PermitNumberAndVersion	Permit number and version eg. (PRMT0001 v 1.0)
	PermitRevision	permit revision, this is the first decimal after the version (x. 1 )
	PermitStatus	Permit status
	PermitTerminationDate	Permit termination date (yyyy-MM-dd HH:MM:SS)
	PermitType	Permit type
	PermitVersion	Permit Version this is the major version before the decimal ( 1 .x)
Project Info	MasterProjectEnvironmentalEventDate	Master Environmental project event date (yyyy-MM-dd HH:MM:SS)
	MasterProjectName	Master project name
	MasterProjectNumber	Master project number
	ProjectActivityCategory	Project activity category
	ProjectActivityEndDate	Project activity end date (yyyy-MM-dd HH:MM:SS)
	ProjectActivityName	Project activity name
	ProjectActivityNumber	Project activity number
	ProjectActivityStartDate	Project activity start date (yyyy-MM-dd HH:MM:SS)
	ProjectActivityStatus	Project activity status
	ProjectActivityType	Project activity type
Site	SiteAddress	Site full address Site Address Line 1 Site Address Line 2 City, State zip-code
	SiteAddress1	Site address line 1
	SiteAddress2	Site address line 2
	SiteAddressComments	Site address comments
	SiteCity	Site city
	SiteNaicsList	North American Industry Classification System Code (NAICS)
	SiteName	Site name
	SiteNumber	Site number
	SiteOwnrshType	Site ownership type
	SiteSicList	Standard Industrial Classification Code (SIC)
	SiteState	Site state (2 letters format)
	SiteTaxParcelNumber	Site tax parcel number
	SiteZip	Site zip-code
	AccountVerificationCode	Account Verification Code
Site Alt Name	SiteAltNames_SiteAltName	Site alternative name
	SiteAltNames_SiteAltNameTypeCode	Site alternative name type code
	SiteAltNames_SiteAltNameTypeDescription	Site Alternative Name Description (Master ID, Historical Name, etc..)
Site Location	SiteCounty	Site county
	SiteFipsCode	Site FIPS Code (Federal Information Processing Standard)
	SiteLatitude	Site location Latitude
	SiteLongitude	Site location Longitude
Submission Info	SubmissionActionType	Submission Type (Application, Permit Change, etc..)
	SubmissionCompleteDate	Submission completed date (yyyy-MM-dd HH:MM:SS)
	SubmissionFormName	Submission form name
	SubmissionFormNumber	nFORM submission number
	SubmissionFormType	Submission form type
	SubmissionProjectName	Submission project name
	SubmissionReceivedDate	Submission received date (yyyy-MM-dd HH:MM:SS)
	SubmissionReferenceNumber	Submission referenced number
System Info	AgencyAcronym	Agency Acronym
	AgencyFullName	Agency full name
	SystemContactUrl	Agency website for contact information
	SystemIsProduction	System is Production (1 or 0 values)
	SystemName	System name
	SystemUrl	Website link to the system
Violation	Violations_DetectEndDate	Violation end date (yyyy-MM-dd HH:MM:SS)
	Violations_DetectStartDate	Violation start date (yyyy-MM-dd HH:MM:SS)
	Violations_Id	Violation system id
	Violations_IsSignificantNonCompliance	Violation is significant non compliance (1 or 0 value)
	Violations_RegulationReference	Violation regulation reference
	Violations_ViolationCategoryDescription	Violation category description
	Violations_ViolationComments	Violation comments
	Violations_ViolationId	Violation id
	Violations_ViolationTypeDescription	Violation type description
Events	EventComments	Event comments
	EventEndDate	Event end date (yyyy-MM-dd HH:MM:SS)
	EvnetStartDate	Event start date (yyyy-MM-dd HH:MM:SS)
	EventTypeDescription	Event type description
	EventTypeId	Event type ID

Ui expand

title	Compliance Action Fields (Compliance Action Standard for Documents)

The view name for this data source in database is VW_SVC_DATASRC_CMPL_ACTN_STDRD_NOPARSE

Subject Area	Insertable Field Name	Description
Assigned Staff	ComplianceActionAssignedUserDisplayName	Compliance Action assigned user Display Name
	ComplianceActionAssignedUserEmail	Compliance Action assigned user Email
	ComplianceActionAssignedUserFirstName	Compliance Action assigned user First Name
	ComplianceActionAssignedUserLastName	Compliance Action assigned user Last Name
	ComplianceActionAssignedUserOrganization	Compliance Action assigned user Organization
	ComplianceActionAssignedUserPhone	Compliance Action assigned user Phone formatted with Extension if available
	ComplianceActionAssignedWorkgroupName	Compliance Action assigned user Workgroup Name
	ComplianceActionAssignedWorkgroupSupervisorName	Compliance Action assigned user Workgroup Supervisor Name
Compliance Info	ComplianceActionCaseNumber	Compliance Action Case Number
	ComplianceActionCategory	Compliance Action Category
	ComplianceActionComments	Compliance Action Comments
	ComplianceActionDate	Compliance Action date (yyyy-MM-dd HH:MM:SS)
	ComplianceActionNumber	Compliance Action Number
	ComplianceActionProgramArea	Compliance Action Program Area
	ComplianceActionResolutionDate	Compliance Action Resolution date (yyyy-MM-dd HH:MM:SS)
	ComplianceActionResolutionType	Compliance Action Resolution Type
	ComplianceActionStatus	Compliance Action Status
	ComplianceActionType	Compliance Action Type
Contact	Contacts_AffiliationTypeCode	Contact Affiliation Code, a List of types is configured in Admin → Lookups → Affiliation Types (Roles)
	Contacts_AffiliationTypeDescription	Contact Affiliation Description, a List of types is configured in Admin → Lookups → Affiliation Types (Roles)
	Contacts_ContactAddress1	Contact Address Line 1
	Contacts_ContactAddress2	Contact Address Line 2
	Contacts_ContactCity	Contact City
	Contacts_ContactCityStateZip	City, State Zip Code (Portland, OR 97239)
	Contacts_ContactEmail	Contact Email
	Contacts_ContactFirstName	Contact First Name
	Contacts_ContactLastName	Contact Last Name
	Contacts_ContactName	Contact Display Name
	Contacts_ContactOrganizationName	Contact Organization Name
	Contacts_ContactPhone	Contact Phone
	Contacts_ContactPhoneExtension	Contact Phone Extension
	Contacts_ContactPhoneTypeDescription	Phone Type (Home, Mobile, etc..)
	Contacts_ContactPrefix	Contact Prefix (Mr, Ms, Mrs., etc.)
	Contacts_ContactState	Contact State (2 letters format)
	Contacts_ContactTitle	Contact Title
	Contacts_ContactZipCode	Contact Zip Code
	Contacts_FunctionalAreaId	Functional Area Id
Responsible Party Contact (Responsible Party contact role)	ResponsiblePartyAddress1	Responsible Party Address line 1
	ResponsiblePartyAddress2	Responsible Party Address line 2
	ResponsiblePartyCity	Responsible Party City
	ResponsiblePartyFirstName	Responsible Party First Name
	ResponsiblePartyLastName	Responsible Party Last Name
	ResponsiblePartyName	Responsible Party Name
	ResponsiblePartyOrganization	Responsible Party Organization
	ResponsiblePartyPhone	Responsible Party Phone formatted with Extension if available
	ResponsiblePartyPrefix	Responsible Party Prefix (Mr, Ms, Mrs., etc.)
	ResponsiblePartyState	Responsible Party State (2 letters format)
	ResponsiblePartyTitle	Responsible Party Title
	ResponsiblePartyZip	Responsible Party Zip
District Office	DistrictOfficeAddress	Agency district office full address Address Line 1 Address Line 2 City, State Zip-Code
	DistrictOfficeAddress1	Agency district office address line 1
	DistrictOfficeAddress2	Agency district office address line 2
	DistrictOfficeCity	Agency district office city
	DistrictOfficeFax	Agency district office fax number
	DistrictOfficeName	Name of District Office (Based on County defined in District Office Lookups)
	DistrictOfficePhone	Agency district office Phone formatted with Extension if available
	DistrictOfficeState	Agency district office state (2 letters format)
	DistrictOfficeZip	Agency district office zip code
	DistrictSupervisorName	Agency district office supervisor name
Evaluation Info	EvaluationComments	Evaluation comments
	EvaluationDecision	Evaluation decision
	EvaluationDecisionDate	Evaluation decision date (yyyy-MM-dd HH:MM:SS)
	EvaluationEndDate	Evaluation end date (yyyy-MM-dd HH:MM:SS)
	EvaluationNumber	Evaluation number
	EvaluationReportTransmittedDate	Evaluation report transmitted date (yyyy-MM-dd HH:MM:SS)
	EvaluationSamplesTransmittedDate	Evaluation samples transmitted date (yyyy-MM-dd HH:MM:SS)
	EvaluationScheduledDate	Evaluation scheduled date (yyyy-MM-dd HH:MM:SS)
	EvaluationStartDate	Evaluation start date (yyyy-MM-dd HH:MM:SS)
	EvaluationStatus	Evaluation status
	EvaluationStatusDescription	Evaluation status description
	EvaluationType	Evaluation type
Permit Info	PermitApplicationDueDate	Permit application due date (yyyy-MM-dd HH:MM:SS)
	PermitCategory	Permit category
	PermitComments	Permit comments
	PermitEffectiveDate	Permit effective date (yyyy-MM-dd HH:MM:SS)
	PermitExpireDate	Permit expire date (yyyy-MM-dd HH:MM:SS)
	PermitIsAfterTheFact	Permit is after the fact (1 or 0 value)
	PermitIssueDate	Permit issue date (yyyy-MM-dd HH:MM:SS)
	PermitNumber	Permit number
	PermitNumberAndVersion	Permit number and version eg. (PRMT0001 v 1.0)
	PermitRevision	permit revision, this is the first decimal after the version (x. 1 )
	PermitStatus	Permit status
	PermitTerminationDate	Permit termination date (yyyy-MM-dd HH:MM:SS)
	PermitType	Permit type
	PermitVersion	Permit Version this is the major version before the decimal ( 1 .x)
Schedule	Schedules_IsReoccurring	Schedules is Reoccurring (1 and 0 value)
	Schedules_NumDaysBeforeDueAllowSubmission	Number of Days before schedule submission is allowed
	Schedules_ScheduleAchievedDate	Schedule achieved date (yyyy-MM-dd HH:MM:SS)
	Schedules_ScheduleDecisionDate	Schedule decision date (yyyy-MM-dd HH:MM:SS)
	Schedules_ScheduleDueDate	Schedule due date (yyyy-MM-dd HH:MM:SS)
	Schedules_ScheduleDueDateTypeDescription	Type of schedule due date (as needed, specific due date, etc..)
	Schedules_ScheduleGroupName	Schedule group name
	Schedules_ScheduleName	Schedule name
	Schedules_ScheduleReceivedDate	Schedule received date (yyyy-MM-dd HH:MM:SS)
	Schedules_ScheduleSequenceNumber	Schedule sequence number
	Schedules_ScheduleStatusDescription	Schedule status description (Received, Not Submitted, etc..)
	Schedules_SubmissionDecisionDate	Schedule submission decision date (yyyy-MM-dd HH:MM:SS)
	Schedules_SubmissionDecisionDescription	Schedule submission decision description
	Schedules_SubmissionReceivedDate	Schedule submission received date (yyyy-MM-dd HH:MM:SS)
	Schedules_SubmissionVersionNumber	Schedule submission version number
Site	SiteAddress	Site full address Site Address Line 1 Site Address Line 2 City, State zip-code
	SiteAddress1	Site address line 1
	SiteAddress2	Site address line 2
	SiteAddressComments	Site address comments
	SiteCity	Site city
	SiteNaicsList	North American Industry Classification System Code (NAICS)
	SiteName	Site name
	SiteNumber	Site number
	SiteOwnrshType	Site ownership type
	SiteSicList	Standard Industrial Classification Code (SIC)
	SiteState	Site state (2 letters format)
	SiteTaxParcelNumber	Site tax parcel number
	SiteZip	Site zip-code
	AccountVerificationCode	Account Verification Code
Site Alt Name	SiteAltNames_SiteAltName	Site alternative name
	SiteAltNames_SiteAltNameTypeCode	Site alternative name type code
	SiteAltNames_SiteAltNameTypeDescription	Site Alternative Name Description (Master ID, Historical Name, etc..)
Site Location	SiteCounty	Site county
	SiteFipsCode	Site FIPS Code (Federal Information Processing Standard)
	SiteLatitude	Site location Latitude
	SiteLongitude	Site location Longitude
Submission Info	SubmissionActionType	Submission Type (Application, Permit Change, etc..)
	SubmissionCompleteDate	Submission completed date (yyyy-MM-dd HH:MM:SS)
	SubmissionFormName	Submission form name
	SubmissionFormNumber	nFORM submission number
	SubmissionFormType	Submission form type
	SubmissionProjectName	Submission project name
	SubmissionReceivedDate	Submission received date (yyyy-MM-dd HH:MM:SS)
	SubmissionReferenceNumber	Submission referenced number
System Info	AgencyAcronym	Agency Acronym
	AgencyFullName	Agency full name
	SystemContactUrl	Agency website for contact information
	SystemIsProduction	System is Production (1 or 0 values)
	SystemName	System name
	SystemUrl	Website link to the system
Violation	Violations_DetectEndDate	Violation end date (yyyy-MM-dd HH:MM:SS)
	Violations_DetectStartDate	Violation start date (yyyy-MM-dd HH:MM:SS)
	Violations_Id	Violation system id
	Violations_IsSignificantNonCompliance	Violation is significant non compliance (1 or 0 value)
	Violations_PermitNumberAndVersion	Violation related Permit number and version eg. (PRMT0001 v 1.0)
	Violations_RegulationReference	Violation regulation reference
	Violations_SourceEvaluationNumber	Violation source evaluation number
	Violations_ViolationCategoryDescription	Violation category description
	Violations_ViolationComments	Violation comments
	Violations_ViolationId	Violation id
	Violations_ViolationTypeDescription	Violation type description
Events	EventComments	Event comments
	EventEndDate	Event end date (yyyy-MM-dd HH:MM:SS)
	EvnetStartDate	Event start date (yyyy-MM-dd HH:MM:SS)
	EventTypeDescription	Event type description
	EventTypeId	Event type ID

...

Versions Compared

Old Version 11

New Version 12

Key