TL_ACTIONS_I_VW

(SQL View)
 Index Back

Time Admin Actions View-Insert

Time Admin View of Insert Actions.

SELECT ACTION_ID , TL_ACTION_TYPE FROM PS_TL_ACTIONS WHERE TL_ACTION_TYPE = '1'

# 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