LM_LPLN_IDY/N Table Edit
Default Value: N
LM_LPLN_SEL_2VW(SQL View) |
Index Back |
|---|---|
Selected Learning Plans 2This view will be used by learners, managers or administrators. This view excludes the default learning plans. In addition, exclude non-default learning plans that are owned by the learners. |
| SELECT P1.LM_LPLN_ID , 'N' , P1.LM_LPLN_NAME , P1.LM_LPLN_CREATED_BY FROM PS_LM_LPLN P1 WHERE NOT EXISTS ( SELECT 1 FROM PS_LM_LPLN_LRN L1 WHERE L1.LM_LPLN_ID = P1.LM_LPLN_ID) UNION SELECT P2.LM_LPLN_ID , 'N' , P2.LM_LPLN_NAME , P2.LM_LPLN_CREATED_BY FROM PS_LM_LPLN P2 WHERE NOT EXISTS ( SELECT 1 FROM PS_LM_LPLN_LRN L2 WHERE L2.LM_LPLN_ID = P2.LM_LPLN_ID AND L2.LM_LPLN_DEFAULT = 'Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_LPLN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Learning Plan ID |
| 2 | LM_LPLN_DEFAULT | Character(1) | VARCHAR2(1) NOT NULL |
Learning Plan Default
Y/N Table Edit Default Value: N |
| 3 | LM_LPLN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Learning Plan Code or Title |
| 4 | LM_LPLN_CREATED_BY | Number(15,0) | DECIMAL(15) NOT NULL | Assigned By |