PY_IN_YE_CNS_TB (SQL Table)	Index Back
Insights YE Consent Insights YE Consent for Pre-processing

PY_IN_YE_CNS_TB

(SQL Table)

Insights YE Consent

Insights YE Consent for Pre-processing

Related Language Record: PY_IN_YE_CON_LN

# 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 PY_CONSENT_DESCR Character(254) VARCHAR2(254) NOT NULL Consent Status

4 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	PY_CONSENT_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Consent Status
4	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.