FILENAME: D0000F03 MASTER
DESCRIPTION: UNIVERSITY DEPARTMENT UNIT TABLE
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
UNIT LMAJUNIT A2
I
UNITABR UNT_ABR A12
UNITDESC UNT_DESC A20
UNITFULL UNT_FULL A50
UNITCAMPUS CAMPUS A2
UNITHEAD UNT_HEAD A15
UNITACTHEAD UNT_HEADAC A1
UNITUBOX UNT_UBOX A4
UNITAREA UNT_AREA A3
UNITPHONE UNT_PHONE A7
UNIT_STARTDT SDTEF03 YYMD
UNT_INACTDTE YYMD
UNT_ACTIVEYN A1
CHGUSER CHGUSERF03 A08
CHGDATE CHGDATEF03 YYMD
UNIT_MAILADDR1 UNTADDR1 A24
UNIT_MAILTOWN UNTTOWN A24
UNIT_MAILST UNTSTATE A2
UNIT_MAILZIP INTZIPCODE A9
UNIT_MAILBLDG UNTBLDG A15
UNIT_MAILROOM UNTROOM A5
UNIT_FAX1 UNTFAX1 A10
UNIT_FAX2 UNTFAX2 A10
UNIT_EMPNUM UNTEMPNO A10
ENDDATE ENDDATEF03 YYMD
ENDTIME ENDTIMEF03 A8
HIST_COMMENT HISTCOMF03 A25
HSTARTDATE STARTDATEF3 YYMD
HUNITFULL HLUNIT_FULL A50
HUNITCAMPUS HUNT_CAMP A2
HUNIT_HEAD HLUNIT_HEAD A15
HUNITHEADACT HLUNIT_HEADA A1
HUNT_ACTIVE A1

 

508 UsableNet Approved (v. 1.2.1)