Model View
Table AFRCORG
Object Full Name
Source Code Comments
Columns Comments for AFRCORG_CAMPAIGN (# 1)
Source Code Comments
Columns Comments for AFRCORG_SOLC_CODE (# 2)
Source Code Comments
Columns Comments for AFRCORG_SOL_ORG (# 3)
Source Code Comments
Columns Comments for AFRCORG_INDEX (# 4)
Source Code Comments
Columns Comments for AFRCORG_SEQ_NO (# 5)
Source Code Comments
Columns Comments for AFRCORG_LEVEL (# 6)
Source Code Comments
Columns Comments for AFRCORG_GOAL (# 7)
Source Code Comments
Columns Comments for AFRCORG_ACTIVITY_DATE (# 8)
Source Code Comments
Table AFRCRES
Object Full Name
Source Code Comments
Columns Comments for AFRCRES_CAMPAIGN (# 1)
Source Code Comments
Columns Comments for AFRCRES_SOLC_CODE (# 2)
Source Code Comments
Columns Comments for AFRCRES_SOL_ORG (# 3)
Source Code Comments
Columns Comments for AFRCRES_PIDM (# 4)
Source Code Comments
Columns Comments for AFRCRES_CTYP_SEQ_NO (# 5)
Source Code Comments
Columns Comments for AFRCRES_SEQ_NO (# 6)
Source Code Comments
Columns Comments for AFRCRES_SCNT_CODE (# 7)
Source Code Comments
Columns Comments for AFRCRES_SCRS_CODE (# 8)
Source Code Comments
Columns Comments for AFRCRES_PLEDGE_NO (# 9)
Source Code Comments
Columns Comments for AFRCRES_DATE (# 10)
Source Code Comments
Columns Comments for AFRCRES_ACTIVITY_DATE (# 11)
Source Code Comments
Columns Comments for AFRCRES_USER (# 12)
Source Code Comments
Columns Comments for AFRCRES_GIFT_NO (# 13)
Source Code Comments
Columns Comments for AFRCRES_COMMENT (# 14)
Source Code Comments
Columns Comments for AFRCRES_DCYR_CODE (# 15)
Source Code Comments
Columns Comments for AFRCRES_ASK_AMOUNT (# 16)
Source Code Comments
Table AFRCSLT
Object Full Name
Source Code Comments
Columns Comments for AFRCSLT_CAMPAIGN (# 1)
Source Code Comments
Columns Comments for AFRCSLT_SOLC_CODE (# 2)
Source Code Comments
Columns Comments for AFRCSLT_SOL_ORG (# 3)
Source Code Comments
Columns Comments for AFRCSLT_PIDM (# 4)
Source Code Comments
Columns Comments for AFRCSLT_GOAL (# 5)
Source Code Comments
Columns Comments for AFRCSLT_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for AFRCSLT_REPORT_TO_PIDM (# 7)
Source Code Comments
Columns Comments for AFRCSLT_MAX_CONTACTS (# 8)
Source Code Comments
Columns Comments for AFRCSLT_SSTA_CODE (# 9)
Source Code Comments
Columns Comments for AFRCSLT_SSTA_DATE (# 10)
Source Code Comments
Columns Comments for AFRCSLT_UPD_WEB_IND (# 11)
Source Code Comments
Table AFRCTYP
Object Full Name
Source Code Comments
Columns Comments for AFRCTYP_CAMPAIGN (# 1)
Source Code Comments
Columns Comments for AFRCTYP_SOLC_CODE (# 2)
Source Code Comments
Columns Comments for AFRCTYP_SOL_ORG (# 3)
Source Code Comments
Columns Comments for AFRCTYP_PIDM (# 4)
Source Code Comments
Columns Comments for AFRCTYP_SEQ_NO (# 5)
Source Code Comments
Columns Comments for AFRCTYP_CONSTITUENT_PIDM (# 6)
Source Code Comments
Columns Comments for AFRCTYP_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for AFRCTYP_USER (# 8)
Source Code Comments
Columns Comments for AFRCTYP_RATE_CODE (# 9)
Source Code Comments
Columns Comments for AFRCTYP_RSCR_CODE (# 10)
Source Code Comments
Columns Comments for AFRCTYP_RATER_PIDM (# 11)
Source Code Comments
Columns Comments for AFRCTYP_ASK_AMOUNT (# 12)
Source Code Comments
Columns Comments for AFRCTYP_ASK_DATE (# 13)
Source Code Comments
Columns Comments for AFRCTYP_COMMENT (# 14)
Source Code Comments
Columns Comments for AFRCTYP_ASSIGN_DATE (# 15)
Source Code Comments
Columns Comments for AFRCTYP_DCYR_CODE (# 16)
Source Code Comments
Table AGBPDEF
Object Full Name
Source Code Comments
Columns Comments for AGBPDEF_USER (# 1)
Source Code Comments
Columns Comments for AGBPDEF_CAMPAIGN (# 2)
Source Code Comments
Columns Comments for AGBPDEF_DESG (# 3)
Source Code Comments
Columns Comments for AGBPDEF_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for AGBPDEF_GIFT_CODE (# 5)
Source Code Comments
Columns Comments for AGBPDEF_GCLS_CODE (# 6)
Source Code Comments
Columns Comments for AGBPDEF_GIFT_PLDG_IND (# 7)
Source Code Comments
Columns Comments for AGBPDEF_MATCH_RECEIVED (# 8)
Source Code Comments
Columns Comments for AGBPDEF_PSTA_CODE (# 9)
Source Code Comments
Columns Comments for AGBPDEF_PLDG_CODE (# 10)
Source Code Comments
Columns Comments for AGBPDEF_PCLS_CODE (# 11)
Source Code Comments
Columns Comments for AGBPDEF_PDUR_CODE (# 12)
Source Code Comments
Columns Comments for AGBPDEF_FREQ_CODE (# 13)
Source Code Comments
Columns Comments for AGBPDEF_PRMD_CODE (# 14)
Source Code Comments
Columns Comments for AGBPDEF_DEFAULT_DATE (# 15)
Source Code Comments
Columns Comments for AGBPDEF_SOLC_CODE (# 16)
Source Code Comments
Columns Comments for AGBPDEF_SOL_ORG (# 17)
Source Code Comments
Columns Comments for AGBPDEF_SOL_PIDM (# 18)
Source Code Comments
Columns Comments for AGBPDEF_PCAT_CODE (# 19)
Source Code Comments
Columns Comments for AGBPDEF_CTYP_CODE (# 20)
Source Code Comments
Columns Comments for AGBPDEF_SCNT_CODE (# 21)
Source Code Comments
Columns Comments for AGBPDEF_SCRS_CODE (# 22)
Source Code Comments
Columns Comments for AGBPDEF_PGVE_CODE (# 23)
Source Code Comments
Columns Comments for AGBPDEF_DNAM_CODE (# 24)
Source Code Comments
Table AGBWPLG
Object Full Name
Source Code Comments
Columns Comments for AGBWPLG_PIDM (# 1)
Source Code Comments
Columns Comments for AGBWPLG_AMOUNT (# 2)
Source Code Comments
Columns Comments for AGBWPLG_PLDG_DATE (# 3)
Source Code Comments
Columns Comments for AGBWPLG_CAMPAIGN (# 4)
Source Code Comments
Columns Comments for AGBWPLG_DESG (# 5)
Source Code Comments
Columns Comments for AGBWPLG_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for AGBWPLG_USER (# 7)
Source Code Comments
Columns Comments for AGBWPLG_ACCEPTED_IND (# 8)
Source Code Comments
Columns Comments for AGBWPLG_PLDG_CODE (# 9)
Source Code Comments
Columns Comments for AGBWPLG_PGVE_CODE (# 10)
Source Code Comments
Columns Comments for AGBWPLG_SOLC_CODE (# 11)
Source Code Comments
Columns Comments for AGBWPLG_SOL_ORG (# 12)
Source Code Comments
Columns Comments for AGBWPLG_DCYR_CODE (# 13)
Source Code Comments
Columns Comments for AGBWPLG_SOLICITOR_PIDM (# 14)
Source Code Comments
Columns Comments for AGBWPLG_SPS_SPLIT_IND (# 15)
Source Code Comments
Columns Comments for AGBWPLG_PDUR_CODE (# 16)
Source Code Comments
Columns Comments for AGBWPLG_FREQ_CODE (# 17)
Source Code Comments
Columns Comments for AGBWPLG_BILL_DATE (# 18)
Source Code Comments
Columns Comments for AGBWPLG_COMMENT (# 19)
Source Code Comments
Columns Comments for AGBWPLG_CAMPAIGN_2 (# 20)
Source Code Comments
Columns Comments for AGBWPLG_DESIGNATION_2 (# 21)
Source Code Comments
Columns Comments for AGBWPLG_CAMPAIGN_3 (# 22)
Source Code Comments
Columns Comments for AGBWPLG_DESIGNATION_3 (# 23)
Source Code Comments
Columns Comments for AGBWPLG_SCNT_CODE (# 26)
Source Code Comments
Columns Comments for AGBWPLG_SCRS_CODE (# 27)
Source Code Comments
Columns Comments for AGBWPLG_ASK_AMOUNT (# 28)
Source Code Comments
Columns Comments for AGBWPLG_ASK_DATE (# 29)
Source Code Comments
Columns Comments for AGBWPLG_LETR_CODE (# 30)
Source Code Comments
Columns Comments for AGBWPLG_PLDG_PRMD_CODE (# 31)
Source Code Comments
Columns Comments for AGBWPLG_PINS_PRMD_CODE (# 32)
Source Code Comments
Table AGRGSOL
Object Full Name
Source Code Comments
Columns Comments for AGRGSOL_PIDM (# 1)
Source Code Comments
Columns Comments for AGRGSOL_GIFT_NO (# 2)
Source Code Comments
Columns Comments for AGRGSOL_PLEDGE_NO (# 3)
Source Code Comments
Columns Comments for AGRGSOL_CAMPAIGN (# 4)
Source Code Comments
Columns Comments for AGRGSOL_SOLC_CODE (# 5)
Source Code Comments
Columns Comments for AGRGSOL_SOL_ORG (# 6)
Source Code Comments
Columns Comments for AGRGSOL_SOL_PIDM (# 7)
Source Code Comments
Columns Comments for AGRGSOL_AMT (# 8)
Source Code Comments
Columns Comments for AGRGSOL_ACTIVITY_DATE (# 9)
Source Code Comments
Columns Comments for AGRGSOL_CREDIT_PIDM (# 10)
Source Code Comments
Columns Comments for AGRGSOL_3PP_PLEDGE_NO (# 11)
Source Code Comments
Table AGRMSOL
Object Full Name
Source Code Comments
Columns Comments for AGRMSOL_EMPR_PIDM (# 1)
Source Code Comments
Columns Comments for AGRMSOL_EMPL_PIDM (# 2)
Source Code Comments
Columns Comments for AGRMSOL_GIFT_NO (# 3)
Source Code Comments
Columns Comments for AGRMSOL_CAMPAIGN (# 4)
Source Code Comments
Columns Comments for AGRMSOL_SOLC_CODE (# 5)
Source Code Comments
Columns Comments for AGRMSOL_SOL_ORG (# 6)
Source Code Comments
Columns Comments for AGRMSOL_SOL_PIDM (# 7)
Source Code Comments
Columns Comments for AGRMSOL_AMT (# 8)
Source Code Comments
Columns Comments for AGRMSOL_ACTIVITY_DATE (# 9)
Source Code Comments
Table AGRPSOL
Object Full Name
Source Code Comments
Columns Comments for AGRPSOL_PIDM (# 1)
Source Code Comments
Columns Comments for AGRPSOL_PLEDGE_NO (# 2)
Source Code Comments
Columns Comments for AGRPSOL_CAMPAIGN (# 3)
Source Code Comments
Columns Comments for AGRPSOL_SOLC_CODE (# 4)
Source Code Comments
Columns Comments for AGRPSOL_SOL_ORG (# 5)
Source Code Comments
Columns Comments for AGRPSOL_SOL_PIDM (# 6)
Source Code Comments
Columns Comments for AGRPSOL_AMT (# 7)
Source Code Comments
Columns Comments for AGRPSOL_AMT_PAID (# 8)
Source Code Comments
Columns Comments for AGRPSOL_ACTIVITY_DATE (# 9)
Source Code Comments
Columns Comments for AGRPSOL_CREDIT_PIDM (# 10)
Source Code Comments
Table ASBSORG
Object Full Name
Source Code Comments
Columns Comments for ASBSORG_SOL_ORG (# 1)
Source Code Comments
Columns Comments for ASBSORG_NAME (# 2)
Source Code Comments
Columns Comments for ASBSORG_SOTP_CODE (# 3)
Source Code Comments
Columns Comments for ASBSORG_CONTACT_PIDM (# 4)
Source Code Comments
Columns Comments for ASBSORG_ATYP_CODE (# 5)
Source Code Comments
Columns Comments for ASBSORG_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for ASBSORG_DOLLAR_GOAL (# 7)
Source Code Comments
Columns Comments for ASBSORG_PARTICIPATION_GOAL (# 8)
Source Code Comments
Columns Comments for ASBSORG_DONOR_COUNT_GOAL (# 9)
Source Code Comments
Columns Comments for ASBSORG_SSTA_CODE (# 10)
Source Code Comments
Columns Comments for ASBSORG_SSTA_DATE (# 11)
Source Code Comments
Columns Comments for ASBSORG_COLL_CODE (# 12)
Source Code Comments
Columns Comments for ASBSORG_YEAR (# 13)
Source Code Comments
Columns Comments for ASBSORG_UPD_WEB_IND (# 14)
Source Code Comments
Table ASRCOMT
Object Full Name
Source Code Comments
Columns Comments for ASRCOMT_SOL_ORG (# 1)
Source Code Comments
Columns Comments for ASRCOMT_SEQ_NO (# 2)
Source Code Comments
Columns Comments for ASRCOMT_COMMENT (# 3)
Source Code Comments
Columns Comments for ASRCOMT_ACTIVITY_DATE (# 4)
Source Code Comments
Table ASRCONT
Object Full Name
Source Code Comments
Columns Comments for ASRCONT_SOL_ORG (# 1)
Source Code Comments
Columns Comments for ASRCONT_PIDM (# 2)
Source Code Comments
Columns Comments for ASRCONT_CONT_CODE (# 3)
Source Code Comments
Columns Comments for ASRCONT_CONT_VALUE (# 4)
Source Code Comments
Columns Comments for ASRCONT_ACTIVITY_DATE (# 5)
Source Code Comments
Table ASRCORG
Object Full Name
Source Code Comments
Columns Comments for ASRCORG_SOL_ORG_KEY (# 1)
Source Code Comments
Columns Comments for ASRCORG_SOL_ORG (# 2)
Source Code Comments
Columns Comments for ASRCORG_SOL_ORG_UP (# 3)
Source Code Comments
Columns Comments for ASRCORG_LEVEL (# 4)
Source Code Comments
Columns Comments for ASRCORG_DCYR_CODE (# 5)
Source Code Comments
Columns Comments for ASRCORG_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for ASRCORG_USER (# 7)
Source Code Comments
Table ASRSOAG
Object Full Name
Source Code Comments
Columns Comments for ASRSOAG_SOL_ORG (# 1)
Source Code Comments
Columns Comments for ASRSOAG_DCYR_CODE (# 2)
Source Code Comments
Columns Comments for ASRSOAG_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for ASRSOAG_USER (# 4)
Source Code Comments
Columns Comments for ASRSOAG_DOLLAR_GOAL (# 5)
Source Code Comments
Columns Comments for ASRSOAG_PARTICIPATION_GOAL (# 6)
Source Code Comments
Columns Comments for ASRSOAG_DONOR_COUNT_GOAL (# 7)
Source Code Comments
Table ASRSORG
Object Full Name
Source Code Comments
Columns Comments for ASRSORG_SOL_ORG (# 1)
Source Code Comments
Columns Comments for ASRSORG_PIDM (# 2)
Source Code Comments
Columns Comments for ASRSORG_SOLT_CODE (# 3)
Source Code Comments
Columns Comments for ASRSORG_ATYP_CODE (# 4)
Source Code Comments
Columns Comments for ASRSORG_MAX_CONTACTS (# 5)
Source Code Comments
Columns Comments for ASRSORG_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for ASRSORG_DOLLAR_GOAL (# 7)
Source Code Comments
Columns Comments for ASRSORG_PARTICIPATION_GOAL (# 8)
Source Code Comments
Columns Comments for ASRSORG_DONOR_COUNT_GOAL (# 9)
Source Code Comments
Columns Comments for ASRSORG_SSTA_CODE (# 10)
Source Code Comments
Columns Comments for ASRSORG_SSTA_DATE (# 11)
Source Code Comments
Columns Comments for ASRSORG_UPD_WEB_IND (# 12)
Source Code Comments
Table ASRSSAG
Object Full Name
Source Code Comments
Columns Comments for ASRSSAG_SOL_ORG (# 1)
Source Code Comments
Columns Comments for ASRSSAG_PIDM (# 2)
Source Code Comments
Columns Comments for ASRSSAG_DCYR_CODE (# 3)
Source Code Comments
Columns Comments for ASRSSAG_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for ASRSSAG_USER (# 5)
Source Code Comments
Columns Comments for ASRSSAG_DOLLAR_GOAL (# 6)
Source Code Comments
Columns Comments for ASRSSAG_PARTICIPATION_GOAL (# 7)
Source Code Comments
Columns Comments for ASRSSAG_DONOR_COUNT_GOAL (# 8)
Source Code Comments
Columns Comments for ASRSSAG_REPORT_TO_PIDM (# 9)
Source Code Comments
Columns Comments for ASRSSAG_MAX_CONTACTS (# 10)
Source Code Comments
Table ATVDCYR
Object Full Name
Source Code Comments
Columns Comments for ATVDCYR_CODE (# 1)
Source Code Comments
Columns Comments for ATVDCYR_DESC (# 2)
Source Code Comments
Columns Comments for ATVDCYR_START_DATE (# 3)
Source Code Comments
Columns Comments for ATVDCYR_END_DATE (# 4)
Source Code Comments
Columns Comments for ATVDCYR_ACTIVITY_DATE (# 5)
Source Code Comments
Table ATVSOTP
Object Full Name
Source Code Comments
Columns Comments for ATVSOTP_CODE (# 1)
Source Code Comments
Columns Comments for ATVSOTP_DESC (# 2)
Source Code Comments
Columns Comments for ATVSOTP_ACTIVITY_DATE (# 3)
Source Code Comments
Table ATVSSTA
Object Full Name
Source Code Comments
Columns Comments for ATVSSTA_CODE (# 1)
Source Code Comments
Columns Comments for ATVSSTA_DESC (# 2)
Source Code Comments
Columns Comments for ATVSSTA_ACTIVE_IND (# 3)
Source Code Comments
Columns Comments for ATVSSTA_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for ATVSSTA_USER (# 5)
Source Code Comments
Table AXRMSOL
Object Full Name
Source Code Comments
Columns Comments for AXRMSOL_PIDM (# 1)
Source Code Comments
Columns Comments for AXRMSOL_EMPR_PIDM (# 2)
Source Code Comments
Columns Comments for AXRMSOL_PLEDGE_NO (# 3)
Source Code Comments
Columns Comments for AXRMSOL_CAMPAIGN (# 4)
Source Code Comments
Columns Comments for AXRMSOL_AMT (# 5)
Source Code Comments
Columns Comments for AXRMSOL_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for AXRMSOL_SOLC_CODE (# 7)
Source Code Comments
Columns Comments for AXRMSOL_SOL_ORG (# 8)
Source Code Comments
Columns Comments for AXRMSOL_SOL_PIDM (# 9)
Source Code Comments
Table STVATYP
Object Full Name
Source Code Comments
Columns Comments for STVATYP_CODE (# 1)
Source Code Comments
Columns Comments for STVATYP_DESC (# 2)
Source Code Comments
Columns Comments for STVATYP_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for STVATYP_SYSTEM_REQ_IND (# 4)
Source Code Comments
Columns Comments for STVATYP_TELE_CODE (# 5)
Source Code Comments
Columns Comments for STVATYP_UPDATE_WEB_IND (# 6)
Source Code Comments
Table STVCOLL
Object Full Name
Source Code Comments
Columns Comments for STVCOLL_CODE (# 1)
Source Code Comments
Columns Comments for STVCOLL_DESC (# 2)
Source Code Comments
Columns Comments for STVCOLL_ADDR_STREET_LINE1 (# 3)
Source Code Comments
Columns Comments for STVCOLL_ADDR_STREET_LINE2 (# 4)
Source Code Comments
Columns Comments for STVCOLL_ADDR_STREET_LINE3 (# 5)
Source Code Comments
Columns Comments for STVCOLL_ADDR_CITY (# 6)
Source Code Comments
Columns Comments for STVCOLL_ADDR_STATE (# 7)
Source Code Comments
Columns Comments for STVCOLL_ADDR_COUNTRY (# 8)
Source Code Comments
Columns Comments for STVCOLL_ADDR_ZIP_CODE (# 9)
Source Code Comments
Columns Comments for STVCOLL_ACTIVITY_DATE (# 10)
Source Code Comments
Columns Comments for STVCOLL_SYSTEM_REQ_IND (# 11)
Source Code Comments
Columns Comments for STVCOLL_VR_MSG_NO (# 12)
Source Code Comments
Columns Comments for STVCOLL_STATSCAN_CDE3 (# 13)
Source Code Comments
Columns Comments for STVCOLL_DICD_CODE (# 14)
Source Code Comments
Columns Comments for STVCOLL_HOUSE_NUMBER (# 15)
Source Code Comments
Columns Comments for STVCOLL_ADDR_STREET_LINE4 (# 16)
Source Code Comments
Link between AFRCTYP and AFRCRES
Join Information
Link between ASRSORG and ASRSSAG
Join Information
Link between AFRCTYP and ASRSORG
Join Information
Link between AFRCTYP and AFRCSLT
Join Information
Link between AFRCORG and ASBSORG
Link between AFRCRES and ASBSORG
Link between AFRCSLT and ASBSORG
Link between AFRCTYP and ASBSORG
Link between AGBWPLG and ASBSORG
Link between AGRMSOL and ASBSORG
Link between AGRPSOL and ASBSORG
Link between ASRCOMT and ASBSORG
Link between ASRCONT and ASBSORG
Link between ASRCORG and ASBSORG
Link between ASRSOAG and ASBSORG
Link between ASRSORG and ASBSORG
Link between ASRSSAG and ASBSORG
Link between AXRMSOL and ASBSORG
Link between ASBSORG and ATVSOTP
Link between AFRCSLT and ATVSSTA
Link between ASBSORG and ATVSSTA
Link between ASRSORG and ATVSSTA
Link between AGBPDEF and ASBSORG
Link between AFRCRES and ATVDCYR
Link between AFRCTYP and ATVDCYR
Link between AGBWPLG and ATVDCYR
Link between ASBSORG and ATVDCYR
Link between ASRCORG and ATVDCYR
Link between ASRSOAG and ATVDCYR
Link between ASRSSAG and ATVDCYR
Link between AGRGSOL and ASBSORG
Link between AXRMSOL and AGRPSOL
Join Information
Link between ASBSORG and STVATYP
Link between ASRSORG and STVATYP
Link between ASBSORG and STVCOLL