GPDE_DV_FLT_BAL

(SQL Table)
Index Back

Flat Balances Table for DEUEV

Flat Balances Table for DEUEV (temporary)

# 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 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
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 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 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
10 SLICE_END_DT Date(10) DATE Element Slice End Date
11 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
13 PRD_END_DT Date(10) DATE Pay Period End Date
14 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
15 BGN_DT Date(10) DATE Begin Date
16 END_DT Date(10) DATE end date
17 GPDE_RP_SIGRSS_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
18 GPDE_RP_SIGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
19 GPDE_RP_SIGRSM_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
20 GPDE_RP_OAPGRS_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
21 GPDE_RP_AZGRS_ANLZ Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
22 GPDE_RP_OAPGRS_MC Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
23 GPDE_RP_MAR_MON Date(10) DATE March Month
24 GPDE_RP_SIDAYS Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
25 GPDE_RP_RV_GZ_FLG Character(1) VARCHAR2(1) NOT NULL Flag Glidezone Calculation Pension Insurance
0=No Glidezone calculation in RV
1=GZ RV btwn 400 and 800 Eur
2=GZ RV under 400 Eur

Default Value: 0