LM_ACT_STS_VW

(SQL View)
Index Back

Activity Status View

Activity Status View

SELECT LM_ACT_ID , LM_ACT_STATUS FROM PS_LM_ACT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
2 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded

Default Value: 4