LM_ACT_ROUTE_VW(SQL View) |
Index Back |
|---|---|
Activity Routes ViewView for Activity routes |
| SELECT LM_ACT_ID , LM_ROUTE_ID , LM_LC_ID , LM_COMP_SEQ_ID , LM_REQD_FLAG FROM PS_LM_ACT_ROUTES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 2 | LM_ROUTE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Route ID - Blended Learning |
| 3 | LM_LC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
| 4 | LM_COMP_SEQ_ID | Number(3,0) | SMALLINT NOT NULL | Learning Component sequence - Blended Learning |
| 5 | LM_REQD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Learning Component required? - Blended Learning |