GP_NRP_RPT_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	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	GP_RPT_ID	Character(18)	VARCHAR2(18) NOT NULL	Extraction Process Name
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Seq
5	GP_RPT_OUT_FLD	Character(18)	VARCHAR2(18) NOT NULL	Output Field
6	GP_RPT_FLD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Source Field Type 00=Primary Input 02=Internal Worktable 03=Additional Input 04=Element 06=Writable Array 08=Period Accumulator 13=Segment Writable Array 14=Result Delta Table
7	GP_RPT_INPUT	Character(15)	VARCHAR2(15) NOT NULL	Source Record
8	GP_RPT_FLD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Field / As Of
9	GP_RPT_REVERSE	Character(1)	VARCHAR2(1) NOT NULL	Subtract
10	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element
11	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
12	GP_RPT_PIN_SRC	Character(1)	VARCHAR2(1) NOT NULL	Field used in report generation from GP 1=Original 2=Recalculated
13	GP_RPT_FLD_ASOF	Character(18)	VARCHAR2(18) NOT NULL	Field / As Of
14	GP_RPT_ACC_TYP	Character(2)	VARCHAR2(2) NOT NULL	Period Accumulator Type 01=PTD Amount 02=PTD Unit 03=QTD Amount 04=QTD Unit 05=YTD Amount 06=YTD Unit 07=MTD Amount 08=MTD Unit
15	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data