LIAISON Structure
From CrossRoad
Revision as of 15:13, 31 October 2008 by WikiSysop (talk | contribs) (New page: Return to Export Merge Data. <table border><Caption>LIAISON</caption> <tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Descr...)
Return to Export Merge Data.
| FieldName | Data Type | Length | Decimals | Picture | Caption | Description | HelpContext | Name |
|---|---|---|---|---|---|---|---|---|
| ENTCODE | N | 5 | 0 | 99999 | File # | Application File Number | ENTCODE | |
| FILSTAT | C | 2 | 0 | File Status | Application file status for this individual | FILSTAT | ||
| SIN | C | 9 | 0 | @R 999-999-999 | Social Insurance Number | Social Insurance Number | SIN | |
| 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 |
| 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 | 8 | 0 | Program | Program in which this individual is interested | PRGINT | ||
| SOURCE | C | 8 | 0 | @! | Source | Source of this prospective student information | Liaison_SOURCE | SOURCE |
| OPNHSE | C | 1 | 0 | Opnhse | Liaison_OPNHSE | OPNHSE | ||
| GRADYR | C | 4 | 0 | Graduation Year | Year of Graduation from High School | GRADYR | ||
| LASINST | C | 32 | 0 | Lasinst | Liaison_LASINST | LASINST | ||
| CALEND | C | 1 | 0 | Calend | Liaison_CALEND | CALEND | ||
| COVER | C | 1 | 0 | Cover | Liaison_COVER | COVER | ||
| LASACT | D | 8 | 0 | Lasact | Liaison_LASACT | LASACT | ||
| IPRIOR | C | 2 | 0 | Iprior | Liaison_IPRIOR | IPRIOR | ||
| PRIORITY | C | 2 | 0 | Priority | Liaison_PRIORITY | PRIORITY | ||
| CONTBY | C | 3 | 0 | @! | Contby | Staff member in contact with this individual | Liaison_CONTBY | CONTBY |
| HISTORY | C | 240 | 0 | History | Liaison_HISTORY | HISTORY | ||
| ENTDATE | D | 8 | 0 | Entdate | Liaison_ENTDATE | ENTDATE | ||
| OTHERINT | C | 16 | 0 | Otherint | Liaison_OTHERINT | OTHERINT | ||
| ERROR | C | 10 | 0 | Error | Liaison_ERROR | ERROR | ||
| MAILINGS | C | 60 | 0 | Mailings | Liaison_MAILINGS | MAILINGS | ||
| STUDID | N | 6 | 0 | 999999 | Student ID | Student Identification Number | STUDID | |
| HASAPPLIED | L | 1 | 0 | Hasapplied | Liaison_HASAPPLIED | HASAPPLIED | ||
| HCHCITY | C | 20 | 0 | @! XXXXXXXXXXXXXXXXXXXX | City | City or Town | CHURLCCITY | |
| NEXTACT | D | 8 | 0 | Nextact | Liaison_NEXTACT | NEXTACT | ||
| PROSPID | N | 7 | 0 | 9999999 | Prospect # | Prospective Student File Identifier | PROSPID | |
| IDCENT | N | 2 | 0 | 99 | ID Century | Century of Student Identification Number | IDCENT | |
| BAND | C | 5 | 0 | BAND | BAND | |||
| EXTN | C | 5 | 0 | Extension | Liaison_extn | EXTN | ||
| REGNYR | C | 7 | 0 | @K 9999/99 | Year | Academic Year | YEAR | |
| ENTSEM | C | 1 | 0 | 9 | Session | Academic Term | TERM | |
| PRGINT2 | C | 8 | 0 | Program of Interest | Liaison_prgint2 | PRGINT2 | ||
| OTHERINTCD | C | 10 | 0 | Other Interests | Liaison_otherintcd | OTHERINTCD | ||
| CELLPHONE | C | 10 | 0 | @R (999)999-9999 | Cellphone | Cell phone number | Liaison_cellphone | CELLPHONE |
| PARNAME | C | 30 | 0 | Name | Liaison_parname | PARNAME | ||
| PARADDR | C | 60 | 0 | Address | Liaison_paraddr | PARADDR | ||
| PARPHONE | C | 10 | 0 | @R (999)999-9999 | Phone Number | Phone Number | phone | PHONEEMG |
| PARCELL | C | 10 | 0 | @R (999)999-9999 | Cell | Liaison_parcell | PARCELL | |
| PAREMAIL | C | 40 | 0 | Email Address: | Email Address: | PAREMAIL |
