| # |
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 |
PI_MNL_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID for GP bulk Positive Input
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
ENTRY_TYPE_VAL1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 6 |
PIN_VAL1_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 7 |
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
|
| 8 |
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
|
| 9 |
ENTRY_TYPE_VAL2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 10 |
PIN_VAL2_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 11 |
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
|
| 12 |
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
|
| 13 |
ENTRY_TYPE_VAL3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 14 |
PIN_VAL3_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 15 |
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
|
| 16 |
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
|
| 17 |
ENTRY_TYPE_VAL4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 18 |
PIN_VAL4_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 19 |
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
|
| 20 |
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
|
| 21 |
ENTRY_TYPE_VAL5 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 22 |
PIN_VAL5_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 23 |
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
|
| 24 |
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
|
| 25 |
ENTRY_TYPE_VAL6 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 26 |
PIN_VAL6_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 27 |
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
|
| 28 |
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
|
| 29 |
BGN_END_DT_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Begin End Date indicator, used in building the template for Bulk Positive Input
|
| 30 |
PIN_SOVR1_NUM |
Number(8,0) |
INTEGER NOT NULL |
SOVR Pin NUmber user to build the template to be used in Bulk Positive Input
|
| 31 |
ENTRY_TYPE_SOVR_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
SOVR Entry Type 1 used for building the template for entering Bulk Positive Input
|
| 32 |
SOVR_VAL_TYPE_1 |
Character(2) |
VARCHAR2(2) NOT NULL |
SOVR Value Type use in build up the Template for Bulk Positive Inpput
|
| 33 |
PIN_SOVR1_SETID |
Number(3,0) |
SMALLINT NOT NULL |
Pin SOVR setid used to build the Template for Bulk Positive Input
|
| 34 |
SETID_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid used to build the Template for entering Bulk Positive Input
|
| 35 |
PIN_SOVR2_NUM |
Number(8,0) |
INTEGER NOT NULL |
SOVR Pin NUmber user to build the template to be used in Bulk Positive Input
|
| 36 |
ENTRY_TYPE_SOVR_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
SOVR Entry Type 1 used for building the template for entering Bulk Positive Input
|
| 37 |
SOVR_VAL_TYPE_2 |
Character(2) |
VARCHAR2(2) NOT NULL |
SOVR Value Type use in build up the Template for Bulk Positive Inpput
|
| 38 |
PIN_SOVR2_SETID |
Number(3,0) |
SMALLINT NOT NULL |
Pin SOVR setid used to build the Template for Bulk Positive Input
|
| 39 |
SETID_2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid used to build the Template for entering Bulk Positive Input
|
| 40 |
PIN_SOVR3_NUM |
Number(8,0) |
INTEGER NOT NULL |
SOVR Pin NUmber user to build the template to be used in Bulk Positive Input
|
| 41 |
ENTRY_TYPE_SOVR_3 |
Character(3) |
VARCHAR2(3) NOT NULL |
SOVR Entry Type 1 used for building the template for entering Bulk Positive Input
|
| 42 |
SOVR_VAL_TYPE_3 |
Character(2) |
VARCHAR2(2) NOT NULL |
SOVR Value Type use in build up the Template for Bulk Positive Inpput
|
| 43 |
PIN_SOVR3_SETID |
Number(3,0) |
SMALLINT NOT NULL |
Pin SOVR setid used to build the Template for Bulk Positive Input
|
| 44 |
SETID_3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid used to build the Template for entering Bulk Positive Input
|
| 45 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 46 |
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
|
| 47 |
CURRENCY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator field related to currency. Initial use on GP Positive Input template configuration to indicate whether end user is allowed to override the currency set on the template when the template is deployed for PI data entry.
|
| 48 |
BU_OVRD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Attribute introduced on PI templates. Used to indicate whether or not Business Unit can be overridden (entered) with data entry.
|
| 49 |
DECIMAL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Controls number of decimals enabled with data entry on GP pages. Our fields generally carry a precision of 12.6. This control field is introduced with the PI template to enable configuration of the number of decimals input when currency code cannot be applied to control the number. [Number may not be amount or may not be associated with a currency code.]
0=No Decimals
1=One Decimal
2=Two Decimals
3=Three Decimals
4=Four Decimals
5=Five Decimals
6=Six Decimals
|
| 50 |
PI_MNL_TMPLT_OVR1C |
Character(2) |
VARCHAR2(2) NOT NULL |
Component field used with Bulk Positive Input template
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 51 |
PI_MNL_TMPLT_OVR2C |
Character(2) |
VARCHAR2(2) NOT NULL |
Component field used with Bulk Positive Input template
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 52 |
PI_MNL_TMPLT_OVR3C |
Character(2) |
VARCHAR2(2) NOT NULL |
Component field used with Bulk Positive Input template
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 53 |
PI_MNL_TMPLT_OVR4C |
Character(2) |
VARCHAR2(2) NOT NULL |
Component field used with Bulk Positive Input template
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 54 |
PI_MNL_TMPLT_OVR5C |
Character(2) |
VARCHAR2(2) NOT NULL |
Component field used with Bulk Positive Input template
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|
| 55 |
PI_MNL_TMPLT_OVR6C |
Character(2) |
VARCHAR2(2) NOT NULL |
Component field used with Bulk Positive Input template
10=Unit
20=Rate
30=Amount
40=Base
50=Percent
|