LM_SCHED_ENR_VW

(SQL View)
 Index Back

Learners Scheduled Time

View of Learners who are scheduled in learning.

SELECT A.LM_PERSON_ID , A.LM_ENRLMT_ID , B.LM_SES_ID , B.LM_SES_DT , B.LM_START_TM , B.LM_END_TM , B.TIMEZONE , C.LM_HR_EMPLID , C.LM_EMPL_RCD , A.LM_STTS , 'TRNG' , E.LM_CS_LONG_NM , B.LM_FCLTY , %subrec(ADDRESS_SBR,B) , D.LM_BAS_LC_TYPE , A.LM_ROW_MAINT_DTTM , A.LM_ROW_MAINT_OPRID , 'LELM' , %Dttm(B.LM_SES_DT , B.LM_START_TM) , %Dttm(B.LM_SES_DT , B.LM_END_TM) FROM PS_LM_ENRLMT_VW A , PS_LM_SESALL_FC_VW B , PS_LM_PER_SRC_VW C , PS_LM_LC_VW D , PS_LM_CI_SRCH E , PS_LM_SCHED_BAS_LC F WHERE B.LM_ACT_ID = A.LM_ACT_ID AND C.LM_PERSON_ID = A.LM_PERSON_ID AND D.LM_ACT_ID = A.LM_ACT_ID AND D.LM_LC_ID = B.LM_LC_ID AND D.LM_BAS_LC_TYPE = F.LM_BAS_LC_TYPE AND E.LM_CI_ID = A.LM_CI_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
2 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
3 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
4 LM_SES_DT Date(10) DATE Session Date
5 LM_START_TM Time(15) TIMESTAMP Start Time
6 LM_END_TM Time(15) TIMESTAMP End Time
7 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
8 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
9 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
10 LM_STTS Character(4) VARCHAR2(4) NOT NULL Enrollment Status
CANC=Dropped
COMP=Completed
DECL=Denied
ENRL=Enrolled
INCO=Not Completed
INPO=In-Progress
MACT=Moved to New Activity
NOTS=Not Started
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
RQST=Learning Request
WAIV=Waived
WTLT=Waitlisted
11 LM_EVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Event Type
TRNG=Training
TRNR=Trainer
12 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
13 LM_FCLTY Character(50) VARCHAR2(50) NOT NULL Facility Description
14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

15 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
16 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
17 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
18 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
19 CITY Character(30) VARCHAR2(30) NOT NULL City
20 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
21 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
22 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
23 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
24 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
25 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
26 COUNTY Character(30) VARCHAR2(30) NOT NULL County
27 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
29 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
30 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

31 LM_BAS_LC_TYPE Character(3) VARCHAR2(3) NOT NULL Base Learning Component Type
10=Web-based
20=Sessions
30=Webcast
40=Assignment
50=Test
60=Survey
32 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
33 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
34 LM_SOURCE_IND Character(4) VARCHAR2(4) NOT NULL Source Indicator
EXT=External
HR89=HRMS 89
HRMS=HRMS
LELM=Enterprise Learning
35 LM_START_DTTM DateTime(26) TIMESTAMP Start Time
36 LM_END_DTTM DateTime(26) TIMESTAMP End Time