Model View
Table GTVSDAX
Object Full Name
Source Code Comments
Columns Comments for GTVSDAX_EXTERNAL_CODE (# 1)
Source Code Comments
Columns Comments for GTVSDAX_INTERNAL_CODE (# 2)
Source Code Comments
Columns Comments for GTVSDAX_REPORTING_DATE (# 3)
Source Code Comments
Columns Comments for GTVSDAX_TRANSLATION_CODE (# 4)
Source Code Comments
Columns Comments for GTVSDAX_INTERNAL_CODE_SEQNO (# 5)
Source Code Comments
Columns Comments for GTVSDAX_INTERNAL_CODE_GROUP (# 6)
Source Code Comments
Columns Comments for GTVSDAX_DESC (# 7)
Source Code Comments
Columns Comments for GTVSDAX_SYSREQ_IND (# 8)
Source Code Comments
Columns Comments for GTVSDAX_ACTIVITY_DATE (# 9)
Source Code Comments
Table PARAPST
Object Full Name
Source Code Comments
Columns Comments for PARAPST_PIDM (# 1)
Source Code Comments
Columns Comments for PARAPST_PCLS_CODE (# 2)
Source Code Comments
Columns Comments for PARAPST_POSN (# 3)
Source Code Comments
Columns Comments for PARAPST_APPS_CODE (# 4)
Source Code Comments
Columns Comments for PARAPST_APPS_DATE (# 5)
Source Code Comments
Columns Comments for PARAPST_COMMENT (# 6)
Source Code Comments
Columns Comments for PARAPST_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for PARAPST_REQ_NO (# 8)
Source Code Comments
Columns Comments for PARAPST_APPL_DATE (# 9)
Source Code Comments
Table PCRBENE
Object Full Name
Source Code Comments
Columns Comments for PCRBENE_PIDM (# 1)
Source Code Comments
Columns Comments for PCRBENE_SEQ_NO (# 2)
Source Code Comments
Columns Comments for PCRBENE_BENE_PIDM (# 3)
Source Code Comments
Columns Comments for PCRBENE_BENE_LAST_NAME (# 4)
Source Code Comments
Columns Comments for PCRBENE_BENE_FIRST_NAME (# 5)
Source Code Comments
Columns Comments for PCRBENE_BENE_MI (# 6)
Source Code Comments
Columns Comments for PCRBENE_BREL_CODE (# 7)
Source Code Comments
Columns Comments for PCRBENE_SEX_IND (# 8)
Source Code Comments
Columns Comments for PCRBENE_BIRTH_DATE (# 9)
Source Code Comments
Columns Comments for PCRBENE_COLLEGE_IND (# 10)
Source Code Comments
Columns Comments for PCRBENE_ACTIVITY_DATE (# 11)
Source Code Comments
Columns Comments for PCRBENE_SURNAME_PREFIX (# 12)
Source Code Comments
Table PCRCPAY
Object Full Name
Source Code Comments
Columns Comments for PCRCPAY_PIDM (# 1)
Source Code Comments
Columns Comments for PCRCPAY_TRANS_IND (# 2)
Source Code Comments
Columns Comments for PCRCPAY_TRANS_DATE (# 3)
Source Code Comments
Columns Comments for PCRCPAY_CBEN_CODE (# 4)
Source Code Comments
Columns Comments for PCRCPAY_PLAN (# 5)
Source Code Comments
Columns Comments for PCRCPAY_AMOUNT (# 6)
Source Code Comments
Columns Comments for PCRCPAY_COMMENTS (# 7)
Source Code Comments
Columns Comments for PCRCPAY_DUE_DATE (# 8)
Source Code Comments
Columns Comments for PCRCPAY_HIST_IND (# 9)
Source Code Comments
Columns Comments for PCRCPAY_CLOSE_IND (# 10)
Source Code Comments
Columns Comments for PCRCPAY_ACTIVITY_DATE (# 11)
Source Code Comments
Table PCRDEDN
Object Full Name
Source Code Comments
Columns Comments for PCRDEDN_PIDM (# 1)
Source Code Comments
Columns Comments for PCRDEDN_SEQ_NO (# 2)
Source Code Comments
Columns Comments for PCRDEDN_CBEN_CODE (# 3)
Source Code Comments
Columns Comments for PCRDEDN_PLAN (# 4)
Source Code Comments
Columns Comments for PCRDEDN_BEGIN_DATE (# 5)
Source Code Comments
Columns Comments for PCRDEDN_END_DATE (# 6)
Source Code Comments
Columns Comments for PCRDEDN_ACTIVITY_DATE (# 7)
Source Code Comments
Table PDRBCHS
Object Full Name
Source Code Comments
Columns Comments for PDRBCHS_PIDM (# 1)
Source Code Comments
Columns Comments for PDRBCHS_BDCA_CODE (# 2)
Source Code Comments
Columns Comments for PDRBCHS_BENE_SEQ_NO (# 3)
Source Code Comments
Columns Comments for PDRBCHS_BEGIN_DATE (# 4)
Source Code Comments
Columns Comments for PDRBCHS_END_DATE (# 5)
Source Code Comments
Columns Comments for PDRBCHS_OTHER_COV_IND (# 6)
Source Code Comments
Columns Comments for PDRBCHS_CAPTURE_DATE (# 7)
Source Code Comments
Columns Comments for PDRBCHS_DELETED_IND (# 8)
Source Code Comments
Columns Comments for PDRBCHS_USER_ID (# 9)
Source Code Comments
Columns Comments for PDRBCHS_ACTIVITY_DATE (# 10)
Source Code Comments
Table PDRBCOV
Object Full Name
Source Code Comments
Columns Comments for PDRBCOV_PIDM (# 1)
Source Code Comments
Columns Comments for PDRBCOV_BDCA_CODE (# 2)
Source Code Comments
Columns Comments for PDRBCOV_BENE_SEQ_NO (# 3)
Source Code Comments
Columns Comments for PDRBCOV_BEGIN_DATE (# 4)
Source Code Comments
Columns Comments for PDRBCOV_END_DATE (# 5)
Source Code Comments
Columns Comments for PDRBCOV_OTHER_COV_IND (# 6)
Source Code Comments
Columns Comments for PDRBCOV_ACTIVITY_DATE (# 7)
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 PDRBEHS
Object Full Name
Source Code Comments
Columns Comments for PDRBEHS_PIDM (# 1)
Source Code Comments
Columns Comments for PDRBEHS_SEQ_NO (# 2)
Source Code Comments
Columns Comments for PDRBEHS_BENE_PIDM (# 3)
Source Code Comments
Columns Comments for PDRBEHS_BENE_LAST_NAME (# 4)
Source Code Comments
Columns Comments for PDRBEHS_BENE_FIRST_NAME (# 5)
Source Code Comments
Columns Comments for PDRBEHS_BENE_MI (# 6)
Source Code Comments
Columns Comments for PDRBEHS_BREL_CODE (# 7)
Source Code Comments
Columns Comments for PDRBEHS_SEX_IND (# 8)
Source Code Comments
Columns Comments for PDRBEHS_BIRTH_DATE (# 9)
Source Code Comments
Columns Comments for PDRBEHS_COLLEGE_IND (# 10)
Source Code Comments
Columns Comments for PDRBEHS_SSN (# 11)
Source Code Comments
Columns Comments for PDRBEHS_CAPTURE_DATE (# 12)
Source Code Comments
Columns Comments for PDRBEHS_DELETED_IND (# 13)
Source Code Comments
Columns Comments for PDRBEHS_USER_ID (# 14)
Source Code Comments
Columns Comments for PDRBEHS_ACTIVITY_DATE (# 15)
Source Code Comments
Columns Comments for PDRBEHS_SURNAME_PREFIX (# 16)
Source Code Comments
Table PDRBENE
Object Full Name
Source Code Comments
Columns Comments for PDRBENE_PIDM (# 1)
Source Code Comments
Columns Comments for PDRBENE_SEQ_NO (# 2)
Source Code Comments
Columns Comments for PDRBENE_BENE_PIDM (# 3)
Source Code Comments
Columns Comments for PDRBENE_BENE_LAST_NAME (# 4)
Source Code Comments
Columns Comments for PDRBENE_BENE_FIRST_NAME (# 5)
Source Code Comments
Columns Comments for PDRBENE_BENE_MI (# 6)
Source Code Comments
Columns Comments for PDRBENE_BREL_CODE (# 7)
Source Code Comments
Columns Comments for PDRBENE_SEX_IND (# 8)
Source Code Comments
Columns Comments for PDRBENE_BIRTH_DATE (# 9)
Source Code Comments
Columns Comments for PDRBENE_COLLEGE_IND (# 10)
Source Code Comments
Columns Comments for PDRBENE_ACTIVITY_DATE (# 11)
Source Code Comments
Columns Comments for PDRBENE_SSN (# 12)
Source Code Comments
Columns Comments for PDRBENE_SURNAME_PREFIX (# 13)
Source Code Comments
Table PDRBFLX
Object Full Name
Source Code Comments
Columns Comments for PDRBFLX_PIDM (# 1)
Source Code Comments
Columns Comments for PDRBFLX_FLEX_AMT (# 2)
Source Code Comments
Columns Comments for PDRBFLX_ACTIVITY_DATE (# 3)
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 PDRFLEX
Object Full Name
Source Code Comments
Columns Comments for PDRFLEX_PIDM (# 1)
Source Code Comments
Columns Comments for PDRFLEX_BDCA_CODE (# 2)
Source Code Comments
Columns Comments for PDRFLEX_PLAN_CODE (# 3)
Source Code Comments
Columns Comments for PDRFLEX_STATUS (# 4)
Source Code Comments
Columns Comments for PDRFLEX_START_DATE (# 5)
Source Code Comments
Columns Comments for PDRFLEX_END_DATE (# 6)
Source Code Comments
Columns Comments for PDRFLEX_AMOUNT1 (# 7)
Source Code Comments
Columns Comments for PDRFLEX_AMOUNT2 (# 8)
Source Code Comments
Columns Comments for PDRFLEX_AMOUNT3 (# 9)
Source Code Comments
Columns Comments for PDRFLEX_AMOUNT4 (# 10)
Source Code Comments
Columns Comments for PDRFLEX_LIF_OVR_UDR_AMT (# 11)
Source Code Comments
Columns Comments for PDRFLEX_APPR_IND (# 12)
Source Code Comments
Columns Comments for PDRFLEX_PROCESS_IND (# 13)
Source Code Comments
Columns Comments for PDRFLEX_ACTIVITY_DATE (# 14)
Source Code Comments
Table PDRPERS
Object Full Name
Source Code Comments
Columns Comments for PDRPERS_PIDM (# 1)
Source Code Comments
Columns Comments for PDRPERS_COUNTY_CODE (# 2)
Source Code Comments
Columns Comments for PDRPERS_DISTRICT_CODE (# 3)
Source Code Comments
Columns Comments for PDRPERS_SSN (# 4)
Source Code Comments
Columns Comments for PDRPERS_LAST_NAME (# 6)
Source Code Comments
Columns Comments for PDRPERS_FIRST_NAME (# 7)
Source Code Comments
Columns Comments for PDRPERS_MI (# 8)
Source Code Comments
Columns Comments for PDRPERS_GROUP (# 9)
Source Code Comments
Columns Comments for PDRPERS_ELIGIBLE_GRS (# 10)
Source Code Comments
Columns Comments for PDRPERS_PAY_RATE (# 11)
Source Code Comments
Columns Comments for PDRPERS_PAY_CODE (# 12)
Source Code Comments
Columns Comments for PDRPERS_POST_TAX_AMT (# 13)
Source Code Comments
Columns Comments for PDRPERS_CONT_CODE (# 14)
Source Code Comments
Columns Comments for PDRPERS_EMPL_CONT_RATE (# 15)
Source Code Comments
Columns Comments for PDRPERS_WORK_SCHEDULE (# 16)
Source Code Comments
Columns Comments for PDRPERS_PRE_TAX_AMT (# 17)
Source Code Comments
Columns Comments for PDRPERS_REPORT_IND (# 18)
Source Code Comments
Columns Comments for PDRPERS_USERID (# 19)
Source Code Comments
Columns Comments for PDRPERS_ACTIVITY_DATE (# 20)
Source Code Comments
Columns Comments for PDRPERS_BATCH_NO (# 21)
Source Code Comments
Columns Comments for PDRPERS_SURVIVOR_AMT (# 22)
Source Code Comments
Columns Comments for PDRPERS_EMPR_CONT_RATE (# 23)
Source Code Comments
Columns Comments for PDRPERS_SURNAME_PREFIX (# 24)
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 PERDTOT
Object Full Name
Source Code Comments
Columns Comments for PERDTOT_PIDM (# 1)
Source Code Comments
Columns Comments for PERDTOT_YEAR (# 2)
Source Code Comments
Columns Comments for PERDTOT_BDCA_CODE (# 3)
Source Code Comments
Columns Comments for PERDTOT_MONTH (# 4)
Source Code Comments
Columns Comments for PERDTOT_EMPL_AMT (# 5)
Source Code Comments
Columns Comments for PERDTOT_EMPR_AMT (# 6)
Source Code Comments
Columns Comments for PERDTOT_APPL_GRS (# 7)
Source Code Comments
Columns Comments for PERDTOT_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for PERDTOT_EMPR_CODE (# 9)
Source Code Comments
Table PEREHIS
Object Full Name
Source Code Comments
Columns Comments for PEREHIS_PIDM (# 1)
Source Code Comments
Columns Comments for PEREHIS_EFFECTIVE_DATE (# 2)
Source Code Comments
Columns Comments for PEREHIS_EMPL_STATUS (# 3)
Source Code Comments
Columns Comments for PEREHIS_HOME_ORGN (# 4)
Source Code Comments
Columns Comments for PEREHIS_ECLS_CODE (# 5)
Source Code Comments
Columns Comments for PEREHIS_LCAT_CODE (# 6)
Source Code Comments
Columns Comments for PEREHIS_BCAT_CODE (# 7)
Source Code Comments
Columns Comments for PEREHIS_CURRENT_HIRE_DATE (# 8)
Source Code Comments
Columns Comments for PEREHIS_ADJ_SERVICE_DATE (# 9)
Source Code Comments
Columns Comments for PEREHIS_LREA_CODE (# 10)
Source Code Comments
Columns Comments for PEREHIS_TREA_CODE (# 11)
Source Code Comments
Columns Comments for PEREHIS_USER_ID (# 12)
Source Code Comments
Columns Comments for PEREHIS_ACTIVITY_DATE (# 13)
Source Code Comments
Columns Comments for PEREHIS_TERM_DATE (# 14)
Source Code Comments
Columns Comments for PEREHIS_LOA_BEG_DATE (# 15)
Source Code Comments
Columns Comments for PEREHIS_LOA_END_DATE (# 16)
Source Code Comments
Columns Comments for PEREHIS_COAS_CODE_HOME (# 17)
Source Code Comments
Columns Comments for PEREHIS_COAS_CODE_DIST (# 18)
Source Code Comments
Columns Comments for PEREHIS_ORGN_CODE_DIST (# 19)
Source Code Comments
Columns Comments for PEREHIS_FIRST_HIRE_DATE (# 20)
Source Code Comments
Columns Comments for PEREHIS_SENIORITY_DATE (# 21)
Source Code Comments
Columns Comments for PEREHIS_I9_FORM_IND (# 22)
Source Code Comments
Columns Comments for PEREHIS_I9_DATE (# 23)
Source Code Comments
Columns Comments for PEREHIS_I9_EXPIRE_DATE (# 24)
Source Code Comments
Columns Comments for PEREHIS_WKPR_CODE (# 25)
Source Code Comments
Columns Comments for PEREHIS_FLSA_IND (# 26)
Source Code Comments
Columns Comments for PEREHIS_STGR_CODE (# 27)
Source Code Comments
Columns Comments for PEREHIS_DAYS_IN_CANADA (# 28)
Source Code Comments
Columns Comments for PEREHIS_1042_RECIPIENT_CD (# 29)
Source Code Comments
Columns Comments for PEREHIS_INTERNAL_FT_PT_IND (# 30)
Source Code Comments
Columns Comments for PEREHIS_DICD_CODE (# 31)
Source Code Comments
Columns Comments for PEREHIS_EGRP_CODE (# 32)
Source Code Comments
Columns Comments for PEREHIS_IPEDS_SOFT_MONEY_IND (# 33)
Source Code Comments
Columns Comments for PEREHIS_FIRST_WORK_DATE (# 34)
Source Code Comments
Columns Comments for PEREHIS_LAST_WORK_DATE (# 35)
Source Code Comments
Columns Comments for PEREHIS_CALIF_PENSION_IND (# 36)
Source Code Comments
Columns Comments for PEREHIS_NRSI_CODE (# 37)
Source Code Comments
Columns Comments for PEREHIS_SSN_LAST_NAME (# 38)
Source Code Comments
Columns Comments for PEREHIS_SSN_FIRST_NAME (# 39)
Source Code Comments
Columns Comments for PEREHIS_SSN_MI (# 40)
Source Code Comments
Columns Comments for PEREHIS_SSN_SUFFIX (# 41)
Source Code Comments
Columns Comments for PEREHIS_JBLN_CODE (# 42)
Source Code Comments
Columns Comments for PEREHIS_COLL_CODE (# 43)
Source Code Comments
Columns Comments for PEREHIS_CAMP_CODE (# 44)
Source Code Comments
Columns Comments for PEREHIS_DATA_ORIGIN (# 45)
Source Code Comments
Columns Comments for PEREHIS_EW2_CONSENT_IND (# 46)
Source Code Comments
Columns Comments for PEREHIS_EW2_CONSENT_DATE (# 47)
Source Code Comments
Columns Comments for PEREHIS_EW2_CONSENT_USER_ID (# 48)
Source Code Comments
Columns Comments for PEREHIS_IPEDS_PRIMARY_FUNCTION (# 49)
Source Code Comments
Columns Comments for PEREHIS_IPEDS_MED_DENTAL_IND (# 50)
Source Code Comments
Columns Comments for PEREHIS_ETAX_CONSENT_IND (# 51)
Source Code Comments
Columns Comments for PEREHIS_ETAX_CONSENT_DATE (# 52)
Source Code Comments
Columns Comments for PEREHIS_ETAX_CONSENT_USER_ID (# 53)
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 PERJTOT
Object Full Name
Source Code Comments
Columns Comments for PERJTOT_PIDM (# 1)
Source Code Comments
Columns Comments for PERJTOT_YEAR (# 2)
Source Code Comments
Columns Comments for PERJTOT_POSN (# 3)
Source Code Comments
Columns Comments for PERJTOT_SUFF (# 4)
Source Code Comments
Columns Comments for PERJTOT_EARN_CODE (# 5)
Source Code Comments
Columns Comments for PERJTOT_MONTH (# 6)
Source Code Comments
Columns Comments for PERJTOT_HRS (# 7)
Source Code Comments
Columns Comments for PERJTOT_GRS (# 8)
Source Code Comments
Columns Comments for PERJTOT_ACTIVITY_DATE (# 9)
Source Code Comments
Columns Comments for PERJTOT_EMPR_CODE (# 10)
Source Code Comments
Table PERPCRE
Object Full Name
Source Code Comments
Columns Comments for PERPCRE_YEAR (# 1)
Source Code Comments
Columns Comments for PERPCRE_EMPR_CODE (# 2)
Source Code Comments
Columns Comments for PERPCRE_PIDM (# 3)
Source Code Comments
Columns Comments for PERPCRE_BDCA_CODE (# 4)
Source Code Comments
Columns Comments for PERPCRE_BDPL_CODE (# 5)
Source Code Comments
Columns Comments for PERPCRE_PENSION_CREDIT (# 6)
Source Code Comments
Columns Comments for PERPCRE_CREDIT_OVERRIDE (# 7)
Source Code Comments
Columns Comments for PERPCRE_PENSION_SERVICE (# 8)
Source Code Comments
Columns Comments for PERPCRE_SERVICE_OVERRIDE (# 9)
Source Code Comments
Columns Comments for PERPCRE_ACTIVITY_DATE (# 10)
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 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 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 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 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 PTRBCAT
Object Full Name
Source Code Comments
Columns Comments for PTRBCAT_CODE (# 1)
Source Code Comments
Columns Comments for PTRBCAT_DESC (# 2)
Source Code Comments
Columns Comments for PTRBCAT_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for PTRBCAT_FLEX_AMT (# 4)
Source Code Comments
Columns Comments for PTRBCAT_WEB_ACCESS_IND (# 5)
Source Code Comments
Columns Comments for PTRBCAT_OPEN_BEGIN_DATE (# 6)
Source Code Comments
Columns Comments for PTRBCAT_OPEN_END_DATE (# 7)
Source Code Comments
Columns Comments for PTRBCAT_OPEN_EFFECTIVE_DATE (# 8)
Source Code Comments
Columns Comments for PTRBCAT_DATE_OVERRIDE_IND (# 9)
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 PTRBDAS
Object Full Name
Source Code Comments
Columns Comments for PTRBDAS_CODE (# 1)
Source Code Comments
Columns Comments for PTRBDAS_BDCA_CODE (# 2)
Source Code Comments
Columns Comments for PTRBDAS_ACTIVITY_DATE (# 3)
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 PTRBDCG
Object Full Name
Source Code Comments
Columns Comments for PTRBDCG_CODE (# 1)
Source Code Comments
Columns Comments for PTRBDCG_BDCA_CODE (# 2)
Source Code Comments
Columns Comments for PTRBDCG_USER_ID (# 3)
Source Code Comments
Columns Comments for PTRBDCG_ACTIVITY_DATE (# 4)
Source Code Comments
Table PTRBDGM
Object Full Name
Source Code Comments
Columns Comments for PTRBDGM_BDCA_CODE (# 1)
Source Code Comments
Columns Comments for PTRBDGM_BDPG_CODE (# 2)
Source Code Comments
Columns Comments for PTRBDGM_BDSG_CODE (# 3)
Source Code Comments
Columns Comments for PTRBDGM_WEB_SEL_IND (# 4)
Source Code Comments
Columns Comments for PTRBDGM_WEB_INS_IND (# 5)
Source Code Comments
Columns Comments for PTRBDGM_WEB_UPD_IND (# 6)
Source Code Comments
Columns Comments for PTRBDGM_WEB_DEL_IND (# 7)
Source Code Comments
Columns Comments for PTRBDGM_WEB_EMPR_IND (# 8)
Source Code Comments
Columns Comments for PTRBDGM_WEB_CVG_SEL_IND (# 9)
Source Code Comments
Columns Comments for PTRBDGM_WEB_CVG_INS_IND (# 10)
Source Code Comments
Columns Comments for PTRBDGM_WEB_CVG_UPD_IND (# 11)
Source Code Comments
Columns Comments for PTRBDGM_WEB_CVG_DEL_IND (# 12)
Source Code Comments
Columns Comments for PTRBDGM_WEB_OPEN_IND (# 13)
Source Code Comments
Columns Comments for PTRBDGM_ACTIVITY_DATE (# 14)
Source Code Comments
Table PTRBDLD
Object Full Name
Source Code Comments
Columns Comments for PTRBDLD_CODE (# 1)
Source Code Comments
Columns Comments for PTRBDLD_ECLS_CODE (# 2)
Source Code Comments
Columns Comments for PTRBDLD_COAS_CODE (# 3)
Source Code Comments
Columns Comments for PTRBDLD_ACCI_CODE_EMP_LIB (# 4)
Source Code Comments
Columns Comments for PTRBDLD_FUND_CODE_EMP_LIB (# 5)
Source Code Comments
Columns Comments for PTRBDLD_ORGN_CODE_EMP_LIB (# 6)
Source Code Comments
Columns Comments for PTRBDLD_ACCT_CODE_EMP_LIB (# 7)
Source Code Comments
Columns Comments for PTRBDLD_PROG_CODE_EMP_LIB (# 8)
Source Code Comments
Columns Comments for PTRBDLD_ACTV_CODE_EMP_LIB (# 9)
Source Code Comments
Columns Comments for PTRBDLD_LOCN_CODE_EMP_LIB (# 10)
Source Code Comments
Columns Comments for PTRBDLD_ACCI_CODE_EMR_EXP (# 11)
Source Code Comments
Columns Comments for PTRBDLD_FUND_CODE_EMR_EXP (# 12)
Source Code Comments
Columns Comments for PTRBDLD_ORGN_CODE_EMR_EXP (# 13)
Source Code Comments
Columns Comments for PTRBDLD_ACCT_CODE_EMR_EXP (# 14)
Source Code Comments
Columns Comments for PTRBDLD_PROG_CODE_EMR_EXP (# 15)
Source Code Comments
Columns Comments for PTRBDLD_ACTV_CODE_EMR_EXP (# 16)
Source Code Comments
Columns Comments for PTRBDLD_LOCN_CODE_EMR_EXP (# 17)
Source Code Comments
Columns Comments for PTRBDLD_ACCI_CODE_EMR_LIB (# 18)
Source Code Comments
Columns Comments for PTRBDLD_FUND_CODE_EMR_LIB (# 19)
Source Code Comments
Columns Comments for PTRBDLD_ORGN_CODE_EMR_LIB (# 20)
Source Code Comments
Columns Comments for PTRBDLD_ACCT_CODE_EMR_LIB (# 21)
Source Code Comments
Columns Comments for PTRBDLD_PROG_CODE_EMR_LIB (# 22)
Source Code Comments
Columns Comments for PTRBDLD_ACTV_CODE_EMR_LIB (# 23)
Source Code Comments
Columns Comments for PTRBDLD_LOCN_CODE_EMR_LIB (# 24)
Source Code Comments
Columns Comments for PTRBDLD_EMP_LIB_EXTERNAL (# 25)
Source Code Comments
Columns Comments for PTRBDLD_EMR_EXP_EXTERNAL (# 26)
Source Code Comments
Columns Comments for PTRBDLD_EMR_LIB_EXTERNAL (# 27)
Source Code Comments
Columns Comments for PTRBDLD_ACTIVITY_DATE (# 28)
Source Code Comments
Table PTRBDMC
Object Full Name
Source Code Comments
Columns Comments for PTRBDMC_BCAT_CODE (# 1)
Source Code Comments
Columns Comments for PTRBDMC_BDCA_CODE (# 2)
Source Code Comments
Columns Comments for PTRBDMC_EFFECTIVE_DATE (# 3)
Source Code Comments
Columns Comments for PTRBDMC_ACTION (# 4)
Source Code Comments
Columns Comments for PTRBDMC_SELECT_STATUS (# 5)
Source Code Comments
Columns Comments for PTRBDMC_CHANGE_STATUS (# 6)
Source Code Comments
Columns Comments for PTRBDMC_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for PTRBDMC_USER_ID (# 8)
Source Code Comments
Columns Comments for PTRBDMC_REPL_BDCA_CODE (# 9)
Source Code Comments
Columns Comments for PTRBDMC_REF_NO (# 10)
Source Code Comments
Columns Comments for PTRBDMC_AMOUNT1 (# 11)
Source Code Comments
Columns Comments for PTRBDMC_AMOUNT2 (# 12)
Source Code Comments
Columns Comments for PTRBDMC_AMOUNT3 (# 13)
Source Code Comments
Columns Comments for PTRBDMC_AMOUNT4 (# 14)
Source Code Comments
Columns Comments for PTRBDMC_OPT_CODE1 (# 15)
Source Code Comments
Columns Comments for PTRBDMC_OPT_CODE2 (# 16)
Source Code Comments
Columns Comments for PTRBDMC_OPT_CODE3 (# 17)
Source Code Comments
Columns Comments for PTRBDMC_OPT_CODE4 (# 18)
Source Code Comments
Columns Comments for PTRBDMC_OPT_CODE5 (# 19)
Source Code Comments
Columns Comments for PTRBDMC_BDCL_CODE (# 20)
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 PTRBDPG
Object Full Name
Source Code Comments
Columns Comments for PTRBDPG_CODE (# 1)
Source Code Comments
Columns Comments for PTRBDPG_WEB_SEL_IND (# 2)
Source Code Comments
Columns Comments for PTRBDPG_WEB_INS_IND (# 3)
Source Code Comments
Columns Comments for PTRBDPG_WEB_UPD_IND (# 4)
Source Code Comments
Columns Comments for PTRBDPG_WEB_DEL_IND (# 5)
Source Code Comments
Columns Comments for PTRBDPG_WEB_EMPR_IND (# 6)
Source Code Comments
Columns Comments for PTRBDPG_WEB_CVG_SEL_IND (# 7)
Source Code Comments
Columns Comments for PTRBDPG_WEB_CVG_INS_IND (# 8)
Source Code Comments
Columns Comments for PTRBDPG_WEB_CVG_UPD_IND (# 9)
Source Code Comments
Columns Comments for PTRBDPG_WEB_CVG_DEL_IND (# 10)
Source Code Comments
Columns Comments for PTRBDPG_WEB_OPEN_IND (# 11)
Source Code Comments
Columns Comments for PTRBDPG_ACTIVITY_DATE (# 12)
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 PTRBDSG
Object Full Name
Source Code Comments
Columns Comments for PTRBDSG_CODE (# 1)
Source Code Comments
Columns Comments for PTRBDSG_DESC (# 2)
Source Code Comments
Columns Comments for PTRBDSG_WEB_SEL_IND (# 3)
Source Code Comments
Columns Comments for PTRBDSG_WEB_INS_IND (# 4)
Source Code Comments
Columns Comments for PTRBDSG_BDPG_CODE (# 5)
Source Code Comments
Columns Comments for PTRBDSG_WEB_UPD_IND (# 6)
Source Code Comments
Columns Comments for PTRBDSG_WEB_DEL_IND (# 7)
Source Code Comments
Columns Comments for PTRBDSG_WEB_EMPR_IND (# 8)
Source Code Comments
Columns Comments for PTRBDSG_WEB_CVG_SEL_IND (# 9)
Source Code Comments
Columns Comments for PTRBDSG_WEB_CVG_INS_IND (# 10)
Source Code Comments
Columns Comments for PTRBDSG_WEB_CVG_UPD_IND (# 11)
Source Code Comments
Columns Comments for PTRBDSG_WEB_CVG_DEL_IND (# 12)
Source Code Comments
Columns Comments for PTRBDSG_WEB_OPEN_IND (# 13)
Source Code Comments
Columns Comments for PTRBDSG_ACTIVITY_DATE (# 14)
Source Code Comments
Table PTRCBEN
Object Full Name
Source Code Comments
Columns Comments for PTRCBEN_CODE (# 1)
Source Code Comments
Columns Comments for PTRCBEN_PLAN (# 2)
Source Code Comments
Columns Comments for PTRCBEN_GROUP (# 3)
Source Code Comments
Columns Comments for PTRCBEN_NO_COLLEGE_AGE (# 4)
Source Code Comments
Columns Comments for PTRCBEN_COLLEGE_AGE (# 5)
Source Code Comments
Columns Comments for PTRCBEN_DELAY_IND (# 6)
Source Code Comments
Columns Comments for PTRCBEN_DELAY_MONTHS (# 7)
Source Code Comments
Columns Comments for PTRCBEN_GRACE_DAYS (# 8)
Source Code Comments
Columns Comments for PTRCBEN_BASIC_COST (# 9)
Source Code Comments
Columns Comments for PTRCBEN_ADMIN_COST (# 10)
Source Code Comments
Columns Comments for PTRCBEN_TOTAL_COST (# 11)
Source Code Comments
Columns Comments for PTRCBEN_ADMIN_PERCENT (# 12)
Source Code Comments
Columns Comments for PTRCBEN_RATE_CHANGE_IND (# 13)
Source Code Comments
Columns Comments for PTRCBEN_COAS_CODE (# 14)
Source Code Comments
Columns Comments for PTRCBEN_ACCI_CODE_CSH (# 15)
Source Code Comments
Columns Comments for PTRCBEN_FUND_CODE_CSH (# 16)
Source Code Comments
Columns Comments for PTRCBEN_ORGN_CODE_CSH (# 17)
Source Code Comments
Columns Comments for PTRCBEN_ACCT_CODE_CSH (# 18)
Source Code Comments
Columns Comments for PTRCBEN_PROG_CODE_CSH (# 19)
Source Code Comments
Columns Comments for PTRCBEN_ACTV_CODE_CSH (# 20)
Source Code Comments
Columns Comments for PTRCBEN_LOCN_CODE_CSH (# 21)
Source Code Comments
Columns Comments for PTRCBEN_ACCT_CODE_EXTERNAL_CSH (# 22)
Source Code Comments
Columns Comments for PTRCBEN_ACCI_CODE_BEN (# 23)
Source Code Comments
Columns Comments for PTRCBEN_FUND_CODE_BEN (# 24)
Source Code Comments
Columns Comments for PTRCBEN_ORGN_CODE_BEN (# 25)
Source Code Comments
Columns Comments for PTRCBEN_ACCT_CODE_BEN (# 26)
Source Code Comments
Columns Comments for PTRCBEN_PROG_CODE_BEN (# 27)
Source Code Comments
Columns Comments for PTRCBEN_ACTV_CODE_BEN (# 28)
Source Code Comments
Columns Comments for PTRCBEN_LOCN_CODE_BEN (# 29)
Source Code Comments
Columns Comments for PTRCBEN_ACCT_CODE_EXTERNAL_BEN (# 30)
Source Code Comments
Columns Comments for PTRCBEN_ACCI_CODE_ADM (# 31)
Source Code Comments
Columns Comments for PTRCBEN_FUND_CODE_ADM (# 32)
Source Code Comments
Columns Comments for PTRCBEN_ORGN_CODE_ADM (# 33)
Source Code Comments
Columns Comments for PTRCBEN_ACCT_CODE_ADM (# 34)
Source Code Comments
Columns Comments for PTRCBEN_PROG_CODE_ADM (# 35)
Source Code Comments
Columns Comments for PTRCBEN_ACTV_CODE_ADM (# 36)
Source Code Comments
Columns Comments for PTRCBEN_LOCN_CODE_ADM (# 37)
Source Code Comments
Columns Comments for PTRCBEN_ACCT_CODE_EXTERNAL_ADM (# 38)
Source Code Comments
Columns Comments for PTRCBEN_ACTIVITY_DATE (# 39)
Source Code Comments
Table PTRECBC
Object Full Name
Source Code Comments
Columns Comments for PTRECBC_CODE (# 1)
Source Code Comments
Columns Comments for PTRECBC_BCAT_CODE (# 2)
Source Code Comments
Columns Comments for PTRECBC_ACTIVITY_DATE (# 3)
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 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 PTRLIFE
Object Full Name
Source Code Comments
Columns Comments for PTRLIFE_BDCA_CODE (# 1)
Source Code Comments
Columns Comments for PTRLIFE_BDPL_CODE (# 2)
Source Code Comments
Columns Comments for PTRLIFE_INS_SALARY_DATE (# 3)
Source Code Comments
Columns Comments for PTRLIFE_AGE_DATE (# 4)
Source Code Comments
Columns Comments for PTRLIFE_ACTIVITY_DATE (# 5)
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 PTVBDPG
Object Full Name
Source Code Comments
Columns Comments for PTVBDPG_CODE (# 1)
Source Code Comments
Columns Comments for PTVBDPG_DESC (# 2)
Source Code Comments
Columns Comments for PTVBDPG_ACTIVITY_DATE (# 3)
Source Code Comments
Table PTVBDTY
Object Full Name
Source Code Comments
Columns Comments for PTVBDTY_CODE (# 1)
Source Code Comments
Columns Comments for PTVBDTY_DESC (# 2)
Source Code Comments
Columns Comments for PTVBDTY_ACTIVITY_DATE (# 3)
Source Code Comments
Table PXRADDS
Object Full Name
Source Code Comments
Columns Comments for PXRADDS_TXCD_CODE (# 1)
Source Code Comments
Columns Comments for PXRADDS_FSTA_CODE (# 2)
Source Code Comments
Columns Comments for PXRADDS_SEQ_NO (# 3)
Source Code Comments
Columns Comments for PXRADDS_OPT_CODE (# 4)
Source Code Comments
Columns Comments for PXRADDS_MULT_OR_ADD (# 5)
Source Code Comments
Columns Comments for PXRADDS_EXEMP_MULT (# 6)
Source Code Comments
Columns Comments for PXRADDS_USER_ID (# 7)
Source Code Comments
Columns Comments for PXRADDS_ACTIVITY_DATE (# 8)
Source Code Comments
Table PXRCALC
Object Full Name
Source Code Comments
Columns Comments for PXRCALC_TXCD_CODE (# 1)
Source Code Comments
Columns Comments for PXRCALC_FSTA_CODE (# 2)
Source Code Comments
Columns Comments for PXRCALC_STEP_NO (# 3)
Source Code Comments
Columns Comments for PXRCALC_STEP_DESC (# 4)
Source Code Comments
Columns Comments for PXRCALC_OPERATOR (# 5)
Source Code Comments
Columns Comments for PXRCALC_OPERAND_IND (# 6)
Source Code Comments
Columns Comments for PXRCALC_OPERAND_TYPE (# 7)
Source Code Comments
Columns Comments for PXRCALC_AMOUNT (# 8)
Source Code Comments
Columns Comments for PXRCALC_RANGE_LOW (# 9)
Source Code Comments
Columns Comments for PXRCALC_RANGE_HIGH (# 10)
Source Code Comments
Columns Comments for PXRCALC_USER_ID (# 11)
Source Code Comments
Columns Comments for PXRCALC_ACTIVITY_DATE (# 12)
Source Code Comments
Table PXREXEM
Object Full Name
Source Code Comments
Columns Comments for PXREXEM_TXCD_CODE (# 1)
Source Code Comments
Columns Comments for PXREXEM_FSTA_CODE (# 2)
Source Code Comments
Columns Comments for PXREXEM_SEQ_NO (# 3)
Source Code Comments
Columns Comments for PXREXEM_PERCENT (# 4)
Source Code Comments
Columns Comments for PXREXEM_RANGE_LOW (# 5)
Source Code Comments
Columns Comments for PXREXEM_RANGE_HIGH (# 6)
Source Code Comments
Columns Comments for PXREXEM_MAX_ANN_TAX (# 7)
Source Code Comments
Columns Comments for PXREXEM_WAGE_BASE (# 8)
Source Code Comments
Columns Comments for PXREXEM_EMPR_PERCENT (# 9)
Source Code Comments
Columns Comments for PXREXEM_OPT_CODE (# 10)
Source Code Comments
Columns Comments for PXREXEM_MULT_OR_ADD (# 11)
Source Code Comments
Columns Comments for PXREXEM_EXEMP_MULT (# 12)
Source Code Comments
Columns Comments for PXREXEM_DEDN_IND (# 13)
Source Code Comments
Columns Comments for PXREXEM_DEDN_TYPE (# 14)
Source Code Comments
Columns Comments for PXREXEM_DEDN_PERCENT (# 15)
Source Code Comments
Columns Comments for PXREXEM_USER_ID (# 16)
Source Code Comments
Columns Comments for PXREXEM_ACTIVITY_DATE (# 17)
Source Code Comments
Columns Comments for PXREXEM_BDTY_CODE (# 18)
Source Code Comments
Table PXRFSTA
Object Full Name
Source Code Comments
Columns Comments for PXRFSTA_TXCD_CODE (# 1)
Source Code Comments
Columns Comments for PXRFSTA_FIL_STAT (# 2)
Source Code Comments
Columns Comments for PXRFSTA_DESC (# 3)
Source Code Comments
Columns Comments for PXRFSTA_LOW_INCOME (# 4)
Source Code Comments
Columns Comments for PXRFSTA_USER_ID (# 5)
Source Code Comments
Columns Comments for PXRFSTA_ACTIVITY_DATE (# 6)
Source Code Comments
Table PXRGRAD
Object Full Name
Source Code Comments
Columns Comments for PXRGRAD_TXCD_CODE (# 1)
Source Code Comments
Columns Comments for PXRGRAD_FSTA_CODE (# 2)
Source Code Comments
Columns Comments for PXRGRAD_OVER (# 3)
Source Code Comments
Columns Comments for PXRGRAD_NOT_OVER (# 4)
Source Code Comments
Columns Comments for PXRGRAD_AMOUNT (# 5)
Source Code Comments
Columns Comments for PXRGRAD_PERCENT (# 6)
Source Code Comments
Columns Comments for PXRGRAD_OVER2 (# 7)
Source Code Comments
Columns Comments for PXRGRAD_USER_ID (# 8)
Source Code Comments
Columns Comments for PXRGRAD_ACTIVITY_DATE (# 9)
Source Code Comments
Columns Comments for PXRGRAD_STEP_NO (# 10)
Source Code Comments
Table PXRRDED
Object Full Name
Source Code Comments
Columns Comments for PXRRDED_REPT_CODE (# 1)
Source Code Comments
Columns Comments for PXRRDED_RBOX_CODE (# 2)
Source Code Comments
Columns Comments for PXRRDED_BDCA_CODE (# 3)
Source Code Comments
Columns Comments for PXRRDED_AMT_IND (# 4)
Source Code Comments
Columns Comments for PXRRDED_ACTIVITY_DATE (# 5)
Source Code Comments
Table PXRREPT
Object Full Name
Source Code Comments
Columns Comments for PXRREPT_REPT_CODE (# 1)
Source Code Comments
Columns Comments for PXRREPT_YEAR (# 2)
Source Code Comments
Columns Comments for PXRREPT_START_MONTH (# 3)
Source Code Comments
Columns Comments for PXRREPT_END_MONTH (# 4)
Source Code Comments
Columns Comments for PXRREPT_EMPR_CODE (# 5)
Source Code Comments
Columns Comments for PXRREPT_PIDM (# 6)
Source Code Comments
Columns Comments for PXRREPT_RBOX_CODE (# 7)
Source Code Comments
Columns Comments for PXRREPT_SESSION_ID (# 8)
Source Code Comments
Columns Comments for PXRREPT_AMOUNT (# 9)
Source Code Comments
Columns Comments for PXRREPT_ACTIVITY_DATE (# 10)
Source Code Comments
Table PXRRERN
Object Full Name
Source Code Comments
Columns Comments for PXRRERN_REPT_CODE (# 1)
Source Code Comments
Columns Comments for PXRRERN_RBOX_CODE (# 2)
Source Code Comments
Columns Comments for PXRRERN_EARN_CODE (# 3)
Source Code Comments
Columns Comments for PXRRERN_ACTIVITY_DATE (# 4)
Source Code Comments
Table PXRTXCD
Object Full Name
Source Code Comments
Columns Comments for PXRTXCD_CODE (# 1)
Source Code Comments
Columns Comments for PXRTXCD_DESC (# 2)
Source Code Comments
Columns Comments for PXRTXCD_TAX_TYPE (# 3)
Source Code Comments
Columns Comments for PXRTXCD_STARTING_POINT (# 4)
Source Code Comments
Columns Comments for PXRTXCD_ANNUALIZATION_METHOD (# 5)
Source Code Comments
Columns Comments for PXRTXCD_SUPPLEMENTAL_PERCENT (# 6)
Source Code Comments
Columns Comments for PXRTXCD_USER_ID (# 7)
Source Code Comments
Columns Comments for PXRTXCD_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for PXRTXCD_STAT_CODE (# 9)
Source Code Comments
Columns Comments for PXRTXCD_FIPS_CODE (# 10)
Source Code Comments
Columns Comments for PXRTXCD_1099_IND (# 11)
Source Code Comments
Table SPBPERS
Object Full Name
Source Code Comments
Lock
Columns Comments for SPBPERS_PIDM (# 1)
Source Code Comments
Columns Comments for SPBPERS_SSN (# 2)
Source Code Comments
Columns Comments for SPBPERS_BIRTH_DATE (# 3)
Source Code Comments
Columns Comments for SPBPERS_LGCY_CODE (# 4)
Source Code Comments
Columns Comments for SPBPERS_ETHN_CODE (# 5)
Source Code Comments
Columns Comments for SPBPERS_MRTL_CODE (# 6)
Source Code Comments
Columns Comments for SPBPERS_RELG_CODE (# 7)
Source Code Comments
Columns Comments for SPBPERS_SEX (# 8)
Source Code Comments
Columns Comments for SPBPERS_CONFID_IND (# 9)
Source Code Comments
Columns Comments for SPBPERS_DEAD_IND (# 10)
Source Code Comments
Columns Comments for SPBPERS_VETC_FILE_NUMBER (# 11)
Source Code Comments
Columns Comments for SPBPERS_LEGAL_NAME (# 12)
Source Code Comments
Columns Comments for SPBPERS_PREF_FIRST_NAME (# 13)
Source Code Comments
Columns Comments for SPBPERS_NAME_PREFIX (# 14)
Source Code Comments
Columns Comments for SPBPERS_NAME_SUFFIX (# 15)
Source Code Comments
Columns Comments for SPBPERS_ACTIVITY_DATE (# 16)
Source Code Comments
Columns Comments for SPBPERS_VERA_IND (# 17)
Source Code Comments
Columns Comments for SPBPERS_CITZ_IND (# 18)
Source Code Comments
Columns Comments for SPBPERS_DEAD_DATE (# 19)
Source Code Comments
Columns Comments for SPBPERS_PIN (# 20)
Source Code Comments
Columns Comments for SPBPERS_CITZ_CODE (# 21)
Source Code Comments
Columns Comments for SPBPERS_HAIR_CODE (# 22)
Source Code Comments
Columns Comments for SPBPERS_EYES_CODE (# 23)
Source Code Comments
Columns Comments for SPBPERS_CITY_BIRTH (# 24)
Source Code Comments
Columns Comments for SPBPERS_STAT_CODE_BIRTH (# 25)
Source Code Comments
Columns Comments for SPBPERS_DRIVER_LICENSE (# 26)
Source Code Comments
Columns Comments for SPBPERS_STAT_CODE_DRIVER (# 27)
Source Code Comments
Columns Comments for SPBPERS_NATN_CODE_DRIVER (# 28)
Source Code Comments
Columns Comments for SPBPERS_UOMS_CODE_HEIGHT (# 29)
Source Code Comments
Columns Comments for SPBPERS_HEIGHT (# 30)
Source Code Comments
Columns Comments for SPBPERS_UOMS_CODE_WEIGHT (# 31)
Source Code Comments
Columns Comments for SPBPERS_WEIGHT (# 32)
Source Code Comments
Columns Comments for SPBPERS_SDVET_IND (# 33)
Source Code Comments
Columns Comments for SPBPERS_LICENSE_ISSUED_DATE (# 34)
Source Code Comments
Columns Comments for SPBPERS_LICENSE_EXPIRES_DATE (# 35)
Source Code Comments
Columns Comments for SPBPERS_INCAR_IND (# 36)
Source Code Comments
Columns Comments for SPBPERS_WEBID (# 37)
Source Code Comments
Columns Comments for SPBPERS_WEB_LAST_ACCESS (# 38)
Source Code Comments
Columns Comments for SPBPERS_PIN_DISABLED_IND (# 39)
Source Code Comments
Columns Comments for SPBPERS_ITIN (# 40)
Source Code Comments
Columns Comments for SPBPERS_ACTIVE_DUTY_SEPR_DATE (# 41)
Source Code Comments
Columns Comments for SPBPERS_DATA_ORIGIN (# 42)
Source Code Comments
Columns Comments for SPBPERS_USER_ID (# 43)
Source Code Comments
Columns Comments for SPBPERS_ETHN_CDE (# 44)
Source Code Comments
Columns Comments for SPBPERS_CONFIRMED_RE_CDE (# 45)
Source Code Comments
Columns Comments for SPBPERS_CONFIRMED_RE_DATE (# 46)
Source Code Comments
Table SPRIDEN
Object Full Name
Source Code Comments
Columns Comments for SPRIDEN_PIDM (# 1)
Source Code Comments
Columns Comments for SPRIDEN_ID (# 2)
Source Code Comments
Columns Comments for SPRIDEN_LAST_NAME (# 3)
Source Code Comments
Columns Comments for SPRIDEN_FIRST_NAME (# 4)
Source Code Comments
Columns Comments for SPRIDEN_MI (# 5)
Source Code Comments
Columns Comments for SPRIDEN_CHANGE_IND (# 6)
Source Code Comments
Columns Comments for SPRIDEN_ENTITY_IND (# 7)
Source Code Comments
Columns Comments for SPRIDEN_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for SPRIDEN_USER (# 9)
Source Code Comments
Columns Comments for SPRIDEN_ORIGIN (# 10)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_LAST_NAME (# 11)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_FIRST_NAME (# 12)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_MI (# 13)
Source Code Comments
Columns Comments for SPRIDEN_SOUNDEX_LAST_NAME (# 14)
Source Code Comments
Columns Comments for SPRIDEN_SOUNDEX_FIRST_NAME (# 15)
Source Code Comments
Columns Comments for SPRIDEN_NTYP_CODE (# 16)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_USER (# 17)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_DATE (# 18)
Source Code Comments
Columns Comments for SPRIDEN_DATA_ORIGIN (# 19)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_FDMN_CODE (# 20)
Source Code Comments
Columns Comments for SPRIDEN_SURNAME_PREFIX (# 21)
Source Code Comments
Link between SPRIDEN and SPBPERS
Join Information
Link between PTRBDPL and PDRDEDN
Join Information
Link between PTRBDCA and PDRDEDN
Join Information
Link between PERJTOT and PXRRERN
Join Information
Link between PERDTOT and PXRRDED
Join Information
Link between PXRRERN and PXRREPT
Join Information
Link between PERJTOT and PXRREPT
Join Information
Link between PXRRDED and PXRREPT
Join Information
Link between PERDTOT and PXRREPT
Join Information
Link between PPRCOLR and PXRRERN
Join Information
Link between PPRCOLR and PERJTOT
Join Information
Link between PPRCOLR and PXRRDED
Join Information
Link between PPRCOLR and PERDTOT
Join Information
Link between PHREARN and PPRCOLR
Join Information
Link between PPRCOLR and PHRJOBS
Join Information
Link between PERDTOT and PTRBDCA
Join Information
Link between PPRCOLR and PTRBDCA
Join Information
Link between SPRIDEN and PEBEMPL
Join Information
Link between PDRBENE and PDRBCOV
Join Information
Link between PDRDEDN and PDRBDED
Join Information
Link between SPRIDEN and PDRBDED
Join Information
Link between PERDTOT and PTRBDAS
Join Information
Link between PXRTXCD and PTRBDCA
Join Information
Link between PTRBDPL and PDRBDED
Join Information
Link between PTRBDCA and PDRBCOV
Join Information
Link between SPRIDEN and PDRBENE
Join Information
Link between PDRBENE and SPBPERS
Join Information
Link between PARAPST and GTVSDAX
Join Information
Link between SPBPERS and PEBEMPL
Join Information
Link between GTVSDAX and PERJTOT
Join Information
Link between PXRRDED and PTRBDCA
Join Information
Link between PHR1042 and PHRHIST
Join Information
Link between PTRPICT and PHRHIST
Join Information
Link between PHRHIST and PHRJOBS
Join Information
Link between PHRDEDN and PTRBDGM
Join Information
Link between PHRDEDN and PTRBDCA
Join Information
Link between PHREARN and PHRJOBS
Join Information
Link between PHRHIST and PHRDOCM
Join Information
Link between PDRBDED and PTRBDGM
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 PDRBDED and PTRBDCG
Join Information
Link between PHREARN and PHRHIST
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 PEBEMPL and PERJLEV
Join Information
Link between PERJLEV and PHRHIST
Join Information
Link between PERJLEV and PHRJOBS
Join Information
Link between PTRBCDN and PTRBDCA
Join Information
Link between PXRFSTA and PTRBDCA
Join Information
Link between PDRDEDN and PTRBDPD
Join Information
Link between PTRBCDN and PDRDEDN
Join Information
Link between PTRBDGM and PTRBDCA
Join Information
Link between PTRBCDN and PTRBCAT
Link between PEREHIS and PTRBCAT
Link between PTRBDAS and PTRBDCA
Link between PTRBDCG and PTRBDCA
Link between PTRECBC and PTRBCAT
Link between PTRBDLD and PTRBDCA
Link between PXRADDS and PXRTXCD
Link between PXRFSTA and PXRTXCD
Link between PTRBDPD and PTRBDCA
Link between PTRBDPL and PTRBDCA
Link between PTRBDGM and PTRBDSG
Link between PTRBDSG and PTRBDPG
Link between PEREHIS and PTRECLS
Link between PTRECBC and PTRECLS
Link between PDRBFLX and PEBEMPL
Link between PDRFBAL and PEBEMPL
Link between PDRFCLM and PEBEMPL
Link between PHRHIST and PEBEMPL
Link between PEBEMPL and PTRBCAT
Link between PEBEMPL and PTRECLS
Link between PTRCBEN and PTRBDCA
Link between PTRBDPG and PTVBDPG
Link between PXRGRAD and PXRTXCD
Link between PTRBDCA and PTVBDTY
Link between PXREXEM and PTVBDTY
Link between PXREXEM and PXRTXCD
Link between PTRFBEN and PTRBDCA
Link between PHRJOBS and PTRECLS
Link between PDRBCOV and PDRBDED
Link between PERDTOT and PDRBDED
Link between PERPCRE and PDRBDED
Link between PHRDEDN and PDRBDED
Link between PDRBDED and PEBEMPL
Link between PDRBDED and PTRBDCA
Link between PXRCALC and PXRTXCD
Link between PHRJACR and PTRPICT
Link between PDRXPID and PDRBDED
Link between PDRXPID and PTRPICT
Link between PTRLIFE and PTRBDCA