GPIT_CUD_RUNCTL

(SQL Table)
 Index Back

CUD Run Control

CUD: Previdential Control Report for Italy

  • Parent Record Of GPIT_RC_ESTABID GPIT_RC_PYGRP

    • # 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 GPIT_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print class

    Default Value: KICUD

    Prompt Table: GPIT_RC_PRT_SRC

    5 FROMDATE Date(10) DATE NOT NULL From Date
    6 THRU_DATE Date(10) DATE NOT NULL Thru Date
    7 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GP_PYENT

    8 GPIT_CUD_STAMPA Character(1) VARCHAR2(1) NOT NULL Population for CUD Printing
    0=TFR Not Payed
    1=TFR Payed
    2=All

    Default Value: 2

    9 GPIT_CUD_CRIT1 Character(1) VARCHAR2(1) NOT NULL 1.Criteria 1
    G=PayGroup
    N=Name
    S=Establishment
    Y=Company
    10 GPIT_CUD_CRIT2 Character(1) VARCHAR2(1) NOT NULL 2. Sort Criteria
    G=PayGroup
    N=Name
    S=Establishment
    Y=Company
    11 GPIT_CUD_CRIT3 Character(1) VARCHAR2(1) NOT NULL 3. Sort Criteria
    G=PayGroup
    N=Name
    S=Establishment
    Y=Company
    12 GPIT_CUD_CRIT4 Character(1) VARCHAR2(1) NOT NULL 4. Criteria 4
    G=PayGroup
    N=Name
    S=Establishment
    Y=Company
    13 PRINT_DATE Date(10) DATE Print Date
    14 GPIT_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Used to override data, when required.

    Y/N Table Edit

    Default Value: N

    15 GPIT_SIGNATURE Character(50) VARCHAR2(50) NOT NULL Signature
    16 GPIT_SIGN_FLG Character(1) VARCHAR2(1) NOT NULL Legal Representative

    Y/N Table Edit

    Default Value: N

    17 GPIT_COMPANY Character(1) VARCHAR2(1) NOT NULL Company

    Y/N Table Edit

    Default Value: N