STDNT_ADVR_HIST - Student Advisor History

peoplesoft campus-solutions DARTS PSQUERY campus-solutions-reporting

This Table includes Student Advisor Demographic details

Detailed Information

This Table includes Academic Degree description detail

Key	Record.Fieldname	Format	XLAT	Heading Text
	A.ACAD_CAREER - Academic Career	Char4		Career
	A.ACAD_PLAN - Academic Plan	Char10		Acad Plan
	A.ACAD_PROG - Academic Program	Char5		Acad Prog
	A.ACAD_SUB_PLAN - Academic Sub-Plan	Char10		Sub-Plan
	A.ADVISOR_ID - Academic Advisor	Char11		Advisor
Key	A.ADVISOR_ROLE - Advisor Role	Char4	N	Advr. Role
	A.APPROVE_ENRLMT - Must Approve Enrollment	Char1		App Enrlmt
	A.APPROVE_GRAD - Must Approve Graduation	Char1		Aprve Grad
	A.COMMITTEE_ID - Committee	Char6		Committee
	A.COMM_PERS_CD - Advised by Committee	Char1		Adv Comm
Key	A.EFFDT - Effective Date	Date		Eff Date
Key	A.EMPLID - Empl ID	Char11		ID
	A.GRAD_APPROVED - Graduation Approved	Char1		Grad Aprvd
	A.INSTITUTION - Academic Institution	Char5		Institution
	A.SSR_ADVR_PERCNT - Advisor Percentage	Num3.1		Percentage
Key	A.STDNT_ADVISOR_NBR - Student Advisor Number	Num2.0		Stdnt Nbr

Field Value	Translate Long Name	Translate Short Name
ADVR	Advisor	Advisor
ATHL	Athletic Counselor	Athletic
CARA	Career Advisor	Career Adv
CERT	Certificate Advisor	Cert Advis
CON	Concentration Advisor	Con Advr
FAA	Faculty Academic Advisor	FacAcadAdv
FAL	Faculty Advisor Liaison	FacAdvLias
FACM	Faculty Mentor	Fac Mentor
FFDC	FFD Coach	FFD Coach
FPC	Field Placement Coordinator	FieldCoord
FYRA	First Year Advisor	FYR Adv
HON	Honors Advisor	Honors
INTL	International Advisor	InNational
JMG	JMG Specialist	JMG
JSA	Johnson Scholars Advisor	Johnson
MAC	Major Advising Coordinator	MajAdvCoor
MINR	Minor Advisor	Minor Advi
NSE	NSE Advisor	NSE
ONL	Online Advisor	Online Adv
PROF	Professional Academic Advisor	PrfAcadAdv
PROG	Program Coordinator	Prog Coord
QEC	Qualifying Exam Committee	Qualifying
SMAJ	Second Major Advisor	2nd Advis
SSA	Student Success Advisor	SSA
THES	Thesis Committee	Thesis Com
TRIO	TRiO Advisor	TRiO
CBEA	YourPace AcademicSuccess Coach	YPASC

0 reviews