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 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 NBRPOSH
Object Full Name
Source Code Comments
Columns Comments for NBRPOSH_POSN (# 1)
Source Code Comments
Columns Comments for NBRPOSH_CHANGE_DATE_TIME (# 2)
Source Code Comments
Columns Comments for NBRPOSH_TITLE (# 3)
Source Code Comments
Columns Comments for NBRPOSH_PCLS_CODE (# 4)
Source Code Comments
Columns Comments for NBRPOSH_ECLS_CODE (# 5)
Source Code Comments
Columns Comments for NBRPOSH_POSN_REPORTS (# 6)
Source Code Comments
Columns Comments for NBRPOSH_TABLE (# 7)
Source Code Comments
Columns Comments for NBRPOSH_GRADE (# 8)
Source Code Comments
Columns Comments for NBRPOSH_STEP (# 9)
Source Code Comments
Columns Comments for NBRPOSH_APPT_PCT (# 10)
Source Code Comments
Columns Comments for NBRPOSH_PGRP_CODE (# 11)
Source Code Comments
Columns Comments for NBRPOSH_USERID (# 12)
Source Code Comments
Columns Comments for NBRPOSH_ACTIVITY_DATE (# 13)
Source Code Comments
Columns Comments for NBRPOSH_EXEMPT_IND (# 14)
Source Code Comments
Columns Comments for NBRPOSH_JBLN_CODE (# 15)
Source Code Comments
Columns Comments for NBRPOSH_BARG_CODE (# 16)
Source Code Comments
Columns Comments for NBRPOSH_PROBATION_UNITS (# 17)
Source Code Comments
Columns Comments for NBRPOSH_ACCRUE_SENIORITY_IND (# 18)
Source Code Comments
Columns Comments for NBRPOSH_JOBP_CODE (# 19)
Source Code Comments
Columns Comments for NBRPOSH_BUDGET_TYPE (# 20)
Source Code Comments
Table NTRPCLS
Object Full Name
Source Code Comments
Columns Comments for NTRPCLS_CODE (# 1)
Source Code Comments
Columns Comments for NTRPCLS_DESC (# 2)
Source Code Comments
Columns Comments for NTRPCLS_ECLS_CODE (# 3)
Source Code Comments
Columns Comments for NTRPCLS_ESKL_CODE (# 4)
Source Code Comments
Columns Comments for NTRPCLS_EFUN_CODE (# 5)
Source Code Comments
Columns Comments for NTRPCLS_EXEMPT_IND (# 6)
Source Code Comments
Columns Comments for NTRPCLS_TABLE (# 7)
Source Code Comments
Columns Comments for NTRPCLS_GRADE (# 8)
Source Code Comments
Columns Comments for NTRPCLS_STEP (# 9)
Source Code Comments
Columns Comments for NTRPCLS_ACTIVITY_DATE (# 10)
Source Code Comments
Columns Comments for NTRPCLS_SGRP_CODE (# 11)
Source Code Comments
Columns Comments for NTRPCLS_PGRP_CODE (# 12)
Source Code Comments
Columns Comments for NTRPCLS_CHANGE_DATE_TIME (# 13)
Source Code Comments
Columns Comments for NTRPCLS_CALIF_TYPE (# 14)
Source Code Comments
Columns Comments for NTRPCLS_STRS_FTE (# 15)
Source Code Comments
Columns Comments for NTRPCLS_PERS_HOURS (# 16)
Source Code Comments
Columns Comments for NTRPCLS_STRS_BASE_HRS (# 17)
Source Code Comments
Columns Comments for NTRPCLS_BARG_CODE (# 18)
Source Code Comments
Columns Comments for NTRPCLS_PROBATION_UNITS (# 19)
Source Code Comments
Columns Comments for NTRPCLS_ACCRUE_SENIORITY_IND (# 20)
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 PABPFAC
Object Full Name
Source Code Comments
Columns Comments for PABPFAC_POSN (# 1)
Source Code Comments
Columns Comments for PABPFAC_SKILL_FACTOR (# 2)
Source Code Comments
Columns Comments for PABPFAC_DEGREE_FACTOR (# 3)
Source Code Comments
Columns Comments for PABPFAC_EXAM_FACTOR (# 4)
Source Code Comments
Columns Comments for PABPFAC_CERT_FACTOR (# 5)
Source Code Comments
Columns Comments for PABPFAC_ACTIVITY_DATE (# 6)
Source Code Comments
Table PABREQU
Object Full Name
Source Code Comments
Columns Comments for PABREQU_REQ_NO (# 1)
Source Code Comments
Columns Comments for PABREQU_REQS_CODE (# 2)
Source Code Comments
Columns Comments for PABREQU_APPL_DATE (# 3)
Source Code Comments
Columns Comments for PABREQU_POSN (# 4)
Source Code Comments
Columns Comments for PABREQU_VACY_DATE (# 5)
Source Code Comments
Columns Comments for PABREQU_POST_DATE (# 6)
Source Code Comments
Columns Comments for PABREQU_OPEN_DATE (# 7)
Source Code Comments
Columns Comments for PABREQU_CLOSE_DATE (# 8)
Source Code Comments
Columns Comments for PABREQU_HIRE_DATE (# 9)
Source Code Comments
Columns Comments for PABREQU_APPR_DATE (# 10)
Source Code Comments
Columns Comments for PABREQU_APPR_PIDM (# 11)
Source Code Comments
Columns Comments for PABREQU_RECR_PIDM (# 12)
Source Code Comments
Columns Comments for PABREQU_RELOC_IND (# 13)
Source Code Comments
Columns Comments for PABREQU_ACTIVITY_DATE (# 14)
Source Code Comments
Table PARAPIN
Object Full Name
Source Code Comments
Columns Comments for PARAPIN_PIDM (# 1)
Source Code Comments
Columns Comments for PARAPIN_REQ_NO (# 2)
Source Code Comments
Columns Comments for PARAPIN_POSN (# 3)
Source Code Comments
Columns Comments for PARAPIN_PCLS_CODE (# 4)
Source Code Comments
Columns Comments for PARAPIN_APPL_DATE (# 5)
Source Code Comments
Columns Comments for PARAPIN_INTERVIEW_PIDM (# 6)
Source Code Comments
Columns Comments for PARAPIN_INTERVIEW_DATE (# 7)
Source Code Comments
Columns Comments for PARAPIN_INTERVIEW_TIME (# 8)
Source Code Comments
Columns Comments for PARAPIN_COMMENT (# 9)
Source Code Comments
Columns Comments for PARAPIN_ACTIVITY_DATE (# 10)
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 PARCDES
Object Full Name
Source Code Comments
Columns Comments for PARCDES_PCLS_CODE (# 1)
Source Code Comments
Columns Comments for PARCDES_CDES_CODE (# 2)
Source Code Comments
Columns Comments for PARCDES_ACTIVITY_DATE (# 3)
Source Code Comments
Table PARPCER
Object Full Name
Source Code Comments
Columns Comments for PARPCER_POSN (# 1)
Source Code Comments
Columns Comments for PARPCER_CERT_CODE (# 2)
Source Code Comments
Columns Comments for PARPCER_CERT_REQR_IND (# 3)
Source Code Comments
Columns Comments for PARPCER_ACTIVITY_DATE (# 4)
Source Code Comments
Table PARPCMT
Object Full Name
Source Code Comments
Columns Comments for PARPCMT_POSN (# 1)
Source Code Comments
Columns Comments for PARPCMT_COMMENT (# 2)
Source Code Comments
Columns Comments for PARPCMT_ACTIVITY_DATE (# 3)
Source Code Comments
Table PARPCON
Object Full Name
Source Code Comments
Columns Comments for PARPCON_POSN (# 1)
Source Code Comments
Columns Comments for PARPCON_DEGC_CODE (# 2)
Source Code Comments
Columns Comments for PARPCON_CONC_CODE (# 3)
Source Code Comments
Columns Comments for PARPCON_CONC_REQR_IND (# 4)
Source Code Comments
Columns Comments for PARPCON_ACTIVITY_DATE (# 5)
Source Code Comments
Table PARPDEG
Object Full Name
Source Code Comments
Columns Comments for PARPDEG_POSN (# 1)
Source Code Comments
Columns Comments for PARPDEG_DEGC_CODE (# 2)
Source Code Comments
Columns Comments for PARPDEG_DEGC_REQR_IND (# 3)
Source Code Comments
Columns Comments for PARPDEG_DLEV_REQR_IND (# 4)
Source Code Comments
Columns Comments for PARPDEG_ACTIVITY_DATE (# 5)
Source Code Comments
Table PARPDES
Object Full Name
Source Code Comments
Columns Comments for PARPDES_POSN (# 1)
Source Code Comments
Columns Comments for PARPDES_CDES_CODE (# 2)
Source Code Comments
Columns Comments for PARPDES_ACTIVITY_DATE (# 3)
Source Code Comments
Table PARPEND
Object Full Name
Source Code Comments
Columns Comments for PARPEND_POSN (# 1)
Source Code Comments
Columns Comments for PARPEND_CERT_CODE (# 2)
Source Code Comments
Columns Comments for PARPEND_ENDS_CODE (# 3)
Source Code Comments
Columns Comments for PARPEND_ENDS_REQR_IND (# 4)
Source Code Comments
Columns Comments for PARPEND_ACTIVITY_DATE (# 5)
Source Code Comments
Table PARPEXM
Object Full Name
Source Code Comments
Columns Comments for PARPEXM_POSN (# 1)
Source Code Comments
Columns Comments for PARPEXM_EXAM_CODE (# 2)
Source Code Comments
Columns Comments for PARPEXM_EXAM_REQR_IND (# 3)
Source Code Comments
Columns Comments for PARPEXM_ACTIVITY_DATE (# 4)
Source Code Comments
Table PARPMAJ
Object Full Name
Source Code Comments
Columns Comments for PARPMAJ_POSN (# 1)
Source Code Comments
Columns Comments for PARPMAJ_DEGC_CODE (# 2)
Source Code Comments
Columns Comments for PARPMAJ_MAJR_CODE (# 3)
Source Code Comments
Columns Comments for PARPMAJ_MAJR_REQR_IND (# 4)
Source Code Comments
Columns Comments for PARPMAJ_ACTIVITY_DATE (# 5)
Source Code Comments
Table PARPMIN
Object Full Name
Source Code Comments
Columns Comments for PARPMIN_POSN (# 1)
Source Code Comments
Columns Comments for PARPMIN_DEGC_CODE (# 2)
Source Code Comments
Columns Comments for PARPMIN_MINR_CODE (# 3)
Source Code Comments
Columns Comments for PARPMIN_MINR_REQR_IND (# 4)
Source Code Comments
Columns Comments for PARPMIN_ACTIVITY_DATE (# 5)
Source Code Comments
Table PARPSKL
Object Full Name
Source Code Comments
Columns Comments for PARPSKL_POSN (# 1)
Source Code Comments
Columns Comments for PARPSKL_SKIL_CODE (# 2)
Source Code Comments
Columns Comments for PARPSKL_SKIL_REQR_IND (# 3)
Source Code Comments
Columns Comments for PARPSKL_SKLV_CODE (# 4)
Source Code Comments
Columns Comments for PARPSKL_SKLV_REQR_IND (# 5)
Source Code Comments
Columns Comments for PARPSKL_ACTIVITY_DATE (# 6)
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 PPRCERT
Object Full Name
Source Code Comments
Columns Comments for PPRCERT_PIDM (# 1)
Source Code Comments
Columns Comments for PPRCERT_CERT_CODE (# 2)
Source Code Comments
Columns Comments for PPRCERT_CERT_DATE (# 3)
Source Code Comments
Columns Comments for PPRCERT_NEXT_CERT_DATE (# 4)
Source Code Comments
Columns Comments for PPRCERT_EXPIRE_DATE (# 5)
Source Code Comments
Columns Comments for PPRCERT_CERT_NO (# 6)
Source Code Comments
Columns Comments for PPRCERT_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for PPRCERT_LCSV_CODE (# 8)
Source Code Comments
Columns Comments for PPRCERT_STAT_CODE (# 9)
Source Code Comments
Columns Comments for PPRCERT_NATN_CODE (# 10)
Source Code Comments
Columns Comments for PPRCERT_COMMENTS (# 11)
Source Code Comments
Columns Comments for PPRCERT_USER_ID (# 12)
Source Code Comments
Columns Comments for PPRCERT_DATA_ORIGIN (# 13)
Source Code Comments
Table PPREXPE
Object Full Name
Source Code Comments
Columns Comments for PPREXPE_PIDM (# 1)
Source Code Comments
Columns Comments for PPREXPE_POSN_TITLE (# 2)
Source Code Comments
Columns Comments for PPREXPE_EMTY_CODE (# 3)
Source Code Comments
Columns Comments for PPREXPE_EMPR_NAME (# 4)
Source Code Comments
Columns Comments for PPREXPE_START_DATE (# 5)
Source Code Comments
Columns Comments for PPREXPE_END_DATE (# 6)
Source Code Comments
Columns Comments for PPREXPE_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for PPREXPE_CURR_SALARY (# 8)
Source Code Comments
Columns Comments for PPREXPE_CURR_HOURLY (# 9)
Source Code Comments
Columns Comments for PPREXPE_REASON_LEFT (# 10)
Source Code Comments
Columns Comments for PPREXPE_EMPS_SUPERVISE (# 11)
Source Code Comments
Columns Comments for PPREXPE_SUPER_NAME (# 12)
Source Code Comments
Columns Comments for PPREXPE_SUPER_PHONE_AREA (# 13)
Source Code Comments
Columns Comments for PPREXPE_SUPER_PHONE_NUMBER (# 14)
Source Code Comments
Columns Comments for PPREXPE_SUPER_PHONE_EXT (# 15)
Source Code Comments
Columns Comments for PPREXPE_CONTACT_IND (# 16)
Source Code Comments
Columns Comments for PPREXPE_SUPER_COMMENT (# 17)
Source Code Comments
Columns Comments for PPREXPE_POSN_DUTIES (# 18)
Source Code Comments
Columns Comments for PPREXPE_STAT_CODE (# 19)
Source Code Comments
Columns Comments for PPREXPE_NATN_CODE (# 20)
Source Code Comments
Columns Comments for PPREXPE_USER_ID (# 21)
Source Code Comments
Columns Comments for PPREXPE_DATA_ORIGIN (# 22)
Source Code Comments
Columns Comments for PPREXPE_CTRY_CODE_SUPER_PHONE (# 23)
Source Code Comments
Table PPRREFE
Object Full Name
Source Code Comments
Columns Comments for PPRREFE_PIDM (# 1)
Source Code Comments
Columns Comments for PPRREFE_NAME (# 2)
Source Code Comments
Columns Comments for PPRREFE_PHONE_AREA (# 3)
Source Code Comments
Columns Comments for PPRREFE_PHONE_NUMBER (# 4)
Source Code Comments
Columns Comments for PPRREFE_PHONE_EXT (# 5)
Source Code Comments
Columns Comments for PPRREFE_COMMENT (# 6)
Source Code Comments
Columns Comments for PPRREFE_ACTIVITY_DATE (# 7)
Source Code Comments
Columns Comments for PPRREFE_CTRY_CODE_PHONE (# 8)
Source Code Comments
Table PPRSKIL
Object Full Name
Source Code Comments
Columns Comments for PPRSKIL_PIDM (# 1)
Source Code Comments
Columns Comments for PPRSKIL_SKIL_CODE (# 2)
Source Code Comments
Columns Comments for PPRSKIL_SKLV_CODE (# 3)
Source Code Comments
Columns Comments for PPRSKIL_COMMENTS (# 4)
Source Code Comments
Columns Comments for PPRSKIL_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for PPRSKIL_START_DATE (# 6)
Source Code Comments
Columns Comments for PPRSKIL_END_DATE (# 7)
Source Code Comments
Columns Comments for PPRSKIL_LAST_DATE (# 8)
Source Code Comments
Columns Comments for PPRSKIL_READ_IND (# 9)
Source Code Comments
Columns Comments for PPRSKIL_WRITE_IND (# 10)
Source Code Comments
Columns Comments for PPRSKIL_SPEAK_IND (# 11)
Source Code Comments
Columns Comments for PPRSKIL_TRANS_IND (# 12)
Source Code Comments
Columns Comments for PPRSKIL_TEACH_IND (# 13)
Source Code Comments
Columns Comments for PPRSKIL_NATIVE_IND (# 14)
Source Code Comments
Columns Comments for PPRSKIL_DATA_ORIGIN (# 15)
Source Code Comments
Columns Comments for PPRSKIL_USER_ID (# 16)
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 PTVASRC
Object Full Name
Source Code Comments
Columns Comments for PTVASRC_CODE (# 1)
Source Code Comments
Columns Comments for PTVASRC_DESC (# 2)
Source Code Comments
Columns Comments for PTVASRC_ACTIVITY_DATE (# 3)
Source Code Comments
Table PTVESKL
Object Full Name
Source Code Comments
Columns Comments for PTVESKL_CODE (# 1)
Source Code Comments
Columns Comments for PTVESKL_DESC (# 2)
Source Code Comments
Columns Comments for PTVESKL_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for PTVESKL_EMPR_IND (# 4)
Source Code Comments
Columns Comments for PTVESKL_MIS_OCC_CODE (# 5)
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
Table SPRTELE
Object Full Name
Source Code Comments
Columns Comments for SPRTELE_PIDM (# 1)
Source Code Comments
Columns Comments for SPRTELE_SEQNO (# 2)
Source Code Comments
Columns Comments for SPRTELE_TELE_CODE (# 3)
Source Code Comments
Columns Comments for SPRTELE_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for SPRTELE_PHONE_AREA (# 5)
Source Code Comments
Columns Comments for SPRTELE_PHONE_NUMBER (# 6)
Source Code Comments
Columns Comments for SPRTELE_PHONE_EXT (# 7)
Source Code Comments
Columns Comments for SPRTELE_STATUS_IND (# 8)
Source Code Comments
Columns Comments for SPRTELE_ATYP_CODE (# 9)
Source Code Comments
Columns Comments for SPRTELE_ADDR_SEQNO (# 10)
Source Code Comments
Columns Comments for SPRTELE_PRIMARY_IND (# 11)
Source Code Comments
Columns Comments for SPRTELE_UNLIST_IND (# 12)
Source Code Comments
Columns Comments for SPRTELE_COMMENT (# 13)
Source Code Comments
Columns Comments for SPRTELE_INTL_ACCESS (# 14)
Source Code Comments
Columns Comments for SPRTELE_DATA_ORIGIN (# 15)
Source Code Comments
Columns Comments for SPRTELE_USER_ID (# 16)
Source Code Comments
Columns Comments for SPRTELE_CTRY_CODE_PHONE (# 17)
Source Code Comments
Link between SPRIDEN and SPBPERS
Join Information
Link between NBBPOSN and NBRJOBS
Join Information
Link between PTRECLS and NBRJOBS
Join Information
Link between PABAPPL and PTVESKL
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 SPRTELE and PEBEMPL
Join Information
Link between NBRJOBS and PEBEMPL
Join Information
Link between SPRIDEN and PARAPIN
Join Information
Link between PABAPPL and SPBPERS
Join Information
Link between PTRECLS and NBBPOSN
Join Information
Link between PABAPPL and PABREQU
Join Information
Link between PABAPPL and SPRTELE
Join Information
Link between PABAPPL and PPRSKIL
Join Information
Link between PABAPPL and PPRREFE
Join Information
Link between PPREXPE and PABAPPL
Join Information
Link between PARAPST and PABAPPL
Join Information
Link between PABAPPL and PARAPIN
Join Information
Link between PABAPPL and PPRCERT
Join Information
Link between SPRIDEN and NBRJOBS
Join Information
Link between PABAPPL and PEBEMPL
Join Information
Link between SPBPERS and PEBEMPL
Join Information
Link between NBBPOSN and NTRPCLS
Link between PABREQU and NBBPOSN
Link between PABPFAC and NBBPOSN
Link between NTRPCLS and PTRECLS
Link between PEBEMPL and PTRECLS
Link between PARPCER and NBBPOSN
Link between PARPCON and NBBPOSN
Link between PARCDES and NTRPCLS
Link between PARPDEG and NBBPOSN
Link between PARPDES and NBBPOSN
Link between PARPSKL and NBBPOSN
Link between PARPEND and NBBPOSN
Link between PARPMAJ and NBBPOSN
Link between PARPEXM and NBBPOSN
Link between PARPMIN and NBBPOSN
Link between PABAPPL and NTRPCLS
Link between PABAPPL and PTVASRC
Link between NBRPOSH and NBBPOSN
Join Information