FILENAME: D0000F01 MASTER
DESCRIPTION: FRSV3.0 UNIVERSITY SEVEN DIGIT DEPARTMENT TABLE
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
UNIVDEPT FRSDEPT
A7
7 DIGIT UNIVERSITY DEPT NUMBER
I
DEPT FDEPT
A5
5 DIGIT UNIVERSITY DEPT NUMBER
I
SUBDEPT FSUBDEPT
A2
SUBDEPARTMENT CODE
UNIV_ALPHA U_ALPHA
A22
UNIV_DESC UNV_DESC
A60
DEPARTMENT DESCRIPTION
EXLEVEL EX_LEVEL
A2
EXECUTIVE LEVEL
UNIT MAJUNIT
A2
MAJOR UNIT
CAMPUS FCAMPUS
A2
CAMPUS
UNIV_HEAD UNV_HEAD
A15
UNIV_HEADACT UNV_ACTYN
A1
UNIV_UBOX UNV_UBOX
A4
UBOX
UNIV_AREACDE UAC
A3
AREA CODE
UNIV_PHONE UNV_PHONE
A7
PHONE
INSTR_FORM IFORM
I1
STAFF_DIR SDT_NAME
A35
STAFF DIRECTOR
ACTIVITY OLD_ACTIV
A5
I
UNIV_STARTDT U_SDTEF01
YYMD
UNIVERSITY START DATE
STATUS DATE INACT_DATE
YYMD
STATUS ACTIVEYN
A1
CHGUSER_F01 CUSER_F01
A8
CHGDATE_F01 CDATE_F01
YYMD
UNIV_MAILADDR1 UADDR1
A24
STREET ADDRESS
UNIV_MAILTOWN UTOWN
A24
TOWN
UNIV_MAILST USTATE
A2
STATE
UNIV_MAILZIP
UZIPCODE
A9
9 DIGIT ZIP CODE
UNIV_MAILBLDG
UBLDG
A15
UNIVERSITY BUILDING
UNIV_MAILROOM
UROOM
A5
ROOM NUMBER

UNIV_FAX1

UFAX1

A10

FAX NUMBER - PRIMARY

UNIV_FAX2

UFAX2

A10

FAX NUMBER - SECONDARY

UNIV_EMPNUM
UNV_EMPNUM A10 UNIVERSITY EMPLOYEE #
ACTNAME
DESC A35 ACCOUNT DESCRIPTION
PRT_UNIVPHONE
PRT_UNIVPHONE A13 UNIVERSITY PHONE #
SPACE_FUNC
PCSCD A2
I
SPACE_IPEDS
HACT A4
I
SR_DEPTNO
SRNO I3
ENDDATE
ENDDATEF01 YYMD
ENDTIME
ENDTIMEF01 A8
HISTCOMMENT
HISTCOMF01 A25
HUNIT
HMAJUNIT A2
HCAMPUS
HUCAMPUS A2
HEXLEVEL
HEX_LEVEL A2
HINSTFORM
HIFORM I1
HUNIVDESC
HUNIV_DESC A60
HUNIVHEAD
HUNIV_HEAD A15
HUNIVHEADACT
HUNIV_HEADAC A1
HIST_USTART
HSTARTDATEF1 YYMD
HACTIVEYN
A1

Return to Focus Main Menu

Return to FRS Main Menu

508 UsableNet Approved (v. 1.2.1)

Last edited 4/19/02 CBM