EG_CLC_SVC_FLX

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CALC_NAME	Character(20)	VARCHAR2(20) NOT NULL	Calculation Name
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group
4	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
5	PRD_FR_DT	Date(10)	DATE	Period From Date
6	PRCS_THRU_DT	Date(10)	DATE	Process Through Date
7	PRD_END_DT	Date(10)	DATE	Pay Period End Date
8	EG_PROJ_DT	Date(10)	DATE	Projected Service Date
9	EG_BRKS_PRD	Number(10,6)	DECIMAL(9,6) NOT NULL	Breaks for Period
10	EG_SVC_AMT_WO_BRK	Number(10,6)	DECIMAL(9,6) NOT NULL	Service Amt without Breaks
11	EG_ACCUM_BRKS	Number(10,6)	DECIMAL(9,6) NOT NULL	Accumulated Breaks
12	EG_SVC_AMT_W_BRK	Number(10,6)	DECIMAL(9,6) NOT NULL	Service Amt with Breaks
13	EG_ACCUM_SVC_W_BRK	Number(10,6)	DECIMAL(9,6) NOT NULL	Accum Service with Breaks
14	EG_SVC_ADJ_AMT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Service Adjustment
15	SERVICE_YEARS	Number(2,0)	SMALLINT NOT NULL	Years of Service
16	SERVICE_MONTHS_GBL	Number(4,0)	SMALLINT NOT NULL	Service Months
17	SERVICE_DAYS_GBL	Number(5,0)	INTEGER NOT NULL	Service Days
18	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
19	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
20	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
21	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
22	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
23	GEN_ADJ_IND	Character(1)	VARCHAR2(1) NOT NULL	Generated Adjusted Indicator
24	EG_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Service Type E=Elapsed Time
25	UNITS	Character(1)	VARCHAR2(1) NOT NULL	Units M=Months Y=Years