• List of Objects
    • Comments
    • Model View
  • Table NOBTRAN
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Table NORROUT
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

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

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

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

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

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

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

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

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

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

  • Table NORTERN
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Table NORTLBD
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Table NORTRAN
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

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

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

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

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

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

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

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

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

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

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

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

  • Table NTVACAT
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

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

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

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

  • Table SPRIDEN
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Impact job : LN_last_name_col New Job
    • Impact job : SPRIDEN_LAST_NAME New Job
      • Impacted objects
    • Impact job : spriden_last_name3 New Job
      • Impacted objects
    • 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_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_CREATE_USER (17)
      • Source Code Comments

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

  • Link between NORTLBD and NOBTRAN
    • Link List
    • Link Foreign Key Between NORTLBD and NOBTRAN
      • Foreign Key information
    • Comments
  • Link between NOBTRAN and NTVACAT
    • Link List
    • Link Foreign Key Between NOBTRAN and NTVACAT
      • Foreign Key information
    • Comments