GreenshadesOnline Integration Help
dbo.GO_EmployeeDDAInfo View
| SQL Objects Database > dbo Schema : dbo.GO_EmployeeDDAInfo View |
| Creation Date | 7/17/2015 10:23 AM |
| Is Schema Bound |  |
| Encrypted | |
| Ansi Nulls |  |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| EmployeeID | Employee ID | char | 15 | ||||
| LineNumber | Line number this Direct Deposit Displays on | int | 4 |  | |||
| Active | Active or inactive [1 or 0] | bit | 1 | | |||
| Percent | Percent amount | int | 4 | | |||
| Amount | Dollar Amount | numeric | 9 (19,5) | ||||
| AccountNumber | Account number of Direct Deposit | char | 17 | ||||
| RoutingNumber | Routing number for Account | char | 9 | ||||
| AccountType | Savings / Checking | varchar | 8 | ||||
| IsRemainder | is the remainder [1 or 0] | bit | 1 | | |||
| EmployeeDDAInfoID | int | 4 | |||||
| Parent_EmployeeID | char | 15 |