INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
ADMIN_FUNCTIONPrompt Table: ADM_FUNCTN_TBL
INST_ADMFNC_SCH(SQL View) |
Index Back |
|---|---|
Comm Speed Key SearchINST_ADMFNC_SCH is used to find the valid Administrative Functions for an Institution within the COMM_SPDKEY_TBL. If a combination does not exist it can be added. |
| SELECT institution ,admin_function FROM PS_COMM_SPDKEY_TBL |
| # | 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 | ADMIN_FUNCTION |
Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: ADM_FUNCTN_TBL |