• Model View
  • Table GORADRL
    • Object Full Name
    • Source Code Comments
    • Columns Comments for GORADRL_ATYP_CODE (# 1)
      • Source Code Comments
    • Columns Comments for GORADRL_ROLE (# 2)
      • Source Code Comments
    • Columns Comments for GORADRL_PRIV_IND (# 3)
      • Source Code Comments
    • Columns Comments for GORADRL_ACTIVITY_DATE (# 4)
      • Source Code Comments
  • Table SPBPERS
    • Object Full Name
    • Source Code Comments
    • Lock
    • Columns Comments for SPBPERS_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for SPBPERS_SSN (# 2)
      • Source Code Comments
    • Columns Comments for SPBPERS_BIRTH_DATE (# 3)
      • Source Code Comments
    • Columns Comments for SPBPERS_LGCY_CODE (# 4)
      • Source Code Comments
    • Columns Comments for SPBPERS_ETHN_CODE (# 5)
      • Source Code Comments
    • Columns Comments for SPBPERS_MRTL_CODE (# 6)
      • Source Code Comments
    • Columns Comments for SPBPERS_RELG_CODE (# 7)
      • Source Code Comments
    • Columns Comments for SPBPERS_SEX (# 8)
      • Source Code Comments
    • Columns Comments for SPBPERS_CONFID_IND (# 9)
      • Source Code Comments
    • Columns Comments for SPBPERS_DEAD_IND (# 10)
      • Source Code Comments
    • Columns Comments for SPBPERS_VETC_FILE_NUMBER (# 11)
      • Source Code Comments
    • Columns Comments for SPBPERS_LEGAL_NAME (# 12)
      • Source Code Comments
    • Columns Comments for SPBPERS_PREF_FIRST_NAME (# 13)
      • Source Code Comments
    • Columns Comments for SPBPERS_NAME_PREFIX (# 14)
      • Source Code Comments
    • Columns Comments for SPBPERS_NAME_SUFFIX (# 15)
      • Source Code Comments
    • Columns Comments for SPBPERS_ACTIVITY_DATE (# 16)
      • Source Code Comments
    • Columns Comments for SPBPERS_VERA_IND (# 17)
      • Source Code Comments
    • Columns Comments for SPBPERS_CITZ_IND (# 18)
      • Source Code Comments
    • Columns Comments for SPBPERS_DEAD_DATE (# 19)
      • Source Code Comments
    • Columns Comments for SPBPERS_PIN (# 20)
      • Source Code Comments
    • Columns Comments for SPBPERS_CITZ_CODE (# 21)
      • Source Code Comments
    • Columns Comments for SPBPERS_HAIR_CODE (# 22)
      • Source Code Comments
    • Columns Comments for SPBPERS_EYES_CODE (# 23)
      • Source Code Comments
    • Columns Comments for SPBPERS_CITY_BIRTH (# 24)
      • Source Code Comments
    • Columns Comments for SPBPERS_STAT_CODE_BIRTH (# 25)
      • Source Code Comments
    • Columns Comments for SPBPERS_DRIVER_LICENSE (# 26)
      • Source Code Comments
    • Columns Comments for SPBPERS_STAT_CODE_DRIVER (# 27)
      • Source Code Comments
    • Columns Comments for SPBPERS_NATN_CODE_DRIVER (# 28)
      • Source Code Comments
    • Columns Comments for SPBPERS_UOMS_CODE_HEIGHT (# 29)
      • Source Code Comments
    • Columns Comments for SPBPERS_HEIGHT (# 30)
      • Source Code Comments
    • Columns Comments for SPBPERS_UOMS_CODE_WEIGHT (# 31)
      • Source Code Comments
    • Columns Comments for SPBPERS_WEIGHT (# 32)
      • Source Code Comments
    • Columns Comments for SPBPERS_SDVET_IND (# 33)
      • Source Code Comments
    • Columns Comments for SPBPERS_LICENSE_ISSUED_DATE (# 34)
      • Source Code Comments
    • Columns Comments for SPBPERS_LICENSE_EXPIRES_DATE (# 35)
      • Source Code Comments
    • Columns Comments for SPBPERS_INCAR_IND (# 36)
      • Source Code Comments
    • Columns Comments for SPBPERS_WEBID (# 37)
      • Source Code Comments
    • Columns Comments for SPBPERS_WEB_LAST_ACCESS (# 38)
      • Source Code Comments
    • Columns Comments for SPBPERS_PIN_DISABLED_IND (# 39)
      • Source Code Comments
    • Columns Comments for SPBPERS_ITIN (# 40)
      • Source Code Comments
    • Columns Comments for SPBPERS_ACTIVE_DUTY_SEPR_DATE (# 41)
      • Source Code Comments
    • Columns Comments for SPBPERS_DATA_ORIGIN (# 42)
      • Source Code Comments
    • Columns Comments for SPBPERS_USER_ID (# 43)
      • Source Code Comments
    • Columns Comments for SPBPERS_ETHN_CDE (# 44)
      • Source Code Comments
    • Columns Comments for SPBPERS_CONFIRMED_RE_CDE (# 45)
      • Source Code Comments
    • Columns Comments for SPBPERS_CONFIRMED_RE_DATE (# 46)
      • Source Code Comments
  • Table SPRADDR
    • Object Full Name
    • 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
    • Columns Comments for SPRADDR_CTRY_CODE_PHONE (# 28)
      • Source Code Comments
    • Columns Comments for SPRADDR_HOUSE_NUMBER (# 29)
      • Source Code Comments
    • Columns Comments for SPRADDR_STREET_LINE4 (# 30)
      • Source Code Comments
  • Table SPRIDEN
    • Object Full Name
    • Source Code Comments
    • 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
    • Columns Comments for SPRIDEN_SURNAME_PREFIX (# 21)
      • Source Code Comments
  • Table SPRTELE
    • Object Full Name
    • Source Code Comments
    • Columns Comments for SPRTELE_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for SPRTELE_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for SPRTELE_TELE_CODE (# 3)
      • Source Code Comments
    • Columns Comments for SPRTELE_ACTIVITY_DATE (# 4)
      • Source Code Comments
    • Columns Comments for SPRTELE_PHONE_AREA (# 5)
      • Source Code Comments
    • Columns Comments for SPRTELE_PHONE_NUMBER (# 6)
      • Source Code Comments
    • Columns Comments for SPRTELE_PHONE_EXT (# 7)
      • Source Code Comments
    • Columns Comments for SPRTELE_STATUS_IND (# 8)
      • Source Code Comments
    • Columns Comments for SPRTELE_ATYP_CODE (# 9)
      • Source Code Comments
    • Columns Comments for SPRTELE_ADDR_SEQNO (# 10)
      • Source Code Comments
    • Columns Comments for SPRTELE_PRIMARY_IND (# 11)
      • Source Code Comments
    • Columns Comments for SPRTELE_UNLIST_IND (# 12)
      • Source Code Comments
    • Columns Comments for SPRTELE_COMMENT (# 13)
      • Source Code Comments
    • Columns Comments for SPRTELE_INTL_ACCESS (# 14)
      • Source Code Comments
    • Columns Comments for SPRTELE_DATA_ORIGIN (# 15)
      • Source Code Comments
    • Columns Comments for SPRTELE_USER_ID (# 16)
      • Source Code Comments
    • Columns Comments for SPRTELE_CTRY_CODE_PHONE (# 17)
      • 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 STVCNTY
    • Object Full Name
    • Source Code Comments
    • Columns Comments for STVCNTY_CODE (# 1)
      • Source Code Comments
    • Columns Comments for STVCNTY_DESC (# 2)
      • Source Code Comments
    • Columns Comments for STVCNTY_ACTIVITY_DATE (# 3)
      • Source Code Comments
  • Table STVNATN
    • Object Full Name
    • 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
    • Object Full Name
    • 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
  • Table STVTELE
    • Object Full Name
    • Source Code Comments
    • Columns Comments for STVTELE_CODE (# 1)
      • Source Code Comments
    • Columns Comments for STVTELE_DESC (# 2)
      • Source Code Comments
    • Columns Comments for STVTELE_ACTIVITY_DATE (# 3)
      • Source Code Comments
  • Link between SPRIDEN and SPBPERS
    • Join Information
  • Link between SPRIDEN and SPRADDR
    • Join Information
  • Link between SPRADDR and SPRTELE
    • Join Information
  • Link between GORADRL and STVATYP
    • Join Information
  • Link between SPRADDR and GORADRL
    • Join Information
  • Link between SPBPERS and STVNATN
  • Link between SPBPERS and STVSTAT
  • Link between SPRTELE and STVATYP
  • Link between SPRADDR and STVATYP
  • Link between SPRADDR and STVCNTY
  • Link between SPRADDR and STVNATN
  • Link between SPRADDR and STVSTAT
  • Link between SPRTELE and STVTELE
  • Link between STVATYP and STVTELE