GreenshadesOnline Integration Help
dbo.GO_EmployeePayRecordTimeOffBalances View
SQL Objects Database > dbo Schema : dbo.GO_EmployeePayRecordTimeOffBalances View
Description
This Table is required for Paystub only integration.
Properties
Creation Date7/17/2015 10:23 AM
Is Schema Bound
Encrypted
Ansi Nulls
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 TimeOffCodeThis field uniquely identifies the time off type, e.g. VAC, SCK, HOLvarchar50  
 EmployeeIDStores the unique identifier of a specific employeechar15   
 Parent_EmployeeID char15   
 DateObservedUTCThis should be the check date corresponding to the check numberdatetime4  
 BalanceStores the time off balance as of the current checkdecimal9 (28,12)  
 CheckNumberStores the check numbervarchar21  
 CurrentlyActive int4  
Objects that dbo.GO_EmployeePayRecordTimeOffBalances depends on
 Database ObjectObject TypeDescriptionDep Level
dbo.GO_EmployeeAddresses viewdbo.GO_EmployeeAddressesViewThis Table is required for Paystub only integration.2
dbo.GO_EmployeePayRecords viewdbo.GO_EmployeePayRecordsViewThis Table is required for Paystub only integration.1
See Also

Related Objects

dbo Schema
SQL Objects Database

 

 

© 2015 All Rights Reserved.

Send comments on this topic.