GreenshadesOnline Integration Help
dbo.GO_EmployeeFringeBenefitElectedCoverages View
SQL Objects Database > dbo Schema : dbo.GO_EmployeeFringeBenefitElectedCoverages View
Properties
Creation Date7/17/2015 10:23 AM
Is Schema Bound
Encrypted
Ansi Nulls
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 EmployeeIDStores the unique identifier of a specific employeechar15   
 HROptionCode varchar7  
 VersionID int4  
 CoverageType char7   
 BenType varchar14   
 Status varchar10   
 ApprovedDateUTC int4  
 ApprovedBy varchar15   
 EmployeeAmount numeric9 (20,5)  
 PreTaxEmployeeAmount numeric9 (19,5)   
 AfterTaxEmployeeAmount numeric9 (19,5)   
 SpouseAmount numeric9 (19,5)   
 ChildAmount numeric9 (19,5)   
 NumberOfChildren smallint2   
 EmployeePercent numeric9 (20,5)  
 PreTaxContributionPercentage numeric9 (19,5)   
 AfterTaxContributionPercentage numeric9 (19,5)   
 Parent_EmployeeID char15   
Objects that depend on dbo.GO_EmployeeFringeBenefitElectedCoverages
 Database ObjectObject TypeDescriptionDep Level
dbo.GO_EmployeeFringeBenefitEnrolledDependents viewdbo.GO_EmployeeFringeBenefitEnrolledDependentsView 1
See Also

Related Objects

dbo Schema
SQL Objects Database

 

 

© 2015 All Rights Reserved.

Send comments on this topic.