| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_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
Prompt Table:
GP_RPT_F1_VW
|
| 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
Default Value: 00
|
| 6 |
GP_RPT_INPUT |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Record
Prompt Table:
GP_RPT_REC_VW
|
| 7 |
GP_RPT_FLD_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field / As Of
Prompt Table:
GP_RPT_F2_VW
|
| 8 |
GP_RPT_REVERSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Subtract
Y/N Table Edit
Default Value: N
|
| 9 |
ENTRY_TYPE_ELEM |
Character(3) |
VARCHAR2(3) NOT NULL |
entry type element
Prompt Table:
GP_ENT_FMFL3_VW
|
| 10 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
Prompt Table:
%GP_EDIT_FLD7
|
| 11 |
GP_RPT_PIN_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used in report generation from GP
1=Original
2=Recalculated
Default Value: 1
|
| 12 |
GP_RPT_FLD_ASOF |
Character(18) |
VARCHAR2(18) NOT NULL |
Field / As Of
Prompt Table:
GP_RPT_F1_VW
|
| 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
Default Value: 01
|
| 14 |
DATA_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data
S=Sample Data
Y=System Data
|