| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | empID | Employee No. | int | 11 | 0 | OHEM | | | Allow NULL? |
| 2 | Object | The Object Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | Peer | Peer Authorization | char | 1 | 0 | | N | F=Full, N=None, R=Read Only, U=Undefined Type | Allow NULL? |
| 4 | Manager | Manager Authorization | char | 1 | 0 | | N | , F=Full, N=None, R=Read Only, U=Undefined Type | Allow NULL? |
| 5 | Subord | Subordinate Authorization | char | 1 | 0 | | N | , F=Full, N=None, R=Read Only, U=Undefined Type | Allow NULL? |
| 6 | Dept | Department Authorization | char | 1 | 0 | | N | , F=Full, N=None, R=Read Only, U=Undefined Type | Allow NULL? |
| 7 | Branch | Branch Authorization | char | 1 | 0 | | N | , F=Full, N=None, R=Read Only, U=Undefined Type | Allow NULL? |
| 8 | Team | Team Authorization | char | 1 | 0 | | N | , F=Full, N=None, R=Read Only, U=Undefined Type | Allow NULL? |
| 9 | AC | Cache Access Counter | int | 11 | 0 | | 0 | | Allow NULL? |
| 10 | Cmpny | Company Authorization | char | 1 | 0 | | N | F=Full, N=None, R=Read Only, U=Undefined Type | Allow NULL? |