GP_NRP_PIGDT_VW

(SQL View)
 Index Back

Generated PI Data - View

This contains entries for generated (non-manual) PI - Packaging View

SELECT EMPLID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,SRC_CAL_ID ,PI_VER_NUM ,SRC_CAL_RUN_ID ,PIN_NUM + 50000000 ,PI_SOURCE ,GEN_INSTANCE ,END_DT ,BGN_DT ,TIME_INPUT_NBR ,ENTRY_TYPE_ID ,PI_ACTION_TYPE ,CURRENCY_CD ,RATE_ASOF_DATE ,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 ,BUSINESS_UNIT ,DESCR ,ABS_PRD_BGN_DT ,ABS_PRD_END_DT ,ABS_BGN_DT ,ABS_END_DT ,BNDL_GRP_TAG ,PIN_TK_NUM + 50000000 ,PIN_PARENT_TK_NUM + 50000000 FROM PS_GP_PI_GEN_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
5 SRC_CAL_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar ID
6 PI_VER_NUM Number(3,0) SMALLINT NOT NULL PI version number
7 SRC_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar Run ID
8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
9 PI_SOURCE Character(1) VARCHAR2(1) NOT NULL Positive Input Source
A=Absence
G=Generated PI
M=Manual
T=Time&Labor
10 GEN_INSTANCE Number(3,0) SMALLINT NOT NULL Instance of Generated PI
11 END_DT Date(10) DATE end date
12 BGN_DT Date(10) DATE Begin Date
13 TIME_INPUT_NBR Number(15,0) DECIMAL(15) NOT NULL Contains data from SEQ_NBR in TL_PAYABLE_TIME. Must be kept in sync if the TL field every changes its format.
14 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID
15 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
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 RATE_ASOF_DATE Date(10) DATE As Of Date for PI Rate
18 GP_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate
19 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate
20 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate
21 GP_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit
22 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit
23 PIN_UNIT_NUM Number(8,0) INTEGER NOT NULL Pin-Number Unit
24 GP_BASE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base
25 ENTRY_TYPE_BASE Character(3) VARCHAR2(3) NOT NULL entry type base
26 PIN_BASE_NUM Number(8,0) INTEGER NOT NULL PIN-Number Base
27 GP_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Percent
28 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option
29 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element
30 GP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount
31 ENTRY_TYPE_AMT Character(3) VARCHAR2(3) NOT NULL entry type amount
32 PIN_AMT_NUM Number(8,0) INTEGER NOT NULL PIN-Number Amount
33 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
34 DESCR Character(30) VARCHAR2(30) NOT NULL Description
35 ABS_PRD_BGN_DT Date(10) DATE Absence Period Begin Date
36 ABS_PRD_END_DT Date(10) DATE Absence Period End Date
37 ABS_BGN_DT Date(10) DATE Absence Begin Date
38 ABS_END_DT Date(10) DATE Absence End Date
39 BNDL_GRP_TAG Character(10) VARCHAR2(10) NOT NULL Bundle Group Tag
40 PIN_TK_NUM Number(8,0) INTEGER NOT NULL Element number field
41 PIN_PARENT_TK_NUM Number(8,0) INTEGER NOT NULL Element number field