LM_S4_ACT_IDLM_S4_ACTRES_VW(SQL View) |
Index Back |
|---|---|
ActivityActivity |
| SELECT c.lm_s4_act_id , c.lm_s4_org_id , c.lm_s4_title , d.lm_s4_href , c.lm_s4_parameters FROM PS_LM_S4_ACTIVITY c , ps_lm_s4_actrrs_vw d WHERE c.lm_s4_act_id = d.lm_s4_act_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_ORG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Content Organization Id |
| 3 | LM_S4_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Title |
| 4 | LM_S4_HREF | Long Character(2000) | VARCHAR2(2000) | href URL |
| 5 | LM_S4_PARAMETERS | Long Character(1000) | VARCHAR2(1000) | SCORM Resource Parameters |