LM_LPLN_IDLM_PERSON_IDA=Active
C=Complete
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: N
LM_LPLN_CUR_VW(SQL View) |
Index Back |
|---|---|
Current Learning PlanCurrent Learning Plan |
| SELECT LRN.LM_LPLN_ID , LRN.LM_PERSON_ID , 0 , PLN.LM_LPLN_NAME , LRN.LM_LPLN_STATUS , LRN.LM_LPLN_DEFAULT , LRN.LM_COMPL_DATE , LRN.LM_ASSIGNED_BY , PLN.LM_LPLN_CREATED_BY , PLN.LM_LPLN_CREATED_DT FROM PS_LM_LPLN PLN , PS_LM_LPLN_LRN LRN WHERE PLN.LM_LPLN_ID = LRN.LM_LPLN_ID AND LRN.LM_LPLN_STATUS <> 'C' |
| # | 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_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_MANAGER_ID | Number(15,0) | DECIMAL(15) NOT NULL | Manager ID |
| 4 | LM_LPLN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Learning Plan Code or Title |
| 5 | LM_LPLN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Learning Plan Status
A=Active C=Complete I=Inactive Default Value: A |
| 6 | LM_LPLN_DEFAULT | Character(1) | VARCHAR2(1) NOT NULL |
Learning Plan Default
Y/N Table Edit Default Value: N |
| 7 | LM_COMPL_DATE | Date(10) | DATE | Learning Plan Completion Date |
| 8 | LM_ASSIGNED_BY | Number(15,0) | DECIMAL(15) NOT NULL | Assigned By |
| 9 | LM_LPLN_CREATED_BY | Number(15,0) | DECIMAL(15) NOT NULL | Assigned By |
| 10 | LM_LPLN_CREATED_DT | Date(10) | DATE | Learning Plan Creation Date |