LM_PRG_ACT_VW(SQL View) |
Index Back |
|---|---|
Program Items ViewProgram Items View |
| SELECT A.LM_PRG_ID , A.EFFDT , A.LM_SCN_ID , A.LM_OBJ_TYPE , A.LM_OBJ_ID , ACT.LM_ACT_ID , ACT.LM_ACT_CD , A.LM_ORDER , A.LM_REQ , A.LM_HIST_CREDIT , A.LM_HISTCREDIT_DAYS , A.LM_ALLOW_WAIVER , A.LM_AUDIENCE , A.LM_WAITING_PD , A.LM_ALLOW_EQUIV , ACT.LM_ACT_STATUS , ACT.LM_CI_ID , ACT.LM_CS_LONG_NM , ACT.LM_CS_DESCR , ACT.LM_DM_LONG_NM , ACT.LM_START_DT , ACT.LM_LST_ENRL_DT , ACT.LM_DISP_DATES , ACT.LM_END_DT , %subrec(LM_PRICING_SBR, ACT) FROM PS_LM_PRG_ITEM A , PS_LM_ACT_CI_UI_VW ACT WHERE ACT.LM_CI_ID = A.LM_OBJ_ID UNION SELECT A.LM_PRG_ID , A.EFFDT , A.LM_SCN_ID , A.LM_OBJ_TYPE , A.LM_OBJ_ID , ACT.LM_ACT_ID , ACT.LM_ACT_CD , A.LM_ORDER , A.LM_REQ , A.LM_HIST_CREDIT , A.LM_HISTCREDIT_DAYS , A.LM_ALLOW_WAIVER , A.LM_AUDIENCE , A.LM_WAITING_PD , A.LM_ALLOW_EQUIV , ACT.LM_ACT_STATUS , ACT.LM_CI_ID , ACT.LM_CS_LONG_NM , ACT.LM_CS_DESCR , ACT.LM_DM_LONG_NM , ACT.LM_START_DT , ACT.LM_LST_ENRL_DT , ACT.LM_DISP_DATES , ACT.LM_END_DT , %subrec(LM_PRICING_SBR, ACT) FROM PS_LM_PRG_ITEM A , PS_LM_ACTCI_CLS_VW ACT WHERE ACT.LM_CI_ID = A.LM_OBJ_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_PRG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: LM_PRG_SCN.EFFDT |
| 3 | LM_SCN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Section ID |
| 4 | LM_OBJ_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Object Type
10=Catalog Item 20=Activity 30=Program Default Value: 10 |
| 5 | LM_OBJ_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.
Prompt Table: %EDITTABLE |
| 6 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 7 | LM_ACT_CD | Character(30) | VARCHAR2(30) NOT NULL | Activity Code |
| 8 | LM_ORDER | Number(4,0) | SMALLINT NOT NULL | Order of Completion |
| 9 | LM_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Item Required
Y/N Table Edit Default Value: N |
| 10 | LM_HIST_CREDIT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Historical Credit
Y/N Table Edit Default Value: N |
| 11 | LM_HISTCREDIT_DAYS | Number(5,0) | INTEGER NOT NULL | Historical Credit Days |
| 12 | LM_ALLOW_WAIVER | Character(1) | VARCHAR2(1) NOT NULL |
Allow Waiver Credit is a flag to determine whether learners can get ad-hoc credit for any items in a program.
Y/N Table Edit Default Value: N |
| 13 | LM_AUDIENCE | Character(2) | VARCHAR2(2) NOT NULL |
Audience
10=Learner 20=Instructor 30=Manager |
| 14 | LM_WAITING_PD | Number(3,0) | SMALLINT NOT NULL | Waiting Period |
| 15 | LM_ALLOW_EQUIV | Character(1) | VARCHAR2(1) NOT NULL | Allow Equivalency |
| 16 | LM_ACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded |
| 17 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 18 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 19 | LM_CS_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Description - Describes an object with further detail |
| 20 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |
| 21 | LM_START_DT | Date(10) | DATE | Start Date |
| 22 | LM_LST_ENRL_DT | Date(10) | DATE | Last Enroll Date |
| 23 | LM_DISP_DATES | Character(1) | VARCHAR2(1) NOT NULL | Use Display Dates |
| 24 | LM_END_DT | Date(10) | DATE | End Date |
| 25 | LM_INT_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | Internal Learner - Price |
| 26 | LM_EXT_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | External Learner - Price |
| 27 | LM_TRNG_UT | Number(14,3) | DECIMAL(13,3) NOT NULL | Training Units - Price |
| 28 | LM_INT_DP_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | Internal Learner - Drop Price |
| 29 | LM_EXT_DP_PRICE | Number(19,3) | DECIMAL(18,3) NOT NULL | External Learner - Drop Price |
| 30 | LM_DP_TRNG_UT | Number(14,3) | DECIMAL(13,3) NOT NULL | Drop Training Units |
| 31 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |