GP_PYGRP

(SQL Table)
 Index Back

GP Pay Group Definition

GP Pay Group Definition

  • Related Language Record: GP_PYGRP_LANG

  • Parent Record Of GPBR_VAC_CAL_E GPCN_PYGRPD_LNG GPCN_PYGRP_D_VW GPHK_PYGRPD_LNG GPHK_PYGRP_D_VW GPMX_SDI_CAL_E GPMX_VAR_EFFDT GPNZ_PG_DTL_VW GPTH_PYGRP_D_VW GP_NRP_PYGDL_AD GP_PYGRP_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

    Prompt Table: GP_PYENT

    5 START_DT_OPTN_FSCL Character(2) VARCHAR2(2) NOT NULL fiscal start option
    PE=Use Paying Entity Defaults
    SP=Use Specified Start Date

    Default Value: PE

    6 START_MTH_FSCL Character(2) VARCHAR2(2) NOT NULL Fiscal start month
    01=January
    02=February
    03=March
    04=April
    05=May
    06=June
    07=July
    08=August
    09=September
    10=October
    11=November
    12=December
    7 START_DAY_FSCL Number(2,0) SMALLINT NOT NULL fiscal yearly start day
    8 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1