GP_NRP_RSPID_VW

(SQL View)
 Index Back

Result - PI Data - View

This contains PI that was used by a given calendar - Packaging View

SELECT EMPLID ,CAL_RUN_ID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,PIN_NUM + 50000000 ,INSTANCE ,PI_SOURCE ,PI_ACTION_TYPE ,PI_GEN_REF ,ENTRY_TYPE_ID ,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 ,BUSINESS_UNIT ,DESCR ,BAL_ADJ ,ABS_BGN_DT ,ABS_END_DT ,ABS_PRD_BGN_DT ,ABS_PRD_END_DT ,LASTUPDOPRID ,LASTUPDDTTM FROM PS_GP_RSLT_PI_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
9 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
10 PI_SOURCE Character(1) VARCHAR2(1) NOT NULL Positive Input Source
A=Absence
G=Generated PI
M=Manual
T=Time&Labor
11 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
12 PI_GEN_REF Character(15) VARCHAR2(15) NOT NULL PI Generated Reference
13 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 GP_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate
16 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate
17 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate
18 GP_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit
19 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit
20 PIN_UNIT_NUM Number(8,0) INTEGER NOT NULL Pin-Number Unit
21 GP_BASE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base
22 ENTRY_TYPE_BASE Character(3) VARCHAR2(3) NOT NULL entry type base
23 PIN_BASE_NUM Number(8,0) INTEGER NOT NULL PIN-Number Base
24 GP_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Percent
25 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option
26 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element
27 GP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount
28 ENTRY_TYPE_AMT Character(3) VARCHAR2(3) NOT NULL entry type amount
29 PIN_AMT_NUM Number(8,0) INTEGER NOT NULL PIN-Number Amount
30 BGN_DT Date(10) DATE Begin Date
31 END_DT Date(10) DATE end date
32 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
33 DESCR Character(30) VARCHAR2(30) NOT NULL Description
34 BAL_ADJ Signed Number(20,6) DECIMAL(18,6) NOT NULL Balance Adjustment
35 ABS_BGN_DT Date(10) DATE Absence Begin Date
36 ABS_END_DT Date(10) DATE Absence End Date
37 ABS_PRD_BGN_DT Date(10) DATE Absence Period Begin Date
38 ABS_PRD_END_DT Date(10) DATE Absence Period End Date
39 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.
40 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.