PROCESS_INSTANCELM_RTG_RPT_VW(SQL View) |
Index Back |
|---|---|
View Rating Report ViewView Rating Report View |
| SELECT PROCESS_INSTANCE , LM_EP_RATING , LM_RTG_TOT_RATINGS , LM_RTG_LRNG_TITLE , LM_RTG_ACT_PRG_CD , LM_DM_LONG_NM , LM_NAME_DISPLAY , LM_FCLTY , LM_LE_LONG_NM FROM PS_LM_RTGRPT_STG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | LM_EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 3 | LM_RTG_TOT_RATINGS | Number(15,0) | DECIMAL(15) NOT NULL | Total Ratings |
| 4 | LM_RTG_LRNG_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Title |
| 5 | LM_RTG_ACT_PRG_CD | Character(30) | VARCHAR2(30) NOT NULL | Code |
| 6 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |
| 7 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 8 | LM_FCLTY | Character(50) | VARCHAR2(50) NOT NULL | Facility Description |
| 9 | LM_LE_LONG_NM | Character(60) | VARCHAR2(60) NOT NULL | Learning Environment Long Name |