GP_NRP_PIMDT_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	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
3	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
7	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
8	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID
9	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
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	GP_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
12	ENTRY_TYPE_RATE	Character(3)	VARCHAR2(3) NOT NULL	entry type rate
13	PIN_RATE_NUM	Number(8,0)	INTEGER NOT NULL	PinNumber Rate
14	GP_UNIT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit
15	ENTRY_TYPE_UNIT	Character(3)	VARCHAR2(3) NOT NULL	entry type unit
16	PIN_UNIT_NUM	Number(8,0)	INTEGER NOT NULL	Pin-Number Unit
17	GP_BASE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base
18	ENTRY_TYPE_BASE	Character(3)	VARCHAR2(3) NOT NULL	entry type base
19	PIN_BASE_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Base
20	GP_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Percent
21	ENTRY_TYPE_PCT	Character(3)	VARCHAR2(3) NOT NULL	Entry Pype Percent Option
22	PIN_PCT_NUM	Number(8,0)	INTEGER NOT NULL	Percent to Accum Element
23	GP_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
24	ENTRY_TYPE_AMT	Character(3)	VARCHAR2(3) NOT NULL	entry type amount
25	PIN_AMT_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Amount
26	BGN_DT	Date(10)	DATE	Begin Date
27	END_DT	Date(10)	DATE	end date
28	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
29	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
30	GP_BATCH_CD	Character(10)	VARCHAR2(10) NOT NULL	The Batch Code will be used to identify a group of positive input.
31	BAL_ADJ	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Balance Adjustment
32	ABS_PRD_BGN_DT	Date(10)	DATE	Absence Period Begin Date
33	ABS_PRD_END_DT	Date(10)	DATE	Absence Period End Date
34	ABS_BGN_DT	Date(10)	DATE	Absence Begin Date
35	ABS_END_DT	Date(10)	DATE	Absence End Date
36	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
37	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.