GP_SEG_WRK

(SQL Table)
Index Back

Payee Slctn temporary table

Payee Slctn temporary table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CUR_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Current Calendar Run
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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run 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