GP_PG_ANLGN_HST

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