LM_LELW_TSTE_VW (SQL View)	Index Back
Webcast-Vendor XSLT Table

LM_LELW_TSTE_VW

(SQL View)

Webcast-Vendor XSLT Table

SELECT LM_LELW_VNDR_ID , LM_LELW_XSLT_TYP FROM PS_LM_LELW_XSLT WHERE LM_LELW_XSLT_TYP='100' OR LM_LELW_XSLT_TYP='110' OR LM_LELW_XSLT_TYP='120'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_LELW_VNDR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID

2 LM_LELW_XSLT_TYP Character(3) VARCHAR2(3) NOT NULL XSLT Type
10=Add User
100=Enroll
101=enrollResponse
11=addUserResponse
110=Unenroll
111=unenrollResponse
120=Get Grades
121=getGradesResponse
130=Build URL
20=Edit User
21=editUserResponse
30=Remove User
31=removeUserResponse
40=Create Session
41=createSessionResponse
50=Edit Session
51=editSessionResponse
60=Remove Session
61=removeSessionResponse
70=Get Host URL
71=getHostURLResponse
80=Get Learner URL
81=getLearnerURLResponse
90=Get Recorded URL
91=GetRecordedURLResponse

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LELW_VNDR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Vendor ID
2	LM_LELW_XSLT_TYP	Character(3)	VARCHAR2(3) NOT NULL	XSLT Type 10=Add User 100=Enroll 101=enrollResponse 11=addUserResponse 110=Unenroll 111=unenrollResponse 120=Get Grades 121=getGradesResponse 130=Build URL 20=Edit User 21=editUserResponse 30=Remove User 31=removeUserResponse 40=Create Session 41=createSessionResponse 50=Edit Session 51=editSessionResponse 60=Remove Session 61=removeSessionResponse 70=Get Host URL 71=getHostURLResponse 80=Get Learner URL 81=getLearnerURLResponse 90=Get Recorded URL 91=GetRecordedURLResponse