EG_SVC_HIST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
3	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
4	END_DATE	Date(10)	DATE	End Date
5	LAST_PROC_DT	Date(10)	DATE	Last Proc Date
6	EG_PERIOD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Computational Period M=Month Q=Quarter S=Semester T=Term Y=Computational Year
7	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group Default Value: EG_TENURE_DATA.EG_GROUP
8	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank Default Value: EG_TENURE_DATA.EG_ACADEMIC_RANK
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	EG_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Service Type E=Elapsed Time Default Value: E
16	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
17	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
18	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
19	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Default Value: EG_TENURE_DATA.EG_TENURE_HOME
20	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
21	EG_ADJ_RSN	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Reason A=Adjustment C=Error corrections M=Partial Month O=Other P=Service Recalc Pending R=Recalculation
22	GEN_ADJ_IND	Character(1)	VARCHAR2(1) NOT NULL	Generated Adjusted Indicator
23	ACTION_DT	Date(10)	DATE	Action Date Default Value: %date
24	UNITS	Character(1)	VARCHAR2(1) NOT NULL	Units M=Months Y=Years Default Value: Y
25	COMMENTS	Long Character	CLOB	Comment