GP_NRP_PPS_VW (SQL View)	Index Back
pkg vw for PYE PRC STAT Packager view for Payee Process Status record needed for field PIN ELEM GRP NUM

GP_NRP_PPS_VW

(SQL View)

pkg vw for PYE PRC STAT

Packager view for Payee Process Status record needed for field PIN ELEM GRP NUM

SELECT EMPLID ,CAL_RUN_ID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_VER_NUM ,RSLT_REV_NUM ,PRIOR_VER_NUM ,PRIOR_REV_NUM ,PRC_ORD_TS ,PRD_TYPE ,PYE_PRC_IND ,SEL_STAT ,SEL_ACTION ,SEL_RSN ,CURRENCY_CD ,RUN_TYPE ,CAL_PRD_ID ,PRD_BGN_DT ,PRD_END_DT ,PRC_BGN_DT ,PRC_END_DT ,PAY_ENTITY ,PYMT_DT ,COUNTRY ,RTO_PRC_ID ,CALC_TYPE ,PRIOR_MAX_SEG_NUM ,RTO_MTHD_CHG_IND ,RTO_MTHD_CHG_DT ,CALC_FROM_DT ,CALC_THRU_DT ,GP_TX_TYPE ,GP_CORR_TYPE ,GP_NO_REG_RES_IND ,PIN_ELEM_GRP_NUM + 50000000 FROM PS_GP_PYE_PRC_STAT

# 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_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number

8 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number

9 PRIOR_VER_NUM Number(4,0) SMALLINT NOT NULL Version Number

10 PRIOR_REV_NUM Number(4,0) SMALLINT NOT NULL Revision Number

11 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

12 PRD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
C=Current
R=Retro

13 PYE_PRC_IND Character(1) VARCHAR2(1) NOT NULL Enables user to indicate type of (re) processing to be done on the results for any given payee within a processed calendar group
C=Cancel
F=Freeze
N=Normal
R=Re-Calculate
S=Suspend
U=Uncancel
W=Unfreeze

14 SEL_STAT Character(1) VARCHAR2(1) NOT NULL Indicates status of the selected payee in a Calendar Group As they are identified payees are pulled in either as Active or Inactive based on the EMPL_STATUS. The system or the user can remove a payee either permanently or temporarily for various reasons. These are indicated by the status values other than Active and Inactive.
A=Active
C=Cancelled
I=Inactive
S=System Suspend
U=User Suspend

15 SEL_ACTION Character(1) VARCHAR2(1) NOT NULL Select Action
A=Retro Add
C=Current Calculation
R=Retro Recalc
V=Retro Reversal
Z=Retro Rvr & Recalc

16 SEL_RSN Character(2) VARCHAR2(2) NOT NULL Selection Reason: Indicates why a payee was picked up and processed in a given calendar
01=On Payee List - Active
02=On Payee List - Inactive
03=Active and has PI
04=Active and has Rto Trgr
05=Active in Paygroup
06=Inactive and has PI
07=Inactive and has Rto Trgr
08=Inactive and has Rto Adj
09=Inactive and has Trgt Rto Adj
0A=Calendar Override - Active
0B=Calendar Override - Inactive
20=Absence Forecast

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

18 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

19 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID

20 PRD_BGN_DT Date(10) DATE Period Begin Date

21 PRD_END_DT Date(10) DATE Pay Period End Date

22 PRC_BGN_DT Date(10) DATE The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.

23 PRC_END_DT Date(10) DATE The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.

24 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

25 PYMT_DT Date(10) DATE Payment Date

26 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

27 RTO_PRC_ID Character(10) VARCHAR2(10) NOT NULL Retro Process Definition ID

28 CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation
B=All Calculations
P=Payroll Calculation

29 PRIOR_MAX_SEG_NUM Number(4,0) SMALLINT NOT NULL Prior Max Seg Number

30 RTO_MTHD_CHG_IND Character(1) VARCHAR2(1) NOT NULL Retro Method Change Indicator

31 RTO_MTHD_CHG_DT Date(10) DATE Retro Method Change Date

32 CALC_FROM_DT Date(10) DATE Calculate From Date. Used to aid in calculating only a partial pay period

33 CALC_THRU_DT Date(10) DATE Calculate Thru Date

34 GP_TX_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance. XLAT values are assigned to support batch processing order
A=Advance
M=Manual Payment
R=Correction
U=Additional Payment

35 GP_CORR_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies type of correction requested (in offcycle). See Translate values for set of types
N=Normal retro
R=Replacement
V=Reversal - Normal retro
W=Reversal - Replacement
Y=Year end adjustment

36 GP_NO_REG_RES_IND Character(1) VARCHAR2(1) NOT NULL Used to indicate that no element resolution is to take place except the processing of retro adjustment and PI. Introduced with Offcycle
Default Value: N

37 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group

#	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_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
8	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
9	PRIOR_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Version Number
10	PRIOR_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Revision Number
11	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
12	PRD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Period Type C=Current R=Retro
13	PYE_PRC_IND	Character(1)	VARCHAR2(1) NOT NULL	Enables user to indicate type of (re) processing to be done on the results for any given payee within a processed calendar group C=Cancel F=Freeze N=Normal R=Re-Calculate S=Suspend U=Uncancel W=Unfreeze
14	SEL_STAT	Character(1)	VARCHAR2(1) NOT NULL	Indicates status of the selected payee in a Calendar Group As they are identified payees are pulled in either as Active or Inactive based on the EMPL_STATUS. The system or the user can remove a payee either permanently or temporarily for various reasons. These are indicated by the status values other than Active and Inactive. A=Active C=Cancelled I=Inactive S=System Suspend U=User Suspend
15	SEL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Select Action A=Retro Add C=Current Calculation R=Retro Recalc V=Retro Reversal Z=Retro Rvr & Recalc
16	SEL_RSN	Character(2)	VARCHAR2(2) NOT NULL	Selection Reason: Indicates why a payee was picked up and processed in a given calendar 01=On Payee List - Active 02=On Payee List - Inactive 03=Active and has PI 04=Active and has Rto Trgr 05=Active in Paygroup 06=Inactive and has PI 07=Inactive and has Rto Trgr 08=Inactive and has Rto Adj 09=Inactive and has Trgt Rto Adj 0A=Calendar Override - Active 0B=Calendar Override - Inactive 20=Absence Forecast
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
19	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
20	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
21	PRD_END_DT	Date(10)	DATE	Pay Period End Date
22	PRC_BGN_DT	Date(10)	DATE	The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.
23	PRC_END_DT	Date(10)	DATE	The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.
24	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
25	PYMT_DT	Date(10)	DATE	Payment Date
26	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
27	RTO_PRC_ID	Character(10)	VARCHAR2(10) NOT NULL	Retro Process Definition ID
28	CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Process Type. Identifies a run as either absence run or payroll run A=Absence Calculation B=All Calculations P=Payroll Calculation
29	PRIOR_MAX_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Prior Max Seg Number
30	RTO_MTHD_CHG_IND	Character(1)	VARCHAR2(1) NOT NULL	Retro Method Change Indicator
31	RTO_MTHD_CHG_DT	Date(10)	DATE	Retro Method Change Date
32	CALC_FROM_DT	Date(10)	DATE	Calculate From Date. Used to aid in calculating only a partial pay period
33	CALC_THRU_DT	Date(10)	DATE	Calculate Thru Date
34	GP_TX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance. XLAT values are assigned to support batch processing order A=Advance M=Manual Payment R=Correction U=Additional Payment
35	GP_CORR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies type of correction requested (in offcycle). See Translate values for set of types N=Normal retro R=Replacement V=Reversal - Normal retro W=Reversal - Replacement Y=Year end adjustment
36	GP_NO_REG_RES_IND	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate that no element resolution is to take place except the processing of retro adjustment and PI. Introduced with Offcycle Default Value: N
37	PIN_ELEM_GRP_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number for Element Group