TL_ACTIONS_D_VW

(SQL View)
 Index Back

Time Admin Actions View-Delete

Time Administration View of Delete Actions.

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

# 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