Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: MEDICAL_INFORMATION

Description Contains the detailed medical data for a person who has a disability.
Key & Frequency One row per person per disability.
Recommended Search Columns MEDICAL_TYPE
PERSON_UID, ACADEMIC_PERIOD, DISABILITY
DISABILITY
DISABILITY_SERVICES
PERSON_UID, MEDICAL_TYPE

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD Academic period or time frame associated with this disability.    

SGRDISA

SGRDISA_TERM_CODE

 
ACADEMIC_PERIOD_DESC Academic period description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ACADEMIC_YEAR Academic year associated with the academic period on this record.    

FUNCTION

GOKODSF.F_GET_DESC

 
ACADEMIC_YEAR_DESC Academic year description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
DISABILITY Disability type describing the area affected by the handicap.    

SGRDISA

SPRMEDI

SGRDISA_DISA_CODE

SPRMEDI_DISA_CODE

 
DISABILITY_DESC Disability type description.    

FUNCTION

GOKODSF.F_GET_DESC

 
DISABILITY_ON_SET_AGE Age noted when the disability began.    

SPRMEDI

SPRMEDI_ONSET_AGE

 
DISABILITY_SERVICES Disability service available to the person from the institution because of the disability noted.    

SGRDISA

SPRMEDI

SGRDISA_SPSR_CODE

SPRMEDI_SPSR_CODE

 
DISABILITY_SERVICES_DESC Disability service provided description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ID Person's identification number used to access the records associated with the person.    

SPRIDEN

SPRIDEN_ID

 
MEDICAL_COMMENT Free format comments associated with the medical condition or disability.    

SPRMEDI

SPRMEDI_COMMENT

 
MEDICAL_EQUIPMENT_TYPE Medical equipment associated with the person's medical problem.    

SPRMEDI

SPRMEDI_MDEQ_CODE

 
MEDICAL_EQUIPMENT_TYPE_DESC Medical equipment type description.    

FUNCTION

GOKODSF.F_GET_DESC

 
MEDICAL_TYPE Major medical condition associated with the person.    

SGRDISA

SPRMEDI

SGRDISA_MEDI_CODE

SPRMEDI_MEDI_CODE

 
MEDICAL_TYPE_DESC Person's medical code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NAME Combination of the person's last, first, and middle initial into one value.    

FUNCTION

F_FORMAT_NAME

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

SGRDISA

SPRMEDI

SGRDISA_PIDM

SPRMEDI_PIDM

 
PRIMARY_DISABILITY_IND This field denotes whether this disability is the primary disability.    

SGRDISA

SPRMEDI

SGRDISA_PRIMARY_IND

SPRMEDI_DISB_IND

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
SUB_ACADEMIC_PERIOD A session, portion or part of the academic period.    

NA

NA

 
SUB_ACADEMIC_PERIOD_DESC Subacademic period description.    

NA

NA

 


Ver: 8.3