HCSC_RTG_CDHCSC_RTG_SEQ_NBRLM_ACT_IDLM_PRG_IDA=All
N=No
Y=Yes
Default Value: N
A=All
H=Hidden
U=Unhidden
Default Value: U
LM_RTG_LRN_XREF(SQL Table) |
Index Back |
|---|---|
Ratings for Learning ItemsUse this for ratings and reviews for learning items. The ratings for activities and programs are stored on this table. Moreover, the catalog item ID for the activity ID is tracked. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_RTG_CD |
Character(30) | VARCHAR2(30) NOT NULL | Ratings Identification |
| 2 | HCSC_RTG_SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Ratings Sequence Number |
| 3 | HCSC_RTG_COMMENTS | Long Character | CLOB | Ratings Comments |
| 4 | HCSC_RTG_RATING | Number(3,0) | SMALLINT NOT NULL | Ratings value |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | HCSC_RTG_DATE_STMP | DateTime(26) | TIMESTAMP | Date Stamped |
| 7 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 8 | LM_PRG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
| 9 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 10 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 11 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 12 | LM_RTG_FLG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Ratings and Reviews Flag ID |
| 13 | LM_RTG_REVW_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Reviewed
A=All N=No Y=Yes Default Value: N |
| 14 | LM_RTG_HIDDEN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Hidden Flag
A=All H=Hidden U=Unhidden Default Value: U |