FEDERAL_EINCAEDD_CNTRL_VW(SQL View) |
Index Back |
|---|
| SELECT FEDERAL_EIN , CNTCT_NAME1 , DATE_LAST_PROCESS , FILE_EXT , TOTAL_IC_REPORTED FROM PS_CAEDD_CNTRL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FEDERAL_EIN |
Number(9,0) | DECIMAL(9) NOT NULL | Federal EIN |
| 2 | CNTCT_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Contact Name1 |
| 3 | DATE_LAST_PROCESS | Date(10) | DATE | Date Last Processed |
| 4 | FILE_EXT | Number(3,0) | SMALLINT NOT NULL | File Ext |
| 5 | TOTAL_IC_REPORTED | Number(4,0) | SMALLINT NOT NULL | Total IC's reported |