GP_NRP_RSPID_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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
8	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
9	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
10	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
11	PI_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Positive Input Source A=Absence G=Generated PI M=Manual T=Time&Labor
12	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
13	PI_GEN_REF	Character(15)	VARCHAR2(15) NOT NULL	PI Generated Reference
14	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	GP_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
17	ENTRY_TYPE_RATE	Character(3)	VARCHAR2(3) NOT NULL	entry type rate
18	PIN_RATE_NUM	Number(8,0)	INTEGER NOT NULL	PinNumber Rate
19	GP_UNIT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit
20	ENTRY_TYPE_UNIT	Character(3)	VARCHAR2(3) NOT NULL	entry type unit
21	PIN_UNIT_NUM	Number(8,0)	INTEGER NOT NULL	Pin-Number Unit
22	GP_BASE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base
23	ENTRY_TYPE_BASE	Character(3)	VARCHAR2(3) NOT NULL	entry type base
24	PIN_BASE_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Base
25	GP_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Percent
26	ENTRY_TYPE_PCT	Character(3)	VARCHAR2(3) NOT NULL	Entry Pype Percent Option
27	PIN_PCT_NUM	Number(8,0)	INTEGER NOT NULL	Percent to Accum Element
28	GP_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
29	ENTRY_TYPE_AMT	Character(3)	VARCHAR2(3) NOT NULL	entry type amount
30	PIN_AMT_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Amount
31	BGN_DT	Date(10)	DATE	Begin Date
32	END_DT	Date(10)	DATE	end date
33	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
34	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
35	BAL_ADJ	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Balance Adjustment
36	ABS_BGN_DT	Date(10)	DATE	Absence Begin Date
37	ABS_END_DT	Date(10)	DATE	Absence End Date
38	ABS_PRD_BGN_DT	Date(10)	DATE	Absence Period Begin Date
39	ABS_PRD_END_DT	Date(10)	DATE	Absence Period End Date
40	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.
41	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.