PY_IN_YE_CN_DEL (SQL Table)	Index Back
Insights YE Consent Delete Insights YE Consent delete record for incremental processing

PY_IN_YE_CN_DEL

(SQL Table)

Insights YE Consent Delete

Insights YE Consent delete record for incremental processing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 YE_CONSENT_CURRENT Character(1) VARCHAR2(1) NOT NULL View Year-End Form Self-Service. This field will store the employees consent actions.
C=Consent Received
N=No Consent Received
R=Consent Reset by Employer
W=Consent Withdrawn

3 LASTUPDDTTM 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	YE_CONSENT_CURRENT	Character(1)	VARCHAR2(1) NOT NULL	View Year-End Form Self-Service. This field will store the employees consent actions. C=Consent Received N=No Consent Received R=Consent Reset by Employer W=Consent Withdrawn
3	LASTUPDDTTM	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.