PY_YEO_CO_1099R(SQL Table) |
Index Back |
---|---|
Year-End Form 1099R Comp OptYear-End Form Options for 1099R Company. |
# | 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.
Prompt Table: PY_TAXYR_USA_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 | 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 |