RA_WLST_REC_800

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RA_CAMPAIGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
3	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
4	RA_LIST_REC_ID	Number(18,0)	DECIMAL(18) NOT NULL	List Record ID
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer Setid
7	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
8	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
9	INDUSTRY_ID	Character(30)	VARCHAR2(30) NOT NULL	Industry ID.
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number from Supply Chain Management. Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
11	CR_ADDRESS_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Address ID of a Customer.
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
13	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
14	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
15	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
16	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
17	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
18	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
19	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
20	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
21	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
22	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
23	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender of the person. F=Female M=Male U=Unknown
24	BIRTHDATE	Date(10)	DATE	Birthdate of the person.
25	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Country Code values.
26	WORK_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Work Phone
27	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
28	HOME_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Home Phone
29	CELL_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Cell Phone
30	FAX	Character(24)	VARCHAR2(24) NOT NULL	This is the fax number field.
31	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
32	DELETED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Deleted Flag Field Y/N Table Edit Default Value: N
33	CONTROL_GROUP_ID	Number(3,0)	SMALLINT NOT NULL	Control Group ID
34	CREATE_LEAD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Lead. Y/N Table Edit Default Value: Y