HR_TP_IDEFFDTDefault Value: %date
HR_LM_PRG_IDPrompt Table: HR_LM_PRG_VW
HR_LM_LRN_GRP_IDPrompt Table: HR_LM_GRP_VW
A=Active
I=Inactive
HR_TP_LEARNING(SQL Table) |
Index Back |
|---|---|
Talent Pool LeanringLearning required for each employee attached to a talent pool |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_TP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Talent Pool ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | HR_LM_PRG_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Program ID - via SOA from ELM
Prompt Table: HR_LM_PRG_VW |
| 4 | HR_LM_LRN_GRP_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
ELM Learner Group ID
Prompt Table: HR_LM_GRP_VW |
| 5 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 6 | 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 |