AV_ORG_FND_INFO

(SQL Table)
 Index Back

Organization Foundation Info

Organization Foundation Information

  • Parent Record Of AV_ORG_FND_BOAR AV_ORG_FND_DEAD AV_ORG_FND_FY AV_ORG_FND_GEO AV_ORG_FND_INT AV_ORG_FND_NTFY AV_ORG_FND_SUP

    • # 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 EXT_ORG_ID_RELATED Character(11) VARCHAR2(11) NOT NULL Related ID

    Prompt Table: AV_EXT_ORG_VW

    3 AV_ESTAB_DT Date(10) DATE Date Established
    4 AV_FND_TYP_CD Character(10) VARCHAR2(10) NOT NULL Foundation Type Code

    Prompt Table: AV_FND_TYP_TBL

    5 CNTC_TYPE_CD Character(6) VARCHAR2(6) NOT NULL Contact Type Code

    Prompt Table: AV_C_AC_CNT_VW

    6 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr

    Prompt Table: ORG_CONTACT

    7 DESCRLONG Long Character CLOB Long Description