RC_TAX960

(SQL Table)
Index Back

MMREF Process Run Control

MMREF Process Run Control

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REPORTING_MEDIUM Character(1) VARCHAR2(1) NOT NULL Reporting Medium
C=Cartridge
D=Diskette
T=Tape
X=Electronic
4 DISKETTE_TYPE Character(1) VARCHAR2(1) NOT NULL Diskette Type
0=Not Applicable
1=3.5 Inches High Density
2=3.5 Inches Double Density
5 EMPLR_PIN Character(17) VARCHAR2(17) NOT NULL Employer PIN.
6 RESUB_INDICATOR Character(1) VARCHAR2(1) NOT NULL Resub Indicator.

Y/N Table Edit

Default Value: N

7 RESUB_TLCN Character(6) VARCHAR2(6) NOT NULL TLCN displayed on the notice sent by SSA when resubmitting W-2 in MMREF.
8 CONTACT_NAME_SSA Character(27) VARCHAR2(27) NOT NULL Name of the Person to be contacted by SSA.
9 TELEPHONE_NBR Character(15) VARCHAR2(15) NOT NULL Telephone Number
10 PHONE_EXTN Number(5,0) INTEGER NOT NULL Telephone Extension.
11 EMAIL_ADDR_MMREF Character(40) VARCHAR2(40) NOT NULL Email Address for MMREF
12 CONTACT_FAX Character(10) VARCHAR2(10) NOT NULL Contact FAX Number.
13 NOTIFY_METHOD Character(1) VARCHAR2(1) NOT NULL Preferred Method of Problem Notification.
1=E Mail/Internet
2=Postal Service

Default Value: 3