AV_ORG_FND_FY

(SQL Table)
Index Back

Organization Foundation Fiscal

Organization Foundation Fiscal Year Information

  • Parent record: AV_ORG_FND_INFO
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: AV_EXT_ORG_SRCH

    2 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    3 AV_VALID_FROM_DT Date(10) DATE From Date
    4 AV_VALID_TO_DT Date(10) DATE To Date
    5 AV_ASSETS_ENT Number(16,2) DECIMAL(15,2) NOT NULL Assets Amount Entry
    6 AV_EXPENSES_ENT Number(16,2) DECIMAL(15,2) NOT NULL Expenses Amount Entry
    7 AV_DISTRIB_ENT Number(16,2) DECIMAL(15,2) NOT NULL Distribution Amount Entry
    8 AV_GRANT_ENT Number(16,2) DECIMAL(15,2) NOT NULL Total Grants Amount Entry
    9 AV_GRANT_HI_ENT Number(16,2) DECIMAL(15,2) NOT NULL Highest Grant Amount Entry
    10 AV_GRANT_LO_ENT Number(16,2) DECIMAL(15,2) NOT NULL Lowest Grant Amount Entry
    11 AV_GRANT_AVG_ENT Number(16,2) DECIMAL(15,2) NOT NULL Average Grant Amount Entry
    12 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: AV_INSTALL_INST.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    13 AV_ASSETS_AMT Number(16,2) DECIMAL(15,2) NOT NULL Assets Amount
    14 AV_EXPENSES_AMT Number(16,2) DECIMAL(15,2) NOT NULL Expenses Amount Base
    15 AV_DISTRIB_AMT Number(16,2) DECIMAL(15,2) NOT NULL Distribution Amount Base
    16 AV_GRANT_AMT Number(16,2) DECIMAL(15,2) NOT NULL Total Grants Amount Base
    17 AV_GRANT_HI_AMT Number(16,2) DECIMAL(15,2) NOT NULL Highest Grant Amount Base
    18 AV_GRANT_LO_AMT Number(16,2) DECIMAL(15,2) NOT NULL Lowest Grant Amount Base
    19 AV_GRANT_AVG_AMT Number(16,2) DECIMAL(15,2) NOT NULL Average Grant Amount Base
    20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: AV_INSTALL_INST.BASE_CURRENCY

    21 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    22 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    23 AV_GRANT_CNT Number(9,0) DECIMAL(9) NOT NULL Foundation Grant Count
    24 AV_DATE Date(10) DATE Date
    25 SRC_DESCR60 Character(60) VARCHAR2(60) NOT NULL expanded Source Desciption Field