GPMX_NRP_PMD_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
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	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
7	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID
8	PI_ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Action Type Positive Input A=Add I=Ignore N=Do Not Process O=Override Z=Resolve To Zero
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	GP_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
11	ENTRY_TYPE_RATE	Character(3)	VARCHAR2(3) NOT NULL	entry type rate
12	PIN_RATE_NUM	Number(8,0)	INTEGER NOT NULL	PinNumber Rate
13	GP_UNIT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit
14	ENTRY_TYPE_UNIT	Character(3)	VARCHAR2(3) NOT NULL	entry type unit
15	PIN_UNIT_NUM	Number(8,0)	INTEGER NOT NULL	Pin-Number Unit
16	GP_BASE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base
17	ENTRY_TYPE_BASE	Character(3)	VARCHAR2(3) NOT NULL	entry type base
18	PIN_BASE_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Base
19	GP_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Percent
20	ENTRY_TYPE_PCT	Character(3)	VARCHAR2(3) NOT NULL	Entry Pype Percent Option
21	PIN_PCT_NUM	Number(8,0)	INTEGER NOT NULL	Percent to Accum Element
22	GP_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
23	ENTRY_TYPE_AMT	Character(3)	VARCHAR2(3) NOT NULL	entry type amount
24	PIN_AMT_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Amount
25	BGN_DT	Date(10)	DATE	Begin Date
26	END_DT	Date(10)	DATE	end date
27	ABS_PRD_BGN_DT	Date(10)	DATE	Absence Period Begin Date
28	ABS_PRD_END_DT	Date(10)	DATE	Absence Period End Date
29	ABS_BGN_DT	Date(10)	DATE	Absence Begin Date
30	ABS_END_DT	Date(10)	DATE	Absence End Date