LM_DM_ACT_VW (SQL View)	Index Back
A listing of Activities by DM A listing of Activities by DM

LM_DM_ACT_VW

(SQL View)

A listing of Activities by DM

SELECT A.LM_DMTHD_ID , C.LM_ACT_ID , C.LM_ACT_CD , C.LM_ACT_STATUS FROM PS_LM_DMTHD_TBL A , PS_LM_ACT_VW C WHERE A.LM_DMTHD_ID=C.LM_DMTHD_ID AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_DMTHD_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method

2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

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

4 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_DMTHD_ID	Number(10,0)	DECIMAL(10) NOT NULL	Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method
2	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
3	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code
4	LM_ACT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status 1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded