• Model View
  • Table PDR1042
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PDR1042_LAST_NAME (# 1)
      • Source Code Comments
    • Columns Comments for PDR1042_FIRST_NAME (# 2)
      • Source Code Comments
    • Columns Comments for PDR1042_MI (# 3)
      • Source Code Comments
    • Columns Comments for PDR1042_SSN (# 4)
      • Source Code Comments
    • Columns Comments for PDR1042_ID (# 5)
      • Source Code Comments
    • Columns Comments for PDR1042_BIRTH_DATE (# 6)
      • Source Code Comments
    • Columns Comments for PDR1042_TAX_YEAR (# 7)
      • Source Code Comments
    • Columns Comments for PDR1042_INCOME_CODE (# 8)
      • Source Code Comments
    • Columns Comments for PDR1042_WITHHOLDING_RATE (# 9)
      • Source Code Comments
    • Columns Comments for PDR1042_INCOME_CODE_SUBTYPE (# 10)
      • Source Code Comments
    • Columns Comments for PDR1042_EXEMPTION_CODE (# 11)
      • Source Code Comments
    • Columns Comments for PDR1042_MAX_BENEFIT_AMOUNT (# 12)
      • Source Code Comments
    • Columns Comments for PDR1042_RL_BEN_AMT_EXCEED_SW (# 13)
      • Source Code Comments
    • Columns Comments for PDR1042_BEN_END_DATE (# 14)
      • Source Code Comments
    • Columns Comments for PDR1042_RL_BEN_DATE_EXCEED_SW (# 15)
      • Source Code Comments
    • Columns Comments for PDR1042_CURR_RESIDENCY_STATUS (# 16)
      • Source Code Comments
    • Columns Comments for PDR1042_BECOME_RA_DATE (# 17)
      • Source Code Comments
    • Columns Comments for PDR1042_TARGET_DEPARTURE_DATE (# 18)
      • Source Code Comments
    • Columns Comments for PDR1042_TAX_RES_COUNTRY_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PDR1042_TREATY_CHANGED_DATE (# 20)
      • Source Code Comments
    • Columns Comments for PDR1042_EXEMPT_NRA_FICA_SW (# 21)
      • Source Code Comments
    • Columns Comments for PDR1042_EXEMPT_STUDNT_FICA_SW (# 22)
      • Source Code Comments
    • Columns Comments for PDR1042_ADD_WITHHOLDING_SW (# 23)
      • Source Code Comments
    • Columns Comments for PDR1042_ADD_WITHHOLDING_AMT (# 24)
      • Source Code Comments
    • Columns Comments for PDR1042_PERSONAL_EXEMPTION (# 25)
      • Source Code Comments
    • Columns Comments for PDR1042_ADD_EXEMPTION_ALLOWED (# 26)
      • Source Code Comments
    • Columns Comments for PDR1042_DAYS_IN_USA (# 27)
      • Source Code Comments
    • Columns Comments for PDR1042_WITHHOLD_ALLOWANCE_SW (# 28)
      • Source Code Comments
    • Columns Comments for PDR1042_TREATY_BEN_ALLOWED_SW (# 29)
      • Source Code Comments
    • Columns Comments for PDR1042_TREATY_BEN_START_DATE (# 30)
      • Source Code Comments
    • Columns Comments for PDR1042_RA_EFFECTIVE_DATE (# 31)
      • Source Code Comments
    • Columns Comments for PDR1042_STATE_CODE (# 32)
      • Source Code Comments
    • Columns Comments for PDR1042_STATE_HONOR_TREATY_SW (# 33)
      • Source Code Comments
    • Columns Comments for PDR1042_YTD_PAYMENTS (# 34)
      • Source Code Comments
    • Columns Comments for PDR1042_YTD_W2_PAYMENTS (# 35)
      • Source Code Comments
    • Columns Comments for PDR1042_YTD_FED_WH_W2 (# 36)
      • Source Code Comments
    • Columns Comments for PDR1042_YTD_TREATY_WH_ALLWNCE (# 37)
      • Source Code Comments
    • Columns Comments for PDR1042_YTD_TREATY_PMT (# 38)
      • Source Code Comments
    • Columns Comments for PDR1042_YTD_TREATY_WH_AMT (# 39)
      • Source Code Comments
    • Columns Comments for PDR1042_RECORD_SOURCE (# 40)
      • Source Code Comments
    • Columns Comments for PDR1042_VISA_TYPE (# 41)
      • Source Code Comments
    • Columns Comments for PDR1042_J_SUB_TYPE (# 42)
      • Source Code Comments
    • Columns Comments for PDR1042_PRIMARY_ACTIVITY (# 43)
      • Source Code Comments
    • Columns Comments for PDR1042_NON_US_COUNTRY_CODE (# 44)
      • Source Code Comments
    • Columns Comments for PDR1042_CITIZEN_COUNTRY_CODE (# 45)
      • Source Code Comments
    • Columns Comments for PDR1042_CONST_ADDITIONAL_TAX (# 46)
      • Source Code Comments
    • Columns Comments for PDR1042_ADD_WITHHOLDING_TYPE (# 47)
      • Source Code Comments
    • Columns Comments for PDR1042_OTHER_TREATY_BEN (# 48)
      • Source Code Comments
    • Columns Comments for PDR1042_W4_SIGNED (# 49)
      • Source Code Comments
    • Columns Comments for PDR1042_TREATY_FORM_SIGNED (# 50)
      • Source Code Comments
    • Columns Comments for PDR1042_BEN_ESTIMATED_SW (# 51)
      • Source Code Comments
    • Columns Comments for PDR1042_EXEMPTION_CODE_2 (# 52)
      • Source Code Comments
    • Columns Comments for PDR1042_RECIPIENT_CODE (# 53)
      • Source Code Comments
    • Columns Comments for PDR1042_STATUS_TYPE (# 54)
      • Source Code Comments
    • Columns Comments for PDR1042_STATUS_DESC (# 55)
      • Source Code Comments
    • Columns Comments for PDR1042_ADD_TO_GROSS (# 56)
      • Source Code Comments
    • Columns Comments for PDR1042_SURNAME_PREFIX (# 57)
      • Source Code Comments
  • Table PDRBDED
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PDRBDED_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PDRBDED_BDCA_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PDRBDED_ADD_REPL_IND (# 3)
      • Source Code Comments
    • Columns Comments for PDRBDED_ADD_REPL_EMPL (# 4)
      • Source Code Comments
    • Columns Comments for PDRBDED_ADD_REPL_EMPR (# 5)
      • Source Code Comments
    • Columns Comments for PDRBDED_ADD_REPL_TAX_BASE (# 6)
      • Source Code Comments
    • Columns Comments for PDRBDED_ARR_STATUS (# 7)
      • Source Code Comments
    • Columns Comments for PDRBDED_ARR_BALANCE (# 8)
      • Source Code Comments
    • Columns Comments for PDRBDED_BOND_BALANCE (# 9)
      • Source Code Comments
    • Columns Comments for PDRBDED_BEGIN_DATE (# 10)
      • Source Code Comments
    • Columns Comments for PDRBDED_END_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PDRBDED_ACTIVITY_DATE (# 12)
      • Source Code Comments
    • Columns Comments for PDRBDED_ARR_RECOVER_MAX (# 13)
      • Source Code Comments
    • Columns Comments for PDRBDED_ADD_REPL_PICT_CODE (# 14)
      • Source Code Comments
  • Table PDRDEDN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PDRDEDN_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PDRDEDN_BDCA_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PDRDEDN_EFFECTIVE_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PDRDEDN_STATUS (# 4)
      • Source Code Comments
    • Columns Comments for PDRDEDN_REF_NO (# 5)
      • Source Code Comments
    • Columns Comments for PDRDEDN_AMOUNT1 (# 6)
      • Source Code Comments
    • Columns Comments for PDRDEDN_AMOUNT2 (# 7)
      • Source Code Comments
    • Columns Comments for PDRDEDN_AMOUNT3 (# 8)
      • Source Code Comments
    • Columns Comments for PDRDEDN_AMOUNT4 (# 9)
      • Source Code Comments
    • Columns Comments for PDRDEDN_OPT_CODE1 (# 10)
      • Source Code Comments
    • Columns Comments for PDRDEDN_OPT_CODE2 (# 11)
      • Source Code Comments
    • Columns Comments for PDRDEDN_OPT_CODE3 (# 12)
      • Source Code Comments
    • Columns Comments for PDRDEDN_OPT_CODE4 (# 13)
      • Source Code Comments
    • Columns Comments for PDRDEDN_OPT_CODE5 (# 14)
      • Source Code Comments
    • Columns Comments for PDRDEDN_ACTIVITY_DATE (# 15)
      • Source Code Comments
    • Columns Comments for PDRDEDN_COVERAGE_DATE (# 16)
      • Source Code Comments
    • Columns Comments for PDRDEDN_BDCL_CODE (# 17)
      • Source Code Comments
  • Table PDRFBAL
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PDRFBAL_PLAN_YEAR (# 1)
      • Source Code Comments
    • Columns Comments for PDRFBAL_PIDM (# 2)
      • Source Code Comments
    • Columns Comments for PDRFBAL_BDCA_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PDRFBAL_PLAN_CODE (# 4)
      • Source Code Comments
    • Columns Comments for PDRFBAL_AMOUNT_AVAIL (# 5)
      • Source Code Comments
    • Columns Comments for PDRFBAL_AMOUNT_SPENT (# 6)
      • Source Code Comments
    • Columns Comments for PDRFBAL_ACTIVITY_DATE (# 7)
      • Source Code Comments
  • Table PDRFCLM
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PDRFCLM_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PDRFCLM_BDCA_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PDRFCLM_PLAN_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PDRFCLM_CLAIM_DATE (# 4)
      • Source Code Comments
    • Columns Comments for PDRFCLM_REF_NO (# 5)
      • Source Code Comments
    • Columns Comments for PDRFCLM_CLAIM_AMT (# 6)
      • Source Code Comments
    • Columns Comments for PDRFCLM_CLAIM_PAID (# 7)
      • Source Code Comments
    • Columns Comments for PDRFCLM_ACTIVITY_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PDRFCLM_PLAN_YEAR (# 9)
      • 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 PER1042
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PER1042_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PER1042_ID (# 2)
      • Source Code Comments
    • Columns Comments for PER1042_INCOME_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PER1042_EXEMPTION_CODE (# 4)
      • Source Code Comments
    • Columns Comments for PER1042_WITHHOLDING_RATE (# 5)
      • Source Code Comments
    • Columns Comments for PER1042_COUNTRY_CODE (# 6)
      • Source Code Comments
    • Columns Comments for PER1042_SSN (# 7)
      • Source Code Comments
    • Columns Comments for PER1042_LAST_NAME (# 8)
      • Source Code Comments
    • Columns Comments for PER1042_FIRST_NAME (# 9)
      • Source Code Comments
    • Columns Comments for PER1042_MI (# 10)
      • Source Code Comments
    • Columns Comments for PER1042_BIRTH_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PER1042_GROSS_INCOME_PAID (# 12)
      • Source Code Comments
    • Columns Comments for PER1042_WITHHOLDING_ALLOW (# 13)
      • Source Code Comments
    • Columns Comments for PER1042_WITHHELD_AMOUNT (# 14)
      • Source Code Comments
    • Columns Comments for PER1042_INCOME_CODE_SUBTYPE (# 15)
      • Source Code Comments
    • Columns Comments for PER1042_CYCLE_DATE (# 16)
      • Source Code Comments
    • Columns Comments for PER1042_TAX_YEAR (# 17)
      • Source Code Comments
    • Columns Comments for PER1042_STATE_WH_AMOUNT (# 18)
      • Source Code Comments
    • Columns Comments for PER1042_STATE_CODE (# 19)
      • Source Code Comments
    • Columns Comments for PER1042_RECORD_STATUS (# 20)
      • Source Code Comments
    • Columns Comments for PER1042_LAST_EARN_DATE (# 21)
      • Source Code Comments
    • Columns Comments for PER1042_SURNAME_PREFIX (# 22)
      • Source Code Comments
  • Table PERDHIS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERDHIS_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PERDHIS_EFFECTIVE_DATE (# 2)
      • Source Code Comments
    • Columns Comments for PERDHIS_BDCA_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PERDHIS_STATUS (# 4)
      • Source Code Comments
    • Columns Comments for PERDHIS_ADD_REPL_IND (# 5)
      • Source Code Comments
    • Columns Comments for PERDHIS_ADD_REPL_EMPL (# 6)
      • Source Code Comments
    • Columns Comments for PERDHIS_ADD_REPL_EMPR (# 7)
      • Source Code Comments
    • Columns Comments for PERDHIS_ADD_REPL_TAX_BASE (# 8)
      • Source Code Comments
    • Columns Comments for PERDHIS_ARR_STATUS (# 9)
      • Source Code Comments
    • Columns Comments for PERDHIS_ARR_BALANCE (# 10)
      • Source Code Comments
    • Columns Comments for PERDHIS_BEGIN_DATE (# 11)
      • Source Code Comments
    • Columns Comments for PERDHIS_END_DATE (# 12)
      • Source Code Comments
    • Columns Comments for PERDHIS_REF_NO (# 13)
      • Source Code Comments
    • Columns Comments for PERDHIS_AMOUNT1 (# 14)
      • Source Code Comments
    • Columns Comments for PERDHIS_AMOUNT2 (# 15)
      • Source Code Comments
    • Columns Comments for PERDHIS_AMOUNT3 (# 16)
      • Source Code Comments
    • Columns Comments for PERDHIS_AMOUNT4 (# 17)
      • Source Code Comments
    • Columns Comments for PERDHIS_OPT_CODE1 (# 18)
      • Source Code Comments
    • Columns Comments for PERDHIS_OPT_CODE2 (# 19)
      • Source Code Comments
    • Columns Comments for PERDHIS_OPT_CODE3 (# 20)
      • Source Code Comments
    • Columns Comments for PERDHIS_OPT_CODE4 (# 21)
      • Source Code Comments
    • Columns Comments for PERDHIS_OPT_CODE5 (# 22)
      • Source Code Comments
    • Columns Comments for PERDHIS_CALC_INS_SALA (# 23)
      • Source Code Comments
    • Columns Comments for PERDHIS_USER_ID (# 24)
      • Source Code Comments
    • Columns Comments for PERDHIS_ACTIVITY_DATE (# 25)
      • Source Code Comments
    • Columns Comments for PERDHIS_ARR_RECOVER_MAX (# 26)
      • Source Code Comments
    • Columns Comments for PERDHIS_DELETED_IND (# 27)
      • Source Code Comments
    • Columns Comments for PERDHIS_CAPTURE_DATE (# 28)
      • Source Code Comments
    • Columns Comments for PERDHIS_OPEN_ENROLL_IND (# 29)
      • Source Code Comments
    • Columns Comments for PERDHIS_ADD_REPL_PICT_CODE (# 30)
      • Source Code Comments
    • Columns Comments for PERDHIS_BDCL_CODE (# 31)
      • Source Code Comments
  • Table PERINDV
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PERINDV_PIDM (# 1)
      • Source Code Comments
    • Columns Comments for PERINDV_ID (# 2)
      • Source Code Comments
    • Columns Comments for PERINDV_SSN (# 3)
      • Source Code Comments
    • Columns Comments for PERINDV_LAST_NAME (# 4)
      • Source Code Comments
    • Columns Comments for PERINDV_FIRST_NAME (# 5)
      • Source Code Comments
    • Columns Comments for PERINDV_MI (# 6)
      • Source Code Comments
    • Columns Comments for PERINDV_BIRTH_DATE (# 7)
      • Source Code Comments
    • Columns Comments for PERINDV_TITLE (# 8)
      • Source Code Comments
    • Columns Comments for PERINDV_SUFFIX (# 9)
      • Source Code Comments
    • Columns Comments for PERINDV_US_STREET_LINE1 (# 10)
      • Source Code Comments
    • Columns Comments for PERINDV_US_STREET_LINE2 (# 11)
      • Source Code Comments
    • Columns Comments for PERINDV_US_STREET_LINE3 (# 12)
      • Source Code Comments
    • Columns Comments for PERINDV_US_CITY (# 13)
      • Source Code Comments
    • Columns Comments for PERINDV_US_STATE (# 14)
      • Source Code Comments
    • Columns Comments for PERINDV_US_ZIP (# 15)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_STREET_LINE1 (# 16)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_STREET_LINE2 (# 17)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_STREET_LINE3 (# 18)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_CITY (# 19)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_STATE (# 20)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_ZIP (# 21)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_COUNTRY_CODE (# 22)
      • Source Code Comments
    • Columns Comments for PERINDV_CITZ_COUNTRY_CODE (# 23)
      • Source Code Comments
    • Columns Comments for PERINDV_TAX_RES_COUNTRY_CODE (# 24)
      • Source Code Comments
    • Columns Comments for PERINDV_SURNAME_PREFIX (# 25)
      • Source Code Comments
    • Columns Comments for PERINDV_US_HOUSE_NUMBER (# 26)
      • Source Code Comments
    • Columns Comments for PERINDV_US_STREET_LINE4 (# 27)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_HOUSE_NUMBER (# 28)
      • Source Code Comments
    • Columns Comments for PERINDV_FR_STREET_LINE4 (# 29)
      • 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 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 PTRBCDN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRBCDN_BCAT_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRBCDN_BDCA_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTRBCDN_REQ_IND (# 3)
      • Source Code Comments
    • Columns Comments for PTRBCDN_SETUP_IND (# 4)
      • Source Code Comments
    • Columns Comments for PTRBCDN_ACTIVITY_DATE (# 5)
      • Source Code Comments
    • Columns Comments for PTRBCDN_SEQ_NO (# 6)
      • Source Code Comments
    • Columns Comments for PTRBCDN_AMOUNT1 (# 7)
      • Source Code Comments
    • Columns Comments for PTRBCDN_AMOUNT2 (# 8)
      • Source Code Comments
    • Columns Comments for PTRBCDN_AMOUNT3 (# 9)
      • Source Code Comments
    • Columns Comments for PTRBCDN_AMOUNT4 (# 10)
      • Source Code Comments
    • Columns Comments for PTRBCDN_OPT_CODE1 (# 11)
      • Source Code Comments
    • Columns Comments for PTRBCDN_OPT_CODE2 (# 12)
      • Source Code Comments
    • Columns Comments for PTRBCDN_OPT_CODE3 (# 13)
      • Source Code Comments
    • Columns Comments for PTRBCDN_OPT_CODE4 (# 14)
      • Source Code Comments
    • Columns Comments for PTRBCDN_OPT_CODE5 (# 15)
      • Source Code Comments
    • Columns Comments for PTRBCDN_BEGIN_DATE_IND (# 16)
      • Source Code Comments
    • Columns Comments for PTRBCDN_DEDN_STATUS (# 17)
      • Source Code Comments
    • Columns Comments for PTRBCDN_BEGIN_DATE (# 18)
      • Source Code Comments
    • Columns Comments for PTRBCDN_END_DATE (# 19)
      • Source Code Comments
    • Columns Comments for PTRBCDN_COVERAGE_END_DATE_IND (# 20)
      • Source Code Comments
    • Columns Comments for PTRBCDN_DISP_ON_STMT_IND (# 21)
      • Source Code Comments
  • Table PTRBDCA
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRBDCA_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRBDCA_SHORT_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTRBDCA_LONG_DESC (# 3)
      • Source Code Comments
    • Columns Comments for PTRBDCA_PRIORITY (# 4)
      • Source Code Comments
    • Columns Comments for PTRBDCA_CALC_RULE (# 5)
      • Source Code Comments
    • Columns Comments for PTRBDCA_WEEK1_IND (# 6)
      • Source Code Comments
    • Columns Comments for PTRBDCA_WEEK2_IND (# 7)
      • Source Code Comments
    • Columns Comments for PTRBDCA_WEEK3_IND (# 8)
      • Source Code Comments
    • Columns Comments for PTRBDCA_WEEK4_IND (# 9)
      • Source Code Comments
    • Columns Comments for PTRBDCA_WEEK5_IND (# 10)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT1_IND (# 11)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT2_IND (# 12)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT3_IND (# 13)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT4_IND (# 14)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT1_TITLE (# 15)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT2_TITLE (# 16)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT3_TITLE (# 17)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT4_TITLE (# 18)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION1_IND (# 19)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION2_IND (# 20)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION3_IND (# 21)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION4_IND (# 22)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION5_IND (# 23)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION1_TITLE (# 24)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION2_TITLE (# 25)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION3_TITLE (# 26)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION4_TITLE (# 27)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION5_TITLE (# 28)
      • Source Code Comments
    • Columns Comments for PTRBDCA_GROSS_REPORT_IND (# 29)
      • Source Code Comments
    • Columns Comments for PTRBDCA_BENEFIT_IND (# 30)
      • Source Code Comments
    • Columns Comments for PTRBDCA_TXCD_CODE (# 31)
      • Source Code Comments
    • Columns Comments for PTRBDCA_TAX_TYPE_IND (# 32)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OVERLOAD_IND (# 33)
      • Source Code Comments
    • Columns Comments for PTRBDCA_ARREAR_IND (# 34)
      • Source Code Comments
    • Columns Comments for PTRBDCA_ACTIVITY_DATE (# 35)
      • Source Code Comments
    • Columns Comments for PTRBDCA_BDTY_CODE (# 36)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT1_DESC (# 37)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT2_DESC (# 38)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT3_DESC (# 39)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT4_DESC (# 40)
      • Source Code Comments
    • Columns Comments for PTRBDCA_1099_CODE (# 41)
      • Source Code Comments
    • Columns Comments for PTRBDCA_FLAT_AMT_IND (# 42)
      • Source Code Comments
    • Columns Comments for PTRBDCA_YTD_START_MONTH (# 43)
      • Source Code Comments
    • Columns Comments for PTRBDCA_WEB_DESC (# 44)
      • Source Code Comments
    • Columns Comments for PTRBDCA_WEB_INFO_URL (# 45)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION1_WEB_DESC (# 46)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION2_WEB_DESC (# 47)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION3_WEB_DESC (# 48)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION4_WEB_DESC (# 49)
      • Source Code Comments
    • Columns Comments for PTRBDCA_OPTION5_WEB_DESC (# 50)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT1_WEB_DESC (# 51)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT2_WEB_DESC (# 52)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT3_WEB_DESC (# 53)
      • Source Code Comments
    • Columns Comments for PTRBDCA_AMT4_WEB_DESC (# 54)
      • Source Code Comments
    • Columns Comments for PTRBDCA_BDCL_CODE (# 55)
      • Source Code Comments
  • Table PTRBDCL
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRBDCL_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRBDCL_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTRBDCL_USER_ID (# 3)
      • Source Code Comments
    • Columns Comments for PTRBDCL_ACTIVITY_DATE (# 4)
      • Source Code Comments
    • Columns Comments for PTRBDCL_DATA_ORIGIN (# 5)
      • Source Code Comments
    • Columns Comments for PTRBDCL_EMPL_LIMIT (# 6)
      • Source Code Comments
    • Columns Comments for PTRBDCL_EMPR_LIMIT (# 7)
      • Source Code Comments
    • Columns Comments for PTRBDCL_EMPL_EMPR_LIMIT (# 8)
      • Source Code Comments
    • Columns Comments for PTRBDCL_MAX_GROSS (# 9)
      • Source Code Comments
  • Table PTRBDPD
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRBDPD_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRBDPD_BDCA_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTRBDPD_ACTIVITY_DATE (# 3)
      • Source Code Comments
  • Table PTRBDPL
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRBDPL_BDCA_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRBDPL_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTRBDPL_DESC (# 3)
      • Source Code Comments
    • Columns Comments for PTRBDPL_AMT1 (# 4)
      • Source Code Comments
    • Columns Comments for PTRBDPL_AMT2 (# 5)
      • Source Code Comments
    • Columns Comments for PTRBDPL_AMT3 (# 6)
      • Source Code Comments
    • Columns Comments for PTRBDPL_AMT4 (# 7)
      • Source Code Comments
    • Columns Comments for PTRBDPL_ACTIVITY_DATE (# 8)
      • Source Code Comments
    • Columns Comments for PTRBDPL_EFFECTIVE_DATE (# 9)
      • Source Code Comments
  • Table PTRCITZ
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRCITZ_CITZ_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRCITZ_WS_IRC_STATUS (# 2)
      • Source Code Comments
    • Columns Comments for PTRCITZ_WS_VISA_TYPE (# 3)
      • Source Code Comments
    • Columns Comments for PTRCITZ_USER_ID (# 4)
      • Source Code Comments
    • Columns Comments for PTRCITZ_ACTIVITY_DATE (# 5)
      • Source Code Comments
  • Table PTRFBEN
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRFBEN_BDCA_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRFBEN_PLAN_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTRFBEN_FSA_IND (# 3)
      • Source Code Comments
    • Columns Comments for PTRFBEN_AVAIL_IND (# 4)
      • Source Code Comments
    • Columns Comments for PTRFBEN_FLEX_AMT (# 5)
      • Source Code Comments
    • Columns Comments for PTRFBEN_EMPL_AMT (# 6)
      • Source Code Comments
    • Columns Comments for PTRFBEN_PREM_AMT (# 7)
      • Source Code Comments
    • Columns Comments for PTRFBEN_DEDN_FREQ (# 8)
      • Source Code Comments
    • Columns Comments for PTRFBEN_ACTIVITY_DATE (# 9)
      • Source Code Comments
    • Columns Comments for PTRFBEN_FSA_GRACE_PERIOD_IND (# 10)
      • Source Code Comments
  • Table PTRFILE
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRFILE_PROCESS_ID (# 1)
      • Source Code Comments
    • Columns Comments for PTRFILE_RECORD_ID (# 2)
      • Source Code Comments
    • Columns Comments for PTRFILE_COL_NAME (# 3)
      • Source Code Comments
    • Columns Comments for PTRFILE_POS (# 4)
      • Source Code Comments
    • Columns Comments for PTRFILE_LENGTH (# 5)
      • Source Code Comments
    • Columns Comments for PTRFILE_DATA_TYPE (# 6)
      • Source Code Comments
    • Columns Comments for PTRFILE_REQUIRED_IND (# 7)
      • Source Code Comments
    • Columns Comments for PTRFILE_USER_ID (# 8)
      • Source Code Comments
    • Columns Comments for PTRFILE_ACTIVITY_DATE (# 9)
      • Source Code Comments
  • Table PTRINCD
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRINCD_BEN_DED_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRINCD_USER_ID (# 2)
      • Source Code Comments
    • Columns Comments for PTRINCD_ACTIVITY_DATE (# 3)
      • Source Code Comments
    • Columns Comments for PTRINCD_WS_INCOME_CODE (# 4)
      • Source Code Comments
    • Columns Comments for PTRINCD_WS_INCOME_SUBTYPE (# 5)
      • Source Code Comments
    • Columns Comments for PTRINCD_WS_EXEMPTION_CODE (# 6)
      • Source Code Comments
  • Table PTRTPCM
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRTPCM_TPCD_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRTPCM_BTPC_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTRTPCM_PROGRAM_NAME (# 3)
      • Source Code Comments
    • Columns Comments for PTRTPCM_COLUMN_NAME (# 4)
      • Source Code Comments
    • Columns Comments for PTRTPCM_USER_ID (# 5)
      • Source Code Comments
    • Columns Comments for PTRTPCM_ACTIVITY_DATE (# 6)
      • Source Code Comments
  • Table PTRTPCS
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTRTPCS_TPCD_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTRTPCS_BTPC_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTRTPCS_CODE (# 3)
      • Source Code Comments
    • Columns Comments for PTRTPCS_CODE_DESC (# 4)
      • Source Code Comments
    • Columns Comments for PTRTPCS_USER_ID (# 5)
      • Source Code Comments
    • Columns Comments for PTRTPCS_ACTIVITY_DATE (# 6)
      • Source Code Comments
  • Table PTVBTPC
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTVBTPC_TPCD_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTVBTPC_CATEGORY_CODE (# 2)
      • Source Code Comments
    • Columns Comments for PTVBTPC_CAT_CODE_DESC (# 3)
      • Source Code Comments
    • Columns Comments for PTVBTPC_USER_ID (# 4)
      • Source Code Comments
    • Columns Comments for PTVBTPC_ACTIVITY_DATE (# 5)
      • Source Code Comments
  • Table PTVTPCD
    • Object Full Name
    • Source Code Comments
    • Columns Comments for PTVTPCD_CODE (# 1)
      • Source Code Comments
    • Columns Comments for PTVTPCD_DESC (# 2)
      • Source Code Comments
    • Columns Comments for PTVTPCD_USER_ID (# 3)
      • Source Code Comments
    • Columns Comments for PTVTPCD_ACTIVITY_DATE (# 4)
      • Source Code Comments
  • Link between PTRBDPL and PDRDEDN
    • Join Information
  • Link between PTRBDCA and PDRDEDN
    • Join Information
  • Link between PDRDEDN and PDRBDED
    • Join Information
  • Link between PTRBDPL and PDRBDED
    • Join Information
  • Link between PHR1042 and PHRHIST
    • Join Information
  • Link between PERDHIS and PDRDEDN
    • Join Information
  • Link between PDRBDED and PTRBDPD
    • Join Information
  • Link between PTRFBEN and PDRDEDN
    • Join Information
  • Link between PDRFCLM and PDRDEDN
    • Join Information
  • Link between PDRFBAL and PDRDEDN
    • Join Information
  • Link between PTRBCDN and PEBEMPL
    • Join Information
  • Link between PTRBCDN and PTRBDCA
    • Join Information
  • Link between PDRDEDN and PTRBDPD
    • Join Information
  • Link between PTRBCDN and PDRDEDN
    • Join Information
  • Link between PTRBDCA and PTRBDCL
  • Link between PTRBDPD and PTRBDCA
  • Link between PTRBDPL and PTRBDCA
  • Link between PDRFBAL and PEBEMPL
  • Link between PDRFCLM and PEBEMPL
  • Link between PHRHIST and PEBEMPL
  • Link between PDRDEDN and PTRBDCL
  • Link between PTRFBEN and PTRBDCA
  • Link between PDRBDED and PEBEMPL
  • Link between PDRBDED and PTRBDCA