NBRBJOB PABAPPL PDRBDED PDRBFLX PDRFBAL PDRFCLM PEBEMPL PEBROEC PERBARG PERBFAC PERCAPL PERCAPR PERDHIS PERDIRD PERDTOT PEREHIS PERETOT PERFACC PERFACL PERFAPL PERFAPR PERGRRA PERJBBG PERJFAC PERJHIS PERJLEV PERJLHS PERJOBP PERJTOT PERLEAV PERLHIS PERLVTK PERPADV PERRCMT PERREVW PERRHOL PERROTH PERSAHS PERSNBL PERXJOB PHRACCR PHRHIST PHRJACR POTPARM PTRBCAT PTRBCDN PTRBSDD PTRECLS PTRJBLN PTRLREA PTRTREA PTRWKPR PTVLCAT PTVNRSI PTVSTGR SORDEGR SPBPERS SPRIDEN

Model Employee


Model Label : Banner HR Employee Module
Path : Default Folder/B70/payroll/Banner HR Employee Module

List of Objects

Object Name Object Type Layer Name
NBRBJOB TABLE Default
PABAPPL TABLE Default
PDRBDED TABLE Default
PDRBFLX TABLE Default
PDRFBAL TABLE Default
PDRFCLM TABLE Default
PEBEMPL TABLE Main Objects
PEBROEC TABLE Default
PERBARG TABLE Default
PERBFAC TABLE Default
PERCAPL TABLE Default
PERCAPR TABLE Default
PERDHIS TABLE Default
PERDIRD TABLE Default
PERDTOT TABLE Default
PEREHIS TABLE Default
PERETOT TABLE Default
PERFACC TABLE Default
PERFACL TABLE Default
PERFAPL TABLE Default
PERFAPR TABLE Default
PERGRRA TABLE Default
PERJBBG TABLE Default
PERJFAC TABLE Default
PERJHIS TABLE Default
PERJLEV TABLE Default
PERJLHS TABLE Default
PERJOBP TABLE Default
PERJTOT TABLE Default
PERLEAV TABLE Default
PERLHIS TABLE Default
PERLVTK TABLE Default
PERPADV TABLE Default
PERRCMT TABLE Default
PERREVW TABLE Default
PERRHOL TABLE Default
PERROTH TABLE Default
PERSAHS TABLE Default
PERSNBL TABLE Default
PERXJOB TABLE Default
PHRACCR TABLE Default
PHRHIST TABLE Default
PHRJACR TABLE Default
POTPARM TABLE Default
PTRBCAT TABLE Default
PTRBCDN TABLE Default
PTRBSDD TABLE Default
PTRECLS TABLE Default
PTRJBLN TABLE Default
PTRLREA TABLE Default
PTRTREA TABLE Default
PTRWKPR TABLE Default
PTVLCAT TABLE Default
PTVNRSI TABLE Default
PTVSTGR TABLE Default
SORDEGR TABLE Default
SPBPERS TABLE Default
SPRIDEN TABLE Default

Comments

Model View

''

Table NBRBJOB

Schema Name POSNCTL
Label NBRBJOB
Server name S4B70
Creation Date 09/29/2003 12:11:57:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
NBRBJOB_PIDM NBRBJOB_PIDM NUMBER(8,0) No * *
NBRBJOB_POSN NBRBJOB_POSN VARCHAR2(6) No * *
NBRBJOB_SUFF NBRBJOB_SUFF VARCHAR2(2) No * *
NBRBJOB_BEGIN_DATE NBRBJOB_BEGIN_DATE DATE No
NBRBJOB_END_DATE NBRBJOB_END_DATE DATE Yes
NBRBJOB_DEFER_BAL NBRBJOB_DEFER_BAL NUMBER(11,2) No
NBRBJOB_CONTRACT_TYPE NBRBJOB_CONTRACT_TYPE VARCHAR2(1) No
NBRBJOB_SALARY_ENCUMBRANCE NBRBJOB_SALARY_ENCUMBRANCE NUMBER(11,2) No
NBRBJOB_CONTRACT_BEGIN_DATE NBRBJOB_CONTRACT_BEGIN_DATE DATE Yes
NBRBJOB_CONTRACT_END_DATE NBRBJOB_CONTRACT_END_DATE DATE Yes
NBRBJOB_TOTAL_CONTRACT_HRS NBRBJOB_TOTAL_CONTRACT_HRS NUMBER(6,2) Yes
NBRBJOB_TOTAL_ENCUMBRANCE_HRS NBRBJOB_TOTAL_ENCUMBRANCE_HRS NUMBER(6,2) Yes
NBRBJOB_STEP_INCR_MON NBRBJOB_STEP_INCR_MON VARCHAR2(2) Yes
NBRBJOB_STEP_INCR_DAY NBRBJOB_STEP_INCR_DAY VARCHAR2(2) Yes
NBRBJOB_COAS_CODE NBRBJOB_COAS_CODE VARCHAR2(1) Yes
NBRBJOB_ACTIVITY_DATE NBRBJOB_ACTIVITY_DATE DATE No
NBRBJOB_ACCRUE_LEAVE_IND NBRBJOB_ACCRUE_LEAVE_IND VARCHAR2(1) No
NBRBJOB_CIVIL_SERVICE_IND NBRBJOB_CIVIL_SERVICE_IND VARCHAR2(1) Yes
NBRBJOB_ENCUMBRANCE_CHANGE_IND NBRBJOB_ENCUMBRANCE_CHANGE_IND VARCHAR2(1) No
NBRBJOB_FRINGE_ENCUMBRANCE NBRBJOB_FRINGE_ENCUMBRANCE NUMBER(11,2) Yes
NBRBJOB_IPEDS_REPT_IND NBRBJOB_IPEDS_REPT_IND VARCHAR2(1) No
NBRBJOB_FACL_STATSCAN_REPT_IND NBRBJOB_FACL_STATSCAN_REPT_IND VARCHAR2(1) No
NBRBJOB_PROBATION_BEGIN_DATE NBRBJOB_PROBATION_BEGIN_DATE DATE Yes
NBRBJOB_PROBATION_END_DATE NBRBJOB_PROBATION_END_DATE DATE Yes
NBRBJOB_PROBATION_UNITS NBRBJOB_PROBATION_UNITS NUMBER(3,0) Yes
NBRBJOB_ELIGIBLE_DATE NBRBJOB_ELIGIBLE_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
NBRBJOB_POSN NBBPOSN_POSN NBBPOSN
NBRBJOB_PIDM PERJLEV_PIDM PERJLEV
NBRBJOB_POSN PERJLEV_POSN PERJLEV
NBRBJOB_SUFF PERJLEV_SUFF PERJLEV
NBRBJOB_PIDM NBRJOBS_PIDM NBRJOBS
NBRBJOB_POSN NBRJOBS_POSN NBRJOBS
NBRBJOB_SUFF NBRJOBS_SUFF NBRJOBS
NBRBJOB_PIDM NBREARN_PIDM NBREARN
NBRBJOB_POSN NBREARN_POSN NBREARN
NBRBJOB_SUFF NBREARN_SUFF NBREARN
NBRBJOB_PIDM NBRJOBS_PIDM NBRJOBS
NBRBJOB_POSN NBRJOBS_POSN NBRJOBS
NBRBJOB_SUFF NBRJOBS_SUFF NBRJOBS

Index

Index Name Index Type Column Name
NBRBJOB_KEY2_INDEX NBRBJOB_PIDM
NBRBJOB_KEY2_INDEX NBRBJOB_CONTRACT_TYPE
NBRBJOB_KEY_INDEX NBRBJOB_POSN
PK_NBRBJOB Unique NBRBJOB_PIDM
PK_NBRBJOB Unique NBRBJOB_POSN
PK_NBRBJOB Unique NBRBJOB_SUFF

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
acquire_locks C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use()
calc_salary C/C++ Function [F:\BANNER\C\SIRASGQ.PC] Use(select )
check_multiple_employment_status C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
enc_body C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(update )
get_coll_appointment C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use(select )
get_member_status C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use(select )
get_perdemo_empl_status C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
get_tmp_salary_rate C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use(select )
ins_pertwfa C/C++ Function [F:\BANNER\C\PERWFAN.PC] Use(select )
ins_pertwfa C/C++ Function [F:\BANNER\C\PERPGAN.PC] Use(select )
ins_pertwfa C/C++ Function [F:\BANNER\C\PERPHIR.PC] Use(select )
ins_pertwfa C/C++ Function [F:\BANNER\C\PERPTER.PC] Use(select )
ins_pertwfa C/C++ Function [F:\BANNER\C\PERUTAN.PC] Use(select )
ins_phraccr_bank_rolls C/C++ Function [F:\BANNER\C\PHPLEAV.PC] Use(select )
load_nbrbjob C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use(select )
print_index_by_ftvorgn C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
print_index_by_last_name C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
print_index_by_ptvorgn C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
process_fisc_encumbrance C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use(update )
sel_5_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_accrue_level1 C/C++ Function [F:\BANNER\C\PHPLEAV.PC] Use(select )
sel_accrue_level1_job C/C++ Function [F:\BANNER\C\PHPLEAV.PC] Use(select )
sel_accrue_min_hrs C/C++ Function [F:\BANNER\C\PHPLEAV.PC] Use(select )
sel_accrue_min_hrs_job C/C++ Function [F:\BANNER\C\PHPLEAV.PC] Use(select )
sel_accrue_pro_hrs C/C++ Function [F:\BANNER\C\PHPLEAV.PC] Use(select )
sel_accrue_pro_hrs_job C/C++ Function [F:\BANNER\C\PHPLEAV.PC] Use(select )
sel_all_newhire C/C++ Function [F:\BANNER\C\PERV100.PC] Use(select )
sel_ann_salary C/C++ Function [F:\BANNER\C\PDPCFLX.PC] Use(select )
sel_ann_salary C/C++ Function [F:\BANNER\C\PDPLIFE.PC] Use(select )
sel_annual_salary C/C++ Function [F:\BANNER\C\PEPCSAL.PC] Use(select )
sel_appl_rule_cnt C/C++ Function [F:\BANNER\C\PERHIRE.PC] Use(select )
sel_base_hrs C/C++ Function [F:\BANNER\C\PEPPCRE.PC] Use(select )
sel_ben_cnt C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_ben_pidm C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_bjob_crol C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(select )
sel_budget_s_sala_h C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_budget_s_sala_s C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_budget_s_step_zero C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_budget_v C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_college C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use(select )
sel_contract_cnt C/C++ Function [F:\BANNER\C\PEREO4D.PC] Use(select )
sel_contract_cnt C/C++ Function [F:\BANNER\C\PEREO6D.PC] Use(select )
sel_contract_cnt C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_contract_cnt_con C/C++ Function [F:\BANNER\C\PEREO1D.PC] Use(select )
sel_contract_cnt_dist C/C++ Function [F:\BANNER\C\PEREO5D.PC] Use(select )
sel_contract_cnt_locn C/C++ Function [F:\BANNER\C\PEREO1D.PC] Use(select )
sel_contract_cnt_schl C/C++ Function [F:\BANNER\C\PEREO5D.PC] Use(select )
sel_dept_total C/C++ Function [F:\BANNER\C\PERLEAV.PC] Use(select )
sel_dept_total_jlev C/C++ Function [F:\BANNER\C\PERLEAV.PC] Use(select )
sel_disabled C/C++ Function [F:\BANNER\C\PERV100.PC] Use(select )
sel_disabled_newhire C/C++ Function [F:\BANNER\C\PERV100.PC] Use(select )
sel_ejob C/C++ Function [F:\BANNER\C\NBPSPUP.PC] Use(select )
sel_empl C/C++ Function [F:\BANNER\C\PEREO4D.PC] Use(select )
sel_empl C/C++ Function [F:\BANNER\C\PEREO6D.PC] Use(select )
sel_empl_con C/C++ Function [F:\BANNER\C\PEREO1D.PC] Use(select )
sel_empl_dist C/C++ Function [F:\BANNER\C\PEREO5D.PC] Use(select )
sel_empl_info C/C++ Function [F:\BANNER\C\PERLEAV.PC] Use(select )
sel_empl_info C/C++ Function [F:\BANNER\C\PHRROST.PC] Use(select )
sel_empl_info C/C++ Function [F:\BANNER\C\PHRDSTT.PC] Use(select )
sel_empl_info C/C++ Function [F:\BANNER\C\PHRTMSH.PC] Use(select )
sel_empl_info_jlev C/C++ Function [F:\BANNER\C\PERLEAV.PC] Use(select )
sel_empl_locn C/C++ Function [F:\BANNER\C\PEREO1D.PC] Use(select )
sel_empl_schl C/C++ Function [F:\BANNER\C\PEREO5D.PC] Use(select )
sel_eskl_cnt C/C++ Function [F:\BANNER\C\PEREO41.PC] Use(select )
sel_eskl_cnt C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_eskl_code_cnt C/C++ Function [F:\BANNER\C\PEREO41.PC] Use(select )
sel_eskl_code_cnt C/C++ Function [F:\BANNER\C\PEREO4D.PC] Use(select )
sel_eskl_code_cnt C/C++ Function [F:\BANNER\C\PEREO6D.PC] Use(select )
sel_eskl_code_cnt C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_eskl_code_cnt_con C/C++ Function [F:\BANNER\C\PEREO1D.PC] Use(select )
sel_eskl_code_cnt_dist C/C++ Function [F:\BANNER\C\PEREO5D.PC] Use(select )
sel_eskl_code_cnt_locn C/C++ Function [F:\BANNER\C\PEREO1D.PC] Use(select )
sel_eskl_code_cnt_schl C/C++ Function [F:\BANNER\C\PEREO5D.PC] Use(select )
sel_ethn_cnt C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_faculty C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_ftvorgn_title C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
sel_full_mem C/C++ Function [F:\BANNER\C\PEREO51.PC] Use(select )
sel_full_mem C/C++ Function [F:\BANNER\C\PEREO52.PC] Use(select )
sel_function C/C++ Function [F:\BANNER\C\PEREO41.PC] Use(select )
sel_function C/C++ Function [F:\BANNER\C\PEREO4D.PC] Use(select )
sel_grand_total C/C++ Function [F:\BANNER\C\PERLEAV.PC] Use(select )
sel_grand_total_jlev C/C++ Function [F:\BANNER\C\PERLEAV.PC] Use(select )
sel_hire_fac_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_hire_mem C/C++ Function [F:\BANNER\C\PEREO41.PC] Use(select )
sel_hire_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_hire_mem C/C++ Function [F:\BANNER\C\PEREO52.PC] Use(select )
sel_hire_mem C/C++ Function [F:\BANNER\C\PEREO51.PC] Use(select )
sel_hire_other_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_job C/C++ Function [F:\BANNER\C\PERCAF7.PC] Use(select )
sel_job_exists C/C++ Function [F:\BANNER\C\PDPLIFE.PC] Use(select )
sel_job_info C/C++ Function [F:\BANNER\C\PERLEAV.PC] Use(select )
sel_job_table C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_jobs C/C++ Function [F:\BANNER\C\PERHIRE.PC] Use(select )
sel_jobs C/C++ Function [F:\BANNER\C\PHPTIME.PC] Use(select )
sel_jobs C/C++ Function [F:\BANNER\C\PERTERM.PC] Use(select )
sel_jobs_enc_hrs C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(select )
sel_jobs_fte C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_jobs_fte C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use(select )
sel_location C/C++ Function [F:\BANNER\C\PEREO12.PC] Use(select )
sel_location C/C++ Function [F:\BANNER\C\PEREO11.PC] Use(select )
sel_mem C/C++ Function [F:\BANNER\C\PEREO11.PC] Use(select )
sel_mem C/C++ Function [F:\BANNER\C\PEREO12.PC] Use(select )
sel_min_eff_date C/C++ Function [F:\BANNER\C\PDPLIFE.PC] Use(select )
sel_mm_dd_step_incr C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(select )
sel_newly_separated_newhire C/C++ Function [F:\BANNER\C\PERV100.PC] Use(select )
sel_no_action_empl C/C++ Function [F:\BANNER\C\PHRDCON.PC] Use(select )
sel_non_faculty C/C++ Function [F:\BANNER\C\PEPAEXT.PC] Use(select )
sel_other_veterans C/C++ Function [F:\BANNER\C\PERV100.PC] Use(select )
sel_other_veterans_newhire C/C++ Function [F:\BANNER\C\PERV100.PC] Use(select )
sel_part_mem C/C++ Function [F:\BANNER\C\PEREO51.PC] Use(select )
sel_part_mem C/C++ Function [F:\BANNER\C\PEREO52.PC] Use(select )
sel_part_mem C/C++ Function [F:\BANNER\C\PEREO41.PC] Use(select )
sel_part_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_pebempl C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
sel_pebempl1 C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
sel_per_empl C/C++ Function [F:\BANNER\C\PHRDCON.PC] Use(select )
sel_pidm_on_strength C/C++ Function [F:\BANNER\C\PHRLGST.PC] Use(select )
sel_pidms C/C++ Function [F:\BANNER\C\BWPREDIR.PC] Use(select )
sel_pidms_by_ftvorgn C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
sel_pidms_by_last_name C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
sel_pidms_by_ptvorgn C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
sel_position_class C/C++ Function [F:\BANNER\C\NBRPINC.PC] Use(select )
sel_positions C/C++ Function [F:\BANNER\C\PERORGC.PC] Use(select )
sel_posns_inc C/C++ Function [F:\BANNER\C\NBRBWRK.PC] Use(select )
sel_ptvorgn_title C/C++ Function [F:\BANNER\C\HWPREDIR.PC] Use(select )
sel_rank_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_rev_empl C/C++ Function [F:\BANNER\C\NBRPINC.PC] Use(select )
sel_salary_ratio C/C++ Function [F:\BANNER\C\PERAPND.PC] Use(select )
sel_step_incr_others C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(select )
sel_step_zero C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(select )
sel_temp_info C/C++ Function [F:\BANNER\C\PHRDSTT.PC] Use(select )
sel_temp_info C/C++ Function [F:\BANNER\C\PHRORGT.PC] Use(select )
sel_temp_info C/C++ Function [F:\BANNER\C\PHRTMSH.PC] Use(select )
sel_temp_info C/C++ Function [F:\BANNER\C\PHRROST.PC] Use(select )
sel_ten_other C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_term_empl C/C++ Function [F:\BANNER\C\PERTERM.PC] Use(select )
sel_total_empcnt C/C++ Function [F:\BANNER\C\PERHIRE.PC] Use(select )
sel_total_empcnt C/C++ Function [F:\BANNER\C\PERTERM.PC] Use(select )
sel_total_ethn_cnt C/C++ Function [F:\BANNER\C\PERHIRE.PC] Use(select )
sel_total_ethn_cnt C/C++ Function [F:\BANNER\C\PERTERM.PC] Use(select )
sel_total_female_cnt C/C++ Function [F:\BANNER\C\PERHIRE.PC] Use(select )
sel_total_female_cnt C/C++ Function [F:\BANNER\C\PERTERM.PC] Use(select )
sel_total_male_cnt C/C++ Function [F:\BANNER\C\PERHIRE.PC] Use(select )
sel_total_male_cnt C/C++ Function [F:\BANNER\C\PERTERM.PC] Use(select )
sel_total_trea_rule_cnt C/C++ Function [F:\BANNER\C\PERTERM.PC] Use(select )
sel_trainee C/C++ Function [F:\BANNER\C\PEREO11.PC] Use(select )
sel_trainee C/C++ Function [F:\BANNER\C\PEREO12.PC] Use(select )
sel_trea_rule_cnt C/C++ Function [F:\BANNER\C\PERTERM.PC] Use(select )
sel_university_ft C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use(select )
sel_university_pt C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use(select )
sel_var_jobs C/C++ Function [F:\BANNER\C\PEPPCRE.PC] Use(select )
sel_vietnam C/C++ Function [F:\BANNER\C\PERV100.PC] Use(select )
sel_vietnam_newhire C/C++ Function [F:\BANNER\C\PERV100.PC] Use(select )
upd_bjob_crol C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(update )
upd_nbrbjob_defer C/C++ Function [F:\BANNER\C\PHPUPDT.PC] Use(update,select )
upd_nbrbjob_defer_sub C/C++ Function [F:\BANNER\C\PHPUPDT.PC] Use(update,select )
upd_prev_jobs_enc_hrs C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(update )
NBRBJOB SYNONYM S4B70.PUBLIC Rely on ()
NPRCOLR TABLE S4B70.POSNCTL Join
PEBEMPL TABLE S4B70.PAYROLL Join
PERGRPA TABLE S4B70.PAYROLL Refer( No Action )
PERJBBG TABLE S4B70.PAYROLL Refer( No Action )
PERJOBS TABLE S4B70.PAYROLL Join
PERJTOT TABLE S4B70.PAYROLL Refer( No Action )
PERPADV TABLE S4B70.PAYROLL Refer( No Action )
PERXJOB TABLE S4B70.PAYROLL Refer( No Action )
PHRJOBS TABLE S4B70.PAYROLL Refer( No Action )
PPRCOLR TABLE S4B70.PAYROLL Join
SPRIDEN TABLE S4B70.SATURN Join
AN_EMPLOYEE_POSITION VIEW S4B70.BANINST1 Use(select )
NBVPINC VIEW S4B70.BANINST1 Use(select )
PEVACP2 VIEW S4B70.BANINST1 Use(select )
PEVEPRO VIEW S4B70.BANINST1 Use(select )
PEVJLEV VIEW S4B70.BANINST1 Use(select )
PEVJOB1 VIEW S4B70.BANINST1 Use(select )
PEVJOBS VIEW S4B70.BANINST1 Use(select )
PEVPRF1 VIEW S4B70.BANINST1 Use(select )
PEVREC1 VIEW S4B70.BANINST1 Use(select )
PEVRTWK VIEW S4B70.BANINST1 Use(select )
PHVTIME VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NBAPBUD.NBBPOSN.NBBPOSN_BEGIN_DATE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEAXJOB.PERXJOB.PERXJOB_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NBIPLST.NBIPLST.NBBPOSN_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PHAADJT.PHRJOBS.PHRJOBS_EFFECTIVE_DATE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEIFACT.KEY_BLOCK.SUFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PHAADJT.PHRJOBS.PHRJOBS_EFFECTIVE_DATE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEAHSIN.PERHSIP.ID Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NBIPORG.NBAPORG.NBBPOSN_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NBAJOBS.KEY_BLOCK.QUERY_DATE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NBIPLST.NBIPLST.NBBPOSN_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NTRRQUE.NTRRQUE.NTRRQUE_APPR_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NBAPBUD.NBBPOSN.NBBPOSN_BEGIN_DATE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEAFACT.KEY_BLOCK.ID Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEAFACT.ACTION_KEY.SUFF_CODE3 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PEAXJOB.PERXJOB.PERXJOB_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEIFACT.KEY_BLOCK.SUFF Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEAHSIN.PERHSIP.ID Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NBIPORG.NBAPORG.NBBPOSN_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NBAJOBS.KEY_BLOCK.QUERY_DATE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEAFACT.ACTION_KEY.SUFF_CODE3 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PEAFACT.KEY_BLOCK.ID Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NTRRQUE.NTRRQUE.NTRRQUE_APPR_POSN Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.PEAGREV.PERGRPA.ID Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.NBAJQUE.NBRRJQE.NBRRJQE_APPR_POSN Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.PEAGREV.PERGRPA.ID Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.NBAJQUE.NBRRJQE.NBRRJQE_APPR_POSN Use(select )
CALC_PTOT_AVAIL Forms Trigger BANNER7_FORMS.NBAJOBS Use(select )
CALC_PTOT_AVAIL Forms Trigger BANNER7_FORMS_10G.NBAJOBS Use(select )
CHECK_ALREADY_TERMED Forms Trigger BANNER7_FORMS.PEAESCH Use(select )
CHECK_ALREADY_TERMED Forms Trigger BANNER7_FORMS_10G.PEAESCH Use(select )
CHECK_DEFAULT Forms Trigger BANNER7_FORMS.PEAROEC Use(select )
CHECK_DEFAULT Forms Trigger BANNER7_FORMS_10G.PEAROEC Use(select )
CHECK_EMPLOYEE Forms Trigger BANNER7_FORMS.FRAPROP Use(select )
CHECK_EMPLOYEE Forms Trigger BANNER7_FORMS_10G.FRAPROP Use(select )
CHECK_EMPLOYEE Forms Trigger BANNER7_FORMS_10G.FRAGRNT Use(select )
CHECK_EMPLOYEE Forms Trigger BANNER7_FORMS.FRAGRNT Use(select )
CHECK_JOB Forms Trigger BANNER7_FORMS.PEAGREV Use(select )
CHECK_JOB Forms Trigger BANNER7_FORMS_10G.PEAHSIN Use(select )
CHECK_JOB Forms Trigger BANNER7_FORMS_10G.NBIWKSH Use(select )
CHECK_JOB Forms Trigger BANNER7_FORMS_10G.PEAGREV Use(select )
CHECK_JOB Forms Trigger BANNER7_FORMS.NBIWKSH Use(select )
CHECK_JOB Forms Trigger BANNER7_FORMS.PEAHSIN Use(select )
CHECK_JOB_STATUS Forms Trigger BANNER7_FORMS.PEATMVF Use(select )
CHECK_JOB_STATUS Forms Trigger BANNER7_FORMS_10G.PEATMVF Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS.NBAJFTE Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS_10G.NBAJFTE Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS.NBAJQUE Use(select )
CHECK_KEYS Forms Trigger BANNER7_FORMS_10G.NBAJQUE Use(select )
CHECK_LEAVE_END_DATE Forms Trigger BANNER7_FORMS.PEAESCH Use(select )
CHECK_LEAVE_END_DATE Forms Trigger BANNER7_FORMS_10G.PEAESCH Use(select )
CHECK_LOA_BEG_DATE Forms Trigger BANNER7_FORMS.PEAESCH Use(select )
CHECK_LOA_BEG_DATE Forms Trigger BANNER7_FORMS_10G.PEAESCH Use(select )
CHECK_LREA_ENTERED Forms Trigger BANNER7_FORMS.PEAESCH Use(select )
CHECK_LREA_ENTERED Forms Trigger BANNER7_FORMS_10G.PEAESCH Use(select )
CHECK_POSN Forms Trigger BANNER7_FORMS.PEADADJ Use(select )
CHECK_POSN Forms Trigger BANNER7_FORMS_10G.PEADADJ Use(select )
CHECK_POSN_EXISTS Forms Trigger BANNER7_FORMS.NOAEPAF Use(select )
CHECK_POSN_EXISTS Forms Trigger BANNER7_FORMS_10G.NOAEPAF Use(select )
CHECK_SUPERVISOR Forms Trigger BANNER7_FORMS.NBAJOBS Use(select )
CHECK_SUPERVISOR Forms Trigger BANNER7_FORMS.PEAESCH Use(select )
CHECK_SUPERVISOR Forms Trigger BANNER7_FORMS_10G.NBAJOBS Use(select )
CHECK_SUPERVISOR Forms Trigger BANNER7_FORMS_10G.PEAESCH Use(select )
CHECK_TREA_ENTERED Forms Trigger BANNER7_FORMS.PEAESCH Use(select )
CHECK_TREA_ENTERED Forms Trigger BANNER7_FORMS_10G.PEAESCH Use(select )
DEL_BJOB Forms Trigger BANNER7_FORMS.NBAJOBS Use(delete )
DEL_BJOB Forms Trigger BANNER7_FORMS_10G.NBAJOBS Use(delete )
EDIT_CHK_FOR_PRIMARY Forms Trigger BANNER7_FORMS.NBAJOBS Use(select )
EDIT_CHK_FOR_PRIMARY Forms Trigger BANNER7_FORMS_10G.NBAJOBS Use(select )
EDIT_EDATE Forms Trigger BANNER7_FORMS.NBAPBUD Use(select )
EDIT_EDATE Forms Trigger BANNER7_FORMS.NBAPOSN Use(select )
EDIT_EDATE Forms Trigger BANNER7_FORMS_10G.NBAPOSN Use(select )
EDIT_EDATE Forms Trigger BANNER7_FORMS_10G.NBAPBUD Use(select )
EDIT_EMPL_TERM_DATE Forms Trigger BANNER7_FORMS.PEAESCH Use(select )
EDIT_EMPL_TERM_DATE Forms Trigger BANNER7_FORMS_10G.PEAESCH Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS.NBIJLHS Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS.PEADADJ Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS.PEIJHIS Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS.PEAJCDD Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS_10G.PEADADJ Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS_10G.PEAJCDD Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS_10G.PEIJTOT Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS_10G.NBIJLHS Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS_10G.PEIJHIS Use(select )
EDIT_FOR_PJOB Forms Trigger BANNER7_FORMS.PEIJTOT Use(select )
EDIT_FROSEN_POSN Forms Trigger BANNER7_FORMS.NBAJOBS Use(select )