INSTITUTIONPrompt Table: INSTITUTION_VW
SSR_RI_EUN_COD_NLDA=Active
I=Inactive
SSR_RI_EDUNTVNL(SQL View) |
Index Back |
|---|---|
Edu Unit View |
| SELECT INSTITUTION ,SSR_RI_EUN_COD_NLD ,EFF_STATUS ,DESCR ,DESCR200 FROM %Table(SSR_RI_EDUNT_NL) A WHERE %EFFDTCHECK(SSR_RI_EDUNT_NL A_ED, A, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_VW |
| 2 | SSR_RI_EUN_COD_NLD |
Character(12) | VARCHAR2(12) NOT NULL | RIO STAP Educational Unit Code |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR200 | Character(254) | VARCHAR2(254) NOT NULL | Long Description |