GPCH_RC_PAYROLL

(SQL Table)
 Index Back

Run Control Record for Swiss

Run Control Record for Swiss

  • Parent Record Of GPCH_RC_COMPANY GPCH_RC_DEPT GPCH_RC_EMPLID GPCH_RC_LOC GPCH_RC_PROVIDR GPIT_RC_LOC

    • # 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

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

    Prompt Table: GP_PYENT

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

    Prompt Table: COMPANY_TBL

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

    Prompt Table: GPCH_RC_PYGRPVW

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

    Prompt Table: LOCATION_TBL
    Set Control Field: SETID

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

    Prompt Table: DEPT_TBL
    Set Control Field: SETID

    13 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date

    Prompt Table: GPCH_RP_DATE_VW

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

    Prompt Table: GPCH_RP_DATE_VW

    17 GPCH_BK_GEN_DT Date(10) DATE Generation Date
    18 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
    19 GPCH_RC_AL01_S1 Character(1) VARCHAR2(1) NOT NULL
    C=Company
    D=Deptid
    E=Emplid
    G=PayGroup
    K=Canton
    L=Location
    N=Name
    20 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
    21 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
    22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    23 NAME Character(50) VARCHAR2(50) NOT NULL Name
    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 GPCH_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 GPCH_TX_NUMBER Character(13) VARCHAR2(13) NOT NULL Tax Number
    28 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

    Prompt Table: SRC_BANK

    29 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: GP_CAL_RUN

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

    Prompt Table: GPCH_RC_PRT_SRC

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: DEP_SCHED

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

    Prompt Table: STATE_NAMES_TBL

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

    Prompt Table: GPCH_TX_VILLAGE

    38 GPCH_TX_CANTON_SRT Character(1) VARCHAR2(1) NOT NULL Canton Sort
    C=Canton
    V=Village
    39 GPCH_RC_DESCR1 Character(30) VARCHAR2(30) NOT NULL Signature1
    40 GPCH_RC_DESCR2 Character(30) VARCHAR2(30) NOT NULL Signature2
    41 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

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

    Prompt Table: GP_JRNLGEN_VW

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

    Prompt Table: BUS_UNIT_TBL_HR

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

    Prompt Table: BUS_UNIT_GL_VW

    45 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

    46 ACCOUNTING_DT Date(10) DATE Accounting Date
    47 GPCH_RC_SERIALNR Number(2,0) SMALLINT NOT NULL Represents Serial number for the reports
    48 GPCH_RC_ADJUST_DT Date(10) DATE Use for the report GPCHSI08
    49 GPCH_RC_LST_OPTION Character(1) VARCHAR2(1) NOT NULL Print type
    0=Print Only
    1=Interface Only
    2=Print & Interface

    Default Value: 0

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

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Default Value: CHE

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

    Default Value: C

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

    Prompt Table: GP_PIN_CATEGORY

    60 GPCH_BK_SENDER_ID Character(15) VARCHAR2(15) NOT NULL DP ID Sender
    61 GPCH_BK_PAYER_ID Character(15) VARCHAR2(15) NOT NULL DP ID Payer
    62 GPCH_RC_SKILLED Character(1) VARCHAR2(1) NOT NULL Use for Reporting
    1=Demand
    2=Balanced
    3=Supply
    63 GPCH_RC_TRAINED Character(1) VARCHAR2(1) NOT NULL Use for reporting
    1=Demand
    2=Balanced
    3=Supply
    64 GPCH_RC_UNSKILLED Character(1) VARCHAR2(1) NOT NULL Use for reporting
    1=Demand
    2=Balanced
    3=Supply
    65 GPCH_RC_FORECAST Character(1) VARCHAR2(1) NOT NULL Use for reporting
    1=Positive
    2=Satisfying
    3=Negative
    4=Unknown
    66 GPCH_RC_VACANT Number(6,0) INTEGER NOT NULL Use for reporting
    67 GPCH_RC_BRANCH Number(4,0) SMALLINT NOT NULL Use for reporting
    68 GPCH_RC_WKHOURS Signed Number(6,2) DECIMAL(4,2) NOT NULL Use for reporting
    69 GPCH_RC_COUNT_METH Character(1) VARCHAR2(1) NOT NULL Use For Reporting
    1=Every Employee
    6=Every sixth Employee
    70 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
    E=EO-APG
    71 GPCH_AL_PROVIDER Character(10) VARCHAR2(10) NOT NULL Provider ID

    Prompt Table: GPCH_SI_PROV_VW

    72 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
    73 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

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GPCH_EG_DSET_VW

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

    Prompt Table: GPCH_RCTX02_VW

    87 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