Model View
Table GTVLETR
Object Full Name
Source Code Comments
Columns Comments for GTVLETR_CODE (# 1)
Source Code Comments
Columns Comments for GTVLETR_ACTIVITY_DATE (# 2)
Source Code Comments
Columns Comments for GTVLETR_DUPL_IND (# 3)
Source Code Comments
Columns Comments for GTVLETR_DESC (# 4)
Source Code Comments
Columns Comments for GTVLETR_PRINT_COMMAND (# 5)
Source Code Comments
Columns Comments for GTVLETR_LETR_CODE_ALT (# 6)
Source Code Comments
Table RFRBASE
Object Full Name
Source Code Comments
Columns Comments for RFRBASE_FUND_CODE (# 1)
Source Code Comments
Columns Comments for RFRBASE_FUND_TITLE (# 2)
Source Code Comments
Columns Comments for RFRBASE_FSRC_CODE (# 3)
Source Code Comments
Columns Comments for RFRBASE_FTYP_CODE (# 4)
Source Code Comments
Columns Comments for RFRBASE_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for RFRBASE_DETAIL_CODE (# 6)
Source Code Comments
Columns Comments for RFRBASE_FED_FUND_ID (# 7)
Source Code Comments
Columns Comments for RFRBASE_PRINT_SEQ_NO (# 8)
Source Code Comments
Columns Comments for RFRBASE_VR_MSG_NO (# 9)
Source Code Comments
Columns Comments for RFRBASE_ACTIVE_IND (# 10)
Source Code Comments
Columns Comments for RFRBASE_XREF_VALUE (# 11)
Source Code Comments
Columns Comments for RFRBASE_FUND_TITLE_LONG (# 12)
Source Code Comments
Table RJBJOBT
Object Full Name
Source Code Comments
Columns Comments for RJBJOBT_CODE (# 1)
Source Code Comments
Columns Comments for RJBJOBT_DESC (# 2)
Source Code Comments
Columns Comments for RJBJOBT_HRLY_PAY_IND (# 3)
Source Code Comments
Columns Comments for RJBJOBT_PAY_RANGE_LOW (# 4)
Source Code Comments
Columns Comments for RJBJOBT_PAY_RANGE_HIGH (# 5)
Source Code Comments
Columns Comments for RJBJOBT_DEFAULT_PAY (# 6)
Source Code Comments
Columns Comments for RJBJOBT_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for RJBJOBT_REQUIREMENTS (# 8)
Source Code Comments
Columns Comments for RJBJOBT_USER_ID (# 9)
Source Code Comments
Table RJBPLBD
Object Full Name
Source Code Comments
Columns Comments for RJBPLBD_STREET_LINE4 (# 15)
Source Code Comments
Columns Comments for RJBPLBD_HOUSE_NUMBER (# 16)
Source Code Comments
Columns Comments for RJBPLBD_CTRY_CODE_PHONE (# 17)
Source Code Comments
Columns Comments for RJBPLBD_EMAIL_ADDRESS (# 18)
Source Code Comments
Columns Comments for RJBPLBD_USER_ID (# 19)
Source Code Comments
Table RJBSEDR
Object Full Name
Source Code Comments
Columns Comments for RJBSEDR_USER_ID (# 8)
Source Code Comments
Table RJRPAYL
Object Full Name
Source Code Comments
Columns Comments for RJRPAYL_USER_ID (# 8)
Source Code Comments
Table RJRPLRL
Object Full Name
Source Code Comments
Columns Comments for RJRPLRL_USER_ID (# 12)
Source Code Comments
Table RJRSEAR
Object Full Name
Source Code Comments
Columns Comments for RJRSEAR_JOBT_CODE (# 3)
Source Code Comments
Columns Comments for RJRSEAR_SORT_KEY (# 18)
Source Code Comments
Columns Comments for RJRSEAR_USER_ID (# 19)
Source Code Comments
Table RJRSERF
Object Full Name
Source Code Comments
Columns Comments for RJRSERF_FUND_CODE (# 7)
Source Code Comments
Columns Comments for RJRSERF_POSN (# 8)
Source Code Comments
Columns Comments for RJRSERF_SUFF (# 9)
Source Code Comments
Columns Comments for RJRSERF_JOBT_CODE (# 10)
Source Code Comments
Columns Comments for RJRSERF_USER_ID (# 12)
Source Code Comments
Table RJRSEWH
Object Full Name
Source Code Comments
Columns Comments for RJRSEWH_USER_ID (# 13)
Source Code Comments
Table RORENRL
Object Full Name
Source Code Comments
Columns Comments for RORENRL_PIDM (# 1)
Source Code Comments
Columns Comments for RORENRL_TERM_CODE (# 2)
Source Code Comments
Columns Comments for RORENRL_FINAID_CREDIT_HR (# 3)
Source Code Comments
Columns Comments for RORENRL_FINAID_BILL_HR (# 4)
Source Code Comments
Columns Comments for RORENRL_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for RORENRL_FINAID_ADJ_HR (# 6)
Source Code Comments
Columns Comments for RORENRL_USER_ID (# 7)
Source Code Comments
Columns Comments for RORENRL_SYS_IND (# 8)
Source Code Comments
Columns Comments for RORENRL_CONSORTIUM_IND (# 9)
Source Code Comments
Table RORSAPR
Object Full Name
Source Code Comments
Columns Comments for RORSAPR_PIDM (# 1)
Source Code Comments
Columns Comments for RORSAPR_TERM_CODE (# 2)
Source Code Comments
Columns Comments for RORSAPR_SAPR_CODE (# 3)
Source Code Comments
Columns Comments for RORSAPR_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for RORSAPR_SAPR_CODE_CALC (# 5)
Source Code Comments
Columns Comments for RORSAPR_LOCK_IND (# 6)
Source Code Comments
Columns Comments for RORSAPR_SLCT_IND (# 7)
Source Code Comments
Columns Comments for RORSAPR_USER_ID (# 8)
Source Code Comments
Columns Comments for RORSAPR_DATA_ORIGIN (# 9)
Source Code Comments
Table RORSTRF
Object Full Name
Source Code Comments
Columns Comments for RORSTRF_SAPR_CODE_PREV (# 1)
Source Code Comments
Columns Comments for RORSTRF_SAPR_CODE_CALC (# 2)
Source Code Comments
Columns Comments for RORSTRF_SAPR_CODE_NEW (# 3)
Source Code Comments
Columns Comments for RORSTRF_USER_ID (# 4)
Source Code Comments
Columns Comments for RORSTRF_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for RORSTRF_LETR_CODE (# 6)
Source Code Comments
Table RPRATRM
Object Full Name
Source Code Comments
Columns Comments for RPRATRM_AIDY_CODE (# 1)
Source Code Comments
Columns Comments for RPRATRM_PIDM (# 2)
Source Code Comments
Columns Comments for RPRATRM_FUND_CODE (# 3)
Source Code Comments
Columns Comments for RPRATRM_TERM_CODE (# 4)
Source Code Comments
Columns Comments for RPRATRM_OFFER_AMT (# 5)
Source Code Comments
Columns Comments for RPRATRM_OFFER_DATE (# 6)
Source Code Comments
Columns Comments for RPRATRM_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for RPRATRM_DISB_FINAL_IND (# 8)
Source Code Comments
Columns Comments for RPRATRM_DIST_PCT (# 9)
Source Code Comments
Columns Comments for RPRATRM_MEMO_EXP_DATE (# 10)
Source Code Comments
Columns Comments for RPRATRM_ORIG_OFFER_AMT (# 11)
Source Code Comments
Columns Comments for RPRATRM_ORIG_OFFER_DATE (# 12)
Source Code Comments
Columns Comments for RPRATRM_ACCEPT_AMT (# 13)
Source Code Comments
Columns Comments for RPRATRM_ACCEPT_DATE (# 14)
Source Code Comments
Columns Comments for RPRATRM_DECLINE_AMT (# 15)
Source Code Comments
Columns Comments for RPRATRM_DECLINE_DATE (# 16)
Source Code Comments
Columns Comments for RPRATRM_CANCEL_AMT (# 17)
Source Code Comments
Columns Comments for RPRATRM_CANCEL_DATE (# 18)
Source Code Comments
Columns Comments for RPRATRM_AUTHORIZE_AMT (# 19)
Source Code Comments
Columns Comments for RPRATRM_AUTHORIZE_DATE (# 20)
Source Code Comments
Columns Comments for RPRATRM_MEMO_AMT (# 21)
Source Code Comments
Columns Comments for RPRATRM_MEMO_DATE (# 22)
Source Code Comments
Columns Comments for RPRATRM_PAID_AMT (# 23)
Source Code Comments
Columns Comments for RPRATRM_PAID_DATE (# 24)
Source Code Comments
Columns Comments for RPRATRM_PCKG_LOAD_IND (# 25)
Source Code Comments
Columns Comments for RPRATRM_NSLDS_OVRD_IND (# 26)
Source Code Comments
Columns Comments for RPRATRM_PELL_AWRD_LOAD_OPT (# 27)
Source Code Comments
Columns Comments for RPRATRM_LOCK_IND (# 28)
Source Code Comments
Columns Comments for RPRATRM_USER_ID (# 29)
Source Code Comments
Columns Comments for RPRATRM_CIP_OVERRIDE_CODE (# 30)
Source Code Comments
Columns Comments for RPRATRM_DATA_ORIGIN (# 31)
Source Code Comments
Columns Comments for RPRATRM_OVERRIDE_DISB_RULE (# 32)
Source Code Comments
Table RTVAUST
Object Full Name
Source Code Comments
Columns Comments for RTVAUST_USER_ID (# 5)
Source Code Comments
Table RTVRFST
Object Full Name
Source Code Comments
Columns Comments for RTVRFST_USER_ID (# 4)
Source Code Comments
Table RTVSAPR
Object Full Name
Source Code Comments
Columns Comments for RTVSAPR_CODE (# 1)
Source Code Comments
Columns Comments for RTVSAPR_DESC (# 2)
Source Code Comments
Columns Comments for RTVSAPR_PCKG_IND (# 3)
Source Code Comments
Columns Comments for RTVSAPR_DISB_IND (# 4)
Source Code Comments
Columns Comments for RTVSAPR_AID_TYPE (# 5)
Source Code Comments
Columns Comments for RTVSAPR_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for RTVSAPR_VR_MSG_NO (# 7)
Source Code Comments
Columns Comments for RTVSAPR_LETR_CODE (# 8)
Source Code Comments
Columns Comments for RTVSAPR_PRIORITY (# 9)
Source Code Comments
Columns Comments for RTVSAPR_ACTIVE_IND (# 10)
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
Link between RJRSEAR and RTVAUST
Link between RORSAPR and RTVSAPR
Link between RJRPLRL and RJBPLBD
Link between RORSTRF and RTVSAPR
Link between RJBSEDR and RTVAUST
Link between RJRSERF and RTVRFST
Link between RPRATRM and RFRBASE
Join Information
Link between RORENRL and RPRATRM
Join Information
Link between RFRBASE and RJRSEAR
Join Information
Link between RJBPLBD and RJRSEAR
Join Information
Link between RORSTRF and GTVLETR
Link between RTVSAPR and GTVLETR
Link between RJBPLBD and STVNATN
Link between RJBPLBD and STVSTAT