FAPPLICS Structure - Revision history

WikiSysop: New page:
2009-09-08T04:44:38Z

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

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

FAPPLICS
FieldName Data Type Length Decimals Picture Caption Description HelpContext