PA_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	EFFDT	Date(10)	DATE	Effective Date
4	COMPUTATION_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Computation Period A=Anniversary Year M=Calendar Month P=Plan Year Y=Calendar Year
5	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
6	END_DATE	Date(10)	DATE	End Date
7	LAST_PROC_DT	Date(10)	DATE	Last Proc Dt
8	BRKS_PRD	Number(10,6)	DECIMAL(9,6) NOT NULL	Breaks for Period
9	ACCUM_BRKS	Number(10,6)	DECIMAL(9,6) NOT NULL	Accumulated Breaks
10	SVC_AMT_WO_BRK	Number(10,6)	DECIMAL(9,6) NOT NULL	Service Amt without Breaks
11	SVC_AMT_W_BRK	Number(10,6)	DECIMAL(9,6) NOT NULL	Service Amt with Breaks
12	ACCUM_SVC_W_BRKS	Number(10,6)	DECIMAL(9,6) NOT NULL	Accum Service with Breaks
13	HRS_FOR_PRD	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Hours for Period
14	SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Sevice type 1=Service Request 2=Service Reply C=Hours Counting E=Elapsed Time H=Hours Equivalence T=Hours and Time Dependent
15	GEN_ADJ_IND	Character(1)	VARCHAR2(1) NOT NULL	Generated Adjusted Indicator
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	UNITS	Character(1)	VARCHAR2(1) NOT NULL	Units M=Months Y=Years
19	VEST_SVC_PCT	Number(10,6)	DECIMAL(9,6) NOT NULL	Vest Total service percentage
20	SVC_ADJ_AMT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Service Adjustment