Home / About SNHU / Administrative Offices / Computing Resources / Data Retrieval / File Pointers

File Pointers

CO-FILES all have the same key or @ID. Examples of PERSON CO-FILES are APPLICANTS, FACULTY, FACULTY.QUALS, FIN.AID, INSTITUTIONS, PERSON.ST, STUDENTS, and VENDORS. Most files that are not CO-FILES of PERSON will have a link to the PERSON File. The following table lists frequestly used files and the PERSON link. Other helpful links may also be listed.

FILE	PERSON LINK	OTHER FILE LINKS TO...	FILE NAME
ACAD.CREDENTIALS	ACAD.PERSON.ID	ACAD.ACAD.PROGRAM N19.ACAD.PREFERRED. ADDRESS	ACAD.PROGRAMS ADDRESS
APPLICATIONS	APPL.APPLICANT	APPL.ACAD.PROGRAM APPL.STUDENT.PROGRAMS.ID N19.APPL.ADDRESSCODE	ACAD.PROGRAMS STUDENT.PROGRAMS ADDRESS
AR.ACCTS	ARA.PERSON.ID	ARA.RESTRICTION.IDS ARA.INVOICES ARA.TERMS	STUDENT.RESTRICTIONS AR.INVOICES TERMS
CASH.RCPTS	RCPT.PAYER.ID	RCPT.ITEMS RCPT.PAYMENTS RCPT.DEPOSITS	CASH.RCPT.ITEMS AR.PAYMENTS AR.DEPOSITS
COURSE.SECTIONS	NONE - GO THROUGH STUDENT. COURSE.SEC	SEC.FACULTY SEC.STUDENTS SEC.TERM	COURSE.SEC.FACULTY STUDENT.COURSE.SEC TERMS
GRADUATES	GRAD.STUDENT	GRAD.ACAD.PROGRAM GRAD.STUDENT:"*": GRAD.ACAD.LEVEL	ACAD.PROGRAMS STUDENT.ACAD.LEVELS
INSTITUTIONS. ATTEND	INSTA.PERSON.ID	INSTA.ACAD.CREDENTIALS INSTA.INSTITUTIONS.ID	ACAD.CREDENTIALS INSTITUTIONS
ROOM.ASSIGNMENT	RMAS.PERSON.ID	RMAS.ROOM.AR.POSTINGS RMAS.BLDG RMAS.TERM N19.RMAS.STUDENT. TERMS.ID	ROOM.AR.POSTINGS BUILDINGS TERMS STUDENT.TERMS
STUDENT.ACAD. CRED	STC.PERSON.ID	STC.COURSE STC.STUDENT.COURSE.SEC STC.TERM	COURSES STUDENT.COURSE.SEC TERMS
STUDENT.COURSE .SEC	STC.PERSON.ID SCS.STUDENT	SCS.STUDENT.ACAD.CRED SCS.COURSE.SECTION SCS.REG.AR.POSTING.ITEMS SCS.TERM	STUDENT.ACAD.CRED COURSE.SECTIONS REG.AR.POSTING.ITEMS TERMS
STUDENT.TERMS	STTR.STUDENT	STTR.STUDENT.ACAD.CRED STTR.ACAD.LEVEL.ID STTR.TERM	STUDENT.ACAD.CRED STUDENT.ACAD.LEVELS TERMS