GP_ABS_ANLY_GEN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
9	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
10	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
11	PI_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Positive Input Source A=Absence G=Generated PI M=Manual T=Time&Labor
12	ABS_BGN_DT	Date(10)	DATE	Absence Begin Date
13	ABS_END_DT	Date(10)	DATE	Absence End Date
14	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
15	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
16	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
17	PRD_END_DT	Date(10)	DATE	Pay Period End Date
18	GP_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
19	GP_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Percent
20	GP_UNIT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit
21	GP_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
22	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
23	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
24	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
25	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
26	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason
27	ABS_REASON_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Absence Reason
28	COMPUTED_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Variable Cost
29	GP_PG_ABS_CNT	Number(7,0)	INTEGER NOT NULL	field used to present processing statistics
30	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
31	ACTION_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Action Description
32	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
33	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
34	WORKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Workgroup
35	DESCR3	Character(30)	VARCHAR2(30) NOT NULL	Descr 3
36	GP_ATTRIBUTE_NAME	Character(4)	VARCHAR2(4) NOT NULL	ATTRIBUTE_NAME NEWH=New Hire OLVA=On Leave Of Absence RFL=Return From Leave TERM=Terminated
37	GP_HR_ACTION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	GP_HR_ACTION_DESCR
38	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
39	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
40	GROUP_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Group List
41	ABS_DATA_SRC	Character(1)	VARCHAR2(1) NOT NULL	Absence Data Source: Event or Take Processing 1=Event Processing 2=Take Processing
42	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
43	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
44	PIN_PARENT_TK_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
45	PIN_PARENT_TAKE_NM	Character(18)	VARCHAR2(18) NOT NULL	Parent PIN Take Name
46	RETRO_IND	Character(1)	VARCHAR2(1) NOT NULL	Retro Indicator
47	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
48	TRC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Time Reporting Code Descriptio
49	TOT_REPD_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
50	TOT_REPD_PCT	Signed Number(11,3)	DECIMAL(9,3) NOT NULL	Percent
51	ACTUAL_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Actual Cost
52	TOTAL_RPTD_UNIT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Reported Units for Approval.
53	TOT_REPD_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
54	GP_AGGR_COUNT	Number(9,1)	DECIMAL(8,1) NOT NULL	field used to present processing statistics
55	LASTUPDDTTM	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.