INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
TRNSFR_SCH_TYPEE=External Organization
I=Institution
Default Value: E
TRNSFR_SRC_IDPrompt Table: %EDITTABLE6
TRNSFR_EQVLNCYTRNSFR_APRMT(SQL View) |
Index Back |
|---|---|
Ext Trnsfr Equiv Add PromtThis view is used as a prompt for Transfer Credit Rules. |
| SELECT a.INSTITUTION , 'X' , a.TRNSFR_SRC_ID , a.TRNSFR_EQVLNCY FROM PS_TRNSFR_RULE a |
| # | 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 | TRNSFR_SCH_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Credit Source Type
E=External Organization I=Institution Default Value: E |
| 3 | TRNSFR_SRC_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Source ID
Prompt Table: %EDITTABLE6 |
| 4 | TRNSFR_EQVLNCY |
Character(6) | VARCHAR2(6) NOT NULL | Equivalency Rule |