The following standard word abbreviations should be used in naming records, fields, and SQRs:

有些词可能共用一些缩写。带星号的缩写或词来源于PeopleSoft标准。

缩 写 全 称 中文
addr Address 地址
adm Administrator 管理员
app Application 应用程序
arg Argument 主题,幅交
asm assemble 集合
asyn asynchronization 异步
avg average 平均
DB Database 数据库
bk back 后面
bmp Bitmap 位图
btn Button 按钮
buf Buffer 缓冲区
calc Calculate 计算
char Character 字符
chg Change 改变
clk Click 点击
clr color 颜色
cmd Command 命令
cmp Compare 比较
col Column 专栏,柱
coord coordinates 坐标
cpy copy 抄写
ctl / ctrl Control 控制
cur Current 电流,最新
cyl Cylinder 圆柱
dbg Debug 调试
dbl Double 双倍
dec Decrease 减少
def default 默认
del Delete 删除
dest / dst Destination 目的地
dev Device 装置,设备
dict dictionary 词典
diff different 不同
dir directory 目录
disp Display 显示器
div Divide 分成
缩 写 全 称
dlg Dialog 对话框
doc Document 文件
drv Driver 驾驶
dyna Dynamic 动态
env Environment 环境
err error 错误
ex/ext Extend 延伸,增加
exec execute 执行
flg flag 目标
frm Frame 框架
func / fn Function 功能
grp group
horz Horizontal 水平的
idx / ndx Index 指数
img Image 图像
impl Implement 实施
inc Increase 增加
info Information 信息
init Initial/Initialize/Initialization 初始化
ins Insert 嵌入,插入
inst Instance 实例
INT / intr Interrupt 中断
len Length 长度
lib Library
lnk Link 链接
log logical 逻辑
lst List 列表
max maximum 最大值
mem Memory 记忆
mgr / man Manage / Manager 管理
mid middle 中央
min minimum 最低
msg Message 消息
mul Multiply
num Number 数目
obj Object 目标
ofs Offset 偏移
org Origin / Original 原始,最初
param Parameter 参数
pic picture 图片
pkg package 包装
pnt / pt Point
pos Position 位置
pre / prev previous 以前的
缩 写 全 称
prg program 程序
prn Print 打印
proc Process / Procedure 处理
prop Properties 特性
psw Password 口令
ptr Pointer 点子,提升
pub Public 公共
rc rect 矩形
ref Reference 参考
reg Register 注册
req request 请求
res Resource 资源
ret return 回归
rgn region 地区,层
scr screen 屏幕
sec Second 第二
seg Segment 环节,部分
sel Select 选择
src Source 源代码
std Standard 标准
stg Storage 存储
stm Stream
str String 字符串
sub Subtract 减去
sum summation
svr Server 服务器
sync Synchronization 同步
sys System 系统
tbl Table 表格
temp / tmp Temporary 短暂的
tran / trans translate/transation/transparent 转换
tst Test 测试
txt text 文本
unk Unknown 未知
upd Update 更新
upg Upgrade 升级
util Utility 功用
var Variable 变量
ver Version 版本
vert Vertical 垂直,纵向
vir Virus 病毒
wnd Window

 

Word(s) Abbreviation Description
Abbreviate ABRV
Abbreviation
Academic ACAD
Accept ACPT
Acceptance
Accepted
Access ACCS
Accident ACDNT
Accomplish ACMP
Accomplishment
Accomplishments
Account* ACCT*
Accounting* ACCTG*
Accounts Payable AP
Advanced Placement
Accounts Receivable AR
Accredited ACRD
Accrual ACRL
Accumulated* ACCUM*
Accumulation ACUM
Accumulative
Achieve ACHV
Achievement
Acquisition* ACQ*
Act ACT
Active
Activity
American College Test
Action* ACTN*
Actual ACTL
Add ADD
Added
Additional* ADDL*
Address* ADDR* Narrative data which describes a person, place or thing’s location
Ad hoc ADHC
Adjudicate ADJD
Adjudicated
Adjudication
Adjusted Gross Income AGI
Adjustment* ADJ*
Administered ADM
Administrated
Administration
Admissible ADMS
Admission
Admittance ADMT
Admitted
Advanced Placement AP
Accounts Payable
Advice ADVC
Affiliation AFFL
After AFT
Age AGE
Agency AGCY
Agent AGNT
Aid AID
Alien ALN
All ALL
Allocate ALLOC*
Allocation*
Alpha ALPH
Alter ALT
Alternate
Alumni ALMN
Alumnus
AM AM “Ante Meridiem” (morning)
American College Test ACT
Act
Active
Activity
Amount* AMT* Monetary value(s)
Analysis ANLS
Annual* ANNL*
Anonymous ANON
Answer ANS
Apartment APT
Appeal APEL
Appealed
Applicant* APP*
Application* APPL*
Appointment APPT
Approval APRV
Approve
Area AREA
Array ARAY
Arrears ARRS
Ascending ASC
Assign ASGN
Assigned
Assignment
Association ASSC
Assumption ASMP
Athlete ATHL
Athletic
Attach ATCH
Attempt ATMPT
Attend ATND
Attendance
Attention ATTN
Attribute ATTR
Audit ADT
Audited
Authority AUTH
Authorize
Auxiliary AUX
Availability AVL
Available
Average AVG The mean of two or more numbers
Average Cumulative Grade ACG
Award AWRD
Awarded
Balance* BAL* The net value (balance) of an account
Bank BNK
Bargain BARG
Base BAS
Basic
Batch BTCH
Before BEF
Begin BEGN
Beginning
Beginning of Term BOT
Benefits BEN
Bid BID
Bill BILL
Billing
Billing and Receivables System BRS
Birth BRTH
Board BRD
Break BRK
Budget BUD
Budgetable
Budget Balance Account BBA
Build BLD
Building
Business BUS
Business Unit* BU*
Buy BUY
Buyer
Calculate CALC*
Calculated
Calculation*
Calendar* CAL*
Call CALL
Campaign CMPN
Campus CMPS
Cancel CAN
Canceled
Capacity CAP
Capitalization CPLZ
Card CRD
Career CAR
Carrier CRIR
Cartridge CART
Case CSE
Cash CSH
Catalog CTLG
Category* CATG*
Census CENS
Center CTR
Certificate CERT
Certification
Change CHG
Changed
Chapter CHAP
Charge CRG
Chartfield CHARTF
Check CHK
Checked
Citizen CTZN
Citizenship
City CTY
Class CLAS
Clear CLR
Cleared
CLEP CLEP
Close CLO
Club CLB
COBRA* CBR*
Code* CD* Data which represents encoded values (translate or code table)
Collect CLCT
Collection
College COLG
Column CLMN
Combination COMB
Combine
Command CMD
Comment CMT An explanatory, illustrative or critical note, remark or observation
Committee CMMTTEE
Company* CO*
Comparative* COMPA*
Competitor CPTR
Complete CMPL
Completion
Compliance
Component CMPT When the meaning is “part”, use abbreviation “PRT”.
Composite COMP
Compensation
Conditional COND
Confidential CNFD
Confirm CONF*
Confirmation*
Constant CNST Data which is unchanging or invariable
CST
Contact CTCT
Continue CONT
Continuing
Continuous
Contract CNTR
Contractor
Control* CNTL*
Conversation* CONVR*
Conversion* CNV*
Convert*
Converted
Correspondence CRSP
Cost COST
Count CNT A number of people or things that have been “counted”, such as inventory cycle count
Counter
Country CTRY
County CNTY
Course* CRSE*
Coverage* COVRG*
Create CRE
Credential CRDL
Credit* CR* Use “CR” for field names relating to financial data
CRDT Use “CRDT” for field names relating to academic work
CREF CREF
Cross CRS
Cross List XLST
Cross Listed
Cross Reference XREF
Cumulative CUM
Currency* CURR*
Current* CUR*
Cursor CRSR
Custodian CSTN
Customer* CUST*
Daily DLY
Data DATA
Data Processing DP
Date* DT* A calendar day, month, and year (including century)
Date-Time Stamp DTTM
Day* DD* A day of the week (Sunday, Monday, etc.)
DY*
Dead DEAD
Death
Deceased
Debit* DR*
Decimal DEC
Deduct DED*
Deduction*
Default* DFLT*
Deficit DFCT
Definition* DEFN*
Degree DEG
Delete DEL
Deliver DLVR
Delivery
Demo DMO
Dental DNTL
Department* DEPT*
Department of Motor Vehicles DMV
Dependency DEP*
Dependent*
Depends
Deposit DPST
Depreciation* DEPR*
Description* DESCR* Narrative data which translates a code or number. When a suffix, use “_DSC” (see Standard Field Name Suffix table).
DSC
Design DSGN
Destination* DEST*
Detail* DETL*
Develop DEV
Development
Deviation
Difference DIFF
Differential
Digit DGT
Direct DIR
Direction
Directional
Disability DISA
Disabled
Disbursed DSB
Disbursement
Discount* DISC*
Displacement DSPL
Display DISP
Disposition DSP
Distribute DIST*
Distribution*
District DSTR
Division DIV
Division of Continuing Education DCE
Document DOC
Donor DONR
Down DN
Drive DRV
Driver
Drop DRP
Due DUE
Duplicate* DUP*
Duplication
Each EA
Early ERLY
Earn EARN*
Earned
Earnings*
Earned Income Credit EIC
Educate EDU
Education
Effect EFF*
Effective*
Effective Date* EFFDT*
Effective Date Sequence* EFFSEQ*
Effort EFRT
Elect ELCT
Elected
Elective
Electronic Data Interchange EDI
Electronic Funds Transfer EFT
Electronic Mail EM
Eligibility* ELIG*
Eligible
Emergency EMRG
Emphasis EMPH
Employee* EE*
EMPL
Employee ID* EMPLID*
Employer* ER*
Employment EMPLMT
Encumber ENCB
Encumbrance
End END
Ending
End of Term EOT
Endorse ENDR
Endorsement
Endorsement ENDR
Endow ENDW
Endowment
Engineer ENGN
Engineering
English ENGL
Enrichment ENRCH
Enrollment ENRL
Enter ENTR
Entered
Entry
Entitle ENTL
Entitlement
Equal EQ
Equality
Equivalence
Equivalent
Equal Employment Opportunity EEO
Equal Opportunity
Equip EQP
Error ERR
Establishment ESTB
Ethnic ETHN
Evaluation EVAL
Evaluator
Event EVNT
Exam EXM
Exception EXCP
Exclude EXCL
Exclusion
Execute EXEC
Execution
Exempt EXMT
Exemption
Expect EXPC
Expected
Expected Family Contribution EFC
Expedite XPDT
Expense EXP
Export
Express
Experimental EXPM
Expiration EXPR
Expire
Export EXP
Expense
Extend EXT
Extended
Extension
External EXTR
Facility FCLT
Faculty FAC
Family FMLY
Family Eduaction Rights and Privacy Act FERPA
Fast FST
Father FATH
Federal FED
Federal Labor and Security Act FLSA
Fee FEE
Feet FT
Full Time
FICA FICA
Field FLD
Fields
File FILE
Final FNL
Financial* FIN*
Financial Aid FA
Fine FINE
First FRST
Fiscal FISC
Fiscal Year FY
Fiscal Year to Date FYTD
Fix FIX
Fixed
Flag FLG Data which functions as a flag or indicator. Used with only two possible states/conditions. Data should normally be “Y” or “N”.
SW
Flexible Spending Account FSA
Floor FLR
For FOR
Foreign FGN
Foreign Key FK
Form FRM
Format FMT
Former FORMR
Free FREE
Free Application for Federal Student Aid FAFSA
Free on Board FOB
Freeze FRZ
Frozen
Frequency* FREQ*
Fresh FRSH
Freshman
From FR
Fulfill FULF
Fulfilled
Full Time FT
Full Time Equivalent FTE
Function FCN
Functional
Fund FUND
Funding
Future FUT
Garnishment* GARN*
General GENL
General Education Degree GED
General Ledger GL
Geographic GEOG
Geography
Gift GFT
Global GLBL
Government GOVT
Grade GDE A value assigned to reflect performance or position on a scale
GRD
Grade Point Average GPA
Graduate GRAD
Grant GRNT
Granted
Gross GROS
Group GRP
Guarantee GUAR
Guaranteed Student Loan GSL
Guest GST
Handicap HAND
Handicapped
Head HEAD
Header* HDR*
Health HLTH
Held HLD
Hold
Help HLP
Hierarchy HIER
High H Normally used in conjunction with another word (i.e., High School abbreviated as “HS”).
High School HS
High School Services HSS
Higher Education HED
Highway HWAY
Hire HIRE
History HST
Home HM
Honor HONR
Honor Society HSC
Hospital HOSP
Hour HH A duration of time expressed in hours
Hourly HRLY
Hours* HRS*
House HSE
Housing
How HOW
Human Resources HR
Human Resource System HRS
Identification ID* Alphanumeric data which identifies a person, place, or thing
Identifier*
Indicator
Image IMG
Immune IMUN
Immunization
Impact IMPC
Implementation IMPL
Import IMP
Import/Export IMPEXP
Inch IN
Include INCL
Income INCM
Increase INCR
Increment
Index INDX
Indicator ID
IND
Individual INDV
Individual Student Information Report ISIR
Information INFO
Initial INIT
Initialize
Injury* INJ*
Inoculation INOC
Input INPT
Inquiry INQ
Insert ISRT
Institution INST
Instruction ISTR
Instructional
Instructor
Instructional Need Analysis System INAS
Insurance INS
Inter-Unit* IU*
Interest INT
Interface* INTFC*
Internal INTR
International INTL
Interval INVL
Interview INTV
Interviewer
Invent INVN
Inventory INV
Investment* INVEST*
Invitation INVT
Invite
Invoice INVC
Issue ISS
Issued
Item ITM
Job JOB
Journal* JRNL*
Junior JR
Junior Science JS
Key KEY
Label LBL
Labor LBR
Laboratory LAB
Language LNG
Last LST
List
Late LATE
Latitude LAT
Layoff LAYF
Leave LV
Lecture LCTR
Ledger* LED*
Legal LGL
Lender LNDR
Length* LEN*
Letter LTR
Level LVL
Liaison LISN
Liberal Education LBD
Library LIB
License LIC
License Plate Number LIC_PLTE_NBR
Life LIFE
Limit* LIM*
Line* LN*
Loan
Link LNK
Linked
Liquid LIQ
List LST
Last
Literal LTRL
Load LOAD
Loan LN
Line*
Locate LOC*
Location*
Lock LK
Locker LKR
Log LOG
Log on LOGON
Long LONG
Longest
Long Term Care LTC
Long Term Disability LTD
Longitude LON
Lot LOT
Low LOW
Mail MAIL
Mailer
Mailing
Maintenance* MAINT*
Major MJR
Make MK
Manager MGR
Map MAP
Marital MRTL
Message Agent Server MAS
Mask MSK
Master Academic Records System MARS
Match MTCH
Matching
Math MTH
Matriculated MTRC
Matriculation
Maximum* MAX*
Medical MED
Medicinal
Meet MT
Meeting
Member MBR
Membership MSHP
Memo MMO
Memorandum
Memorial MEMR
Merchandise MERCHNDS
Merchant MERCH
Merit MERT
Message MSG*
Messages*
Meter MTR
Method METH
Microfilm MFILM
Middle MID
Military MIL
Minimum* MIN*
Minor MINR
Minute MNT A duration of time expressed in minutes
MM
Miscellaneous MISC
Mode MDE
Modification MOD
Modifier
Monetary MONY
Money
Month* MM* A calendar month in numeric form (e.g., 01=January)
MN*
Month-to-Date* MTD*
More MORE
Mother MOTH
Move MOVE
Multiple MULT
Name NM Word(s) by which a person, place or thing is commonly known
NME
National NATL
National Association of College and University Business Officers NACUBO
National Student Loan Direct System NSLDS Commonly known as the “Perkins Loan”
Navigation NAV
New NEW
Next NXT
Next of Kin NOK
No Charge NC
No Credit NOCR
No Print NPRT
Nominal NOM
Non NON
Non-Personal Services NPS
Not NOT
Not Applicable NA
Note NOTE
Notice
Notification
Notify
Number* NBR* Numeric data which identifies a person, place, or thing
Numeric
Object OBJ
Objective
Occupation OCP
Occurs OCC
Offer OFFR
Offered
Office OFFC
Officer OFCR
Official OFCL
Old OLD
Online ONLN
Open OPN
Operator* OPR*
Option OPT
Optional
Options
Order ORDR
Organization ORG
Organize
Orientation ORNT
Origin ORIG
Original
Origination
Other OTHR
Out OUT
Over OVR
Overhead OH
Override OVRD
Overtime OT
Own OWN
Owned
Owner OWNR
Packaged PACK
Paid PAID
Paper PPR
Parameter* PARM*
Parent PAR
Parity PRTY
Priority
Park PRK
Part PRT
Partial
Part Time PT
Participation PRTP
Pass PASS
Passed
Past PAST
Patron PTRN
Pay PAY
Payable
Payment
Payroll PYRL
Pedestrian PED
Pell (Pell Grant) PEL
Pending PEND
Pension PENS
Percent* PCT* Part of a whole expressed in hundredths
Percentage
Percentile
Period* PD*
Period-to-Date* PTD*
Perkins Loan NSLDS Common name for National Student Loan Direct System
Permanent PERM
Permit PRMT
Person PERS
Personal PSNL
Personnel
Personal Identification PIN
Personnel Action Notification PAN
Phone PHN
Physics PHYS
Place PLCE
Plan PLN
Plate PLTE
Pledge PLDG
PM PM “Post Meridiem” (afternoon)
Point PNT
Policy PLCY
Position* POSN*
Post POST
Posted
Postal PSTL
Potential POTN
Predicted PRED
Preference PREF
Preferred
Prefix PRFX
Premium PREM
Prerequisite PREQ
Prescribed PSCR
Presentation PRST
President PRES
Previous PREV
Prior
Price PRC
Price Level PL
Primary PRIM
Primary Key PK
Principal PRIN
Principle
Principal Investigator PI
Print PRN
Printed
Prior PREV
Previous
Priority PRTY
Parity
Probation PROB
Problem
Procedure PROC
Process
Profession PRFS
Professional
Proficiency PRFC
Profile* PROF*
Program PROG
Project PROJ
Projected
Promissory PRMS
Promotion PROM
Proposal PRPS
Prospect PRSP
Province PRVN
Purchase PUR
Purchase Order PO
Purge PRG
Purpose PURP
Qualitative QAL
Quality
Quantitative QTY* A number of things other than money
Quantity*
Quantity-to-Date QTD*
Quarter-to-Date*
Quarter QTR
Question QSTN
Race RACE
Range RNG
Rank RNK Relative standing or position
Rate* RT* Numeric value expressing amount per some unit of coverage
Read READ
Reading
Real REAL
Reallocation
Reason* RSN*
Recall RCL
Receipt RCPT
Receive RECV*
Received*
Receiver RCVR
Recharge RCHG
Recognition RECG
Recognize
Recommend RCMD
Reconciliation* RECON*
Record* REC*
Recreate RECR
Recreation
Recruit RCRT
Recruiting
Reduce RED*
Reduced
Reduction*
Refer REF*
Reference*
Referral
Referred
Refund RFND
Regional RGNL
Registrar REGR
Registration REG
Reject RJCT
Rejection
Relate RLAT
Relation
Relationship
Release RLSE
Religion RELG
Religious
Remaining RMNG
Reminder RMDR
Renewal RNWL
Repeat REPT
Repeatable
Repeated
Replace REPL
Replaced
Reply RPLY
Report* RPT*
Request* REQ*
Requested
Require
Required*
Requisition*
Requirements* RQMT*
Research RES
Reserve RSRV
Reserved
Reserve Officers Training Corps ROTC
Residence RSDT
Residency
Resident
Resign RSGN
Resource RSRC
Response RESP
Restart RST
Restock RSTK
Restrict RSTR
Restricted
Restrictions
Result RSLT
Retire* RET*
Retirement*
Retroactive RETR
Return RTN
Revenue REV
Review RVW
Revision REVS
Revoke REVK
Roll RL
Roll up RLUP
Room RM
Route ROUT
Row ROW
RSVP RSVP French abbreviation meaning “please reply”
Run RUN
Run Control RUNCTL
Salary* SAL*
Sale SALE
Salutation SLTN
Same SM
Save SAVE
Scale SCAL
Schedule* SCHED*
Scheduled
Scheduling
Scholar SCHLR
Scholarship
Scholastic SCHL
School
Scholastic Aptitude Test SAT
Science SCI
Score SCR A number that expresses merit or performance
Screen SCRN
Search SRCH
Second SCND Use “SCND” for field names relating to number two in a countable series
SS Use “SS” for field names relating to a duration of time expressed in seconds
Section SCTN
Secure SEC*
Security*
Segment SEG
Select* SEL*
Selection
Selective
Semester SEM
Semi Finalist SEMF
Senate SEN
Senator
Send SND
Senior SR
Sent SNT
Separate SEPR
Sequence* SEQ*
Serial SERL
Service SERV
Session* SESSN*
Sex SEX
Sharing SHR
Sheet SHET
Shelter SHLT
Shift SHFT
Shipping SHIP
Short SHRT
Sign SGN
Simulated SIM
Site SITE
Size SZ
Skill SKL
Skip SKP
Social SOC
Society
Social Security Number SSN
Soft SFT
Solid SLID
Sophomore SOPH
Sort SRT
Source SRC
Special SPCL
Specialty
Specific SPEC
Specification
Sponsor SPON
Sponsored
Sports SPRT
Spouse SPSE
Square SQ
Stack STCK
Staff STF
Stage STG
Stamp STMP
Standard STD
Standard Deviation STDV
Start STRT
Starting
State ST
Statement STMT
Static STC
Statistics* STAT*
Status STS
Step STP
Stipend STPD
Stock STK
Stop STOP
Street STR
String STRG
Structure STRC
Student STU
Student Academic Records SAR
Student Credit Hour SCH
Study STDY
Subcampaign SCMP
Subject SUBJ
Subordinate SUB
Subsidiary SUBS
Suffix SFX
Summation SUM*
Summary*
Supervisor* SUP*
Support
Supplement SUPL*
Supplemental*
Survey SRVY
Suspense SUSP
SUSPN
Switch FLG Data which functions as a flag or indicator. Used with only two possible states/conditions. Data should normally be “Y” or “N”.
SW
System SYS
Table TBL
Tables
Taken TKN
Tape TAPE
Target TRGT
Taught TGHT
Tax TX
Taxable
Tax ID Number TIN
Team TEAM
Temperature TEMP
Template* TMPL*
Temporary TMP
Tenure TENR
Term TRM
Terminal TRML
Terminate TRMT
Test TST
Text TXT Narrative informational data such as a message or error text
Thermidor THERM 13th Month
TIAA TIAA
Ticket TKT
Time TM Hours and minutes. May include seconds, hundredths of seconds.
Time keeping TMKP
Time-stamp TS A system generated Time-stamp
Title TITL
Today TDY
Total* TOT*
Tour TOUR
Town CTY
Track TRK
Tracking
Traditional TRAD
Training* TRN*
Transact TRANS*
Transaction*
Transcript TSCP
Transfer* XFER*
Translate XLT Meaning “Crosswalk Table”
Translation
Transmit XMIT
Transmittal
Travel TRVL
Tuition* TUIT*
Type TYP
Undergraduate UGRD
Unemployment UNEMPL
Unit UNIT
Unit of Measure* UOM*
Universal UNVRSL
University UNIV
Unpaid UNPD
Unsecure UNSEC
Unsecured
Up To MAX
Update UPDT
Updated
Upper UPR
US Department of Education USDE
Use USE
Used
User USR
Vacation* VACN*
Valedictorian VLDC
Valid VLD
Validate
Validation
Value VAL
Variable VAR
Vehicle* VEH*
Vendor VEND
Verbal VRBL
Verify VERF
Verified
Veteran VET
Vice President VP
Violation VIO
Visa VISA
Visit VST
Voucher VCHR
W2 W2
W4 W4
W9 W9
Waived WVED
Week WK
Work
Worked
Worker(s)
Width WID
With W Normally used as part of a compound word (i.e., Withdrawl abbreviated as “WDRL”).
Withdrawal WDRL
Withhold WHLD
Withholding
Women WMN
Worksheet WKST
Write WRT
Written
Year* YR* A calendar year, including century (e.g., 1997)
YY*
Year-to-Date* YTD*
Zip ZIP
Zone ZN

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

Menu