This table contains data for apply for graduation. UMS does not use the PeopleSoft delivered graduation application code, so this table was created.
It is NOT available in PeopleSoft Query Manager. UM_GRAD_APPL_VW - Student Acad Prog Prompt Vw is based on this table (UM_GRAD_APPL_HD), which is available in PS Query.
| Column Number | Field Name | Type |
|---|---|---|
| 1 | EMPLID | VARCHAR2(11) |
| 2 | INSTITUTION | VARCHAR2(5) |
| 3 | ACAD_CAREER | VARCHAR2(4) |
| 4 | STRM | VARCHAR2(4) |
| 5 | EFFDT | DATE |
| 6 | EFFSEQ | INTEGER |
| 7 | UM_GRAD_APP_STATUS | VARCHAR2(2) |
| 8 | FIRST_NAME | VARCHAR2(30) |
| 9 | MIDDLE_NAME | VARCHAR2(30) |
| 10 | LAST_NAME | VARCHAR2(30) |
| 11 | ADDRESS1 | VARCHAR2(55) |
| 12 | ADDRESS2 | VARCHAR2(55) |
| 13 | ADDRESS3 | VARCHAR2(55) |
| 14 | ADDRESS4 | VARCHAR2(55) |
| 15 | CITY | VARCHAR2(30) |
| 16 | COUNTY | VARCHAR2(30) |
| 17 | STATE | VARCHAR2(6) |
| 18 | POSTAL | VARCHAR2(12) |
| 19 | COUNTRY | VARCHAR2(3) |
| 20 | DATE_ISSUED | DATE |
| 21 | UM_GRAD_EXCLUDE | VARCHAR2(1) |
| 22 | CITY2 | VARCHAR2(30) |
| 23 | STATE2 | VARCHAR2(6) |
| 24 | COUNTRY2 | VARCHAR2(3) |
| 25 | UM_GRAD_ATTEND | VARCHAR2(1) |
| 26 | UM_GRAD_ATTEND_MO | VARCHAR2(2) |
| 27 | UM_GRAD_ATTEND_YR | VARCHAR2(4) |
| 28 | UM_GRAD_ASSIST | VARCHAR2(1) |
| 29 | UM_GRAD_ASSIST_ST | VARCHAR2(1) |
| 30 | CREATEOPRID | VARCHAR2(30) |
| 31 | CREATED_DTTM | TIMESTAMP(6) |
| 32 | UPDATED_USERID | VARCHAR2(30) |
| 33 | UPDATED_DTTM | TIMESTAMP(6) |
Navigation on PeopleSoft
- Go to Campus Community > Student Service Center
- Search ID
- Choose "Apply for Graduation/Completion " from drop down under Academics
- Seach ID again
- Graduation Application page will show up
Attachments:
image2020-7-10_10-57-35.png (image/png)
image2020-7-10_11-0-19.png (image/png)
image2020-7-10_11-5-49.png (image/png)
image2020-7-10_11-14-29.png (image/png)