HP_1042S_PARAM

(SQL Table)
Index Back

1042 Withholding Agent Info

Withholding Agent's contact information for 1042 Magnetic Media Process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 HP_CONTACT_NM_1042 Character(40) VARCHAR2(40) NOT NULL Withholding Agent's contact name for 1042 Magnetic Tape process
3 CONTACT_PHONE Character(12) VARCHAR2(12) NOT NULL Contact Phone
4 CONTACT_PHONE_EXT Character(4) VARCHAR2(4) NOT NULL Contact Phone Extension
5 DEPT_TITLE Character(45) VARCHAR2(45) NOT NULL Department Title - use for 1042-S process parameter that keep withholding agent's department title.
6 HP_USE_WH_CONTACT Character(1) VARCHAR2(1) NOT NULL Use Withholding Agent contact information on transmitter record.

Y/N Table Edit

Default Value: Y

7 HP_TRM_CONTACT_NM Character(40) VARCHAR2(40) NOT NULL Transmitter contact name for 1042 Magnetic Tape process
8 HP_TRM_CONTACT_PH Character(12) VARCHAR2(12) NOT NULL Transmitter Contact Phone number
9 HP_TRM_CONTACT_EXT Character(4) VARCHAR2(4) NOT NULL Transmitter contact phone extension for 1042 Magnetic Tape process