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 | W2_REPORTING_CO | Character(3) | VARCHAR2(3) NOT NULL |
W-2 Reporting Company
Default Value: W2_COMPANY_VW.COMPANY Prompt Table: W2_COMPANY_VW |
2 | PY_TAX_YEAR | 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 |