GPUS_YE_MMREFPA

(SQL Table)
 Index Back

Year End MMREF Parameters

This record stores all the parameters required to create MMREF files.

  • Parent Record Of GPUS_YE_MMREFCO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLR_PIN Character(17) VARCHAR2(17) NOT NULL Employer PIN.
    2 GPUS_XMITTER_ID Character(8) VARCHAR2(8) NOT NULL Transmitter No

    Prompt Table: GPUS_CO_USA_VW

    3 GPUS_ORG_TYPE Character(1) VARCHAR2(1) NOT NULL Organization Type
    F=Federal Government
    G=State or Local Government
    N=None Apply
    O=Other
    S=State and Local Government
    S=State and Local non-501(c)
    T=501(c) Non-governmental
    T=Tax Exempt
    Y=State and Local Tax Exempt
    Y=State and Local 501(c)
    4 GPUS_EMPLYMNT_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Employment
    A=Agriculture
    F=Regular - Form 944
    H=HouseHould
    M=Military
    Q=Medicare Qualified Govt Emplmt
    R=Regular (All Others)
    X=Railroad

    Default Value: R

    5 GPUS_RECORDING_CD Character(3) VARCHAR2(3) NOT NULL Recording Code
    ASC=ASCII
    EBC=EBCDIC

    Default Value: ASC

    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: GP_PERS_SRCH

    7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    8 TELEPHONE_NBR Character(15) VARCHAR2(15) NOT NULL Telephone Number
    9 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension
    10 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    11 EMAIL_ADDR_MMREF Character(40) VARCHAR2(40) NOT NULL Email Address for MMREF
    12 GPUS_NOTIFY_METHOD Character(1) VARCHAR2(1) NOT NULL Preferred Method of Problem Notification.
    1=E Mail/Internet
    2=Postal Service

    Default Value: 2

    13 GPUS_RPT_CO_IND Character(1) VARCHAR2(1) NOT NULL Indicates if Transmitter reports for other companies

    Y/N Table Edit

    Default Value: N

    14 GPUS_CNTRL_NBR Character(9) VARCHAR2(9) NOT NULL Control Number
    15 GPUS_ACCESS_CD Character(5) VARCHAR2(5) NOT NULL Access Code
    16 GPUS_REGISTER_NBR Character(5) VARCHAR2(5) NOT NULL Specialists Register Number
    17 GPUS_SUPP_D2_2 Character(46) VARCHAR2(46) NOT NULL Supplemental Data 2
    18 GPUS_E_CONFIRM_NBR Character(11) VARCHAR2(11) NOT NULL Electronic Filing Confirmation Number for GPUS W-2 and W-2c Puerto Rico forms For 2018, the length changed to 11 characters
    19 GPUS_EST_NUM Character(4) VARCHAR2(4) NOT NULL `Establishment Number