Model View
Table APBWIDN
Object Full Name
Source Code Comments
Columns Comments for APBWIDN_ID (# 1)
Source Code Comments
Columns Comments for APBWIDN_PIN (# 2)
Source Code Comments
Columns Comments for APBWIDN_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for APBWIDN_USER (# 4)
Source Code Comments
Columns Comments for APBWIDN_ACCEPTED_IND (# 5)
Source Code Comments
Columns Comments for APBWIDN_QUESTION (# 6)
Source Code Comments
Columns Comments for APBWIDN_ANSWER (# 7)
Source Code Comments
Columns Comments for APBWIDN_PIDM (# 8)
Source Code Comments
Columns Comments for APBWIDN_LAST_NAME (# 9)
Source Code Comments
Columns Comments for APBWIDN_FIRST_NAME (# 10)
Source Code Comments
Columns Comments for APBWIDN_MI (# 11)
Source Code Comments
Columns Comments for APBWIDN_MAIDEN_NAME (# 12)
Source Code Comments
Columns Comments for APBWIDN_NAME_PREFIX (# 13)
Source Code Comments
Columns Comments for APBWIDN_NAME_SUFFIX (# 14)
Source Code Comments
Columns Comments for APBWIDN_BIRTH_DATE (# 15)
Source Code Comments
Columns Comments for APBWIDN_SEX (# 16)
Source Code Comments
Columns Comments for APBWIDN_ATYP_CODE (# 17)
Source Code Comments
Columns Comments for APBWIDN_STREET_LINE1 (# 18)
Source Code Comments
Columns Comments for APBWIDN_STREET_LINE2 (# 19)
Source Code Comments
Columns Comments for APBWIDN_STREET_LINE3 (# 20)
Source Code Comments
Columns Comments for APBWIDN_CITY (# 21)
Source Code Comments
Columns Comments for APBWIDN_STAT_CODE (# 22)
Source Code Comments
Columns Comments for APBWIDN_ZIP (# 23)
Source Code Comments
Columns Comments for APBWIDN_CNTY_CODE (# 24)
Source Code Comments
Columns Comments for APBWIDN_NATN_CODE (# 25)
Source Code Comments
Columns Comments for APBWIDN_TELE_CODE (# 26)
Source Code Comments
Columns Comments for APBWIDN_PHONE_AREA (# 27)
Source Code Comments
Columns Comments for APBWIDN_PHONE_NUMBER (# 28)
Source Code Comments
Columns Comments for APBWIDN_PHONE_EXT (# 29)
Source Code Comments
Columns Comments for APBWIDN_INTL_ACCESS (# 30)
Source Code Comments
Columns Comments for APBWIDN_UNLIST_IND (# 31)
Source Code Comments
Columns Comments for APBWIDN_FAX_TELE_CODE (# 32)
Source Code Comments
Columns Comments for APBWIDN_FAX_AREA (# 33)
Source Code Comments
Columns Comments for APBWIDN_FAX_NUMBER (# 34)
Source Code Comments
Columns Comments for APBWIDN_FAX_INTL_ACCESS (# 35)
Source Code Comments
Columns Comments for APBWIDN_FAX_UNLIST_IND (# 36)
Source Code Comments
Columns Comments for APBWIDN_EMAIL_ADDRESS (# 37)
Source Code Comments
Columns Comments for APBWIDN_EMAL_CODE (# 38)
Source Code Comments
Columns Comments for APBWIDN_SPS_LAST_NAME (# 39)
Source Code Comments
Columns Comments for APBWIDN_SPS_FIRST_NAME (# 40)
Source Code Comments
Columns Comments for APBWIDN_SPS_MI (# 41)
Source Code Comments
Columns Comments for APBWIDN_PREF_CLAS (# 42)
Source Code Comments
Columns Comments for APBWIDN_DONR_CODE (# 44)
Source Code Comments
Columns Comments for APBWIDN_LAST_LOGIN_DATE (# 45)
Source Code Comments
Columns Comments for APBWIDN_STREET_LINE4 (# 46)
Source Code Comments
Columns Comments for APBWIDN_CTRY_CODE_PHONE (# 47)
Source Code Comments
Columns Comments for APBWIDN_SURNAME_PREFIX (# 48)
Source Code Comments
Columns Comments for APBWIDN_HOUSE_NUMBER (# 49)
Source Code Comments
Columns Comments for APBWIDN_SALT (# 50)
Source Code Comments
Table GOREMAL
Object Full Name
Source Code Comments
Columns Comments for GOREMAL_PIDM (# 1)
Source Code Comments
Columns Comments for GOREMAL_EMAL_CODE (# 2)
Source Code Comments
Columns Comments for GOREMAL_EMAIL_ADDRESS (# 3)
Source Code Comments
Columns Comments for GOREMAL_STATUS_IND (# 4)
Source Code Comments
Columns Comments for GOREMAL_PREFERRED_IND (# 5)
Source Code Comments
Columns Comments for GOREMAL_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for GOREMAL_USER_ID (# 7)
Source Code Comments
Columns Comments for GOREMAL_COMMENT (# 8)
Source Code Comments
Columns Comments for GOREMAL_DISP_WEB_IND (# 9)
Source Code Comments
Columns Comments for GOREMAL_DATA_ORIGIN (# 10)
Source Code Comments
Table GTVEMAL
Object Full Name
Source Code Comments
Columns Comments for GTVEMAL_CODE (# 1)
Source Code Comments
Columns Comments for GTVEMAL_DESC (# 2)
Source Code Comments
Columns Comments for GTVEMAL_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for GTVEMAL_DISP_WEB_IND (# 4)
Source Code Comments
Columns Comments for GTVEMAL_URL_IND (# 5)
Source Code Comments
Table ROTEMAL
Object Full Name
Source Code Comments
Columns Comments for ROTEMAL_PIDM (# 1)
Source Code Comments
Columns Comments for ROTEMAL_EMAL_CODE (# 2)
Source Code Comments
Columns Comments for ROTEMAL_EMAIL_ADDRESS (# 3)
Source Code Comments
Columns Comments for ROTEMAL_STATUS_IND (# 4)
Source Code Comments
Columns Comments for ROTEMAL_PREFERRED_IND (# 5)
Source Code Comments
Columns Comments for ROTEMAL_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for ROTEMAL_USER_ID (# 7)
Source Code Comments
Columns Comments for ROTEMAL_COMMENT (# 8)
Source Code Comments
Columns Comments for ROTEMAL_DISP_WEB_IND (# 9)
Source Code Comments
Columns Comments for ROTEMAL_INFC_CODE (# 10)
Source Code Comments
Columns Comments for ROTEMAL_AIDY_CODE (# 11)
Source Code Comments
Table SARADAP
Object Full Name
Source Code Comments
Lock
Columns Comments for SARADAP_PIDM (# 1)
Source Code Comments
Columns Comments for SARADAP_TERM_CODE_ENTRY (# 2)
Source Code Comments
Columns Comments for SARADAP_APPL_NO (# 3)
Source Code Comments
Columns Comments for SARADAP_LEVL_CODE (# 4)
Source Code Comments
Columns Comments for SARADAP_APPL_DATE (# 5)
Source Code Comments
Columns Comments for SARADAP_APST_CODE (# 6)
Source Code Comments
Columns Comments for SARADAP_APST_DATE (# 7)
Source Code Comments
Columns Comments for SARADAP_MAINT_IND (# 8)
Source Code Comments
Columns Comments for SARADAP_ADMT_CODE (# 9)
Source Code Comments
Columns Comments for SARADAP_STYP_CODE (# 10)
Source Code Comments
Columns Comments for SARADAP_CAMP_CODE (# 11)
Source Code Comments
Columns Comments for SARADAP_SITE_CODE (# 12)
Source Code Comments
Columns Comments for SARADAP_COLL_CODE_1 (# 13)
Source Code Comments
Columns Comments for SARADAP_DEGC_CODE_1 (# 14)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_1 (# 15)
Source Code Comments
Columns Comments for SARADAP_COLL_CODE_2 (# 16)
Source Code Comments
Columns Comments for SARADAP_DEGC_CODE_2 (# 17)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_2 (# 18)
Source Code Comments
Columns Comments for SARADAP_RESD_CODE (# 19)
Source Code Comments
Columns Comments for SARADAP_FULL_PART_IND (# 20)
Source Code Comments
Columns Comments for SARADAP_SESS_CODE (# 21)
Source Code Comments
Columns Comments for SARADAP_WRSN_CODE (# 22)
Source Code Comments
Columns Comments for SARADAP_INTV_CODE (# 23)
Source Code Comments
Columns Comments for SARADAP_FEE_IND (# 24)
Source Code Comments
Columns Comments for SARADAP_FEE_DATE (# 25)
Source Code Comments
Columns Comments for SARADAP_ACTIVITY_DATE (# 26)
Source Code Comments
Columns Comments for SARADAP_RATE_CODE (# 27)
Source Code Comments
Columns Comments for SARADAP_EGOL_CODE (# 28)
Source Code Comments
Columns Comments for SARADAP_EDLV_CODE (# 29)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_1 (# 30)
Source Code Comments
Columns Comments for SARADAP_DEPT_CODE (# 31)
Source Code Comments
Columns Comments for SARADAP_SBGI_CODE (# 32)
Source Code Comments
Columns Comments for SARADAP_RECR_CODE (# 33)
Source Code Comments
Columns Comments for SARADAP_RTYP_CODE (# 34)
Source Code Comments
Columns Comments for SARADAP_DEPT_CODE_2 (# 35)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_2 (# 36)
Source Code Comments
Columns Comments for SARADAP_PROGRAM_1 (# 37)
Source Code Comments
Columns Comments for SARADAP_TERM_CODE_CTLG_1 (# 38)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_1_2 (# 39)
Source Code Comments
Columns Comments for SARADAP_DEPT_CODE_1_2 (# 40)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_1_2 (# 41)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_1_3 (# 42)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_121 (# 43)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_122 (# 44)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_123 (# 45)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_MINR_1_1 (# 46)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_MINR_1_2 (# 47)
Source Code Comments
Columns Comments for SARADAP_PROGRAM_2 (# 48)
Source Code Comments
Columns Comments for SARADAP_TERM_CODE_CTLG_2 (# 49)
Source Code Comments
Columns Comments for SARADAP_LEVL_CODE_2 (# 50)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_2_2 (# 52)
Source Code Comments
Columns Comments for SARADAP_DEPT_CODE_2_2 (# 53)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_211 (# 54)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_212 (# 55)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_213 (# 56)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_221 (# 57)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_222 (# 58)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_223 (# 59)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_MINR_2_1 (# 60)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_MINR_2_2 (# 61)
Source Code Comments
Columns Comments for SARADAP_CURR_RULE_1 (# 62)
Source Code Comments
Columns Comments for SARADAP_CMJR_RULE_1_1 (# 63)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_11_1 (# 64)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_11_2 (# 65)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_11_3 (# 66)
Source Code Comments
Columns Comments for SARADAP_CMJR_RULE_1_2 (# 67)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_12_1 (# 68)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_12_2 (# 69)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_12_3 (# 70)
Source Code Comments
Columns Comments for SARADAP_CMNR_RULE_1_1 (# 71)
Source Code Comments
Columns Comments for SARADAP_CMNR_RULE_1_2 (# 72)
Source Code Comments
Columns Comments for SARADAP_CURR_RULE_2 (# 73)
Source Code Comments
Columns Comments for SARADAP_CMJR_RULE_2_1 (# 74)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_21_1 (# 75)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_21_2 (# 76)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_21_3 (# 77)
Source Code Comments
Columns Comments for SARADAP_CMJR_RULE_2_2 (# 78)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_22_1 (# 79)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_22_2 (# 80)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_22_3 (# 81)
Source Code Comments
Columns Comments for SARADAP_CMNR_RULE_2_1 (# 82)
Source Code Comments
Columns Comments for SARADAP_CMNR_RULE_2_2 (# 83)
Source Code Comments
Columns Comments for SARADAP_WEB_ACCT_MISC_IND (# 84)
Source Code Comments
Columns Comments for SARADAP_WEB_CASHIER_USER (# 85)
Source Code Comments
Columns Comments for SARADAP_WEB_TRANS_NO (# 86)
Source Code Comments
Columns Comments for SARADAP_WEB_AMOUNT (# 87)
Source Code Comments
Columns Comments for SARADAP_WEB_RECEIPT_NUMBER (# 88)
Source Code Comments
Columns Comments for SARADAP_WAIV_CODE (# 89)
Source Code Comments
Columns Comments for SARADAP_DATA_ORIGIN (# 90)
Source Code Comments
Columns Comments for SARADAP_USER_ID (# 91)
Source Code Comments
Columns Comments for SARADAP_APPL_PREFERENCE (# 92)
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 SRBWPRO
Object Full Name
Source Code Comments
Columns Comments for SRBWPRO_PREL_CODE (# 1)
Source Code Comments
Columns Comments for SRBWPRO_WPIC_CODE (# 2)
Source Code Comments
Columns Comments for SRBWPRO_DISPLAY_ORDER (# 3)
Source Code Comments
Columns Comments for SRBWPRO_ATYP_CODE (# 5)
Source Code Comments
Columns Comments for SRBWPRO_RESPONSE_REQ_IND (# 7)
Source Code Comments
Table SRTEMAL
Object Full Name
Source Code Comments
Columns Comments for SRTEMAL_RIDM (# 1)
Source Code Comments
Columns Comments for SRTEMAL_EMAL_CODE (# 2)
Source Code Comments
Columns Comments for SRTEMAL_EMAIL_ADDRESS (# 3)
Source Code Comments
Columns Comments for SRTEMAL_STATUS_IND (# 4)
Source Code Comments
Columns Comments for SRTEMAL_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for SRTEMAL_USER_ID (# 6)
Source Code Comments
Columns Comments for SRTEMAL_PREFERRED_IND (# 7)
Source Code Comments
Columns Comments for SRTEMAL_COMMENT (# 8)
Source Code Comments
Columns Comments for SRTEMAL_DISP_WEB_IND (# 9)
Source Code Comments
Link between SPBPERS and SARADAP
Join Information
Link between GOREMAL and SARADAP
Join Information
Link between SPBPERS and GOREMAL
Join Information
Link between APBWIDN and GTVEMAL
Link between ROTEMAL and GTVEMAL
Link between GOREMAL and GTVEMAL
Link between SRBWPRO and GTVEMAL
Link between SRTEMAL and GTVEMAL