Model View
Index PK_SIBFACD
Object Full Name
Index PK_SIBINST
Object Full Name
Index PK_SIBTERM
Object Full Name
Index PK_SIRASGN
Object Full Name
Index PK_SIRCOLC
Object Full Name
Index PK_SIRCOLR
Object Full Name
Index PK_SIRLVAS
Object Full Name
Index PK_SIROFFC
Object Full Name
Table SIBCFTE
Object Full Name
Source Code Comments
Columns Comments for SIBCFTE_FCNT_CODE (# 1)
Source Code Comments
Columns Comments for SIBCFTE_TERM_CODE_EFF (# 2)
Source Code Comments
Columns Comments for SIBCFTE_FTE_FACTOR (# 3)
Source Code Comments
Columns Comments for SIBCFTE_ACTIVITY_DATE (# 4)
Source Code Comments
Table SIBFACD
Object Full Name
Source Code Comments
Columns Comments for SIBFACD_PIDM (# 1)
Source Code Comments
Columns Comments for SIBFACD_1ST_APPT_DATE (# 2)
Source Code Comments
Columns Comments for SIBFACD_RANK_CODE (# 3)
Source Code Comments
Columns Comments for SIBFACD_RANK_DATE (# 4)
Source Code Comments
Columns Comments for SIBFACD_DISP_CODE (# 5)
Source Code Comments
Columns Comments for SIBFACD_TENR_CODE (# 6)
Source Code Comments
Columns Comments for SIBFACD_TENURE_DATE (# 7)
Source Code Comments
Columns Comments for SIBFACD_TENURE_REV_DATE (# 8)
Source Code Comments
Columns Comments for SIBFACD_LAST_SABB_DATE (# 9)
Source Code Comments
Columns Comments for SIBFACD_NEXT_SABB_DATE (# 10)
Source Code Comments
Columns Comments for SIBFACD_YRS_EXP (# 11)
Source Code Comments
Columns Comments for SIBFACD_BIRTH_STATE (# 12)
Source Code Comments
Columns Comments for SIBFACD_AAUP_MEM_IND (# 13)
Source Code Comments
Columns Comments for SIBFACD_ACTIVITY_DATE (# 14)
Source Code Comments
Columns Comments for SIBFACD_ACADEMIC_TITLE (# 15)
Source Code Comments
Columns Comments for SIBFACD_PRIMARY_ACTIVITY (# 16)
Source Code Comments
Table SIBFACD_TMP
Object Full Name
Source Code Comments
Columns Comments for SIBFACD_PIDM (# 1)
Source Code Comments
Columns Comments for SIBFACD_1ST_APPT_DT (# 2)
Source Code Comments
Columns Comments for SIBFACD_RANK_CODE (# 3)
Source Code Comments
Columns Comments for SIBFACD_RANK_DATE (# 4)
Source Code Comments
Columns Comments for SIBFACD_DISP_CODE (# 5)
Source Code Comments
Columns Comments for SIBFACD_TENR_CODE (# 6)
Source Code Comments
Columns Comments for SIBFACD_TENURE_DATE (# 7)
Source Code Comments
Columns Comments for SIBFACD_TENURE_REV_DATE (# 8)
Source Code Comments
Columns Comments for SIBFACD_LAST_SABB_DATE (# 9)
Source Code Comments
Columns Comments for SIBFACD_NEXT_SABB_DATE (# 10)
Source Code Comments
Columns Comments for SIBFACD_YRS_EXP (# 11)
Source Code Comments
Columns Comments for SIBFACD_BIRTH_STATE (# 12)
Source Code Comments
Columns Comments for SIBFACD_AAUP_MEM_IND (# 13)
Source Code Comments
Columns Comments for SIBFACD_ACTIVITY_DATE (# 14)
Source Code Comments
Columns Comments for SIBFACD_ACADEMIC_TITLE (# 15)
Source Code Comments
Columns Comments for SIBFACD_PRIMARY_ACTIVITY (# 16)
Source Code Comments
Table SIBINST
Object Full Name
Source Code Comments
Columns Comments for SIBINST_PIDM (# 1)
Source Code Comments
Columns Comments for SIBINST_TERM_CODE_EFF (# 2)
Source Code Comments
Columns Comments for SIBINST_FCST_CODE (# 3)
Source Code Comments
Columns Comments for SIBINST_FCTG_CODE (# 4)
Source Code Comments
Columns Comments for SIBINST_FSTP_CODE (# 5)
Source Code Comments
Columns Comments for SIBINST_FCNT_CODE (# 6)
Source Code Comments
Columns Comments for SIBINST_SCHD_IND (# 7)
Source Code Comments
Columns Comments for SIBINST_ADVR_IND (# 8)
Source Code Comments
Columns Comments for SIBINST_FCST_DATE (# 9)
Source Code Comments
Columns Comments for SIBINST_WKLD_CODE (# 10)
Source Code Comments
Columns Comments for SIBINST_CNTR_CODE (# 11)
Source Code Comments
Columns Comments for SIBINST_APPOINT_DATE (# 12)
Source Code Comments
Columns Comments for SIBINST_ACTIVITY_DATE (# 13)
Source Code Comments
Columns Comments for SIBINST_DATA_ORIGIN (# 14)
Source Code Comments
Columns Comments for SIBINST_USER_ID (# 15)
Source Code Comments
Table SIBTERM
Object Full Name
Source Code Comments
Columns Comments for SIBTERM_TERM_CODE (# 1)
Source Code Comments
Columns Comments for SIBTERM_FTE_FACTOR (# 2)
Source Code Comments
Columns Comments for SIBTERM_CALC_DEV_FACTOR (# 3)
Source Code Comments
Columns Comments for SIBTERM_ACTIVITY_DATE (# 4)
Source Code Comments
Table SIRASGN
Object Full Name
Source Code Comments
Columns Comments for SIRASGN_TERM_CODE (# 1)
Source Code Comments
Columns Comments for SIRASGN_CRN (# 2)
Source Code Comments
Columns Comments for SIRASGN_PIDM (# 3)
Source Code Comments
Columns Comments for SIRASGN_CATEGORY (# 4)
Source Code Comments
Columns Comments for SIRASGN_PERCENT_RESPONSE (# 5)
Source Code Comments
Columns Comments for SIRASGN_WORKLOAD_ADJUST (# 6)
Source Code Comments
Columns Comments for SIRASGN_PERCENT_SESS (# 7)
Source Code Comments
Columns Comments for SIRASGN_PRIMARY_IND (# 8)
Source Code Comments
Columns Comments for SIRASGN_OVER_RIDE (# 9)
Source Code Comments
Columns Comments for SIRASGN_POSITION (# 10)
Source Code Comments
Columns Comments for SIRASGN_ACTIVITY_DATE (# 11)
Source Code Comments
Columns Comments for SIRASGN_FCNT_CODE (# 12)
Source Code Comments
Columns Comments for SIRASGN_POSN (# 13)
Source Code Comments
Columns Comments for SIRASGN_SUFF (# 14)
Source Code Comments
Columns Comments for SIRASGN_ASTY_CODE (# 15)
Source Code Comments
Columns Comments for SIRASGN_DATA_ORIGIN (# 16)
Source Code Comments
Columns Comments for SIRASGN_USER_ID (# 17)
Source Code Comments
Columns Comments for SIRASGN_WORKLOAD_INCR (# 18)
Source Code Comments
Columns Comments for SIRASGN_INCR_ENRL (# 19)
Source Code Comments
Columns Comments for SIRASGN_INCR_ENRL_DATE (# 20)
Source Code Comments
Table SIRATTR
Object Full Name
Source Code Comments
Columns Comments for SIRATTR_PIDM (# 1)
Source Code Comments
Columns Comments for SIRATTR_TERM_CODE_EFF (# 2)
Source Code Comments
Columns Comments for SIRATTR_FATT_CODE (# 3)
Source Code Comments
Columns Comments for SIRATTR_ACTIVITY_DATE (# 4)
Source Code Comments
Table SIRCMNT
Object Full Name
Source Code Comments
Columns Comments for SIRCMNT_PIDM (# 1)
Source Code Comments
Columns Comments for SIRCMNT_TERM_CODE_EFF (# 2)
Source Code Comments
Columns Comments for SIRCMNT_SEQNO (# 3)
Source Code Comments
Columns Comments for SIRCMNT_TEXT (# 4)
Source Code Comments
Columns Comments for SIRCMNT_ACTIVITY_DATE (# 5)
Source Code Comments
Table SIRCOLC
Object Full Name
Source Code Comments
Columns Comments for SIRCOLC_SESSIONID (# 1)
Source Code Comments
Columns Comments for SIRCOLC_FATT_CODE (# 2)
Source Code Comments
Table SIRCOLR
Object Full Name
Source Code Comments
Columns Comments for SIRCOLR_SESSIONID (# 1)
Source Code Comments
Columns Comments for SIRCOLR_PIDM (# 2)
Source Code Comments
Columns Comments for SIRCOLR_TERM_CODE (# 3)
Source Code Comments
Columns Comments for SIRCOLR_FCNT_CODE (# 4)
Source Code Comments
Columns Comments for SIRCOLR_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for SIRCOLR_TERM_CODE_EFF (# 6)
Source Code Comments
Table SIRDPCL
Object Full Name
Source Code Comments
Columns Comments for SIRDPCL_PIDM (# 1)
Source Code Comments
Columns Comments for SIRDPCL_TERM_CODE_EFF (# 2)
Source Code Comments
Columns Comments for SIRDPCL_COLL_CODE (# 3)
Source Code Comments
Columns Comments for SIRDPCL_DEPT_CODE (# 4)
Source Code Comments
Columns Comments for SIRDPCL_HOME_IND (# 5)
Source Code Comments
Columns Comments for SIRDPCL_PERCENTAGE (# 6)
Source Code Comments
Columns Comments for SIRDPCL_ACTIVITY_DATE (# 7)
Source Code Comments
Table SIRFCNT
Object Full Name
Source Code Comments
Columns Comments for SIRFCNT_FCNT_CODE (# 1)
Source Code Comments
Columns Comments for SIRFCNT_TERM_CODE_EFF (# 2)
Source Code Comments
Columns Comments for SIRFCNT_TERM_CODE (# 3)
Source Code Comments
Columns Comments for SIRFCNT_ACTIVITY_DATE (# 4)
Source Code Comments
Table SIRFLCT
Object Full Name
Source Code Comments
Columns Comments for SIRFLCT_TERM_CODE (# 1)
Source Code Comments
Columns Comments for SIRFLCT_FCNT_CODE (# 2)
Source Code Comments
Columns Comments for SIRFLCT_STATUS (# 3)
Source Code Comments
Columns Comments for SIRFLCT_CNTR_CODE (# 4)
Source Code Comments
Columns Comments for SIRFLCT_CREDIT_HR_LOW (# 5)
Source Code Comments
Columns Comments for SIRFLCT_CREDIT_HR_HIGH (# 6)
Source Code Comments
Columns Comments for SIRFLCT_CREDIT_HR_LOW_GEN (# 7)
Source Code Comments
Columns Comments for SIRFLCT_CREDIT_HR_HIGH_GEN (# 8)
Source Code Comments
Columns Comments for SIRFLCT_CONTACT_HR_LOW (# 9)
Source Code Comments
Columns Comments for SIRFLCT_CONTACT_HR_HIGH (# 10)
Source Code Comments
Columns Comments for SIRFLCT_CONTACT_HR_LOW_WEEK (# 11)
Source Code Comments
Columns Comments for SIRFLCT_CONTACT_HR_HIGH_WEEK (# 12)
Source Code Comments
Columns Comments for SIRFLCT_INST_WORKLOAD_LOW (# 13)
Source Code Comments
Columns Comments for SIRFLCT_INST_WORKLOAD_HIGH (# 14)
Source Code Comments
Columns Comments for SIRFLCT_NIST_WORKLOAD_LOW (# 15)
Source Code Comments
Columns Comments for SIRFLCT_NIST_WORKLOAD_HIGH (# 16)
Source Code Comments
Columns Comments for SIRFLCT_TOT_WORKLOAD_LOW (# 17)
Source Code Comments
Columns Comments for SIRFLCT_TOT_WORKLOAD_HIGH (# 18)
Source Code Comments
Columns Comments for SIRFLCT_FTE_LOW (# 19)
Source Code Comments
Columns Comments for SIRFLCT_FTE_HIGH (# 20)
Source Code Comments
Columns Comments for SIRFLCT_ACTIVITY_DATE (# 21)
Source Code Comments
Table SIRFLRC
Object Full Name
Source Code Comments
Columns Comments for SIRFLRC_FCNT_CODE (# 1)
Source Code Comments
Columns Comments for SIRFLRC_TERM_CODE_EFF (# 2)
Source Code Comments
Columns Comments for SIRFLRC_STATUS (# 3)
Source Code Comments
Columns Comments for SIRFLRC_CNTR_CODE (# 4)
Source Code Comments
Columns Comments for SIRFLRC_CREDIT_HR_LOW (# 5)
Source Code Comments
Columns Comments for SIRFLRC_CREDIT_HR_HIGH (# 6)
Source Code Comments
Columns Comments for SIRFLRC_CREDIT_HR_LOW_GEN (# 7)
Source Code Comments
Columns Comments for SIRFLRC_CREDIT_HR_HIGH_GEN (# 8)
Source Code Comments
Columns Comments for SIRFLRC_CONTACT_HR_LOW (# 9)
Source Code Comments
Columns Comments for SIRFLRC_CONTACT_HR_HIGH (# 10)
Source Code Comments
Columns Comments for SIRFLRC_CONTACT_HR_LOW_WEEK (# 11)
Source Code Comments
Columns Comments for SIRFLRC_CONTACT_HR_HIGH_WEEK (# 12)
Source Code Comments
Columns Comments for SIRFLRC_INST_WORKLOAD_LOW (# 13)
Source Code Comments
Columns Comments for SIRFLRC_INST_WORKLOAD_HIGH (# 14)
Source Code Comments
Columns Comments for SIRFLRC_NIST_WORKLOAD_LOW (# 15)
Source Code Comments
Columns Comments for SIRFLRC_NIST_WORKLOAD_HIGH (# 16)
Source Code Comments
Columns Comments for SIRFLRC_TOT_WORKLOAD_LOW (# 17)
Source Code Comments
Columns Comments for SIRFLRC_TOT_WORKLOAD_HIGH (# 18)
Source Code Comments
Columns Comments for SIRFLRC_FTE_FACTOR (# 19)
Source Code Comments
Columns Comments for SIRFLRC_FTE_LOW (# 20)
Source Code Comments
Columns Comments for SIRFLRC_FTE_HIGH (# 21)
Source Code Comments
Columns Comments for SIRFLRC_ACTIVITY_DATE (# 22)
Source Code Comments
Table SIRFLRT
Object Full Name
Source Code Comments
Columns Comments for SIRFLRT_TERM_CODE (# 1)
Source Code Comments
Columns Comments for SIRFLRT_STATUS (# 2)
Source Code Comments
Columns Comments for SIRFLRT_WKLD_CODE (# 3)
Source Code Comments
Columns Comments for SIRFLRT_CREDIT_HR_LOW (# 4)
Source Code Comments
Columns Comments for SIRFLRT_CREDIT_HR_HIGH (# 5)
Source Code Comments
Columns Comments for SIRFLRT_CREDIT_HR_LOW_GEN (# 6)
Source Code Comments
Columns Comments for SIRFLRT_CREDIT_HR_HIGH_GEN (# 7)
Source Code Comments
Columns Comments for SIRFLRT_CONTACT_HR_LOW (# 8)
Source Code Comments
Columns Comments for SIRFLRT_CONTACT_HR_HIGH (# 9)
Source Code Comments
Columns Comments for SIRFLRT_CONTACT_HR_LOW_WEEK (# 10)
Source Code Comments
Columns Comments for SIRFLRT_CONTACT_HR_HIGH_WEEK (# 11)
Source Code Comments
Columns Comments for SIRFLRT_INST_WORKLOAD_LOW (# 12)
Source Code Comments
Columns Comments for SIRFLRT_INST_WORKLOAD_HIGH (# 13)
Source Code Comments
Columns Comments for SIRFLRT_NIST_WORKLOAD_LOW (# 14)
Source Code Comments
Columns Comments for SIRFLRT_NIST_WORKLOAD_HIGH (# 15)
Source Code Comments
Columns Comments for SIRFLRT_TOT_WORKLOAD_LOW (# 16)
Source Code Comments
Columns Comments for SIRFLRT_TOT_WORKLOAD_HIGH (# 17)
Source Code Comments
Columns Comments for SIRFLRT_FTE_LOW (# 18)
Source Code Comments
Columns Comments for SIRFLRT_FTE_HIGH (# 19)
Source Code Comments
Columns Comments for SIRFLRT_ACTIVITY_DATE (# 20)
Source Code Comments
Table SIRICNT
Object Full Name
Source Code Comments
Columns Comments for SIRICNT_PIDM (# 1)
Source Code Comments
Columns Comments for SIRICNT_TERM_CODE_EFF (# 2)
Source Code Comments
Columns Comments for SIRICNT_FCNT_CODE (# 3)
Source Code Comments
Columns Comments for SIRICNT_CNTR_CODE (# 4)
Source Code Comments
Columns Comments for SIRICNT_DEF_IND (# 5)
Source Code Comments
Columns Comments for SIRICNT_ACTIVITY_DATE (# 6)
Source Code Comments
Table SIRLVAS
Object Full Name
Source Code Comments
Columns Comments for SIRLVAS_TERM_CODE (# 1)
Source Code Comments
Columns Comments for SIRLVAS_CRN (# 2)
Source Code Comments
Columns Comments for SIRLVAS_PIDM (# 3)
Source Code Comments
Columns Comments for SIRLVAS_CATEGORY (# 4)
Source Code Comments
Columns Comments for SIRLVAS_PERCENT_RESPONSE (# 5)
Source Code Comments
Columns Comments for SIRLVAS_PERCENT_SESS (# 6)
Source Code Comments
Columns Comments for SIRLVAS_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for SIRLVAS_WORKLOAD_ADJUST (# 8)
Source Code Comments
Columns Comments for SIRLVAS_PRIMARY_IND (# 9)
Source Code Comments
Columns Comments for SIRLVAS_OVERRIDE_IND (# 10)
Source Code Comments
Columns Comments for SIRLVAS_POSITION (# 11)
Source Code Comments
Columns Comments for SIRLVAS_FCNT_CODE (# 12)
Source Code Comments
Columns Comments for SIRLVAS_POSN (# 13)
Source Code Comments
Columns Comments for SIRLVAS_SUFF (# 14)
Source Code Comments
Columns Comments for SIRLVAS_ASTY_CODE (# 15)
Source Code Comments
Table SIRNIST
Object Full Name
Source Code Comments
Columns Comments for SIRNIST_TERM_CODE (# 1)
Source Code Comments
Columns Comments for SIRNIST_PIDM (# 2)
Source Code Comments
Columns Comments for SIRNIST_NIST_CODE (# 3)
Source Code Comments
Columns Comments for SIRNIST_COLL_CODE (# 4)
Source Code Comments
Columns Comments for SIRNIST_DEPT_CODE (# 5)
Source Code Comments
Columns Comments for SIRNIST_NIST_WORKLOAD (# 6)
Source Code Comments
Columns Comments for SIRNIST_TOPS_CODE (# 7)
Source Code Comments
Columns Comments for SIRNIST_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for SIRNIST_FCNT_CODE (# 9)
Source Code Comments
Columns Comments for SIRNIST_POSN (# 10)
Source Code Comments
Columns Comments for SIRNIST_SUFF (# 11)
Source Code Comments
Columns Comments for SIRNIST_ASTY_CODE (# 12)
Source Code Comments
Columns Comments for SIRNIST_WEEKLY_HRS (# 13)
Source Code Comments
Table SIRNLVA
Object Full Name
Source Code Comments
Columns Comments for SIRNLVA_TERM_CODE (# 1)
Source Code Comments
Columns Comments for SIRNLVA_PIDM (# 2)
Source Code Comments
Columns Comments for SIRNLVA_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for SIRNLVA_NIST_CODE (# 4)
Source Code Comments
Columns Comments for SIRNLVA_COLL_CODE (# 5)
Source Code Comments
Columns Comments for SIRNLVA_DEPT_CODE (# 6)
Source Code Comments
Columns Comments for SIRNLVA_NIST_WORKLOAD (# 7)
Source Code Comments
Columns Comments for SIRNLVA_NIST_WEEKLY_HRS (# 8)
Source Code Comments
Columns Comments for SIRNLVA_TOPS_CODE (# 9)
Source Code Comments
Columns Comments for SIRNLVA_FCNT_CODE (# 10)
Source Code Comments
Columns Comments for SIRNLVA_POSN (# 11)
Source Code Comments
Columns Comments for SIRNLVA_SUFF (# 12)
Source Code Comments
Columns Comments for SIRNLVA_ASTY_CODE (# 13)
Source Code Comments
Table SIROFFC
Object Full Name
Source Code Comments
Columns Comments for SIROFFC_TERM_CODE (# 1)
Source Code Comments
Columns Comments for SIROFFC_CRN (# 2)
Source Code Comments
Columns Comments for SIROFFC_PIDM (# 3)
Source Code Comments
Columns Comments for SIROFFC_FROM_DATE (# 4)
Source Code Comments
Columns Comments for SIROFFC_TO_DATE (# 5)
Source Code Comments
Columns Comments for SIROFFC_FROM_TIME (# 6)
Source Code Comments
Columns Comments for SIROFFC_DISPLAY_IND (# 8)
Source Code Comments
Columns Comments for SIROFFC_ACTIVITY_DATE (# 9)
Source Code Comments
Columns Comments for SIROFFC_USER_ID (# 10)
Source Code Comments
Columns Comments for SIROFFC_LOCATION (# 11)
Source Code Comments
Columns Comments for SIROFFC_TELE_CODE (# 12)
Source Code Comments
Columns Comments for SIROFFC_PHONE_AREA (# 13)
Source Code Comments
Columns Comments for SIROFFC_PHONE_NUMBER (# 14)
Source Code Comments
Columns Comments for SIROFFC_PHONE_EXTN (# 15)
Source Code Comments
Columns Comments for SIROFFC_SUN_DAY (# 16)
Source Code Comments
Columns Comments for SIROFFC_MON_DAY (# 17)
Source Code Comments
Columns Comments for SIROFFC_TUE_DAY (# 18)
Source Code Comments
Columns Comments for SIROFFC_WED_DAY (# 19)
Source Code Comments
Columns Comments for SIROFFC_THU_DAY (# 20)
Source Code Comments
Columns Comments for SIROFFC_FRI_DAY (# 21)
Source Code Comments
Columns Comments for SIROFFC_SAT_DAY (# 22)
Source Code Comments
Columns Comments for SIROFFC_CTRY_CODE_PHONE (# 23)
Source Code Comments
Link between SIRDPCL and SIBINST
Join Information
Link between SIRICNT and SIBINST
Join Information
Link between SIBCFTE and SIRCOLR
Join Information
Link between SIBTERM and SIRASGN
Join Information
Link between SIRFCNT and SIRASGN
Join Information
Link between SIRASGN and SIRCOLR
Join Information
Link between SIRFCNT and SIRCOLR
Join Information
Link between SIBFACD and SIBINST
Join Information
Link between SIBINST and SIRASGN
Join Information
Link between SIROFFC and SIRASGN
Join Information
Link between SIRCOLC and PK_SIRCOLC
Link between SIRCOLR and PK_SIRCOLR
Link between SIRLVAS and PK_SIRLVAS
Link between SIROFFC and PK_SIROFFC
Link between SIBINST and PK_SIBINST
Link between SIBFACD and PK_SIBFACD
Link between SIRASGN and PK_SIRASGN
Link between SIBTERM and PK_SIBTERM