Difference between revisions of "MASTER Structure"
From CrossRoad
m (Protected "MASTER Structure" [edit=autoconfirmed:move=autoconfirmed]) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | Return to [[Export Merge Data]] or [[Data Structures]]. | ||
| + | |||
<table border><Caption>MASTER</caption> | <table border><Caption>MASTER</caption> | ||
<tr> | <tr> | ||
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 |
