GP_RSLT_PI_A_VW

(SQL View)
 Index Back

View of Absence Entl PI

Global Payroll Absence Entitlement Positive Input view record

SELECT A.EMPLID ,A.EMPL_RCD ,A.CAL_RUN_ID ,A.GP_PAYGROUP ,A.CAL_ID ,A.ORIG_CAL_RUN_ID ,A.RSLT_SEG_NUM ,A.PIN_NUM ,A.INSTANCE ,A.PI_SOURCE ,A.PI_ACTION_TYPE ,A.BAL_ADJ ,A.BGN_DT ,A.END_DT FROM PS_GP_RSLT_PI_DATA A , PS_GP_PYE_PRC_STAT B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.CAL_ID = B.CAL_ID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND A.GP_PAYGROUP = B.GP_PAYGROUP AND B.CALC_TYPE = 'A'

# 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 Record
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
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

Prompt Table: GP_PI_ACTTYP_VW

12 BAL_ADJ Signed Number(20,6) DECIMAL(18,6) NOT NULL Balance Adjustment
13 BGN_DT Date(10) DATE Begin Date
14 END_DT Date(10) DATE end date