Masterfile Details


How do I get rid of the demo MF files so I can "load" my own classes, Instructors, classrooms?
I could then use the drop down lists and locate details for my Campus!

VCS has four text masterfiles. instructor.txt, room.txt, subject.txt and class.txt

Your text masterfiles need to be loaded to the C:\VSS directory, overwiting the demo files.
Use your favourite spreadsheet system like MS-Excel to format the data.
Be sure to Save(A)s Type: Text (Tab-delimited) (*.txt)

VCS uses the first 6 columns for data and will display free format details in other columns in the zoom window at the bottom of the screen.

The column order for the first six columns of the

Class Masterfile: Class.txt

Column Name Description Usage
1 Course Name & Group e.g.
12652 IT Dip
Max 15 chars
Appears at left on Class screen and reports
On screen and reports
2 Class capacity (optional)
e.g. 30
Number of Students expected for this class Screen Zoom Window for comparison to room size
3 Group type /
Statistics Type
0 = State Funded
1 = Commercial
2 = Another fund
3 = Non class
Statistics screen (F4)
4 Course Total $Fees (optional) e.g. $14,000 per course (whole class) Costed summary reports and statistics
5 Course $Fee/hour (optional) e.g. $100/hour (whole class) Costed summary reports and statistics
6 Faculty or
Sub Faculty
Often used to designate area where the timetable controller is.
So when timetables are merged into a whole Campus it is easy to view the events managed by any timetable controller.
1. Display screen top right.
2. Color faculty,
3. Write back faculty
7-12 Other details Free format - multi column
Descriptions, contact names and telephones, equipment details etc
Screen Zoom Window during mouse-over name window.

The column order for the first six columns of the

Subject master file: Subject.txt

Column Name Description Usage
1 Subject No &Name e.g.
3456A BAKING
Max 15 chars
Appears at left on Subject screen and reports
On screen and reports
2 Sunbject capacity (optional)
e.g. 30
Number of Students expected for this subject Screen Zoom Window for comparison to class / room size
3 Group type /
Statistics Type
0 = My Faculty
1 = Another Faculty
2 = Another faculty
3 = Non class
Statistics screen (F4)
4 Subject Total $Costs (optional) e.g. $4,000 per subject for meat (whole class) Costed summary reports and statistics
5 Subject $Fee/hour (optional) e.g. $100/hour (whole class) Costed summary reports and statistics
6 Faculty or
Sub Faculty
Often used to designate area where the timetable controller is.
So when timetables are merged into a whole Campus it is easy to view the events managed by any timetable controller.
1. Display screen top right.
2. Color faculty,
3. Write back faculty
7-12 Other details Free format - multi column
Descriptions, contact names and telephones, equipment details etc
Screen Zoom Window during mouse-over name window.

The column order for the first six columns of the

Classroom master file: Room.txt

Column Name Description Usage
1 Room No & Description e.g.
A1.12 Lecture

Appears at left on Room screen and reports
On screen and reports
2 Room capacity (optional)
e.g. 30
Number of seats 1. Occupancy in statistics, 2. Screen Zoom Window for comparison to class / subject size
3 Group type /
Statistics Type
0 = Rooms managed by me
1 = Other Classrooms
2 = Another room group
3 = Non class e.g. office
Statistics screen (F4)
4 Room Annual $Costs (optional) e.g. $800 per Lecture Room for cleaning, A/C, Security, or $20,000 for computer depreciation. Costed summary reports and statistics
5 Room $Fee/hour (optional) e.g. $50/hour Costed summary reports and statistics
6 Faculty or
Sub Faculty
Often used to designate area where the timetable controller is.
So when timetables are merged into a whole Campus it is easy to view the events managed by any timetable controller.
1. Display screen top right.
2. Color faculty,
3. Write back faculty
7-12 Other details Free format - multi column
Descriptions, contact names and telephones, equipment details etc
Screen Zoom Window during mouse-over name window.

The column order for the first six columns of the

Instructor / Teacher master file: Instructor.txt

Column Name Description Usage
1 Instructor Name e.g.
Robert James
James, Robert

Appears at left on Instructor screen and reports
On screen and reports
2 Instructor load
e.g. 1 or 0.5
Permanent staff on full or part duties 1. Screen Window over / under allocation
2. Statistics
3. Reports
3 Group type /
Statistics Type
0 = Permanent Teaching staff
1 = Part time staff
2 = Casual staff
3 = Non teaching staff e.g. maintenance
1. Main screen under / over allocations
2. Statistics screen (F4)
3. Report calculations
NB Type 1, Part timers will not have over/under allocations shown.
4 Staff $Salary (optional) e.g. $44,000 per annum Costed summary reports and statistics
5 Contract $Cost /hour (optional) e.g. $80/hour Costed summary reports and statistics
6 Faculty or
Sub Faculty
Used to designate area where the teaching staff belong.
1. Color faculty
2. Report description
7-12 Other details Free format - multi column
Teaching capability, preferences, telephone, room no etc
Screen Zoom Window during mouse-over instructor name window.

*There is a VCS configuration file which can be used to access masterfiles across Campus LANS instead of on the local PC. Please e-mail for details.

Please send your questions or comments and details to VCS Customer Service

Visual Scheduling Systems,
51 Carinya Road, Picnic Point,
Sydney NSW 2213, Australia
ABN 54 002 021 1212

TEL + 414 792 703

+ is your international dialling code eg 001

in Australia, call 0414 792 703