GP_PI_MNL_SSN

(SQL Table)
 Index Back

GP PI Bulk Data Entry session

This is a temporary record for use in Bulk PI data entry. It is only used during Bulk PI data entry, it is required to format multiple GP_PI_MNL_DATA rows according to the Template selected for data entry.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: GP_EMP_SEC_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: EMPLMT_SRCH_GBL

3 OVRD_AMT_1A Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
4 OVRD_AMT_1B Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
5 OVRD_VAL_1C Signed Number(20,6) DECIMAL(18,6) NOT NULL Generic numeric value field introduced for bulk PI entry of element component value (base, rate, percent, unit, amount).
6 OVRD_AMT_2A Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
7 OVRD_AMT_2B Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
8 OVRD_VAL_2C Signed Number(20,6) DECIMAL(18,6) NOT NULL Generic numeric value field introduced for bulk PI entry of element component value (base, rate, percent, unit, amount).
9 OVRD_AMT_3A Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
10 OVRD_AMT_3B Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
11 OVRD_VAL_3C Signed Number(20,6) DECIMAL(18,6) NOT NULL Generic numeric value field introduced for bulk PI entry of element component value (base, rate, percent, unit, amount).
12 OVRD_AMT_4A Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
13 OVRD_AMT_4B Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
14 OVRD_VAL_4C Signed Number(20,6) DECIMAL(18,6) NOT NULL Generic numeric value field introduced for bulk PI entry of element component value (base, rate, percent, unit, amount).
15 OVRD_AMT_5A Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
16 OVRD_AMT_5B Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
17 OVRD_VAL_5C Signed Number(20,6) DECIMAL(18,6) NOT NULL Generic numeric value field introduced for bulk PI entry of element component value (base, rate, percent, unit, amount).
18 OVRD_AMT_6A Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
19 OVRD_AMT_6B Signed Number(20,6) DECIMAL(18,6) NOT NULL Override amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
20 OVRD_VAL_6C Signed Number(20,6) DECIMAL(18,6) NOT NULL Generic numeric value field introduced for bulk PI entry of element component value (base, rate, percent, unit, amount).
21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

22 BEGIN_DT Date(10) DATE Begin Date
23 END_DT Date(10) DATE end date
24 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_HR

25 SOVR_VAL_CHAR_1 Character(25) VARCHAR2(25) NOT NULL SOVR Character Value used in Bulk Positive Input

Prompt Table: %GP_EDIT_FLD11

26 SOVR_VAL_NUM_1 Signed Number(20,6) DECIMAL(18,6) NOT NULL SOVR Number Value used to enter Bilk Positive Input
27 SOVR_VAL_DT_1 Date(10) DATE SOVR date use in Bulk Positive Input
28 SOVR_VAL_CHAR_2 Character(25) VARCHAR2(25) NOT NULL SOVR Character Value used in Bulk Positive Input

Prompt Table: %GP_EDIT_FLD12

29 SOVR_VAL_NUM_2 Signed Number(20,6) DECIMAL(18,6) NOT NULL SOVR Number Value used to enter Bilk Positive Input
30 SOVR_VAL_DT_2 Date(10) DATE SOVR date use in Bulk Positive Input
31 SOVR_VAL_CHAR_3 Character(25) VARCHAR2(25) NOT NULL SOVR Character Value used in Bulk Positive Input

Prompt Table: %GP_EDIT_FLD13

32 SOVR_VAL_NUM_3 Signed Number(20,6) DECIMAL(18,6) NOT NULL SOVR Number Value used to enter Bilk Positive Input
33 SOVR_VAL_DT_3 Date(10) DATE SOVR date use in Bulk Positive Input