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
    G=State or Local Government
    O=Other

    Default Value: O

    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