Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Human Resources | ||||||||||
1 | AHEM | Employees | 30 | salaryUnit | Salary Unit | VarChar | 1 | 0 | M | B=Biweekly, D=Day, H=Hour, M=Month, S=Semimonthly, W=Week, Y=Year |
2 | OHEM | Employees | 30 | salaryUnit | Salary Unit | VarChar | 1 | 0 | M | B=Bi-Weekly, D=Day, H=Hour, M=Month, S=Semi-Monthly, W=Week, Y=Year |