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 Rcd Nbr

Prompt Table: EMPLMT_SRCH_GBL

3 OVRD_AMT_1A Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
4 OVRD_AMT_1B Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
5 OVRD_AMT_2A Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
6 OVRD_AMT_2B Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
7 OVRD_AMT_3A Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
8 OVRD_AMT_3B Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
9 OVRD_AMT_4A Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
10 OVRD_AMT_4B Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
11 OVRD_AMT_5A Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
12 OVRD_AMT_5B Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
13 OVRD_AMT_6A Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
14 OVRD_AMT_6B Signed Number(17,2) DECIMAL(15,2) NOT NULL Overide amount used in PI Bulk data entry session page, GP_PI_BULK_SSN
15 BEGIN_DT Date(10) DATE Begin Date
16 END_DT Date(10) DATE end date
17 SOVR_VAL_CHAR_1 Character(25) VARCHAR2(25) NOT NULL SOVR Character Value used in Bulk Positive Input
18 SOVR_VAL_NUM_1 Signed Number(20,6) DECIMAL(18,6) NOT NULL SOVR Number Value used to enter Bilk Positive Input
19 SOVR_VAL_DT_1 Date(10) DATE SOVR date use in Bulk Positive Input
20 SOVR_VAL_CHAR_2 Character(25) VARCHAR2(25) NOT NULL SOVR Character Value used in Bulk Positive Input
21 SOVR_VAL_NUM_2 Signed Number(20,6) DECIMAL(18,6) NOT NULL SOVR Number Value used to enter Bilk Positive Input
22 SOVR_VAL_DT_2 Date(10) DATE SOVR date use in Bulk Positive Input
23 SOVR_VAL_CHAR_3 Character(25) VARCHAR2(25) NOT NULL SOVR Character Value used in Bulk Positive Input
24 SOVR_VAL_NUM_3 Signed Number(20,6) DECIMAL(18,6) NOT NULL SOVR Number Value used to enter Bilk Positive Input
25 SOVR_VAL_DT_3 Date(10) DATE SOVR date use in Bulk Positive Input
26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL