• 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 NBREARN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for NBREARN_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for NBREARN_POSN (# 2)
      • Source Code Comments
    • Columns Comments for NBREARN_SUFF (# 3)
      • Source Code Comments
    • Columns Comments for NBREARN_EFFECTIVE_DATE (# 4)
      • Source Code Comments
    • Columns Comments for NBREARN_EARN_CODE (# 5)
      • Source Code Comments
    • Columns Comments for NBREARN_ACTIVE_IND (# 6)
      • Source Code Comments
    • Columns Comments for NBREARN_HRS (# 7)
      • Source Code Comments
    • Columns Comments for NBREARN_SPECIAL_RATE (# 8)
      • Source Code Comments
    • Columns Comments for NBREARN_SHIFT (# 9)
      • Source Code Comments
    • Columns Comments for NBREARN_ACTIVITY_DATE (# 10)
      • Source Code Comments
    • Columns Comments for NBREARN_DEEMED_HRS (# 11)
      • Source Code Comments
    • Columns Comments for NBREARN_USER_ID (# 12)
      • Source Code Comments
    • Columns Comments for NBREARN_DATA_ORIGIN (# 13)
      • Source Code Comments
  • Table NBRERRN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for NBRERRN_SPEX_CODE (# 1)
      • Source Code Comments
    • Columns Comments for NBRERRN_SCENARIO (# 2)
      • Source Code Comments
    • Columns Comments for NBRERRN_PIDM (# 3)
      • Source Code Comments
    • Columns Comments for NBRERRN_POSN (# 4)
      • Source Code Comments
    • Columns Comments for NBRERRN_SUFF (# 5)
      • Source Code Comments
    • Columns Comments for NBRERRN_EFFECTIVE_DATE (# 6)
      • Source Code Comments
    • Columns Comments for NBRERRN_EFF_DATE_PROPOSED (# 7)
      • Source Code Comments
    • Columns Comments for NBRERRN_EARN_CODE (# 8)
      • Source Code Comments
    • Columns Comments for NBRERRN_ORGN_CODE_POSN (# 9)
      • Source Code Comments
    • Columns Comments for NBRERRN_SHIFT (# 10)
      • Source Code Comments
    • Columns Comments for NBRERRN_RECORD_STATUS (# 11)
      • Source Code Comments
    • Columns Comments for NBRERRN_USER_ID (# 12)
      • Source Code Comments
    • Columns Comments for NBRERRN_ACTIVITY_DATE (# 13)
      • Source Code Comments
    • Columns Comments for NBRERRN_HRS (# 14)
      • Source Code Comments
    • Columns Comments for NBRERRN_HRS_PROPOSED (# 15)
      • Source Code Comments
    • Columns Comments for NBRERRN_CANCEL_DATE (# 16)
      • Source Code Comments
    • Columns Comments for NBRERRN_SPECIAL_RATE (# 17)
      • Source Code Comments
    • Columns Comments for NBRERRN_TRANSACTION_NO (# 18)
      • Source Code Comments
  • Table NBRJLBD
    • Object Full Name
    • Source Code Comments
    • Columns Comments for NBRJLBD_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for NBRJLBD_POSN (# 2)
      • Source Code Comments
    • Columns Comments for NBRJLBD_SUFF (# 3)
      • Source Code Comments
    • Columns Comments for NBRJLBD_EFFECTIVE_DATE (# 4)
      • Source Code Comments
    • Columns Comments for NBRJLBD_COAS_CODE (# 5)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ACCI_CODE (# 6)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FUND_CODE (# 7)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ORGN_CODE (# 8)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ACCT_CODE (# 9)
      • Source Code Comments
    • Columns Comments for NBRJLBD_PROG_CODE (# 10)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ACTV_CODE (# 11)
      • Source Code Comments
    • Columns Comments for NBRJLBD_LOCN_CODE (# 12)
      • Source Code Comments
    • Columns Comments for NBRJLBD_PROJ_CODE (# 13)
      • Source Code Comments
    • Columns Comments for NBRJLBD_CTYP_CODE (# 14)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ACCT_CODE_EXTERNAL (# 15)
      • Source Code Comments
    • Columns Comments for NBRJLBD_PERCENT (# 16)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ENCD_NUM (# 17)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ENCD_SEQ_NUM (# 18)
      • Source Code Comments
    • Columns Comments for NBRJLBD_SALARY_ENCUMBRANCE (# 19)
      • Source Code Comments
    • Columns Comments for NBRJLBD_SALARY_ENC_TO_POST (# 20)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FRINGE_ENCUMBRANCE (# 21)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FRINGE_ENC_TO_POST (# 22)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FUND_CODE_FRINGE (# 23)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ORGN_CODE_FRINGE (# 24)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ACCT_CODE_FRINGE (# 25)
      • Source Code Comments
    • Columns Comments for NBRJLBD_PROG_CODE_FRINGE (# 26)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ACTV_CODE_FRINGE (# 27)
      • Source Code Comments
    • Columns Comments for NBRJLBD_LOCN_CODE_FRINGE (# 28)
      • Source Code Comments
    • Columns Comments for NBRJLBD_CHANGE_IND (# 29)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ACTIVITY_DATE (# 30)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FRINGE_RESIDUAL (# 31)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FRINGE_RES_TO_POST (# 32)
      • Source Code Comments
    • Columns Comments for NBRJLBD_USER_ID (# 33)
      • Source Code Comments
    • Columns Comments for NBRJLBD_DATA_ORIGIN (# 34)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FUTURE_SALARY_ENC (# 35)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FUTURE_FRINGE_ENC (# 36)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FUTURE_FRINGE_RESIDUAL (# 37)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FUTURE_SAL_ENC_TO_POST (# 38)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FUTURE_FRG_ENC_TO_POST (# 39)
      • Source Code Comments
    • Columns Comments for NBRJLBD_FUTURE_FRG_RES_TO_POST (# 40)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ENC_OVERRIDE_END_DATE (# 41)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ENC_LAST_RECAST_DATE (# 42)
      • Source Code Comments
    • Columns Comments for NBRJLBD_ENC_LAST_CALC_DATE (# 43)
      • Source Code Comments
  • Table NBRJOBS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for NBRJOBS_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for NBRJOBS_POSN (# 2)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SUFF (# 3)
      • Source Code Comments
    • Columns Comments for NBRJOBS_EFFECTIVE_DATE (# 4)
      • Source Code Comments
    • Columns Comments for NBRJOBS_STATUS (# 5)
      • Source Code Comments
    • Columns Comments for NBRJOBS_DESC (# 6)
      • Source Code Comments
    • Columns Comments for NBRJOBS_ECLS_CODE (# 7)
      • Source Code Comments
    • Columns Comments for NBRJOBS_PICT_CODE (# 8)
      • Source Code Comments
    • Columns Comments for NBRJOBS_COAS_CODE_TS (# 9)
      • Source Code Comments
    • Columns Comments for NBRJOBS_ORGN_CODE_TS (# 10)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SAL_TABLE (# 11)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SAL_GRADE (# 12)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SAL_STEP (# 13)
      • Source Code Comments
    • Columns Comments for NBRJOBS_APPT_PCT (# 14)
      • Source Code Comments
    • Columns Comments for NBRJOBS_FTE (# 15)
      • Source Code Comments
    • Columns Comments for NBRJOBS_HRS_DAY (# 16)
      • Source Code Comments
    • Columns Comments for NBRJOBS_HRS_PAY (# 17)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SHIFT (# 18)
      • Source Code Comments
    • Columns Comments for NBRJOBS_REG_RATE (# 19)
      • Source Code Comments
    • Columns Comments for NBRJOBS_ASSGN_SALARY (# 20)
      • Source Code Comments
    • Columns Comments for NBRJOBS_FACTOR (# 21)
      • Source Code Comments
    • Columns Comments for NBRJOBS_ANN_SALARY (# 22)
      • Source Code Comments
    • Columns Comments for NBRJOBS_PER_PAY_SALARY (# 23)
      • Source Code Comments
    • Columns Comments for NBRJOBS_PAYS (# 24)
      • Source Code Comments
    • Columns Comments for NBRJOBS_PER_PAY_DEFER_AMT (# 25)
      • Source Code Comments
    • Columns Comments for NBRJOBS_ACTIVITY_DATE (# 26)
      • Source Code Comments
    • Columns Comments for NBRJOBS_JCRE_CODE (# 27)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SGRP_CODE (# 28)
      • Source Code Comments
    • Columns Comments for NBRJOBS_EMPR_CODE (# 29)
      • Source Code Comments
    • Columns Comments for NBRJOBS_LGCD_CODE (# 30)
      • Source Code Comments
    • Columns Comments for NBRJOBS_LOCN_CODE (# 31)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SCHL_CODE (# 32)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SUPERVISOR_PIDM (# 33)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SUPERVISOR_POSN (# 34)
      • Source Code Comments
    • Columns Comments for NBRJOBS_SUPERVISOR_SUFF (# 35)
      • Source Code Comments
    • Columns Comments for NBRJOBS_WKCP_CODE (# 36)
      • Source Code Comments
    • Columns Comments for NBRJOBS_JBLN_CODE (# 37)
      • Source Code Comments
    • Columns Comments for NBRJOBS_PERS_CHG_DATE (# 38)
      • Source Code Comments
    • Columns Comments for NBRJOBS_PCAT_CODE (# 39)
      • Source Code Comments
    • Columns Comments for NBRJOBS_DFPR_CODE (# 40)
      • Source Code Comments
    • Columns Comments for NBRJOBS_ENCUMBRANCE_HRS (# 41)
      • Source Code Comments
    • Columns Comments for NBRJOBS_CONTRACT_NO (# 42)
      • Source Code Comments
    • Columns Comments for NBRJOBS_STRS_ASSN_CODE (# 43)
      • Source Code Comments
    • Columns Comments for NBRJOBS_STRS_PAY_CODE (# 44)
      • Source Code Comments
    • Columns Comments for NBRJOBS_PERS_PAY_CODE (# 45)
      • Source Code Comments
    • Columns Comments for NBRJOBS_TIME_ENTRY_METHOD (# 46)
      • Source Code Comments
    • Columns Comments for NBRJOBS_TIME_ENTRY_TYPE (# 47)
      • Source Code Comments
    • Columns Comments for NBRJOBS_TIME_IN_OUT_IND (# 48)
      • Source Code Comments
    • Columns Comments for NBRJOBS_LCAT_CODE (# 49)
      • Source Code Comments
    • Columns Comments for NBRJOBS_LEAV_REPT_METHOD (# 50)
      • Source Code Comments
    • Columns Comments for NBRJOBS_PICT_CODE_LEAV_REPT (# 51)
      • Source Code Comments
    • Columns Comments for NBRJOBS_USER_ID (# 52)
      • Source Code Comments
    • Columns Comments for NBRJOBS_DATA_ORIGIN (# 53)
      • Source Code Comments
  • Table PERDAYH
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERDAYH_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERDAYH_TETH_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for PERDAYH_TIME_ENTRY_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PERDAYH_JOBS_STATUS (# 4)
      • Source Code Comments
    • Columns Comments for PERDAYH_SHCD_CODE (# 5)
      • Source Code Comments
    • Columns Comments for PERDAYH_ACTIVITY_DATE (# 6)
      • Source Code Comments
  • Table PERDAYS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERDAYS_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERDAYS_TIME_ENTRY_DATE (# 2)
      • Source Code Comments
    • Columns Comments for PERDAYS_JOBS_STATUS (# 3)
      • Source Code Comments
    • Columns Comments for PERDAYS_SHCD_CODE (# 4)
      • Source Code Comments
    • Columns Comments for PERDAYS_ACTIVITY_DATE (# 5)
      • Source Code Comments
  • Table PEREARH
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PEREARH_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PEREARH_TETH_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for PEREARH_EARN_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PEREARH_SHIFT (# 4)
      • Source Code Comments
    • Columns Comments for PEREARH_SPECIAL_RATE (# 5)
      • Source Code Comments
    • Columns Comments for PEREARH_DEFAULT_HRS (# 6)
      • Source Code Comments
    • Columns Comments for PEREARH_ACTIVITY_DATE (# 7)
      • Source Code Comments
  • Table PEREARN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PEREARN_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PEREARN_EARN_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PEREARN_SHIFT (# 3)
      • Source Code Comments
    • Columns Comments for PEREARN_SPECIAL_RATE (# 4)
      • Source Code Comments
    • Columns Comments for PEREARN_DEFAULT_HRS (# 5)
      • Source Code Comments
    • Columns Comments for PEREARN_ACTIVITY_DATE (# 6)
      • Source Code Comments
  • Table PERELBD
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERELBD_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERELBD_EARN_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PERELBD_SHIFT (# 3)
      • Source Code Comments
    • Columns Comments for PERELBD_SPECIAL_RATE (# 4)
      • Source Code Comments
    • Columns Comments for PERELBD_SEQNO (# 6)
      • Source Code Comments
    • Columns Comments for PERELBD_COAS_CODE (# 7)
      • Source Code Comments
    • Columns Comments for PERELBD_ACCI_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PERELBD_FUND_CODE (# 9)
      • Source Code Comments
    • Columns Comments for PERELBD_ORGN_CODE (# 10)
      • Source Code Comments
    • Columns Comments for PERELBD_ACCT_CODE (# 11)
      • Source Code Comments
    • Columns Comments for PERELBD_PROG_CODE (# 12)
      • Source Code Comments
    • Columns Comments for PERELBD_ACTV_CODE (# 13)
      • Source Code Comments
    • Columns Comments for PERELBD_LOCN_CODE (# 14)
      • Source Code Comments
    • Columns Comments for PERELBD_PROJ_CODE (# 15)
      • Source Code Comments
    • Columns Comments for PERELBD_CTYP_CODE (# 16)
      • Source Code Comments
    • Columns Comments for PERELBD_ACCT_CODE_EXTERNAL (# 17)
      • Source Code Comments
    • Columns Comments for PERELBD_HRS (# 18)
      • Source Code Comments
    • Columns Comments for PERELBD_ACTIVITY_DATE (# 19)
      • Source Code Comments
  • Table PERELBH
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERELBH_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERELBH_TETH_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for PERELBH_EARN_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PERELBH_SHIFT (# 4)
      • Source Code Comments
    • Columns Comments for PERELBH_SPECIAL_RATE (# 5)
      • Source Code Comments
    • Columns Comments for PERELBH_SEQNO (# 7)
      • Source Code Comments
    • Columns Comments for PERELBH_COAS_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PERELBH_ACCI_CODE (# 9)
      • Source Code Comments
    • Columns Comments for PERELBH_FUND_CODE (# 10)
      • Source Code Comments
    • Columns Comments for PERELBH_ORGN_CODE (# 11)
      • Source Code Comments
    • Columns Comments for PERELBH_ACCT_CODE (# 12)
      • Source Code Comments
    • Columns Comments for PERELBH_PROG_CODE (# 13)
      • Source Code Comments
    • Columns Comments for PERELBH_ACTV_CODE (# 14)
      • Source Code Comments
    • Columns Comments for PERELBH_LOCN_CODE (# 15)
      • Source Code Comments
    • Columns Comments for PERELBH_PROJ_CODE (# 16)
      • Source Code Comments
    • Columns Comments for PERELBH_CTYP_CODE (# 17)
      • Source Code Comments
    • Columns Comments for PERELBH_ACCT_CODE_EXTERNAL (# 18)
      • Source Code Comments
    • Columns Comments for PERELBH_HRS (# 19)
      • Source Code Comments
    • Columns Comments for PERELBH_ACTIVITY_DATE (# 20)
      • Source Code Comments
  • Table PERHOUH
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERHOUH_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERHOUH_TETH_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for PERHOUH_EARN_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PERHOUH_SHIFT (# 4)
      • Source Code Comments
    • Columns Comments for PERHOUH_SPECIAL_RATE (# 5)
      • Source Code Comments
    • Columns Comments for PERHOUH_TIME_ENTRY_DATE (# 6)
      • Source Code Comments
    • Columns Comments for PERHOUH_HRS (# 7)
      • Source Code Comments
    • Columns Comments for PERHOUH_ACTIVITY_DATE (# 8)
      • Source Code Comments
  • Table PERHOUR
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERHOUR_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERHOUR_EARN_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PERHOUR_SHIFT (# 3)
      • Source Code Comments
    • Columns Comments for PERHOUR_SPECIAL_RATE (# 4)
      • Source Code Comments
    • Columns Comments for PERHOUR_TIME_ENTRY_DATE (# 5)
      • Source Code Comments
    • Columns Comments for PERHOUR_HRS (# 6)
      • Source Code Comments
    • Columns Comments for PERHOUR_ACTIVITY_DATE (# 7)
      • Source Code Comments
  • Table PERJOBH
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERJOBH_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERJOBH_TETH_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for PERJOBH_YEAR (# 3)
      • Source Code Comments
    • Columns Comments for PERJOBH_PICT_CODE (# 4)
      • Source Code Comments
    • Columns Comments for PERJOBH_PAYNO (# 5)
      • Source Code Comments
    • Columns Comments for PERJOBH_MONTH (# 6)
      • Source Code Comments
    • Columns Comments for PERJOBH_ACTION_IND (# 7)
      • Source Code Comments
    • Columns Comments for PERJOBH_PIDM (# 8)
      • Source Code Comments
    • Columns Comments for PERJOBH_POSN (# 9)
      • Source Code Comments
    • Columns Comments for PERJOBH_SUFF (# 10)
      • Source Code Comments
    • Columns Comments for PERJOBH_COAS_CODE_TS (# 11)
      • Source Code Comments
    • Columns Comments for PERJOBH_ORGN_CODE_TS (# 12)
      • Source Code Comments
    • Columns Comments for PERJOBH_STATUS_IND (# 13)
      • Source Code Comments
    • Columns Comments for PERJOBH_JOB_TITLE (# 14)
      • Source Code Comments
    • Columns Comments for PERJOBH_ECLS_CODE (# 16)
      • Source Code Comments
    • Columns Comments for PERJOBH_TIME_ENTRY_METHOD (# 17)
      • Source Code Comments
    • Columns Comments for PERJOBH_TIME_ENTRY_TYPE (# 18)
      • Source Code Comments
    • Columns Comments for PERJOBH_TIME_IN_OUT_IND (# 19)
      • Source Code Comments
    • Columns Comments for PERJOBH_ACAT_CODE (# 20)
      • Source Code Comments
    • Columns Comments for PERJOBH_COMMENT (# 21)
      • Source Code Comments
    • Columns Comments for PERJOBH_COMMENT_DATE_TIME (# 22)
      • Source Code Comments
    • Columns Comments for PERJOBH_COMMENT_CONFID_IND (# 23)
      • Source Code Comments
    • Columns Comments for PERJOBH_ACTIVITY_DATE (# 24)
      • Source Code Comments
    • Columns Comments for PERJOBH_LCAT_CODE (# 25)
      • Source Code Comments
    • Columns Comments for PERJOBH_COMMENT_PIDM (# 26)
      • Source Code Comments
  • Table PERJOBS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERJOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERJOBS_YEAR (# 2)
      • Source Code Comments
    • Columns Comments for PERJOBS_PICT_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PERJOBS_PAYNO (# 4)
      • Source Code Comments
    • Columns Comments for PERJOBS_MONTH (# 5)
      • Source Code Comments
    • Columns Comments for PERJOBS_ACTION_IND (# 6)
      • Source Code Comments
    • Columns Comments for PERJOBS_PIDM (# 7)
      • Source Code Comments
    • Columns Comments for PERJOBS_POSN (# 8)
      • Source Code Comments
    • Columns Comments for PERJOBS_SUFF (# 9)
      • Source Code Comments
    • Columns Comments for PERJOBS_COAS_CODE_TS (# 10)
      • Source Code Comments
    • Columns Comments for PERJOBS_ORGN_CODE_TS (# 11)
      • Source Code Comments
    • Columns Comments for PERJOBS_STATUS_IND (# 12)
      • Source Code Comments
    • Columns Comments for PERJOBS_JOB_TITLE (# 13)
      • Source Code Comments
    • Columns Comments for PERJOBS_SHIFT (# 14)
      • Source Code Comments
    • Columns Comments for PERJOBS_ECLS_CODE (# 15)
      • Source Code Comments
    • Columns Comments for PERJOBS_TIME_ENTRY_METHOD (# 16)
      • Source Code Comments
    • Columns Comments for PERJOBS_TIME_ENTRY_TYPE (# 17)
      • Source Code Comments
    • Columns Comments for PERJOBS_TIME_IN_OUT_IND (# 18)
      • Source Code Comments
    • Columns Comments for PERJOBS_ACAT_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PERJOBS_COMMENT (# 20)
      • Source Code Comments
    • Columns Comments for PERJOBS_COMMENT_DATE_TIME (# 21)
      • Source Code Comments
    • Columns Comments for PERJOBS_COMMENT_CONFID_IND (# 22)
      • Source Code Comments
    • Columns Comments for PERJOBS_ACTIVITY_DATE (# 23)
      • Source Code Comments
    • Columns Comments for PERJOBS_LCAT_CODE (# 24)
      • Source Code Comments
    • Columns Comments for PERJOBS_APPT_PCT (# 25)
      • Source Code Comments
    • Columns Comments for PERJOBS_FTE (# 26)
      • Source Code Comments
    • Columns Comments for PERJOBS_HRS_DAY (# 27)
      • Source Code Comments
    • Columns Comments for PERJOBS_COMMENT_PIDM (# 28)
      • Source Code Comments
  • Table PERJTOT
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERJTOT_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PERJTOT_YEAR (# 2)
      • Source Code Comments
    • Columns Comments for PERJTOT_POSN (# 3)
      • Source Code Comments
    • Columns Comments for PERJTOT_SUFF (# 4)
      • Source Code Comments
    • Columns Comments for PERJTOT_EARN_CODE (# 5)
      • Source Code Comments
    • Columns Comments for PERJTOT_MONTH (# 6)
      • Source Code Comments
    • Columns Comments for PERJTOT_HRS (# 7)
      • Source Code Comments
    • Columns Comments for PERJTOT_GRS (# 8)
      • Source Code Comments
    • Columns Comments for PERJTOT_ACTIVITY_DATE (# 9)
      • Source Code Comments
    • Columns Comments for PERJTOT_EMPR_CODE (# 10)
      • Source Code Comments
  • Table PERLVTK
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERLVTK_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERLVTK_EARN_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PERLVTK_LEAV_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PERLVTK_USER_ID (# 4)
      • Source Code Comments
    • Columns Comments for PERLVTK_ACTIVITY_DATE (# 5)
      • Source Code Comments
    • Columns Comments for PERLVTK_HRS (# 6)
      • Source Code Comments
  • Table PERROUT
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERROUT_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERROUT_APPR_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for PERROUT_APPR_POSN (# 3)
      • Source Code Comments
    • Columns Comments for PERROUT_APPR_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PERROUT_APPR_ACTION_IND (# 5)
      • Source Code Comments
    • Columns Comments for PERROUT_MANDATORY_APPR_IND (# 6)
      • Source Code Comments
    • Columns Comments for PERROUT_ACTION_PIDM (# 7)
      • Source Code Comments
    • Columns Comments for PERROUT_QUEUE_STATUS_IND (# 8)
      • Source Code Comments
    • Columns Comments for PERROUT_STATUS_DATE_TIME (# 9)
      • Source Code Comments
    • Columns Comments for PERROUT_ACTIVITY_DATE (# 10)
      • Source Code Comments
  • Table PERTETH
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERTETH_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERTETH_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for PERTETH_TRANS_TYPE_IND (# 3)
      • Source Code Comments
    • Columns Comments for PERTETH_TRANS_ROLE_IND (# 4)
      • Source Code Comments
    • Columns Comments for PERTETH_TRANS_PIDM (# 5)
      • Source Code Comments
    • Columns Comments for PERTETH_TRANS_DATE_TIME (# 6)
      • Source Code Comments
    • Columns Comments for PERTETH_TRANS_SOURCE_IND (# 7)
      • Source Code Comments
    • Columns Comments for PERTETH_ACTIVITY_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PERTETH_TRANS_PROXY_FOR_PIDM (# 9)
      • Source Code Comments
  • Table PERTITH
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERTITH_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERTITH_TETH_SEQNO (# 2)
      • Source Code Comments
    • Columns Comments for PERTITH_EARN_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PERTITH_TIME_ENTRY_DATE (# 4)
      • Source Code Comments
    • Columns Comments for PERTITH_TIME_IN (# 5)
      • Source Code Comments
    • Columns Comments for PERTITH_TIME_OUT (# 6)
      • Source Code Comments
    • Columns Comments for PERTITH_SHIFT (# 7)
      • Source Code Comments
    • Columns Comments for PERTITH_SPECIAL_RATE (# 8)
      • Source Code Comments
    • Columns Comments for PERTITH_ACTIVITY_DATE (# 9)
      • Source Code Comments
  • Table PERTITO
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERTITO_JOBS_SEQNO (# 1)
      • Source Code Comments
    • Columns Comments for PERTITO_EARN_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PERTITO_TIME_ENTRY_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PERTITO_TIME_IN (# 4)
      • Source Code Comments
    • Columns Comments for PERTITO_TIME_OUT (# 5)
      • Source Code Comments
    • Columns Comments for PERTITO_SHIFT (# 6)
      • Source Code Comments
    • Columns Comments for PERTITO_SPECIAL_RATE (# 7)
      • Source Code Comments
    • Columns Comments for PERTITO_ACTIVITY_DATE (# 8)
      • Source Code Comments
  • Table PHRDIRD
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRDIRD_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRDIRD_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRDIRD_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRDIRD_COMPANY_NAME (# 4)
      • Source Code Comments
    • Columns Comments for PHRDIRD_ITEM_CNT (# 5)
      • Source Code Comments
    • Columns Comments for PHRDIRD_DOLLAR_AMT (# 6)
      • Source Code Comments
    • Columns Comments for PHRDIRD_HASH_TOTAL (# 7)
      • Source Code Comments
    • Columns Comments for PHRDIRD_PAY_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PHRDIRD_ACTIVITY_DATE (# 9)
      • Source Code Comments
  • Table PHREARN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHREARN_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHREARN_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHREARN_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHREARN_COAS_CODE_TS (# 4)
      • Source Code Comments
    • Columns Comments for PHREARN_ORGN_CODE_TS (# 5)
      • Source Code Comments
    • Columns Comments for PHREARN_TS_ROSTER_IND (# 6)
      • Source Code Comments
    • Columns Comments for PHREARN_PIDM (# 7)
      • Source Code Comments
    • Columns Comments for PHREARN_SEQ_NO (# 8)
      • Source Code Comments
    • Columns Comments for PHREARN_POSN (# 9)
      • Source Code Comments
    • Columns Comments for PHREARN_SUFF (# 10)
      • Source Code Comments
    • Columns Comments for PHREARN_EFFECTIVE_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PHREARN_EARN_CODE (# 12)
      • Source Code Comments
    • Columns Comments for PHREARN_SHIFT (# 13)
      • Source Code Comments
    • Columns Comments for PHREARN_GEN_IND (# 14)
      • Source Code Comments
    • Columns Comments for PHREARN_HRS (# 15)
      • Source Code Comments
    • Columns Comments for PHREARN_UPDATE_HRS (# 16)
      • Source Code Comments
    • Columns Comments for PHREARN_RATE (# 17)
      • Source Code Comments
    • Columns Comments for PHREARN_SPECIAL_RATE (# 18)
      • Source Code Comments
    • Columns Comments for PHREARN_AMT (# 19)
      • Source Code Comments
    • Columns Comments for PHREARN_ACTIVITY_DATE (# 20)
      • Source Code Comments
    • Columns Comments for PHREARN_TS_ENTRY_SEQ (# 21)
      • Source Code Comments
    • Columns Comments for PHREARN_TS_PRINT_SEQ (# 22)
      • Source Code Comments
    • Columns Comments for PHREARN_REDISTRIBUTION_IND (# 23)
      • Source Code Comments
    • Columns Comments for PHREARN_DEEMED_HRS (# 24)
      • Source Code Comments
    • Columns Comments for PHREARN_ACCRUE_SENIORITY_IND (# 25)
      • Source Code Comments
  • Table PHRERRL
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRERRL_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRERRL_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRERRL_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRERRL_COAS_CODE_TS (# 4)
      • Source Code Comments
    • Columns Comments for PHRERRL_ORGN_CODE_TS (# 5)
      • Source Code Comments
    • Columns Comments for PHRERRL_TS_ROSTER_IND (# 6)
      • Source Code Comments
    • Columns Comments for PHRERRL_PIDM (# 7)
      • Source Code Comments
    • Columns Comments for PHRERRL_SEQ_NO (# 8)
      • Source Code Comments
    • Columns Comments for PHRERRL_POSN (# 9)
      • Source Code Comments
    • Columns Comments for PHRERRL_SUFF (# 10)
      • Source Code Comments
    • Columns Comments for PHRERRL_EFFECTIVE_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PHRERRL_STATUS (# 12)
      • Source Code Comments
    • Columns Comments for PHRERRL_ECLS_CODE (# 13)
      • Source Code Comments
    • Columns Comments for PHRERRL_DISP (# 14)
      • Source Code Comments
    • Columns Comments for PHRERRL_EARN_CODE (# 15)
      • Source Code Comments
    • Columns Comments for PHRERRL_BDCA_CODE (# 16)
      • Source Code Comments
    • Columns Comments for PHRERRL_LEAV_CODE (# 17)
      • Source Code Comments
    • Columns Comments for PHRERRL_BASE_SAL_HRS (# 18)
      • Source Code Comments
    • Columns Comments for PHRERRL_SALARY_RATE (# 19)
      • Source Code Comments
    • Columns Comments for PHRERRL_PER_PAY_SALARY (# 20)
      • Source Code Comments
    • Columns Comments for PHRERRL_CONTRACT_TYPE (# 21)
      • Source Code Comments
    • Columns Comments for PHRERRL_ID_SEQ (# 22)
      • Source Code Comments
    • Columns Comments for PHRERRL_LAST_NAME_SEQ (# 23)
      • Source Code Comments
    • Columns Comments for PHRERRL_FIRST_NAME_SEQ (# 24)
      • Source Code Comments
    • Columns Comments for PHRERRL_SHIFT (# 25)
      • Source Code Comments
    • Columns Comments for PHRERRL_HRS (# 26)
      • Source Code Comments
    • Columns Comments for PHRERRL_UPDATE_HRS (# 27)
      • Source Code Comments
    • Columns Comments for PHRERRL_RATE (# 28)
      • Source Code Comments
    • Columns Comments for PHRERRL_SPECIAL_RATE (# 29)
      • Source Code Comments
    • Columns Comments for PHRERRL_AMT (# 30)
      • Source Code Comments
    • Columns Comments for PHRERRL_ADJS_SEQ_NO (# 31)
      • Source Code Comments
    • Columns Comments for PHRERRL_COMMENT (# 32)
      • Source Code Comments
    • Columns Comments for PHRERRL_ACTIVITY_DATE (# 33)
      • Source Code Comments
    • Columns Comments for PHRERRL_TIME_ENTRY_ACTION_IND (# 34)
      • Source Code Comments
    • Columns Comments for PHRERRL_TIME_ENTRY_DATE (# 35)
      • Source Code Comments
  • Table PHRHOUR
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRHOUR_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRHOUR_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRHOUR_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRHOUR_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHRHOUR_SEQ_NO (# 5)
      • Source Code Comments
    • Columns Comments for PHRHOUR_POSN (# 6)
      • Source Code Comments
    • Columns Comments for PHRHOUR_SUFF (# 7)
      • Source Code Comments
    • Columns Comments for PHRHOUR_EFFECTIVE_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PHRHOUR_EARN_CODE (# 9)
      • Source Code Comments
    • Columns Comments for PHRHOUR_SHIFT (# 10)
      • Source Code Comments
    • Columns Comments for PHRHOUR_BEGIN_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PHRHOUR_END_DATE (# 12)
      • Source Code Comments
    • Columns Comments for PHRHOUR_HRS (# 13)
      • Source Code Comments
    • Columns Comments for PHRHOUR_AMT (# 14)
      • Source Code Comments
    • Columns Comments for PHRHOUR_ACTIVITY_DATE (# 15)
      • Source Code Comments
    • Columns Comments for PHRHOUR_GEN_IND (# 16)
      • Source Code Comments
  • Table PHRREDS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRREDS_USER_ID (# 1)
      • Source Code Comments
    • Columns Comments for PHRREDS_SESSION_ID (# 2)
      • Source Code Comments
    • Columns Comments for PHRREDS_TYPE (# 3)
      • Source Code Comments
    • Columns Comments for PHRREDS_YEAR (# 4)
      • Source Code Comments
    • Columns Comments for PHRREDS_PICT_CODE (# 5)
      • Source Code Comments
    • Columns Comments for PHRREDS_PAYNO (# 6)
      • Source Code Comments
    • Columns Comments for PHRREDS_PIDM (# 7)
      • Source Code Comments
    • Columns Comments for PHRREDS_SEQ_NO (# 8)
      • Source Code Comments
    • Columns Comments for PHRREDS_POSN (# 9)
      • Source Code Comments
    • Columns Comments for PHRREDS_SUFF (# 10)
      • Source Code Comments
    • Columns Comments for PHRREDS_EFFECTIVE_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PHRREDS_EARN_CODE (# 12)
      • Source Code Comments
    • Columns Comments for PHRREDS_SHIFT (# 13)
      • Source Code Comments
    • Columns Comments for PHRREDS_GEN_IND (# 14)
      • Source Code Comments
    • Columns Comments for PHRREDS_COAS_CODE_TS (# 15)
      • Source Code Comments
    • Columns Comments for PHRREDS_ORGN_CODE_TS (# 16)
      • Source Code Comments
    • Columns Comments for PHRREDS_TS_ROSTER_IND (# 17)
      • Source Code Comments
    • Columns Comments for PHRREDS_COAS_CODE (# 18)
      • Source Code Comments
    • Columns Comments for PHRREDS_ACCI_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PHRREDS_FUND_CODE (# 20)
      • Source Code Comments
    • Columns Comments for PHRREDS_ORGN_CODE (# 21)
      • Source Code Comments
    • Columns Comments for PHRREDS_ACCT_CODE (# 22)
      • Source Code Comments
    • Columns Comments for PHRREDS_PROG_CODE (# 23)
      • Source Code Comments
    • Columns Comments for PHRREDS_ACTV_CODE (# 24)
      • Source Code Comments
    • Columns Comments for PHRREDS_LOCN_CODE (# 25)
      • Source Code Comments
    • Columns Comments for PHRREDS_PROJ_CODE (# 26)
      • Source Code Comments
    • Columns Comments for PHRREDS_CTYP_CODE (# 27)
      • Source Code Comments
    • Columns Comments for PHRREDS_ACCT_CODE_EXTERNAL (# 28)
      • Source Code Comments
    • Columns Comments for PHRREDS_PERCENT (# 29)
      • Source Code Comments
    • Columns Comments for PHRREDS_HRS (# 30)
      • Source Code Comments
    • Columns Comments for PHRREDS_ENCD_NUM (# 31)
      • Source Code Comments
    • Columns Comments for PHRREDS_ENCD_SEQ_NUM (# 32)
      • Source Code Comments
    • Columns Comments for PHRREDS_ACTIVITY_DATE (# 33)
      • Source Code Comments
    • Columns Comments for PHRREDS_REDISTRIBUTION_AMT (# 34)
      • Source Code Comments
    • Columns Comments for PHRREDS_STATUS (# 35)
      • Source Code Comments
    • Columns Comments for PHRREDS_POSTING_OVERRIDE_DATE (# 36)
      • Source Code Comments
  • Table PTRCALN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRCALN_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PTRCALN_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTRCALN_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PTRCALN_START_DATE (# 4)
      • Source Code Comments
    • Columns Comments for PTRCALN_END_DATE (# 5)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_DATE (# 6)
      • Source Code Comments
    • Columns Comments for PTRCALN_PAY_OF_MONTH_IND (# 7)
      • Source Code Comments
    • Columns Comments for PTRCALN_FISC_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PTRCALN_ACTIVITY_DATE (# 9)
      • Source Code Comments
    • Columns Comments for PTRCALN_ETOT_IND (# 10)
      • Source Code Comments
    • Columns Comments for PTRCALN_JTOT_IND (# 11)
      • Source Code Comments
    • Columns Comments for PTRCALN_DTOT_IND (# 12)
      • Source Code Comments
    • Columns Comments for PTRCALN_DEDN_IND (# 13)
      • Source Code Comments
    • Columns Comments for PTRCALN_JOBS_IND (# 14)
      • Source Code Comments
    • Columns Comments for PTRCALN_DEFER_IND (# 15)
      • Source Code Comments
    • Columns Comments for PTRCALN_TERM_IND (# 16)
      • Source Code Comments
    • Columns Comments for PTRCALN_LEAV_IND (# 17)
      • Source Code Comments
    • Columns Comments for PTRCALN_STATS_CANADA_YEAR (# 18)
      • Source Code Comments
    • Columns Comments for PTRCALN_STATS_CANADA_MONTH (# 19)
      • Source Code Comments
    • Columns Comments for PTRCALN_TIME_ENTRY_START_DATE (# 20)
      • Source Code Comments
    • Columns Comments for PTRCALN_TIME_ENTRY_END_DATE (# 21)
      • Source Code Comments
    • Columns Comments for PTRCALN_TIME_ENTRY_CUTOFF_TIME (# 22)
      • Source Code Comments
    • Columns Comments for PTRCALN_WEB_VIEW_CUTOFF_DATE (# 23)
      • Source Code Comments
    • Columns Comments for PTRCALN_LEAV_REPT_START_DATE (# 24)
      • Source Code Comments
    • Columns Comments for PTRCALN_LEAV_REPT_END_DATE (# 25)
      • Source Code Comments
    • Columns Comments for PTRCALN_LEAV_REPT_CUTOFF_TIME (# 26)
      • Source Code Comments
    • Columns Comments for PTRCALN_LR_WEBVIEW_CUTOFF_DATE (# 27)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_MESG_LINE1 (# 28)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_MESG_LINE2 (# 29)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_MESG_LINE3 (# 30)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_MESG_LINE4 (# 31)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_MESG_LINE5 (# 32)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_MESG_LINE6 (# 33)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_MESG_LINE7 (# 34)
      • Source Code Comments
    • Columns Comments for PTRCALN_CHECK_MESG_LINE8 (# 35)
      • Source Code Comments
  • Table PTREARN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTREARN_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTREARN_SHORT_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTREARN_LONG_DESC (# 3)
      • Source Code Comments
    • Columns Comments for PTREARN_RATE_IND (# 4)
      • Source Code Comments
    • Columns Comments for PTREARN_RATE (# 5)
      • Source Code Comments
    • Columns Comments for PTREARN_MULT_FACTOR (# 6)
      • Source Code Comments
    • Columns Comments for PTREARN_TYPE_IND (# 7)
      • Source Code Comments
    • Columns Comments for PTREARN_CASH_IND (# 8)
      • Source Code Comments
    • Columns Comments for PTREARN_SHFT_DIFF_IND (# 9)
      • Source Code Comments
    • Columns Comments for PTREARN_TAX_METHOD_IND (# 10)
      • Source Code Comments
    • Columns Comments for PTREARN_LEAV_CODE_TAKEN (# 11)
      • Source Code Comments
    • Columns Comments for PTREARN_LEAV_CODE_EARNED (# 12)
      • Source Code Comments
    • Columns Comments for PTREARN_LEAV_PRORATION_IND (# 13)
      • Source Code Comments
    • Columns Comments for PTREARN_LEAV_MINIMUM_IND (# 14)
      • Source Code Comments
    • Columns Comments for PTREARN_ECLD_IND (# 15)
      • Source Code Comments
    • Columns Comments for PTREARN_BASE_SAL_IND (# 16)
      • Source Code Comments
    • Columns Comments for PTREARN_EXCEPTION_IND (# 17)
      • Source Code Comments
    • Columns Comments for PTREARN_EXPENDED_BUD_IND (# 18)
      • Source Code Comments
    • Columns Comments for PTREARN_UNIT_IND (# 19)
      • Source Code Comments
    • Columns Comments for PTREARN_LONGEVITY_IND (# 20)
      • Source Code Comments
    • Columns Comments for PTREARN_FLSA_HRS_IND (# 21)
      • Source Code Comments
    • Columns Comments for PTREARN_FLSA_AMT_IND (# 22)
      • Source Code Comments
    • Columns Comments for PTREARN_RUCL_CODE (# 23)
      • Source Code Comments
    • Columns Comments for PTREARN_1099_CODE (# 24)
      • Source Code Comments
    • Columns Comments for PTREARN_PENSIONABLE_HRS_IND (# 25)
      • Source Code Comments
    • Columns Comments for PTREARN_FRINGE_IND (# 26)
      • Source Code Comments
    • Columns Comments for PTREARN_ACTIVITY_DATE (# 27)
      • Source Code Comments
    • Columns Comments for PTREARN_STIPEND_IND (# 28)
      • Source Code Comments
    • Columns Comments for PTREARN_ERGR_CODE (# 29)
      • Source Code Comments
    • Columns Comments for PTREARN_SPECIAL_COMP_IND (# 30)
      • Source Code Comments
    • Columns Comments for PTREARN_WEB_DISP_IND (# 31)
      • Source Code Comments
    • Columns Comments for PTREARN_NOT_DETERMINED_IND (# 32)
      • Source Code Comments
    • Columns Comments for PTREARN_OSHA_HRS_IND (# 33)
      • Source Code Comments
    • Columns Comments for PTREARN_MIS_ADDL_EARN_IND (# 34)
      • Source Code Comments
    • Columns Comments for PTREARN_RUCL_CODE_FRNG (# 35)
      • Source Code Comments
  • Table PTRLVAS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRLVAS_LCAT_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRLVAS_LEAV_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTRLVAS_FREQ_IND (# 3)
      • Source Code Comments
    • Columns Comments for PTRLVAS_SEQ_NO (# 4)
      • Source Code Comments
    • Columns Comments for PTRLVAS_ACTIVITY_DATE (# 5)
      • Source Code Comments
    • Columns Comments for PTRLVAS_BASE_DATE (# 6)
      • Source Code Comments
    • Columns Comments for PTRLVAS_ANN_DAY (# 7)
      • Source Code Comments
    • Columns Comments for PTRLVAS_EXCESS_IND (# 8)
      • Source Code Comments
    • Columns Comments for PTRLVAS_MIN_HRS (# 9)
      • Source Code Comments
    • Columns Comments for PTRLVAS_PRORATE_HRS (# 10)
      • Source Code Comments
    • Columns Comments for PTRLVAS_BANK_IND (# 11)
      • Source Code Comments
    • Columns Comments for PTRLVAS_ROLL_MONTH (# 12)
      • Source Code Comments
    • Columns Comments for PTRLVAS_ROLL_DAY (# 13)
      • Source Code Comments
    • Columns Comments for PTRLVAS_AVAIL_DAYS (# 14)
      • Source Code Comments
    • Columns Comments for PTRLVAS_AVAIL_MTHS (# 15)
      • Source Code Comments
    • Columns Comments for PTRLVAS_MIN_PCT (# 16)
      • Source Code Comments
    • Columns Comments for PTRLVAS_PRORATE_PCT (# 17)
      • Source Code Comments
    • Columns Comments for PTRLVAS_WEEK1_IND (# 18)
      • Source Code Comments
    • Columns Comments for PTRLVAS_WEEK2_IND (# 19)
      • Source Code Comments
    • Columns Comments for PTRLVAS_WEEK3_IND (# 20)
      • Source Code Comments
    • Columns Comments for PTRLVAS_WEEK4_IND (# 21)
      • Source Code Comments
    • Columns Comments for PTRLVAS_WEEK5_IND (# 22)
      • Source Code Comments
  • Table PTRPICT
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRPICT_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRPICT_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTRPICT_PAYS_PER_YEAR (# 3)
      • Source Code Comments
    • Columns Comments for PTRPICT_TAX_FACTOR (# 4)
      • Source Code Comments
    • Columns Comments for PTRPICT_SUPP_PAY_IND (# 5)
      • Source Code Comments
    • Columns Comments for PTRPICT_CODE_ORIG (# 6)
      • Source Code Comments
    • Columns Comments for PTRPICT_ACTIVITY_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PTRPICT_ROE_PERIOD_TYPE (# 8)
      • Source Code Comments
    • Columns Comments for PTRPICT_UI_MIN_HOURS (# 9)
      • Source Code Comments
    • Columns Comments for PTRPICT_UI_MIN_EARNINGS (# 10)
      • Source Code Comments
    • Columns Comments for PTRPICT_UI_MAX_EARNINGS (# 11)
      • Source Code Comments
    • Columns Comments for PTRPICT_UI_WEEKS (# 12)
      • Source Code Comments
    • Columns Comments for PTRPICT_BANK_CODE (# 13)
      • Source Code Comments
    • Columns Comments for PTRPICT_TS_CUTOFF_DAYS (# 14)
      • Source Code Comments
    • Columns Comments for PTRPICT_TS_CUTOFF_TIME (# 15)
      • Source Code Comments
    • Columns Comments for PTRPICT_TS_PRIOR_AFTER_IND (# 16)
      • Source Code Comments
    • Columns Comments for PTRPICT_TS_WEB_VIEW_MONTHS (# 17)
      • Source Code Comments
    • Columns Comments for PTRPICT_TS_LEAVE_REQUESTS (# 18)
      • Source Code Comments
  • Table PTVLCAT
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTVLCAT_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTVLCAT_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTVLCAT_ACTIVITY_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PTVLCAT_REPORT_IND (# 4)
      • Source Code Comments
    • Columns Comments for PTVLCAT_HOUR_DAY_IND (# 5)
      • Source Code Comments
    • Columns Comments for PTVLCAT_USER_ID (# 6)
      • Source Code Comments
  • Table SPRIDEN
    • Object Full Name
    • Source Code Comments
    • 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_USER (# 9)
      • Source Code Comments
    • Columns Comments for SPRIDEN_ORIGIN (# 10)
      • 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_NTYP_CODE (# 16)
      • Source Code Comments
    • Columns Comments for SPRIDEN_CREATE_USER (# 17)
      • Source Code Comments
    • Columns Comments for SPRIDEN_CREATE_DATE (# 18)
      • Source Code Comments
    • Columns Comments for SPRIDEN_DATA_ORIGIN (# 19)
      • Source Code Comments
    • Columns Comments for SPRIDEN_CREATE_FDMN_CODE (# 20)
      • Source Code Comments
    • Columns Comments for SPRIDEN_SURNAME_PREFIX (# 21)
      • Source Code Comments
  • Link between SPRIDEN and NBRBJOB
    • Join Information
  • Link between NBRJOBS and NBRBJOB
    • Join Information
  • Link between PTRPICT and NBRJOBS
    • Join Information
  • Link between PTVLCAT and NBRJOBS
    • Join Information
  • Link between SPRIDEN and PERJOBS
    • Join Information
  • Link between NBRJOBS and PTRCALN
    • Join Information
  • Link between SPRIDEN and NBRJOBS
    • Join Information
  • Link between PERJOBS and PTRCALN
    • Join Information
  • Link between PERJOBS and NBRBJOB
    • Join Information
  • Link between PERJOBS and PTVLCAT
    • Join Information
  • Link between SPRIDEN and PERJOBH
    • Join Information
  • Link between SPRIDEN and PERTETH
    • Join Information
  • Link between SPRIDEN and PERROUT
    • Join Information
  • Link between PTREARN and PERHOUR
    • Join Information
  • Link between PTREARN and PEREARN
    • Join Information
  • Link between PERHOUR and PERELBD
    • Join Information
  • Link between PTRPICT and PTRCALN
    • Join Information
  • Link between PTRLVAS and PTREARN
    • Join Information
  • Link between NBRERRN and PTREARN
    • Join Information
  • Link between NBREARN and PTREARN
    • Join Information
  • Link between PERROUT and PERJOBS
    • Join Information
  • Link between PERHOUR and PERDAYS
    • Join Information
  • Link between PERHOUR and PEREARN
    • Join Information
  • Link between PERTITO and PERDAYS
    • Join Information
  • Link between PHRERRL and PTREARN
    • Join Information
  • Link between NBRJLBD and PERJOBS
    • Join Information
  • Link between PERJOBH and PERTETH
    • Join Information
  • Link between PTRLVAS and NBRJOBS
    • Join Information
  • Link between PTRLVAS and PERJOBS
    • Join Information
  • Link between PERJOBS and PEREARN
    • Join Information
  • Link between PERHOUR and PERJOBS
    • Join Information
  • Link between PHREARN and PTREARN
  • Link between PTRLVAS and PTVLCAT
  • Link between PERJTOT and NBRBJOB
  • Link between PERJTOT and PTREARN
  • Link between PERLVTK and PERJOBS
  • Link between PERLVTK and PTREARN