LM_LRQ_IDLM_PERSON_IDPrompt Table: LM_PERS_ADTL_VW
1=Active
2=Deleted
Prompt Table: LM_TRAIN_CLASS
LM_LRQ_LRNR_VW(SQL View) |
Index Back |
|---|---|
Learning Request Learner's TBLLearning Request Learner's view |
| SELECT A.LM_LRQ_ID , A.LM_PERSON_ID , A.LM_LRQ_LRNR_STTS , A.LM_TRAINING_CLASS FROM PS_LM_LRN_REQ_LNR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_LRQ_ID |
Number(10,0) | DECIMAL(10) NOT NULL | New field for ELM 9.0, stores unique identifier for a single learning request. |
| 2 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
ELM Person ID
Prompt Table: LM_PERS_ADTL_VW |
| 3 | LM_LRQ_LRNR_STTS | Character(1) | VARCHAR2(1) NOT NULL |
Learner's status in the learning request
'1' Active
'2' Deleted
1=Active 2=Deleted |
| 4 | LM_TRAINING_CLASS | Character(10) | VARCHAR2(10) NOT NULL |
Training Class
Prompt Table: LM_TRAIN_CLASS |