AV_MTCH_RULES

(SQL Table)
 Index Back

Org Matching Rules

Org Matching Rules

  • Parent Record Of AV_MTCH_E_G_TYP AV_MTCH_M_G_TYP AV_MTCH_ORG_ALM AV_MTCH_ORG_EMP AV_MTCH_ORG_REQ AV_MTCH_RATIO

    • # 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 LAST_MOD_DT Date(10) DATE Last Modification Date
    3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    4 MTCH_DEADLN_DT Character(5) VARCHAR2(5) NOT NULL Deadline Date
    5 MTCH_DIST_DT Character(5) VARCHAR2(5) NOT NULL Distribution Date
    6 MTCH_DIST_SCHD Character(4) VARCHAR2(4) NOT NULL Distribution Schedule
    ANNU=Annually
    CONT=Continuously
    MNTH=Monthly
    QTLY=Quarterly
    SEMI=Semiannually
    7 MTCH_DNR_INST_TTL Number(16,2) DECIMAL(15,2) NOT NULL Donor/Institution Total
    8 MTCH_DNR_TTL Number(16,2) DECIMAL(15,2) NOT NULL Donor Total
    9 MTCH_DUP_FLG Character(1) VARCHAR2(1) NOT NULL Duplicate Match

    Y/N Table Edit

    10 MTCH_INST_TTL Number(16,2) DECIMAL(15,2) NOT NULL Institution Total
    11 MTCH_ORG_MIN_AMT Number(16,2) DECIMAL(15,2) NOT NULL Minimum Match Amount
    12 MTCH_OVRALL_TTL Number(16,2) DECIMAL(15,2) NOT NULL Overall Total
    13 MTCH_PAY_ELIG_FLG Character(1) VARCHAR2(1) NOT NULL Payroll Eligibility

    Y/N Table Edit

    14 MTCH_RECEIPT Character(4) VARCHAR2(4) NOT NULL Receipts
    BTCH=Periodically
    EACH=Each Gift
    15 MTCH_RSTRCT_CD Character(4) VARCHAR2(4) NOT NULL MG Designation Type
    ANY=Any Eligible
    DONR=Donor's Designation
    OPER=Gen'l Operating Budget
    16 COMMENTS Long Character CLOB Comment