CAEDD_VENDOR

(SQL Table)

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

5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: CAEDD_VNDR_VW

6 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #

7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

8 MIDDLE_INITIAL Character(1) VARCHAR2(1) NOT NULL Middle Initial

9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

#	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: SP_SETID_NONVW
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: CAEDD_VNDR_VW
6	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
7	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
8	MIDDLE_INITIAL	Character(1)	VARCHAR2(1) NOT NULL	Middle Initial
9	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name