Difference between revisions of "GENSTATS Structure"
From CrossRoad
(New page: <table border><Caption>GENSTATS</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...) |
(No difference)
|
Latest revision as of 04:20, 16 September 2009
| 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 | |
| SEX | C | 1 | 0 | ! | Gender | Gender of this individual | SEX | |
| YRSTDY | C | 1 | 0 | 9 | Year of Study | Year of study in this program | YRSTDY | |
| CREDCRS | N | 3 | 0 | Credit Courses | Number of Courses taken for credit by this student | genstats_CREDCRS | CREDCRS | |
| AUDCRS | N | 3 | 0 | Audit Courses | Number of Audit Courses taken by this student | genstats_AUDCRS | AUDCRS | |
| NONCRED | N | 3 | 0 | Non-credit Courses | Number of non-credit courses taken by this student | genstats_NONCRED | NONCRED | |
| CURCREDS | N | 5 | 2 | Current Credits | Number of Credits Attempted by this student | genstats_CURCREDS | CURCREDS | |
| CONCENT | C | 4 | 0 | Major/Concentration | Major or Concentration for this program | CONC | ||
| DEGREE | C | 4 | 0 | @! XXXX | Degree | Degree program | DEGREE | |
| AGE | N | 3 | 0 | Age | Age of this student in years | genstats_AGE | AGE | |
| DENOM | C | 4 | 0 | Denomination | Denomination of this individual | DENOMLOC | ||
| ACDSTAT | C | 2 | 0 | Academic Status | Academic Status for this individual | ACDSTAT | ||
| STDSTAT | C | 2 | 0 | Student Status | Student status for this individual | STDSTAT | ||
| CITY | C | 20 | 0 | @! XXXXXXXXXXXXXXXXXXXX | City | City or Town | CHURLCCITY | |
| PROV | C | 2 | 0 | !! | Province | Province or State | PROVLOC | |
| SCHOOL | C | 30 | 0 | @! | School | High School of this individual | SCHOOL | |
| YEAR | C | 7 | 0 | @K 9999/99 | Year | Academic Year | YEAR | |
| SESSION | C | 1 | 0 | 9 | Session | Academic Term | TERM | |
| GRADUATED | L | 1 | 0 | Graduated | Indicates whether this individual has graduated | GRADUATED | ||
| GRADYR | C | 2 | 0 | Graduation Year | The graduation year for which this student has applied | gradyr | GRADYR | |
| GRADDEGREE | C | 4 | 0 | @! XXXX | Degree | Degree program | DEGREE | |
| GRADCONC | C | 4 | 0 | Major/Concentration | Major or Concentration for this program | CONC | ||
| WITHDRAWN | N | 3 | 0 | Withdrawn | Number of Withdrawn Credit Courses | genstats_WITHDRAWN | WITHDRAWN | |
| STARTYEAR | C | 7 | 0 | @K 9999/99 | Year | Academic Year | YEAR | |
| IDCENT | N | 2 | 0 | 99 | ID Century | Century of Student Identification Number | IDCENT | |
| COUNTRY | C | 20 | 0 | @! | Country | Country | COUNTRY | |
| MARITAL | C | 1 | 0 | ! | Marital Status | Marital status of this individual | MARITAL |
