PY_YEOPT_CO_USA(SQL Table) | 
Index Back | 
|---|---|
Year-End Form Company OptionsYear-End Form Options by Company and Taxform ID. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL | 
W-2 Reporting Company
 Default Value: W2_COMPANY_VW.COMPANY Prompt Table: W2_COMPANY_VW  | 
|
| 2 | Number(4,0) | SMALLINT NOT NULL | Represents the year for personal income tax purposes. | |
| 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 | 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. | 
| 5 | 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  |