Beneficiary
| EmpUID | Employee Unique ID | BigID | 12 | ||
| CompanyID | Company Identifier | SmallID | 12 | ||
| BenefyID | Beneficiary Identifier | BigID | 12 | Unique identifier for the beneficiary record. | |
| LastName | Last Name | Varchar | 40 | ||
| FirstName | First Name | Varchar | 80 | ||
| MiddleName | Middle Name | Varchar | 40 | ||
| Address1 | Address, Line 1 | Varchar | 80 | ||
| Address2 | Address, Line 2 | Varchar | 80 | ||
| City | City | Varchar | 80 | ||
| BeneficType | Beneficiary Type | Enum | 1 | Indicates whether the type is normal, or is a dependent. If dependent, we use the DepndID to get the dependent, and don't use the other fields in this record. | Enum |
| DepndID | Dependent Identifier | BigID | 12 | Used to get the dependent record, if needed. | |
| BenRelatn | Beneficiary Relationship | Enum | 1 | Relationship of beneficiary to the employee. | Enum |
| State | State Code | Varchar | 2 | ||
| Country | Country | Varchar | 80 | ||
| LstModBy | Last Modified By Name | Varchar | 40 | ||
| LstModDate | Last Modified Date | Date | 32 | ||
| ZipCode | Zip Code | Varchar | 10 | ||
| HpChgTS | Timestamp | 32 | |||
| LockSeqNbr | *SYSTEM* Row Sequence Nbr | Long | 12 |