Difference between revisions of "MASTER Structure"
From CrossRoad
(New page: <table border> <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>...) |
m (Protected "MASTER Structure" [edit=autoconfirmed:move=autoconfirmed]) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <table border> | + | Return to [[Export Merge Data]] or [[Data Structures]]. |
| − | <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>ENTCODE</i></b></ | + | |
| − | <tr><td><b><i>STUDID</i></b></ | + | <table border><Caption>MASTER</caption> |
| − | <tr><td><b><i>SIN</i></b></ | + | <tr> |
| − | <tr><td><b><i>FILSTAT</i></b></ | + | <th>FieldName</th> |
| − | <tr><td><b><i>ADMSTAT</i></b></ | + | <th>Data Type</th> |
| − | <tr><td><b><i>STDSTAT</i></b></ | + | <th>Length</th> |
| − | <tr><td><b><i>ACDSTAT</i></b></ | + | <th>Decimals</th> |
| − | <tr><td><b><i>YRSTDY</i></b></ | + | <th>Picture</th> |
| − | <tr><td><b><i>ADVISOR</i></b></ | + | <th>Caption</th> |
| − | <tr><td><b><i>SURNAME</i></b></ | + | <th>Description</th> |
| − | <tr><td><b><i>FNAME</i></b></ | + | <th>HelpContext</th> |
| − | <tr><td><b><i>INITIAL</i></b></ | + | <th>Name</th> |
| − | <tr><td><b><i>PREFNAME</i></b></ | + | </tr> |
| − | <tr><td><b><i>SALUT</i></b></ | + | <tr> |
| − | <tr><td><b><i>SEX</i></b></ | + | <td><b><i>ENTCODE</i></b></td> |
| − | <tr><td><b><i>MARITAL</i></b></ | + | <td>N</td> |
| − | <tr><td><b><i>ADDR1</i></b></ | + | <td>5</td> |
| − | <tr><td><b><i>CITY</i></b></ | + | <td>0</td> |
| − | <tr><td><b><i>PROV</i></b></ | + | <td>99999</td> |
| − | <tr><td><b><i>HCNTY</i></b></ | + | <td>File #</td> |
| − | <tr><td><b><i>BIRTHDAY</i></b></ | + | <td>Application File Number</td> |
| − | <tr><td><b><i>COUNTRY</i></b></ | + | <td></td> |
| − | <tr><td><b><i>PCODE</i></b></ | + | <td>ENTCODE</td> |
| − | <tr><td><b><i>PHONE</i></b></ | + | </tr> |
| − | <tr><td><b><i>OLDNAME</i></b></ | + | <tr> |
| − | <tr><td><b><i>SCHOOL</i></b></ | + | <td><b><i>STUDID</i></b></td> |
| − | <tr><td><b><i>SCHCITY</i></b></ | + | <td>N</td> |
| − | <tr><td><b><i>HCHURCH</i></b></ | + | <td>6</td> |
| − | <tr><td><b><i>DENOM</i></b></ | + | <td>0</td> |
| − | <tr><td><b><i>PRGINT</i></b></ | + | <td>999999</td> |
| − | <tr><td><b><i>RACORG</i></b></ | + | <td>Student ID</td> |
| − | <tr><td><b><i>MOTHLANG</i></b></ | + | <td>Student Identification Number</td> |
| − | <tr><td><b><i>PREVCTRY</i></b></ | + | <td></td> |
| − | <tr><td><b><i>ENTCDA</i></b></ | + | <td>STUDID</td> |
| − | <tr><td><b><i>CITSTAT</i></b></ | + | </tr> |
| − | <tr><td><b><i>CITCTRY</i></b></ | + | <tr> |
| − | <tr><td><b><i>CURADDR</i></b></ | + | <td><b><i>SIN</i></b></td> |
| − | <tr><td><b><i>OLDSTDSTAT</i></b></ | + | <td>C</td> |
| − | <tr><td><b><i>ARCHFLAG</i></b></ | + | <td>9</td> |
| − | <tr><td><b><i>GRADYR</i></b></ | + | <td>0</td> |
| − | <tr><td><b><i>GRADUATED</i></b></ | + | <td>@R 999-999-999</td> |
| − | <tr><td><b><i>GRADNOTE</i></b></ | + | <td>Social Insurance Number</td> |
| − | <tr><td><b><i>PREVGRAD</i></b></ | + | <td>Social Insurance Number</td> |
| − | <tr><td><b><i>HCHCITY</i></b></ | + | <td></td> |
| − | <tr><td><b><i>IDCENT</i></b></ | + | <td>SIN</td> |
| − | <tr><td><b><i>EXTN</i></b></ | + | </tr> |
| − | <tr><td><b><i>AUTHEXPY</i></b></ | + | <tr> |
| − | <tr><td><b><i>NOCONTACT</i></b></ | + | <td><b><i>FILSTAT</i></b></td> |
| + | <td>C</td> | ||
| + | <td>2</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>File Status</td> | ||
| + | <td>Application file status for this individual</td> | ||
| + | <td></td> | ||
| + | <td>FILSTAT</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>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>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>YRSTDY</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>1</td> | ||
| + | <td>0</td> | ||
| + | <td>9</td> | ||
| + | <td>Year of Study</td> | ||
| + | <td>Year of study in this program</td> | ||
| + | <td></td> | ||
| + | <td>YRSTDY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>ADVISOR</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>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>PREFNAME</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>15</td> | ||
| + | <td>0</td> | ||
| + | <td>@! XXXXXXXXXXXXXXX</td> | ||
| + | <td>Preferred</td> | ||
| + | <td>Preferred name for this individual</td> | ||
| + | <td></td> | ||
| + | <td>PREFNAME</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>SALUT</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>4</td> | ||
| + | <td>0</td> | ||
| + | <td>@! XXXX</td> | ||
| + | <td>Title</td> | ||
| + | <td>Salutation or title of this individual</td> | ||
| + | <td></td> | ||
| + | <td>SALUT</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>SEX</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>1</td> | ||
| + | <td>0</td> | ||
| + | <td>!</td> | ||
| + | <td>Gender</td> | ||
| + | <td>Gender of this individual</td> | ||
| + | <td></td> | ||
| + | <td>SEX</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>MARITAL</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>1</td> | ||
| + | <td>0</td> | ||
| + | <td>!</td> | ||
| + | <td>Marital Status</td> | ||
| + | <td>Marital status of this individual</td> | ||
| + | <td></td> | ||
| + | <td>MARITAL</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>ADDR1</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>60</td> | ||
| + | <td>0</td> | ||
| + | <td>@! </td> | ||
| + | <td>Address</td> | ||
| + | <td>Address</td> | ||
| + | <td></td> | ||
| + | <td>ADDREMG</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>CITY</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>20</td> | ||
| + | <td>0</td> | ||
| + | <td>@! XXXXXXXXXXXXXXXXXXXX</td> | ||
| + | <td>City</td> | ||
| + | <td>City or Town</td> | ||
| + | <td></td> | ||
| + | <td>CHURLCCITY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>PROV</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>2</td> | ||
| + | <td>0</td> | ||
| + | <td>!!</td> | ||
| + | <td>Province</td> | ||
| + | <td>Province or State</td> | ||
| + | <td></td> | ||
| + | <td>PROVLOC</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>HCNTY</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>15</td> | ||
| + | <td>0</td> | ||
| + | <td>@! XXXXXXXXXXXXXXX</td> | ||
| + | <td>County</td> | ||
| + | <td>County of residence for this individual</td> | ||
| + | <td></td> | ||
| + | <td>HCNTY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>BIRTHDAY</i></b></td> | ||
| + | <td>D</td> | ||
| + | <td>8</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Birth Date</td> | ||
| + | <td>Date of birth of this individual</td> | ||
| + | <td></td> | ||
| + | <td>BIRTHDAY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>COUNTRY</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>20</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>Country</td> | ||
| + | <td>Country</td> | ||
| + | <td></td> | ||
| + | <td>COUNTRY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>PCODE</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>9</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>PostalCode</td> | ||
| + | <td>Postal or Zip Code</td> | ||
| + | <td></td> | ||
| + | <td>PCODELOC</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>PHONE</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>10</td> | ||
| + | <td>0</td> | ||
| + | <td>@R (999)999-9999</td> | ||
| + | <td>Phone Number</td> | ||
| + | <td>Phone Number</td> | ||
| + | <td>phone</td> | ||
| + | <td>PHONEEMG</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>OLDNAME</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>20</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>Former Name</td> | ||
| + | <td>Former surname for this individual</td> | ||
| + | <td></td> | ||
| + | <td>OLDNAME</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>SCHOOL</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>30</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>School</td> | ||
| + | <td>High School of this individual</td> | ||
| + | <td></td> | ||
| + | <td>SCHOOL</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>SCHCITY</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>20</td> | ||
| + | <td>0</td> | ||
| + | <td>@! XXXXXXXXXXXXXXXXXXXX</td> | ||
| + | <td>City</td> | ||
| + | <td>City or Town</td> | ||
| + | <td></td> | ||
| + | <td>CHURLCCITY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>HCHURCH</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>30</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>Church</td> | ||
| + | <td>Church of this individual</td> | ||
| + | <td></td> | ||
| + | <td>CHURLOC</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>DENOM</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>4</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Denomination</td> | ||
| + | <td>Denomination of this individual</td> | ||
| + | <td></td> | ||
| + | <td>DENOMLOC</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>PRGINT</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>RACORG</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>6</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>Racial Origin</td> | ||
| + | <td>Racial Origin of this individual</td> | ||
| + | <td></td> | ||
| + | <td>RACORG</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>MOTHLANG</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>4</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>First Language</td> | ||
| + | <td>First language of this individual</td> | ||
| + | <td></td> | ||
| + | <td>MOTHLANG</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>PREVCTRY</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>20</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>Country</td> | ||
| + | <td>Country</td> | ||
| + | <td></td> | ||
| + | <td>COUNTRY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>ENTCDA</i></b></td> | ||
| + | <td>D</td> | ||
| + | <td>8</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Entered On</td> | ||
| + | <td>Date on which this person entered Canada</td> | ||
| + | <td></td> | ||
| + | <td>ENTCDA</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>CITSTAT</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>12</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Citizenship Status</td> | ||
| + | <td>Citizenship status for this individual</td> | ||
| + | <td></td> | ||
| + | <td>CITSTAT</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>CITCTRY</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>20</td> | ||
| + | <td>0</td> | ||
| + | <td>@!</td> | ||
| + | <td>Country</td> | ||
| + | <td>Country</td> | ||
| + | <td></td> | ||
| + | <td>COUNTRY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>CURADDR</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>1</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Current Address</td> | ||
| + | <td>Indicates which address is to be used at this time</td> | ||
| + | <td></td> | ||
| + | <td>CURADDR</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>OLDSTDSTAT</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>OLDSTDSTAT</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>ARCHFLAG</i></b></td> | ||
| + | <td>L</td> | ||
| + | <td>1</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Archive?</td> | ||
| + | <td>Is this individual marked for archiving?</td> | ||
| + | <td></td> | ||
| + | <td>ARCHFLAG</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>GRADYR</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>2</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Graduation Year</td> | ||
| + | <td>The graduation year for which this student has applied</td> | ||
| + | <td>gradyr</td> | ||
| + | <td>GRADYR</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>GRADUATED</i></b></td> | ||
| + | <td>L</td> | ||
| + | <td>1</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Graduated</td> | ||
| + | <td>Indicates whether this individual has graduated</td> | ||
| + | <td></td> | ||
| + | <td>GRADUATED</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>GRADNOTE</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>30</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Note</td> | ||
| + | <td>Note concerning this graduand</td> | ||
| + | <td></td> | ||
| + | <td>GRADNOTE</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>PREVGRAD</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>20</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Previous Grad Yr</td> | ||
| + | <td>Years of previous graduations of this student from this institution</td> | ||
| + | <td></td> | ||
| + | <td>PREVGRAD</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>HCHCITY</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>20</td> | ||
| + | <td>0</td> | ||
| + | <td>@! XXXXXXXXXXXXXXXXXXXX</td> | ||
| + | <td>City</td> | ||
| + | <td>City or Town</td> | ||
| + | <td></td> | ||
| + | <td>CHURLCCITY</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>EXTN</i></b></td> | ||
| + | <td>C</td> | ||
| + | <td>5</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Extension</td> | ||
| + | <td>Home Extension</td> | ||
| + | <td>master_extn</td> | ||
| + | <td>EXTN</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>AUTHEXPY</i></b></td> | ||
| + | <td>D</td> | ||
| + | <td>8</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>Authorization Expiry</td> | ||
| + | <td>Date on which Student Authorization Expires</td> | ||
| + | <td>master_authexpy</td> | ||
| + | <td>AUTHEXPY</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><b><i>NOCONTACT</i></b></td> | ||
| + | <td>L</td> | ||
| + | <td>1</td> | ||
| + | <td>0</td> | ||
| + | <td></td> | ||
| + | <td>NOCONTACT</td> | ||
| + | <td> </td> | ||
| + | <td></td> | ||
| + | <td>NOCONTACT</td> | ||
| + | </tr> | ||
</table> | </table> | ||
Latest revision as of 04:21, 16 November 2009
Return to Export Merge Data or Data Structures.
| FieldName | Data Type | Length | Decimals | Picture | Caption | Description | HelpContext | Name |
|---|---|---|---|---|---|---|---|---|
| ENTCODE | N | 5 | 0 | 99999 | File # | Application File Number | ENTCODE | |
| STUDID | N | 6 | 0 | 999999 | Student ID | Student Identification Number | STUDID | |
| SIN | C | 9 | 0 | @R 999-999-999 | Social Insurance Number | Social Insurance Number | SIN | |
| FILSTAT | C | 2 | 0 | File Status | Application file status for this individual | FILSTAT | ||
| ADMSTAT | C | 2 | 0 | Admission Status | Admissions status for this individual | ADMSTAT | ||
| STDSTAT | C | 2 | 0 | Student Status | Student status for this individual | STDSTAT | ||
| ACDSTAT | C | 2 | 0 | Academic Status | Academic Status for this individual | ACDSTAT | ||
| YRSTDY | C | 1 | 0 | 9 | Year of Study | Year of study in this program | YRSTDY | |
| ADVISOR | C | 12 | 0 | Advisor | Academic Advisor assigned to this individual | ADVISOR | ||
| SURNAME | C | 20 | 0 | @! XXXXXXXXXXXXXXXXXXXX | Surname | Family Name of this individual | SURNAME | |
| FNAME | C | 15 | 0 | @! XXXXXXXXXXXXXXX | First Name | First or Given name for this individual | FNAME | |
| INITIAL | C | 1 | 0 | ! | Middle Initial | Middle Initial of this individual | INITIAL | |
| PREFNAME | C | 15 | 0 | @! XXXXXXXXXXXXXXX | Preferred | Preferred name for this individual | PREFNAME | |
| SALUT | C | 4 | 0 | @! XXXX | Title | Salutation or title of this individual | SALUT | |
| SEX | C | 1 | 0 | ! | Gender | Gender of this individual | SEX | |
| MARITAL | C | 1 | 0 | ! | Marital Status | Marital status of this individual | MARITAL | |
| ADDR1 | C | 60 | 0 | @! | Address | Address | ADDREMG | |
| CITY | C | 20 | 0 | @! XXXXXXXXXXXXXXXXXXXX | City | City or Town | CHURLCCITY | |
| PROV | C | 2 | 0 | !! | Province | Province or State | PROVLOC | |
| HCNTY | C | 15 | 0 | @! XXXXXXXXXXXXXXX | County | County of residence for this individual | HCNTY | |
| BIRTHDAY | D | 8 | 0 | Birth Date | Date of birth of this individual | BIRTHDAY | ||
| COUNTRY | C | 20 | 0 | @! | Country | Country | COUNTRY | |
| PCODE | C | 9 | 0 | @! | PostalCode | Postal or Zip Code | PCODELOC | |
| PHONE | C | 10 | 0 | @R (999)999-9999 | Phone Number | Phone Number | phone | PHONEEMG |
| OLDNAME | C | 20 | 0 | @! | Former Name | Former surname for this individual | OLDNAME | |
| SCHOOL | C | 30 | 0 | @! | School | High School of this individual | SCHOOL | |
| SCHCITY | C | 20 | 0 | @! XXXXXXXXXXXXXXXXXXXX | City | City or Town | CHURLCCITY | |
| HCHURCH | C | 30 | 0 | @! | Church | Church of this individual | CHURLOC | |
| DENOM | C | 4 | 0 | Denomination | Denomination of this individual | DENOMLOC | ||
| PRGINT | C | 4 | 0 | Major/Concentration | Major or Concentration for this program | CONC | ||
| RACORG | C | 6 | 0 | @! | Racial Origin | Racial Origin of this individual | RACORG | |
| MOTHLANG | C | 4 | 0 | @! | First Language | First language of this individual | MOTHLANG | |
| PREVCTRY | C | 20 | 0 | @! | Country | Country | COUNTRY | |
| ENTCDA | D | 8 | 0 | Entered On | Date on which this person entered Canada | ENTCDA | ||
| CITSTAT | C | 12 | 0 | Citizenship Status | Citizenship status for this individual | CITSTAT | ||
| CITCTRY | C | 20 | 0 | @! | Country | Country | COUNTRY | |
| CURADDR | C | 1 | 0 | Current Address | Indicates which address is to be used at this time | CURADDR | ||
| OLDSTDSTAT | C | 2 | 0 | Student Status | Student status for this individual | OLDSTDSTAT | ||
| ARCHFLAG | L | 1 | 0 | Archive? | Is this individual marked for archiving? | ARCHFLAG | ||
| GRADYR | C | 2 | 0 | Graduation Year | The graduation year for which this student has applied | gradyr | GRADYR | |
| GRADUATED | L | 1 | 0 | Graduated | Indicates whether this individual has graduated | GRADUATED | ||
| GRADNOTE | C | 30 | 0 | Note | Note concerning this graduand | GRADNOTE | ||
| PREVGRAD | C | 20 | 0 | Previous Grad Yr | Years of previous graduations of this student from this institution | PREVGRAD | ||
| HCHCITY | C | 20 | 0 | @! XXXXXXXXXXXXXXXXXXXX | City | City or Town | CHURLCCITY | |
| IDCENT | N | 2 | 0 | 99 | ID Century | Century of Student Identification Number | IDCENT | |
| EXTN | C | 5 | 0 | Extension | Home Extension | master_extn | EXTN | |
| AUTHEXPY | D | 8 | 0 | Authorization Expiry | Date on which Student Authorization Expires | master_authexpy | AUTHEXPY | |
| NOCONTACT | L | 1 | 0 | NOCONTACT | NOCONTACT |
