CAEDD_CNTRL

(SQL Table)

# 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 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

#	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	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