Purpose: Apply the Grouper GrH Drive oups permissions on SPS Analytics folders List of SPS Departments and their data location on the H drive.
List of the Grouper GroupsDepartments and folders:
| Department | H Drive SPS Analytics |
Folders (H drive map: \\c-gp1.ais.columbia.edu\grp1)Data Type| Folders | Data and Report |
| Finance | H:\SCE\Systems and Data Analysis\SPS Analytics\Tuition Management | Finance data and ad-hoc reports |
| Graduate Programs | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs | Degree Program Data |
SPSAIS--RWXSPSAIS-Alumni-RWX | H:\SCE\Systems and Data Analysis\SPS Analytics\SPS All Programs |
Modify | SPSAIS-Admissions-RWX| Registration, Course Data, and Graduation Data for All Programs |
| Alumni | H:\SCE\Systems and Data Analysis\SPS Analytics\Projects\Alumni |
Modify | SPSAIS-Projects-RWX| Alumni data and ad-hoc reports |
| Admissions | H:\SCE\Systems and Data Analysis\SPS Analytics\Projects\Admissions |
Modify | SPSAIS-| Admissions data and ad-hoc reports |
| Projects | H:\SCE\Systems and Data Analysis\SPS Analytics\Projects |
Modify | | Special Project data and ad-hoc reports |
| External Projects |
-RWX | H:\SCE\Systems and Data Analysis\SPS Analytics\Projects\Enrollment Projection Tool-New |
ModifySPSAIS--RWXSPSAIS-Sports-RWX| Science | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Actuarial |
Modify | SPSAIS-IKNS-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Sports Management | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Sports |
Modify | SPSAIS-Narrative Medicine-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Information and Knowledge Strategy | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\IKNS |
Modify | SPSAIS-Bioethics-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Narrative Medicine | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Narrative Medicine |
Modify | SPSAIS-Construction-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Bioethics | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Bioethics |
Modify | SPSAIS-Wealth Management-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Construction Administration | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Construction |
Modify | SPSAIS-Nonprofit-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Wealth Management | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Wealth Management |
Modify | SPSAIS-Communications-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Nonprofit Management | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Nonprofit |
Modify | SPSAIS-ERM-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Strategic Communication | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Communications |
Modify | SPSAIS-Analytics-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Enterprise Risk Management | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\ERM |
Modify | SPSAIS-Sustainability-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Applied Analytics | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Analytics |
Modify | SPSAIS-Negotiation-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Sustainability Management | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Sustainability |
Modify | SPSAIS-Technology-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Negotiation and Conflict Resolution | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Negotiation |
Modify | SPSAIS-| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Technology Management | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Technology |
Modify | | Registration, Course Data, Graduation Data, and ad-hoc reports |
| Human Capital Management |
-RWXSPSAIS-Insurance Management-RWX | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Human Capital Management |
Modify | SPSAIS-Nondegree Programs-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Insurance Management | H:\SCE\Systems and Data Analysis\SPS Analytics\Degree Programs\Insurance Management |
Modify | SPSAIS-High School-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Nondegree Programs | H:\SCE\Systems and Data Analysis\SPS Analytics\Nondegree Programs |
Modify | SPSAIS-Auditing-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| High School | H:\SCE\Systems and Data Analysis\SPS Analytics\Nondegree Programs\High School |
Modify | SPSAIS-Certificates-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Auditing | H:\SCE\Systems and Data Analysis\SPS Analytics\Nondegree Programs\Auditing |
Modify | SPSAIS-CPA-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Certificates - CER | H:\SCE\Systems and Data Analysis\SPS Analytics\Nondegree Programs\Certificates |
Modify | SPSAIS-Registration-RWX| Registration, Course Data, Graduation Data, and ad-hoc reports |
| Certification of Professional Achievement - CPA | H:\SCE\Systems and Data Analysis\SPS Analytics\Nondegree Programs\Certification of Professional Achievement |
Modify | | Registration, Course Data, Graduation Data, and ad-hoc reports |
| Registration Enablement | H:\SCE\Systems and Data Analysis\SPS Analytics\Registration Enablement |
Modify | | SPSAIS-Root-List | H:\SCE\Systems and Data Analysis | List |
SPSAIS-Root-Full | H:\SCE\Systems and Data Analysis | Full Control| Registration Enablement report |
Note: Data access to the above folders is provided to individuals with specific job descriptions and supervisor approval. Most of the data and the reports are in MS Excel format and the data is refreshed daily.