OPRIDRUN_CNTL_ID0=All
Default Value: 0
Prompt Table: LM_UI_DMTH_VW
Prompt Table: LM_RTG_FCLTY_VW
Prompt Table: LM_UI_INSTR_VW1
Prompt Table: LM_LE_UI_VW
Prompt Table: LM_ALL_CD_VW
LM_RTG_SRCH_RCT(SQL Table) |
Index Back |
|---|---|
RCTL Rec for Review RatingsRCTL Rec for Review Ratings |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | HCSC_RTG_VALUES | Character(4) | VARCHAR2(4) NOT NULL |
Ratings Value
0=All Default Value: 0 |
| 4 | LM_ACTPRG_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Act/Program Type
Prompt Table: LM_UI_DMTH_VW |
| 5 | LM_FCLTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Facility ID
Prompt Table: LM_RTG_FCLTY_VW |
| 6 | LM_INSTR_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Instructor ID
Prompt Table: LM_UI_INSTR_VW1 |
| 7 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Prompt Table: LM_LE_UI_VW |
| 8 | LM_RTG_ACT_PRG_CD | Character(30) | VARCHAR2(30) NOT NULL |
Code
Prompt Table: LM_ALL_CD_VW |
| 9 | LM_RTG_FROM_DT | Date(10) | DATE | Ratings From |
| 10 | LM_RTG_FROM_TO | Date(10) | DATE | Ratings To |
| 11 | LM_RTG_LRNG_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Title |