RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Operational Data Store
Reporting View Target: PERSON_SENSITIVE

Description Contains person data that is considered sensitive information that can be secured and accessed only by authorized staff.
Key & Frequency One row per person.
Recommended Search Columns PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AGE Calculated Age (subtract the birth date from the current system date). NUMBER

FUNCTION

F_CALCULATE_AGE

BIRTH_DATE Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

ETHNICITY_EDI_EQUIV EDI/SPEEDE ethnicity code that equates to the ethnic code. VARCHAR2(63)

STVETHN

STVETHN_EDI_EQUIV

FIRST_NAME Person's first or given name. VARCHAR2(15)

SPRIDEN

SPRIDEN_FIRST_NAME

FOREIGN_TAX_ID Unique identification number for tax purposes from a country outside the institution's home country. VARCHAR2(9)

GOBINTL

GOBINTL_FOREIGN_SSN

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

FUNCTION

F_FORMAT_NAME

GENDER Gender of the person. VARCHAR2(63)

SPBPERS

SPBPERS_SEX

GENDER_DESC Gender code description. VARCHAR2(63)

CALCULATION

DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')

GOVERNMENT_ID Identification assigned by the institution's home government when the tax id is from a different government. VARCHAR2(63)

NA

NA

HISPANIC_LATINO_ETHNICITY_IND Indicates if person's ethnicity is Latino or Hispanic. Due to mandated changes to the collection of race and ethnicity, these classifications were changed to separate Race and Ethnicity. Ethnicity can now be defined as either Hispanic or Latino, or Not Hispanic or Latino. VARCHAR2(1)

SPBPERS

SPBPERS_ETHN_CODE

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

SPRIDEN

SPRIDEN_ID

IMMIGRATION_STATUS Indicates whether immigration information has been received by the institution. VARCHAR2(63)

GOBINTL

GOBINTL_I94_STATUS

IMMIGRATION_STATUS_DATE Date the person was admitted to or departed the country. DATE

GOBINTL

GOBINTL_I94_DATE

LAST_NAME Person's last name. VARCHAR2(60)

SPRIDEN

SPRIDEN_LAST_NAME

LEGACY Legacy code of the person. VARCHAR2(63)

SPBPERS

SPBPERS_LGCY_CODE

LEGACY_DESC Legacy code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MARITAL_STATUS Marital status code of the person. VARCHAR2(63)

SPBPERS

SPBPERS_MRTL_CODE

MARITAL_STATUS_DESC Marital status description associated with the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MEDICAL_INFORMATION_COUNT Number of medical information records for the person. NUMBER

FUNCTION

MSKFUNC.F_COUNT_MEDICAL_INFORMATION

MIDDLE_NAME Person's middle name. VARCHAR2(15)

SPRIDEN

SPRIDEN_MI

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

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

SPBPERS

SPBPERS_PIDM

PRIMARY_DISABILITY Primary or first major disability for the person because of this handicap. VARCHAR2(63)

SPRMEDI

SPRMEDI_DISA_CODE

PRIMARY_DISABILITY_DESC Disability type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SPRMEDI

SPRMEDI_SPSR_CODE

PRIMARY_ETHNICITY Ethnicity used for institutional standard reporting. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIMARY_ETHNICITY_DESC Ethnicity code description. VARCHAR2(255)

STVETHN

STVETHN_DESC

PRIMARY_MEDICAL_CONDITION Primary or first major medical condition associated with the person. VARCHAR2(63)

SPRMEDI

SPRMEDI_MEDI_CODE

PRIMARY_MEDICAL_CONDITION_DESC Medical condition description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PRIMARY_MEDICAL_EQUIPMENT Medical equipment required because of the person's medical problem. VARCHAR2(63)

SPRMEDI

SPRMEDI_MDEQ_CODE

PRIMARY_MEDICAL_EQUIPMENT_DESC Medical equipment description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PRIM_DISABILITY_SERVICE_DESC Disability service description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PRIM_ETHNICITY_CATEGORY Ethnic category used for governmental and other standard types of reporting. VARCHAR2(63)

STVETHN

STVETHN_ETCT_CODE

PRIM_ETHNICITY_CATEGORY_DESC Ethnic category description. VARCHAR2(255)

STVETCT

STVETCT_DESC

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

NA

NA

RACE_CATEGORY_COUNT Number of unique regulatory races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE_CATEGORY

RACE_COUNT Number of races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE

RACE_ETHNICITY_CONFIRM_DATE Race and ethnicity self confirmed date. DATE

SPBPERS

SPBPERS_CONFIRMED_RE_DATE

RACE_ETHNICITY_CONFIRM_IND Indicates if the person's race and ethnicity have been self-identified. VARCHAR2(1)

SPBPERS

SPBPERS_CONFIRMED_RE_CDE

RELIGION Religious affiliation recorded for the person. VARCHAR2(63)

SPBPERS

SPBPERS_RELG_CODE

RELIGION_DESC Person's religious affiliation description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TAX_ID Person's tax identification number assigned by their home federal government. VARCHAR2(63)

SPBPERS

SPBPERS_SSN



Ver: 3.1