INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
ENRL_ACTION_REASONSSR_HE_DRSN_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID , A.ENRL_ACTION_REASON , A.DESCR FROM PS_ENRL_RSN_TBL A WHERE A.ENRL_ACTION='D' AND A.ACAD_CAREER = ( SELECT MIN(A2.ACAD_CAREER) FROM PS_ENRL_RSN_TBL A2 WHERE A2.SETID =A.SETID AND A2.ENRL_ACTION =A.ENRL_ACTION AND A2.ENRL_ACTION_REASON=A.ENRL_ACTION_REASON) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | ENRL_ACTION_REASON |
Character(4) | VARCHAR2(4) NOT NULL | Enrollment Action Reason |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |