FAPPLICS Structure
From CrossRoad
Revision as of 04:44, 8 September 2009 by WikiSysop (talk | contribs) (New page: <table border><Caption>FAPPLICS</caption> <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><t...)
| FieldName | Data Type | Length | Decimals | Picture | Caption | Description | HelpContext | Name |
|---|---|---|---|---|---|---|---|---|
| APPL_ID | C | 15 | 0 | Appl Id | FAPPLICS_APPL_ID | APPL_ID | ||
| NEWRET | L | 1 | 0 | New/Returning | FAPPLICS_NEWRET | NEWRET | ||
| SURNAME | C | 35 | 0 | Surname | FAPPLICS_SURNAME | SURNAME | ||
| FNAME | C | 35 | 0 | Firstname | FAPPLICS_FNAME | FNAME | ||
| GPA | C | 10 | 0 | Most recent GPA or Average | FAPPLICS_GPA | GPA | ||
| VOCAT | C | 40 | 0 | Vocational Choice | FAPPLICS_VOCAT | VOCAT | ||
| STUDID | C | 6 | 0 | Student ID | FAPPLICS_STUDID | STUDID | ||
| PHONE | C | 20 | 0 | Phone | FAPPLICS_PHONE | PHONE | ||
| SIN | C | 9 | 0 | Social Insurance Number | FAPPLICS_SIN | SIN | ||
| NONEED | L | 1 | 0 | Not applying for need based awards | FAPPLICS_NONEED | NONEED | ||
| MARITAL | C | 15 | 0 | MARITAL | MARITAL | |||
| EVERM | L | 1 | 0 | Have you ever been married | FAPPLICS_EVERM | EVERM | ||
| SPCUST | L | 1 | 0 | Single Parent has custody | FAPPLICS_SPCUST | SPCUST | ||
| SPDEP11 | C | 3 | 0 | Dependents 11 yrs or less | FAPPLICS_SPDEP11 | SPDEP11 | ||
| SPDEP12 | C | 3 | 0 | Dependents 12 years or more | FAPPLICS_SPDEP12 | SPDEP12 | ||
| BED | L | 1 | 0 | B Ed Applicant/Student | FAPPLICS_BED | BED | ||
| LV12 | C | 4 | 0 | Year left Grade 12 | FAPPLICS_LV12 | LV12 | ||
| STPS | C | 4 | 0 | Year starting Post-secondary | FAPPLICS_STPS | STPS | ||
| FOURYR | L | 1 | 0 | More than 4 years between HS and PS | FAPPLICS_FOURYR | FOURYR | ||
| EVEREMP | L | 1 | 0 | Have you ever been employed | FAPPLICS_EVEREMP | EVEREMP | ||
| EMPYR | C | 3 | 0 | Empyr | FAPPLICS_EMPYR | EMPYR | ||
| EMP2 | L | 1 | 0 | Emp2 | FAPPLICS_EMP2 | EMP2 | ||
| FAMSIZ | C | 3 | 0 | Famsiz | FAPPLICS_FAMSIZ | FAMSIZ | ||
| FAMSCH | C | 3 | 0 | Famsch | FAPPLICS_FAMSCH | FAMSCH | ||
| FAMPSI | C | 3 | 0 | Fampsi | FAPPLICS_FAMPSI | FAMPSI | ||
| PARNET | C | 10 | 0 | Parnet | FAPPLICS_PARNET | PARNET | ||
| PARENTPROV | C | 5 | 0 | Parentprov | FAPPLICS_PARENTPROV | PARENTPROV | ||
| SUMREZ | L | 1 | 0 | Sumrez | FAPPLICS_SUMREZ | SUMREZ | ||
| ACDREZ | L | 1 | 0 | Acdrez | FAPPLICS_ACDREZ | ACDREZ | ||
| SUMMER | C | 10 | 0 | Summer | FAPPLICS_SUMMER | SUMMER | ||
| NOWORK | C | 60 | 0 | Nowork | FAPPLICS_NOWORK | NOWORK | ||
| SAVING | C | 10 | 0 | Saving | FAPPLICS_SAVING | SAVING | ||
| SPOUSEINC | C | 10 | 0 | Spouseinc | FAPPLICS_SPOUSEINC | SPOUSEINC | ||
| OTHREV1NM | C | 60 | 0 | Othrev1nm | FAPPLICS_OTHREV1NM | OTHREV1NM | ||
| OTHREV1 | C | 10 | 0 | Othrev1 | FAPPLICS_OTHREV1 | OTHREV1 | ||
| OTHREV2NM | C | 60 | 0 | Othrev2nm | FAPPLICS_OTHREV2NM | OTHREV2NM | ||
| OTHREV2 | C | 10 | 0 | Othrev2 | FAPPLICS_OTHREV2 | OTHREV2 | ||
| OTHREV3NM | C | 60 | 0 | Othrev3nm | FAPPLICS_OTHREV3NM | OTHREV3NM | ||
| OTHREV3 | C | 10 | 0 | Othrev3 | FAPPLICS_OTHREV3 | OTHREV3 | ||
| DECLARATIO | L | 1 | 0 | Declaratio | FAPPLICS_DECLARATIO | DECLARATIO | ||
| PRINTED | L | 1 | 0 | Printed | FAPPLICS_PRINTED | PRINTED | ||
| ENTCODE | N | 5 | 0 | Entcode | FAPPLICS_ENTCODE | ENTCODE | ||
| PREFNAME | C | 35 | 0 | Prefname | FAPPLICS_PREFNAME | PREFNAME | ||
| OLDNAME | C | 35 | 0 | Oldname | FAPPLICS_OLDNAME | OLDNAME | ||
| C | 100 | 0 | FAPPLICS_EMAIL | |||||
| KUCPROG | C | 15 | 0 | KUCPROG | KUCPROG | |||
| PARDIV | L | 1 | 0 | Pardiv | FAPPLICS_pardiv | PARDIV | ||
| PARREZ | C | 1 | 0 | Parrez | FAPPLICS_parrez | PARREZ | ||
| PARSTEP | L | 1 | 0 | Parstep | FAPPLICS_parstep | PARSTEP | ||
| PARMOM | C | 10 | 0 | Parmom | FAPPLICS_parmom | PARMOM | ||
| INVTYPE1 | C | 20 | 0 | Invtype1 | FAPPLICS_invtype1 | INVTYPE1 | ||
| INVTYPE2 | C | 20 | 0 | Invtype2 | FAPPLICS_invtype2 | INVTYPE2 | ||
| INVTYPE3 | C | 20 | 0 | Invtype3 | FAPPLICS_invtype3 | INVTYPE3 | ||
| INVAMT1 | C | 10 | 0 | Invamt1 | FAPPLICS_invamt1 | INVAMT1 | ||
| INVAMT2 | C | 10 | 0 | Invamt2 | FAPPLICS_invamt2 | INVAMT2 | ||
| INVAMT3 | C | 10 | 0 | Invamt3 | FAPPLICS_invamt3 | INVAMT3 | ||
| INVRSP1 | L | 1 | 0 | Invrsp1 | FAPPLICS_invrsp1 | INVRSP1 | ||
| INVRSP2 | L | 1 | 0 | Invrsp2 | FAPPLICS_invrsp2 | INVRSP2 | ||
| INVRSP3 | L | 1 | 0 | Invrsp3 | FAPPLICS_invrsp3 | INVRSP3 | ||
| LOANHAVE | L | 1 | 0 | Loanhave | FAPPLICS_loanhave | LOANHAVE | ||
| LOANWILL | L | 1 | 0 | Loanwill | FAPPLICS_loanwill | LOANWILL | ||
| LOANWHY | C | 30 | 0 | Loanwhy | FAPPLICS_loanwhy | LOANWHY | ||
| LOANAMT | C | 10 | 0 | Loanamt | FAPPLICS_loanamt | LOANAMT | ||
| LINEAMT | C | 10 | 0 | Lineamt | FAPPLICS_lineamt | LINEAMT | ||
| LINEWHY | C | 30 | 0 | Linewhy | FAPPLICS_linewhy | LINEWHY | ||
| LINEWILL | L | 1 | 0 | Linewill | FAPPLICS_linewill | LINEWILL | ||
| LINEHAVE | L | 1 | 0 | Linehave | FAPPLICS_linehave | LINEHAVE | ||
| WILLM | L | 1 | 0 | Willm | FAPPLICS_willm | WILLM | ||
| ERRENT | C | 10 | 0 | Errent | FAPPLICS_errent | ERRENT | ||
| EREARN | C | 10 | 0 | Erearn | FAPPLICS_erearn | EREARN | ||
| ERFOOD | C | 10 | 0 | Erfood | FAPPLICS_erfood | ERFOOD | ||
| ERSPOU | C | 10 | 0 | Erspou | FAPPLICS_erspou | ERSPOU | ||
| ERUTIL | C | 10 | 0 | Erutil | FAPPLICS_erutil | ERUTIL | ||
| ERPARE | C | 10 | 0 | Erpare | FAPPLICS_erpare | ERPARE | ||
| ERCHIL | C | 10 | 0 | Erchil | FAPPLICS_erchil | ERCHIL | ||
| EROTHN1 | C | 10 | 0 | Erothern1 | FAPPLICS_erothern1 | EROTHN1 | ||
| EROTHA1 | C | 10 | 0 | Erotha1 | FAPPLICS_erotha1 | EROTHA1 | ||
| EROTHN2 | C | 10 | 0 | Erothn2 | FAPPLICS_erothn2 | EROTHN2 | ||
| EROTHA2 | C | 10 | 0 | Erotha2 | FAPPLICS_erotha2 | EROTHA2 | ||
| ERTRANS | C | 10 | 0 | Ertrans | FAPPLICS_ertrans | ERTRANS | ||
| ERSAVG | C | 10 | 0 | Ersavg | FAPPLICS_ersavg | ERSAVG | ||
| EREXPN1 | C | 10 | 0 | Erexpn1 | FAPPLICS_erexpn1 | EREXPN1 | ||
| EREXPA1 | C | 10 | 0 | Erexpa1 | FAPPLICS_erexpa1 | EREXPA1 | ||
| EREXPN2 | C | 10 | 0 | Erexpn2 | FAPPLICS_erexpn2 | EREXPN2 | ||
| EREXPA2 | C | 10 | 0 | Erexpa2 | FAPPLICS_erexpa2 | EREXPA2 | ||
| SINEXP | C | 10 | 0 | SIN Expiry | FAPPLICS_sinexp | SINEXP | ||
| CITSTAT | C | 1 | 0 | Citstat | FAPPLICS_citstat | CITSTAT | ||
| DATEAPP | D | 8 | 0 | Submitted On | FAPPLICS_dateapp | DATEAPP | ||
| DEPOSIT | N | 8 | 2 | Deposit | FAPPLICS_deposit | DEPOSIT | ||
| LOANDATE | D | 8 | 0 | Loandate | FAPPLICS_loandate | LOANDATE | ||
| SUMMMO | C | 1 | 0 | Summer Months Worked | FAPPLICS_summmo | SUMMMO | ||
| INC | C | 10 | 0 | Income | FAPPLICS_inc | INC |
