YE_DATA_VW

(SQL View)
 Index Back

W-2 Data View

Thsi view is used for on-line display of employee W-2 data.

SELECT A.W2_REPORTING_CO ,B.EMPLID ,B.CALENDAR_YEAR ,B.TAXFORM_ID ,B.SEQUENCE_NUMBER ,B.SSN ,B.YE_FNAME ,B.YE_MIDDLE_NAME ,B.YE_LNAME ,B.YE_SUFFIX ,B.ADDRESS1 ,B.ADDRESS2 ,B.CITY ,B.STATE ,B.COUNTRY ,B.POSTAL ,B.CONTROL_NUMBER ,B.ELEC_FILE_CONF_NO ,MAX(B.BIRTHDATE) FROM PS_W2_COMPANY A ,PS_YE_DATA B WHERE B.COMPANY = A.COMPANY AND A.CALENDAR_YEAR = B.CALENDAR_YEAR GROUP BY A.W2_REPORTING_CO,B.EMPLID,B.CALENDAR_YEAR,B.TAXFORM_ID,B.SEQUENCE_NUMBER,B.SSN ,B.YE_FNAME,B.YE_MIDDLE_NAME,B.YE_LNAME,B.YE_SUFFIX,B.ADDRESS1,B.ADDRESS2,B.CITY,B.STATE ,B.COUNTRY,B.POSTAL,B.CONTROL_NUMBER,B.ELEC_FILE_CONF_NO

  • Parent record: YE_EE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    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
    Y=1099-R
    Z=1042-S
    5 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
    6 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    7 YE_FNAME Character(30) VARCHAR2(30) NOT NULL Year-end first name
    8 YE_MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Year-end middle name
    9 YE_LNAME Character(30) VARCHAR2(30) NOT NULL Year-end last name
    10 YE_SUFFIX Character(5) VARCHAR2(5) NOT NULL Year-end suffix
    11 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    12 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    13 CITY Character(30) VARCHAR2(30) NOT NULL City
    14 STATE Character(6) VARCHAR2(6) NOT NULL State
    15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    17 CONTROL_NUMBER Character(12) VARCHAR2(12) NOT NULL Control Number
    18 ELEC_FILE_CONF_NO Character(11) VARCHAR2(11) NOT NULL Puerto Rico Electronic Filing Confirmation Number
    19 BIRTHDATE Date(10) DATE Date of Birth