HR_TP_LRNMAP_VW (SQL View)	Index Back
Talent Pool - ELM mapping used to retreive mapping of EE/Talent pool and programs. The data will be sent back into the ELM system to add program to plans of EEs in ELM

HR_TP_LRNMAP_VW

(SQL View)

Talent Pool - ELM mapping

used to retreive mapping of EE/Talent pool and programs. The data will be sent back into the ELM system to add program to plans of EEs in ELM

SELECT a.effdt ,b.emplid ,c.hr_lm_prg_id ,c.hr_lm_lrn_grp_id ,c.hr_tp_tgt_end_dt ,b.status FROM PS_HR_TPOOL a , PS_HR_TPOOL_mbr b , ps_hr_tp_learning c WHERE a.hr_tp_id = b.hr_tp_id AND a.effdt = b.effdt AND a.effdt = c.effdt AND a.hr_tp_id = c.hr_tp_id AND a.effdt = ( SELECT MAX(sub.effdt) FROM PS_HR_TPOOL sub WHERE sub.hr_tp_id = a.hr_tp_id AND sub.effdt <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE Effective Date
Default Value: %date

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 HR_LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID - via SOA from ELM

4 HR_LM_LRN_GRP_ID Number(15,0) DECIMAL(15) NOT NULL ELM Learner Group ID

5 HR_TP_TGT_END_DT Date(10) DATE Target End Date, Used on Talent Pool. Defines the requrested completion date for a training program assigend to a talent pool

6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	HR_LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID - via SOA from ELM
4	HR_LM_LRN_GRP_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Learner Group ID
5	HR_TP_TGT_END_DT	Date(10)	DATE	Target End Date, Used on Talent Pool. Defines the requrested completion date for a training program assigend to a talent pool
6	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive