GPCH_RC_PAYROLL

(SQL Table)
 Index Back

Run Control Record for Swiss

This Run Control table stores information that is required by GP Swiss reporting process.

  • Parent Record Of GPCH_RC_COMPANY GPCH_RC_DEPT GPCH_RC_EMPLID GPCH_RC_GRP_LST GPCH_RC_LOC GPCH_RC_PROVIDR

    • # 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 GPCH_CONTEXT_LANG Character(1) VARCHAR2(1) NOT NULL Context Language Identifier
    N=No
    Y=Yes

    Default Value: N

    5 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
    6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    9 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GP_PYENT

    10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: GPCH_RC_PYGRPVW

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

    Prompt Table: LOCATION_TBL
    Set Control Field: SETID

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

    Prompt Table: DEPT_TBL
    Set Control Field: SETID

    14 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date

    Prompt Table: GPCH_RP_DATE_VW

    15 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
    16 GPCH_RC_FROM_DT Date(10) DATE From Date
    17 GPCH_RC_TO_DT Date(10) DATE To Date

    Prompt Table: GPCH_RP_DATE_VW

    18 GPCH_BK_GEN_DT Date(10) DATE Generation Date
    19 GPCH_IC_RUN_RETRO Character(1) VARCHAR2(1) NOT NULL Retro Processing
    1=With List Salary over limit
    2=Without List Salary over Limit
    3=Only List Salary over Limit
    4=Revision List
    5=Delivery List
    A=Original Month
    B=Most Recent Month
    C=As Of Month
    J=Detail
    K=Normal
    N=Current Period Only
    O=Retro Periods Only
    Y=Retro and Current Period
    20 GPCH_RC_AL01_S1 Character(1) VARCHAR2(1) NOT NULL
    C=Company
    D=Deptid
    E=Emplid
    G=PayGroup
    K=Canton
    L=Location
    N=Name
    21 GPCH_RC_AL01_S2 Character(1) VARCHAR2(1) NOT NULL 2. Sort Criteria
    C=Company
    D=Deptid
    E=Emplid
    G=PayGroup
    K=Canton
    L=Location
    N=Name
    22 GPCH_RC_AL01_S3 Character(1) VARCHAR2(1) NOT NULL 3. Sort Criteria
    C=Company
    D=Deptid
    E=Emplid
    G=PayGroup
    K=Canton
    L=Location
    N=Name
    23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    24 NAME Character(50) VARCHAR2(50) NOT NULL Name
    25 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
    26 GPCH_AL_RUN_DIR Character(50) VARCHAR2(50) NOT NULL Directory
    27 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code

    Prompt Table: BA_CD_TBL

    28 GPCH_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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: GP_CAL_RUN

    31 GPCH_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print Class

    Prompt Table: GPCH_RC_PRT_SRC

    32 GPCH_TX_TARIF Character(2) VARCHAR2(2) NOT NULL Tariff
    33 GPCH_ER_TRF_AREA Character(3) VARCHAR2(3) NOT NULL Tariff Area
    34 GPCH_RC_PRN_COMP Character(1) VARCHAR2(1) NOT NULL Print Company Report

    Y/N Table Edit

    Default Value: N

    35 DEP_SCHED_ID Character(10) VARCHAR2(10) NOT NULL Deposit Schedule

    Prompt Table: DEP_SCHED

    36 GPCH_BK_XFER_NBR Number(3,0) SMALLINT NOT NULL Transfer Sequence
    37 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton

    Prompt Table: STATE_NAMES_TBL

    38 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code

    Prompt Table: POSTAL_CD_CHE

    39 GPCH_TX_CANTON_SRT Character(1) VARCHAR2(1) NOT NULL Canton Sort
    C=Canton
    V=Village
    40 GPCH_RC_DESCR1 Character(30) VARCHAR2(30) NOT NULL Signature1
    41 GPCH_RC_DESCR2 Character(30) VARCHAR2(30) NOT NULL Signature2
    42 GPCH_RC_PRT_TYPE Character(1) VARCHAR2(1) NOT NULL Print type for report GPCHAL03
    0=Print for All
    1=Cantonal Revenue Authorities
    2=Emloyee
    3=Employer

    Default Value: 0

    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 GPCH_RC_PRT_SIGN Character(1) VARCHAR2(1) NOT NULL Print Elements 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 GPCH_RC_SERIALNR Number(2,0) SMALLINT NOT NULL Represents Serial number for the reports
    49 GPCH_RC_ADJUST_DT Date(10) DATE Use for the report GPCHSI08
    50 GPCH_RC_LST_OPTION Character(1) VARCHAR2(1) NOT NULL Print type
    0=Print Only
    1=Interface Only
    2=Print & Interface

    Default Value: 0

    51 GPCH_RC_AHV_AMNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Represents AHV amount for the report GPCHSI08
    52 GPCH_RC_ALV1_AMNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Represents ALV1 amount for the report GPCHSI08
    53 GPCH_RC_ALV2_AMNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Represents ALV2 amount for the report GPCHSI08
    54 GPCH_TX_CROSS_TYPE Character(1) VARCHAR2(1) NOT NULL Crosser Type

    Default Value: N

    55 GPCH_RC_FINAL_PR Character(1) VARCHAR2(1) NOT NULL Final Print Option for Tax Statement

    Y/N Table Edit

    Default Value: N

    56 GPCH_RC_CLOSE_OPT Character(1) VARCHAR2(1) NOT NULL Include Closed Tax Statement Option

    Default Value: N

    57 GPCH_RC_YEAR_OPT Character(1) VARCHAR2(1) NOT NULL Option for Reports

    Y/N Table Edit

    Default Value: Y

    58 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: CHE

    59 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
    A=All Countries
    C=Specific Country

    Default Value: C

    60 PIN_CATEGORY Character(4) VARCHAR2(4) NOT NULL Element Category

    Prompt Table: GP_PIN_CATEGORY

    61 GPCH_BK_SENDER_ID Character(15) VARCHAR2(15) NOT NULL DP ID Sender
    62 GPCH_BK_PAYER_ID Character(15) VARCHAR2(15) NOT NULL DP ID Payer
    63 GPCH_RC_SKILLED Character(1) VARCHAR2(1) NOT NULL Use for Reporting
    1=Demand
    2=Balanced
    3=Supply
    64 GPCH_RC_TRAINED Character(1) VARCHAR2(1) NOT NULL Use for reporting
    1=Demand
    2=Balanced
    3=Supply
    65 GPCH_RC_UNSKILLED Character(1) VARCHAR2(1) NOT NULL Use for reporting
    1=Demand
    2=Balanced
    3=Supply
    66 GPCH_RC_FORECAST Character(1) VARCHAR2(1) NOT NULL Use for reporting
    1=Positive
    2=Satisfying
    3=Negative
    4=Unknown
    67 GPCH_RC_VACANT Number(6,0) INTEGER NOT NULL Use for reporting
    68 GPCH_RC_BRANCH Number(4,0) SMALLINT NOT NULL Use for reporting
    69 GPCH_RC_WKHOURS Signed Number(6,2) DECIMAL(4,2) NOT NULL Use for reporting
    70 GPCH_RC_COUNT_METH Character(1) VARCHAR2(1) NOT NULL Use For Reporting
    1=Every Employee
    6=Every sixth Employee
    71 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
    0=Identify
    1=Others
    2=UVG-LAA
    3=KTG-AMC
    4=UVGZ-LAAC
    5=FAK-CAF
    6=BVG-LPP
    7=AHV-AVS
    8=LAW-CDS
    9=BFS-OFS
    A=QST-IS
    B=Write File
    C=Base AL08
    D=GRFI-FRFI
    E=EO-APG
    I=BNK_BNQ
    72 GPCH_AL_PROVIDER Character(10) VARCHAR2(10) NOT NULL Provider ID

    Prompt Table: GPCH_SI_PROV_VW

    73 GPCH_RC_TX6_PRT Character(1) VARCHAR2(1) NOT NULL Salary structure analysis select each or every 6th EE
    A=Print Pin Name Only
    B=Print Pin Descr Only
    C=Print Pin Nm and Descr
    74 GPCH_FK_QUARTER Character(1) VARCHAR2(1) NOT NULL Canton select quarterly FAK report
    1=Quarter 1
    2=Quarter 2
    3=Quarter 3
    4=Quarter 4

    Default Value: 1

    75 GPCH_RC_EO_SRT Character(1) VARCHAR2(1) NOT NULL Sort field for EO Report
    A=AHV Number
    E=Emplid
    N=Name
    76 GPCH_RC_MULTI_PSLP Character(1) VARCHAR2(1) NOT NULL Multiple Payslip check box.

    Y/N Table Edit

    Default Value: N

    77 GPCH_BK_PYMNT_TYPE Character(1) VARCHAR2(1) NOT NULL Bank Payment Type
    D=DTA
    L=LSV
    P=Postfinance(EPO)
    78 GPCH_BK_USE_IBAN Character(1) VARCHAR2(1) NOT NULL Use IBAN
    79 GPCH_BK_USE_BKIBAN Character(1) VARCHAR2(1) NOT NULL Use Beneficiary's IBAN
    80 GPCH_BK_USE_IBIBAN Character(1) VARCHAR2(1) NOT NULL Use Beneficiary's IBAN
    81 GPCH_BK_USE_IIBAN Character(1) VARCHAR2(1) NOT NULL Use IBAN
    82 GPCH_BK_INT_XFER Character(1) VARCHAR2(1) NOT NULL International Transfer
    83 GPCH_BK_DOM_XFER Character(1) VARCHAR2(1) NOT NULL Domestic Transfer
    84 FILE_OUTPUT_DIR Character(127) VARCHAR2(127) NOT NULL Output Directory Name for Flat File Interfaces.
    85 GPCH_EG_YEP_FLG Character(1) VARCHAR2(1) NOT NULL Flag to check whether the Reports are Run from Year End Dashboard
    86 GPCH_EG_DOMAINID Number(3,0) SMALLINT NOT NULL Domain Set ID for the ELM Domain Sets

    Prompt Table: GPCH_EG_DST_DVW

    87 GPCH_TX_DOMAINID Number(3,0) SMALLINT NOT NULL Domainid for source tax page

    Prompt Table: GPCH_RCTX02_VW

    88 GPCH_AL_PRINT_DTTM Character(1) VARCHAR2(1) NOT NULL Print Time Stamp for Payslip
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    89 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List

    Prompt Table: GP_GRP_LIST_VW

    90 GPCH_EG_VERSION Character(4) VARCHAR2(4) NOT NULL Swissdec Version Number
    2=Version 4.0
    5=Version 5.0