FO_CUST_BENEFIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUSTOMER
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	LIFE_INSURANCE	Character(50)	VARCHAR2(50) NOT NULL	Life Insurance Details
5	MAJOR_MEDICAL	Character(50)	VARCHAR2(50) NOT NULL	Medical Coverage
6	DENTAL	Character(50)	VARCHAR2(50) NOT NULL	Dental Coverage
7	VISION	Character(50)	VARCHAR2(50) NOT NULL	Vision Coverage
8	RETIREMENT_PLAN	Character(50)	VARCHAR2(50) NOT NULL	Retirement Plan
9	CAFETERIA_PLAN	Character(50)	VARCHAR2(50) NOT NULL	Cafeteria Plan
10	DISABILITY	Character(50)	VARCHAR2(50) NOT NULL	Disability LTD
11	HOLIDAYS	Character(50)	VARCHAR2(50) NOT NULL	Holidays
12	SICK_LEAVE	Character(50)	VARCHAR2(50) NOT NULL	Sick Leave
13	VACATION	Character(50)	VARCHAR2(50) NOT NULL	Vacation
14	PERSONAL_FAMILY	Character(50)	VARCHAR2(50) NOT NULL	Personal/Family
15	FLEX_TIME	Character(50)	VARCHAR2(50) NOT NULL	Flex Time
16	EDUC_ASSISTANCE	Character(50)	VARCHAR2(50) NOT NULL	Education Assistance
17	ADOPT_ASSISTANCE	Character(50)	VARCHAR2(50) NOT NULL	Adoption Assistance
18	CREDIT_UNION	Character(50)	VARCHAR2(50) NOT NULL	Credit Union
19	PURCHASE_DISCOUNTS	Character(50)	VARCHAR2(50) NOT NULL	Purchase Discounts
20	CHILD_CARE	Character(50)	VARCHAR2(50) NOT NULL	Child Care
21	CAFETERIA_FOOD	Character(50)	VARCHAR2(50) NOT NULL	Cafeteria Food
22	COMMENTS_2000	Long Character	CLOB	Comment Text