GP_CF_VW

(SQL View)
 Index Back

GP Chartfields

GP GL Chartfields by Business Unit and Pay Entity

SELECT A.PAY_ENTITY , A.BUSINESS_UNIT , A.EFFDT , %Substring(X.FIELDVALUE, 1, 2) , B.PIN_NUM , B.PIN_NM FROM PS_GP_GL_CHARTFLD A , PS_GP_PIN B , PSXLATITEM X WHERE ( B.PIN_NUM = A.PIN_CHART1_NUM OR B.PIN_NUM = A.PIN_CHART2_NUM OR B.PIN_NUM = A.PIN_CHART3_NUM OR B.PIN_NUM = A.PIN_CHART4_NUM OR B.PIN_NUM = A.PIN_CHART5_NUM OR B.PIN_NUM = A.PIN_CHART6_NUM OR B.PIN_NUM = A.PIN_CHART7_NUM OR B.PIN_NUM = A.PIN_CHART8_NUM ) AND X.FIELDNAME = 'GP_CHFLD_IND' AND ( X.FIELDVALUE = '1' AND B.PIN_NUM = A.PIN_CHART1_NUM OR X.FIELDVALUE = '2' AND B.PIN_NUM = A.PIN_CHART2_NUM OR X.FIELDVALUE = '3' AND B.PIN_NUM = A.PIN_CHART3_NUM OR X.FIELDVALUE = '4' AND B.PIN_NUM = A.PIN_CHART4_NUM OR X.FIELDVALUE = '5' AND B.PIN_NUM = A.PIN_CHART5_NUM OR X.FIELDVALUE = '6' AND B.PIN_NUM = A.PIN_CHART6_NUM OR X.FIELDVALUE = '7' AND B.PIN_NUM = A.PIN_CHART7_NUM OR X.FIELDVALUE = '8' AND B.PIN_NUM = A.PIN_CHART8_NUM )

  • Parent record: GP_GL_CHARTFLD

    • # 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_CHFLD_IND Character(2) VARCHAR2(2) NOT NULL GP Chartfield Indicator
    1=Chartfield 1
    2=Chartfield 2
    3=Chartfield 3
    4=Chartfield 4
    5=Chartfield 5
    6=Chartfield 6
    7=Chartfield 7
    8=Chartfield 8
    5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    6 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field