GPDE_RP_TX03_4

(SQL Table)
 Index Back

Temp record for PayBalance

Temp record for PayBalance

# 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 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
9 SLICE_END_DT Date(10) DATE Element Slice End Date
10 GPDE_RC_PRT_SIGN Character(1) VARCHAR2(1) NOT NULL PRINT SIGN
N=Non Elements in Print Class
Y=Only Elements in Print Class
11 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
12 PRD_END_DT Date(10) DATE Pay Period End Date
13 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
14 GPDE_DV_SV_CODE Character(4) VARCHAR2(4) NOT NULL DEUEV Contribution Group Code
15 GPDE_FL_CGRP_KV_E Character(1) VARCHAR2(1) NOT NULL Contribution Group
16 GPDE_FL_CGRP_RV_E Character(1) VARCHAR2(1) NOT NULL Contribution Group
17 GPDE_FL_CGRP_AV_E Character(1) VARCHAR2(1) NOT NULL Contribution Group
18 GPDE_FL_CGRP_PV_E Character(1) VARCHAR2(1) NOT NULL Contribution Group
19 GPDE_FL_CGRP_KV_W Character(1) VARCHAR2(1) NOT NULL Contribution Group
20 GPDE_FL_CGRP_RV_W Character(1) VARCHAR2(1) NOT NULL Contribution Group
21 GPDE_FL_CGRP_AV_W Character(1) VARCHAR2(1) NOT NULL Contribution Group
22 GPDE_FL_CGRP_PV_W Character(1) VARCHAR2(1) NOT NULL Contribution Group
23 GPDE_FL_BTNR_EAST Character(8) VARCHAR2(8) NOT NULL Employer SI Number
24 GPDE_FL_BTNR_WEST Character(8) VARCHAR2(8) NOT NULL Employer SI Number
25 GPDE_FL_RP_1S1AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIH Contrib. Stoerfall Eas
26 GPDE_FL_RP_1S1AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIH Contrib. Stoerfall East
27 GPDE_FL_RP_1S1B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIH Gross Stoerfall Region Eas
28 GPDE_FL_RP_1S2AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIC Contrib. Stoerfall East
29 GPDE_FL_RP_1S2AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIC Contrib. Stoerfall East
30 GPDE_FL_RP_1S2B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIC Gross Stoerfall Region Eas
31 GPDE_FL_RP_1S3AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIP Contrib. Stoerfall East
32 GPDE_FL_RP_1S3AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIP Contrib. Stoerfall East
33 GPDE_FL_RP_1S3B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIP Gross Stoerfall Region Eas
34 GPDE_FL_RP_1S4AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIU Contrib. Stoerfall East
35 GPDE_FL_RP_1S4AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIU Contrib. Stoerfall East
36 GPDE_FL_RP_1S4B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIU Gross Stoerfall Region Eas
37 GPDE_FL_RP_2S1AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIH Contrib. Stoerfall West
38 GPDE_FL_RP_2S1AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIH Contrib. Stoerfall West
39 GPDE_FL_RP_2S1B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIH Gross Stoerfall Region Wes
40 GPDE_FL_RP_2S2AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIC Contrib. Stoerfall West
41 GPDE_FL_RP_2S2AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIC Contrib. Stoerfall West
42 GPDE_FL_RP_2S2B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIC Gross Stoerfall Region Wes
43 GPDE_FL_RP_2S3AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIP Contrib. Stoerfall West
44 GPDE_FL_RP_2S3AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIP Contrib. Stoerfall West
45 GPDE_FL_RP_2S3B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIP Gross Stoerfall Region Wes
46 GPDE_FL_RP_2S4AG Signed Number(20,6) DECIMAL(18,6) NOT NULL ER SIU Contrib. Stoerfall West
47 GPDE_FL_RP_2S4AN Signed Number(20,6) DECIMAL(18,6) NOT NULL EE SIU Contrib. Stoerfall West
48 GPDE_FL_RP_2S4B Signed Number(20,6) DECIMAL(18,6) NOT NULL SIU Gross Stoerfall Region Wes
49 GPDE_FL_L001S1_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
50 GPDE_FL_L001S2_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
51 GPDE_FL_L001S3_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
52 GPDE_FL_L001S4_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
53 GPDE_FL_L001S1_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
54 GPDE_FL_L001S2_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
55 GPDE_FL_L001S3_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
56 GPDE_FL_L001S4_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
57 GPDE_FL_RP_L001S1 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIH east
58 GPDE_FL_RP_L001S2 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIC east
59 GPDE_FL_RP_L001S3 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIP east
60 GPDE_FL_RP_L001S4 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIU east
61 GPDE_FL_L002S1_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
62 GPDE_FL_L002S2_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
63 GPDE_FL_L002S3_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
64 GPDE_FL_L002S4_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
65 GPDE_FL_L002S1_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
66 GPDE_FL_L002S2_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
67 GPDE_FL_L002S3_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
68 GPDE_FL_L002S4_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
69 GPDE_FL_RP_L002S1 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIH west
70 GPDE_FL_RP_L002S2 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIC west
71 GPDE_FL_RP_L002S3 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIP west
72 GPDE_FL_RP_L002S4 Signed Number(20,6) DECIMAL(18,6) NOT NULL gross space SIU west
73 GPDE_FL_W001E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
74 GPDE_FL_W001E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
75 GPDE_FL_RP_W001E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Savings balance money east
76 GPDE_FL_W002E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
77 GPDE_FL_W002E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
78 GPDE_FL_RP_W002E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Savings balance money west
79 GPDE_FL_W011E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
80 GPDE_FL_W011E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
81 GPDE_FL_RP_W011E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Savings balance time-units eas
82 GPDE_FL_W012E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
83 GPDE_FL_W012E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
84 GPDE_FL_RP_W012E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Savings balance time-units wes
85 GPDE_FL_W020E0_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
86 GPDE_FL_W020E0_YTD Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
87 GPDE_FL_RP_W020E0 Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
88 GPDE_FL_W001E0_TMP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
89 GPDE_FL_W002E0_TMP Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
90 GPDE_SIP_REGION Character(1) VARCHAR2(1) NOT NULL Pension Insurance Region