PYCYCL_DEACT (SQL View)	Index Back
Deactivate Pay Cycles

PYCYCL_DEACT

(SQL View)

Deactivate Pay Cycles

SELECT a.pay_cycle , a.active_flag ,a.oprid_last_updt ,a.last_update_dttm FROM PS_PYCYCL a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

2 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

3 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

4 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
2	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive
3	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
4	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.