GP_NRP_PYESG_VW

(SQL View)
 Index Back

Payee Segment Status - View

Payee Segment Status - Packaging View

SELECT EMPLID ,CAL_RUN_ID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,RSLT_VER_NUM ,RSLT_REV_NUM ,PYMT_KEY1 ,PYMT_KEY2 ,PYMT_KEY3 ,PYMT_KEY4 ,BUSINESS_UNIT ,SEG_BGN_DT ,SEG_END_DT ,CALC_ACTION ,PYE_CALC_STAT ,GP_CALC_TS ,SEG_STATUS ,PIN_NET_NUM + 50000000 ,PIN_NET_VAL ,PIN_GROSS_NUM + 50000000 ,PIN_GROSS_VAL ,CUR_RT_TYPE ,GP_ASOF_DT_EXG_RT ,FRST_SEG_IND ,LAST_SEG_IND ,SEG_SRC_ID ,PAYMENT_MTHD ,PYMT_ID ,PYMT_NBR FROM PS_GP_PYE_SEG_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_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
9 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
10 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
11 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
12 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
13 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
14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
15 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
16 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
17 CALC_ACTION Character(1) VARCHAR2(1) NOT NULL Calculate Action
C=Calculate
R=Calculate and Replace
V=Reverse
W=Reverse and Replace
18 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
19 GP_CALC_TS DateTime(26) TIMESTAMP Indicates when something (a segment) was calculated
20 SEG_STATUS Character(2) VARCHAR2(2) NOT NULL Segment Status
00=Active in Segment
01=Inactive in Segment
21 PIN_NET_NUM Number(8,0) INTEGER NOT NULL Element number field
22 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
23 PIN_GROSS_NUM Number(8,0) INTEGER NOT NULL Element number field
24 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value
25 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
26 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
27 FRST_SEG_IND Character(1) VARCHAR2(1) NOT NULL First Segment Ind
28 LAST_SEG_IND Character(1) VARCHAR2(1) NOT NULL Last Segment Ind
29 SEG_SRC_ID Character(1) VARCHAR2(1) NOT NULL Segment Source
C=Calculate
I=Identify
30 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
31 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification
32 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number