Page written by CAST

- Model View
Table NBRBJOB
- Object Full Name
- Source Code Comments
- Columns Comments for NBRBJOB_PIDM (# 1)
  - Source Code Comments
- Columns Comments for NBRBJOB_POSN (# 2)
  - Source Code Comments
- Columns Comments for NBRBJOB_SUFF (# 3)
  - Source Code Comments
- Columns Comments for NBRBJOB_BEGIN_DATE (# 4)
  - Source Code Comments
- Columns Comments for NBRBJOB_END_DATE (# 5)
  - Source Code Comments
- Columns Comments for NBRBJOB_DEFER_BAL (# 6)
  - Source Code Comments
- Columns Comments for NBRBJOB_CONTRACT_TYPE (# 7)
  - Source Code Comments
- Columns Comments for NBRBJOB_SALARY_ENCUMBRANCE (# 8)
  - Source Code Comments
- Columns Comments for NBRBJOB_CONTRACT_BEGIN_DATE (# 9)
  - Source Code Comments
- Columns Comments for NBRBJOB_CONTRACT_END_DATE (# 10)
  - Source Code Comments
- Columns Comments for NBRBJOB_TOTAL_CONTRACT_HRS (# 11)
  - Source Code Comments
- Columns Comments for NBRBJOB_TOTAL_ENCUMBRANCE_HRS (# 12)
  - Source Code Comments
- Columns Comments for NBRBJOB_STEP_INCR_MON (# 13)
  - Source Code Comments
- Columns Comments for NBRBJOB_STEP_INCR_DAY (# 14)
  - Source Code Comments
- Columns Comments for NBRBJOB_COAS_CODE (# 15)
  - Source Code Comments
- Columns Comments for NBRBJOB_ACTIVITY_DATE (# 16)
  - Source Code Comments
- Columns Comments for NBRBJOB_ACCRUE_LEAVE_IND (# 17)
  - Source Code Comments
- Columns Comments for NBRBJOB_CIVIL_SERVICE_IND (# 18)
  - Source Code Comments
- Columns Comments for NBRBJOB_ENCUMBRANCE_CHANGE_IND (# 19)
  - Source Code Comments
- Columns Comments for NBRBJOB_FRINGE_ENCUMBRANCE (# 20)
  - Source Code Comments
- Columns Comments for NBRBJOB_IPEDS_REPT_IND (# 21)
  - Source Code Comments
- Columns Comments for NBRBJOB_FACL_STATSCAN_REPT_IND (# 22)
  - Source Code Comments
- Columns Comments for NBRBJOB_PROBATION_BEGIN_DATE (# 23)
  - Source Code Comments
- Columns Comments for NBRBJOB_PROBATION_END_DATE (# 24)
  - Source Code Comments
- Columns Comments for NBRBJOB_PROBATION_UNITS (# 25)
  - Source Code Comments
- Columns Comments for NBRBJOB_ELIGIBLE_DATE (# 26)
  - Source Code Comments
- Columns Comments for NBRBJOB_USER_ID (# 27)
  - Source Code Comments
- Columns Comments for NBRBJOB_DATA_ORIGIN (# 28)
  - Source Code Comments
- Columns Comments for NBRBJOB_FUTURE_SALARY_ENC (# 29)
  - Source Code Comments
- Columns Comments for NBRBJOB_FUTURE_FRINGE_ENC (# 30)
  - Source Code Comments
Table PEBEMPL
- Object Full Name
- Source Code Comments
- Columns Comments for PEBEMPL_PIDM (# 1)
  - Source Code Comments
- Columns Comments for PEBEMPL_EMPL_STATUS (# 2)
  - Source Code Comments
- Columns Comments for PEBEMPL_COAS_CODE_HOME (# 3)
  - Source Code Comments
- Columns Comments for PEBEMPL_ORGN_CODE_HOME (# 4)
  - Source Code Comments
- Columns Comments for PEBEMPL_COAS_CODE_DIST (# 5)
  - Source Code Comments
- Columns Comments for PEBEMPL_ORGN_CODE_DIST (# 6)
  - Source Code Comments
- Columns Comments for PEBEMPL_ECLS_CODE (# 7)
  - Source Code Comments
- Columns Comments for PEBEMPL_LCAT_CODE (# 8)
  - Source Code Comments
- Columns Comments for PEBEMPL_BCAT_CODE (# 9)
  - Source Code Comments
- Columns Comments for PEBEMPL_FIRST_HIRE_DATE (# 10)
  - Source Code Comments
- Columns Comments for PEBEMPL_CURRENT_HIRE_DATE (# 11)
  - Source Code Comments
- Columns Comments for PEBEMPL_ADJ_SERVICE_DATE (# 12)
  - Source Code Comments
- Columns Comments for PEBEMPL_SENIORITY_DATE (# 13)
  - Source Code Comments
- Columns Comments for PEBEMPL_LREA_CODE (# 14)
  - Source Code Comments
- Columns Comments for PEBEMPL_LOA_BEG_DATE (# 15)
  - Source Code Comments
- Columns Comments for PEBEMPL_LOA_END_DATE (# 16)
  - Source Code Comments
- Columns Comments for PEBEMPL_TREA_CODE (# 17)
  - Source Code Comments
- Columns Comments for PEBEMPL_TERM_DATE (# 18)
  - Source Code Comments
- Columns Comments for PEBEMPL_I9_FORM_IND (# 19)
  - Source Code Comments
- Columns Comments for PEBEMPL_I9_DATE (# 20)
  - Source Code Comments
- Columns Comments for PEBEMPL_I9_EXPIRE_DATE (# 21)
  - Source Code Comments
- Columns Comments for PEBEMPL_ACTIVITY_DATE (# 22)
  - Source Code Comments
- Columns Comments for PEBEMPL_WKPR_CODE (# 23)
  - Source Code Comments
- Columns Comments for PEBEMPL_FLSA_IND (# 24)
  - Source Code Comments
- Columns Comments for PEBEMPL_STGR_CODE (# 25)
  - Source Code Comments
- Columns Comments for PEBEMPL_DAYS_IN_CANADA (# 26)
  - Source Code Comments
- Columns Comments for PEBEMPL_1042_RECIPIENT_CD (# 27)
  - Source Code Comments
- Columns Comments for PEBEMPL_INTERNAL_FT_PT_IND (# 28)
  - Source Code Comments
- Columns Comments for PEBEMPL_DICD_CODE (# 29)
  - Source Code Comments
- Columns Comments for PEBEMPL_EGRP_CODE (# 30)
  - Source Code Comments
- Columns Comments for PEBEMPL_IPEDS_SOFT_MONEY_IND (# 31)
  - Source Code Comments
- Columns Comments for PEBEMPL_FIRST_WORK_DATE (# 32)
  - Source Code Comments
- Columns Comments for PEBEMPL_LAST_WORK_DATE (# 33)
  - Source Code Comments
- Columns Comments for PEBEMPL_CALIF_PENSION_IND (# 34)
  - Source Code Comments
- Columns Comments for PEBEMPL_NRSI_CODE (# 35)
  - Source Code Comments
- Columns Comments for PEBEMPL_SSN_LAST_NAME (# 36)
  - Source Code Comments
- Columns Comments for PEBEMPL_SSN_FIRST_NAME (# 37)
  - Source Code Comments
- Columns Comments for PEBEMPL_SSN_MI (# 38)
  - Source Code Comments
- Columns Comments for PEBEMPL_SSN_SUFFIX (# 39)
  - Source Code Comments
- Columns Comments for PEBEMPL_JBLN_CODE (# 40)
  - Source Code Comments
- Columns Comments for PEBEMPL_COLL_CODE (# 41)
  - Source Code Comments
- Columns Comments for PEBEMPL_CAMP_CODE (# 42)
  - Source Code Comments
- Columns Comments for PEBEMPL_USER_ID (# 43)
  - Source Code Comments
- Columns Comments for PEBEMPL_DATA_ORIGIN (# 44)
  - Source Code Comments
- Columns Comments for PEBEMPL_EW2_CONSENT_IND (# 45)
  - Source Code Comments
- Columns Comments for PEBEMPL_EW2_CONSENT_DATE (# 46)
  - Source Code Comments
- Columns Comments for PEBEMPL_EW2_CONSENT_USER_ID (# 47)
  - Source Code Comments
- Columns Comments for PEBEMPL_IPEDS_PRIMARY_FUNCTION (# 48)
  - Source Code Comments
- Columns Comments for PEBEMPL_IPEDS_MED_DENTAL_IND (# 49)
  - Source Code Comments
- Columns Comments for PEBEMPL_ETAX_CONSENT_IND (# 50)
  - Source Code Comments
- Columns Comments for PEBEMPL_ETAX_CONSENT_DATE (# 51)
  - Source Code Comments
- Columns Comments for PEBEMPL_ETAX_CONSENT_USER_ID (# 52)
  - Source Code Comments
Table PEBGREV
- Object Full Name
- Source Code Comments
- Columns Comments for PEBGREV_NO (# 1)
  - Source Code Comments
- Columns Comments for PEBGREV_DESC (# 2)
  - Source Code Comments
- Columns Comments for PEBGREV_GRTP_CODE (# 3)
  - Source Code Comments
- Columns Comments for PEBGREV_ISTA_CODE (# 4)
  - Source Code Comments
- Columns Comments for PEBGREV_ISTA_DATE (# 5)
  - Source Code Comments
- Columns Comments for PEBGREV_FILED_DATE (# 6)
  - Source Code Comments
- Columns Comments for PEBGREV_RESOLVED_DATE (# 7)
  - Source Code Comments
- Columns Comments for PEBGREV_ACTIVITY_DATE (# 8)
  - Source Code Comments
Table PEBHSIN
- Object Full Name
- Source Code Comments
- Columns Comments for PEBHSIN_NO (# 1)
  - Source Code Comments
- Columns Comments for PEBHSIN_DESC (# 2)
  - Source Code Comments
- Columns Comments for PEBHSIN_INCIDENT_DATE (# 3)
  - Source Code Comments
- Columns Comments for PEBHSIN_HSIL_CODE (# 4)
  - Source Code Comments
- Columns Comments for PEBHSIN_ISTA_CODE (# 5)
  - Source Code Comments
- Columns Comments for PEBHSIN_ISTA_DATE (# 6)
  - Source Code Comments
- Columns Comments for PEBHSIN_ACTIVITY_DATE (# 7)
  - Source Code Comments
Table PERGRDS
- Object Full Name
- Source Code Comments
- Columns Comments for PERGRDS_GREV_NO (# 1)
  - Source Code Comments
- Columns Comments for PERGRDS_TEXT (# 2)
  - Source Code Comments
- Columns Comments for PERGRDS_ACTIVITY_DATE (# 3)
  - Source Code Comments
Table PERGRPA
- Object Full Name
- Source Code Comments
- Columns Comments for PERGRPA_GREV_NO (# 1)
  - Source Code Comments
- Columns Comments for PERGRPA_PIDM (# 2)
  - Source Code Comments
- Columns Comments for PERGRPA_GRPT_CODE (# 3)
  - Source Code Comments
- Columns Comments for PERGRPA_POSN (# 4)
  - Source Code Comments
- Columns Comments for PERGRPA_SUFF (# 5)
  - Source Code Comments
- Columns Comments for PERGRPA_GRIEVANT_IND (# 6)
  - Source Code Comments
- Columns Comments for PERGRPA_ACTIVITY_DATE (# 7)
  - Source Code Comments
Table PERGRRA
- Object Full Name
- Source Code Comments
- Columns Comments for PERGRRA_GREV_NO (# 1)
  - Source Code Comments
- Columns Comments for PERGRRA_GRSR_CODE (# 2)
  - Source Code Comments
- Columns Comments for PERGRRA_GRSR_DATE (# 3)
  - Source Code Comments
- Columns Comments for PERGRRA_ACTIVITY_DATE (# 4)
  - Source Code Comments
Table PERGRRE
- Object Full Name
- Source Code Comments
- Columns Comments for PERGRRE_GREV_NO (# 1)
  - Source Code Comments
- Columns Comments for PERGRRE_TEXT (# 2)
  - Source Code Comments
- Columns Comments for PERGRRE_ACTIVITY_DATE (# 3)
  - Source Code Comments
Table PTVGRPT
- Object Full Name
- Source Code Comments
- Columns Comments for PTVGRPT_CODE (# 1)
  - Source Code Comments
- Columns Comments for PTVGRPT_DESC (# 2)
  - Source Code Comments
- Columns Comments for PTVGRPT_ACTIVITY_DATE (# 3)
  - Source Code Comments
Table PTVGRSR
- Object Full Name
- Source Code Comments
- Columns Comments for PTVGRSR_CODE (# 1)
  - Source Code Comments
- Columns Comments for PTVGRSR_DESC (# 2)
  - Source Code Comments
- Columns Comments for PTVGRSR_ACTIVITY_DATE (# 3)
  - Source Code Comments
Table PTVGRTP
- Object Full Name
- Source Code Comments
- Columns Comments for PTVGRTP_CODE (# 1)
  - Source Code Comments
- Columns Comments for PTVGRTP_DESC (# 2)
  - Source Code Comments
- Columns Comments for PTVGRTP_ACTIVITY_DATE (# 3)
  - Source Code Comments
Table PTVISTA
- Object Full Name
- Source Code Comments
- Columns Comments for PTVISTA_CODE (# 1)
  - Source Code Comments
- Columns Comments for PTVISTA_DESC (# 2)
  - Source Code Comments
- Columns Comments for PTVISTA_ACTIVITY_DATE (# 3)
  - Source Code Comments
Link between NBRBJOB and PEBEMPL
- Join Information
Link between PEBHSIN and PTVISTA
Link between PERGRPA and NBRBJOB
Link between PERGRPA and PTVGRPT
Link between PERGRRA and PTVGRSR
Link between PERGRPA and PEBEMPL
Link between PERGRPA and PEBGREV
Link between PERGRRA and PEBGREV
Link between PEBGREV and PTVGRTP
Link between PEBGREV and PTVISTA