HR_LM_PRG_IDHR_LM_LRN_GRP_IDCE=Certification
CU=Curriculum
HR_TP_ELMPRG_VW(SQL View) |
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 |
| SELECT HR_LM_PRG_ID ,HR_LM_LRN_GRP_ID ,HR_LM_END_EFFDT ,HR_LM_PRG_CD ,HR_LM_PRG_TYPE ,HR_LM_PRG_SHORT ,HR_LM_PRG_LONG FROM PS_HR_TP_ELM_PRG WHERE HR_LM_PRG_STATUS = 'A' AND EFFDT = ( SELECT MAX(sub.effdt) FROM PS_HR_TP_ELM_PRG sub WHERE sub.effdt <= %CurrentDateIn) |
| # | 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 | HR_LM_LRN_GRP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Learner Group ID |
| 3 | HR_LM_END_EFFDT | Date(10) | DATE | End Date for Program - via SOA from ELM |
| 4 | 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 |
| 5 | HR_LM_PRG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Program Type; via SOA from ELM
CE=Certification CU=Curriculum |
| 6 | HR_LM_PRG_SHORT | Character(10) | VARCHAR2(10) NOT NULL | Program Short Name |
| 7 | HR_LM_PRG_LONG | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |