EG_DFN_SVC_STVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEFINITION_NAME	Character(10)	VARCHAR2(10) NOT NULL	VARCHAR2(10) NOT NULL
2	SVC_DFN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	For future use B=Break Definition S=Service Definition Type Default Value: S
3	CATEGORY	Character(10)	VARCHAR2(10) NOT NULL	Category Name Prompt Table: EG_HR_ACT
4	RECORD_IMPACTED	Character(1)	VARCHAR2(1) NOT NULL	Record Impacted A=All F=First Only L=Last Only N=No Records Impacted X=All But First Y=All But Last Z=All But First and Last Default Value: N
5	ADJUSTMENT_RULE	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Rule P=Periods to Add U=User Code
6	PERIODS_ADD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Periods to Add Field Type N=Numeric Constant V=Variable by employee
7	PERIODS_TO_ADD	Number(3,0)	SMALLINT NOT NULL	Periods to Add
8	PRDS_TO_ADD_ALS_NM	Character(10)	VARCHAR2(10) NOT NULL	Periods to add alias name Prompt Table: EG_ALIAS_USE
9	PRDS_TO_AD_ALS_TYP	Character(2)	VARCHAR2(2) NOT NULL	Periods to add alias type
10	PERIOD_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Unit of the Period D=Days M=Months W=Weeks Y=Years
11	DT_RND_OPT_NM	Character(10)	VARCHAR2(10) NOT NULL	Date Round Option Name Prompt Table: EG_DATE_RND_OPT
12	MIN_MAX_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Min/Max Indicator M=Minimum N=No Limit X=Maximum Default Value: N
13	ALLOCATION_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Allocation Period C=Cut Off at Limit D=Spread Across Days
14	LIMITATION_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Limitation Period S=Status Period U=User Code Default Value: S
15	MIN_MAX_SERVICE	Number(10,6)	DECIMAL(9,6) NOT NULL	Minimum or Maximum Svc Amount
16	ADD_TIME	Character(1)	VARCHAR2(1) NOT NULL	Add Time To Date? Y/N Table Edit
17	FUTURE_ADJ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Future Adjustment Flag A=Add Time to Current Act/Rsn C=Ignore Current Action/Reason F=Ignore Future Action/Reason I=Insert Action/Reason
18	HIRE_CATG_CD	Character(1)	VARCHAR2(1) NOT NULL	Hire/Rehire Category Indicator Y/N Table Edit Default Value: N
19	CATG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Category Type H=Hire Category O=Other T=Termination Category
20	INCLUDE_CD	Character(1)	VARCHAR2(1) NOT NULL	Service Include Code Y/N Table Edit