SECTION V
DATA ELEMENT
DICTIONARY
(For elements reported on campus transaction files)
List of APDB Elements Reported in Campus Transaction Files
Administrative Level
AppointmentSequence
Assigned Time Code
Assigned Time WTU
CampusCode
Course Abbreviation
Course Classification Number (CS Number)
Course Level Code
Course Number
Course Suffix
Department Code
Discipline Code
Enrollment (Section Enrollment Actual)
Facility Number
Facility Suffix
Faculty Name
Faculty Record Type/Appointment Sequence Number
Graduate Student Enrollment
Group Code Control
Instructional Administrative Fraction (IAF)
Instructional Faculty Fraction (IFF)
Learning Mode
Line Sequence Number
Non-resident Graduate Student Enrollment (new for CY 2007-2008)
Other Support Fraction (OSF)
Override WTU
Range Code (Salary)
School Code
SectionBegin Time
Section Duration Type
Section End Time
Section Meet Days
Section Number
Segment Credit Units
Service Learning Indicator
Social Security Number (Faculty)
Space Number
SpaceSuffix
SpaceType
Team Teaching Fraction (TTF)
TermCode
To Be Arranged Hours (TBA)
Total Non-resident Student Enrollment (new for CY 2007-2008)
Year
The CaliforniaStateUniversityPage 1
Office of the ChancellorSection V
Information Technology Services – Enterprise SystemsRevision No. 0
Academic Planning Data Base Reference ManualDate Issued: 04/19/10
DEDData Element Definition
ELEMENT NAMEAdministrative Level
Definition
A code that denotes the organizational level at which a person with an Instructional Administrative Fraction (IAF) is assigned. It also defines the type of work assigned and the term of appointment. Persons with an IAF of 0.0 will be coded zero (0).
Structure
One (1) alphanumeric character.
Values
0=No administrative duties (default).
1=Department level, academic year appointment, such as Department Chairs, Associate or Assistant Department Chairs, and Athletic Directors.
2=Department level, 12-month appointment, such as Department Chairs, Associate or Assistant Department Chairs, and Athletic Directors.
3=Coordinator of teacher education, all appointment terms, school or department.
4=School level, Deans and Division Chairs (all appointment terms).
5=School level, Associate and Assistant Deans.
6=Campus level, Deans (all appointment terms). This category covers the Dean and above types of an assignment, such as an Associate Vice President or Graduate Dean.
7=Campus level, other (all appointment terms). This category applies to all other campus level assignments, such as Academic Planner, Associate Dean of Graduate Studies, Coordinator of Evening Sessions, and Production Manager.
DEDData Element Edit/Validation
Data ElementAdministrative Level
File: Faculty Master File
Default Code:Value is a space.
Acceptable Codes:Must be an authorized value as noted above.
Additional Edit:None
Comment:Within a given assignment, a non-zero Instructional
Administrative Fraction must be accompanied by a non-zero
Administrative Level and vice versa.
Message:
C-093 ASSIGNMENT 1 ADMIN. LEVEL IS INVALID
C-094 ASSIGNMENT 2 ADMIN. LEVEL IS INVALID
C-095 ASSIGNMENT 3 ADMIN. LEVEL IS INVALID
File: Faculty Transaction File
Message:
C-108 ASSGINMENT 1: IAF IS ZERO, SO ADMIN LEVEL MUST BE ‘0’
C-109 ASSGINMENT 2: IAF IS ZERO, SO ADMIN LEVEL MUST BE ‘0’
C-110 ASSGINMENT 3: IAF IS ZERO, SO ADMIN LEVEL MUST BE ‘0’
DEDData Element Definition
ELEMENT NAMEAppointment Sequence
Definition
A one digit code used to identify a given faculty transaction as either a first, second or third departmental appointment (aka “assignment”). Each faculty person can have from one to three such appointments in a given term.
Structure
One (1) numeric digit.
Values
1 = first faculty departmental appointment, aka “primary department”
2 = second faculty departmental appointment
3 = third faculty departmental appointment
DEDData Element Edit/Validation
Data ElementAppointment Sequence
Default Code:None.
Acceptable Codes:1, 2 or 3
Additional Edits:None
Comments:
Message:
DEDData Element Definition
ELEMENT NAMEAssigned Time Code
Definition
A numeric code used to indicate up to three different types of activities per faculty assignment for which a faculty member can receive workload credit.
Structure
Two (2) numeric digits.
Values
COSAR Table 10 contains the current and complete listing of the valid codes.
11 = Excess Enrollments
12=New Preparations
14=Course or Supervision Overload
15=Nontraditional Instruction
16=In-Service Training for K-12 School Personnel
17=Credit by Examination/Evaluation
18=Instructional Support of Graduate Students
21=Special Instructional Programs
22=Instructional Experimentation or Innovation, or Instructionally Related Research
23=Instruction-Related Services
31=Student Advisor Responsibilities (Graduate Student Evaluation, etc.)
32=Instruction-Related Committee Assignments
33=Curricular Planning or Studies
34=Accreditation Responsibilities
35=Instruction-Related Facilities Planning
41=CFA Activities
DEDData Element Definition
ELEMENT NAMEAssigned Time Code
Values (Continued)
INSTRUCTION RELATED ASSIGNED TIME CODES
Activities for which Weighted Teaching Units may be assigned:
Code
11.Excess Enrollments
a.For classes with census date enrollment of between 75 and 120 and exceptional workload, a graduate assistant or student assistant may be allocated.
b.For classes with census date enrollment of over 120, a graduate assistant, a student assistant, or an additional 3 WTU may be assigned.
Assignment of graduate assistants is a preferable way of handling such large class loads, but it is recognized that qualified graduate assistants are not always available.
In nocase shall a faculty member be granted assigned WTU for more than one class with excess enrollments.
12.New Preparations
A faculty member may be given assigned WTU for preparation of courses never before taught by that particular faculty member, if courses actually taught include two or more such new preparations.
14.Course or Supervision Overload
A faculty member may be given assigned WTU equal to course or supervision overload earned in a prior fiscal year provided that calendar considerations so necessitate and the faculty member has not been present for the full preceding academic year.
15.Non-Traditional Instruction
A faculty member may be given assigned WTU for activities involving instruction and evaluation, which include such activities as modularized instruction, self-paced instruction, team teaching/cluster courses, thematic projects, open laboratory, sponsored experimental learning or other community activities, writing adjunct, mediated instruction (involving computers, television, and/or other media devices), and peer instruction. These activities typically do not involve a single instructor regularly meeting a group of students in an assigned classroom or laboratory setting.
DEDData Element Definition
ELEMENT NAMEAssigned Time Code
Values (Continued)
16.In-Service Training for K-12 School Personnel
A faculty member may be given assigned WTU for activities involving in-service training for K-12 school personnel. Typically, the activities are provided on the school site using a variety of instructional modes and do not necessarily involve an instructor regularly meeting a group of students in an assigned classroom or laboratory setting on a campus.
17.Credit by Examination/Evaluation
A faculty member may be given assigned WTU for activities that give primary emphasis to the evaluation of a student's knowledge and skills rather than upon the instructional process by which the knowledge and skills are acquired. Such activities include:
a.Credit by evaluation of prior experiential learning (e.g., based upon evaluation of a portfolio of materials).
b.Credit by examination (where the examination is generated and evaluated in whole or in part by the campus), including comprehensive and challenge examinations.
The characteristics of evaluation activities that should be treated as part of the regular instructional program involve 1) regularly enrolled students, and 2) a substantial effort on the part of the faculty member to perform any of the following tasks:
a.Interview and make a preliminary assessment of the student's background.
b.Counsel the student regarding preparation for the evaluation.
c. Selection or preparation of the examination or assistance in preparation of a student portfolio.
d.Evaluation of the portfolio or evaluation of the student response to the examination.
18.Instructional Support for Graduate Students
A faculty member may be given assigned WTU for special graduate student testing duties, in particular for conducting comprehensive examinations for master's degree candidates and examinations in fulfillment of foreign language requirements.
DEDData Element Definition
ELEMENT NAMEAssigned Time Code
Values (Continued)
21.Special Instructional Programs
a.A faculty member may be given assigned WTU for participation in a team teaching effort. The total assigned and earned WTU associated with a team-taught course may not exceed the WTU generated by the course multiplied by the number of faculty members teaching the course. In addition, no individual faculty member may be given more WTU, both earned and assigned, than the course generates.
b.A faculty member may be given assigned WTU for program and tape production for instructional television.
c.A faculty member may be given assigned WTU for liaison duties among multiple sections of the same course.
22.Instructional Experimentation, Innovation, or Instructionally Related Research
a.A faculty member may be given assigned time for development and implementation of experimental programs involving:
1.Instructional television
2.Computer assisted instruction
3.Other innovations in instruction
b.A faculty member may be given assigned time for documented research evaluations which are demonstrably related to the instructional functions and programs of the college.
23.Instruction-Related Services
A faculty member may be given assigned WTU for his services related to college clinics, study skill centers, farms, art galleries, and other campus institutions and facilities which are ancillary to the instruction program.
31.Advising Responsibilities
a.A faculty member may be given assigned WTU for carrying an excessive advising load due to a relatively high proportion of part-time faculty in his department.
b.A faculty member may be given assigned WTU for carrying a greater than normal share of departmental or school advising responsibilities.
c. A faculty member may be given assigned WTU for services as departmental graduate adviser.
DEDData Element Definition
ELEMENT NAMEAssigned Time Code
Values (Continued)
32.Instructon-Relatcd Committee Assignments
a.A faculty member may be given assigned WTU for participation over and above normal levels in such areas as curriculum, personnel, budget, library, audio-visual, and selection committees at the department, school or college level.
b.A faculty member may be given assigned WTU for membership in or liaison to special committees whose activities have significant bearing on the instructional programs of the college, or the CSU system at large.
c. Includes all-university assigned time.
33.Curricular Planning, or Studies
a.A faculty member may be given assigned WTU for special individual or committee-related curriculum planning, development and redevelopment activities.
b.A faculty member may be given assigned WTU for development of special tests for credit by examination,
34.Accreditation Responsibilities
A faculty member may be given assigned WTU for accreditation responsibilities.
35.Instruction-Related Facilities Planning
A faculty member may be given assigned WTU for duties related to planning of instructional facilities.
41.California Faculty Association Activities
Each CFA campus Chapter President and each of four CFA statewide officers (President, Vice President, Secretary, Treasurer) shall be granted a reduction in workload, without loss of compensation, of up to three (3) WTU on a semester campus, or four (4) WTU on a quarter campus, per academic term.
DEDData Element Edit/Validation
Data ElementAssigned Time Code
File: Faculty Master File
Default Code:00
Acceptable Codes:See list: 00 is also an acceptable value.
Additional Edit:Within a department assignment, if the Assign Time Code is zero, its corresponding WTU must also be zero. If Assign Time Code is greater than zero, its corresponding WTU must also be greater than zero.
Message:
C-033 ASSIGNMENT 1 - ASSIGN TIME CODE 1 NOT IN COSAR 10 COMMON TABLE
C-034 ASSIGNMENT 1 - ASSIGN TIME CODE 2 NOT IN COSAR 10 COMMON TABLE
C-035 ASSIGNMENT 1 - ASSIGN TIME CODE 3 NOT IN COSAR 10 COMMON TABLE
C-036 ASSIGNMENT 2 - ASSIGN TIME CODE 1 NOT IN COSAR 10 COMMON TABLE
C-037 ASSIGNMENT 2 - ASSIGN TIME CODE 2 NOT IN COSAR 10 COMMON TABLE
C-038 ASSIGNMENT 2 - ASSIGN TIME CODE 3 NOT IN COSAR 10 COMMON TABLE
C-039 ASSIGNMENT 3 - ASSIGN TIME CODE 1 NOT IN COSAR 10 COMMON TABLE
C-040 ASSIGNMENT 3 - ASSIGN TIME CODE 2 NOT IN COSAR 10 COMMON TABLE
C-041 ASSIGNMENT 3 - ASSIGN TIME CODE 3 NOT IN COSAR 10 COMMON TABLE
DEDData Element Definition
ELEMENT NAMEAssign Time WTU
Definition
The number of Weighted Teaching Units (WTU) assigned to the faculty member in conjunction with the associated 'Assigned Time Code'.
Structure
Three (3) numeric digits of which one is decimal. The decimal point is implied, not entered. Example: 12.0 is entered as 120.
Values
00.0 thru 12.0
DEDData Element Edit/Validation
Data ElementAssign Time WTU
File:Faculty Master File
Default Code:Zero
Acceptable Codes:Zero thru 12.0
Additional Edit:Within a department assignment, if the Assign Time Code is zero,
its corresponding WTU must be zero. If the Assign Time Code
is greater than zero, its corresponding WTU must also be greater
than zero.
Comment:None
Message:
W-042 ASSIGNMENT 1 - ASSIGN TIME WTU 1 INVALID - DEFAULTED TO ZERO
W-043 ASSIGNMENT 1 - ASSIGN TIME WTU 2 INVALID - DEFAULTED TO ZERO
W-044 ASSIGNMENT 1 - ASSIGN TIME WTU 3 INVALID - DEFAULTED TO ZERO
W-045 ASSIGNMENT 2 - ASSIGN TIME WTU 1 INVALID - DEFAULTED TO ZERO
W-046 ASSIGNMENT 2 - ASSIGN TIME WTU 2 INVALID - DEFAULTED TO ZERO
W-047 ASSIGNMENT 2 - ASSIGN TIME WTU 3 INVALID - DEFAULTED TO ZERO
W-048 ASSIGNMENT 3 - ASSIGN TIME WTU 1 INVALID - DEFAULTED TO ZERO
W-049 ASSIGNMENT 3 - ASSIGN TIME WTU 2 INVALID - DEFAULTED TO ZERO
W-050 ASSIGNMENT 3 - ASSIGN TIME WTU 3 INVALID - DEFAULTED TO ZERO
C-063 ASSIGN TIME WTU (1) IN ASSIGNMENT 1 NOT VALID FOR ASSOCIATED CODE
C-064 ASSIGN TME WTU (2) IN ASSIGNMENT 1 NOT VALID FOR ASSOCIATED CODE
C-065 ASSIGN TIME WTU (3) IN ASSIGNMENT 1 NOT VALID FOR ASSOCIATED CODE
C-066 ASSIGN TME WTU (1) IN ASSIGNMENT 2 NOT VALID FOR ASSOCIATED CODE
C-067 ASSIGN TIME WTU (2) IN ASSIGNMENT 2 NOT VALID FOR ASSOCIATED CODE
C-068 ASSIGN TIME WTU (3) IN ASSIGNMENT 2 NOT VALID FOR ASSOCIATED CODE
C-069 ASSIGN TME WTU (1) IN ASSIGNMENT 3 NOT VALID FOR ASSOCIATED CODE
C-070 ASSIGN TIME WTU (2) IN ASSIGNMENT 3 NOT VALID FOR ASSOCIATED CODE
C-071 ASSIGN TIME WTU (3) IN ASSIGNMENT 3 NOT VALID FOR ASSOCIATED CODE
DEDData Element Definition
ELEMENT NAME Campus Code
Definition
A code is assigned to each entity of the CaliforniaStateUniversity.
Structure
Two (2) numeric digits.
Values
Refer to COSAR Table 1 for the current and complete listing of the valid Campus Codes.
Alpha OrderCampus Code Order
Bakersfield / 35 / Chancellor's Office / 01Calexico / 66 / EastBay / 05
Chancellor's Office / 01 / MontereyBay / 06
ChannelIsland / 73 / Maritime Academy / 07
Chico / 20 / Pomona / 10
Dominguez Hills / 55 / San Luis Obispo / 15
Fresno / 25 / Chico / 20
Fullerton / 50 / Fresno / 25
EastBay / 05 / Humboldt / 30
Humboldt / 30 / Bakersfield / 35
Long Beach / 40 / Long Beach / 40
Los Angeles / 45 / Los Angeles / 45
Maritime Academy / 07 / Fullerton / 50
MontereyBay / 06 / Dominguez Hills / 55
Moss Landing / 94 / Sacramento / 60
Northridge / 70 / San Bernardino / 63
Pomona / 10 / San Diego / 65
Sacramento / 60 / Calexico / 66
San Bernardino / 63 / San Marcos / 68
San Diego / 65 / Northridge / 70
San Francisco / 75 / ChannelIsland / 73
San Jose / 80 / San Francisco / 75
San Luis Obispo / 15 / San Jose / 80
San Marcos / 68 / Sonoma / 85
Sonoma / 85 / Stanislaus / 90
Stanislaus / 90 / Moss Landing / 94
DEDData Element Edit/Validation
Data ElementCampus Code
File:Faculty Transaction File
Default Code:None
Acceptable Codes:See current list.
Additional Edit:None
Comment:In most APDB jobs, the year/term/campus code values specified by
the user must correspond to an existing section and/or faculty master
file, and must match the year/term/campus code contained in the
header record of the file.
Message:
APD66-023 Invalid year, term or campus code.
File:Faculty Master File
Message:
None
File:Section Master File
Message:
C-074 FIELD 03 CAMPUS CODE NOT SAME AS PARAMETER CARD
File:Section Transaction File
Message:
C-08 INVALID PARAMETER CARD CAMPUS CODE
DEDData Element Definition
ELEMENT NAMECourse Abbreviation
Definition
A prefix used in conjunction with the Course Number and Course Suffix to identify a course.
Structure
Five (5) alphanumeric characters.
Values
Acceptable values are defined by each campus and often vary among CSU campuses. Embedded and/or trailing blanks are allowed. Value must be left justified.
DEDData Element Edit/Validation
Data ElementCourse Abbreviation
File:Section Master File
Default Code:None
Acceptable Codes:Any non-trivial value consisting of the letters A thru Z and blanks.
Additional Edit:None
Comment:None
Message:
None
File:Faculty Master File
Message:
None
DEDData Element Definition
ELEMENT NAMECourse Classification Number (CS Number)
Definition
This data element identifies a particular mode of instruction for a resource segment activity.
Structure
Two (2) numeric digits.
Values
Value must correspond to an authorized value in the COSAR Table 12. Latter values are listed below.
ValuesCorresponding Modes
01 to 04C1 to C4 (lecture)
05 C5 (seminar)
06C6 (seminar/demonstration)
07 to 14C7 to C14 (activity)
15 to 16C15 to C16 (laboratory)
17 to 21C17 to C21 (activity)
23S5
24S4
25S3
36S2
48S1
77C77 (non state supported instructions, e. g. ROTC)
78C78 (non traditional instruction, e. g. examination
or evaluation, 78 modes are state supported)
"C" stands for "Classroom"
"S" stands for "Supervision"
Note: "00" is used to identify a resource segment that operates as an extension of its immediately preceding master segment (CS Number greater than zero). Such "00" segments are commonly referred to as dependents and serve to contain additional information about the master segment, such as a team teaching pair of instructions,
or non-continuous (split) meeting hours.
DEDData Element Edit/Validation
Data ElementCourse Classification Number (CS Number)
File:Section Master File
Default Code:None
Acceptable Codes:00 and the authorized two-digit codes found in COSAR table 12.
Additional Edit:1. The first resource segment within any section must have a valid, non-zero CS Number.
2. Sections which have multiple Master Resource Segments (CS Number greater than zero), must have these segments
in ascending order by CS Number. One or more dependent