HR_LM_PRG_IDEFFDTDefault Value: %date
HR_LM_LRN_GRP_ID10=Active
20=Inactive
30=Pending
CE=Certification
CU=Curriculum
HR_TP_ELM_PRG(SQL Table) |
Index Back |
|---|---|
Program Table Interface to ELMInterface table to ELM programs. Stored on HR side to hold learning programs as defined by ELM with explicite learner group. Table is filled via IB FullSync Message from ELM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_LM_PRG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Program ID - via SOA from ELM |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | HR_LM_LRN_GRP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Learner Group ID |
| 4 | HR_LM_LRN_GRP | Character(30) | VARCHAR2(30) NOT NULL | from ELM Learner Group |
| 5 | HR_LM_END_EFFDT | Date(10) | DATE | End Date for Program - via SOA from ELM |
| 6 | HR_LM_PRG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
current Program Status. Via SOA from ELM
10=Active 20=Inactive 30=Pending |
| 7 | HR_LM_PRG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Program Type; via SOA from ELM
CE=Certification CU=Curriculum |
| 8 | HR_LM_PRG_CD | Character(30) | VARCHAR2(30) NOT NULL | Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure. Via SOA from ELM |
| 9 | HR_LM_VERSION | Character(30) | VARCHAR2(30) NOT NULL | Program Version; via SOA from ELM |
| 10 | HR_LM_PRG_LONG | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |
| 11 | HR_LM_PRG_SHORT | Character(10) | VARCHAR2(10) NOT NULL | Program Short Name |
| 12 | HR_LM_PRG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Program Description - via SOA from ELM |