LM_PRG_SEC_VW1(SQL View) |
Index Back |
|---|---|
Program ItemsProgram Items |
| SELECT A.LM_PRG_ID ,A.EFFDT ,A.LM_SCN_ID ,A.LM_OBJ_TYPE ,A.LM_OBJ_ID ,B.LM_ORDER ,A.LM_ORDER ,A.LM_HIST_CREDIT ,A.LM_REQ ,A.LM_HISTCREDIT_DAYS ,A.LM_ALLOW_WAIVER ,A.LM_ALLOW_EQUIV FROM PS_LM_PRG_ITEM A , PS_LM_PRG_SCN B WHERE A.LM_PRG_ID=B.LM_PRG_ID AND A.EFFDT=B.EFFDT AND A.LM_SCN_ID=B.LM_SCN_ID UNION SELECT DISTINCT A.LM_PRG_ID ,A.EFFDT ,A.LM_SCN_ID ,'10' ,0 ,B.LM_ORDER ,0 ,'N' ,'N' ,0 ,'N' ,'N' FROM PS_LM_PRG_ITEM A , PS_LM_PRG_SCN B WHERE A.LM_PRG_ID=B.LM_PRG_ID AND A.EFFDT=B.EFFDT AND A.LM_SCN_ID=B.LM_SCN_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 NOT NULL |
Effective Date
Default Value: LM_PRG_SCN.EFFDT |
| 3 | LM_SCN_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Section ID
Default Value: 0 |
| 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_ORDER_SEC | Number(4,0) | SMALLINT NOT NULL | Order of Completion |
| 7 | LM_ORDER | Number(4,0) | SMALLINT NOT NULL | Order of Completion |
| 8 | LM_HIST_CREDIT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Historical Credit
Y/N Table Edit Default Value: N |
| 9 | LM_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Item Required
Y/N Table Edit Default Value: N |
| 10 | LM_HISTCREDIT_DAYS | Number(5,0) | INTEGER NOT NULL | Historical Credit Days |
| 11 | 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 |
| 12 | LM_ALLOW_EQUIV | Character(1) | VARCHAR2(1) NOT NULL |
Allow Equivalency
Y/N Table Edit Default Value: N |