| Infoaccess | |
| DATA VIEW NAME | BIO_DEMO_STOUT |
| OVERVIEW | This view contains student demographic information for each student registered for the current term and any future terms at UW-Stout. Students who have withdrawn or are deceased are also included but have been identified accordingly. A FERPA indicator is provided in this view and it is the users responsibility to check this indicator if the information is being considered for release. |
| LOAD FREQUENCY | The data is refreshed every night |
| DATA CUSTODIAN | Undergraduate
Admissions Office/Records and Registration Office Contact: Larry Graves |
| AUTHORIZATION | You
must receive approval to access data from the data custodian. For information about the authorization forms and the connections necessary, connect to the Infoaccess home page. |
| SPECIAL CONSIDERATIONS | |
| QUESTIONS | Contact:
Division of Information Technology Help Desk Phone: 264-HELP (4357) |
| LAST UPDATED |
09/00 Data view
created |
| FIELD DEFINITIONS | Key
fields are identified with an asterisk (*). Field Formats describe the field type and length. |
| CHAR2(
N) or CHAR (N) - Alphanumeric field. (N) is the length of the field.
Field contains letters and/or numbers. Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’ (N) is the length of the field. Field contains letters and/or numbers. |
|
| NUM
(N) - Numeric field. (N) is the length of the field. Field contains
only numbers. Numbers with decimal points are represented as NUM (X.Y)
X = total number of digits Y = the number of decimals after the decimal
Examples: NUM (6,2) could contain 2500.12 NUM (6) could contain 000005 or 550000 |
|
| DATE
(XXXX) - Date field. (XXXX) is the format of the field. Date can be
in various formats and date functions available based on your query
tool can be used against the field. Examples: DATE (YYMMDD); DATE (YYDDD); DATE (DD-MM-YY) |
|
Field Name |
Format |
Description |
|---|---|---|
|
PERSON_ID |
CHAR 7 |
ID number assigned by Datatel to be used internally. This is a unique ID for each student. Not the same as Campus ID. |
|
CAMPUS_ID |
CHAR 16 |
Campus identification number.. |
|
SSN |
CHAR 9 |
Student’s nine digit social security number.. |
|
LAST_NAME |
CHAR 30 |
Student’s last name.. |
|
FIRST_NAME |
CHAR 30 |
Student’s first name. |
|
MIDDLE_NAME |
CHAR 10 |
Student’s middle name. |
|
GENDER |
CHAR 1 |
Student’s sex,
if indicated. |
|
BIRTH_DATE |
DATE 10 |
Student’s date
of birth. |
|
ETHNIC_CODE |
CHAR 2 |
Code indicating
a student’s ethnic group. |
|
ETHNIC_CODE_DESC |
CHAR 30 |
Description of Ethnic Group Code. |
|
CITIZENSHIP |
CHAR 3 |
Code indicating
student’s country of citizenship (last three digits). |
|
CITIZENSHIP_DESC |
CHAR 30 |
Description of country of citizenship. |
|
FERPA_FLAG |
CHAR 1 |
Restricted information indicator. |
|
DECEASED_DATE |
DATE 10 |
Date student became
deceased. |
|
AGE |
CHAR 2 |
Age of student, as of last update. |
|
VETERAN_STATUS |
CHAR 1 |
Indicates whether
a student is a veteran. |
|
MINORITY_STATUS |
CHAR 1 |
Indicates whether
a student is a minority. |
|
STATE_RESIDENCY |
CHAR 2 |
State
code of the state from which student resides. |
|
COUNTY_RESIDENCY |
CHAR 3 |
Wisconsin county
of residency. |
|
EXTRZCT_DATE_TIME |
DATE |
The System generated date when the data was last refreshed. |
|
Appendix – Valid Codes |
|
CITIZENSHIP Code Values |
|
00000988 Citizens
Abroad |