GPFR_DUCCO_NRVW

(SQL View)
 Index Back

Contribution Setup De NPR View

This setup is read via an Array, which populate the Writeable Array used in the Application Engine

SELECT GPFR_PAR3_CONT_FAM , GPFR_DUCS_CON_TYP1 , GPFR_DUCS_CON_TYP2 + 50000000 , GPFR_DUCS_CON_T11 , GPFR_DUCS_CON_T12 , GPFR_DUCS_CON_T21 , GPFR_DUCS_CON_T22 , GPFR_DUCS_ORDER , GPFR_DUCS_CON_ET1 , GPFR_DUCS_CON_DESC , GPFR_DUCS_CON_ET2 , GPFR_DUCS_CON_BASE + 50000000 , GPFR_DUCS_CON_ET3 , GPFR_DUCS_CON_RAT1 + 50000000 , GPFR_DUCS_CON_ET4 , GPFR_DUCS_CON_RAT2 + 50000000 , GPFR_DUCS_CON_ET5 , GPFR_DUCS_CON_RAT3 + 50000000 , GPFR_DUCS_CON_ET6 , GPFR_DUCS_CON_AMT1 + 50000000 , GPFR_DUCS_CON_ET7 , GPFR_DUCS_CON_AMT2 + 50000000 , GPFR_DUCS_CON_ET8 , GPFR_DUCS_CON_FTE1 + 50000000 , GPFR_DUCS_CON_ET9 , GPFR_DUCS_CON_FTE2 + 50000000 , GPFR_DUCS_CON_TRS , GPFR_DUCS_CON_TAT FROM PS_GPFR_DUCS_CONTR

  • Related Language Record: GPFR_DUCSCR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_PAR3_CONT_FAM Character(3) VARCHAR2(3) NOT NULL GPFR: Contribution Family

    Prompt Table: GPFR_DUCS_P3_VW

    2 GPFR_DUCS_CON_TYP1 Character(3) VARCHAR2(3) NOT NULL GPFR: Contribution Type
    3 GPFR_DUCS_CON_TYP2 Number(8,0) INTEGER NOT NULL GPFR: Contribution Type

    Prompt Table: %GP_EDIT_FLD1

    4 GPFR_DUCS_CON_T11 Character(3) VARCHAR2(3) NOT NULL GPFR: Positive Contribution Type 1

    Prompt Table: GPFR_DUCS_PAR4

    5 GPFR_DUCS_CON_T12 Character(3) VARCHAR2(3) NOT NULL GPFR: Negative Contribution Type 1

    Prompt Table: GPFR_DUCS_PAR4

    6 GPFR_DUCS_CON_T21 Character(3) VARCHAR2(3) NOT NULL GPFR: Positive Contribution Type 2

    Prompt Table: GPFR_DUCS_PAR4

    7 GPFR_DUCS_CON_T22 Character(3) VARCHAR2(3) NOT NULL GPFR: Negative Contribution Type 2

    Prompt Table: GPFR_DUCS_PAR4

    8 GPFR_DUCS_ORDER Number(2,0) SMALLINT NOT NULL Order number in the contribution setup
    9 GPFR_DUCS_CON_ET1 Character(3) VARCHAR2(3) NOT NULL GPFR: Contribution Type

    Prompt Table: GPFR_DUCS_PINVW

    10 GPFR_DUCS_CON_DESC Character(30) VARCHAR2(30) NOT NULL GPFR: Description
    11 GPFR_DUCS_CON_ET2 Character(3) VARCHAR2(3) NOT NULL GPFR: Base

    Prompt Table: GPFR_DUCS_PINVW

    12 GPFR_DUCS_CON_BASE Number(8,0) INTEGER NOT NULL GPFR: Pin for Base

    Prompt Table: %GP_EDIT_FLD2

    13 GPFR_DUCS_CON_ET3 Character(3) VARCHAR2(3) NOT NULL GPFR: Employee

    Prompt Table: GPFR_DUCS_PINVW

    14 GPFR_DUCS_CON_RAT1 Number(8,0) INTEGER NOT NULL GPFR: Pin for Employee's Rate

    Prompt Table: %GP_EDIT_FLD3

    15 GPFR_DUCS_CON_ET4 Character(3) VARCHAR2(3) NOT NULL GPFR: Employer

    Prompt Table: GPFR_DUCS_PINVW

    16 GPFR_DUCS_CON_RAT2 Number(8,0) INTEGER NOT NULL GPFR: Pin for Employer's Rate

    Prompt Table: %GP_EDIT_FLD4

    17 GPFR_DUCS_CON_ET5 Character(3) VARCHAR2(3) NOT NULL GPFR: AT

    Prompt Table: GPFR_DUCS_PINVW

    18 GPFR_DUCS_CON_RAT3 Number(8,0) INTEGER NOT NULL GPFR: Pin for AT Rate

    Prompt Table: %GP_EDIT_FLD5

    19 GPFR_DUCS_CON_ET6 Character(3) VARCHAR2(3) NOT NULL GPFR: Employee

    Prompt Table: GPFR_DUCS_PINVW

    20 GPFR_DUCS_CON_AMT1 Number(8,0) INTEGER NOT NULL GPFR: Pin Employee Amount

    Prompt Table: %GP_EDIT_FLD6

    21 GPFR_DUCS_CON_ET7 Character(3) VARCHAR2(3) NOT NULL GPFR: Employer

    Prompt Table: GPFR_DUCS_PINVW

    22 GPFR_DUCS_CON_AMT2 Number(8,0) INTEGER NOT NULL GPFR: Pin Employer Amount

    Prompt Table: %GP_EDIT_FLD7

    23 GPFR_DUCS_CON_ET8 Character(3) VARCHAR2(3) NOT NULL GPFR: Payee FTE

    Prompt Table: GPFR_DUCS_PINVW

    24 GPFR_DUCS_CON_FTE1 Number(8,0) INTEGER NOT NULL GPFR: Payee FTE with no lump

    Prompt Table: %GP_EDIT_FLD8

    25 GPFR_DUCS_CON_ET9 Character(3) VARCHAR2(3) NOT NULL GPFR: Payee FTE, lump sum cont

    Prompt Table: GPFR_DUCS_PINVW

    26 GPFR_DUCS_CON_FTE2 Number(8,0) INTEGER NOT NULL GPFR: payee FTE with lump

    Prompt Table: %GP_EDIT_FLD9

    27 GPFR_DUCS_CON_TRS Character(1) VARCHAR2(1) NOT NULL GPFR: Transportation Contribution

    Y/N Table Edit

    Default Value: N

    28 GPFR_DUCS_CON_TAT Character(1) VARCHAR2(1) NOT NULL DUCS Additional Transportation

    Y/N Table Edit

    Default Value: N