GPUS_BENACM_EXT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
8	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
9	GP_RPT_KEY	Character(22)	VARCHAR2(22) NOT NULL	Output Result Key
10	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
12	ACM_FROM_DT	Date(10)	DATE	From Date
13	ACM_THRU_DT	Date(10)	DATE	Through Date
14	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
15	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
16	PIN_PARENT_NUM	Number(8,0)	INTEGER NOT NULL	Parent Element Number
17	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
18	ACM_PRD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Accumulator Period 1=Segment 2=Calendar Period 3=Month to Date 4=Quarter to Date 5=Year to Date 6=Custom Period
19	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
20	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
21	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
22	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
23	EFFDT	Date(10)	DATE	Effective Date
24	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code