Missouri State University

Skip Navigation Links
Missouri State University

QDUG - ODS Security, Personally Identifiable Information, and ODSPROD Datablock Connections

Please enable JavaScript.
This application will not function properly if JavaScript is disabled.
  1. What We Change
  2. How it impacts you
  3. Personally Identifiable Information
  4. Roles for ODS
    1. PII_LVL_ONE
    2. PII_INTERNATIONAL
    3. PII_VETERAN
    4. PII_MEDICAL
    5. DATACOLL_ROLE
  5. New Argos Datablock Connections
    1. ODSPROD
    2. ODSPROD_ACCOUNTS_RECIEVABLE
    3. ODSPROD_ADVANCEMENT
    4. ODSPROD_HUMAN_RESOURCES
    5. ODSPROD_STUDENT_1
    6. View Changes on ODSPROD
What we changed:


Recently, Computer Services - MIS has undertaken a project to improve the security of the ODS data. In this effort, we will now be further restricting access to Personally Identifiable information. These restrictions are outlined in the University's policy on Personally Identifiable Information
(Chapter 12 : Op 12.02-8 of the Policy Library) available on the Missouri State Website. In order to abide by this policy and make the information available when needed, we have rewritten the ODS tables and views. Personally identifiable information is now only available in one place with improved security. We have modified and increased security on any Argos reports that previously contained information described in level three of the Information Security Data Classification Levels. The data includes, but is not limited to, social security number and birth date.

How it impacts you:


The ODSPROD_STUDENT connection will be replaced with new connections for each of the areas to use in datablocks. The connections are described below.

Personally Identifiable Information


Information access needs to be secure especially when it comes to accessing personal information. The ODS will now accommodate this plan to make our personal information more secure. We have created four new roles to categorize this information and limit access to users. These four new roles are described below.

Roles for ODS


PII_LVL_ONE


The PII _LVL_ONE role is the highest level of personally identifiable information and should only be granted to users with a specific business need. The role includes one view called Z_PII _LVL_ONE. The view includes Birth_Date, Tax_ID (SSN), Government_ID, Deceased_Date and Foreign_SSN. This is the only view with this type of information available. To request access to this role please contact
QDUG Administration. Any usage of this view will require a user to login to the ODSPROD database using their ODSPROD credentials.

PII_INTERNATIONAL


The PII_INTERNATIONAL role is a role given to users that need access to visa and passport information. The role includes the views VISA, PERSON_INTERNATIONAL, C_VISA_CURRENT, and VISA_CURRENT. To request access to this role please contact
QDUG Administration. Any usage of this view will require a user to login to the ODSPROD database using their ODSPROD credentials.

PII_VETERAN


The PII_VETERAN role is a role given to users that need access to veteran information. The role includes the view PERSON_VETERAN. To request access to this role please contact
QDUG Administration. Any usage of this view will require a user to login to the ODSPROD database using their ODSPROD credentials.

PII_MEDICAL


The PII_MEDICAL role is a role given to users that need access to medical and disability information. The role includes the views MEDICAL_INFORMATION, MEDICAL_INFORMATION_SLOT. To request access to this role please contact
QDUG Administration. Any usage of this view will require a user to login to the ODSPROD database using their ODSPROD credentials.

DATACOLL_ROLE


The DATACOLL_ROLE is a role given to users that need access to legacy data. The role includes the all views in the DATACOLL schema in ODSPROD. To request access to this role please contact
QDUG Administration. Any usage of this view will require a user to login to the ODSPROD database using their ODSPROD credentials.

New Argos Datablock Connections


ODSPROD


The ODSPROD connection allows users' access to not only personally identifiable information but datablocks that crossover between areas. If a datablock contains views from more than on area, personally identifiable information or DATACOLL tables, the datablock must use the ODSPROD connection. Users needing to access this datablock will need to request access to the appropriate views. Please contact
QDUG Administration.to request access to this connection or a table or view is not available using this connection.
Financial Views will still only be available using the ODSPROD connection and require a second login.

ODSPROD_ACCOUNTS_RECEIVABLE


ODSPROD_ACCOUNTS RECEIVABLE allows access to all Accounts Receivable and the other area's view excluding the personally identifiable information views as described in the table documentation webpage on the QDUG website. For a list of the Accounts Receivable views please see the link below or click on the Table Documentation link on the QDUG homepage. Some BEARDATA views, tables and functions will also be available using this connection. This connection is only available for use in the Student and Financial Aid areas. Users outside this area will need to request access. Please contact
QDUG Administration.to request access to this connection or a table or view is not available using this connection.

Accounts Receivable Views
Common Views
ODSLOV


ODSPROD_ADVANCEMENT


ODSPROD_ADVANCEMENT allows access to all Advancement views as described in the table documentation webpage on the QDUG website. The connection will also allow access to any of the Common Views and the ODSLOV views as listed in the table documentation webpage. For a list of these views please see the link below or click on the Table Documentation link on the QDUG homepage. Some BEARDATA views, tables and functions will also be available using this connection. This connection is only available for use in the Advancement area. Users outside this area will need to request access. Please contact
QDUG Administration.to request access to this connection or a table or view is not available using this connection.

Advancement Views
Common Views
ODSLOV


ODSPROD_HUMAN_RESOURCES


ODSPROD_HUMAN_RESOURCES allows access to all Human Resource views as described in the table documentation webpage on the QDUG website. The connection will also allow access to any of the Common Views and the ODSLOV views as listed in the table documentation webpage. For a list of these views please see the link below or click on the Table Documentation link on the QDUG homepage. Some BEARDATA views, tables and functions will also be available using this connection. This connection is only available for use in the Human Resources area. Users outside this area will need to request access. Please contact
QDUG Administration.to request access to this connection or a table or view is not available using this connection.

Human Resources Views
Common Views
ODSLOV


ODSPROD_STUDENT_1


ODSPROD_STUDENT_1 allows access to all Student and Financial Aid views as described in the table documentation webpage on the QDUG website. The connection will also allow access to any of the Common Views and the ODSLOV views as listed in the table documentation webpage. For a list of these views please see the link below or click on the Table Documentation link on the QDUG homepage. Some BEARDATA views, tables and functions will also be available using this connection. This connection is only available for use in the Student and Financial Aid areas. Users outside this area will need to request access. Please contact
QDUG Administration.to request access to this connection or a table or view is not available using this connection.

Student Views
Financial Aid Views
Common Views
ODSLOV


View Changes on ODSPROD


The new security changes in ODS have cause some small changes some of the ODS views. We have removed PII from any ODS view that in the past contained PII. We have also revoked access to views that contain mostly PII but all information is still accessible but from different views. Below is a list of views that have changed or are no longer available. If you are using any views that are no longer available in your queries you will need to make adjustments. Please contact QDUG Administration if you have any questions or concerns. For more information on what has been changed, please see the PII reference chart below.

Module Views/Tables Roles Changes to existing views/new views created
Accounts Receivable RECEIVABLE_ACCOUNT Only accessible to AR Role Tax ID Removed.
Advancement C_CONSTITUENT_ENTITY No longer accessible a new view has been created. Table Replaced by ODSMGR.C_CONSTITUENT_ENTITY_MV
Advancement CONSTITUENT_ENTITY Only accessible to Advancement Role Birth Date removed.
Advancement RELATIONSHIP Only accessible to Advancement Role Birth Date and Tax ID removed.
BEARDATA IPEDS_DEMOGRAPHIC Only accessible to Datacoll Role No change to view
BEARDATA PHOENIX_STUDENT Only accessible to Datacoll Role No Longer accessible from any role
BEARDATA SP_SU_09_RSH Only accessible to Student Role No change to view
BEARDATA Z_GRADSTUB Only accessible to Datacoll Role No change to view
Common ADDRESS Only accessible to Common Role Tax ID Removed.
Common C_PERSON No longer accessible from any role No longer accessible from any role
Common C_PERSON_DETAIL No longer accessible a new view has been created. Table Replaced by ODSMGR.C_PERSON_DETAIL_VW
Common C_PERSON_SENSITIVE No longer accessible from any role No longer accessible from any role
Common C_VISA_CURRENT Only accessible to PII_International Role No change to view
Common CROSS_REFERENCE_SLOT Only accessible to Common Role Tax ID Removed.
Common MEDICAL_INFORMATION Only accessible to PII_Medical_Role No change to view
Common MEDICAL_INFORMATION_SLOT Only accessible to PII_Medical Role No change to view
Common ORGANIZATION_ENTITY Only accessible to Common Role Government ID and Tax ID removed
Common PERSON No longer accessible from any role No longer accessible from any role
Common PERSON_DETAIL Only accessible to Common Role Birth Date, Government ID, Passport Number, Tax ID, Veteran Special Disabled Indicator, and Visa information removed.
Common PERSON_INTERNATIONAL Only accessible to PII_International Role Government ID and Tax ID removed
Common PERSON_SENSITIVE No longer accessible from any role No longer accessible from any role
Common PERSON_VETERAN Only accessible to PII_Veteran_Role Birth Date, Government ID, and Tax ID, information removed.
Common VISA Only accessible to PII_International Role No change to view
Finance GRANT_LEDGER Only accessible to Finance Role Visa Information Removed.
Finance INVOICE Only accessible to Finance Role Tax ID Removed.
Finance VENDOR Only accessible to Finance Role Tax ID Removed.
Financial Aid C_NEED_ANALYSIS No longer accessible a new view has been created. Table Replaced by ODSMGR.C_NEED_ANALYSIS_VW
Financial Aid C_NEED_ANALYSIS_DEMOGRAPHIC No longer accessible a new view has been created. Table Replaced by ODSMGR.C_NEED_ANALYSIS_DEMOGRAPHIC_VW
Financial Aid GOVERNMENT_FINANCIAL_AID Only accessible to Student Role Birth Date and Tax ID removed.
Financial Aid LOAN_AGGREGATES Only accessible to Student and Financial Aid Role Birth Date and Tax ID removed.
Financial Aid LOAN_APPLICATION Only accessible to PII_Medical_Role Birth Date and Tax ID removed.
Financial Aid NEED_ANALYSIS Only accessible to Student and Financial Aid Role Tax ID Removed.
Financial Aid NEED_ANALYSIS_DEMOGRAPHIC Only accessible to Student and Financial Aid Role Birth Date, tax ID and Visa Information removed.
Human Resources BENEFICIARY_DEPENDANT Only accessible to HR Role Birth Date removed.
Human Resources BENEFICIARY_SLOT Only accessible to HR Role Birth Date and Tax ID removed.
Student C_GOVERNMENT_ACADEMIC_OUTCOME No longer accessible a new view has been created. Table Replaced by ODSMGR.C_GOV_ACADEMIC_OUTCOME_VW
Student C_GOVERNMENT_ADMISSIONS No longer accessible a new view has been created. Table Replaced by ODSMGR.C_GOVERNMENT_ADMISSIONS_VW
Student C_GOVERNMENT_STUDENT No longer accessible a new view has been created. Table Replaced by ODSMGR.C_GOVERNMENT_STUDENT_VW
Student C_STUDENT No longer accessible a new view has been created. Table Replaced by ODSMGR.C_STUDENT_VW
Student GOVERNMENT_ACADEMIC_OUTCOME Only accessible to Student Role Birth Date removed.
Student GOVERNMENT_ADMISSIONS Only accessible to Student Role Birth Date removed.
Student GOVERNMENT_STUDENT Only accessible to Student and Financial Aid Role Birth Date and Visa information removed.
Student STUDENT Only accessible to Student Role Veteran Special Disability Indicator removed.
Student STUDENT_EXTENDED Only accessible to Student Role Veteran Special Disability Indicator removed.