GP_PG_ABS_STORE

#	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	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GP_AB_CALGRP_VW
4	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id Prompt Table: GP_AB_CALID_VW
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_AB_PYGRP_VW
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: GP_AB_DEPTID_VW
7	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type Prompt Table: GP_AB_ABSTYP_VW
8	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field Prompt Table: GP_AB_TAKE_VW
9	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason Prompt Table: GP_AB_ABSRSN_VW
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GP_AB_EMPLID_VW
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: GP_AB_COMPNY_VW
12	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_AB_PYENT_VW
13	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: GP_AB_JOBCD_VW
14	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
15	GP_THRESHOLD_UNITS	Signed Number(15,4)	DECIMAL(13,4) NOT NULL	GP_THRESHOLD_UNITS
16	GP_THRESHOLD_COST	Signed Number(15,4)	DECIMAL(13,4) NOT NULL	GP_THRESHOLD_COST
17	GP_THRESHOLD_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
18	GP_THRESHOLD_PCT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
19	GP_THRESHOLD_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
20	GP_AGGR_COUNT	Number(9,1)	DECIMAL(8,1) NOT NULL	field used to present processing statistics
21	GP_CAL_GRP_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_CAL_GRP_OPER
22	GP_CAL_ID_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_CAL_ID_OPER
23	GP_PAYGRP_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_PAYGRP_OPER
24	GP_DEPTID_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_DEPTID_OPER
25	GP_ABS_TY_OPN_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_ABS_TY_OPN_OPER
26	GP_PIN_NM_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_PIN_NM_OPER
27	GP_ABS_RSN_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_ABS_RSN_OPER
28	GP_EMPLID_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_EMPLID_OPER
29	GP_COMPANY_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_COMPANY_OPER
30	GP_PAY_ENTITY_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_PAY_ENTITY_OPER
31	GP_JOBCODE_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_JOBCODE_OPER
32	GP_ACTION_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_ACTION_OPER
33	GP_UNIT_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_UNIT_OPER
34	GP_COST_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_COST_OPER
35	GP_AMT_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_AMT_OPER
36	GP_PCT_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_PCT_OPER
37	GP_RATE_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_RATE_OPER
38	GP_AGGR_CNT_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_AGGR_CNT_OPER
39	PIN_CODE	Character(22)	VARCHAR2(22) NOT NULL	Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
40	GP_PINCODE_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_PINCODE_OPER
41	TRC4	Character(5)	VARCHAR2(5) NOT NULL	TRC -- Used in rule templates.
42	GP_TRC_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_TRC_OPER
43	GP_PG_ERNDD_CD	Character(6)	VARCHAR2(6) NOT NULL	GP_PG_ERNDD_CD
44	GP_PNACODE_OPER	Character(2)	VARCHAR2(2) NOT NULL	GP_PNACODE_OPER
45	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field