|
SELECT COUNTRY ,PI_MNL_TEMPLATE_ID ,DESCR ,ENTRY_TYPE_VAL1 ,PIN_VAL1_NUM + 50000000 ,PI_MNL_TMPLT_OVR1A ,PI_MNL_TMPLT_OVR1B ,ENTRY_TYPE_VAL2 ,PIN_VAL2_NUM + 50000000 ,PI_MNL_TMPLT_OVR2A ,PI_MNL_TMPLT_OVR2B ,ENTRY_TYPE_VAL3 ,PIN_VAL3_NUM + 50000000 ,PI_MNL_TMPLT_OVR3A ,PI_MNL_TMPLT_OVR3B ,ENTRY_TYPE_VAL4 ,PIN_VAL4_NUM + 50000000 ,PI_MNL_TMPLT_OVR4A ,PI_MNL_TMPLT_OVR4B ,ENTRY_TYPE_VAL5 ,PIN_VAL5_NUM + 50000000 ,PI_MNL_TMPLT_OVR5A ,PI_MNL_TMPLT_OVR5B ,ENTRY_TYPE_VAL6 ,PIN_VAL6_NUM + 50000000 ,PI_MNL_TMPLT_OVR6A ,PI_MNL_TMPLT_OVR6B ,BGN_END_DT_YN ,PIN_SOVR1_NUM + 50000000 ,ENTRY_TYPE_SOVR_1 ,SOVR_VAL_TYPE_1 ,PIN_SOVR1_SETID ,SETID_1 ,PIN_SOVR2_NUM + 50000000 ,ENTRY_TYPE_SOVR_2 ,SOVR_VAL_TYPE_2 ,PIN_SOVR2_SETID ,SETID_2 ,PIN_SOVR3_NUM + 50000000 ,ENTRY_TYPE_SOVR_3 ,SOVR_VAL_TYPE_3 ,PIN_SOVR3_SETID ,SETID_3 ,CURRENCY_CD ,STORE_OPTN FROM PS_GP_PI_MNL_TMPLT
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 2 |
PI_MNL_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID for GP bulk Positive Input
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
ENTRY_TYPE_VAL1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
Prompt Table:
GP_ENT_E_D_VW
|
| 5 |
PIN_VAL1_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
Prompt Table:
%GP_EDIT_FLD1
|
| 6 |
PI_MNL_TMPLT_OVR1A |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 7 |
PI_MNL_TMPLT_OVR1B |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 8 |
ENTRY_TYPE_VAL2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
Prompt Table:
GP_ENT_E_D_VW
|
| 9 |
PIN_VAL2_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
Prompt Table:
%GP_EDIT_FLD2
|
| 10 |
PI_MNL_TMPLT_OVR2A |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 11 |
PI_MNL_TMPLT_OVR2B |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 12 |
ENTRY_TYPE_VAL3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
Prompt Table:
GP_ENT_E_D_VW
|
| 13 |
PIN_VAL3_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
Prompt Table:
%GP_EDIT_FLD3
|
| 14 |
PI_MNL_TMPLT_OVR3A |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 15 |
PI_MNL_TMPLT_OVR3B |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 16 |
ENTRY_TYPE_VAL4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
Prompt Table:
GP_ENT_E_D_VW
|
| 17 |
PIN_VAL4_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
Prompt Table:
%GP_EDIT_FLD4
|
| 18 |
PI_MNL_TMPLT_OVR4A |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 19 |
PI_MNL_TMPLT_OVR4B |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 20 |
ENTRY_TYPE_VAL5 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
Prompt Table:
GP_ENT_E_D_VW
|
| 21 |
PIN_VAL5_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
Prompt Table:
%GP_EDIT_FLD5
|
| 22 |
PI_MNL_TMPLT_OVR5A |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 23 |
PI_MNL_TMPLT_OVR5B |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 24 |
ENTRY_TYPE_VAL6 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
Prompt Table:
GP_ENT_E_D_VW
|
| 25 |
PIN_VAL6_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
Prompt Table:
%GP_EDIT_FLD6
|
| 26 |
PI_MNL_TMPLT_OVR6A |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 27 |
PI_MNL_TMPLT_OVR6B |
Character(2) |
VARCHAR2(2) NOT NULL |
Overide type used for built template to enter Bulk Positive Input
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 28 |
BGN_END_DT_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Begin End Date indicator, used in building the template for Bulk Positive Input
Y/N Table Edit
Default Value: N
|
| 29 |
PIN_SOVR1_NUM |
Number(8,0) |
INTEGER NOT NULL |
SOVR Pin NUmber user to build the template to be used in Bulk Positive Input
Prompt Table:
%GP_EDIT_FLD7
|
| 30 |
ENTRY_TYPE_SOVR_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
SOVR Entry Type 1 used for building the template for entering Bulk Positive Input
Prompt Table:
GP_ENT_PISOV_VW
|
| 31 |
SOVR_VAL_TYPE_1 |
Character(2) |
VARCHAR2(2) NOT NULL |
SOVR Value Type use in build up the Template for Bulk Positive Inpput
|
| 32 |
PIN_SOVR1_SETID |
Number(3,0) |
SMALLINT NOT NULL |
Pin SOVR setid used to build the Template for Bulk Positive Input
|
| 33 |
SETID_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid used to build the Template for entering Bulk Positive Input
|
| 34 |
PIN_SOVR2_NUM |
Number(8,0) |
INTEGER NOT NULL |
SOVR Pin NUmber user to build the template to be used in Bulk Positive Input
Prompt Table:
%GP_EDIT_FLD8
|
| 35 |
ENTRY_TYPE_SOVR_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
SOVR Entry Type 1 used for building the template for entering Bulk Positive Input
Prompt Table:
GP_ENT_PISOV_VW
|
| 36 |
SOVR_VAL_TYPE_2 |
Character(2) |
VARCHAR2(2) NOT NULL |
SOVR Value Type use in build up the Template for Bulk Positive Inpput
|
| 37 |
PIN_SOVR2_SETID |
Number(3,0) |
SMALLINT NOT NULL |
Pin SOVR setid used to build the Template for Bulk Positive Input
|
| 38 |
SETID_2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid used to build the Template for entering Bulk Positive Input
|
| 39 |
PIN_SOVR3_NUM |
Number(8,0) |
INTEGER NOT NULL |
SOVR Pin NUmber user to build the template to be used in Bulk Positive Input
Prompt Table:
%GP_EDIT_FLD9
|
| 40 |
ENTRY_TYPE_SOVR_3 |
Character(3) |
VARCHAR2(3) NOT NULL |
SOVR Entry Type 1 used for building the template for entering Bulk Positive Input
Prompt Table:
GP_ENT_PISOV_VW
|
| 41 |
SOVR_VAL_TYPE_3 |
Character(2) |
VARCHAR2(2) NOT NULL |
SOVR Value Type use in build up the Template for Bulk Positive Inpput
|
| 42 |
PIN_SOVR3_SETID |
Number(3,0) |
SMALLINT NOT NULL |
Pin SOVR setid used to build the Template for Bulk Positive Input
|
| 43 |
SETID_3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid used to build the Template for entering Bulk Positive Input
|
| 44 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 45 |
STORE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Store Option - Indicator field to configure when data is stored (when element or results are non-zero, when element or results are zero, but component values are entered etc....)
Introduced on Bulk PI template
A=Always Store
C=When Components are Non-Zero
S=When Supporting Elements Exist
|