Database Design Abbreviations
The following is a list of abbreviations that have been used when naming database objects (for example, tables, views, sequences, ...) at UW-Extension. This list is not all inclusive. When more than one abbreviation has been specified for a word, the preferred abbreviation is bold. If there are additional abbreviations you would like included in the list, please email them to the Oracle DBA.
| Full Word | Abbreviation |
|---|---|
| abbreviation | ABBR |
| accumulated, accumulation | ACCUM |
| address | ADDR |
| affiliate | AFFL |
| allocated, allocation | ALLOC |
| application | APPL |
| archive | ARC |
| association | ASSN |
| association | ASSOC |
| attribute | ATTR |
| attribute | ATTRIB |
| building | BLDG |
| calculated, calculation | CALC |
| category | CAT |
| change | CHG |
| code | CD |
| connection | CONN |
| county | CTY |
| current | CUR |
| database | DB |
| database | DBASE |
| date | DT |
| date of birth | DOB |
| definition | DEFN |
| definition | DFN |
| delete | DEL |
| delete | DLT |
| department | DEPT |
| depreciation | DEPR |
| description | DESCR |
| district | DIST |
| division | DIV |
| EM | |
| EML | |
| employee | EMP |
| encumberance | ENCUMB |
| end of year | EOY |
| error | ERR |
| evaluation | EVAL |
| execute, executable | EXE |
| executive | EXEC |
| expiration | EXP |
| extension | EXT |
| faculty | FAC |
| fax | FX |
| federal | FED |
| field | FLD |
| first name | FNAM |
| first name | FNAME |
| fiscal year | FY |
| flag | FL |
| foreign key | FK |
| group | GRP |
| header | HDR |
| identifier | ID |
| information | INFO |
| insert | INS |
| introduction | INTRO |
| item | ITM |
| last name | LNAM |
| last name | LNAME |
| length | LEN |
| location | LOC |
| management | MGMT |
| member | MBR |
| message | MSG |
| method | MTH |
| middle initial | MI |
| middle name | MNAM |
| middle name | MNAME |
| month | MO |
| name | NM |
| number | NUM |
| object | OBJ |
| office | OFF |
| oracle | ORA |
| organization | ORG |
| original | ORIG |
| outcome | OTC |
| password | PSWD |
| password | PWORD |
| payment | PYMNT |
| person | PERS |
| person | PRSN |
| phone | PH |
| phone | PHN |
| post office box | POBOX |
| preference | PREF |
| prefix | PRFX |
| previous | PREV |
| primary | PRMY |
| primary key | PK |
| prior year | PY |
| priority | PRI |
| privilege | PRIV |
| program | PGM |
| program | PROG |
| program area | PA |
| purchase | PURCH |
| quarter | QTR |
| query | QRY |
| recordset | RS |
| reference | REF |
| registry, registration | REG |
| remark | REM |
| return | RET |
| revenue | REV |
| room | RM |
| secretary | SEC |
| segment | SEG |
| sequence | SEQ |
| shipment | SHIP |
| situation | SIT |
| social security number | SSN |
| source | SRC |
| specialty | SPEC |
| state | ST |
| statement | STMT |
| street | STR |
| suffix | SFFX |
| system | SYS |
| team | TM |
| text | TXT |
| title | TTL |
| transaction | TRANS |
| trigger | TR |
| trigger | TRG |
| unique key | UK |
| unit/division/department/subdepartment | UDDS |
| update | UPD |
| update | UPDT |
| user name | UNAM |
| user name | UNAME |
| utility | UTIL |
| vacant | VCNT |
| view | VW |
| volunteer | VOL |
| world wide web | WWW |
| year | YR |
| year to date | YTD |
| zip plus four | ZIP4 |
| zipcode | ZIP |