WTHD_T_RECORD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECORD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Record Type
F=Project Funding R=Project Resource Transaction |
| 2 | WTHD_PAYMENT_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Payment Year |
| 3 | HDR_PRIORYEAR_DATA | Character(1) | VARCHAR2(1) NOT NULL | Prior Year Data Indicator |
| 4 | HDR_TRANS_TIN_CD | Character(9) | VARCHAR2(9) NOT NULL | Transmitter's TIN Code |
| 5 | HDR_TRANS_CNTL_CD | Character(5) | VARCHAR2(5) NOT NULL | Transmitter Control Code |
| 6 | HDR_REPLACE_ALPHA | Character(2) | VARCHAR2(2) NOT NULL | Replacement Alpha |
| 7 | BLANK5 | Character(5) | VARCHAR2(5) NOT NULL | Blank |
| 8 | HDR_TEST_FILE_IND | Character(1) | VARCHAR2(1) NOT NULL | Test File Indicator |
| 9 | HDR_FOREIGN_ENTTY | Character(1) | VARCHAR2(1) NOT NULL | Foreign Entity Indicator |
| 10 | HDR_TRANS_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Transmitter Name |
| 11 | HDR_TRANS_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Transmitter Name |
| 12 | HDR_COMPANY_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Company Name |
| 13 | HDR_COMPANY_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Company Name 2 |
| 14 | HDR_COMPANY_ADDR | Character(40) | VARCHAR2(40) NOT NULL | Company Address |
| 15 | HDR_COMPANY_CITY | Character(40) | VARCHAR2(40) NOT NULL | Company City |
| 16 | HDR_COMPANY_STATE | Character(2) | VARCHAR2(2) NOT NULL | Company State |
| 17 | HDR_COMPANY_ZIP | Character(9) | VARCHAR2(9) NOT NULL | Company ZIP Code |
| 18 | BLANK15 | Character(15) | VARCHAR2(15) NOT NULL | blank |
| 19 | HDR_TOT_PAYEES | Character(8) | VARCHAR2(8) NOT NULL | Total Nbr of Payees |
| 20 | HDR_CONTACT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Contact name |
| 21 | HDR_CONTACT_PHONE | Character(15) | VARCHAR2(15) NOT NULL | Contact Phone |
| 22 | HDR_CNTCT_EMAIL | Character(50) | VARCHAR2(50) NOT NULL | Contact Email Address |
| 23 | HDR_MAGNETIC_FILE | Character(2) | VARCHAR2(2) NOT NULL | Magnetic File Indicator |
| 24 | HDR_E_FILENAME | Character(15) | VARCHAR2(15) NOT NULL | Electronic Filename |
| 25 | HDR_MEDIA_NUMBER | Character(6) | VARCHAR2(6) NOT NULL | Media Number |
| 26 | BLANK83 | Character(83) | VARCHAR2(83) NOT NULL | Blank 83 |
| 27 | REC_SEQ_NBR | Character(8) | VARCHAR2(8) NOT NULL | Record Sequence Number |
| 28 | BLANK10 | Character(10) | VARCHAR2(10) NOT NULL | 10 blanks |
| 29 | HDR_VENDOR_IND | Character(1) | VARCHAR2(1) NOT NULL | Supplier Indicator |
| 30 | HDR_VENDOR_NAME | Character(40) | VARCHAR2(40) NOT NULL | Supplier Name |
| 31 | HDR_VENDOR_ADDR | Character(40) | VARCHAR2(40) NOT NULL | Supplier Address |
| 32 | HDR_VENDOR_CITY | Character(40) | VARCHAR2(40) NOT NULL | Supplier City |
| 33 | HDR_VENDOR_STATE | Character(2) | VARCHAR2(2) NOT NULL | Supplier State |
| 34 | HDR_VENDOR_ZIP | Character(9) | VARCHAR2(9) NOT NULL | Supplier ZIP Code |
| 35 | HDR_VNDCNTCT_NAME | Character(40) | VARCHAR2(40) NOT NULL | Supplier Contact Name |
| 36 | HDR_VNDCNTCT_PHONE | Character(15) | VARCHAR2(15) NOT NULL | Supplier Contact Phone |
| 37 | HDR_VNDCNTCT_EMAIL | Character(35) | VARCHAR2(35) NOT NULL | Supplier contact email address |
| 38 | BLANK9 | Character(9) | VARCHAR2(9) NOT NULL | blank |
| 39 | BLANK2 | Character(2) | VARCHAR2(2) NOT NULL | 2 blanks |