a code look up table which also shows gear group designations
| name | value |
|---|---|
| name | [dbo].[GEAR_CODES] |
| ansi nulls | on |
| quoted identifier | on |
| row count | 70 |
| Size of data | 8 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 112 bytes |
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|---|---|---|---|---|---|---|---|---|---|
| calcom_code | varchar | 50 | 50 | no | yes | no | code used in CALCOM | |||
| cdfg_code | int | 10 | 4 | no | no | CDFG code equivelent (numeric) | ||||
| pacfin_code | varchar | 4 | 4 | yes | no | PacFIN code equivelent (often the same as CALCOM_Code) | ||||
| description | varchar | 50 | 50 | yes | no | |||||
| gear_grp | varchar | 3 | 3 | yes | no | gear group to which this gear code belongs | ||||
| active_cdfg | char | 1 | 1 | yes | no |
| name | object type | level |
|---|