EG_FLX_SVC_DT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: EG_FLX_SVC_VW
2	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group Default Value: EG_FLX_SVC_VW.EG_GROUP Prompt Table: EG_FLX_SVC_VW
3	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name Prompt Table: EG_FLX_FUNC_VW
4	SERVICE_DT	Date(10)	DATE NOT NULL	Service Date Default Value: EG_FLX_SVC_VW.SERVICE_DT
5	EG_ACCR_SVC	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Time Accrued
6	SERVICE_YEARS	Number(2,0)	SMALLINT NOT NULL	Years of Service
7	SERVICE_MONTHS_GBL	Number(4,0)	SMALLINT NOT NULL	Service Months
8	SERVICE_DAYS_GBL	Number(5,0)	INTEGER NOT NULL	Service Days
9	EG_START_UP_CR	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Yrs of Credit Granted
10	EG_PROJ_DT	Date(10)	DATE	Projected Service Date
11	EG_ADJ_RSN1	Character(1)	VARCHAR2(1) NOT NULL	Change Reason A=Retroactive Adjustment C=Error corrections M=Partial Month N=New O=Other P=Service Recalc. Pending R=Recalculation Default Value: N
12	ADJ_ENTRY_DT	Date(10)	DATE	Adjustment Entry Date Default Value: %Date
13	LAST_PROC_DT	Date(10)	DATE	Last Proc Date
14	EG_OVERRIDE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Override Calculation Y/N Table Edit
15	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
16	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
17	COMMENTS	Long Character	CLOB	Comment