GPTH_RPT_G_VW (SQL View)	Index Back
Results Register Guide View Results Register Guide View

GPTH_RPT_G_VW

(SQL View)

Results Register Guide View

SELECT PROCESS_INSTANCE , EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , GP_RPT_KEY , SEG_END_DT , COMPANY , GPTH_SI_BRANCH_NO , SEQ_NUM , OFF_CYCLE , RSLT_VER_NUM , RSLT_REV_NUM , PRD_BGN_DT , PRD_END_DT , SEG_BGN_DT , PYMT_DT , CAL_PRD_ID , COUNTRY , PIN_GROSS_VAL , PIN_NET_VAL , CURRENCY_CD , CUR_RT_TYPE , RUN_TYPE , PYMT_KEY1 , PYMT_KEY2 , PYMT_KEY3 , PYMT_KEY4 , PAY_ENTITY , BUSINESS_UNIT , ESTABID , SETID_DEPT , DEPTID , SETID_LOCATION , LOCATION , PYE_PRC_IND , SEL_STAT , SEL_ACTION , CALC_TYPE , PYE_CALC_STAT , CALC_ACTION , SEG_STATUS , NAME , GPTH_GOV , GPTH_DETAIL_PAGE , GPTH_DOWN_TO_TXT , MAR_STATUS , PRC_ORD_TS FROM PS_GPTH_RPT_G_TMP D /* WHERE D.PRC_ORD_TS=( SELECT MAX(D_ED.PRC_ORD_TS) FROM PS_GPTH_RPT_G_TMP D_ED WHERE D.PROCESS_INSTANCE=D_ED.PROCESS_INSTANCE AND D.EMPLID=D_ED.EMPLID AND D.EMPL_RCD=D_ED.EMPL_RCD)*/ /*Commented whereclause for bug fix 29438276*/

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

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 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key

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

11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

12 GPTH_SI_BRANCH_NO Character(6) VARCHAR2(6) NOT NULL Social Security Branch Number

13 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

14 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

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

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

17 PRD_BGN_DT Date(10) DATE Period Begin Date

18 PRD_END_DT Date(10) DATE Pay Period End Date

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

20 PYMT_DT Date(10) DATE Payment Date

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

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

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

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

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

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

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

28 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

29 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

30 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

31 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

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

33 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

34 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

35 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

36 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

37 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

38 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

39 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

40 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

41 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

42 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

43 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

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

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

46 NAME Character(50) VARCHAR2(50) NOT NULL Name

47 GPTH_GOV Character(1) VARCHAR2(1) NOT NULL This field represents that if the report is an Government report

48 GPTH_DETAIL_PAGE Character(1) VARCHAR2(1) NOT NULL This field represents that if the report need a detail page

49 GPTH_DOWN_TO_TXT Character(1) VARCHAR2(1) NOT NULL This field represents that if the report need a Data Media File

50 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed

51 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
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	GP_RPT_KEY	Character(22)	VARCHAR2(22) NOT NULL	Output Result Key
10	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
12	GPTH_SI_BRANCH_NO	Character(6)	VARCHAR2(6) NOT NULL	Social Security Branch Number
13	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
14	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
15	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
16	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
17	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
18	PRD_END_DT	Date(10)	DATE	Pay Period End Date
19	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
20	PYMT_DT	Date(10)	DATE	Payment Date
21	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
22	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
23	PIN_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
24	PIN_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Net Pay Value
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
26	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
27	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
28	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
29	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
30	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
31	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
32	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
33	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
34	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
35	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
36	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
37	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
38	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
39	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
40	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
41	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
42	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
43	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
44	CALC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Calculate Action C=Calculate R=Calculate and Replace V=Reverse W=Reverse and Replace
45	SEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Segment Status 00=Active in Segment 01=Inactive in Segment
46	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
47	GPTH_GOV	Character(1)	VARCHAR2(1) NOT NULL	This field represents that if the report is an Government report
48	GPTH_DETAIL_PAGE	Character(1)	VARCHAR2(1) NOT NULL	This field represents that if the report need a detail page
49	GPTH_DOWN_TO_TXT	Character(1)	VARCHAR2(1) NOT NULL	This field represents that if the report need a Data Media File
50	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
51	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp