DARTS : UM_GRAD_APPL_VW - Student Acad Prog Prompt Vw

Key	Record.Fieldname	Format	XLAT	Heading Text
→	ACAD_CAREER - Academic Career	Char4	N	Career
	ADDRESS1 - Address Line 1	Char55		Address 1
	ADDRESS2 - Address Line 2	Char55		Address 2
	ADDRESS3 - Address Line 3	Char55		Address 3
	ADDRESS4 - Address Line 4	Char55		Address 4
	CITY - City	Char30		City
	CITY2 - City	Char30		City
	COUNTRY - Country	Char3		Country
	COUNTRY2 - Country	Char3		Cntry
	COUNTY - County	Char30		County
	CREATED_DTTM - Created Datetime	DateTm		Created DTTM
	CREATEOPRID - User ID	Char30		User
	DATE_ISSUED - Date Issued	Date		Date
→	EFFDT - Effective Date	Date		Eff Date
→	EFFSEQ - Effective Sequence	Num3.0		Sequence
→	EMPLID - Empl ID	Char11		ID
	FERPA - FERPA	Char1		FERPA
	FIRST_NAME - First Name	Char30		First Name
→	INSTITUTION - Academic Institution	Char5		Institution
	LAST_NAME - Last Name	Char30		Last
	MIDDLE_NAME - Middle Name	Char30		Middle
	POSTAL - Postal Code	Char12		Postal
	STATE - State	Char6		State
	STATE2 - State	Char6		St
→	STRM - Term	Char4		Term
	UM_GRAD_APP_STATUS - Application Status	Char2	N	Status
	UM_GRAD_ASSIST - Request Special Accommodations	Char1		RequestAccom
	UM_GRAD_ASSIST_ST - Status of Accomodation Request	Char1	N	Status
	UM_GRAD_ATTEND - Will Attend Commencement	Char1		Attend
	UM_GRAD_ATTEND_MO - Commencement Month	Char2		Month
	UM_GRAD_ATTEND_YR - Commencement	Char4		Commencement
	UM_GRAD_EXCLUDE - Do Not Include Me	Char1		Exclude Me
	UPDATED_DTTM - Last Updated	DateTm		Updated
	UPDATED_USERID - Updated UserID	Char30		Updated UserID

Data Dictionary Links

Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.

SQL code for UM_GRAD_APPL_VW

SELECT A.EMPLID,
       A.INSTITUTION,
       A.ACAD_CAREER,
       A.STRM,
       A.EFFDT,
       A.EFFSEQ,
       A.UM_GRAD_APP_STATUS,
       A.FIRST_NAME,
       A.MIDDLE_NAME,
       A.LAST_NAME,
       A.ADDRESS1,
       A.ADDRESS2,
       A.ADDRESS3,
       A.ADDRESS4,
       A.CITY,
       A.COUNTY,
       A.STATE,
       A.POSTAL,
       A.COUNTRY,
       A.DATE_ISSUED,
       A.UM_GRAD_EXCLUDE,
       A.CITY2,
       A.STATE2,
       A.COUNTRY2,
       A.UM_GRAD_ATTEND,
       A.UM_GRAD_ATTEND_MO,
       A.UM_GRAD_ATTEND_YR,
       A.UM_GRAD_ASSIST,
       A.UM_GRAD_ASSIST_ST,
       A.CREATEOPRID,
       A.CREATED_DTTM,
       A.UPDATED_USERID,
       A.UPDATED_DTTM,
       B.UM_FERPA
  FROM PS_UM_GRAD_APPL_HD A, PS_UM_FERPA_VW B
 WHERE B.EMPLID = A.EMPLID;