Model View
Table APBCONS
Source Code Comments
Columns Comments for APBCONS_PIDM (# 1)
Source Code Comments
Columns Comments for APBCONS_PREF_LAST_NAME (# 2)
Source Code Comments
Columns Comments for APBCONS_PREF_FIRST_NAME (# 3)
Source Code Comments
Columns Comments for APBCONS_PREF_MI (# 4)
Source Code Comments
Columns Comments for APBCONS_NICKNAME (# 5)
Source Code Comments
Columns Comments for APBCONS_GRAD_NAME (# 6)
Source Code Comments
Columns Comments for APBCONS_PARENTS_NAME (# 7)
Source Code Comments
Columns Comments for APBCONS_MAIDEN_LAST_NAME (# 8)
Source Code Comments
Columns Comments for APBCONS_PREF_CLAS (# 9)
Source Code Comments
Columns Comments for APBCONS_COLL_CODE_PREF (# 10)
Source Code Comments
Columns Comments for APBCONS_HOME_CITY (# 11)
Source Code Comments
Columns Comments for APBCONS_STAT_CODE_HOME (# 12)
Source Code Comments
Columns Comments for APBCONS_NATN_CODE_HOME (# 13)
Source Code Comments
Columns Comments for APBCONS_CM_NAME (# 14)
Source Code Comments
Columns Comments for APBCONS_ATYP_CODE_CM (# 15)
Source Code Comments
Columns Comments for APBCONS_DOTT_CODE (# 16)
Source Code Comments
Columns Comments for APBCONS_INCM_CODE (# 17)
Source Code Comments
Columns Comments for APBCONS_ATYP_CODE_PREF (# 18)
Source Code Comments
Columns Comments for APBCONS_ADDR_NAME (# 19)
Source Code Comments
Columns Comments for APBCONS_ACTIVITY_DATE (# 20)
Source Code Comments
Columns Comments for APBCONS_ATYP_CODE_GEOR (# 21)
Source Code Comments
Columns Comments for APBCONS_SOCIETY_NAME (# 22)
Source Code Comments
Columns Comments for APBCONS_DATA_ORIGIN (# 23)
Source Code Comments
Table APRACYR
Source Code Comments
Columns Comments for APRACYR_PIDM (# 1)
Source Code Comments
Columns Comments for APRACYR_SACT_CODE (# 2)
Source Code Comments
Columns Comments for APRACYR_YEAR (# 3)
Source Code Comments
Columns Comments for APRACYR_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for APRACYR_ACTC_CODE (# 5)
Source Code Comments
Table APRADEG
Source Code Comments
Columns Comments for APRADEG_PIDM (# 1)
Source Code Comments
Columns Comments for APRADEG_SEQ_NO (# 2)
Source Code Comments
Columns Comments for APRADEG_SBGI_CODE (# 3)
Source Code Comments
Columns Comments for APRADEG_DEGC_CODE (# 4)
Source Code Comments
Columns Comments for APRADEG_DATE (# 5)
Source Code Comments
Columns Comments for APRADEG_HONR_CODE (# 6)
Source Code Comments
Columns Comments for APRADEG_COLL_CODE (# 7)
Source Code Comments
Columns Comments for APRADEG_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for APRADEG_ACYR_CODE (# 9)
Source Code Comments
Columns Comments for APRADEG_ACYR_CODE_BULLETIN (# 10)
Source Code Comments
Columns Comments for APRADEG_CAMP_CODE (# 11)
Source Code Comments
Columns Comments for APRADEG_DEPT_CODE (# 12)
Source Code Comments
Columns Comments for APRADEG_COMMENTS (# 13)
Source Code Comments
Columns Comments for APRADEG_MAJR_CODE_MINR_1 (# 14)
Source Code Comments
Columns Comments for APRADEG_MAJR_CODE_MINR_2 (# 15)
Source Code Comments
Columns Comments for APRADEG_MAJR_CODE_CONC_1 (# 16)
Source Code Comments
Columns Comments for APRADEG_MAJR_CODE_CONC_2 (# 17)
Source Code Comments
Columns Comments for APRADEG_MAJR_CODE_CONC_3 (# 18)
Source Code Comments
Columns Comments for APRADEG_MAJR_CODE_CONC_4 (# 19)
Source Code Comments
Columns Comments for APRADEG_MAJR_CODE_CONC_5 (# 20)
Source Code Comments
Columns Comments for APRADEG_MAJR_CODE_CONC_6 (# 21)
Source Code Comments
Columns Comments for APRADEG_DEPT_CODE_2 (# 22)
Source Code Comments
Columns Comments for APRADEG_HONR_CODE_2 (# 23)
Source Code Comments
Columns Comments for APRADEG_HONR_CODE_3 (# 24)
Source Code Comments
Columns Comments for APRADEG_HONR_CODE_4 (# 25)
Source Code Comments
Columns Comments for APRADEG_HONR_CODE_5 (# 26)
Source Code Comments
Columns Comments for APRADEG_HOND_CODE_1 (# 27)
Source Code Comments
Columns Comments for APRADEG_HOND_CODE_2 (# 28)
Source Code Comments
Columns Comments for APRADEG_HOND_CODE_3 (# 29)
Source Code Comments
Columns Comments for APRADEG_HOND_CODE_4 (# 30)
Source Code Comments
Columns Comments for APRADEG_HOND_CODE_5 (# 31)
Source Code Comments
Columns Comments for APRADEG_OK_FOR_NOTES_IND (# 32)
Source Code Comments
Columns Comments for APRADEG_DISP_NOTES_IND (# 33)
Source Code Comments
Columns Comments for APRADEG_DISP_NOTES_DATE (# 34)
Source Code Comments
Columns Comments for APRADEG_USER (# 35)
Source Code Comments
Columns Comments for APRADEG_REVIEWED_IND (# 36)
Source Code Comments
Columns Comments for APRADEG_REVIEWED_USER (# 37)
Source Code Comments
Columns Comments for APRADEG_MAJOR_COMMENT (# 38)
Source Code Comments
Table APRCHIS
Source Code Comments
Columns Comments for APRCHIS_PIDM (# 1)
Source Code Comments
Columns Comments for APRCHIS_CAMPAIGN (# 2)
Source Code Comments
Columns Comments for APRCHIS_FISC_CODE (# 3)
Source Code Comments
Columns Comments for APRCHIS_AMT_PLEDGED (# 4)
Source Code Comments
Columns Comments for APRCHIS_AMT_PLEDGED_PAID (# 5)
Source Code Comments
Columns Comments for APRCHIS_AMT_GIFT (# 6)
Source Code Comments
Columns Comments for APRCHIS_AMT_MEMO (# 7)
Source Code Comments
Columns Comments for APRCHIS_ACTIVITY_DATE (# 8)
Source Code Comments
Table APRCHLD
Source Code Comments
Columns Comments for APRCHLD_PIDM (# 1)
Source Code Comments
Columns Comments for APRCHLD_SEQ_NO (# 2)
Source Code Comments
Columns Comments for APRCHLD_LAST_NAME (# 3)
Source Code Comments
Columns Comments for APRCHLD_FIRST_NAME (# 4)
Source Code Comments
Columns Comments for APRCHLD_MI (# 5)
Source Code Comments
Columns Comments for APRCHLD_SEX (# 6)
Source Code Comments
Columns Comments for APRCHLD_BIRTH_DATE (# 7)
Source Code Comments
Columns Comments for APRCHLD_SSN (# 8)
Source Code Comments
Columns Comments for APRCHLD_ATYP_CODE (# 9)
Source Code Comments
Columns Comments for APRCHLD_ACTIVITY_DATE (# 10)
Source Code Comments
Columns Comments for APRCHLD_XREF_CODE (# 11)
Source Code Comments
Columns Comments for APRCHLD_CHLD_PIDM (# 12)
Source Code Comments
Columns Comments for APRCHLD_DISP_WEB_IND (# 13)
Source Code Comments
Columns Comments for APRCHLD_DECEASED_IND (# 14)
Source Code Comments
Columns Comments for APRCHLD_DECEASED_DATE (# 15)
Source Code Comments
Columns Comments for APRCHLD_OK_FOR_NOTES_IND (# 16)
Source Code Comments
Columns Comments for APRCHLD_DISP_NOTES_IND (# 17)
Source Code Comments
Columns Comments for APRCHLD_DISP_NOTES_DATE (# 18)
Source Code Comments
Columns Comments for APRCHLD_USER (# 19)
Source Code Comments
Columns Comments for APRCHLD_REVIEWED_IND (# 20)
Source Code Comments
Columns Comments for APRCHLD_REVIEWED_USER (# 21)
Source Code Comments
Columns Comments for APRCHLD_COMMENT (# 22)
Source Code Comments
Table APRCSPS
Source Code Comments
Columns Comments for APRCSPS_PIDM (# 1)
Source Code Comments
Columns Comments for APRCSPS_MARS_IND (# 2)
Source Code Comments
Columns Comments for APRCSPS_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for APRCSPS_SPS_PIDM (# 4)
Source Code Comments
Columns Comments for APRCSPS_LAST_NAME (# 5)
Source Code Comments
Columns Comments for APRCSPS_FIRST_NAME (# 6)
Source Code Comments
Columns Comments for APRCSPS_MAIDEN_NAME (# 7)
Source Code Comments
Columns Comments for APRCSPS_NAME_PREFIX (# 8)
Source Code Comments
Columns Comments for APRCSPS_NAME_SUFFIX (# 9)
Source Code Comments
Columns Comments for APRCSPS_BIRTH_DATE (# 10)
Source Code Comments
Columns Comments for APRCSPS_SPS_COMMENT (# 11)
Source Code Comments
Columns Comments for APRCSPS_MRTL_CODE (# 12)
Source Code Comments
Columns Comments for APRCSPS_MRTL_START_DATE (# 13)
Source Code Comments
Columns Comments for APRCSPS_MRTL_END_DATE (# 14)
Source Code Comments
Columns Comments for APRCSPS_DEAD_IND (# 15)
Source Code Comments
Columns Comments for APRCSPS_DEAD_DATE (# 16)
Source Code Comments
Columns Comments for APRCSPS_XREF_CODE (# 17)
Source Code Comments
Columns Comments for APRCSPS_MI (# 18)
Source Code Comments
Table APRDHIS
Source Code Comments
Columns Comments for APRDHIS_PIDM (# 1)
Source Code Comments
Columns Comments for APRDHIS_DESG (# 2)
Source Code Comments
Columns Comments for APRDHIS_FISC_CODE (# 3)
Source Code Comments
Columns Comments for APRDHIS_AMT_PLEDGED (# 4)
Source Code Comments
Columns Comments for APRDHIS_AMT_PLEDGED_PAID (# 5)
Source Code Comments
Columns Comments for APRDHIS_AMT_GIFT (# 6)
Source Code Comments
Columns Comments for APRDHIS_AMT_MEMO (# 7)
Source Code Comments
Columns Comments for APRDHIS_ACTIVITY_DATE (# 8)
Source Code Comments
Table APREHIS
Source Code Comments
Columns Comments for APREHIS_PIDM (# 1)
Source Code Comments
Columns Comments for APREHIS_SEQ_NO (# 2)
Source Code Comments
Columns Comments for APREHIS_EMPR_NAME (# 3)
Source Code Comments
Columns Comments for APREHIS_JOBC_CODE (# 4)
Source Code Comments
Columns Comments for APREHIS_EMPL_POSITION (# 5)
Source Code Comments
Columns Comments for APREHIS_FROM_DATE (# 6)
Source Code Comments
Columns Comments for APREHIS_TO_DATE (# 7)
Source Code Comments
Columns Comments for APREHIS_EMPR_PIDM (# 8)
Source Code Comments
Columns Comments for APREHIS_EMPR_ID (# 9)
Source Code Comments
Columns Comments for APREHIS_ACTIVITY_DATE (# 10)
Source Code Comments
Columns Comments for APREHIS_SICC_CODE (# 11)
Source Code Comments
Columns Comments for APREHIS_XREF_CODE (# 12)
Source Code Comments
Columns Comments for APREHIS_EMPS_CODE (# 13)
Source Code Comments
Columns Comments for APREHIS_WKLY_HOURS (# 14)
Source Code Comments
Columns Comments for APREHIS_USER (# 15)
Source Code Comments
Columns Comments for APREHIS_PRIMARY_IND (# 16)
Source Code Comments
Columns Comments for APREHIS_ATYP_CODE (# 17)
Source Code Comments
Columns Comments for APREHIS_ATYP_SEQNO (# 18)
Source Code Comments
Columns Comments for APREHIS_JOBC_CODE2 (# 19)
Source Code Comments
Columns Comments for APREHIS_JOBC_CODE3 (# 20)
Source Code Comments
Columns Comments for APREHIS_JOBC_CODE4 (# 21)
Source Code Comments
Columns Comments for APREHIS_OK_FOR_NOTES_IND (# 22)
Source Code Comments
Columns Comments for APREHIS_DISP_NOTES_IND (# 23)
Source Code Comments
Columns Comments for APREHIS_DISP_NOTES_DATE (# 24)
Source Code Comments
Columns Comments for APREHIS_MG_IND (# 25)
Source Code Comments
Columns Comments for APREHIS_REVIEWED_IND (# 26)
Source Code Comments
Columns Comments for APREHIS_REVIEWED_USER (# 27)
Source Code Comments
Columns Comments for APREHIS_COMMENT (# 28)
Source Code Comments
Table ASRSSAG
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 ATVDOTT
Source Code Comments
Columns Comments for ATVDOTT_CODE (# 1)
Source Code Comments
Columns Comments for ATVDOTT_DESC (# 2)
Source Code Comments
Columns Comments for ATVDOTT_ACTIVITY_DATE (# 3)
Source Code Comments
Table ATVINCM
Source Code Comments
Columns Comments for ATVINCM_CODE (# 1)
Source Code Comments
Columns Comments for ATVINCM_DESC (# 2)
Source Code Comments
Columns Comments for ATVINCM_ACTIVITY_DATE (# 3)
Source Code Comments
Table SPRADDR
Source Code Comments
Columns Comments for SPRADDR_PIDM (# 1)
Source Code Comments
Columns Comments for SPRADDR_ATYP_CODE (# 2)
Source Code Comments
Columns Comments for SPRADDR_SEQNO (# 3)
Source Code Comments
Columns Comments for SPRADDR_FROM_DATE (# 4)
Source Code Comments
Columns Comments for SPRADDR_TO_DATE (# 5)
Source Code Comments
Columns Comments for SPRADDR_STREET_LINE1 (# 6)
Source Code Comments
Columns Comments for SPRADDR_STREET_LINE2 (# 7)
Source Code Comments
Columns Comments for SPRADDR_STREET_LINE3 (# 8)
Source Code Comments
Columns Comments for SPRADDR_CITY (# 9)
Source Code Comments
Columns Comments for SPRADDR_STAT_CODE (# 10)
Source Code Comments
Columns Comments for SPRADDR_ZIP (# 11)
Source Code Comments
Columns Comments for SPRADDR_CNTY_CODE (# 12)
Source Code Comments
Columns Comments for SPRADDR_NATN_CODE (# 13)
Source Code Comments
Columns Comments for SPRADDR_PHONE_AREA (# 14)
Source Code Comments
Columns Comments for SPRADDR_PHONE_NUMBER (# 15)
Source Code Comments
Columns Comments for SPRADDR_PHONE_EXT (# 16)
Source Code Comments
Columns Comments for SPRADDR_STATUS_IND (# 17)
Source Code Comments
Columns Comments for SPRADDR_ACTIVITY_DATE (# 18)
Source Code Comments
Columns Comments for SPRADDR_USER (# 19)
Source Code Comments
Columns Comments for SPRADDR_ASRC_CODE (# 20)
Source Code Comments
Columns Comments for SPRADDR_DELIVERY_POINT (# 21)
Source Code Comments
Columns Comments for SPRADDR_CORRECTION_DIGIT (# 22)
Source Code Comments
Columns Comments for SPRADDR_CARRIER_ROUTE (# 23)
Source Code Comments
Columns Comments for SPRADDR_GST_TAX_ID (# 24)
Source Code Comments
Columns Comments for SPRADDR_REVIEWED_IND (# 25)
Source Code Comments
Columns Comments for SPRADDR_REVIEWED_USER (# 26)
Source Code Comments
Columns Comments for SPRADDR_DATA_ORIGIN (# 27)
Source Code Comments
Table SPRIDEN
Source Code Comments
Impact job : SPRIDEN_LAST_NAME SPRIDEN_LAST_NAME
Impact job : ln_spriden_first_name New Job
Impact job : ln_spriden_last_name New Job
Columns Comments for SPRIDEN_PIDM (# 1)
Source Code Comments
Columns Comments for SPRIDEN_ID (# 2)
Source Code Comments
Columns Comments for SPRIDEN_LAST_NAME (# 3)
Source Code Comments
Columns Comments for SPRIDEN_FIRST_NAME (# 4)
Source Code Comments
Columns Comments for SPRIDEN_MI (# 5)
Source Code Comments
Columns Comments for SPRIDEN_CHANGE_IND (# 6)
Source Code Comments
Columns Comments for SPRIDEN_ENTITY_IND (# 7)
Source Code Comments
Columns Comments for SPRIDEN_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for SPRIDEN_USER (# 9)
Source Code Comments
Columns Comments for SPRIDEN_ORIGIN (# 10)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_LAST_NAME (# 11)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_FIRST_NAME (# 12)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_MI (# 13)
Source Code Comments
Columns Comments for SPRIDEN_SOUNDEX_LAST_NAME (# 14)
Source Code Comments
Columns Comments for SPRIDEN_SOUNDEX_FIRST_NAME (# 15)
Source Code Comments
Columns Comments for SPRIDEN_NTYP_CODE (# 16)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_USER (# 17)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_DATE (# 18)
Source Code Comments
Columns Comments for SPRIDEN_DATA_ORIGIN (# 19)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_FDMN_CODE (# 20)
Source Code Comments
Table STVATYP
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
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
Table STVNATN
Source Code Comments
Columns Comments for STVNATN_CODE (# 1)
Source Code Comments
Columns Comments for STVNATN_NATION (# 2)
Source Code Comments
Columns Comments for STVNATN_CAPITAL (# 3)
Source Code Comments
Columns Comments for STVNATN_AREA (# 4)
Source Code Comments
Columns Comments for STVNATN_POPULATION (# 5)
Source Code Comments
Columns Comments for STVNATN_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for STVNATN_EDI_EQUIV (# 7)
Source Code Comments
Columns Comments for STVNATN_LMS_EQUIV (# 8)
Source Code Comments
Columns Comments for STVNATN_STATSCAN_CDE (# 11)
Source Code Comments
Columns Comments for STVNATN_SCOD_CODE_ISO (# 12)
Source Code Comments
Columns Comments for STVNATN_SSA_REPORTING_EQUIV (# 13)
Source Code Comments
Columns Comments for STVNATN_SEVIS_EQUIV (# 14)
Source Code Comments
Table STVSTAT
Source Code Comments
Columns Comments for STVSTAT_CODE (# 1)
Source Code Comments
Columns Comments for STVSTAT_DESC (# 2)
Source Code Comments
Columns Comments for STVSTAT_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for STVSTAT_EDI_EQUIV (# 4)
Source Code Comments
Columns Comments for STVSTAT_STATSCAN_CDE (# 5)
Source Code Comments
Columns Comments for STVSTAT_IPEDS_CDE (# 6)
Source Code Comments
Link between APRCSPS and SPRIDEN
Join Information
Link between SPRIDEN and ASRSSAG
Join Information
Link between SPRADDR and SPRIDEN
Join Information
Link between SPRIDEN and APBCONS
Join Information
Link between ASRSSAG and APBCONS
Join Information
Link between APRACYR and APRADEG
Join Information
Link between SPRADDR and STVATYP
Link between SPRADDR and STVSTAT
Link between SPRADDR and STVNATN
Link between APBCONS and STVATYP
Link between APBCONS and STVCOLL
Link between APBCONS and STVNATN
Link between APBCONS and STVSTAT
Link between APRCSPS and APBCONS
Link between APBCONS and ATVINCM
Link between APRADEG and APBCONS
Link between APRADEG and STVCOLL
Link between APREHIS and APBCONS
Link between APBCONS and ATVDOTT
Link between APRCHLD and APBCONS
Link between APRCHLD and STVATYP