MASTER Structure

From CrossRoad
Revision as of 14:57, 31 October 2008 by WikiSysop (talk | contribs) (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>...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
<td>5</td><td>0</td><td>99999</td><td>File #</td><td>Application File Number</td><td></td><td>ENTCODE</td>

<tr><td>STUDID</th><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>SIN</th><td>C</td><td>9</td><td>0</td><td>@R 999-999-999</td><td>Social Insurance Number</td><td>Social Insurance Number</td><td></td><td>SIN</td></tr> <tr><td>FILSTAT</th><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>ADMSTAT</th><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>STDSTAT</th><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>ACDSTAT</th><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>YRSTDY</th><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>ADVISOR</th><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>SURNAME</th><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>FNAME</th><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>INITIAL</th><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>PREFNAME</th><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>SALUT</th><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>SEX</th><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>MARITAL</th><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>ADDR1</th><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>CITY</th><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>PROV</th><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>HCNTY</th><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>BIRTHDAY</th><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>COUNTRY</th><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>PCODE</th><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>PHONE</th><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>OLDNAME</th><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>SCHOOL</th><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>SCHCITY</th><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>HCHURCH</th><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>DENOM</th><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>PRGINT</th><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>RACORG</th><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>MOTHLANG</th><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>PREVCTRY</th><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>ENTCDA</th><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>CITSTAT</th><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>CITCTRY</th><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>CURADDR</th><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>OLDSTDSTAT</th><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>ARCHFLAG</th><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>GRADYR</th><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>GRADUATED</th><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>GRADNOTE</th><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>PREVGRAD</th><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>HCHCITY</th><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>IDCENT</th><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>EXTN</th><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>AUTHEXPY</th><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>NOCONTACT</th><td>L</td><td>1</td><td>0</td><td></td><td>NOCONTACT</td><td> </td><td></td><td>NOCONTACT</td></tr> </table>

FieldNameData TypeLengthDecimalsPictureCaptionDescriptionHelpContextName
ENTCODE</th><td>N