LM_S4_ACT_IDLM_S4_SH_DATA_IDLM_S4_ACT_SHD_V(SQL View) |
Index Back |
|---|
| SELECT a.LM_S4_ACT_ID , a.LM_S4_SH_DATA_ID , b.LM_S4_NAME , a.LM_S4_SHD_READ , a.LM_S4_SHD_WRITE FROM PS_LM_S4_ACT_SHD a , PS_LM_S4_SH_DATA b WHERE a.LM_S4_SH_DATA_ID = b.LM_S4_SH_DATA_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_S4_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | SCORM 2004 Activity Id |
| 2 | LM_S4_SH_DATA_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Shared Data Definition Id |
| 3 | LM_S4_NAME | Character(254) | VARCHAR2(254) NOT NULL | SCORM identifier string |
| 4 | LM_S4_SHD_READ | Character(1) | VARCHAR2(1) NOT NULL | Shared Data Read flag |
| 5 | LM_S4_SHD_WRITE | Character(1) | VARCHAR2(1) NOT NULL | Shared Data Write flag |