GP_AUD_CAL_PKG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
8	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
9	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
10	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
11	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
12	PRD_END_DT	Date(10)	DATE	Pay Period End Date
13	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
14	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
15	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
16	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
17	CALC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Calculate Action C=Calculate R=Calculate and Replace V=Reverse W=Reverse and Replace
18	PIN_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
19	PIN_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Net Pay Value
20	GP_CALC_TS	DateTime(26)	TIMESTAMP	Indicates when something (a segment) was calculated