EG_PRDIC_RSLT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	RUN_DT	Date(10)	DATE	Run Date
4	CALC_NAME	Character(20)	VARCHAR2(20) NOT NULL	Calculation Name
5	PRDIC_RUNSTAT	Character(1)	VARCHAR2(1) NOT NULL	Periodic Run Status C=Complete with no Errors E=Complete with Errors I=Incomplete - Severe Errors N=Not Run Yet
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group
8	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
9	CALC_SEQ_NUM	Number(9,0)	DECIMAL(9) NOT NULL	Calc Seq Num
10	FROM_DATE	Date(10)	DATE	From Date
11	AS_OF_DATE	Date(10)	DATE	As of Date
12	EG_PERIODIC_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Periodic Cycle A=Annual Cycle M=Monthly Cycle Q=Quarterly Cycle S=Semester Cycle T=By Term
13	CALC_ALL_PLANS_CD	Character(1)	VARCHAR2(1) NOT NULL	Calculate All Plans Y/N Table Edit Default Value: N
14	EG_CLC_ALL_SVC_CD	Character(1)	VARCHAR2(1) NOT NULL	This is a one digit Y/N code indicating whether all available service dates are to be calculated in a given calculation run. If no, then a single service date calculation is performed. N=Calculate one date only Y=Calculate All service dates
15	SERVICE_IND	Character(1)	VARCHAR2(1) NOT NULL	Service Y/N Table Edit Default Value: N
16	SERVICE_IND2	Character(1)	VARCHAR2(1) NOT NULL	Commit to History Default Value: N
17	DELETE_IND	Character(1)	VARCHAR2(1) NOT NULL	Delete Indicator is used to indicate whether a row has been logically deleted. Default Value: N
18	PROCESS_MODE_EG	Character(1)	VARCHAR2(1) NOT NULL	Periodic Processing Mode - E&G N=Normal Run P=Update to History Z=Delete & Rebuild History