Model View
Table NBBPOSN
Object Full Name
Source Code Comments
Columns Comments for NBBPOSN_POSN (# 1)
Source Code Comments
Columns Comments for NBBPOSN_STATUS (# 2)
Source Code Comments
Columns Comments for NBBPOSN_TITLE (# 3)
Source Code Comments
Columns Comments for NBBPOSN_PLOC_CODE (# 4)
Source Code Comments
Columns Comments for NBBPOSN_BEGIN_DATE (# 5)
Source Code Comments
Columns Comments for NBBPOSN_END_DATE (# 6)
Source Code Comments
Columns Comments for NBBPOSN_TYPE (# 7)
Source Code Comments
Columns Comments for NBBPOSN_PCLS_CODE (# 8)
Source Code Comments
Columns Comments for NBBPOSN_ECLS_CODE (# 9)
Source Code Comments
Columns Comments for NBBPOSN_POSN_REPORTS (# 10)
Source Code Comments
Columns Comments for NBBPOSN_AUTH_NUMBER (# 11)
Source Code Comments
Columns Comments for NBBPOSN_TABLE (# 12)
Source Code Comments
Columns Comments for NBBPOSN_GRADE (# 13)
Source Code Comments
Columns Comments for NBBPOSN_STEP (# 14)
Source Code Comments
Columns Comments for NBBPOSN_APPT_PCT (# 15)
Source Code Comments
Columns Comments for NBBPOSN_CIPC_CODE (# 16)
Source Code Comments
Columns Comments for NBBPOSN_ROLL_IND (# 17)
Source Code Comments
Columns Comments for NBBPOSN_COAS_CODE (# 18)
Source Code Comments
Columns Comments for NBBPOSN_ACTIVITY_DATE (# 19)
Source Code Comments
Columns Comments for NBBPOSN_SGRP_CODE (# 20)
Source Code Comments
Columns Comments for NBBPOSN_PGRP_CODE (# 21)
Source Code Comments
Columns Comments for NBBPOSN_WKSH_CODE (# 22)
Source Code Comments
Columns Comments for NBBPOSN_PREMIUM_ROLL_IND (# 23)
Source Code Comments
Columns Comments for NBBPOSN_PFOC_CODE (# 24)
Source Code Comments
Columns Comments for NBBPOSN_PNOC_CODE (# 25)
Source Code Comments
Columns Comments for NBBPOSN_DOTT_CODE (# 26)
Source Code Comments
Columns Comments for NBBPOSN_CHANGE_DATE_TIME (# 27)
Source Code Comments
Columns Comments for NBBPOSN_CALIF_TYPE (# 28)
Source Code Comments
Columns Comments for NBBPOSN_EXEMPT_IND (# 29)
Source Code Comments
Columns Comments for NBBPOSN_JBLN_CODE (# 30)
Source Code Comments
Columns Comments for NBBPOSN_BARG_CODE (# 31)
Source Code Comments
Columns Comments for NBBPOSN_PROBATION_UNITS (# 32)
Source Code Comments
Columns Comments for NBBPOSN_COMMENT (# 33)
Source Code Comments
Columns Comments for NBBPOSN_ACCRUE_SENIORITY_IND (# 34)
Source Code Comments
Columns Comments for NBBPOSN_JOBP_CODE (# 35)
Source Code Comments
Columns Comments for NBBPOSN_BPRO_CODE (# 36)
Source Code Comments
Columns Comments for NBBPOSN_BUDGET_TYPE (# 37)
Source Code Comments
Table NBRBJOB
Object Full Name
Source Code Comments
Columns Comments for NBRBJOB_PIDM (# 1)
Source Code Comments
Columns Comments for NBRBJOB_POSN (# 2)
Source Code Comments
Columns Comments for NBRBJOB_SUFF (# 3)
Source Code Comments
Columns Comments for NBRBJOB_BEGIN_DATE (# 4)
Source Code Comments
Columns Comments for NBRBJOB_END_DATE (# 5)
Source Code Comments
Columns Comments for NBRBJOB_DEFER_BAL (# 6)
Source Code Comments
Columns Comments for NBRBJOB_CONTRACT_TYPE (# 7)
Source Code Comments
Columns Comments for NBRBJOB_SALARY_ENCUMBRANCE (# 8)
Source Code Comments
Columns Comments for NBRBJOB_CONTRACT_BEGIN_DATE (# 9)
Source Code Comments
Columns Comments for NBRBJOB_CONTRACT_END_DATE (# 10)
Source Code Comments
Columns Comments for NBRBJOB_TOTAL_CONTRACT_HRS (# 11)
Source Code Comments
Columns Comments for NBRBJOB_TOTAL_ENCUMBRANCE_HRS (# 12)
Source Code Comments
Columns Comments for NBRBJOB_STEP_INCR_MON (# 13)
Source Code Comments
Columns Comments for NBRBJOB_STEP_INCR_DAY (# 14)
Source Code Comments
Columns Comments for NBRBJOB_COAS_CODE (# 15)
Source Code Comments
Columns Comments for NBRBJOB_ACTIVITY_DATE (# 16)
Source Code Comments
Columns Comments for NBRBJOB_ACCRUE_LEAVE_IND (# 17)
Source Code Comments
Columns Comments for NBRBJOB_CIVIL_SERVICE_IND (# 18)
Source Code Comments
Columns Comments for NBRBJOB_ENCUMBRANCE_CHANGE_IND (# 19)
Source Code Comments
Columns Comments for NBRBJOB_FRINGE_ENCUMBRANCE (# 20)
Source Code Comments
Columns Comments for NBRBJOB_IPEDS_REPT_IND (# 21)
Source Code Comments
Columns Comments for NBRBJOB_FACL_STATSCAN_REPT_IND (# 22)
Source Code Comments
Columns Comments for NBRBJOB_PROBATION_BEGIN_DATE (# 23)
Source Code Comments
Columns Comments for NBRBJOB_PROBATION_END_DATE (# 24)
Source Code Comments
Columns Comments for NBRBJOB_PROBATION_UNITS (# 25)
Source Code Comments
Columns Comments for NBRBJOB_ELIGIBLE_DATE (# 26)
Source Code Comments
Columns Comments for NBRBJOB_USER_ID (# 27)
Source Code Comments
Columns Comments for NBRBJOB_DATA_ORIGIN (# 28)
Source Code Comments
Columns Comments for NBRBJOB_FUTURE_SALARY_ENC (# 29)
Source Code Comments
Columns Comments for NBRBJOB_FUTURE_FRINGE_ENC (# 30)
Source Code Comments
Table NBRJOBS
Object Full Name
Source Code Comments
Columns Comments for NBRJOBS_PIDM (# 1)
Source Code Comments
Columns Comments for NBRJOBS_POSN (# 2)
Source Code Comments
Columns Comments for NBRJOBS_SUFF (# 3)
Source Code Comments
Columns Comments for NBRJOBS_EFFECTIVE_DATE (# 4)
Source Code Comments
Columns Comments for NBRJOBS_STATUS (# 5)
Source Code Comments
Columns Comments for NBRJOBS_DESC (# 6)
Source Code Comments
Columns Comments for NBRJOBS_ECLS_CODE (# 7)
Source Code Comments
Columns Comments for NBRJOBS_PICT_CODE (# 8)
Source Code Comments
Columns Comments for NBRJOBS_COAS_CODE_TS (# 9)
Source Code Comments
Columns Comments for NBRJOBS_ORGN_CODE_TS (# 10)
Source Code Comments
Columns Comments for NBRJOBS_SAL_TABLE (# 11)
Source Code Comments
Columns Comments for NBRJOBS_SAL_GRADE (# 12)
Source Code Comments
Columns Comments for NBRJOBS_SAL_STEP (# 13)
Source Code Comments
Columns Comments for NBRJOBS_APPT_PCT (# 14)
Source Code Comments
Columns Comments for NBRJOBS_FTE (# 15)
Source Code Comments
Columns Comments for NBRJOBS_HRS_DAY (# 16)
Source Code Comments
Columns Comments for NBRJOBS_HRS_PAY (# 17)
Source Code Comments
Columns Comments for NBRJOBS_SHIFT (# 18)
Source Code Comments
Columns Comments for NBRJOBS_REG_RATE (# 19)
Source Code Comments
Columns Comments for NBRJOBS_ASSGN_SALARY (# 20)
Source Code Comments
Columns Comments for NBRJOBS_FACTOR (# 21)
Source Code Comments
Columns Comments for NBRJOBS_ANN_SALARY (# 22)
Source Code Comments
Columns Comments for NBRJOBS_PER_PAY_SALARY (# 23)
Source Code Comments
Columns Comments for NBRJOBS_PAYS (# 24)
Source Code Comments
Columns Comments for NBRJOBS_PER_PAY_DEFER_AMT (# 25)
Source Code Comments
Columns Comments for NBRJOBS_ACTIVITY_DATE (# 26)
Source Code Comments
Columns Comments for NBRJOBS_JCRE_CODE (# 27)
Source Code Comments
Columns Comments for NBRJOBS_SGRP_CODE (# 28)
Source Code Comments
Columns Comments for NBRJOBS_EMPR_CODE (# 29)
Source Code Comments
Columns Comments for NBRJOBS_LGCD_CODE (# 30)
Source Code Comments
Columns Comments for NBRJOBS_LOCN_CODE (# 31)
Source Code Comments
Columns Comments for NBRJOBS_SCHL_CODE (# 32)
Source Code Comments
Columns Comments for NBRJOBS_SUPERVISOR_PIDM (# 33)
Source Code Comments
Columns Comments for NBRJOBS_SUPERVISOR_POSN (# 34)
Source Code Comments
Columns Comments for NBRJOBS_SUPERVISOR_SUFF (# 35)
Source Code Comments
Columns Comments for NBRJOBS_WKCP_CODE (# 36)
Source Code Comments
Columns Comments for NBRJOBS_JBLN_CODE (# 37)
Source Code Comments
Columns Comments for NBRJOBS_PERS_CHG_DATE (# 38)
Source Code Comments
Columns Comments for NBRJOBS_PCAT_CODE (# 39)
Source Code Comments
Columns Comments for NBRJOBS_DFPR_CODE (# 40)
Source Code Comments
Columns Comments for NBRJOBS_ENCUMBRANCE_HRS (# 41)
Source Code Comments
Columns Comments for NBRJOBS_CONTRACT_NO (# 42)
Source Code Comments
Columns Comments for NBRJOBS_STRS_ASSN_CODE (# 43)
Source Code Comments
Columns Comments for NBRJOBS_STRS_PAY_CODE (# 44)
Source Code Comments
Columns Comments for NBRJOBS_PERS_PAY_CODE (# 45)
Source Code Comments
Columns Comments for NBRJOBS_TIME_ENTRY_METHOD (# 46)
Source Code Comments
Columns Comments for NBRJOBS_TIME_ENTRY_TYPE (# 47)
Source Code Comments
Columns Comments for NBRJOBS_TIME_IN_OUT_IND (# 48)
Source Code Comments
Columns Comments for NBRJOBS_LCAT_CODE (# 49)
Source Code Comments
Columns Comments for NBRJOBS_LEAV_REPT_METHOD (# 50)
Source Code Comments
Columns Comments for NBRJOBS_PICT_CODE_LEAV_REPT (# 51)
Source Code Comments
Columns Comments for NBRJOBS_USER_ID (# 52)
Source Code Comments
Columns Comments for NBRJOBS_DATA_ORIGIN (# 53)
Source Code Comments
Table PABAPPL
Object Full Name
Source Code Comments
Columns Comments for PABAPPL_PIDM (# 1)
Source Code Comments
Columns Comments for PABAPPL_DATE (# 2)
Source Code Comments
Columns Comments for PABAPPL_FULL_PART_IND (# 3)
Source Code Comments
Columns Comments for PABAPPL_ESKL_CODE (# 4)
Source Code Comments
Columns Comments for PABAPPL_ASRC_CODE (# 5)
Source Code Comments
Columns Comments for PABAPPL_DESIRED_SALARY (# 6)
Source Code Comments
Columns Comments for PABAPPL_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for PABAPPL_REQ_NO (# 8)
Source Code Comments
Columns Comments for PABAPPL_POSN (# 9)
Source Code Comments
Columns Comments for PABAPPL_PCLS_CODE (# 10)
Source Code Comments
Columns Comments for PABAPPL_DESIRED_HOURLY (# 11)
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 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 PEBEMPL
Object Full Name
Source Code Comments
Columns Comments for PEBEMPL_PIDM (# 1)
Source Code Comments
Columns Comments for PEBEMPL_EMPL_STATUS (# 2)
Source Code Comments
Columns Comments for PEBEMPL_COAS_CODE_HOME (# 3)
Source Code Comments
Columns Comments for PEBEMPL_ORGN_CODE_HOME (# 4)
Source Code Comments
Columns Comments for PEBEMPL_COAS_CODE_DIST (# 5)
Source Code Comments
Columns Comments for PEBEMPL_ORGN_CODE_DIST (# 6)
Source Code Comments
Columns Comments for PEBEMPL_ECLS_CODE (# 7)
Source Code Comments
Columns Comments for PEBEMPL_LCAT_CODE (# 8)
Source Code Comments
Columns Comments for PEBEMPL_BCAT_CODE (# 9)
Source Code Comments
Columns Comments for PEBEMPL_FIRST_HIRE_DATE (# 10)
Source Code Comments
Columns Comments for PEBEMPL_CURRENT_HIRE_DATE (# 11)
Source Code Comments
Columns Comments for PEBEMPL_ADJ_SERVICE_DATE (# 12)
Source Code Comments
Columns Comments for PEBEMPL_SENIORITY_DATE (# 13)
Source Code Comments
Columns Comments for PEBEMPL_LREA_CODE (# 14)
Source Code Comments
Columns Comments for PEBEMPL_LOA_BEG_DATE (# 15)
Source Code Comments
Columns Comments for PEBEMPL_LOA_END_DATE (# 16)
Source Code Comments
Columns Comments for PEBEMPL_TREA_CODE (# 17)
Source Code Comments
Columns Comments for PEBEMPL_TERM_DATE (# 18)
Source Code Comments
Columns Comments for PEBEMPL_I9_FORM_IND (# 19)
Source Code Comments
Columns Comments for PEBEMPL_I9_DATE (# 20)
Source Code Comments
Columns Comments for PEBEMPL_I9_EXPIRE_DATE (# 21)
Source Code Comments
Columns Comments for PEBEMPL_ACTIVITY_DATE (# 22)
Source Code Comments
Columns Comments for PEBEMPL_WKPR_CODE (# 23)
Source Code Comments
Columns Comments for PEBEMPL_FLSA_IND (# 24)
Source Code Comments
Columns Comments for PEBEMPL_STGR_CODE (# 25)
Source Code Comments
Columns Comments for PEBEMPL_DAYS_IN_CANADA (# 26)
Source Code Comments
Columns Comments for PEBEMPL_1042_RECIPIENT_CD (# 27)
Source Code Comments
Columns Comments for PEBEMPL_INTERNAL_FT_PT_IND (# 28)
Source Code Comments
Columns Comments for PEBEMPL_DICD_CODE (# 29)
Source Code Comments
Columns Comments for PEBEMPL_EGRP_CODE (# 30)
Source Code Comments
Columns Comments for PEBEMPL_IPEDS_SOFT_MONEY_IND (# 31)
Source Code Comments
Columns Comments for PEBEMPL_FIRST_WORK_DATE (# 32)
Source Code Comments
Columns Comments for PEBEMPL_LAST_WORK_DATE (# 33)
Source Code Comments
Columns Comments for PEBEMPL_CALIF_PENSION_IND (# 34)
Source Code Comments
Columns Comments for PEBEMPL_NRSI_CODE (# 35)
Source Code Comments
Columns Comments for PEBEMPL_SSN_LAST_NAME (# 36)
Source Code Comments
Columns Comments for PEBEMPL_SSN_FIRST_NAME (# 37)
Source Code Comments
Columns Comments for PEBEMPL_SSN_MI (# 38)
Source Code Comments
Columns Comments for PEBEMPL_SSN_SUFFIX (# 39)
Source Code Comments
Columns Comments for PEBEMPL_JBLN_CODE (# 40)
Source Code Comments
Columns Comments for PEBEMPL_COLL_CODE (# 41)
Source Code Comments
Columns Comments for PEBEMPL_CAMP_CODE (# 42)
Source Code Comments
Columns Comments for PEBEMPL_USER_ID (# 43)
Source Code Comments
Columns Comments for PEBEMPL_DATA_ORIGIN (# 44)
Source Code Comments
Columns Comments for PEBEMPL_EW2_CONSENT_IND (# 45)
Source Code Comments
Columns Comments for PEBEMPL_EW2_CONSENT_DATE (# 46)
Source Code Comments
Columns Comments for PEBEMPL_EW2_CONSENT_USER_ID (# 47)
Source Code Comments
Columns Comments for PEBEMPL_IPEDS_PRIMARY_FUNCTION (# 48)
Source Code Comments
Columns Comments for PEBEMPL_IPEDS_MED_DENTAL_IND (# 49)
Source Code Comments
Columns Comments for PEBEMPL_ETAX_CONSENT_IND (# 50)
Source Code Comments
Columns Comments for PEBEMPL_ETAX_CONSENT_DATE (# 51)
Source Code Comments
Columns Comments for PEBEMPL_ETAX_CONSENT_USER_ID (# 52)
Source Code Comments
Table PEBROEC
Object Full Name
Source Code Comments
Columns Comments for PEBROEC_PIDM (# 1)
Source Code Comments
Columns Comments for PEBROEC_PICT_CODE (# 2)
Source Code Comments
Columns Comments for PEBROEC_ISSUE_DATE (# 3)
Source Code Comments
Columns Comments for PEBROEC_PRINT_IND (# 4)
Source Code Comments
Columns Comments for PEBROEC_SERIAL_NO_AMEND (# 5)
Source Code Comments
Columns Comments for PEBROEC_REFERENCE_NO (# 6)
Source Code Comments
Columns Comments for PEBROEC_LANGUAGE_IND (# 7)
Source Code Comments
Columns Comments for PEBROEC_OCCUPATION (# 8)
Source Code Comments
Columns Comments for PEBROEC_FIRST_DAY_WORKED (# 9)
Source Code Comments
Columns Comments for PEBROEC_LAST_DAY_WORKED (# 10)
Source Code Comments
Columns Comments for PEBROEC_UI_PREMIUM_DATE (# 11)
Source Code Comments
Columns Comments for PEBROEC_FINAL_PAY_END_DATE (# 12)
Source Code Comments
Columns Comments for PEBROEC_VACATION_PAY (# 13)
Source Code Comments
Columns Comments for PEBROEC_FINAL_PAY_IND (# 14)
Source Code Comments
Columns Comments for PEBROEC_LEAVE_START (# 15)
Source Code Comments
Columns Comments for PEBROEC_LEAVE_DURATION (# 16)
Source Code Comments
Columns Comments for PEBROEC_LEAVE_DURATION_IND (# 17)
Source Code Comments
Columns Comments for PEBROEC_LEAVE_AMOUNT (# 18)
Source Code Comments
Columns Comments for PEBROEC_ROER_CODE (# 19)
Source Code Comments
Columns Comments for PEBROEC_CONTACT_PIDM (# 20)
Source Code Comments
Columns Comments for PEBROEC_CONTACT_PH_AREA (# 21)
Source Code Comments
Columns Comments for PEBROEC_CONTACT_PH_NUMBER (# 22)
Source Code Comments
Columns Comments for PEBROEC_CONTACT_PH_EXT (# 23)
Source Code Comments
Columns Comments for PEBROEC_RETURN_DATE (# 24)
Source Code Comments
Columns Comments for PEBROEC_RETURN_IND (# 25)
Source Code Comments
Columns Comments for PEBROEC_ISSUER_PIDM (# 26)
Source Code Comments
Columns Comments for PEBROEC_ISSUER_PH_AREA (# 27)
Source Code Comments
Columns Comments for PEBROEC_ISSUER_PH_NUMBER (# 28)
Source Code Comments
Columns Comments for PEBROEC_ISSUER_PH_EXT (# 29)
Source Code Comments
Columns Comments for PEBROEC_ACTIVITY_DATE (# 30)
Source Code Comments
Columns Comments for PEBROEC_EMPR_CODE (# 31)
Source Code Comments
Table PERBARG
Object Full Name
Source Code Comments
Columns Comments for PERBARG_PIDM (# 1)
Source Code Comments
Columns Comments for PERBARG_BARG_CODE (# 2)
Source Code Comments
Columns Comments for PERBARG_BURE_CODE (# 3)
Source Code Comments
Columns Comments for PERBARG_BARG_SENIORITY_DATE (# 4)
Source Code Comments
Columns Comments for PERBARG_EFFECTIVE_DATE (# 5)
Source Code Comments
Columns Comments for PERBARG_END_DATE (# 6)
Source Code Comments
Columns Comments for PERBARG_ACTIVITY_DATE (# 7)
Source Code Comments
Table PERBFML
Object Full Name
Source Code Comments
Columns Comments for PERBFML_PIDM (# 1)
Source Code Comments
Columns Comments for PERBFML_YEAR_IND (# 2)
Source Code Comments
Columns Comments for PERBFML_YEAR (# 3)
Source Code Comments
Columns Comments for PERBFML_YEAR_BEGIN (# 4)
Source Code Comments
Columns Comments for PERBFML_YEAR_END (# 5)
Source Code Comments
Columns Comments for PERBFML_UNIT_IND (# 6)
Source Code Comments
Columns Comments for PERBFML_MAX_UNITS (# 7)
Source Code Comments
Columns Comments for PERBFML_SPOUSE_IND (# 8)
Source Code Comments
Columns Comments for PERBFML_SPOUSE_PIDM (# 9)
Source Code Comments
Columns Comments for PERBFML_ACTIVITY_DATE (# 10)
Source Code Comments
Table PERCAPL
Object Full Name
Source Code Comments
Columns Comments for PERCAPL_PIDM (# 1)
Source Code Comments
Columns Comments for PERCAPL_ACTION (# 2)
Source Code Comments
Columns Comments for PERCAPL_ACTION_DATE (# 3)
Source Code Comments
Columns Comments for PERCAPL_ORGN (# 4)
Source Code Comments
Columns Comments for PERCAPL_COAS_CODE (# 5)
Source Code Comments
Columns Comments for PERCAPL_POSN (# 6)
Source Code Comments
Columns Comments for PERCAPL_SUFF (# 7)
Source Code Comments
Columns Comments for PERCAPL_ALVL_CODE (# 8)
Source Code Comments
Columns Comments for PERCAPL_USER_ID (# 9)
Source Code Comments
Columns Comments for PERCAPL_FACC_CODE (# 10)
Source Code Comments
Columns Comments for PERCAPL_ACTIVITY_DATE (# 11)
Source Code Comments
Table PERCAPR
Object Full Name
Source Code Comments
Columns Comments for PERCAPR_PIDM (# 1)
Source Code Comments
Columns Comments for PERCAPR_ACTION (# 2)
Source Code Comments
Columns Comments for PERCAPR_ACTION_DATE (# 3)
Source Code Comments
Columns Comments for PERCAPR_ORGN (# 4)
Source Code Comments
Columns Comments for PERCAPR_COAS_CODE (# 5)
Source Code Comments
Columns Comments for PERCAPR_POSN (# 6)
Source Code Comments
Columns Comments for PERCAPR_SUFF (# 7)
Source Code Comments
Columns Comments for PERCAPR_ALVL_CODE (# 8)
Source Code Comments
Columns Comments for PERCAPR_USER_ID (# 9)
Source Code Comments
Columns Comments for PERCAPR_FACC_CODE (# 10)
Source Code Comments
Columns Comments for PERCAPR_ACTIVITY_DATE (# 11)
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 PERDIRD
Object Full Name
Source Code Comments
Columns Comments for PERDIRD_PIDM (# 1)
Source Code Comments
Columns Comments for PERDIRD_BANK_CODE (# 2)
Source Code Comments
Columns Comments for PERDIRD_BANK_ACCT_NO (# 3)
Source Code Comments
Columns Comments for PERDIRD_PRIORITY (# 4)
Source Code Comments
Columns Comments for PERDIRD_AMOUNT (# 5)
Source Code Comments
Columns Comments for PERDIRD_PERCENT (# 6)
Source Code Comments
Columns Comments for PERDIRD_ACCT_TYPE (# 7)
Source Code Comments
Columns Comments for PERDIRD_STATUS (# 8)
Source Code Comments
Columns Comments for PERDIRD_DOC_TYPE (# 9)
Source Code Comments
Columns Comments for PERDIRD_ACTIVITY_DATE (# 10)
Source Code Comments
Table PEREEOT
Object Full Name
Source Code Comments
Columns Comments for PEREEOT_LINENO (# 1)
Source Code Comments
Columns Comments for PEREEOT_TITLE (# 2)
Source Code Comments
Columns Comments for PEREEOT_LINE_TOTAL_CNT (# 3)
Source Code Comments
Columns Comments for PEREEOT_LINE_MALE_CNT (# 4)
Source Code Comments
Columns Comments for PEREEOT_LINE_M1_CNT (# 5)
Source Code Comments
Columns Comments for PEREEOT_LINE_M2_CNT (# 6)
Source Code Comments
Columns Comments for PEREEOT_LINE_M3_CNT (# 7)
Source Code Comments
Columns Comments for PEREEOT_LINE_M4_CNT (# 8)
Source Code Comments
Columns Comments for PEREEOT_LINE_M5_CNT (# 9)
Source Code Comments
Columns Comments for PEREEOT_LINE_FEMALE_CNT (# 10)
Source Code Comments
Columns Comments for PEREEOT_LINE_F1_CNT (# 11)
Source Code Comments
Columns Comments for PEREEOT_LINE_F2_CNT (# 12)
Source Code Comments
Columns Comments for PEREEOT_LINE_F3_CNT (# 13)
Source Code Comments
Columns Comments for PEREEOT_LINE_F4_CNT (# 14)
Source Code Comments
Columns Comments for PEREEOT_LINE_F5_CNT (# 15)
Source Code Comments
Columns Comments for PEREEOT_ACTIVITY_DATE (# 16)
Source Code Comments
Columns Comments for PEREEOT_EFUN_CODE (# 17)
Source Code Comments
Columns Comments for PEREEOT_YEAR (# 18)
Source Code Comments
Columns Comments for PEREEOT_TYPE_OF_REPORT_IND (# 19)
Source Code Comments
Columns Comments for PEREEOT_SCHL_CODE (# 20)
Source Code Comments
Columns Comments for PEREEOT_LOCN_CODE (# 21)
Source Code Comments
Columns Comments for PEREEOT_EMPR_CODE (# 22)
Source Code Comments
Columns Comments for PEREEOT_LINE_M6_CNT (# 23)
Source Code Comments
Columns Comments for PEREEOT_LINE_F6_CNT (# 24)
Source Code Comments
Columns Comments for PEREEOT_LINE_M0_CNT (# 25)
Source Code Comments
Columns Comments for PEREEOT_LINE_F0_CNT (# 26)
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 PERFACC
Object Full Name
Source Code Comments
Columns Comments for PERFACC_PIDM (# 1)
Source Code Comments
Columns Comments for PERFACC_ACTION (# 2)
Source Code Comments
Columns Comments for PERFACC_ACTION_DATE (# 3)
Source Code Comments
Columns Comments for PERFACC_ORGN (# 4)
Source Code Comments
Columns Comments for PERFACC_COAS_CODE (# 5)
Source Code Comments
Columns Comments for PERFACC_POSN (# 6)
Source Code Comments
Columns Comments for PERFACC_SUFF (# 7)
Source Code Comments
Columns Comments for PERFACC_FACC_CODE (# 8)
Source Code Comments
Columns Comments for PERFACC_ACTIVITY_DATE (# 9)
Source Code Comments
Table PERFACL
Object Full Name
Source Code Comments
Columns Comments for PERFACL_PIDM (# 1)
Source Code Comments
Columns Comments for PERFACL_POSN (# 2)
Source Code Comments
Columns Comments for PERFACL_SUFF (# 3)
Source Code Comments
Columns Comments for PERFACL_EFFECTIVE_DATE (# 4)
Source Code Comments
Columns Comments for PERFACL_FTE (# 5)
Source Code Comments
Columns Comments for PERFACL_CONTACT_HOURS (# 6)
Source Code Comments
Columns Comments for PERFACL_ACTIVITY_DATE (# 7)
Source Code Comments
Table PERFAPL
Object Full Name
Source Code Comments
Columns Comments for PERFAPL_PIDM (# 1)
Source Code Comments
Columns Comments for PERFAPL_ACTION (# 2)
Source Code Comments
Columns Comments for PERFAPL_ACTION_DATE (# 3)
Source Code Comments
Columns Comments for PERFAPL_ORGN (# 4)
Source Code Comments
Columns Comments for PERFAPL_COAS_CODE (# 5)
Source Code Comments
Columns Comments for PERFAPL_POSN (# 6)
Source Code Comments
Columns Comments for PERFAPL_SUFF (# 7)
Source Code Comments
Columns Comments for PERFAPL_ALVL_CODE (# 8)
Source Code Comments
Columns Comments for PERFAPL_USER_ID (# 9)
Source Code Comments
Columns Comments for PERFAPL_LAST_LEVEL_IND (# 10)
Source Code Comments
Columns Comments for PERFAPL_APPR_DECISION (# 11)
Source Code Comments
Columns Comments for PERFAPL_APPR_DATE (# 12)
Source Code Comments
Columns Comments for PERFAPL_DEFERRAL_DATE (# 13)
Source Code Comments
Columns Comments for PERFAPL_COMMENT (# 14)
Source Code Comments
Columns Comments for PERFAPL_ACTIVITY_DATE (# 15)
Source Code Comments
Table PERFAPR
Object Full Name
Source Code Comments
Columns Comments for PERFAPR_PIDM (# 1)
Source Code Comments
Columns Comments for PERFAPR_ACTION (# 2)
Source Code Comments
Columns Comments for PERFAPR_ACTION_DATE (# 3)
Source Code Comments
Columns Comments for PERFAPR_ORGN (# 4)
Source Code Comments
Columns Comments for PERFAPR_COAS_CODE (# 5)
Source Code Comments
Columns Comments for PERFAPR_POSN (# 6)
Source Code Comments
Columns Comments for PERFAPR_SUFF (# 7)
Source Code Comments
Columns Comments for PERFAPR_ALVL_CODE (# 8)
Source Code Comments
Columns Comments for PERFAPR_USER_ID (# 9)
Source Code Comments
Columns Comments for PERFAPR_LAST_LEVEL_IND (# 10)
Source Code Comments
Columns Comments for PERFAPR_APPR_DECISION (# 11)
Source Code Comments
Columns Comments for PERFAPR_APPR_DATE (# 12)
Source Code Comments
Columns Comments for PERFAPR_DEFERRAL_DATE (# 13)
Source Code Comments
Columns Comments for PERFAPR_COMMENT (# 14)
Source Code Comments
Columns Comments for PERFAPR_ACTIVITY_DATE (# 15)
Source Code Comments
Table PERFASG
Object Full Name
Source Code Comments
Columns Comments for PERFASG_TERM_CODE (# 1)
Source Code Comments
Columns Comments for PERFASG_PIDM (# 2)
Source Code Comments
Columns Comments for PERFASG_CRN (# 3)
Source Code Comments
Columns Comments for PERFASG_CATEGORY (# 4)
Source Code Comments
Columns Comments for PERFASG_CAMP_CODE (# 5)
Source Code Comments
Columns Comments for PERFASG_COLL_CODE (# 6)
Source Code Comments
Columns Comments for PERFASG_FCNT_CODE (# 7)
Source Code Comments
Columns Comments for PERFASG_POSN (# 8)
Source Code Comments
Columns Comments for PERFASG_SUFF (# 9)
Source Code Comments
Columns Comments for PERFASG_JOB_EFFECTIVE_DATE (# 10)
Source Code Comments
Columns Comments for PERFASG_PERCENT_RESPONSE (# 11)
Source Code Comments
Columns Comments for PERFASG_PERCENT_SESS (# 12)
Source Code Comments
Columns Comments for PERFASG_TOTAL_CREDIT_HR_SESS (# 13)
Source Code Comments
Columns Comments for PERFASG_TOTAL_HRS_WEEK (# 14)
Source Code Comments
Columns Comments for PERFASG_WORKLOAD (# 15)
Source Code Comments
Columns Comments for PERFASG_ENRL (# 16)
Source Code Comments
Columns Comments for PERFASG_ACTIVITY_DATE (# 17)
Source Code Comments
Columns Comments for PERFASG_USER_ID (# 18)
Source Code Comments
Columns Comments for PERFASG_DATA_ORIGIN (# 19)
Source Code Comments
Columns Comments for PERFASG_PTRM_CODE (# 20)
Source Code Comments
Columns Comments for PERFASG_REVISED_CREDIT_HRS (# 21)
Source Code Comments
Columns Comments for PERFASG_REVISED_HRS_WEEK (# 22)
Source Code Comments
Columns Comments for PERFASG_REVISED_WORKLOAD (# 23)
Source Code Comments
Columns Comments for PERFASG_REVISED_ENRL (# 24)
Source Code Comments
Columns Comments for PERFASG_WORKLOAD_INCR (# 25)
Source Code Comments
Table PERFCNT
Object Full Name
Source Code Comments
Columns Comments for PERFCNT_TERM_CODE (# 1)
Source Code Comments
Columns Comments for PERFCNT_PIDM (# 2)
Source Code Comments
Columns Comments for PERFCNT_FCNT_CODE (# 3)
Source Code Comments
Columns Comments for PERFCNT_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for PERFCNT_USER_ID (# 5)
Source Code Comments
Columns Comments for PERFCNT_DATA_ORIGIN (# 6)
Source Code Comments
Table PERGRPA
Object Full Name
Source Code Comments
Columns Comments for PERGRPA_GREV_NO (# 1)
Source Code Comments
Columns Comments for PERGRPA_PIDM (# 2)
Source Code Comments
Columns Comments for PERGRPA_GRPT_CODE (# 3)
Source Code Comments
Columns Comments for PERGRPA_POSN (# 4)
Source Code Comments
Columns Comments for PERGRPA_SUFF (# 5)
Source Code Comments
Columns Comments for PERGRPA_GRIEVANT_IND (# 6)
Source Code Comments
Columns Comments for PERGRPA_ACTIVITY_DATE (# 7)
Source Code Comments
Table PERGRRA
Object Full Name
Source Code Comments
Columns Comments for PERGRRA_GREV_NO (# 1)
Source Code Comments
Columns Comments for PERGRRA_GRSR_CODE (# 2)
Source Code Comments
Columns Comments for PERGRRA_GRSR_DATE (# 3)
Source Code Comments
Columns Comments for PERGRRA_ACTIVITY_DATE (# 4)
Source Code Comments
Table PERJBBG
Object Full Name
Source Code Comments
Columns Comments for PERJBBG_PIDM (# 1)
Source Code Comments
Columns Comments for PERJBBG_BARG_CODE (# 2)
Source Code Comments
Columns Comments for PERJBBG_POSN (# 3)
Source Code Comments
Columns Comments for PERJBBG_SUFF (# 4)
Source Code Comments
Columns Comments for PERJBBG_JOB_SENIORITY_DATE (# 5)
Source Code Comments
Columns Comments for PERJBBG_BARG_EFFECTIVE_DATE (# 6)
Source Code Comments
Columns Comments for PERJBBG_ACTIVITY_DATE (# 7)
Source Code Comments
Table PERJFAC
Object Full Name
Source Code Comments
Columns Comments for PERJFAC_POSN (# 1)
Source Code Comments
Columns Comments for PERJFAC_DATE (# 2)
Source Code Comments
Columns Comments for PERJFAC_CFAC_CODE (# 3)
Source Code Comments
Columns Comments for PERJFAC_CFAC_POINT (# 4)
Source Code Comments
Columns Comments for PERJFAC_ACTIVITY_DATE (# 5)
Source Code Comments
Table PERJHIS
Object Full Name
Source Code Comments
Columns Comments for PERJHIS_PIDM (# 1)
Source Code Comments
Columns Comments for PERJHIS_POSN (# 2)
Source Code Comments
Columns Comments for PERJHIS_SUFF (# 3)
Source Code Comments
Columns Comments for PERJHIS_EFFECTIVE_DATE (# 4)
Source Code Comments
Columns Comments for PERJHIS_STATUS (# 5)
Source Code Comments
Columns Comments for PERJHIS_ECLS_CODE (# 6)
Source Code Comments
Columns Comments for PERJHIS_BEGIN_DATE (# 7)
Source Code Comments
Columns Comments for PERJHIS_END_DATE (# 8)
Source Code Comments
Columns Comments for PERJHIS_PAYID (# 9)
Source Code Comments
Columns Comments for PERJHIS_SAL_TABLE (# 10)
Source Code Comments
Columns Comments for PERJHIS_SAL_GRADE (# 11)
Source Code Comments
Columns Comments for PERJHIS_SAL_STEP (# 12)
Source Code Comments
Columns Comments for PERJHIS_HRS_DAY (# 13)
Source Code Comments
Columns Comments for PERJHIS_REG_RATE (# 14)
Source Code Comments
Columns Comments for PERJHIS_ASSGN_SALARY (# 15)
Source Code Comments
Columns Comments for PERJHIS_ANN_SALARY (# 16)
Source Code Comments
Columns Comments for PERJHIS_USER_ID (# 17)
Source Code Comments
Columns Comments for PERJHIS_ACTIVITY_DATE (# 18)
Source Code Comments
Columns Comments for PERJHIS_JCRE_CODE (# 19)
Source Code Comments
Columns Comments for PERJHIS_EMPR_CODE (# 20)
Source Code Comments
Columns Comments for PERJHIS_LOCN_CODE (# 21)
Source Code Comments
Columns Comments for PERJHIS_SCHL_CODE (# 22)
Source Code Comments
Columns Comments for PERJHIS_SUPERVISOR_PIDM (# 23)
Source Code Comments
Columns Comments for PERJHIS_SUPERVISOR_POSN (# 24)
Source Code Comments
Columns Comments for PERJHIS_SUPERVISOR_SUFF (# 25)
Source Code Comments
Columns Comments for PERJHIS_WKCP_CODE (# 26)
Source Code Comments
Columns Comments for PERJHIS_JBLN_CODE (# 27)
Source Code Comments
Columns Comments for PERJHIS_PERS_CHG_DATE (# 28)
Source Code Comments
Columns Comments for PERJHIS_DEFER_BAL (# 29)
Source Code Comments
Columns Comments for PERJHIS_CONTRACT_TYPE (# 30)
Source Code Comments
Columns Comments for PERJHIS_SALARY_ENCUMBRANCE (# 31)
Source Code Comments
Columns Comments for PERJHIS_CONTRACT_BEGIN_DATE (# 32)
Source Code Comments
Columns Comments for PERJHIS_CONTRACT_END_DATE (# 33)
Source Code Comments
Columns Comments for PERJHIS_STEP_INCR_MON (# 34)
Source Code Comments
Columns Comments for PERJHIS_STEP_INCR_DAY (# 35)
Source Code Comments
Columns Comments for PERJHIS_COAS_CODE (# 36)
Source Code Comments
Columns Comments for PERJHIS_ACCRUE_LEAVE_IND (# 37)
Source Code Comments
Columns Comments for PERJHIS_CIVIL_SERVICE_IND (# 38)
Source Code Comments
Columns Comments for PERJHIS_FRINGE_ENCUMBRANCE (# 39)
Source Code Comments
Columns Comments for PERJHIS_DESC (# 40)
Source Code Comments
Columns Comments for PERJHIS_COAS_CODE_TS (# 41)
Source Code Comments
Columns Comments for PERJHIS_ORGN_CODE_TS (# 42)
Source Code Comments
Columns Comments for PERJHIS_APPT_PCT (# 43)
Source Code Comments
Columns Comments for PERJHIS_FTE (# 44)
Source Code Comments
Columns Comments for PERJHIS_HRS_PAY (# 45)
Source Code Comments
Columns Comments for PERJHIS_SHIFT (# 46)
Source Code Comments
Columns Comments for PERJHIS_FACTOR (# 47)
Source Code Comments
Columns Comments for PERJHIS_PER_PAY_SALARY (# 48)
Source Code Comments
Columns Comments for PERJHIS_PAYS (# 49)
Source Code Comments
Columns Comments for PERJHIS_PER_PAY_DEFER_AMT (# 50)
Source Code Comments
Columns Comments for PERJHIS_SGRP_CODE (# 51)
Source Code Comments
Columns Comments for PERJHIS_LGCD_CODE (# 52)
Source Code Comments
Columns Comments for PERJHIS_PCAT_CODE (# 53)
Source Code Comments
Columns Comments for PERJHIS_DFPR_CODE (# 54)
Source Code Comments
Columns Comments for PERJHIS_ENCUMBRANCE_HRS (# 55)
Source Code Comments
Columns Comments for PERJHIS_CAPTURE_DATE (# 56)
Source Code Comments
Columns Comments for PERJHIS_TOTAL_ENCUMBRANCE_HRS (# 57)
Source Code Comments
Columns Comments for PERJHIS_TOTAL_CONTRACT_HRS (# 58)
Source Code Comments
Columns Comments for PERJHIS_TIME_ENTRY_METHOD (# 59)
Source Code Comments
Columns Comments for PERJHIS_TIME_ENTRY_TYPE (# 60)
Source Code Comments
Columns Comments for PERJHIS_TIME_IN_OUT_IND (# 61)
Source Code Comments
Columns Comments for PERJHIS_PROBATION_BEGIN_DATE (# 62)
Source Code Comments
Columns Comments for PERJHIS_PROBATION_END_DATE (# 63)
Source Code Comments
Columns Comments for PERJHIS_PROBATION_UNITS (# 64)
Source Code Comments
Columns Comments for PERJHIS_LCAT_CODE (# 65)
Source Code Comments
Columns Comments for PERJHIS_LEAV_REPT_METHOD (# 66)
Source Code Comments
Columns Comments for PERJHIS_ELIGIBLE_DATE (# 67)
Source Code Comments
Columns Comments for PERJHIS_COMMENT_DATE (# 68)
Source Code Comments
Columns Comments for PERJHIS_COMMENT_USER_ID (# 69)
Source Code Comments
Columns Comments for PERJHIS_COMMENT (# 70)
Source Code Comments
Columns Comments for PERJHIS_PICT_CODE_LEAV_REPT (# 71)
Source Code Comments
Columns Comments for PERJHIS_DATA_ORIGIN (# 72)
Source Code Comments
Columns Comments for PERJHIS_FUTURE_SALARY_ENC (# 73)
Source Code Comments
Columns Comments for PERJHIS_FUTURE_FRINGE_ENC (# 74)
Source Code Comments
Table PERJLEV
Object Full Name
Source Code Comments
Columns Comments for PERJLEV_PIDM (# 1)
Source Code Comments
Columns Comments for PERJLEV_POSN (# 2)
Source Code Comments
Columns Comments for PERJLEV_SUFF (# 3)
Source Code Comments
Columns Comments for PERJLEV_LEAV_CODE (# 4)
Source Code Comments
Columns Comments for PERJLEV_BEGIN_BALANCE (# 5)
Source Code Comments
Columns Comments for PERJLEV_ACCRUED (# 6)
Source Code Comments
Columns Comments for PERJLEV_TAKEN (# 7)
Source Code Comments
Columns Comments for PERJLEV_DATE_AVAIL (# 8)
Source Code Comments
Columns Comments for PERJLEV_HRS_BANKED (# 9)
Source Code Comments
Columns Comments for PERJLEV_USER_ID (# 10)
Source Code Comments
Columns Comments for PERJLEV_ACTIVITY_DATE (# 11)
Source Code Comments
Table PERJLHS
Object Full Name
Source Code Comments
Columns Comments for PERJLHS_PIDM (# 1)
Source Code Comments
Columns Comments for PERJLHS_POSN (# 2)
Source Code Comments
Columns Comments for PERJLHS_SUFF (# 3)
Source Code Comments
Columns Comments for PERJLHS_LEAV_CODE (# 4)
Source Code Comments
Columns Comments for PERJLHS_EFFECTIVE_DATE (# 5)
Source Code Comments
Columns Comments for PERJLHS_USER_ID (# 6)
Source Code Comments
Columns Comments for PERJLHS_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for PERJLHS_BEGIN_BALANCE (# 8)
Source Code Comments
Columns Comments for PERJLHS_ACCRUED (# 9)
Source Code Comments
Columns Comments for PERJLHS_TAKEN (# 10)
Source Code Comments
Columns Comments for PERJLHS_DATE_AVAIL (# 11)
Source Code Comments
Columns Comments for PERJLHS_HRS_BANKED (# 12)
Source Code Comments
Columns Comments for PERJLHS_CHANGE_REASON (# 13)
Source Code Comments
Table PERJOBH
Object Full Name
Source Code Comments
Columns Comments for PERJOBH_SEQNO (# 1)
Source Code Comments
Columns Comments for PERJOBH_TETH_SEQNO (# 2)
Source Code Comments
Columns Comments for PERJOBH_YEAR (# 3)
Source Code Comments
Columns Comments for PERJOBH_PICT_CODE (# 4)
Source Code Comments
Columns Comments for PERJOBH_PAYNO (# 5)
Source Code Comments
Columns Comments for PERJOBH_MONTH (# 6)
Source Code Comments
Columns Comments for PERJOBH_ACTION_IND (# 7)
Source Code Comments
Columns Comments for PERJOBH_PIDM (# 8)
Source Code Comments
Columns Comments for PERJOBH_POSN (# 9)
Source Code Comments
Columns Comments for PERJOBH_SUFF (# 10)
Source Code Comments
Columns Comments for PERJOBH_COAS_CODE_TS (# 11)
Source Code Comments
Columns Comments for PERJOBH_ORGN_CODE_TS (# 12)
Source Code Comments
Columns Comments for PERJOBH_STATUS_IND (# 13)
Source Code Comments
Columns Comments for PERJOBH_JOB_TITLE (# 14)
Source Code Comments
Columns Comments for PERJOBH_ECLS_CODE (# 16)
Source Code Comments
Columns Comments for PERJOBH_TIME_ENTRY_METHOD (# 17)
Source Code Comments
Columns Comments for PERJOBH_TIME_ENTRY_TYPE (# 18)
Source Code Comments
Columns Comments for PERJOBH_TIME_IN_OUT_IND (# 19)
Source Code Comments
Columns Comments for PERJOBH_ACAT_CODE (# 20)
Source Code Comments
Columns Comments for PERJOBH_COMMENT (# 21)
Source Code Comments
Columns Comments for PERJOBH_COMMENT_DATE_TIME (# 22)
Source Code Comments
Columns Comments for PERJOBH_COMMENT_CONFID_IND (# 23)
Source Code Comments
Columns Comments for PERJOBH_ACTIVITY_DATE (# 24)
Source Code Comments
Columns Comments for PERJOBH_LCAT_CODE (# 25)
Source Code Comments
Columns Comments for PERJOBH_COMMENT_PIDM (# 26)
Source Code Comments
Table PERJOBP
Object Full Name
Source Code Comments
Columns Comments for PERJOBP_PIDM (# 1)
Source Code Comments
Columns Comments for PERJOBP_JOBP_CODE (# 2)
Source Code Comments
Columns Comments for PERJOBP_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for PERJOBP_USER_ID (# 4)
Source Code Comments
Table PERJOBS
Object Full Name
Source Code Comments
Columns Comments for PERJOBS_SEQNO (# 1)
Source Code Comments
Columns Comments for PERJOBS_YEAR (# 2)
Source Code Comments
Columns Comments for PERJOBS_PICT_CODE (# 3)
Source Code Comments
Columns Comments for PERJOBS_PAYNO (# 4)
Source Code Comments
Columns Comments for PERJOBS_MONTH (# 5)
Source Code Comments
Columns Comments for PERJOBS_ACTION_IND (# 6)
Source Code Comments
Columns Comments for PERJOBS_PIDM (# 7)
Source Code Comments
Columns Comments for PERJOBS_POSN (# 8)
Source Code Comments
Columns Comments for PERJOBS_SUFF (# 9)
Source Code Comments
Columns Comments for PERJOBS_COAS_CODE_TS (# 10)
Source Code Comments
Columns Comments for PERJOBS_ORGN_CODE_TS (# 11)
Source Code Comments
Columns Comments for PERJOBS_STATUS_IND (# 12)
Source Code Comments
Columns Comments for PERJOBS_JOB_TITLE (# 13)
Source Code Comments
Columns Comments for PERJOBS_SHIFT (# 14)
Source Code Comments
Columns Comments for PERJOBS_ECLS_CODE (# 15)
Source Code Comments
Columns Comments for PERJOBS_TIME_ENTRY_METHOD (# 16)
Source Code Comments
Columns Comments for PERJOBS_TIME_ENTRY_TYPE (# 17)
Source Code Comments
Columns Comments for PERJOBS_TIME_IN_OUT_IND (# 18)
Source Code Comments
Columns Comments for PERJOBS_ACAT_CODE (# 19)
Source Code Comments
Columns Comments for PERJOBS_COMMENT (# 20)
Source Code Comments
Columns Comments for PERJOBS_COMMENT_DATE_TIME (# 21)
Source Code Comments
Columns Comments for PERJOBS_COMMENT_CONFID_IND (# 22)
Source Code Comments
Columns Comments for PERJOBS_ACTIVITY_DATE (# 23)
Source Code Comments
Columns Comments for PERJOBS_LCAT_CODE (# 24)
Source Code Comments
Columns Comments for PERJOBS_APPT_PCT (# 25)
Source Code Comments
Columns Comments for PERJOBS_FTE (# 26)
Source Code Comments
Columns Comments for PERJOBS_HRS_DAY (# 27)
Source Code Comments
Columns Comments for PERJOBS_COMMENT_PIDM (# 28)
Source Code Comments
Table PERJTOT
Object Full Name
Source Code Comments
Columns Comments for PERJTOT_PIDM (# 1)
Source Code Comments
Columns Comments for PERJTOT_YEAR (# 2)
Source Code Comments
Columns Comments for PERJTOT_POSN (# 3)
Source Code Comments
Columns Comments for PERJTOT_SUFF (# 4)
Source Code Comments
Columns Comments for PERJTOT_EARN_CODE (# 5)
Source Code Comments
Columns Comments for PERJTOT_MONTH (# 6)
Source Code Comments
Columns Comments for PERJTOT_HRS (# 7)
Source Code Comments
Columns Comments for PERJTOT_GRS (# 8)
Source Code Comments
Columns Comments for PERJTOT_ACTIVITY_DATE (# 9)
Source Code Comments
Columns Comments for PERJTOT_EMPR_CODE (# 10)
Source Code Comments
Table PERLEAV
Object Full Name
Source Code Comments
Columns Comments for PERLEAV_PIDM (# 1)
Source Code Comments
Columns Comments for PERLEAV_LEAV_CODE (# 2)
Source Code Comments
Columns Comments for PERLEAV_BEGIN_BALANCE (# 3)
Source Code Comments
Columns Comments for PERLEAV_ACCRUED (# 4)
Source Code Comments
Columns Comments for PERLEAV_TAKEN (# 5)
Source Code Comments
Columns Comments for PERLEAV_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for PERLEAV_DATE_AVAIL (# 7)
Source Code Comments
Columns Comments for PERLEAV_HRS_BANKED (# 8)
Source Code Comments
Table PERLHIS
Object Full Name
Source Code Comments
Columns Comments for PERLHIS_PIDM (# 1)
Source Code Comments
Columns Comments for PERLHIS_LEAV_CODE (# 2)
Source Code Comments
Columns Comments for PERLHIS_EFFECTIVE_DATE (# 3)
Source Code Comments
Columns Comments for PERLHIS_BEGIN_BALANCE (# 4)
Source Code Comments
Columns Comments for PERLHIS_ACCRUED (# 5)
Source Code Comments
Columns Comments for PERLHIS_TAKEN (# 6)
Source Code Comments
Columns Comments for PERLHIS_DATE_AVAIL (# 7)
Source Code Comments
Columns Comments for PERLHIS_HRS_BANKED (# 8)
Source Code Comments
Columns Comments for PERLHIS_CHANGE_REASON (# 9)
Source Code Comments
Columns Comments for PERLHIS_USER_ID (# 10)
Source Code Comments
Columns Comments for PERLHIS_ACTIVITY_DATE (# 11)
Source Code Comments
Table PERLVTK
Object Full Name
Source Code Comments
Columns Comments for PERLVTK_JOBS_SEQNO (# 1)
Source Code Comments
Columns Comments for PERLVTK_EARN_CODE (# 2)
Source Code Comments
Columns Comments for PERLVTK_LEAV_CODE (# 3)
Source Code Comments
Columns Comments for PERLVTK_USER_ID (# 4)
Source Code Comments
Columns Comments for PERLVTK_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for PERLVTK_HRS (# 6)
Source Code Comments
Table PERPADV
Object Full Name
Source Code Comments
Columns Comments for PERPADV_PIDM (# 1)
Source Code Comments
Columns Comments for PERPADV_POSN (# 2)
Source Code Comments
Columns Comments for PERPADV_SUFF (# 3)
Source Code Comments
Columns Comments for PERPADV_ADVANCE_ACTIVE_IND (# 4)
Source Code Comments
Columns Comments for PERPADV_ADVANCE_AMT (# 5)
Source Code Comments
Columns Comments for PERPADV_ADVANCE_BALANCE (# 6)
Source Code Comments
Columns Comments for PERPADV_ACTIVITY_DATE (# 7)
Source Code Comments
Table PERRCMT
Object Full Name
Source Code Comments
Columns Comments for PERRCMT_PIDM (# 1)
Source Code Comments
Columns Comments for PERRCMT_PICT_CODE (# 2)
Source Code Comments
Columns Comments for PERRCMT_ISSUE_DATE (# 3)
Source Code Comments
Columns Comments for PERRCMT_COMMENT (# 4)
Source Code Comments
Columns Comments for PERRCMT_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for PERRCMT_SEQ_NO (# 6)
Source Code Comments
Columns Comments for PERRCMT_EMPR_CODE (# 7)
Source Code Comments
Table PERREVW
Object Full Name
Source Code Comments
Columns Comments for PERREVW_PIDM (# 1)
Source Code Comments
Columns Comments for PERREVW_REVT_CODE (# 2)
Source Code Comments
Columns Comments for PERREVW_REVT_DATE (# 3)
Source Code Comments
Columns Comments for PERREVW_REVT_COMPLETE (# 4)
Source Code Comments
Columns Comments for PERREVW_REVT_RATING (# 5)
Source Code Comments
Columns Comments for PERREVW_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for PERREVW_REVIEWER_PIDM (# 7)
Source Code Comments
Columns Comments for PERREVW_COMMENT (# 8)
Source Code Comments
Columns Comments for PERREVW_COMPLETED_DATE (# 9)
Source Code Comments
Table PERRHOL
Object Full Name
Source Code Comments
Columns Comments for PERRHOL_PIDM (# 1)
Source Code Comments
Columns Comments for PERRHOL_PICT_CODE (# 2)
Source Code Comments
Columns Comments for PERRHOL_ISSUE_DATE (# 3)
Source Code Comments
Columns Comments for PERRHOL_HOLIDAY_DATE (# 4)
Source Code Comments
Columns Comments for PERRHOL_HOLIDAY_PAY (# 5)
Source Code Comments
Columns Comments for PERRHOL_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for PERRHOL_EMPR_CODE (# 7)
Source Code Comments
Table PERROTH
Object Full Name
Source Code Comments
Columns Comments for PERROTH_PIDM (# 1)
Source Code Comments
Columns Comments for PERROTH_PICT_CODE (# 2)
Source Code Comments
Columns Comments for PERROTH_ISSUE_DATE (# 3)
Source Code Comments
Columns Comments for PERROTH_OTHER_MONIES_NOTE (# 4)
Source Code Comments
Columns Comments for PERROTH_OTHER_MONIES_AMT (# 5)
Source Code Comments
Columns Comments for PERROTH_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for PERROTH_EMPR_CODE (# 7)
Source Code Comments
Table PERSAHS
Object Full Name
Source Code Comments
Columns Comments for PERSAHS_PIDM (# 1)
Source Code Comments
Columns Comments for PERSAHS_PCLS_CODE (# 2)
Source Code Comments
Columns Comments for PERSAHS_CAPTURE_DATE_TIME (# 3)
Source Code Comments
Columns Comments for PERSAHS_SARC_CODE (# 4)
Source Code Comments
Columns Comments for PERSAHS_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for PERSAHS_USER_ID (# 6)
Source Code Comments
Columns Comments for PERSAHS_ADJUSTED_HRS (# 7)
Source Code Comments
Columns Comments for PERSAHS_SENIORITY_HRS (# 8)
Source Code Comments
Columns Comments for PERSAHS_DATE_IN_CLASS (# 9)
Source Code Comments
Columns Comments for PERSAHS_COMMENTS (# 10)
Source Code Comments
Table PERSNBL
Object Full Name
Source Code Comments
Columns Comments for PERSNBL_PIDM (# 1)
Source Code Comments
Columns Comments for PERSNBL_PCLS_CODE (# 2)
Source Code Comments
Columns Comments for PERSNBL_SENIORITY_HRS (# 3)
Source Code Comments
Columns Comments for PERSNBL_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for PERSNBL_USER_ID (# 5)
Source Code Comments
Columns Comments for PERSNBL_EARNED_HRS (# 6)
Source Code Comments
Columns Comments for PERSNBL_DATE_IN_CLASS (# 7)
Source Code Comments
Table PERXJOB
Object Full Name
Source Code Comments
Columns Comments for PERXJOB_PIDM (# 1)
Source Code Comments
Columns Comments for PERXJOB_SCHL_CODE (# 2)
Source Code Comments
Columns Comments for PERXJOB_POSN (# 3)
Source Code Comments
Columns Comments for PERXJOB_SUFF (# 4)
Source Code Comments
Columns Comments for PERXJOB_ACTIVITY_DATE (# 5)
Source Code Comments
Table PHRACCR
Object Full Name
Source Code Comments
Columns Comments for PHRACCR_YEAR (# 1)
Source Code Comments
Columns Comments for PHRACCR_PICT_CODE (# 2)
Source Code Comments
Columns Comments for PHRACCR_PAYNO (# 3)
Source Code Comments
Columns Comments for PHRACCR_PIDM (# 4)
Source Code Comments
Columns Comments for PHRACCR_LEAV_CODE (# 5)
Source Code Comments
Columns Comments for PHRACCR_CURR_ACCR (# 6)
Source Code Comments
Columns Comments for PHRACCR_CURR_TAKEN (# 7)
Source Code Comments
Columns Comments for PHRACCR_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for PHRACCR_BANK_IND (# 9)
Source Code Comments
Columns Comments for PHRACCR_CALC_GEN_IND (# 10)
Source Code Comments
Table 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 POTPARM
Object Full Name
Source Code Comments
Columns Comments for POTPARM_SESSION_ID (# 1)
Source Code Comments
Columns Comments for POTPARM_USER_ID (# 2)
Source Code Comments
Columns Comments for POTPARM_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for POTPARM_PIDM (# 4)
Source Code Comments
Columns Comments for POTPARM_YEAR (# 5)
Source Code Comments
Columns Comments for POTPARM_PICT_CODE (# 6)
Source Code Comments
Columns Comments for POTPARM_PAYNO (# 7)
Source Code Comments
Columns Comments for POTPARM_COAS_CODE_TS (# 8)
Source Code Comments
Columns Comments for POTPARM_ORGN_CODE_TS (# 9)
Source Code Comments
Columns Comments for POTPARM_TE_STATUS (# 10)
Source Code Comments
Columns Comments for POTPARM_TE_ACTION (# 11)
Source Code Comments
Columns Comments for POTPARM_TE_METHOD (# 12)
Source Code Comments
Columns Comments for POTPARM_LEAVE_BALANCE_DATE (# 13)
Source Code Comments
Columns Comments for POTPARM_LEAVE_SEQ_METHOD (# 14)
Source Code Comments
Columns Comments for POTPARM_LEAVE_DISPLAY_TYPE (# 15)
Source Code Comments
Columns Comments for POTPARM_PCLS_CODE (# 16)
Source Code Comments
Columns Comments for POTPARM_ORGN_HIER_IND (# 17)
Source Code Comments
Columns Comments for POTPARM_AS_OF_DATE (# 18)
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 PTRBSDD
Object Full Name
Columns Comments for PTRBSDD_BCAT_CODE (# 1)
Source Code Comments
Columns Comments for PTRBSDD_DATE (# 2)
Source Code Comments
Columns Comments for PTRBSDD_DISP_DATE_IND (# 3)
Source Code Comments
Columns Comments for PTRBSDD_USER_ID (# 4)
Source Code Comments
Columns Comments for PTRBSDD_ACTIVITY_DATE (# 5)
Source Code Comments
Table PTRBURE
Object Full Name
Source Code Comments
Columns Comments for PTRBURE_CODE (# 1)
Source Code Comments
Columns Comments for PTRBURE_DESC (# 2)
Source Code Comments
Columns Comments for PTRBURE_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for PTRBURE_STATS_CANADA_BARG_CDE (# 4)
Source Code Comments
Table PTRJBLN
Object Full Name
Source Code Comments
Columns Comments for PTRJBLN_CODE (# 1)
Source Code Comments
Columns Comments for PTRJBLN_DESC (# 2)
Source Code Comments
Columns Comments for PTRJBLN_ADDRESS1 (# 3)
Source Code Comments
Columns Comments for PTRJBLN_ADDRESS2 (# 4)
Source Code Comments
Columns Comments for PTRJBLN_CITY (# 5)
Source Code Comments
Columns Comments for PTRJBLN_STAT_CODE (# 6)
Source Code Comments
Columns Comments for PTRJBLN_ZIPC_CODE (# 7)
Source Code Comments
Columns Comments for PTRJBLN_NATN_CODE (# 8)
Source Code Comments
Columns Comments for PTRJBLN_ACTIVITY_DATE (# 9)
Source Code Comments
Columns Comments for PTRJBLN_DICD_CODE (# 10)
Source Code Comments
Table PTRLEAV
Object Full Name
Source Code Comments
Columns Comments for PTRLEAV_CODE (# 1)
Source Code Comments
Columns Comments for PTRLEAV_SHORT_DESC (# 2)
Source Code Comments
Columns Comments for PTRLEAV_LONG_DESC (# 3)
Source Code Comments
Columns Comments for PTRLEAV_ANN_DAY (# 4)
Source Code Comments
Columns Comments for PTRLEAV_MIN_HRS (# 5)
Source Code Comments
Columns Comments for PTRLEAV_PRORATE_HRS (# 6)
Source Code Comments
Columns Comments for PTRLEAV_ACTIVITY_DATE (# 7)
Source Code Comments
Table PTRLREA
Object Full Name
Source Code Comments
Columns Comments for PTRLREA_CODE (# 1)
Source Code Comments
Columns Comments for PTRLREA_DESC (# 2)
Source Code Comments
Columns Comments for PTRLREA_STATUS (# 3)
Source Code Comments
Columns Comments for PTRLREA_COBRA_ELIG_IND (# 4)
Source Code Comments
Columns Comments for PTRLREA_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for PTRLREA_RET_WORK_ELIG_IND (# 6)
Source Code Comments
Columns Comments for PTRLREA_SABB_LEAVE_IND (# 7)
Source Code Comments
Columns Comments for PTRLREA_COMM_FULLFILL_IND (# 8)
Source Code Comments
Columns Comments for PTRLREA_FAC_TRACKING_IND (# 9)
Source Code Comments
Columns Comments for PTRLREA_ASSOC_ACAT_CODE (# 10)
Source Code Comments
Table PTRWKPR
Object Full Name
Source Code Comments
Columns Comments for PTRWKPR_CODE (# 1)
Source Code Comments
Columns Comments for PTRWKPR_DESC (# 2)
Source Code Comments
Columns Comments for PTRWKPR_PERIOD_BEGIN_DATE_TIME (# 3)
Source Code Comments
Columns Comments for PTRWKPR_NUMBER_OF_DAYS (# 4)
Source Code Comments
Columns Comments for PTRWKPR_PERIOD_MAX_NON_OT_HRS (# 5)
Source Code Comments
Columns Comments for PTRWKPR_DAILY_MAX_NON_OT_HRS (# 6)
Source Code Comments
Columns Comments for PTRWKPR_ACTIVITY_DATE (# 7)
Source Code Comments
Table PTVBARG
Object Full Name
Source Code Comments
Columns Comments for PTVBARG_CODE (# 1)
Source Code Comments
Columns Comments for PTVBARG_DESC (# 2)
Source Code Comments
Columns Comments for PTVBARG_ACTIVITY_DATE (# 3)
Source Code Comments
Table PTVLCAT
Object Full Name
Source Code Comments
Columns Comments for PTVLCAT_CODE (# 1)
Source Code Comments
Columns Comments for PTVLCAT_DESC (# 2)
Source Code Comments
Columns Comments for PTVLCAT_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for PTVLCAT_REPORT_IND (# 4)
Source Code Comments
Columns Comments for PTVLCAT_HOUR_DAY_IND (# 5)
Source Code Comments
Columns Comments for PTVLCAT_USER_ID (# 6)
Source Code Comments
Table PTVNRSI
Object Full Name
Source Code Comments
Columns Comments for PTVNRSI_CODE (# 1)
Source Code Comments
Columns Comments for PTVNRSI_DESC (# 2)
Source Code Comments
Columns Comments for PTVNRSI_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for PTVNRSI_EFFECTIVE_YEAR (# 4)
Source Code Comments
Table PTVORGN
Object Full Name
Source Code Comments
Columns Comments for PTVORGN_ORGN_CODE_PRED (# 4)
Source Code Comments
Table PTVSTGR
Object Full Name
Source Code Comments
Columns Comments for PTVSTGR_CODE (# 1)
Source Code Comments
Columns Comments for PTVSTGR_DESC (# 2)
Source Code Comments
Columns Comments for PTVSTGR_ACTIVITY_DATE (# 3)
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 SPRIDEN and NBRBJOB
Join Information
Link between NBRJOBS and NBRBJOB
Join Information
Link between NBBPOSN and NBRJOBS
Join Information
Link between PTRJBLN and NBRJOBS
Join Information
Link between SPRIDEN and PERJOBP
Join Information
Link between PERJBBG and NBRJOBS
Join Information
Link between PTRLREA and PEBEMPL
Join Information
Link between PABAPPL and NBBPOSN
Join Information
Link between SPRIDEN and PABAPPL
Join Information
Link between SPRIDEN and PEBEMPL
Join Information
Link between PERLEAV and PEBEMPL
Join Information
Link between NBRBJOB and PEBEMPL
Join Information
Link between NBRJOBS and PEBEMPL
Join Information
Link between SPRIDEN and PERBARG
Join Information
Link between PABAPPL and SPBPERS
Join Information
Link between SPRIDEN and PDRBDED
Join Information
Link between PTVLCAT and NBRJOBS
Join Information
Link between NBRBJOB and PERJLEV
Join Information
Link between PERJLEV and POTPARM
Join Information
Link between PEBEMPL and POTPARM
Join Information
Link between SPRIDEN and PERJOBS
Join Information
Link between SPRIDEN and NBRJOBS
Join Information
Link between PABAPPL and PEBEMPL
Join Information
Link between NBRJOBS and POTPARM
Join Information
Link between NBRJOBS and PERSNBL
Join Information
Link between PERSNBL and NBBPOSN
Join Information
Link between PERJBBG and PEBEMPL
Join Information
Link between SPRIDEN and PERREVW
Join Information
Link between SPBPERS and PEBEMPL
Join Information
Link between NBRBJOB and NBBPOSN
Link between PERJFAC and NBBPOSN
Link between PERXJOB and NBRBJOB
Link between PERJOBS and NBRBJOB
Join Information
Link between PERJOBS and PTVLCAT
Join Information
Link between SPRIDEN and PERJOBH
Join Information
Link between PERFASG and PERFCNT
Join Information
Link between SPBPERS and NBRBJOB
Join Information
Link between PTRBCDN and PEBEMPL
Join Information
Link between SPRIDEN and PERFCNT
Join Information
Link between PHREARN and NBBPOSN
Join Information
Link between PHREARN and PHRHIST
Join Information
Link between PHRJACR and PHRHIST
Join Information
Link between PERJLEV and PHRJACR
Join Information
Link between NBRJOBS and PERJLEV
Join Information
Link between PEBEMPL and PERJLEV
Join Information
Link between PERJLEV and PHRHIST
Join Information
Link between PTRBSDD and PEBEMPL
Join Information
Link between PERJHIS and PTRJBLN
Link between PERBARG and PTVBARG
Link between PERJBBG and NBRBJOB
Link between PERJBBG and PERBARG
Link between PERJBBG and PTVBARG
Link between PHREARN and PTVORGN
Link between NBRJOBS and PTVORGN
Link between PERGRPA and NBRBJOB
Link between PERDIRD and PEBEMPL
Link between PDRFBAL and PEBEMPL
Link between PDRFCLM and PEBEMPL
Link between PERBARG and PEBEMPL
Link between PERGRPA and PEBEMPL
Link between PERREVW and PEBEMPL
Link between PERRHOL and PEBEMPL
Link between PERROTH and PEBEMPL
Link between PHRHIST and PEBEMPL
Link between PEBEMPL and PTRJBLN
Link between PEBEMPL and PTVLCAT
Link between PEBEMPL and PTVNRSI
Link between PEBEMPL and PTVORGN
Link between PEBEMPL and PTVSTGR
Link between PEBEMPL and PTRWKPR
Link between PERLEAV and PTRLEAV
Link between PERPADV and NBRBJOB
Link between PHRACCR and PTRLEAV
Link between PERBARG and PTRBURE
Link between PERRCMT and PEBEMPL
Link between PDRBDED and PEBEMPL
Link between PERJLEV and PTRLEAV
Link between PERJLHS and PTRLEAV
Link between PERFASG and NBBPOSN
Link between PHRJACR and PTRLEAV
Link between PERJTOT and NBRBJOB
Link between PERLVTK and PERJOBS
Link between PERLVTK and PTRLEAV