Go To View:  RETURN TO REPORTING VIEW 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 PERSON_UID, ACADEMIC_PERIOD, DISABILITY
DISABILITY
DISABILITY_SERVICES
MEDICAL_TYPE
PERSON_UID, MEDICAL_TYPE

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame associated with this disability. VARCHAR2(63)

SGRDISA

SGRDISA_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

DISABILITY Disability type describing the area affected by the handicap. VARCHAR2(63)

SGRDISA

SPRMEDI

SGRDISA_DISA_CODE

SPRMEDI_DISA_CODE

DISABILITY_DESC Disability type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DISABILITY_ON_SET_AGE Age noted when the disability began. NUMBER

SPRMEDI

SPRMEDI_ONSET_AGE

DISABILITY_SERVICES Disability service available to the person from the institution because of the disability noted. VARCHAR2(63)

SGRDISA

SPRMEDI

SGRDISA_SPSR_CODE

SPRMEDI_SPSR_CODE

DISABILITY_SERVICES_DESC Disability service provided description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ID Person's identification number used to access the records associated with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

MEDICAL_COMMENT Free format comments associated with the medical condition or disability. VARCHAR2(4000)

SPRMEDI

SPRMEDI_COMMENT

MEDICAL_EQUIPMENT_TYPE Medical equipment associated with the person's medical problem. VARCHAR2(63)

SPRMEDI

SPRMEDI_MDEQ_CODE

MEDICAL_EQUIPMENT_TYPE_DESC Medical equipment type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MEDICAL_TYPE Major medical condition associated with the person. VARCHAR2(63)

SGRDISA

SPRMEDI

SGRDISA_MEDI_CODE

SPRMEDI_MEDI_CODE

MEDICAL_TYPE_DESC Person's medical code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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

FUNCTION

F_FORMAT_NAME

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

SGRDISA

SPRMEDI

SGRDISA_PIDM

SPRMEDI_PIDM

PRIMARY_DISABILITY_IND This field denotes whether this disability is the primary disability. VARCHAR2(1)

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. VARCHAR2(255)

NA

NA

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Subacademic period description. VARCHAR2(255)

NA

NA



Ver: 8.0