HCSC_RTG_CDHCSC_RTG_SEQ_NBRLM_ACT_IDHCSC_RTG_TSTXRF(SQL Table) |
Index Back |
|---|---|
Ratings Sample XREF TableThis is a test sample cross reference table. It can be deleted and recreated at anytime. To populate this table, use the application engine program HCSC_RTG_TST. This table is used for testing only. |
| # | 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_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 9 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 10 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 11 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |