TRNSFR_EQ_PRMT(SQL View) |
Index Back |
|---|---|
Transfer Equiv Prompt |
| select a.INSTITUTION , a.ACAD_PROG , a.ACAD_PLAN , a.TRNSFR_SRC_ID , a.TRNSFR_SRC_ID , a.EFFDT , a.EFF_STATUS , a.TRNSFR_SRC_ID , a.DESCR from PS_EXT_TRNSFR_EQ 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 | ACAD_PROG |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Program
Default Value: OPR_DEF_TBL_CS.ACAD_PROG Prompt Table: ACAD_PROG_TBL |
| 3 | ACAD_PLAN |
Character(10) | VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table: ACAD_PLAN_TBLVW |
| 4 | INSTITUTION_SRC |
Character(11) | VARCHAR2(11) NOT NULL |
Source Institution
Prompt Table: INSTITUTION_TBL |
| 5 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 6 | EFFDT |
Date(10) | DATE | Effective Date |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 8 | TRNSFR_SRC_ID |
Character(11) | VARCHAR2(11) NOT NULL | Source ID |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |