PROCESS_INSTANCEDefault Value: %date
HCSC_RTG_2_AET(SQL Table) |
Index Back |
|---|---|
Ratings Test State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | HCSC_RTG_CD | Character(30) | VARCHAR2(30) NOT NULL | Ratings Identification |
| 5 | HCSC_RTG_COUNT | Number(15,0) | DECIMAL(15) NOT NULL | Total Count |
| 6 | HCSC_RTG_RATING | Number(3,0) | SMALLINT NOT NULL | Ratings value |
| 7 | HCSC_RTG_REC_XREF | Character(15) | VARCHAR2(15) NOT NULL | Cross Reference Table |
| 8 | HCSC_RTG_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Ratings Sequence Number |
| 9 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 10 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 11 | LM_LC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
| 12 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 13 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |