• CAST HTML Report from AppWarehouse

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

    • Columns Comments for SPRAPIN_TERM_CODE (1)
      • Source Code Comments

    • Columns Comments for SPRAPIN_PIDM (2)
      • Source Code Comments

    • Columns Comments for SPRAPIN_PROCESS_NAME (3)
      • Source Code Comments

    • Columns Comments for SPRAPIN_PIN (4)
      • Source Code Comments

    • Columns Comments for SPRAPIN_ACTIVITY_DATE (5)
      • Source Code Comments

  • Table SPRCMNT
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

    • Columns Comments for SPRCMNT_PIDM (1)
      • Source Code Comments

    • Columns Comments for SPRCMNT_CMTT_CODE (2)
      • Source Code Comments

    • Columns Comments for SPRCMNT_TEXT (3)
      • Source Code Comments

    • Columns Comments for SPRCMNT_TEXT_NAR (4)
      • Source Code Comments

    • Columns Comments for SPRCMNT_CONFIDENTIAL_IND (5)
      • Source Code Comments

    • Columns Comments for SPRCMNT_DATE (6)
      • Source Code Comments

    • Columns Comments for SPRCMNT_ORIG_CODE (7)
      • Source Code Comments

    • Columns Comments for SPRCMNT_ACTIVITY_DATE (8)
      • Source Code Comments

    • Columns Comments for SPRCMNT_CTYP_CODE (9)
      • Source Code Comments

    • Columns Comments for SPRCMNT_CONTACT_DATE (10)
      • Source Code Comments

    • Columns Comments for SPRCMNT_USER_ID (11)
      • Source Code Comments

    • Columns Comments for SPRCMNT_CONTACT_FROM_TIME (12)
      • Source Code Comments

    • Columns Comments for SPRCMNT_CONTACT_TO_TIME (13)
      • Source Code Comments

  • Table SPRCOLR
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

    • Columns Comments for SPRCOLR_SESSIONID (1)
      • Source Code Comments

    • Columns Comments for SPRCOLR_TYPE (2)
      • Source Code Comments

    • Columns Comments for SPRCOLR_VALUE_DATE (3)
      • Source Code Comments

    • Columns Comments for SPRCOLR_VALUE_ATYP (4)
      • Source Code Comments

    • Columns Comments for SPRCOLR_ACTIVITY_DATE (5)
      • Source Code Comments

    • Columns Comments for SPRCOLR_JOB (6)
      • Source Code Comments

    • Columns Comments for SPRCOLR_PARM_NUMBER (7)
      • Source Code Comments

  • Table SPREMRG
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

    • Columns Comments for SPREMRG_PIDM (1)
      • Source Code Comments

    • Columns Comments for SPREMRG_PRIORITY (2)
      • Source Code Comments

    • Columns Comments for SPREMRG_LAST_NAME (3)
      • Source Code Comments

    • Columns Comments for SPREMRG_FIRST_NAME (4)
      • Source Code Comments

    • Columns Comments for SPREMRG_MI (5)
      • Source Code Comments

    • Columns Comments for SPREMRG_STREET_LINE1 (6)
      • Source Code Comments

    • Columns Comments for SPREMRG_STREET_LINE2 (7)
      • Source Code Comments

    • Columns Comments for SPREMRG_STREET_LINE3 (8)
      • Source Code Comments

    • Columns Comments for SPREMRG_CITY (9)
      • Source Code Comments

    • Columns Comments for SPREMRG_STAT_CODE (10)
      • Source Code Comments

    • Columns Comments for SPREMRG_NATN_CODE (11)
      • Source Code Comments

    • Columns Comments for SPREMRG_ZIP (12)
      • Source Code Comments

    • Columns Comments for SPREMRG_PHONE_AREA (13)
      • Source Code Comments

    • Columns Comments for SPREMRG_PHONE_NUMBER (14)
      • Source Code Comments

    • Columns Comments for SPREMRG_PHONE_EXT (15)
      • Source Code Comments

    • Columns Comments for SPREMRG_RELT_CODE (16)
      • Source Code Comments

    • Columns Comments for SPREMRG_ACTIVITY_DATE (17)
      • Source Code Comments

    • Columns Comments for SPREMRG_ATYP_CODE (18)
      • Source Code Comments

    • Columns Comments for SPREMRG_DATA_ORIGIN (19)
      • Source Code Comments

    • Columns Comments for SPREMRG_USER_ID (20)
      • Source Code Comments

  • Table SPRHOLD
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

    • Columns Comments for SPRHOLD_PIDM (1)
      • Source Code Comments

    • Columns Comments for SPRHOLD_HLDD_CODE (2)
      • Source Code Comments

    • Columns Comments for SPRHOLD_USER (3)
      • Source Code Comments

    • Columns Comments for SPRHOLD_FROM_DATE (4)
      • Source Code Comments

    • Columns Comments for SPRHOLD_TO_DATE (5)
      • Source Code Comments

    • Columns Comments for SPRHOLD_RELEASE_IND (6)
      • Source Code Comments

    • Columns Comments for SPRHOLD_REASON (7)
      • Source Code Comments

    • Columns Comments for SPRHOLD_AMOUNT_OWED (8)
      • Source Code Comments

    • Columns Comments for SPRHOLD_ORIG_CODE (9)
      • Source Code Comments

    • Columns Comments for SPRHOLD_ACTIVITY_DATE (10)
      • Source Code Comments

    • Columns Comments for SPRHOLD_DATA_ORIGIN (11)
      • 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 SPRINTL
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

    • Columns Comments for SPRINTL_PIDM (1)
      • Source Code Comments

    • Columns Comments for SPRINTL_VTYP_CODE_CURRENT (2)
      • Source Code Comments

    • Columns Comments for SPRINTL_VISA_NUMBER (3)
      • Source Code Comments

    • Columns Comments for SPRINTL_VISA_ISSUE_DATE (4)
      • Source Code Comments

    • Columns Comments for SPRINTL_VISA_EXPIRE_DATE (5)
      • Source Code Comments

    • Columns Comments for SPRINTL_SPON_CODE (6)
      • Source Code Comments

    • Columns Comments for SPRINTL_NATN_CODE_BIRTH (7)
      • Source Code Comments

    • Columns Comments for SPRINTL_NATN_CODE_LEGAL (8)
      • Source Code Comments

    • Columns Comments for SPRINTL_PASSPORT_ID (9)
      • Source Code Comments

    • Columns Comments for SPRINTL_PASSPORT_EXP_DATE (10)
      • Source Code Comments

    • Columns Comments for SPRINTL_ALIEN_REG_NUMBER (11)
      • Source Code Comments

    • Columns Comments for SPRINTL_I20_ID_NUMBER (12)
      • Source Code Comments

    • Columns Comments for SPRINTL_I94_STATUS (13)
      • Source Code Comments

    • Columns Comments for SPRINTL_I94_DATE (14)
      • Source Code Comments

    • Columns Comments for SPRINTL_VTYP_CODE_ENTRY (15)
      • Source Code Comments

    • Columns Comments for SPRINTL_ENTRY_DATE (16)
      • Source Code Comments

    • Columns Comments for SPRINTL_ENTRY_EXP_DATE (17)
      • Source Code Comments

    • Columns Comments for SPRINTL_PENT_CODE (18)
      • Source Code Comments

    • Columns Comments for SPRINTL_NO_ENTRIES (19)
      • Source Code Comments

    • Columns Comments for SPRINTL_ACTIVITY_DATE (20)
      • Source Code Comments

    • Columns Comments for SPRINTL_ADMR_CODE (21)
      • Source Code Comments

    • Columns Comments for SPRINTL_RECV_DATE (22)
      • Source Code Comments

    • Columns Comments for SPRINTL_I20_DATE (23)
      • Source Code Comments

    • Columns Comments for SPRINTL_LANG_CODE (24)
      • Source Code Comments

    • Columns Comments for SPRINTL_I20_IND (25)
      • Source Code Comments

    • Columns Comments for SPRINTL_SPOUSE_IND (26)
      • Source Code Comments

    • Columns Comments for SPRINTL_CHILD_NUMBER (27)
      • Source Code Comments

    • Columns Comments for SPRINTL_EMPT_CODE (28)
      • Source Code Comments

    • Columns Comments for SPRINTL_SIGNATURE_IND (29)
      • Source Code Comments

    • Columns Comments for SPRINTL_FOREIGN_SSN (30)
      • Source Code Comments

  • Table SPRMEDI
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

    • Columns Comments for SPRMEDI_PIDM (1)
      • Source Code Comments

    • Columns Comments for SPRMEDI_MEDI_CODE (2)
      • Source Code Comments

    • Columns Comments for SPRMEDI_MDEQ_CODE (3)
      • Source Code Comments

    • Columns Comments for SPRMEDI_COMMENT (4)
      • Source Code Comments

    • Columns Comments for SPRMEDI_ACTIVITY_DATE (5)
      • Source Code Comments

    • Columns Comments for SPRMEDI_DISA_CODE (6)
      • Source Code Comments

    • Columns Comments for SPRMEDI_SPSR_CODE (7)
      • Source Code Comments

    • Columns Comments for SPRMEDI_ONSET_AGE (8)
      • Source Code Comments

    • Columns Comments for SPRMEDI_DISB_IND (9)
      • Source Code Comments

    • Columns Comments for SPRMEDI_USER_ID (10)
      • 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 SPTADDR
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

  • Table SPTIDEN
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

  • Table SPTPERS
    • Table Columns information
    • Foreign Key information
    • Index
    • Calling objects (non escalated)
    • Called objects (non escalated)
    • Comments
      • Source Code Comments

    • Columns Comments for SPTPERS_ACTIVITY_DATE (16)
      • Source Code Comments

  • Link between SPRADDR and SPRTELE
    • Join Information
    • Link List
    • Link Between SPRADDR and SPRTELE
      • 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