STUDENTS Structure - Revision history

WikiSysop: New page:
2009-09-08T04:53:07Z

New page: <table border><Caption>STUDENTS</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><t...

New page
<table border><Caption>STUDENTS</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>STUDID</i></b></td><td>N</td><td>6</td><td>0</td><td>999999</td><td>Student ID</td><td>Student Identification Number</td><td></td><td>STUDID</td></tr>
<tr><td><b><i>SURNAME</i></b></td><td>C</td><td>20</td><td>0</td><td>@! XXXXXXXXXXXXXXXXXXXX</td><td>Surname</td><td>Family Name of this individual</td><td></td><td>SURNAME</td></tr>
<tr><td><b><i>FNAME</i></b></td><td>C</td><td>15</td><td>0</td><td>@! XXXXXXXXXXXXXXX</td><td>First Name</td><td>First or Given name for this individual</td><td></td><td>FNAME</td></tr>
<tr><td><b><i>INITIAL</i></b></td><td>C</td><td>1</td><td>0</td><td>!</td><td>Middle Initial</td><td>Middle Initial of this individual</td><td></td><td>INITIAL</td></tr>
<tr><td><b><i>YEAR</i></b></td><td>C</td><td>7</td><td>0</td><td>@K 9999/99</td><td>Year</td><td>Academic Year</td><td></td><td>YEAR</td></tr>
<tr><td><b><i>SESSION</i></b></td><td>C</td><td>1</td><td>0</td><td>9</td><td>Session</td><td>Academic Term</td><td></td><td>TERM</td></tr>
<tr><td><b><i>ACDSTAT</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Academic Status</td><td>Academic Status for this individual</td><td></td><td>ACDSTAT</td></tr>
<tr><td><b><i>STDSTAT</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Student Status</td><td>Student status for this individual</td><td></td><td>STDSTAT</td></tr>
<tr><td><b><i>COMMCODE</i></b></td><td>C</td><td>250</td><td>0</td><td></td><td>Comments</td><td>Comment codes for transcript</td><td></td><td>COMMCODE</td></tr>
<tr><td><b><i>DEGREE</i></b></td><td>C</td><td>4</td><td>0</td><td>@! XXXX</td><td>Degree</td><td>Degree program</td><td></td><td>DEGREE</td></tr>
<tr><td><b><i>MAJOR</i></b></td><td>C</td><td>4</td><td>0</td><td></td><td>Major/Concentration</td><td>Major or Concentration for this program</td><td></td><td>CONC</td></tr>
<tr><td><b><i>MINOR</i></b></td><td>C</td><td>4</td><td>0</td><td></td><td>Major/Concentration</td><td>Major or Concentration for this program</td><td></td><td>CONC</td></tr>
<tr><td><b><i>ADMSTAT</i></b></td><td>C</td><td>2</td><td>0</td><td></td><td>Admission Status</td><td>Admissions status for this individual</td><td></td><td>ADMSTAT</td></tr>
<tr><td><b><i>IDCENT</i></b></td><td>N</td><td>2</td><td>0</td><td>99</td><td>ID Century</td><td>Century of Student Identification Number</td><td></td><td>IDCENT</td></tr>
<tr><td><b><i>CONF_DATE</i></b></td><td>D</td><td>8</td><td>0</td><td></td><td>Conferred</td><td>Date on which degree was conferred</td><td>students_conf_date</td><td>CONF_DATE</td></tr>
</table>

STUDENTS
FieldName Data Type Length Decimals Picture Caption Description HelpContext