COURSES Structure - Revision history

WikiSysop: New page:
2009-09-16T04:16:25Z

New page: <table border><Caption>COURSES</caption> <tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Description</th><th>HelpContext</th><th...

New page
<table border><Caption>COURSES</caption>
<tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Description</th><th>HelpContext</th><th>Name</th></tr><tr><td><b><i>CRSCODE</i></b></td><td>C</td><td>8</td><td>0</td><td>@!@R XXXX-999X</td><td>Course Code</td><td>Course code associated with this course</td><td></td><td>CRSCODE</td></tr>
<tr><td><b><i>SUBCODE</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Subcode</td><td></td><td>courses_SUBCODE</td><td>SUBCODE</td></tr>
<tr><td><b><i>CRSDESC</i></b></td><td>C</td><td>30</td><td>0</td><td>!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</td><td>Title</td><td>Course title or desciption</td><td></td><td>CRSDESC</td></tr>
<tr><td><b><i>ACTIVE</i></b></td><td>C</td><td>4</td><td>0</td><td></td><td>Active Terms</td><td></td><td>crsACTIVE</td><td>ACTIVE</td></tr>
<tr><td><b><i>INSTR1</i></b></td><td>C</td><td>12</td><td>0</td><td></td><td>Advisor</td><td>Academic Advisor assigned to this individual</td><td></td><td>ADVISOR</td></tr>
<tr><td><b><i>INSTR2</i></b></td><td>C</td><td>12</td><td>0</td><td></td><td>Advisor</td><td>Academic Advisor assigned to this individual</td><td></td><td>ADVISOR</td></tr>
<tr><td><b><i>GRDTYP</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Credit Type</td><td>Type of credit for this course</td><td></td><td>GRDTYP</td></tr>
<tr><td><b><i>MAXENRL</i></b></td><td>N</td><td>3</td><td>0</td><td></td><td>Maximum</td><td>Maximum enrolment in this class</td><td>MAXENROL</td><td>MAXENROL</td></tr>
<tr><td><b><i>PREREQ</i></b></td><td>C</td><td>65</td><td>0</td><td></td><td>Prerequisite</td><td>Prerequisite courses for this course</td><td></td><td>PREREQ</td></tr>
<tr><td><b><i>COREQ</i></b></td><td>C</td><td>60</td><td>0</td><td></td><td>Co-requisite</td><td>Co-requisite requirements for this course</td><td></td><td>COREQ</td></tr>
<tr><td><b><i>TERMS</i></b></td><td>C</td><td>1</td><td>0</td><td></td><td>Duration Terms</td><td></td><td>crsTERMS</td><td>TERMS</td></tr>
<tr><td><b><i>PRIVATEINST</i></b></td><td>C</td><td>1</td><td>0</td><td></td><td>PRIVATE</td><td> </td><td></td><td>PRIVATE</td></tr>
<tr><td><b><i>CREDITS</i></b></td><td>N</td><td>5</td><td>2</td><td></td><td>Credits</td><td>Amount of credit associated with this course</td><td></td><td>CREDITS</td></tr>
<tr><td><b><i>SPECCODE</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Cycle</td><td>Annual cycling of this course</td><td></td><td>SPECCODE</td></tr>
<tr><td><b><i>REPFLAG</i></b></td><td>L</td><td>1</td><td>0</td><td></td><td>RepFlag</td><td>Reporting Flag</td><td>RepFlag</td><td>REPFLAG</td></tr>
<tr><td><b><i>AVAIL</i></b></td><td>L</td><td>1</td><td>0</td><td></td><td>Available</td><td>This course is currently available</td><td>AVAIL</td><td>AVAIL</td></tr>
<tr><td><b><i>CRSNUMBER</i></b></td><td>N</td><td>4</td><td>0</td><td></td><td>Number</td><td>Number associated with this course</td><td></td><td>CRSNUMBER</td></tr>
<tr><td><b><i>CRSTRUCT</i></b></td><td>C</td><td>9</td><td>0</td><td></td><td>STRUCTURE</td><td> </td><td></td><td>STRUCTURE</td></tr>
<tr><td><b><i>REPEATABLE</i></b></td><td>L</td><td>1</td><td>0</td><td></td><td>Repeatable</td><td>Is this course repeatable without replacing previous instances?</td><td>REPEATABLE</td><td>REPEATABLE</td></tr>
<tr><td><b><i>REGNUMBER</i></b></td><td>C</td><td>9</td><td>0</td><td></td><td>Regnumber</td><td>Registration Number</td><td>regnumber</td><td>REGNUMBER</td></tr>
<tr><td><b><i>TARGETSYS</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Mark System</td><td>Mark system used with this mark</td><td></td><td>TARGETSYS</td></tr>
</table>

COURSES
FieldName Data Type Length Decimals Picture Caption Description HelpContext