INSTITUTIONPrompt Table: INSTITUTION_TBL
SAD_UC_ACTION_REQA=Applicant
I=Institution
N=None
SAD_UC_OUTCOME_CDSAD_UC_CMCDVW(SQL View) |
Index Back |
|---|---|
prompt for outcome codes |
| SELECT INSTITUTION , SAD_UC_ACTION_REQ , SAD_UC_OUTCOME_CD , SAD_UC_DESCR100 FROM %Table(SAD_UC_OUTCMCDS) WHERE SAD_UC_UCAS='Y' AND SAD_UC_CNFRM='Y' AND SAD_UC_ACTIVE_IND='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | SAD_UC_ACTION_REQ |
Character(1) | VARCHAR2(1) NOT NULL |
Action Required
A=Applicant I=Institution N=None |
| 3 | SAD_UC_OUTCOME_CD |
Character(10) | VARCHAR2(10) NOT NULL | Outcome Code |
| 4 | SAD_UC_DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Description |