GP_DIAG_PI_VW

(SQL View)
 Index Back

GP Diagnostic- Manual PI

Derivated row to select fields that could be send from customer to PeopleSoft

SELECT GP_PAYGROUP ,CAL_ID ,EMPLID ,EMPL_RCD ,PIN_NUM ,INSTANCE ,ENTRY_TYPE_ID ,PI_ACTION_TYPE ,CURRENCY_CD ,ENTRY_TYPE_RATE ,PIN_RATE_NUM ,ENTRY_TYPE_UNIT ,PIN_UNIT_NUM ,ENTRY_TYPE_BASE ,PIN_BASE_NUM ,ENTRY_TYPE_PCT ,PIN_PCT_NUM ,ENTRY_TYPE_AMT ,PIN_AMT_NUM ,BGN_DT ,END_DT ,BUSINESS_UNIT ,DESCR ,GP_BATCH_CD ,ABS_PRD_BGN_DT ,ABS_PRD_END_DT ,ABS_BGN_DT ,ABS_END_DT FROM PS_GP_PI_MNL_DATA

# 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

Prompt Table: PERS_SRCH_GBL

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_EDIT_FLD1

6 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
7 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

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
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

10 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate

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 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit

Prompt Table: GP_ENT_PIUN_VW

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

Prompt Table: GP_PIN_RCUPI_VW

14 ENTRY_TYPE_BASE Character(3) VARCHAR2(3) NOT NULL entry type base

Prompt Table: GP_ENT_PIBSE_VW

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

Prompt Table: GP_PIN_RCBPI_VW

16 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option

Prompt Table: GP_ENT_PIPCT_VW

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

Prompt Table: GP_PIN_RCPPI_VW

18 ENTRY_TYPE_AMT Character(3) VARCHAR2(3) NOT NULL entry type amount

Prompt Table: GP_ENT_PIAMT_VW

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

Prompt Table: GP_PIN_RCAPI_VW

20 BGN_DT Date(10) DATE Begin Date
21 END_DT Date(10) DATE end date
22 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_HR

23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
24 GP_BATCH_CD Character(10) VARCHAR2(10) NOT NULL The Batch Code will be used to identify a group of positive input.
25 ABS_PRD_BGN_DT Date(10) DATE Absence Period Begin Date
26 ABS_PRD_END_DT Date(10) DATE Absence Period End Date
27 ABS_BGN_DT Date(10) DATE Absence Begin Date
28 ABS_END_DT Date(10) DATE Absence End Date