InfoAccess  
DATA VIEW NAME ADDRESSES_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: Contact: Julie Schumacher/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 03/01 - Created
09/04 - Data Custodian change
03/08 - Data Custodian change
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.

HOME_ADDRESS_LINE1

CHAR 35

First line of the student’s permanent home address.

HOME_ADDRESS_LINE2

CHAR 35

Second line of the student’s permanent home address.

HOME_ADDRESS_LINE3

CHAR 35

Third line of the student’s permanent home address.

HOME_ADDRESS_LINE4

CHAR 35

Fourth line of the student’s permanent home address.

HOME_ADDRESS_CITY

CHAR 30

City of the student’s permanent home address.

HOME_ADDRESS_STATE

CHAR 2

State of the student’s permanent home address.

HOME_ADDRESS_ZIP

CHAR 10

Zip code of the student’s permanent home address.

HOME_ADDRESS_COUNTRY

CHAR 8

Country of the student’s permanent home address.

HOME_ADDRESS_COUNTRY_DESC

CHAR 30

Description of the country of the student’s permanent home address.

HOME_PHONE

CHAR 30

Student’s permanent home telephone number.

LOCAL_ADDRESS_LINE1

CHAR 35

First line of the student’s local address.

LOCAL_ADDRESS_LINE2

CHAR 35

Second line of the student’s local address.

LOCAL_ADDRESS_LINE3

CHAR 35

Third line of the student’s local address.

LOCAL_ADDRESS_LINE4

CHAR 35

Fourth line of the student’s local address.

LOCAL_ADDRESS_CITY

CHAR 30

City of the student’s local address..

LOCAL_ADDRESS_STATE

CHAR 2

State of the student’s local address.

LOCAL_ADDRESS_ZIP

CHAR 10

Zip code of the student’s local address.

LOCAL_ADDRESS_COUNTRY

CHAR 8

Country of the student’s local address.

LOCAL_ADDRESS_COUNTRY_DESC

CHAR 30

Description of the country of the student’s local address.

LOCAL_PHONE

CHAR 30

Student’s local telephone number.

RMA_ADDRESS_LINE1

CHAR 35

First line of the student’s residence hall address.

RMA_ADDRESS_LINE2

CHAR 35

Second line of the student’s residence hall address.

RMA_ADDRESS_LINE3

CHAR 35

Third line of the student’s residence hall address.

RMA_ADDRESS_LINE4

CHAR 35

Fourth line of the student’s residence hall address.

RMA_ADDR_MODIFIER

CHAR 30

Box/room number of the student’s residence hall address.

RMA_ADDRESS_CITY

CHAR 30

City of the student’s residence hall address.

RMA_ADDRESS_STATE

CHAR 2

State of the student’s residence hall address.

RMA_ADDRESS_ZIP

CHAR 10

Zip code of the student’s residence hall address.

RMA_ADDRESS_COUNTRY

CHAR 8

Country of the student’s residence hall address.

RMA_ADDRESS_COUNTRY_DESC

CHAR 30

Description of the country of the student’s residence hall address.

RMA_ADDRESS_PHONE

CHAR 30

Student’s residence hall telephone number.
(Note: "other" in the following section refers to a student’s address which is not their permanent home address, nor their UW-Stout address, nor a business address. An example may be the address while a potential transfer student is attending another school.).

OTHER_ADDRESS_LINE1

CHAR 35

First line of the student’s other address..

OTHER_ADDRESS_LINE2

CHAR 35

Second line of the student’s other address.

OTHER_ADDRESS_LINE3

CHAR 35

Third line of the student’s other address.

OTHER_ADDRESS_LINE4

CHAR 35

Fourth line of the student’s other address.

OTHER_ADDRESS_CITY

CHAR 30

City of the student’s other address..

OTHER_ADDRESS_STATE

CHAR 2

State of the student’s other address.

OTHER_ADDRESS_ZIP

CHAR 10

Zip code of the student’s other address.

OTHER_ADDRESS_COUNTRY

CHAR 8

Country of the student’s other address.

OTHER_ADDRESS_COUNTRY_DESC

CHAR 30

Description of the country of the student’s other address.

OTHER_ADDRESS_PHONE

CHAR 30

Student’s other telephone number.

CAMPUS_EMAIL_ADDR

CHAR 70

Student’s UW-Stout assigned email address.

Extract_Date_Time

DATE

The System generated date when the data was last refreshed.