FILENAME: D0000F02 MASTER
DESCRIPTION: UNIVERSITY 5 DIGIT DEPARTMENT TABLE
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
DEPT LFDEPT A5
I
DEPTDESC D_DESC A25
DEPTFULL D_FULL A50
DEPTACRO D_ACRO A6
DEPTHEAD D_HEAD A15
DEPTHEADACT D_ACTYN A1
DEPTUBOX D_UBOX A4
DEPT_AREACODE DAREA A3
DEPTPHONE D_PHONE A7
DEPT_STARTDT SDTEF02 YYMD
DPT_STATDATE DPT_INACTDTE YYMD
DPT_STATUS DPT_ACTIVEYN A1
CHGUSER CHGUSERF02 A08
CHGDATE CHGDATEF02 YYMD
DEPT_MAILADDR1 DADDR1 A24
DEPT_MAILTOWN DTOWN A24
DEPT_MAILST DSTATE A2
DEPT_MAILZIP DZIPCODE A9
DEPT_MAILBLDG DBLDG A15
DEPT_MAILROOM DROOM A5
DEPT_FAX1 DFAX1 A10
DEPT_FAX2 DFAX2 A10
DEPT_EMPNUM DEMPNUM A10
ENDDATE ENDDATEF02 YYMD
ENDTIME ENDTIMEF02 A8
HISTCOMMENT HISTCOMF02 A25
HDEPTFULL HLDEPT_FULL A50
HDEPTHEAD HLDEPT_HEAD A15
HDEPTHEADACT HLDEPT_HEADA A1
HSTARTDATE HSTARTDATEF2 YYMD
HDPTACTIVEYN A1

508 UsableNet Approved (v. 1.2.1)