LM_CALBAT_VW (SQL View)	Index Back
Calendar Batch View Calendar batch record view.

LM_CALBAT_VW

(SQL View)

Calendar Batch View

Calendar batch record view.

SELECT BT.LM_PERSON_ID , BT.LM_ENRLMT_ID , BT.LM_ACT_ID , BT.LM_LC_ID , BT.LM_SES_ID , BT.HRS_VENDOR_ID , BT.LM_CAL_ACTION , BT.LM_CAL_STTS , NM.LM_NAME_DISPLAY , VN.HRS_VENDOR_LNAME , AC.LM_ACT_CD , AC.LM_ACT_OWNER_ID , AC.LM_ENRLMT_ADMIN_ID FROM PS_LM_CALENDAR_BAT BT , PS_LM_PERS_NAME_VW NM , PS_HRS_VENDOR VN , PS_LM_ACT AC WHERE BT.LM_PERSON_ID = NM.LM_PERSON_ID AND BT.HRS_VENDOR_ID = VN.HRS_VENDOR_ID AND BT.LM_ACT_ID = AC.LM_ACT_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_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

4 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning

5 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID

6 HRS_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Integration Vendor ID

7 LM_CAL_ACTION Character(3) VARCHAR2(3) NOT NULL Calendaring Action: ADD - "Create" DEL - "Delete"
ADD=Create Calendar
DEL=Delete Calendar
UPD=Update Calendar

8 LM_CAL_STTS Character(3) VARCHAR2(3) NOT NULL Calendaring Status: "ERR" - Error "PEN" - Pending "IGN" - Ignore
ERR=Error
IGN=Ignore
PEN=Pending

9 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field

10 HRS_VENDOR_LNAME Character(30) VARCHAR2(30) NOT NULL Integration Vendor Long Name

11 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code

12 LM_ACT_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Activity Owner

13 LM_ENRLMT_ADMIN_ID Number(15,0) DECIMAL(15) NOT NULL Enrollment Administrator 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_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
4	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
5	LM_SES_ID	Number(10,0)	DECIMAL(10) NOT NULL	Session ID
6	HRS_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Integration Vendor ID
7	LM_CAL_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Calendaring Action: ADD - "Create" DEL - "Delete" ADD=Create Calendar DEL=Delete Calendar UPD=Update Calendar
8	LM_CAL_STTS	Character(3)	VARCHAR2(3) NOT NULL	Calendaring Status: "ERR" - Error "PEN" - Pending "IGN" - Ignore ERR=Error IGN=Ignore PEN=Pending
9	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
10	HRS_VENDOR_LNAME	Character(30)	VARCHAR2(30) NOT NULL	Integration Vendor Long Name
11	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code
12	LM_ACT_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Activity Owner
13	LM_ENRLMT_ADMIN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Enrollment Administrator ID