GPDE_RC_PAYROLL

(SQL Table)
 Index Back

Run Control Table

Run Control Table for Global Payroll

  • Parent Record Of GPDE_AL_XML_LNG GPDE_AL_XML_LOC GPDE_DX_EMPLSEL GPDE_RCRCD_NRVW GPDE_RCTX4LNRVW GPDE_RC_CURRCD GPDE_RC_DEPT GPDE_RC_EMPLID GPDE_RC_LOC GPDE_RC_LOCATN GPDE_RC_LOC_LNG GPDE_RC_PAYGRP GPDE_RC_PYENT GPDE_RC_TX4_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    7 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GP_PYENT

    8 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GPDE_RC_PYGRPVW

    9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    11 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
    12 GPDE_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL For Year
    13 GPDE_RC_FROM_DT Date(10) DATE From Date
    14 GPDE_RC_TO_DT Date(10) DATE To Date
    15 GPDE_IC_RUN_RETRO Character(1) VARCHAR2(1) NOT NULL Retro Processing
    N=Current Period Only
    O=Retro Periods Only
    Y=Retro and Current Period

    Default Value: Y

    16 GPDE_RC_AL01_S1 Character(1) VARCHAR2(1) NOT NULL 1. Sort Criteria
    D=Deptid
    E=Emplid
    G=PayGroup
    L=Location
    N=Name
    P=Pay Entity
    V=Distribution ID
    17 GPDE_RC_AL01_S2 Character(1) VARCHAR2(1) NOT NULL 2. Sort Criteria
    D=Deptid
    E=Emplid
    G=PayGroup
    L=Location
    N=Name
    P=Pay Entity
    V=Distribution ID
    18 GPDE_RC_AL01_S3 Character(1) VARCHAR2(1) NOT NULL 3. Sort Criteria
    D=Deptid
    E=Emplid
    G=PayGroup
    L=Location
    N=Name
    P=Pay Entity
    V=Distribution ID
    19 GPDE_RC_RUN_YEAR Character(1) VARCHAR2(1) NOT NULL Run Year

    Y/N Table Edit

    Default Value: N

    20 GPDE_RC_YR_CLOSE Character(1) VARCHAR2(1) NOT NULL Tax Year Close

    Y/N Table Edit

    Default Value: N

    21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    22 NAME Character(50) VARCHAR2(50) NOT NULL Name
    23 GPDE_RC_EE_TYPE_ST Character(1) VARCHAR2(1) NOT NULL Employee Type
    1=Both
    2=Salaried
    3=Wage Earners
    24 DISKETTE_TYPE Character(1) VARCHAR2(1) NOT NULL Diskette Type
    0=Not Applicable
    1=3.5 Inches High Density
    2=3.5 Inches Double Density
    25 GPDE_AL_RUN_DIR Character(50) VARCHAR2(50) NOT NULL Directory
    26 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code

    Prompt Table: BA_CD_TBL

    27 WC_COUNCIL_ID Character(9) VARCHAR2(9) NOT NULL Works Council ID
    28 GPDE_TX_NUMBER Character(13) VARCHAR2(13) NOT NULL Tax Number
    29 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

    Prompt Table: SRC_BANK

    30 GPDE_RC_MONTH_YEAR Character(1) VARCHAR2(1) NOT NULL Month Year Quarter Salary Structure Report
    M=For Month
    Q=For Quarter
    S=Salary Structure Report
    Y=For Year
    31 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: GP_CAL_RUN

    32 GPDE_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print Class

    Prompt Table: GPDE_RC_PRT_SRC

    33 CAL_SEQ_NUM Number(8,0) INTEGER NOT NULL Calendar Sequence Number
    34 GPDE_BK_XFER_NBR Number(3,0) SMALLINT NOT NULL Transfer Sequence
    35 DEP_SCHED_ID Character(10) VARCHAR2(10) NOT NULL Deposit Schedule

    Prompt Table: DEP_SCHED

    36 GPDE_SI_COVERAGE Character(1) VARCHAR2(1) NOT NULL Insurance Coverage Type
    0=None
    1=Mandatory
    2=Voluntary
    3=Private
    37 GPDE_SI_REGION Character(1) VARCHAR2(1) NOT NULL Region
    0=General
    1=East
    2=West
    38 GPDE_RC_LIMIT_SI09 Signed Number(12,2) DECIMAL(10,2) NOT NULL Reference Value
    39 GPDE_RC_MONTH_FLG Character(1) VARCHAR2(1) NOT NULL Monthly Flag

    Y/N Table Edit

    Default Value: N

    40 GPDE_RC_OPERATORCD Character(1) VARCHAR2(1) NOT NULL Comparative Operator
    G=Display if Greater
    K=Display if Smaller

    Default Value: G

    41 GPDE_BV_COMPANY Character(4) VARCHAR2(4) NOT NULL BVV Company Number
    42 GPDE_RC_PRN_COMP Character(1) VARCHAR2(1) NOT NULL Indicator on the PayBalance report. Determines if the PayEntity report needs to be printed.
    1=Compressed Report
    2=Details Report
    3=Pay Entity Report

    Default Value: 1

    43 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

    Prompt Table: GP_JRNLGEN_VW

    44 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    45 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit

    Prompt Table: BUS_UNIT_GL_VW

    46 GPDE_RC_PRT_SIGN Character(1) VARCHAR2(1) NOT NULL PRINT SIGN
    N=Non Elements in Print Class
    Y=Only Elements in Print Class

    Default Value: Y

    47 ACCOUNTING_DT Date(10) DATE Accounting Date
    48 GPDE_RC_PRINT_CLS Character(8) VARCHAR2(8) NOT NULL Print Class Insurance

    Prompt Table: GPDE_RC_PRT_SRC

    49 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    50 GPDE_RC_CREATE_XML Character(1) VARCHAR2(1) NOT NULL Checkbox to create Tax XML file

    Y/N Table Edit

    Default Value: N

    51 GPDE_RC_PREL_PRINT Character(1) VARCHAR2(1) NOT NULL Preliminary Print checkbox

    Y/N Table Edit

    Default Value: N

    52 GPDE_RC_SEND_XML Character(1) VARCHAR2(1) NOT NULL Checkbox to send Tax XML file

    Y/N Table Edit

    Default Value: N

    53 GPDE_ELSTER_TKT Character(20) VARCHAR2(20) NOT NULL Ticket number returned from ELSTER messaging process representing a particular group of tax statement data sent to ELSTER.
    54 GPDE_AL_ELSTER_TYP Character(4) VARCHAR2(4) NOT NULL Various eGovernment processes
    LSTA=Tax Registration
    LSTB=Tax Statement
    NONE=None
    STAT=Payroll Statistics

    Default Value: NONE

    55 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    56 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    57 TELEPHONE_NBR Character(15) VARCHAR2(15) NOT NULL Telephone Number
    58 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    59 GPDE_AL_DETAIL Character(1) VARCHAR2(1) NOT NULL Detailed Output Selection

    Y/N Table Edit

    Default Value: N

    60 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
    61 GPDE_SS_SPLIT_PDF Character(1) VARCHAR2(1) NOT NULL Germany - Self Service - Flag on Tax Statement page (GPDE_RC_PAYROLL) to indicate split of PDF files created by report is supposed to be done

    Y/N Table Edit

    Default Value: N

    62 GPDE_RC_QUARTER Character(1) VARCHAR2(1) NOT NULL select quarterly salary report
    1=Quarter 1
    2=Quarter 2
    3=Quarter 3
    4=Quarter 4
    63 GPDE_AL_OPRNAME Character(11) VARCHAR2(11) NOT NULL Executing Clerk

    Prompt Table: PERS_SRCH_GBL

    64 GPDE_AL_GENDER Character(1) VARCHAR2(1) NOT NULL gender of an EE
    M=Mr
    W=Mrs
    65 GPDE_AL_CONTACT_NM Character(50) VARCHAR2(50) NOT NULL executing clerk
    66 GPDE_AL_PHONE Character(24) VARCHAR2(24) NOT NULL phone number of an employee

    Prompt Table: GPDE_AL_PH_SRCH

    67 GPDE_AL_FAX Character(24) VARCHAR2(24) NOT NULL Fax number of an employee

    Prompt Table: GPDE_AL_PH_SRCH

    68 GPDE_AL_EMAIL Character(70) VARCHAR2(70) NOT NULL email address of an employee

    Prompt Table: GPDE_AL_EM_SRCH

    69 GPDE_RC_SIGN_XML Character(1) VARCHAR2(1) NOT NULL Sign XML

    Y/N Table Edit