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...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Return to Export Merge Data.

LIAISON
FieldNameData TypeLengthDecimalsPictureCaptionDescriptionHelpContextName
ENTCODEN5099999File #Application File NumberENTCODE
FILSTATC20File StatusApplication file status for this individualFILSTAT
SINC90@R 999-999-999Social Insurance NumberSocial Insurance NumberSIN
SURNAMEC200@! XXXXXXXXXXXXXXXXXXXXSurnameFamily Name of this individualSURNAME
FNAMEC150@! XXXXXXXXXXXXXXXFirst NameFirst or Given name for this individualFNAME
INITIALC10!Middle InitialMiddle Initial of this individualINITIAL
PREFNAMEC150@! XXXXXXXXXXXXXXXPreferredPreferred name for this individualPREFNAME
SALUTC40@! XXXXTitleSalutation or title of this individualSALUT
SEXC10!GenderGender of this individualSEX
MARITALC10!Marital StatusMarital status of this individualMARITAL
ADDR1C600@! AddressAddressADDREMG
CITYC200@! XXXXXXXXXXXXXXXXXXXXCityCity or TownCHURLCCITY
PROVC20!!ProvinceProvince or StatePROVLOC
HCNTYC150@! XXXXXXXXXXXXXXXCountyCounty of residence for this individualHCNTY
BIRTHDAYD80Birth DateDate of birth of this individualBIRTHDAY
COUNTRYC200@!CountryCountryCOUNTRY
PCODEC90@!PostalCodePostal or Zip CodePCODELOC
PHONEC100@R (999)999-9999Phone NumberPhone NumberphonePHONEEMG
SCHOOLC300@!SchoolHigh School of this individualSCHOOL
SCHCITYC200@! XXXXXXXXXXXXXXXXXXXXCityCity or TownCHURLCCITY
HCHURCHC300@!ChurchChurch of this individualCHURLOC
DENOMC40DenominationDenomination of this individualDENOMLOC
PRGINTC80ProgramProgram in which this individual is interestedPRGINT
SOURCEC80@!SourceSource of this prospective student informationLiaison_SOURCESOURCE
OPNHSEC10OpnhseLiaison_OPNHSEOPNHSE
GRADYRC40Graduation YearYear of Graduation from High SchoolGRADYR
LASINSTC320LasinstLiaison_LASINSTLASINST
CALENDC10CalendLiaison_CALENDCALEND
COVERC10CoverLiaison_COVERCOVER
LASACTD80LasactLiaison_LASACTLASACT
IPRIORC20IpriorLiaison_IPRIORIPRIOR
PRIORITYC20PriorityLiaison_PRIORITYPRIORITY
CONTBYC30@!ContbyStaff member in contact with this individualLiaison_CONTBYCONTBY
HISTORYC2400HistoryLiaison_HISTORYHISTORY
ENTDATED80EntdateLiaison_ENTDATEENTDATE
OTHERINTC160OtherintLiaison_OTHERINTOTHERINT
ERRORC100ErrorLiaison_ERRORERROR
MAILINGSC600MailingsLiaison_MAILINGSMAILINGS
STUDIDN60999999Student IDStudent Identification NumberSTUDID
HASAPPLIEDL10HasappliedLiaison_HASAPPLIEDHASAPPLIED
HCHCITYC200@! XXXXXXXXXXXXXXXXXXXXCityCity or TownCHURLCCITY
NEXTACTD80NextactLiaison_NEXTACTNEXTACT
PROSPIDN709999999Prospect #Prospective Student File IdentifierPROSPID
IDCENTN2099ID CenturyCentury of Student Identification NumberIDCENT
BANDC50BAND BAND
EXTNC50ExtensionLiaison_extnEXTN
REGNYRC70@K 9999/99YearAcademic YearYEAR
ENTSEMC109SessionAcademic TermTERM
PRGINT2C80Program of InterestLiaison_prgint2PRGINT2
OTHERINTCDC100Other InterestsLiaison_otherintcdOTHERINTCD
CELLPHONEC100@R (999)999-9999CellphoneCell phone numberLiaison_cellphoneCELLPHONE
PARNAMEC300NameLiaison_parnamePARNAME
PARADDRC600AddressLiaison_paraddrPARADDR
PARPHONEC100@R (999)999-9999Phone NumberPhone NumberphonePHONEEMG
PARCELLC100@R (999)999-9999CellLiaison_parcellPARCELL
PAREMAILC400Email Address:Email Address:EMAILPAREMAIL