GP_GL_CHARTFLD

(SQL Table)
 Index Back

GL Chartfields

GL Chartfields Effective Dated Level

  • Parent Record Of GP_CF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 GP_COMBO_CODE Character(1) VARCHAR2(1) NOT NULL Combo code Options
    N=Not Used
    O=Optional
    R=Required

    Default Value: N

    5 PIN_CHART1_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    6 PIN_CHART2_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    7 PIN_CHART3_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    8 PIN_CHART4_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    9 PIN_CHART5_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    10 PIN_CHART6_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    11 PIN_CHART7_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    12 PIN_CHART8_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    13 PIN_CHART9_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    14 PIN_CHART10_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    15 PIN_CHART11_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    16 PIN_CHART12_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    17 PIN_CHART13_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    18 PIN_CHART14_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    19 PIN_CHART15_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    20 PIN_CHART16_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    21 PIN_CHART17_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    22 PIN_CHART18_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    23 PIN_CHART19_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    24 PIN_CHART20_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW

    25 PIN_CHART21_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: GP_PIN_CHART_VW