LM_SCHED_INS_VW

(SQL View)
 Index Back

Instructor Scheduled Time

View of Instructors who are scheduled to teach training.

SELECT DISTINCT(A.LM_INSTR_ID) , A.LM_SES_ID , A.LM_SES_DT , A.LM_START_TM , A.LM_END_TM , A.TIMEZONE , B.LM_HR_EMPLID , B.LM_EMPL_RCD , ' ' , 'TRNR' , D.LM_CS_LONG_NM , A.LM_FCLTY , %subrec(ADDRESS_SBR,A) , C.LM_BAS_LC_TYPE , A.LM_ROW_MAINT_DTTM , A.LM_ROW_MAINT_OPRID , 'LELM' , A.LM_ACT_STATUS , %Dttm(A.LM_SES_DT , A.LM_START_TM) , %Dttm(A.LM_SES_DT , A.LM_END_TM) FROM PS_LM_SES_IN_FC_VW A , PS_LM_PER_SRC_VW B , PS_LM_LC_VW C , PS_LM_CI_SRCH D , PS_LM_SCHED_BAS_LC E WHERE B.LM_PERSON_ID = A.LM_INSTR_ID AND C.LM_ACT_ID = A.LM_ACT_ID AND C.LM_BAS_LC_TYPE = E.LM_BAS_LC_TYPE AND D.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_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
3 LM_SES_DT Date(10) DATE Session Date
4 LM_START_TM Time(15) TIMESTAMP Start Time
5 LM_END_TM Time(15) TIMESTAMP End Time
6 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
7 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
8 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
9 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
10 LM_EVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Event Type
TRNG=Training
TRNR=Trainer
11 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
12 LM_FCLTY Character(50) VARCHAR2(50) NOT NULL Facility Description
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

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

Prompt Table: STATE_TBL

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

Y/N Table Edit

30 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
31 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
32 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
33 LM_SOURCE_IND Character(4) VARCHAR2(4) NOT NULL Source Indicator
EXT=External
HR89=HRMS 89
HRMS=HRMS
LELM=Enterprise Learning
34 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded
35 LM_START_DTTM DateTime(26) TIMESTAMP Start Time
36 LM_END_DTTM DateTime(26) TIMESTAMP End Time