GP_PYE_MSG_VW

(SQL View)
 Index Back

Global Payroll Payee Status

This record displays payee status information from the GP_PYE_PRC_STAT and GP_PYE_SEG_STAT

SELECT DISTINCT A.EMPLID ,' ' , A.MESSAGE_SEQ , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.RSLT_SEG_NUM , B.PYE_CALC_STAT , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.GP_MSG_SEVERITY , A.MSG_PGM_NM , A.MSG_PARA_NM , A.MSGDATA1 , A.MSGDATA2 , A.MSGDATA3 , A.MSGDATA4 , A.MSGDATA5 , A.PIN_IND1 , A.PIN_IND2 , A.PIN_IND3 , A.PIN_IND4 , A.PIN_IND5 , ' ' FROM PS_GP_MESSAGES A ,PS_GP_PYE_SEG_STAT B WHERE A.EMPLID=B.EMPLID (+) AND A.CAL_RUN_ID=B.CAL_RUN_ID (+) AND A.EMPL_RCD=B.EMPL_RCD (+) AND A.GP_PAYGROUP=B.GP_PAYGROUP (+) AND A.CAL_ID=B.CAL_ID (+) AND A.RSLT_SEG_NUM=B.RSLT_SEG_NUM (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 MESSAGE_SEQ Number(9,0) DECIMAL(9) NOT NULL Message Sequence
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Employee Record Number
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 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
10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
12 GP_MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity. Shows the severity of a message after a calculation. Stored in GP_MESSAGES
E=Error
W=Warning
13 MSG_PGM_NM Character(8) VARCHAR2(8) NOT NULL Program Name
14 MSG_PARA_NM Character(30) VARCHAR2(30) NOT NULL Paragraph Name
15 MSGDATA1 Character(30) VARCHAR2(30) NOT NULL Message Data
16 MSGDATA2 Character(30) VARCHAR2(30) NOT NULL Message Data
17 MSGDATA3 Character(30) VARCHAR2(30) NOT NULL Message Data
18 MSGDATA4 Character(30) VARCHAR2(30) NOT NULL Message Data
19 MSGDATA5 Character(30) VARCHAR2(30) NOT NULL Message Data
20 PIN_IND1 Character(1) VARCHAR2(1) NOT NULL Is Number a PIN number
21 PIN_IND2 Character(1) VARCHAR2(1) NOT NULL Is Number a PIN number
22 PIN_IND3 Character(1) VARCHAR2(1) NOT NULL Is Number a PIN number
23 PIN_IND4 Character(1) VARCHAR2(1) NOT NULL Is Number a PIN number
24 PIN_IND5 Character(1) VARCHAR2(1) NOT NULL Is Number a PIN number
25 MESSAGE_TEXT_WRK Character(250) VARCHAR2(250) NOT NULL Message Text