• List of Objects
    • Comments
    • Model View
  • Table GORADRL
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

    • Impact job : spbpers_sdvet_ind spbpers_sdvet_ind
    • Impact job : SPBPERS_SDVET_IND2 New Job
    • 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

  • Table SPRADDR
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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

  • Table SPRTELE
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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

  • Table STVATYP
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • 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

  • Report on SPBPERS link
    • Comments
      • Free Text on Model

  • Report on SPRIDEN link
    • Comments
      • Free Text on Model

  • Link between SPRADDR and SPRTELE
    • Join Information
    • Link List
    • Link Between SPRADDR and SPRTELE
      • Foreign Key information
    • Comments
  • Link between GORADRL and STVATYP
    • Join Information
    • Link List
    • Link Between GORADRL and STVATYP
      • Foreign Key information
    • Comments
  • Link between SPRIDEN and SPBPERS
    • Join Information
    • Link List
    • Link Between SPRIDEN and SPBPERS
      • Foreign Key information
    • Comments
  • Link between SPRADDR and SPRIDEN
    • Join Information
    • Link List
    • Link Between SPRADDR and SPRIDEN
      • Foreign Key information
    • Comments
  • Link between SPBPERS and STVSTAT
    • Link List
    • Link Foreign Key Between SPBPERS and STVSTAT
      • Foreign Key information
    • Comments
  • Link between SPRTELE and STVATYP
    • Link List
    • Link Foreign Key Between SPRTELE and STVATYP
      • Foreign Key information
    • Comments
  • Link between SPRADDR and STVATYP
    • Link List
    • Link Foreign Key Between SPRADDR and STVATYP
      • Foreign Key information
    • Comments
  • Link between SPRADDR and STVCNTY
    • Link List
    • Link Foreign Key Between SPRADDR and STVCNTY
      • Foreign Key information
    • Comments
  • Link between SPRADDR and STVSTAT
    • Link List
    • Link Foreign Key Between SPRADDR and STVSTAT
      • Foreign Key information
    • Comments
  • Link between STVATYP and STVTELE
    • Link List
    • Link Foreign Key Between STVATYP and STVTELE
      • Foreign Key information
    • Comments
  • Link between SPRTELE and STVTELE
    • Link List
    • Link Foreign Key Between SPRTELE and STVTELE
      • Foreign Key information
    • Comments
  • Link between SPBPERS and STVNATN
    • Link List
    • Link Foreign Key Between SPBPERS and STVNATN
      • Foreign Key information
    • Comments
  • Link between SPRADDR and STVNATN
    • Link List
    • Link Foreign Key Between SPRADDR and STVNATN
      • Foreign Key information
    • Comments