GPDE_RP_SI01_VW

(SQL View)
 Index Back

WA Main Reporting Record

WA Record : Main Reporting Rec

SELECT A.EMPLID ,A.CAL_RUN_ID ,A.EMPL_RCD ,A.GP_PAYGROUP ,A.CAL_ID ,A.ORIG_CAL_RUN_ID ,A.RSLT_SEG_NUM ,A.SEG_END_DT ,A.SLICE_END_DT ,A.SLICE_BGN_DT ,A.SEG_BGN_DT ,A.PRD_END_DT ,A.PRD_BGN_DT ,A.BA_CD ,A.GPDE_SI_L_INC_ERN ,A.GPDE_SI_MINER ,A.GPDE_SI_PROV_MAND ,A.GPDE_DV_SV_CODE ,A.GPDE_DV_EMPL_CAT ,A.GPDE_SI_POS_IN_JOB ,A.GPDE_SI_EDUCATION ,A.GPDE_BA_SCHL_DGR ,A.GPDE_BA_PRF_DGR ,A.GPDE_BA_EMPL_TMP ,A.GPDE_BA_CNTRCT_WRK ,A.GPDE_SI_PENS_APPLI ,A.GPDE_SI_EMPL_MULT ,A.GPDE_SI_EMPL_INSIG ,A.GPDE_SI_PROV_KV ,A.GPDE_SI_PROV_PV ,A.GPDE_SI_PROV_RV ,A.GPDE_SI_PROV_AV ,A.GPDE_SI_PROV_UM ,A.GPDE_RI_PCT1 ,A.GPDE_RI_PCT2 ,A.GPDE_SI_STATUS_KV ,A.GPDE_SI_STATUS_RV ,A.GPDE_SI_STATUS_AV ,A.GPDE_SI_STATUS_PV ,A.GPDE_SIC_REGION ,A.GPDE_SIH_REGION ,A.GPDE_SIP_REGION ,A.GPDE_SIU_REGION ,A.GPDE_SI_CMPINS_1 ,A.GPDE_SI_CMPINS_2 ,A.GPDE_DV_SV_CODE_M ,A.GPDE_SI_PROV_AV_M ,A.GPDE_SI_PROV_KV_M ,A.GPDE_SI_PROV_PV_M ,A.GPDE_SI_PROV_RV_M ,A.GPDE_SI_PROV_UM_M ,A.GPDE_RI_PCT1_MC ,A.GPDE_RI_PCT2_MC ,A.GPDE_RP_MAR_MON ,A.GPDE_SI_CARD_PRES ,A.GPDE_SI_EMPL_TYPE ,A.GPDE_DV_RVNR ,A.GPDE_RP_MARCH_CLS ,A.GPDE_SI_UPROV_ID ,A.GPDE_SI_IS_KVDR ,A.GPDE_SI_REG_MAND ,A.GPDE_RP_RV_GZ_FLG ,A.GPDE_SI_BAEGV ,A.GPDE_SI_PV_CHILD ,A.GPDE_RP_VW_ELIG ,A.GPDE_RP_VW_ELIG_MC ,A.GPDE_VW_MNRBV FROM PS_GPDE_RP_SI01 A WHERE 'N' IN ( SELECT E.GPDE_RETRO_DISP FROM PS_GPDE_AL_EMPLMT E WHERE A.EMPLID = E.EMPLID AND A.EMPL_RCD = E.EMPL_RCD ) OR EXISTS( SELECT 1 FROM PS_GPDE_RP_AL92 B WHERE B.EMPLID=A.EMPLID AND B.CAL_RUN_ID=A.CAL_RUN_ID AND B.EMPL_RCD=A.EMPL_RCD AND B.GP_PAYGROUP=A.GP_PAYGROUP AND B.CAL_ID=A.CAL_ID AND B.ORIG_CAL_RUN_ID=A.ORIG_CAL_RUN_ID AND B.RSLT_SEG_NUM=A.RSLT_SEG_NUM AND (B.GPDE_RP_CHAR01_01='P' OR B.GPDE_RP_CHAR01_02='P' OR B.GPDE_RP_CHAR01_03='P' OR B.GPDE_RP_CHAR01_04='P' OR B.GPDE_RP_CHAR01_05='P' OR B.GPDE_RP_CHAR01_06='P' ))

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    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 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    11 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
    12 PRD_END_DT Date(10) DATE Pay Period End Date
    13 PRD_BGN_DT Date(10) DATE Period Begin Date
    14 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code
    15 GPDE_SI_L_INC_ERN Character(1) VARCHAR2(1) NOT NULL Low Income Earner
    0=No
    1=Yes
    C=Clergy
    D=Disabled
    F=voluntary social year
    K=volutary ecological year
    M=Miner
    N=No
    O=Normal
    16 GPDE_SI_MINER Character(1) VARCHAR2(1) NOT NULL Miners' Social Insurance
    G=Not Applicable
    N=No
    Y=Yes
    17 GPDE_SI_PROV_MAND Character(8) VARCHAR2(8) NOT NULL SI Provider Compulsory
    18 GPDE_DV_SV_CODE Character(4) VARCHAR2(4) NOT NULL DEUEV Contribution Group Code
    19 GPDE_DV_EMPL_CAT Character(3) VARCHAR2(3) NOT NULL Employee Category
    101=Regular SI Taxable
    102=Apprentice
    103=Old-Age Part Time
    104=Consultant
    105=Trainee
    106=Student Trainee
    107=Disabled
    108=Early Retirement
    109=Low Income Earner
    110=Short-Term Employment
    111=EE in Rehabilitation
    112=Family member in agriculture
    113=Part-time Farmer
    114=PT Farmer, seasonal
    116=FEI Compensation Receiver
    118=Casual Worker
    119=Old Age Pensioner
    120=Pretended Freelancer
    190=Insured only for Accident Ins
    900=Public Servant
    901=Managing Partner
    903=Health Insured Pensioner
    910=SI free Employee
    20 GPDE_SI_POS_IN_JOB Character(1) VARCHAR2(1) NOT NULL Position
    0=0 Apprentice
    1=1 Blue Collar, non prof
    2=2 Blue Collar Prof
    3=3 BC Foreman
    4=4 White Collar
    5=5 Disabled
    6=6 Rehabilitation
    7=7 Homeworker;domestic business
    8=8 Part Time < 18 Hrs.
    9=9 Part Time >= 18 Hrs.
    21 GPDE_SI_EDUCATION Character(1) VARCHAR2(1) NOT NULL Education
    0=0 unknown
    1=1General Secondary w/o Prof
    2=2 General Secondary with Prof
    3=3 Gen Univ Entr no Prof Train
    4=4 Gen Univ Entr w/Prof Train
    5=5 Technical College Degree
    6=6 University Degree
    7=7 unknown degree
    22 GPDE_BA_SCHL_DGR Character(1) VARCHAR2(1) NOT NULL SCHOOL DEGREE
    1=Without School Leave certifict
    2=certi of Secondary Education
    3=secondary school levelI certi
    4=gen qual - univ entr/Voc dipl
    9=Certificate not known
    23 GPDE_BA_PRF_DGR Character(1) VARCHAR2(1) NOT NULL PROFESSIONAL DEGREE
    1=without professional educatio
    2=Certificate of accepted profn
    3=Master Craftsman, technican
    4=Bachelor
    5=Mast of Arts/ Dipl/State Exam
    6=Conferal of a Doctorate
    9=Profesionl Education not known
    24 GPDE_BA_EMPL_TMP Character(1) VARCHAR2(1) NOT NULL TEMP EMPLOYMENT
    1=No
    2=Yes
    25 GPDE_BA_CNTRCT_WRK Character(1) VARCHAR2(1) NOT NULL BA CONTRACT WORK
    1=FullTmEmpl-Unlimited Empl Cont
    2=PartTmEmpl-Unlimited Empl Cont
    3=FullTmEmpl-Limited Empl Contrt
    4=PartTmEmpl-Limited Empl Contrt
    26 GPDE_SI_PENS_APPLI Character(1) VARCHAR2(1) NOT NULL Pension Type
    0=No Pension Applic'n/Payments
    1=Pension Application
    2=Partial Disability Pension
    3=General Disability Pension
    4=Retirement Pension
    5=Old Age Part Time Pension
    6=Widow/Orphan Pension
    7=Educational Pension
    8=Miners' Pension
    9=Farmers' Retirement Pension
    27 GPDE_SI_EMPL_MULT Character(1) VARCHAR2(1) NOT NULL Multiple Employment Records
    0=No
    1=Yes
    28 GPDE_SI_EMPL_INSIG Character(1) VARCHAR2(1) NOT NULL Insignificant Employment
    0=Not Insignificant
    1=Insignificant Employment
    2=Short Term Employment
    29 GPDE_SI_PROV_KV Character(8) VARCHAR2(8) NOT NULL Health Insurance Provider
    30 GPDE_SI_PROV_PV Character(8) VARCHAR2(8) NOT NULL Home Care Insurance Provider
    31 GPDE_SI_PROV_RV Character(8) VARCHAR2(8) NOT NULL Pension Insurance Provider
    32 GPDE_SI_PROV_AV Character(8) VARCHAR2(8) NOT NULL Unemployment Insur Provider
    33 GPDE_SI_PROV_UM Character(8) VARCHAR2(8) NOT NULL Unemployment Insur Provider
    34 GPDE_RI_PCT1 Number(6,2) DECIMAL(5,2) NOT NULL Percent
    35 GPDE_RI_PCT2 Number(6,2) DECIMAL(5,2) NOT NULL Percent
    36 GPDE_SI_STATUS_KV Character(1) VARCHAR2(1) NOT NULL Contribution Group
    37 GPDE_SI_STATUS_RV Character(1) VARCHAR2(1) NOT NULL Contribution Group
    38 GPDE_SI_STATUS_AV Character(1) VARCHAR2(1) NOT NULL Contribution Group
    39 GPDE_SI_STATUS_PV Character(1) VARCHAR2(1) NOT NULL Contribution Group
    40 GPDE_SIC_REGION Character(1) VARCHAR2(1) NOT NULL Home Care Insurance Region
    41 GPDE_SIH_REGION Character(1) VARCHAR2(1) NOT NULL Health Insurance Region
    42 GPDE_SIP_REGION Character(1) VARCHAR2(1) NOT NULL Pension Insurance Region
    43 GPDE_SIU_REGION Character(1) VARCHAR2(1) NOT NULL Unemployment Insurance Region
    44 GPDE_SI_CMPINS_1 Character(3) VARCHAR2(3) NOT NULL U1 for Sickness
    00=None
    10=Regular
    11=Increased
    12=Reduced
    45 GPDE_SI_CMPINS_2 Character(3) VARCHAR2(3) NOT NULL U2 for Maternity
    00=None
    20=Regular
    21=Increased
    22=Reduced
    46 GPDE_DV_SV_CODE_M Character(4) VARCHAR2(4) NOT NULL DEUEV Contr Group March Clause
    47 GPDE_SI_PROV_AV_M Character(8) VARCHAR2(8) NOT NULL UI Provider for March Clause
    48 GPDE_SI_PROV_KV_M Character(8) VARCHAR2(8) NOT NULL HI Provider for March Clause
    49 GPDE_SI_PROV_PV_M Character(8) VARCHAR2(8) NOT NULL HCI Provider for March Clause
    50 GPDE_SI_PROV_RV_M Character(8) VARCHAR2(8) NOT NULL PI Provider for March Clause
    51 GPDE_SI_PROV_UM_M Character(8) VARCHAR2(8) NOT NULL Unemployment Insur Provider
    52 GPDE_RI_PCT1_MC Number(6,2) DECIMAL(5,2) NOT NULL Percent
    53 GPDE_RI_PCT2_MC Number(6,2) DECIMAL(5,2) NOT NULL Percent
    54 GPDE_RP_MAR_MON Date(10) DATE March Month
    55 GPDE_SI_CARD_PRES Date(10) DATE SI Card Date Presented
    56 GPDE_SI_EMPL_TYPE Character(20) VARCHAR2(20) NOT NULL Employment Type

    Default Value: JOBCODE_TBL.DESCR

    57 GPDE_DV_RVNR Character(12) VARCHAR2(12) NOT NULL Pension Insurance Number
    58 GPDE_RP_MARCH_CLS Number(2,0) SMALLINT NOT NULL March Clause
    59 GPDE_SI_UPROV_ID Character(8) VARCHAR2(8) NOT NULL Provider ID of Refund Insurance Provider (Umlagekassenbetriebsnummer)
    60 GPDE_SI_IS_KVDR Character(1) VARCHAR2(1) NOT NULL Health Insurance for Pensioners Flag

    Y/N Table Edit

    61 GPDE_SI_REG_MAND Character(1) VARCHAR2(1) NOT NULL Region of mandatory provider
    62 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

    63 GPDE_SI_BAEGV Character(1) VARCHAR2(1) NOT NULL DEUEV Employment Status
    0=Regular Employment
    1=Employed Family Member
    2=Owning Manager
    64 GPDE_SI_PV_CHILD Character(1) VARCHAR2(1) NOT NULL Children for PV Calculation
    65 GPDE_RP_VW_ELIG Number(2,0) SMALLINT NOT NULL March Clause
    66 GPDE_RP_VW_ELIG_MC Number(2,0) SMALLINT NOT NULL March Clause
    67 GPDE_VW_MNRBV Character(17) VARCHAR2(17) NOT NULL Employee's Member ship number for Pension Fund for specific profess ions