FEDERAL_EINPrompt Table: CAEDD_CNTRL_VW
RPT_FEDERAL_EINEDD_ACCOUNT_NUMY/N Table Edit
Default Value: CA
CAEDD_CNTRL_BUS(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
Prompt Table: CAEDD_CNTRL_VW |
| 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 | TRANSMITTER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Transmitter Flg
Y/N Table Edit |
| 5 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 9 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Default Value: CA |
| 10 | ZIP_CODE | Character(5) | VARCHAR2(5) NOT NULL | Zip Code |
| 11 | ZIP_CODE_EXT | Character(4) | VARCHAR2(4) NOT NULL | Zip Code/Ext |
| 12 | PHONE_NUM | Character(12) | VARCHAR2(12) NOT NULL | Phone Number |
| 13 | DATE_LAST_PROCESS | Date(10) | DATE | Date Last Processed |
| 14 | FILE_EXT | Number(3,0) | SMALLINT NOT NULL | File Ext |
| 15 | TOTAL_IC_REPORTED | Number(4,0) | SMALLINT NOT NULL | Total IC's reported |