HP_1042S_PARAM(SQL Table) |
Index Back |
|---|---|
1042 Withholding Agent InfoWithholding Agent's contact information for 1042 Magnetic Media Process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |