GP_PI_MNL_E_VW (SQL View)	Index Back
Manual PI This contains PI entered manually into the system.

GP_PI_MNL_E_VW

(SQL View)

Manual PI

This contains PI entered manually into the system.

SELECT GP_PAYGROUP ,CAL_ID ,EMPLID ,EMPL_RCD ,PIN_NUM ,INSTANCE ,ENTRY_TYPE_ID ,PI_ACTION_TYPE ,CURRENCY_CD ,GP_RATE ,ENTRY_TYPE_RATE ,PIN_RATE_NUM ,GP_UNIT ,ENTRY_TYPE_UNIT ,PIN_UNIT_NUM ,GP_BASE ,ENTRY_TYPE_BASE ,PIN_BASE_NUM ,GP_PCT ,ENTRY_TYPE_PCT ,PIN_PCT_NUM ,GP_AMT ,ENTRY_TYPE_AMT ,PIN_AMT_NUM ,BGN_DT ,END_DT ,BUSINESS_UNIT ,DESCR ,GP_BATCH_CD ,BAL_ADJ ,ABS_PRD_BGN_DT ,ABS_PRD_END_DT ,ABS_BGN_DT ,ABS_END_DT ,LASTUPDOPRID ,LASTUPDDTTM FROM PS_GP_PI_MNL_DATA WHERE ENTRY_TYPE_ID = 'ER0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
Prompt Table: GP_PYGRP

2 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
Prompt Table: GP_PAY_CAL_VW

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GP_PIN_ER0MP_VW

6 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

7 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID
Default Value: ER0
Prompt Table: GP_ENT_E_D_VW

8 PI_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Action Type Positive Input
A=Add
I=Ignore
N=Do Not Process
O=Override
Z=Resolve To Zero
Default Value: Z

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: GP_PYENT_DTL.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

10 GP_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate

11 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate
Default Value: 002
Prompt Table: GP_ENT_PIRT_VW

12 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate
Prompt Table: GP_PIN_RCRPI_VW

13 GP_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit

14 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit
Default Value: 002
Prompt Table: GP_ENT_PIUN_VW

15 PIN_UNIT_NUM Number(8,0) INTEGER NOT NULL Pin-Number Unit
Prompt Table: GP_PIN_RCUPI_VW

16 GP_BASE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base

17 ENTRY_TYPE_BASE Character(3) VARCHAR2(3) NOT NULL entry type base
Default Value: 002
Prompt Table: GP_ENT_PIBSE_VW

18 PIN_BASE_NUM Number(8,0) INTEGER NOT NULL PIN-Number Base
Prompt Table: GP_PIN_RCBPI_VW

19 GP_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Percent

20 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option
Default Value: 002
Prompt Table: GP_ENT_PIPCT_VW

21 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element
Prompt Table: GP_PIN_RCPPI_VW

22 GP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount

23 ENTRY_TYPE_AMT Character(3) VARCHAR2(3) NOT NULL entry type amount
Default Value: 002
Prompt Table: GP_ENT_PIAMT_VW

24 PIN_AMT_NUM Number(8,0) INTEGER NOT NULL PIN-Number Amount
Prompt Table: GP_PIN_RCAPI_VW

25 BGN_DT Date(10) DATE Begin Date

26 END_DT Date(10) DATE end date

27 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

28 DESCR Character(30) VARCHAR2(30) NOT NULL Description

29 GP_BATCH_CD Character(10) VARCHAR2(10) NOT NULL The Batch Code will be used to identify a group of positive input.

30 BAL_ADJ Signed Number(20,6) DECIMAL(18,6) NOT NULL Balance Adjustment

31 ABS_PRD_BGN_DT Date(10) DATE Absence Period Begin Date

32 ABS_PRD_END_DT Date(10) DATE Absence Period End Date

33 ABS_BGN_DT Date(10) DATE Absence Begin Date

34 ABS_END_DT Date(10) DATE Absence End Date

35 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

36 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_PYGRP
2	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id Prompt Table: GP_PAY_CAL_VW
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GP_PIN_ER0MP_VW
6	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
7	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID Default Value: ER0 Prompt Table: GP_ENT_E_D_VW
8	PI_ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Action Type Positive Input A=Add I=Ignore N=Do Not Process O=Override Z=Resolve To Zero Default Value: Z
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: GP_PYENT_DTL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
10	GP_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
11	ENTRY_TYPE_RATE	Character(3)	VARCHAR2(3) NOT NULL	entry type rate Default Value: 002 Prompt Table: GP_ENT_PIRT_VW
12	PIN_RATE_NUM	Number(8,0)	INTEGER NOT NULL	PinNumber Rate Prompt Table: GP_PIN_RCRPI_VW
13	GP_UNIT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit
14	ENTRY_TYPE_UNIT	Character(3)	VARCHAR2(3) NOT NULL	entry type unit Default Value: 002 Prompt Table: GP_ENT_PIUN_VW
15	PIN_UNIT_NUM	Number(8,0)	INTEGER NOT NULL	Pin-Number Unit Prompt Table: GP_PIN_RCUPI_VW
16	GP_BASE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base
17	ENTRY_TYPE_BASE	Character(3)	VARCHAR2(3) NOT NULL	entry type base Default Value: 002 Prompt Table: GP_ENT_PIBSE_VW
18	PIN_BASE_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Base Prompt Table: GP_PIN_RCBPI_VW
19	GP_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Percent
20	ENTRY_TYPE_PCT	Character(3)	VARCHAR2(3) NOT NULL	Entry Pype Percent Option Default Value: 002 Prompt Table: GP_ENT_PIPCT_VW
21	PIN_PCT_NUM	Number(8,0)	INTEGER NOT NULL	Percent to Accum Element Prompt Table: GP_PIN_RCPPI_VW
22	GP_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
23	ENTRY_TYPE_AMT	Character(3)	VARCHAR2(3) NOT NULL	entry type amount Default Value: 002 Prompt Table: GP_ENT_PIAMT_VW
24	PIN_AMT_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Amount Prompt Table: GP_PIN_RCAPI_VW
25	BGN_DT	Date(10)	DATE	Begin Date
26	END_DT	Date(10)	DATE	end date
27	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
28	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
29	GP_BATCH_CD	Character(10)	VARCHAR2(10) NOT NULL	The Batch Code will be used to identify a group of positive input.
30	BAL_ADJ	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Balance Adjustment
31	ABS_PRD_BGN_DT	Date(10)	DATE	Absence Period Begin Date
32	ABS_PRD_END_DT	Date(10)	DATE	Absence Period End Date
33	ABS_BGN_DT	Date(10)	DATE	Absence Begin Date
34	ABS_END_DT	Date(10)	DATE	Absence End Date
35	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
36	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.