LM_TPLN_LRQ_VW

(SQL View)
 Index Back

Training plan enrollment

Training plan enrollment view

SELECT A.LM_LRQ_ID , A.LM_ACT_ID , A.lM_FROM_DT , A.LM_TO_DT , A.LM_CI_ID , A.LM_ORGANIZATION_ID , A.LM_LE_ID , A.LM_HR_COMPANY , %DatePart(A.LM_ROW_ADDED_DTTM) , A.LM_LRQ_STATUS , A.LM_ISELIG_TRN_RPT , A.LM_TITLE , A.LM_OBJV_ID , A.LM_SEAT_REQ , A.LM_FLAT_COST , A.CURRENCY_CD , A.LM_ESTIMATED_HOURS FROM PS_LM_LRN_REQ 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_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
3 LM_START_DT Date(10) DATE Start Date
4 LM_END_DT Date(10) DATE End Date
5 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
6 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
7 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
8 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.
9 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
10 LM_LRQ_STATUS Character(1) VARCHAR2(1) NOT NULL New Field. Uppercase. Stores current status of learning request.
1=Requested
2=Inactive
3=Offered
11 LM_ISELIG_TRN_RPT Character(1) VARCHAR2(1) NOT NULL Is eligible for training plan report
12 LM_TITLE Character(30) VARCHAR2(30) NOT NULL Field to store title of an object
13 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
14 LM_SEAT_REQ Number(10,0) DECIMAL(10) NOT NULL Number of Seat Request
15 LM_FLAT_COST Number(19,3) DECIMAL(18,3) NOT NULL Flat cost
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 LM_ESTIMATED_HOURS Number(3,0) SMALLINT NOT NULL Estimated Hours