LM_ACT_STS_VW(SQL View) |
Index Back |
---|---|
Activity Status ViewActivity 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 |