TL_ACTIONS_U_VW(SQL View) |
Index Back |
---|---|
Time Admin Actions View-UpdateTime Admin View of Update Actions. |
SELECT ACTION_ID , TL_ACTION_TYPE FROM PS_TL_ACTIONS WHERE TL_ACTION_TYPE = '2' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ACTION_ID | Character(12) | VARCHAR2(12) NOT NULL | Action ID |
2 | TL_ACTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Type
0=Delete 1=Insert 2=Update |