PY_YEOPT_CO_CAN (SQL Table)	Index Back
Year-End Form Company Options Year-End Form Options by Company and Taxform ID.

PY_YEOPT_CO_CAN

(SQL Table)

Year-End Form Company Options

Year-End Form Options by Company and Taxform ID.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 PY_TAX_YEAR Number(4,0) SMALLINT NOT NULL Represents the year for personal income tax purposes.
Prompt Table: PY_TAXYR_CAN_VW

3 PY_YE_ONLINE_OPT Character(1) VARCHAR2(1) NOT NULL Enable Electronic Year-End Form in Self Service (Y/N). This option indicates whether or not the employees are able to view their year-end forms from the Self-Service.
Y/N Table Edit
Default Value: N

4 PY_RL_ONLINE_OPT Character(1) VARCHAR2(1) NOT NULL Enable Electronic Year-End RL Slip in Self Service (Y/N). This option indicates whether or not the employees are able to view their year-end RL-1 forms from the Self-Service.
Y/N Table Edit
Default Value: N

5 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

6 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.
Default Value: %datetime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes. Prompt Table: PY_TAXYR_CAN_VW
3	PY_YE_ONLINE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Enable Electronic Year-End Form in Self Service (Y/N). This option indicates whether or not the employees are able to view their year-end forms from the Self-Service. Y/N Table Edit Default Value: N
4	PY_RL_ONLINE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Enable Electronic Year-End RL Slip in Self Service (Y/N). This option indicates whether or not the employees are able to view their year-end RL-1 forms from the Self-Service. Y/N Table Edit Default Value: N
5	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	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. Default Value: %datetime