PY_SS_USA1_VW(SQL View) |
Index Back |
|---|---|
Year-End Forms for SSThis view will select year-end forms from guide table that meet the settings in Year-End Form Options page. |
| SELECT %subrec(PY_SS_USA_SBR, A) FROM PS_PY_SS_USA_GDE A , PS_PY_YEOPT_CO_USA B WHERE A.YE_FORM_VIEWING_DT <= %CurrentDateIn AND A.W2_REPORTING_CO = B.W2_REPORTING_CO AND A.PY_TAX_YEAR = B.PY_TAX_YEAR AND A.TAXFORM_ID IN ('I','J','M','N','P','Q','S','U','X','W') AND A.PY_W2_FINAL_PRINT = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | PY_TAX_YEAR |
Number(4,0) | SMALLINT NOT NULL | Represents the year for personal income tax purposes. |
| 3 | W2_REPORTING_CO |
Character(3) | VARCHAR2(3) NOT NULL | W-2 Reporting Company |
| 4 | TAXFORM_ID |
Character(1) | VARCHAR2(1) NOT NULL |
Tax Form Identification
A=T4A Slip B=Business Payrolls Survey - CAN C=WCB Assessable Earnings E=Record of Employment F=940 - Annual Employer's FUTA I=W-2VI J=W-2cVI M=W-2GU N=W-2cGU P=W-2PR Q=W-2cPR R=RL-1 Slip S=W-2AS T=T4 Slip U=W-2cAS V=RL-2 Slip W=W-2 X=W-2c |
| 5 | SEQUENCE_NUMBER |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | W2C_BATCH_NBR |
Number(4,0) | SMALLINT NOT NULL | W-2c Batch Number |
| 7 | W2C_BATCH_YR |
Number(4,0) | SMALLINT NOT NULL | W-2c Batch Year |
| 8 | PY_YE_FORM_SEQNUM |
Number(2,0) | SMALLINT NOT NULL | A sequential number to indicate the number of W2/W-2c that have been issued/generated for an employee. Initial copy will have a value of 1. Used in Self Service Year-End Forms. |
| 9 | PY_W2_PROCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Year End using XML Publisher: Identifies type of process.
1=Original 2=Corrected 3=Reissued Statement 4=No Specific Reason |
| 10 | YE_FORM_ISSUE_DT | Date(10) | DATE | This field is used in Payroll for North America Self Service Year-End Forms. It stores the date when the forms were generated. |
| 11 | YE_FORM_VIEWING_DT | Date(10) | DATE | This field is used in Payroll for North America Self Service Year-End Forms. It stores the date that determines when the forms become viewable in Self Service. |
| 12 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 13 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 14 | PY_YE_FILEURLID | Character(30) | VARCHAR2(30) NOT NULL | URL ID used to store and retrieve year-end pdf forms. |
| 15 | PY_YE_REPORT_URL | Character(254) | VARCHAR2(254) NOT NULL | Report URL |
| 16 | PY_YE_BURST_ID | Character(40) | VARCHAR2(40) NOT NULL | Stores the value used for bursting a PDF file into separate employee-level files. |
| 17 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 18 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 19 | BURST_FIELDNAME | Character(30) | VARCHAR2(30) NOT NULL | Burst Field Name |
| 20 | PY_YE_NOTIFY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether notification of availability for viewing a year-end form has been sent to employee.
Y - notification already sent to employee
N - notification not yet sent to employee
Y/N Table Edit Default Value: N |
| 21 | PY_W2_FINAL_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Identifies whether final run or not.
Y/N Table Edit |