GP_RSLT_SEG_VW (SQL View)	Index Back
Results Segment View Results Segment View

GP_RSLT_SEG_VW

(SQL View)

Results Segment View

SELECT A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , A.PRC_ORD_TS , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , B.RSLT_SEG_NUM , B.RSLT_VER_NUM , B.RSLT_REV_NUM , B.SEG_BGN_DT , B.SEG_END_DT , B.SEG_STATUS , A.SEL_STAT , B.PYE_CALC_STAT , B.CALC_ACTION , A.RUN_TYPE , A.CALC_TYPE , A.CAL_PRD_ID , A.PRD_BGN_DT , A.PRD_END_DT , A.PYMT_DT , A.PAY_ENTITY , B.PYMT_KEY1 , B.PYMT_KEY2 , B.PYMT_KEY3 , B.PYMT_KEY4 , B.PIN_GROSS_VAL , B.PIN_NET_VAL , B.CUR_RT_TYPE , A.COUNTRY , A.CURRENCY_CD , B.GP_CALC_TS , B.GP_ASOF_DT_EXG_RT , ASG.PER_ORG , ASG.POI_TYPE , B.PYMT_ID , B.PYMT_NBR , A.GP_TX_TYPE , A.GP_CORR_TYPE FROM PS_GP_PYE_PRC_STAT A , PS_GP_PYE_SEG_STAT B , PS_PER_ORG_ASGN ASG WHERE A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EMPLID = ASG.EMPLID AND A.EMPL_RCD = ASG.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID

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

4 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID

8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number

9 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number

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

11 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date

12 SEG_END_DT Date(10) DATE Payee Process Segment's End Date

13 SEG_STATUS Character(2) VARCHAR2(2) NOT NULL Segment Status
00=Active in Segment
01=Inactive in Segment

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 PYE_CALC_STAT Character(2) VARCHAR2(2) NOT NULL Calculation Status: field indicates the processing status of a segment (payment)
00=Identified
02=Calculation Error
03=Calculation Error - Bypassed
04=Calculation Error - By Rule
11=No Segment Created
50=Calculation Successful
55=Frozen For Further Calc
70=Finalized
75=Finalized - With Banking

16 CALC_ACTION Character(1) VARCHAR2(1) NOT NULL Calculate Action
C=Calculate
R=Calculate and Replace
V=Reverse
W=Reverse and Replace

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

18 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

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 PYMT_DT Date(10) DATE Payment Date

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

24 PYMT_KEY1 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number

25 PYMT_KEY2 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number

26 PYMT_KEY3 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number

27 PYMT_KEY4 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number

28 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

29 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value

30 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

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

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

33 GP_CALC_TS DateTime(26) TIMESTAMP Indicates when something (a segment) was calculated

34 GP_ASOF_DT_EXG_RT Character(1) VARCHAR2(1) NOT NULL This field is used as a flag to determine whether to use a default exchange rate or not.
B=Pay Period Begin Date
E=Pay Period End Date
P=Payment Date

35 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

36 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
Prompt Table: POI_TYPE_TBL

37 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification

38 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number

39 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

40 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

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
8	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
9	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
10	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
11	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
12	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
13	SEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Segment Status 00=Active in Segment 01=Inactive in Segment
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	PYE_CALC_STAT	Character(2)	VARCHAR2(2) NOT NULL	Calculation Status: field indicates the processing status of a segment (payment) 00=Identified 02=Calculation Error 03=Calculation Error - Bypassed 04=Calculation Error - By Rule 11=No Segment Created 50=Calculation Successful 55=Frozen For Further Calc 70=Finalized 75=Finalized - With Banking
16	CALC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Calculate Action C=Calculate R=Calculate and Replace V=Reverse W=Reverse and Replace
17	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
18	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
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	PYMT_DT	Date(10)	DATE	Payment Date
23	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
24	PYMT_KEY1	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
25	PYMT_KEY2	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
26	PYMT_KEY3	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
27	PYMT_KEY4	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
28	PIN_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
29	PIN_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Net Pay Value
30	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
31	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
32	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
33	GP_CALC_TS	DateTime(26)	TIMESTAMP	Indicates when something (a segment) was calculated
34	GP_ASOF_DT_EXG_RT	Character(1)	VARCHAR2(1) NOT NULL	This field is used as a flag to determine whether to use a default exchange rate or not. B=Pay Period Begin Date E=Pay Period End Date P=Payment Date
35	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
36	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS. Prompt Table: POI_TYPE_TBL
37	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification
38	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
39	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
40	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