GPMX_NRP_PMD_VW

(SQL View)
 Index Back

Mass Positive Input NRP

This contains PI Non Rul Package View

SELECT OPRID ,RUN_CNTL_ID ,GP_PAYGROUP ,CAL_ID ,PIN_NUM + 50000000 ,ENTRY_TYPE_ID ,PI_ACTION_TYPE ,CURRENCY_CD ,GP_RATE ,ENTRY_TYPE_RATE ,PIN_RATE_NUM + 50000000 ,GP_UNIT ,ENTRY_TYPE_UNIT ,PIN_UNIT_NUM + 50000000 ,GP_BASE ,ENTRY_TYPE_BASE ,PIN_BASE_NUM + 50000000 ,GP_PCT ,ENTRY_TYPE_PCT ,PIN_PCT_NUM + 50000000 ,GP_AMT ,ENTRY_TYPE_AMT ,PIN_AMT_NUM + 50000000 ,BGN_DT ,END_DT ,ABS_PRD_BGN_DT ,ABS_PRD_END_DT ,ABS_BGN_DT ,ABS_END_DT FROM PS_GPMX_PIMASS_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: GPMX_RC_PI_MASS.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Default Value: GPMX_RC_PI_MASS.RUN_CNTL_ID

3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Default Value: GPMX_RC_PI_MASS.GP_PAYGROUP

Prompt Table: GP_PYGRP_OPR_VW

4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

Default Value: GPMX_RC_PI_MASS.CAL_ID

Prompt Table: GP_PAY_CAL_VW

5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %GP_EDIT_FLD1

6 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

Prompt Table: GP_ENT_E_D_VW

7 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: O

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

9 GP_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate
10 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate

Default Value: 002

Prompt Table: GP_ENT_PIRT_VW

11 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate

Prompt Table: GP_PIN_RCRPI_VW

12 GP_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit
13 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit

Default Value: 002

Prompt Table: GP_ENT_PIUN_VW

14 PIN_UNIT_NUM Number(8,0) INTEGER NOT NULL Pin-Number Unit

Prompt Table: GP_PIN_RCUPI_VW

15 GP_BASE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base
16 ENTRY_TYPE_BASE Character(3) VARCHAR2(3) NOT NULL entry type base

Default Value: 002

Prompt Table: GP_ENT_PIBSE_VW

17 PIN_BASE_NUM Number(8,0) INTEGER NOT NULL PIN-Number Base

Prompt Table: GP_PIN_RCBPI_VW

18 GP_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Percent
19 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option

Default Value: 002

Prompt Table: GP_ENT_PIPCT_VW

20 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element

Prompt Table: GP_PIN_RCPPI_VW

21 GP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount
22 ENTRY_TYPE_AMT Character(3) VARCHAR2(3) NOT NULL entry type amount

Default Value: 002

Prompt Table: GP_ENT_PIAMT_VW

23 PIN_AMT_NUM Number(8,0) INTEGER NOT NULL PIN-Number Amount

Prompt Table: GP_PIN_RCAPI_VW

24 BGN_DT Date(10) DATE Begin Date
25 END_DT Date(10) DATE end date
26 ABS_PRD_BGN_DT Date(10) DATE Absence Period Begin Date
27 ABS_PRD_END_DT Date(10) DATE Absence Period End Date
28 ABS_BGN_DT Date(10) DATE Absence Begin Date
29 ABS_END_DT Date(10) DATE Absence End Date