• Model View
  • 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 PDRXPID
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PDRXPID_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PDRXPID_BDCA_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PDRXPID_PICT_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PDRXPID_ACTIVITY_DATE (# 4)
      • 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 PEBROEC
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PEBROEC_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PEBROEC_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PEBROEC_ISSUE_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PEBROEC_PRINT_IND (# 4)
      • Source Code Comments
    • Columns Comments for PEBROEC_SERIAL_NO_AMEND (# 5)
      • Source Code Comments
    • Columns Comments for PEBROEC_REFERENCE_NO (# 6)
      • Source Code Comments
    • Columns Comments for PEBROEC_LANGUAGE_IND (# 7)
      • Source Code Comments
    • Columns Comments for PEBROEC_OCCUPATION (# 8)
      • Source Code Comments
    • Columns Comments for PEBROEC_FIRST_DAY_WORKED (# 9)
      • Source Code Comments
    • Columns Comments for PEBROEC_LAST_DAY_WORKED (# 10)
      • Source Code Comments
    • Columns Comments for PEBROEC_UI_PREMIUM_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PEBROEC_FINAL_PAY_END_DATE (# 12)
      • Source Code Comments
    • Columns Comments for PEBROEC_VACATION_PAY (# 13)
      • Source Code Comments
    • Columns Comments for PEBROEC_FINAL_PAY_IND (# 14)
      • Source Code Comments
    • Columns Comments for PEBROEC_LEAVE_START (# 15)
      • Source Code Comments
    • Columns Comments for PEBROEC_LEAVE_DURATION (# 16)
      • Source Code Comments
    • Columns Comments for PEBROEC_LEAVE_DURATION_IND (# 17)
      • Source Code Comments
    • Columns Comments for PEBROEC_LEAVE_AMOUNT (# 18)
      • Source Code Comments
    • Columns Comments for PEBROEC_ROER_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PEBROEC_CONTACT_PIDM (# 20)
      • Source Code Comments
    • Columns Comments for PEBROEC_CONTACT_PH_AREA (# 21)
      • Source Code Comments
    • Columns Comments for PEBROEC_CONTACT_PH_NUMBER (# 22)
      • Source Code Comments
    • Columns Comments for PEBROEC_CONTACT_PH_EXT (# 23)
      • Source Code Comments
    • Columns Comments for PEBROEC_RETURN_DATE (# 24)
      • Source Code Comments
    • Columns Comments for PEBROEC_RETURN_IND (# 25)
      • Source Code Comments
    • Columns Comments for PEBROEC_ISSUER_PIDM (# 26)
      • Source Code Comments
    • Columns Comments for PEBROEC_ISSUER_PH_AREA (# 27)
      • Source Code Comments
    • Columns Comments for PEBROEC_ISSUER_PH_NUMBER (# 28)
      • Source Code Comments
    • Columns Comments for PEBROEC_ISSUER_PH_EXT (# 29)
      • Source Code Comments
    • Columns Comments for PEBROEC_ACTIVITY_DATE (# 30)
      • Source Code Comments
    • Columns Comments for PEBROEC_EMPR_CODE (# 31)
      • Source Code Comments
  • Table PERJHIS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERJHIS_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PERJHIS_POSN (# 2)
      • Source Code Comments
    • Columns Comments for PERJHIS_SUFF (# 3)
      • Source Code Comments
    • Columns Comments for PERJHIS_EFFECTIVE_DATE (# 4)
      • Source Code Comments
    • Columns Comments for PERJHIS_STATUS (# 5)
      • Source Code Comments
    • Columns Comments for PERJHIS_ECLS_CODE (# 6)
      • Source Code Comments
    • Columns Comments for PERJHIS_BEGIN_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PERJHIS_END_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PERJHIS_PAYID (# 9)
      • Source Code Comments
    • Columns Comments for PERJHIS_SAL_TABLE (# 10)
      • Source Code Comments
    • Columns Comments for PERJHIS_SAL_GRADE (# 11)
      • Source Code Comments
    • Columns Comments for PERJHIS_SAL_STEP (# 12)
      • Source Code Comments
    • Columns Comments for PERJHIS_HRS_DAY (# 13)
      • Source Code Comments
    • Columns Comments for PERJHIS_REG_RATE (# 14)
      • Source Code Comments
    • Columns Comments for PERJHIS_ASSGN_SALARY (# 15)
      • Source Code Comments
    • Columns Comments for PERJHIS_ANN_SALARY (# 16)
      • Source Code Comments
    • Columns Comments for PERJHIS_USER_ID (# 17)
      • Source Code Comments
    • Columns Comments for PERJHIS_ACTIVITY_DATE (# 18)
      • Source Code Comments
    • Columns Comments for PERJHIS_JCRE_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PERJHIS_EMPR_CODE (# 20)
      • Source Code Comments
    • Columns Comments for PERJHIS_LOCN_CODE (# 21)
      • Source Code Comments
    • Columns Comments for PERJHIS_SCHL_CODE (# 22)
      • Source Code Comments
    • Columns Comments for PERJHIS_SUPERVISOR_PIDM (# 23)
      • Source Code Comments
    • Columns Comments for PERJHIS_SUPERVISOR_POSN (# 24)
      • Source Code Comments
    • Columns Comments for PERJHIS_SUPERVISOR_SUFF (# 25)
      • Source Code Comments
    • Columns Comments for PERJHIS_WKCP_CODE (# 26)
      • Source Code Comments
    • Columns Comments for PERJHIS_JBLN_CODE (# 27)
      • Source Code Comments
    • Columns Comments for PERJHIS_PERS_CHG_DATE (# 28)
      • Source Code Comments
    • Columns Comments for PERJHIS_DEFER_BAL (# 29)
      • Source Code Comments
    • Columns Comments for PERJHIS_CONTRACT_TYPE (# 30)
      • Source Code Comments
    • Columns Comments for PERJHIS_SALARY_ENCUMBRANCE (# 31)
      • Source Code Comments
    • Columns Comments for PERJHIS_CONTRACT_BEGIN_DATE (# 32)
      • Source Code Comments
    • Columns Comments for PERJHIS_CONTRACT_END_DATE (# 33)
      • Source Code Comments
    • Columns Comments for PERJHIS_STEP_INCR_MON (# 34)
      • Source Code Comments
    • Columns Comments for PERJHIS_STEP_INCR_DAY (# 35)
      • Source Code Comments
    • Columns Comments for PERJHIS_COAS_CODE (# 36)
      • Source Code Comments
    • Columns Comments for PERJHIS_ACCRUE_LEAVE_IND (# 37)
      • Source Code Comments
    • Columns Comments for PERJHIS_CIVIL_SERVICE_IND (# 38)
      • Source Code Comments
    • Columns Comments for PERJHIS_FRINGE_ENCUMBRANCE (# 39)
      • Source Code Comments
    • Columns Comments for PERJHIS_DESC (# 40)
      • Source Code Comments
    • Columns Comments for PERJHIS_COAS_CODE_TS (# 41)
      • Source Code Comments
    • Columns Comments for PERJHIS_ORGN_CODE_TS (# 42)
      • Source Code Comments
    • Columns Comments for PERJHIS_APPT_PCT (# 43)
      • Source Code Comments
    • Columns Comments for PERJHIS_FTE (# 44)
      • Source Code Comments
    • Columns Comments for PERJHIS_HRS_PAY (# 45)
      • Source Code Comments
    • Columns Comments for PERJHIS_SHIFT (# 46)
      • Source Code Comments
    • Columns Comments for PERJHIS_FACTOR (# 47)
      • Source Code Comments
    • Columns Comments for PERJHIS_PER_PAY_SALARY (# 48)
      • Source Code Comments
    • Columns Comments for PERJHIS_PAYS (# 49)
      • Source Code Comments
    • Columns Comments for PERJHIS_PER_PAY_DEFER_AMT (# 50)
      • Source Code Comments
    • Columns Comments for PERJHIS_SGRP_CODE (# 51)
      • Source Code Comments
    • Columns Comments for PERJHIS_LGCD_CODE (# 52)
      • Source Code Comments
    • Columns Comments for PERJHIS_PCAT_CODE (# 53)
      • Source Code Comments
    • Columns Comments for PERJHIS_DFPR_CODE (# 54)
      • Source Code Comments
    • Columns Comments for PERJHIS_ENCUMBRANCE_HRS (# 55)
      • Source Code Comments
    • Columns Comments for PERJHIS_CAPTURE_DATE (# 56)
      • Source Code Comments
    • Columns Comments for PERJHIS_TOTAL_ENCUMBRANCE_HRS (# 57)
      • Source Code Comments
    • Columns Comments for PERJHIS_TOTAL_CONTRACT_HRS (# 58)
      • Source Code Comments
    • Columns Comments for PERJHIS_TIME_ENTRY_METHOD (# 59)
      • Source Code Comments
    • Columns Comments for PERJHIS_TIME_ENTRY_TYPE (# 60)
      • Source Code Comments
    • Columns Comments for PERJHIS_TIME_IN_OUT_IND (# 61)
      • Source Code Comments
    • Columns Comments for PERJHIS_PROBATION_BEGIN_DATE (# 62)
      • Source Code Comments
    • Columns Comments for PERJHIS_PROBATION_END_DATE (# 63)
      • Source Code Comments
    • Columns Comments for PERJHIS_PROBATION_UNITS (# 64)
      • Source Code Comments
    • Columns Comments for PERJHIS_LCAT_CODE (# 65)
      • Source Code Comments
    • Columns Comments for PERJHIS_LEAV_REPT_METHOD (# 66)
      • Source Code Comments
    • Columns Comments for PERJHIS_ELIGIBLE_DATE (# 67)
      • Source Code Comments
    • Columns Comments for PERJHIS_COMMENT_DATE (# 68)
      • Source Code Comments
    • Columns Comments for PERJHIS_COMMENT_USER_ID (# 69)
      • Source Code Comments
    • Columns Comments for PERJHIS_COMMENT (# 70)
      • Source Code Comments
    • Columns Comments for PERJHIS_PICT_CODE_LEAV_REPT (# 71)
      • Source Code Comments
    • Columns Comments for PERJHIS_DATA_ORIGIN (# 72)
      • Source Code Comments
    • Columns Comments for PERJHIS_FUTURE_SALARY_ENC (# 73)
      • Source Code Comments
    • Columns Comments for PERJHIS_FUTURE_FRINGE_ENC (# 74)
      • Source Code Comments
  • Table PERJLEV
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERJLEV_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PERJLEV_POSN (# 2)
      • Source Code Comments
    • Columns Comments for PERJLEV_SUFF (# 3)
      • Source Code Comments
    • Columns Comments for PERJLEV_LEAV_CODE (# 4)
      • Source Code Comments
    • Columns Comments for PERJLEV_BEGIN_BALANCE (# 5)
      • Source Code Comments
    • Columns Comments for PERJLEV_ACCRUED (# 6)
      • Source Code Comments
    • Columns Comments for PERJLEV_TAKEN (# 7)
      • Source Code Comments
    • Columns Comments for PERJLEV_DATE_AVAIL (# 8)
      • Source Code Comments
    • Columns Comments for PERJLEV_HRS_BANKED (# 9)
      • Source Code Comments
    • Columns Comments for PERJLEV_USER_ID (# 10)
      • Source Code Comments
    • Columns Comments for PERJLEV_ACTIVITY_DATE (# 11)
      • Source Code Comments
  • Table PERRCMT
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERRCMT_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PERRCMT_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PERRCMT_ISSUE_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PERRCMT_COMMENT (# 4)
      • Source Code Comments
    • Columns Comments for PERRCMT_ACTIVITY_DATE (# 5)
      • Source Code Comments
    • Columns Comments for PERRCMT_SEQ_NO (# 6)
      • Source Code Comments
    • Columns Comments for PERRCMT_EMPR_CODE (# 7)
      • Source Code Comments
  • Table PERRHOL
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERRHOL_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PERRHOL_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PERRHOL_ISSUE_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PERRHOL_HOLIDAY_DATE (# 4)
      • Source Code Comments
    • Columns Comments for PERRHOL_HOLIDAY_PAY (# 5)
      • Source Code Comments
    • Columns Comments for PERRHOL_ACTIVITY_DATE (# 6)
      • Source Code Comments
    • Columns Comments for PERRHOL_EMPR_CODE (# 7)
      • Source Code Comments
  • Table PERROTH
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERROTH_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PERROTH_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PERROTH_ISSUE_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PERROTH_OTHER_MONIES_NOTE (# 4)
      • Source Code Comments
    • Columns Comments for PERROTH_OTHER_MONIES_AMT (# 5)
      • Source Code Comments
    • Columns Comments for PERROTH_ACTIVITY_DATE (# 6)
      • Source Code Comments
    • Columns Comments for PERROTH_EMPR_CODE (# 7)
      • Source Code Comments
  • Table PHR1042
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHR1042_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHR1042_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHR1042_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHR1042_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHR1042_SEQ_NO (# 5)
      • Source Code Comments
    • Columns Comments for PHR1042_EMPR_CODE (# 6)
      • Source Code Comments
    • Columns Comments for PHR1042_INCOME_CD (# 7)
      • Source Code Comments
    • Columns Comments for PHR1042_COUNTRY_CD (# 8)
      • Source Code Comments
    • Columns Comments for PHR1042_TAX_RATE (# 9)
      • Source Code Comments
    • Columns Comments for PHR1042_EXEMPTION_CD (# 10)
      • Source Code Comments
    • Columns Comments for PHR1042_GRADUATED_TAX_IND (# 11)
      • Source Code Comments
    • Columns Comments for PHR1042_GROSS_INCOME_PAID (# 12)
      • Source Code Comments
    • Columns Comments for PHR1042_WITHHOLDING_ALLOW (# 13)
      • Source Code Comments
    • Columns Comments for PHR1042_US_FEDERAL_TAX (# 14)
      • Source Code Comments
    • Columns Comments for PHR1042_ACTIVITY_DATE (# 15)
      • Source Code Comments
    • Columns Comments for PHR1042_BDCA_CODE (# 16)
      • Source Code Comments
    • Columns Comments for PHR1042_ALLOWANCE_TAKEN (# 17)
      • Source Code Comments
    • Columns Comments for PHR1042_INCOME_CD_SUB_TYPE (# 18)
      • Source Code Comments
  • Table PHRACCR
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRACCR_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRACCR_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRACCR_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRACCR_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHRACCR_LEAV_CODE (# 5)
      • Source Code Comments
    • Columns Comments for PHRACCR_CURR_ACCR (# 6)
      • Source Code Comments
    • Columns Comments for PHRACCR_CURR_TAKEN (# 7)
      • Source Code Comments
    • Columns Comments for PHRACCR_ACTIVITY_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PHRACCR_BANK_IND (# 9)
      • Source Code Comments
    • Columns Comments for PHRACCR_CALC_GEN_IND (# 10)
      • Source Code Comments
  • Table PHRATND
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRATND_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRATND_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRATND_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRATND_COAS_CODE_TS (# 4)
      • Source Code Comments
    • Columns Comments for PHRATND_ORGN_CODE_TS (# 5)
      • Source Code Comments
    • Columns Comments for PHRATND_TS_ROSTER_IND (# 6)
      • Source Code Comments
    • Columns Comments for PHRATND_PIDM (# 7)
      • Source Code Comments
    • Columns Comments for PHRATND_POSN (# 8)
      • Source Code Comments
    • Columns Comments for PHRATND_SUFF (# 9)
      • Source Code Comments
    • Columns Comments for PHRATND_EFFECTIVE_DATE (# 10)
      • Source Code Comments
    • Columns Comments for PHRATND_EARN_CODE (# 11)
      • Source Code Comments
    • Columns Comments for PHRATND_ATND_DATE (# 12)
      • Source Code Comments
    • Columns Comments for PHRATND_HOURS (# 13)
      • Source Code Comments
    • Columns Comments for PHRATND_LEAV_REASON (# 14)
      • Source Code Comments
    • Columns Comments for PHRATND_ACTIVITY_DATE (# 15)
      • Source Code Comments
  • Table PHRCMNT
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRCMNT_ID (# 1)
      • Source Code Comments
    • Columns Comments for PHRCMNT_YEAR (# 2)
      • Source Code Comments
    • Columns Comments for PHRCMNT_PICT_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PHRCMNT_PAYNO (# 4)
      • Source Code Comments
    • Columns Comments for PHRCMNT_PIDM (# 5)
      • Source Code Comments
    • Columns Comments for PHRCMNT_SEQ_NO (# 6)
      • Source Code Comments
    • Columns Comments for PHRCMNT_COMMENT (# 7)
      • Source Code Comments
    • Columns Comments for PHRCMNT_ACTIVITY_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PHRCMNT_USER_ID (# 9)
      • Source Code Comments
    • Columns Comments for PHRCMNT_DATA_ORIGIN (# 10)
      • Source Code Comments
  • Table PHRDEDN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRDEDN_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRDEDN_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRDEDN_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRDEDN_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHRDEDN_SEQ_NO (# 5)
      • Source Code Comments
    • Columns Comments for PHRDEDN_EFFECTIVE_DATE (# 6)
      • Source Code Comments
    • Columns Comments for PHRDEDN_STATUS (# 7)
      • Source Code Comments
    • Columns Comments for PHRDEDN_BDCA_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PHRDEDN_EMPLOYEE_AMT (# 9)
      • Source Code Comments
    • Columns Comments for PHRDEDN_EMPLOYER_AMT (# 10)
      • Source Code Comments
    • Columns Comments for PHRDEDN_APPLICABLE_GROSS (# 11)
      • Source Code Comments
    • Columns Comments for PHRDEDN_ARREAR_TAKEN (# 12)
      • Source Code Comments
    • Columns Comments for PHRDEDN_ARREAR_RECOVERED (# 13)
      • Source Code Comments
    • Columns Comments for PHRDEDN_ACTIVITY_DATE (# 14)
      • Source Code Comments
    • Columns Comments for PHRDEDN_EMPR_CODE (# 15)
      • Source Code Comments
  • Table PHRDOCM
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRDOCM_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRDOCM_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRDOCM_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRDOCM_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHRDOCM_SEQ_NO (# 5)
      • Source Code Comments
    • Columns Comments for PHRDOCM_DOC_TYPE (# 6)
      • Source Code Comments
    • Columns Comments for PHRDOCM_PRIORITY (# 7)
      • Source Code Comments
    • Columns Comments for PHRDOCM_DOC_NO (# 8)
      • Source Code Comments
    • Columns Comments for PHRDOCM_DOC_DATE (# 9)
      • Source Code Comments
    • Columns Comments for PHRDOCM_NET (# 10)
      • Source Code Comments
    • Columns Comments for PHRDOCM_BANK_CODE (# 11)
      • Source Code Comments
    • Columns Comments for PHRDOCM_BANK_ACCT_NO (# 12)
      • Source Code Comments
    • Columns Comments for PHRDOCM_ACCT_TYPE (# 13)
      • Source Code Comments
    • Columns Comments for PHRDOCM_ACTIVITY_DATE (# 14)
      • Source Code Comments
    • Columns Comments for PHRDOCM_RECON_IND (# 15)
      • Source Code Comments
    • Columns Comments for PHRDOCM_RECON_DATE (# 16)
      • Source Code Comments
    • Columns Comments for PHRDOCM_REISSUE_IND (# 17)
      • 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 PHRELBD
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRELBD_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRELBD_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRELBD_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRELBD_COAS_CODE_TS (# 4)
      • Source Code Comments
    • Columns Comments for PHRELBD_ORGN_CODE_TS (# 5)
      • Source Code Comments
    • Columns Comments for PHRELBD_TS_ROSTER_IND (# 6)
      • Source Code Comments
    • Columns Comments for PHRELBD_PIDM (# 7)
      • Source Code Comments
    • Columns Comments for PHRELBD_SEQ_NO (# 8)
      • Source Code Comments
    • Columns Comments for PHRELBD_POSN (# 9)
      • Source Code Comments
    • Columns Comments for PHRELBD_SUFF (# 10)
      • Source Code Comments
    • Columns Comments for PHRELBD_EFFECTIVE_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PHRELBD_EARN_CODE (# 12)
      • Source Code Comments
    • Columns Comments for PHRELBD_SHIFT (# 13)
      • Source Code Comments
    • Columns Comments for PHRELBD_GEN_IND (# 14)
      • Source Code Comments
    • Columns Comments for PHRELBD_COAS_CODE (# 15)
      • Source Code Comments
    • Columns Comments for PHRELBD_ACCI_CODE (# 16)
      • Source Code Comments
    • Columns Comments for PHRELBD_FUND_CODE (# 17)
      • Source Code Comments
    • Columns Comments for PHRELBD_ORGN_CODE (# 18)
      • Source Code Comments
    • Columns Comments for PHRELBD_ACCT_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PHRELBD_PROG_CODE (# 20)
      • Source Code Comments
    • Columns Comments for PHRELBD_ACTV_CODE (# 21)
      • Source Code Comments
    • Columns Comments for PHRELBD_LOCN_CODE (# 22)
      • Source Code Comments
    • Columns Comments for PHRELBD_PROJ_CODE (# 23)
      • Source Code Comments
    • Columns Comments for PHRELBD_CTYP_CODE (# 24)
      • Source Code Comments
    • Columns Comments for PHRELBD_ACCT_CODE_EXTERNAL (# 25)
      • Source Code Comments
    • Columns Comments for PHRELBD_PERCENT (# 26)
      • Source Code Comments
    • Columns Comments for PHRELBD_HRS (# 27)
      • Source Code Comments
    • Columns Comments for PHRELBD_ENCD_NUM (# 28)
      • Source Code Comments
    • Columns Comments for PHRELBD_ENCD_SEQ_NUM (# 29)
      • Source Code Comments
    • Columns Comments for PHRELBD_ACTIVITY_DATE (# 30)
      • Source Code Comments
    • Columns Comments for PHRELBD_REDISTRIBUTION_AMT (# 31)
      • 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 PHRFLSA
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRFLSA_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRFLSA_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRFLSA_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRFLSA_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHRFLSA_SEQ_NO (# 5)
      • Source Code Comments
    • Columns Comments for PHRFLSA_BEGIN_DATE (# 6)
      • Source Code Comments
    • Columns Comments for PHRFLSA_END_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PHRFLSA_PERIOD_MAX_NON_OT_HRS (# 8)
      • Source Code Comments
    • Columns Comments for PHRFLSA_HRS_ADD (# 9)
      • Source Code Comments
    • Columns Comments for PHRFLSA_HRS_REDUCE (# 10)
      • Source Code Comments
    • Columns Comments for PHRFLSA_AMT_ADD (# 11)
      • Source Code Comments
    • Columns Comments for PHRFLSA_AMT_REDUCE (# 12)
      • Source Code Comments
    • Columns Comments for PHRFLSA_DAILY_OT_HRS (# 13)
      • Source Code Comments
    • Columns Comments for PHRFLSA_HRS_ACCRUED (# 14)
      • Source Code Comments
    • Columns Comments for PHRFLSA_CASH_PAID (# 15)
      • Source Code Comments
    • Columns Comments for PHRFLSA_ACTIVITY_DATE (# 16)
      • Source Code Comments
  • Table PHRHIST
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRHIST_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRHIST_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRHIST_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRHIST_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHRHIST_SEQ_NO (# 5)
      • Source Code Comments
    • Columns Comments for PHRHIST_DISP (# 6)
      • Source Code Comments
    • Columns Comments for PHRHIST_EVENT_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PHRHIST_GROSS (# 8)
      • Source Code Comments
    • Columns Comments for PHRHIST_NET (# 9)
      • Source Code Comments
    • Columns Comments for PHRHIST_TYPE_IND (# 10)
      • Source Code Comments
    • Columns Comments for PHRHIST_CALC_IND (# 11)
      • Source Code Comments
    • Columns Comments for PHRHIST_PRINT_IND (# 12)
      • Source Code Comments
    • Columns Comments for PHRHIST_ADJS_SEQ_NO (# 13)
      • Source Code Comments
    • Columns Comments for PHRHIST_ADJS_DATE (# 14)
      • Source Code Comments
    • Columns Comments for PHRHIST_ADJ_BY_SEQ_NO (# 15)
      • Source Code Comments
    • Columns Comments for PHRHIST_ADJ_BY_DATE (# 16)
      • Source Code Comments
    • Columns Comments for PHRHIST_ASSOC_SEQ_NO (# 17)
      • Source Code Comments
    • Columns Comments for PHRHIST_ACTIVITY_DATE (# 18)
      • Source Code Comments
    • Columns Comments for PHRHIST_UI_WEEKS (# 19)
      • Source Code Comments
    • Columns Comments for PHRHIST_UI_EXCEPTION_IND (# 20)
      • Source Code Comments
    • Columns Comments for PHRHIST_UPDT_DATE (# 21)
      • Source Code Comments
    • Columns Comments for PHRHIST_POSTING_OVERRIDE_DATE (# 22)
      • Source Code Comments
    • Columns Comments for PHRHIST_USER_ID (# 23)
      • Source Code Comments
    • Columns Comments for PHRHIST_COMMENT (# 24)
      • 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 PHRJACR
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRJACR_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRJACR_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRJACR_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRJACR_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHRJACR_POSN (# 5)
      • Source Code Comments
    • Columns Comments for PHRJACR_SUFF (# 6)
      • Source Code Comments
    • Columns Comments for PHRJACR_EFFECTIVE_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PHRJACR_LEAV_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PHRJACR_CALC_GEN_IND (# 9)
      • Source Code Comments
    • Columns Comments for PHRJACR_BANK_IND (# 10)
      • Source Code Comments
    • Columns Comments for PHRJACR_USER_ID (# 11)
      • Source Code Comments
    • Columns Comments for PHRJACR_ACTIVITY_DATE (# 12)
      • Source Code Comments
    • Columns Comments for PHRJACR_CURR_ACCR (# 13)
      • Source Code Comments
    • Columns Comments for PHRJACR_CURR_TAKEN (# 14)
      • Source Code Comments
    • Columns Comments for PHRJACR_MAX_HRS (# 15)
      • Source Code Comments
  • Table PHRJOBS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRJOBS_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRJOBS_COAS_CODE_TS (# 4)
      • Source Code Comments
    • Columns Comments for PHRJOBS_ORGN_CODE_TS (# 5)
      • Source Code Comments
    • Columns Comments for PHRJOBS_TS_ROSTER_IND (# 6)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PIDM (# 7)
      • Source Code Comments
    • Columns Comments for PHRJOBS_SEQ_NO (# 8)
      • Source Code Comments
    • Columns Comments for PHRJOBS_POSN (# 9)
      • Source Code Comments
    • Columns Comments for PHRJOBS_SUFF (# 10)
      • Source Code Comments
    • Columns Comments for PHRJOBS_EFFECTIVE_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PHRJOBS_STATUS (# 12)
      • Source Code Comments
    • Columns Comments for PHRJOBS_ECLS_CODE (# 13)
      • Source Code Comments
    • Columns Comments for PHRJOBS_BASE_SAL_HRS (# 14)
      • Source Code Comments
    • Columns Comments for PHRJOBS_SALARY_RATE (# 15)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PER_PAY_SALARY (# 16)
      • Source Code Comments
    • Columns Comments for PHRJOBS_APPT_PCT (# 17)
      • Source Code Comments
    • Columns Comments for PHRJOBS_DEFER_AMT (# 18)
      • Source Code Comments
    • Columns Comments for PHRJOBS_CONTRACT_TYPE (# 19)
      • Source Code Comments
    • Columns Comments for PHRJOBS_SHIFT (# 20)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PAY_CNT (# 21)
      • Source Code Comments
    • Columns Comments for PHRJOBS_DISP (# 22)
      • Source Code Comments
    • Columns Comments for PHRJOBS_ID_SEQ (# 23)
      • Source Code Comments
    • Columns Comments for PHRJOBS_LAST_NAME_SEQ (# 24)
      • Source Code Comments
    • Columns Comments for PHRJOBS_FIRST_NAME_SEQ (# 25)
      • Source Code Comments
    • Columns Comments for PHRJOBS_ACTIVITY_DATE (# 26)
      • Source Code Comments
    • Columns Comments for PHRJOBS_EMPR_CODE (# 27)
      • Source Code Comments
    • Columns Comments for PHRJOBS_LGCD_CODE (# 28)
      • Source Code Comments
    • Columns Comments for PHRJOBS_TIME_ENTRY_IND (# 29)
      • Source Code Comments
    • Columns Comments for PHRJOBS_EFFECTIVE_UNTIL_DATE (# 30)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PCAT_CODE (# 31)
      • Source Code Comments
    • Columns Comments for PHRJOBS_STRS_CONT_CODE (# 32)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PERS_CONT_CODE (# 33)
      • Source Code Comments
    • Columns Comments for PHRJOBS_STRS_ASSN_CODE (# 34)
      • Source Code Comments
    • Columns Comments for PHRJOBS_STRS_PAY_CODE (# 35)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PERS_PAY_CODE (# 36)
      • Source Code Comments
    • Columns Comments for PHRJOBS_FULL_ASSGN_SALARY (# 37)
      • Source Code Comments
    • Columns Comments for PHRJOBS_PREV_FISCAL_YEAR_IND (# 38)
      • Source Code Comments
    • Columns Comments for PHRJOBS_LCAT_CODE (# 39)
      • Source Code Comments
    • Columns Comments for PHRJOBS_FTE (# 40)
      • Source Code Comments
    • Columns Comments for PHRJOBS_HRS_DAY (# 41)
      • Source Code Comments
  • Table PHRMTIM
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRMTIM_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRMTIM_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRMTIM_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRMTIM_ID (# 4)
      • Source Code Comments
    • Columns Comments for PHRMTIM_POSN (# 5)
      • Source Code Comments
    • Columns Comments for PHRMTIM_SUFF (# 6)
      • Source Code Comments
    • Columns Comments for PHRMTIM_EFFECTIVE_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PHRMTIM_EARN_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PHRMTIM_SHIFT (# 9)
      • Source Code Comments
    • Columns Comments for PHRMTIM_BEGIN_DATE (# 10)
      • Source Code Comments
    • Columns Comments for PHRMTIM_END_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PHRMTIM_SPECIAL_RATE (# 12)
      • Source Code Comments
    • Columns Comments for PHRMTIM_HRS (# 13)
      • Source Code Comments
    • Columns Comments for PHRMTIM_COAS_CODE (# 14)
      • Source Code Comments
    • Columns Comments for PHRMTIM_ACCI_CODE (# 15)
      • Source Code Comments
    • Columns Comments for PHRMTIM_FUND_CODE (# 16)
      • Source Code Comments
    • Columns Comments for PHRMTIM_ORGN_CODE (# 17)
      • Source Code Comments
    • Columns Comments for PHRMTIM_ACCT_CODE (# 18)
      • Source Code Comments
    • Columns Comments for PHRMTIM_PROG_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PHRMTIM_ACTV_CODE (# 20)
      • Source Code Comments
    • Columns Comments for PHRMTIM_LOCN_CODE (# 21)
      • Source Code Comments
    • Columns Comments for PHRMTIM_ACCT_CODE_EXTERNAL (# 22)
      • Source Code Comments
    • Columns Comments for PHRMTIM_PERCENT (# 23)
      • Source Code Comments
    • Columns Comments for PHRMTIM_ACTIVITY_DATE (# 24)
      • Source Code Comments
    • Columns Comments for PHRMTIM_PROJ_CODE (# 25)
      • Source Code Comments
    • Columns Comments for PHRMTIM_CTYP_CODE (# 26)
      • Source Code Comments
    • Columns Comments for PHRMTIM_CHANGE_IND (# 27)
      • Source Code Comments
    • Columns Comments for PHRMTIM_DEEMED_HRS (# 28)
      • Source Code Comments
  • Table PHRUICW
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PHRUICW_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PHRUICW_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PHRUICW_PAYNO (# 3)
      • Source Code Comments
    • Columns Comments for PHRUICW_PIDM (# 4)
      • Source Code Comments
    • Columns Comments for PHRUICW_SEQ_NO (# 5)
      • Source Code Comments
    • Columns Comments for PHRUICW_EMPR_CODE (# 6)
      • Source Code Comments
    • Columns Comments for PHRUICW_PERIOD_START_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PHRUICW_PERIOD_END_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PHRUICW_UIC_HOURS (# 9)
      • Source Code Comments
    • Columns Comments for PHRUICW_UIC_GROSS (# 10)
      • Source Code Comments
    • Columns Comments for PHRUICW_UIC_WEEKS (# 11)
      • Source Code Comments
    • Columns Comments for PHRUICW_ACTIVITY_DATE (# 12)
      • Source Code Comments
  • Table PPRCOLR
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PPRCOLR_SESSIONID (# 1)
      • Source Code Comments
    • Columns Comments for PPRCOLR_TYPE (# 2)
      • Source Code Comments
    • Columns Comments for PPRCOLR_VALUE_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PPRCOLR_VALUE_ATYP (# 4)
      • Source Code Comments
    • Columns Comments for PPRCOLR_JOB (# 5)
      • Source Code Comments
    • Columns Comments for PPRCOLR_PARM_NUMBER (# 6)
      • Source Code Comments
    • Columns Comments for PPRCOLR_ACTIVITY_DATE (# 7)
      • 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 PTRECLS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRECLS_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRECLS_SHORT_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTRECLS_LONG_DESC (# 3)
      • Source Code Comments
    • Columns Comments for PTRECLS_PICT_CODE (# 4)
      • Source Code Comments
    • Columns Comments for PTRECLS_SHCD_CODE (# 5)
      • Source Code Comments
    • Columns Comments for PTRECLS_HOURS_PER_PAY (# 6)
      • Source Code Comments
    • Columns Comments for PTRECLS_HOURS_PER_DAY (# 7)
      • Source Code Comments
    • Columns Comments for PTRECLS_SALARY_ENCUMBRANCE_IND (# 8)
      • Source Code Comments
    • Columns Comments for PTRECLS_TS_ROSTER_IND (# 9)
      • Source Code Comments
    • Columns Comments for PTRECLS_DEFAULT_HOURS_IND (# 10)
      • Source Code Comments
    • Columns Comments for PTRECLS_SALARY_IND (# 11)
      • Source Code Comments
    • Columns Comments for PTRECLS_BUDGET_ROLL_IND (# 12)
      • Source Code Comments
    • Columns Comments for PTRECLS_LCAT_CODE (# 13)
      • Source Code Comments
    • Columns Comments for PTRECLS_BCAT_CODE (# 14)
      • Source Code Comments
    • Columns Comments for PTRECLS_ACTIVITY_DATE (# 15)
      • Source Code Comments
    • Columns Comments for PTRECLS_EEOG_CODE (# 16)
      • Source Code Comments
    • Columns Comments for PTRECLS_EMPR_CODE (# 17)
      • Source Code Comments
    • Columns Comments for PTRECLS_INSTRUCT_CODE (# 18)
      • Source Code Comments
    • Columns Comments for PTRECLS_STCA_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PTRECLS_STGR_CODE (# 20)
      • Source Code Comments
    • Columns Comments for PTRECLS_WKPR_CODE (# 21)
      • Source Code Comments
    • Columns Comments for PTRECLS_LGCD_CODE (# 22)
      • Source Code Comments
    • Columns Comments for PTRECLS_FLSA_IND (# 23)
      • Source Code Comments
    • Columns Comments for PTRECLS_WKSH_CODE (# 24)
      • Source Code Comments
    • Columns Comments for PTRECLS_TIME_ENTRY_IND (# 25)
      • Source Code Comments
    • Columns Comments for PTRECLS_TIME_ENTRY_DAY (# 26)
      • Source Code Comments
    • Columns Comments for PTRECLS_DFPR_CODE (# 27)
      • Source Code Comments
    • Columns Comments for PTRECLS_PCAT_CODE (# 28)
      • Source Code Comments
    • Columns Comments for PTRECLS_PREMIUM_ROLL_IND (# 29)
      • Source Code Comments
    • Columns Comments for PTRECLS_INTERNAL_FT_PT_IND (# 30)
      • Source Code Comments
    • Columns Comments for PTRECLS_EGRP_CODE (# 31)
      • Source Code Comments
    • Columns Comments for PTRECLS_STRS_ASSN_CODE (# 32)
      • Source Code Comments
    • Columns Comments for PTRECLS_STRS_PAY_CODE (# 33)
      • Source Code Comments
    • Columns Comments for PTRECLS_PERS_GROUP (# 34)
      • Source Code Comments
    • Columns Comments for PTRECLS_PERS_PAY_CODE (# 35)
      • Source Code Comments
    • Columns Comments for PTRECLS_TIME_ENTRY_METHOD (# 36)
      • Source Code Comments
    • Columns Comments for PTRECLS_TIME_ENTRY_TYPE (# 37)
      • Source Code Comments
    • Columns Comments for PTRECLS_LEAVE_REQUEST_IND (# 38)
      • Source Code Comments
    • Columns Comments for PTRECLS_EXCEPTION_APPROVAL_IND (# 39)
      • Source Code Comments
    • Columns Comments for PTRECLS_TIME_IN_OUT_IND (# 40)
      • Source Code Comments
    • Columns Comments for PTRECLS_OVERRIDE_LD_WEB_IND (# 41)
      • Source Code Comments
    • Columns Comments for PTRECLS_OVERRIDE_LD_DEPT_IND (# 42)
      • Source Code Comments
    • Columns Comments for PTRECLS_BUDG_BASIS (# 43)
      • Source Code Comments
    • Columns Comments for PTRECLS_ANN_BASIS (# 44)
      • Source Code Comments
    • Columns Comments for PTRECLS_CREATE_JFTE_IND (# 45)
      • Source Code Comments
    • Columns Comments for PTRECLS_LEAV_REPT_METHOD (# 46)
      • Source Code Comments
    • Columns Comments for PTRECLS_PICT_CODE_LEAV_REPT (# 47)
      • Source Code Comments
  • Table PTREERN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTREERN_ECLS_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTREERN_EARN_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTREERN_ATND_IND (# 3)
      • Source Code Comments
    • Columns Comments for PTREERN_REDUCE_REG_PAY_IND (# 4)
      • Source Code Comments
    • Columns Comments for PTREERN_TS_ENTRY_SEQ (# 5)
      • Source Code Comments
    • Columns Comments for PTREERN_TS_PRINT_SEQ (# 6)
      • Source Code Comments
    • Columns Comments for PTREERN_ACTIVITY_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PTREERN_EA_APPROVERS_IND (# 8)
      • Source Code Comments
    • Columns Comments for PTREERN_ACCRUE_SENIORITY_IND (# 9)
      • Source Code Comments
  • Table PTRJBLN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRJBLN_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRJBLN_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTRJBLN_ADDRESS1 (# 3)
      • Source Code Comments
    • Columns Comments for PTRJBLN_ADDRESS2 (# 4)
      • Source Code Comments
    • Columns Comments for PTRJBLN_CITY (# 5)
      • Source Code Comments
    • Columns Comments for PTRJBLN_STAT_CODE (# 6)
      • Source Code Comments
    • Columns Comments for PTRJBLN_ZIPC_CODE (# 7)
      • Source Code Comments
    • Columns Comments for PTRJBLN_NATN_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PTRJBLN_ACTIVITY_DATE (# 9)
      • Source Code Comments
    • Columns Comments for PTRJBLN_DICD_CODE (# 10)
      • Source Code Comments
  • Table PTRLOCN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRLOCN_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRLOCN_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTRLOCN_ADDRESS (# 3)
      • Source Code Comments
    • Columns Comments for PTRLOCN_CITY (# 4)
      • Source Code Comments
    • Columns Comments for PTRLOCN_STAT_CODE (# 5)
      • Source Code Comments
    • Columns Comments for PTRLOCN_CNTY_CODE (# 6)
      • Source Code Comments
    • Columns Comments for PTRLOCN_ZIPC_CODE (# 7)
      • Source Code Comments
    • Columns Comments for PTRLOCN_EIN (# 8)
      • Source Code Comments
    • Columns Comments for PTRLOCN_EMPR_CODE (# 9)
      • Source Code Comments
    • Columns Comments for PTRLOCN_PAY_BEGIN_DATE (# 10)
      • Source Code Comments
    • Columns Comments for PTRLOCN_PAY_END_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PTRLOCN_QUESTION_C1_IND (# 12)
      • Source Code Comments
    • Columns Comments for PTRLOCN_QUESTION_C2_IND (# 13)
      • Source Code Comments
    • Columns Comments for PTRLOCN_QUESTION_C3_IND (# 14)
      • Source Code Comments
    • Columns Comments for PTRLOCN_QUESTION_C4_IND (# 15)
      • Source Code Comments
    • Columns Comments for PTRLOCN_APPRENTICES_IND (# 16)
      • Source Code Comments
    • Columns Comments for PTRLOCN_QUESTION_E1_IND (# 17)
      • Source Code Comments
    • Columns Comments for PTRLOCN_QUESTION_E2_IND (# 18)
      • Source Code Comments
    • Columns Comments for PTRLOCN_E3_LINE1 (# 19)
      • Source Code Comments
    • Columns Comments for PTRLOCN_E3_LINE2 (# 20)
      • Source Code Comments
    • Columns Comments for PTRLOCN_E3_LINE3 (# 21)
      • Source Code Comments
    • Columns Comments for PTRLOCN_E3_LINE4 (# 22)
      • Source Code Comments
    • Columns Comments for PTRLOCN_UNIT_NUMBER (# 23)
      • Source Code Comments
    • Columns Comments for PTRLOCN_HEADQUARTERS_IND (# 24)
      • Source Code Comments
    • Columns Comments for PTRLOCN_RECEIVING_OFFICE (# 25)
      • Source Code Comments
    • Columns Comments for PTRLOCN_SIC_CD (# 26)
      • Source Code Comments
    • Columns Comments for PTRLOCN_DB_IDNO (# 27)
      • Source Code Comments
    • Columns Comments for PTRLOCN_ACTIVITY_DATE (# 28)
      • 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 PTRSCHL
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRSCHL_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRSCHL_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTRSCHL_ADDRESS (# 3)
      • Source Code Comments
    • Columns Comments for PTRSCHL_CITY (# 4)
      • Source Code Comments
    • Columns Comments for PTRSCHL_STAT_CODE (# 5)
      • Source Code Comments
    • Columns Comments for PTRSCHL_CNTY_CODE (# 6)
      • Source Code Comments
    • Columns Comments for PTRSCHL_ZIPC_CODE (# 7)
      • Source Code Comments
    • Columns Comments for PTRSCHL_EMPR_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PTRSCHL_IDNO (# 9)
      • Source Code Comments
    • Columns Comments for PTRSCHL_PRE_K_OFFERED_IND (# 10)
      • Source Code Comments
    • Columns Comments for PTRSCHL_K_OFFERED_IND (# 11)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR1_OFFERED_IND (# 12)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR2_OFFERED_IND (# 13)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR3_OFFERED_IND (# 14)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR4_OFFERED_IND (# 15)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR5_OFFERED_IND (# 16)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR6_OFFERED_IND (# 17)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR7_OFFERED_IND (# 18)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR8_OFFERED_IND (# 19)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR9_OFFERED_IND (# 20)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR10_OFFERED_IND (# 21)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR11_OFFERED_IND (# 22)
      • Source Code Comments
    • Columns Comments for PTRSCHL_GR12_OFFERED_IND (# 23)
      • Source Code Comments
    • Columns Comments for PTRSCHL_UN_OFFERED_IND (# 24)
      • Source Code Comments
    • Columns Comments for PTRSCHL_SE_OFFERED_IND (# 25)
      • Source Code Comments
    • Columns Comments for PTRSCHL_ENROLLMENT (# 26)
      • Source Code Comments
    • Columns Comments for PTRSCHL_PAYROLL_END_DATE (# 27)
      • Source Code Comments
    • Columns Comments for PTRSCHL_PRINCIPAL_ASSGN_IND (# 28)
      • Source Code Comments
    • Columns Comments for PTRSCHL_PR_FTPT_IND (# 29)
      • Source Code Comments
    • Columns Comments for PTRSCHL_PR_TEACHES_IND (# 30)
      • Source Code Comments
    • Columns Comments for PTRSCHL_EEOC_CODE_PR (# 31)
      • Source Code Comments
    • Columns Comments for PTRSCHL_PR_SEX (# 32)
      • Source Code Comments
    • Columns Comments for PTRSCHL_ANNEX_IND (# 33)
      • Source Code Comments
    • Columns Comments for PTRSCHL_TYPE_OF_AGENCY (# 34)
      • Source Code Comments
    • Columns Comments for PTRSCHL_ACTIVITY_DATE (# 35)
      • Source Code Comments
  • Table PTVWKCP
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTVWKCP_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTVWKCP_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTVWKCP_ACTIVITY_DATE (# 3)
      • Source Code Comments
  • Table PXRMROE
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PXRMROE_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PXRMROE_PICT_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PXRMROE_EMPR_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PXRMROE_LANGUAGE_IND (# 4)
      • Source Code Comments
    • Columns Comments for PXRMROE_ROEC_CODE (# 5)
      • Source Code Comments
    • Columns Comments for PXRMROE_FIRST_DAY_WORKED (# 6)
      • Source Code Comments
    • Columns Comments for PXRMROE_LAST_DAY_WORKED (# 7)
      • Source Code Comments
    • Columns Comments for PXRMROE_USER_ID (# 8)
      • Source Code Comments
    • Columns Comments for PXRMROE_ACTIVITY_DATE (# 9)
      • Source Code Comments
    • Columns Comments for PXRMROE_RECALL_IND (# 10)
      • Source Code Comments
    • Columns Comments for PXRMROE_RECALL_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PXRMROE_DATA_ORIGIN (# 12)
      • Source Code Comments
  • Link between PTRECLS and NBRJOBS
    • Join Information
  • Link between PTRPICT and NBRJOBS
    • Join Information
  • Link between PTRLOCN and NBRJOBS
    • Join Information
  • Link between PTRSCHL and NBRJOBS
    • Join Information
  • Link between PTVWKCP and NBRJOBS
    • Join Information
  • Link between PTRJBLN and NBRJOBS
    • Join Information
  • Link between PTRCALN and PHRJOBS
    • Join Information
  • Link between PHREARN and PPRCOLR
    • Join Information
  • Link between PPRCOLR and PHRJOBS
    • Join Information
  • Link between NBRJOBS and PEBEMPL
    • Join Information
  • Link between NBRJOBS and PTRCALN
    • Join Information
  • Link between PHR1042 and PHRHIST
    • Join Information
  • Link between PTRPICT and PTRCALN
    • Join Information
  • Link between PTRPICT and PHRHIST
    • Join Information
  • Link between PHRHIST and PHRJOBS
    • Join Information
  • Link between PHREARN and PTREERN
    • Join Information
  • Link between PHREARN and PHRJOBS
    • Join Information
  • Link between PHRHIST and PHRDOCM
    • Join Information
  • Link between PTRCALN and PHRACCR
    • Join Information
  • Link between PHRERRL and PTREARN
    • Join Information
  • Link between PHREARN and PHRHIST
    • Join Information
  • Link between PTRCALN and PHRJACR
    • Join Information
  • Link between PHRJOBS and PHRJACR
    • Join Information
  • Link between PHRJACR and PHRHIST
    • Join Information
  • Link between PERJLEV and PHRJACR
    • Join Information
  • Link between NBRJOBS and PERJLEV
    • Join Information
  • Link between PEBEMPL and PERJLEV
    • Join Information
  • Link between PERJLEV and PHRHIST
    • Join Information
  • Link between PERJLEV and PHRJOBS
    • Join Information
  • Link between PHREARN and PTREARN
  • Link between PERJHIS and PTRJBLN
  • Link between PHRHIST and PTRCALN
  • Link between PERJHIS and PTRECLS
  • Link between PERJHIS and PTRPICT
  • Link between PERRHOL and PTRPICT
  • Link between PERROTH and PTRPICT
  • Link between PXRMROE and PTRPICT
  • Link between PERRHOL and PEBEMPL
  • Link between PERROTH and PEBEMPL
  • Link between PHRHIST and PEBEMPL
  • Link between PEBEMPL and PTRECLS
  • Link between PEBEMPL and PTRJBLN
  • Link between PERJHIS and PTVWKCP
  • Link between PERRCMT and PEBEMPL
  • Link between PERRCMT and PTRPICT
  • Link between PHRJOBS and PTRECLS
  • Link between PERJHIS and PTRLOCN
  • Link between PEBROEC and PTRPICT
  • Link between PTREERN and PTREARN
  • Link between PTREERN and PTRECLS
  • Link between PHRCMNT and PHRHIST
  • Link between PERJHIS and PTRSCHL
  • Link between PHRJACR and PTRPICT
  • Link between PDRXPID and PTRPICT