Name in AssignmentPro: Cost Estimate (View)
Name in Database: uv_COST_ESTIMATE
Description inc. recommended uses and limitations: This view enables you to pull through specific cost estimate details relating to a specific assignment record within user reports supporting cost estimate line items/Compensation modules and merge documents etc.
Tables used in the view:
COST_ESTIMATE
COST_ESTIMATE_BATCH
COST_ESTIMATE_TEMPLATE
Fields contained in the view:
General Cost Estimate Details
Allow cost allocation
Assignment id
Assignment start month
Authorization id
Base currency
Calculate taxes
Comp worksheet id
Company id
Cost estimate template id
Create by
Create date
Description
Effective date
Enable cost allocations to other
Fiscal period start month
Home family size
Host family size
Id
Inactive
Initial base salary
Is benefit set
Is compensation
Is what if cost estimate
Cost Estimate Label Details
Label calc
Label post year
Label year1
Label year2
Label year3
Label year4
Label year5
Label year6
Cost Estimate Last Update Details
Last calculated by
Last calculated date
Last update by
Last update date
Locked
Locked by
Locked date
Locked source
Cost Estimate Other Details
Marital status
Num years
Post assignment year
Primary estimate
Report title
Require admin review
Summary last update by
Summary last update date
System usage
Tax engine type
Type
Click here for details on how to create a user report to return all fields for a given name in the database.