GP_NRP_RPT_VW

(SQL View)
 Index Back

Report Data Field Mapping

Report Data Field Mapping

SELECT COUNTRY , GP_RPT_ID , SEQ_NUM , GP_RPT_OUT_FLD , GP_RPT_FLD_TYPE , GP_RPT_INPUT , GP_RPT_FLD_NAME , GP_RPT_REVERSE , ENTRY_TYPE_ELEM , PIN_NUM+50000000 , GP_RPT_PIN_SRC , GP_RPT_FLD_ASOF , GP_RPT_ACC_TYP , DATA_TYPE_CD FROM PS_GP_RPT_FLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 GP_RPT_ID Character(18) VARCHAR2(18) NOT NULL Extraction Process Name
3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Seq
4 GP_RPT_OUT_FLD Character(18) VARCHAR2(18) NOT NULL Output Field
5 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
6 GP_RPT_INPUT Character(15) VARCHAR2(15) NOT NULL Source Record
7 GP_RPT_FLD_NAME Character(18) VARCHAR2(18) NOT NULL Field / As Of
8 GP_RPT_REVERSE Character(1) VARCHAR2(1) NOT NULL Subtract

Y/N Table Edit

9 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
10 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
11 GP_RPT_PIN_SRC Character(1) VARCHAR2(1) NOT NULL Field used in report generation from GP
1=Original
2=Recalculated
12 GP_RPT_FLD_ASOF Character(18) VARCHAR2(18) NOT NULL Field / As Of
13 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
14 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data