STUDENTS Structure
From CrossRoad
Revision as of 04:53, 8 September 2009 by WikiSysop (talk | contribs) (New page: <table border><Caption>STUDENTS</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 |
|---|---|---|---|---|---|---|---|---|
| STUDID | N | 6 | 0 | 999999 | Student ID | Student Identification Number | STUDID | |
| 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 | |
| YEAR | C | 7 | 0 | @K 9999/99 | Year | Academic Year | YEAR | |
| SESSION | C | 1 | 0 | 9 | Session | Academic Term | TERM | |
| ACDSTAT | C | 2 | 0 | Academic Status | Academic Status for this individual | ACDSTAT | ||
| STDSTAT | C | 2 | 0 | Student Status | Student status for this individual | STDSTAT | ||
| COMMCODE | C | 250 | 0 | Comments | Comment codes for transcript | COMMCODE | ||
| DEGREE | C | 4 | 0 | @! XXXX | Degree | Degree program | DEGREE | |
| MAJOR | C | 4 | 0 | Major/Concentration | Major or Concentration for this program | CONC | ||
| MINOR | C | 4 | 0 | Major/Concentration | Major or Concentration for this program | CONC | ||
| ADMSTAT | C | 2 | 0 | Admission Status | Admissions status for this individual | ADMSTAT | ||
| IDCENT | N | 2 | 0 | 99 | ID Century | Century of Student Identification Number | IDCENT | |
| CONF_DATE | D | 8 | 0 | Conferred | Date on which degree was conferred | students_conf_date | CONF_DATE |
