Name in AssignmentPro: Assignment Document (view)
Name in Database: vwEQ_ASSIGNMENT_DOCUMENT
Description inc. recommended uses and limitations: This view is recommended for use when the Assignment table and Document table are used in the same user report because it brings those two tables together via the view. It also includes numerous tables related to Assignment tables, Document tables, Move Management tables, Note and Communication tables, Production tables, Property tables and Tax tables.
Tables used in the view:
ASSIGNMENT
ASSIGNMENT_DEPENDENT
ASSIGNMENT_DEPENDENT_PASSPORT
ASSIGNMENT_EXTENSION
ASSIGNMENT_PACKAGE
ASSIGNMENT_PACKAGE_COST_ESTIMATE_COMP_CALC
ASSIGNMENT_PACKAGE_EMPLOYEE_PORTAL_DELIVERY
ASSIGNMENT_VISA
ASYNCHRONOUS_REPORT
CONTRACT
CONTRACT_EXTENSION
COST_ESTIMATE
DESTINATION_APPRAISAL
DESTINATION_APPRAISAL_DETAIL
DESTINATION_BUYER_SERVICE
DOCUMENT
DOCUMENT_ASSIGNMENT
DOCUMENT_ASSIGNMENT_DEPENDENT
DOCUMENT_ASSIGNMENT_DEPENDENT_PASSPORT
DOCUMENT_ASSIGNMENT_EXTENSION
DOCUMENT_ASSIGNMENT_PACKAGE
DOCUMENT_ASSIGNMENT_PACKAGE_COST_ESTIMATE_COMP_CALC
DOCUMENT_ASSIGNMENT_PACKAGE_EMPLOYEE_PORTAL_DELIVERY
DOCUMENT_ASSIGNMENT_VISA
DOCUMENT_COST_ESTIMATE
DOCUMENT_DESTINATION_APPRAISAL_DETAIL
DOCUMENT_DESTINATION_BUYER_SERVICE
DOCUMENT_EMPLOYEE
DOCUMENT_EMPLOYEE_PASSPORT
DOCUMENT_ESIGNATURE
DOCUMENT_MORTGAGE_INTEREST_DIFFERENTIAL
DOCUMENT_MOVE_MANAGEMENT
DOCUMENT_MOVE_MANAGEMENT_INSURANCE_CLAIM
DOCUMENT_NOTE_COMMUNICATION
DOCUMENT_PROPERTY
DOCUMENT_PROPERTY_CLOSING_DETAIL
DOCUMENT_PROPERTY_CONTRACT_DETAIL
DOCUMENT_PROPERTY_DISCLOSURE
DOCUMENT_PROPERTY_EQUITY_REQUEST_DETAIL
DOCUMENT_PROPERTY_ESCROW
DOCUMENT_PROPERTY_FINALIZATION
DOCUMENT_PROPERTY_INSPECTION_DETAIL
DOCUMENT_PROPERTY_LIEN_ASSESSMENT
DOCUMENT_PROPERTY_LIEN_HOA
DOCUMENT_PROPERTY_LIEN_MORTGAGE
DOCUMENT_PROPERTY_LIEN_TAX
DOCUMENT_PROPERTY_LISTING_EMPLOYEE
DOCUMENT_PROPERTY_LISTING_EMPLOYEE_AGENT_FOLLOW_UP
DOCUMENT_PROPERTY_LISTING_RESALE
DOCUMENT_PROPERTY_LISTING_RESALE_AGENT_FOLLOW_UP
DOCUMENT_PROPERTY_NEGOTIATION
DOCUMENT_PROPERTY_OFFER_DETAIL
DOCUMENT_PROPERTY_TITLE_DETAIL
DOCUMENT_PROPERTY_VALUATION_APPRAISAL
DOCUMENT_PROPERTY_VALUATION_BMA
DOCUMENT_REFERRAL
DOCUMENT_SPOUSE_DOMESTIC_PARTNER
DOCUMENT_SPOUSE_DOMESTIC_PARTNER_PASSPORT
DOCUMENT_TAX_BRIEFING
DOCUMENT_TAX_DETAIL
DOCUMENT_TAX_RETURN_DETAIL_NOTE
DOCUMENT_TAX_SOCIAL_INSURANCE
EMPLOYEE_PASSPORT
ESIGNATURE
MORTGAGE_INTEREST_DIFFERENTIAL
MOVE_MANAGEMENT
MOVE_MANAGEMENT_INSURANCE
MOVE_MANAGEMENT_INSURANCE_CLAIM
NOTE_COMM_ASSIGNMENT
NOTE_COMM_SERVICE_ORDER
NOTE_COMMUNICATION
PAGE
PRODUCTION_REPORT_BATCH
PRODUCTION_REPORT_BATCH_ITEM
PRODUCTION_REPORT_BATCH_ITEM_ASSIGNMENT
PRODUCTION_REPORT_BATCH_ITEM_COST_ESTIMATE
PROPERTY
PROPERTY_CLOSING
PROPERTY_CLOSING_DETAIL
PROPERTY_CONTRACT
PROPERTY_CONTRACT_DETAIL
PROPERTY_DISCLOSURE
PROPERTY_EQUITY_REQUEST
PROPERTY_EQUITY_REQUEST_DETAIL
PROPERTY_ESCROW
PROPERTY_FINALIZATION
PROPERTY_INSPECTION
PROPERTY_INSPECTION_DETAIL
PROPERTY_INSPECTION_REQUEST
PROPERTY_LIEN_ASSESSMENT
PROPERTY_LIEN_HOA
PROPERTY_LIEN_MORTGAGE
PROPERTY_LIEN_TAX
PROPERTY_LISTING_EMPLOYEE
PROPERTY_LISTING_EMPLOYEE_AGENT_FOLLOW_UP
PROPERTY_LISTING_RESALE
PROPERTY_LISTING_RESALE_AGENT_FOLLOW_UP
PROPERTY_NEGOTIATION
PROPERTY_OFFER
PROPERTY_OFFER_DETAIL
PROPERTY_TITLE_DETAIL
PROPERTY_VALUATION
PROPERTY_VALUATION_APPRAISAL
PROPERTY_VALUATION_BMA
REFERRAL
SERVICE_ORDER
SPOUSE_DOMESTIC_PARTNER
SPOUSE_DOMESTIC_PARTNER_PASSPORT
TAX_BRIEFING
TAX_DETAIL
TAX_RETURN_DETAIL
TAX_RETURN_DETAIL_NOTE
TAX_SOCIAL_INSURANCE
YEAR_END_TAX_REPORT
Fields contained in the view:
Click here for details on how to create a user report to return all fields for a given name in the database.