FEDERAL_EINRPT_FEDERAL_EINEDD_ACCOUNT_NUMSETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SETID_TBL
VENDOR_IDPrompt Table: CAEDD_VNDR_VW
CALENDAR_YEARY/N Table Edit
CAEDD_VNDR_TRAN(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FEDERAL_EIN |
Number(9,0) | DECIMAL(9) NOT NULL | Federal EIN |
| 2 | RPT_FEDERAL_EIN |
Number(9,0) | DECIMAL(9) NOT NULL | Reporting Federal EIN |
| 3 | EDD_ACCOUNT_NUM |
Number(8,0) | INTEGER NOT NULL | EDD Employer Account Number |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: CAEDD_VNDR_VW |
| 6 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 7 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 8 | CNTRCT_AMT | Number(14,2) | DECIMAL(13,2) NOT NULL | Contract Amount |
| 9 | CNTRCT_EXPIRE_DT | Date(10) | DATE | Expire Date |
| 10 | ONGOING_CONTRCT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Ongoing Contract
Y/N Table Edit |
| 11 | DATE_LAST_PROCESS | Date(10) | DATE | Date Last Processed |
| 12 | FILE_EXT | Number(3,0) | SMALLINT NOT NULL | File Ext |
| 13 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |