NBBFISC NBBPOSN NBBWKSH NBRBHIS NBRBJLH NBRBJOB NBRBJQE NBRCLSH NBREARN NBREHDR NBREJLD NBREJOB NBREPLD NBREPSA NBRERRN NBRFCLD NBRFTOT NBRJFTE NBRJLBD NBRJLHS NBRJOBS NBRLOCK NBRPLBD NBRPOSH NBRPTOT NBRRJQE NBRRTOT NBRSALC NBRSPLC NBRWKSH NBRXDED NBTEMPF NBTFPRM NBTFTOT NBTJERR NBTJOBF NBTORSF NBTPERR NBTPLBD NBTPOSF NBTPTOT NBTRTOT NHRDIST NHRECRT NHRENCD NHRFINC NHRSDST NHRTBUD NOBTRAN NOREAER NORROUT NORTERN NORTLBD NORTRAN NPRCOLR NSRSPSC NTRACAT NTRACLV NTRADFV NTRALVL NTRAPFB NTRAPFD NTRAUBK NTRAUFD NTRAUFM NTRBQUE NTRBROL NTRCROL NTRFBEX NTRFBIN NTRFELD NTRFINI NTRFRNG NTRHROL NTRINST NTRJINC NTRJINR NTRJOBP NTRJTGR NTRJTPC NTRJTRL NTRJTST NTRLVID NTRPCLS NTRPROX NTRROUT NTRRQUE NTRSALA NTRSALB NTRSGRP NTRSPBU NTRSPEC NTRSPEX NTRSPPR NTRSTGR NTRSTRL NTRTPRX NTRWKSH NTVACAT NTVAPTY NTVBPRO NTVDOTT NTVJOBP NTVPFOC NTVPNOC NTVWKSH NURVERS PEBEMPL

Model Position Control


Model Label : Banner HR Position Control Module
Path : Default Folder/B70/posnctl/Position Control

List of Objects

Object Name Object Type Layer Name
NBBFISC TABLE Default
NBBPOSN TABLE Main Objects
NBBWKSH TABLE Main Objects
NBRBHIS TABLE Default
NBRBJLH TABLE Default
NBRBJOB TABLE Main Objects
NBRBJQE TABLE Default
NBRCLSH TABLE Default
NBREARN TABLE Default
NBREHDR TABLE Default
NBREJLD TABLE Default
NBREJOB TABLE Default
NBREPLD TABLE Default
NBREPSA TABLE Default
NBRERRN TABLE Default
NBRFCLD TABLE Default
NBRFTOT TABLE Default
NBRJFTE TABLE Default
NBRJLBD TABLE Default
NBRJLHS TABLE Default
NBRJOBS TABLE Default
NBRLOCK TABLE Default
NBRPLBD TABLE Default
NBRPOSH TABLE Default
NBRPTOT TABLE Default
NBRRJQE TABLE Default
NBRRTOT TABLE Default
NBRSALC TABLE Default
NBRSPLC TABLE Default
NBRWKSH TABLE Default
NBRXDED TABLE Default
NBTEMPF TABLE Default
NBTFPRM TABLE Default
NBTFTOT TABLE Default
NBTJERR TABLE Default
NBTJOBF TABLE Default
NBTORSF TABLE Default
NBTPERR TABLE Default
NBTPLBD TABLE Default
NBTPOSF TABLE Default
NBTPTOT TABLE Default
NBTRTOT TABLE Default
NHRDIST TABLE Default
NHRECRT TABLE Default
NHRENCD TABLE Default
NHRFINC TABLE Default
NHRSDST TABLE Default
NHRTBUD TABLE Default
NOBTRAN TABLE Default
NOREAER TABLE Default
NORROUT TABLE Default
NORTERN TABLE Default
NORTLBD TABLE Default
NORTRAN TABLE Default
NPRCOLR TABLE Default
NSRSPSC TABLE Default
NTRACAT TABLE Default
NTRACLV TABLE Default
NTRADFV TABLE Default
NTRALVL TABLE Default
NTRAPFB TABLE Default
NTRAPFD TABLE Default
NTRAUBK TABLE Default
NTRAUFD TABLE Default
NTRAUFM TABLE Default
NTRBQUE TABLE Default
NTRBROL TABLE Default
NTRCROL TABLE Default
NTRFBEX TABLE Default
NTRFBIN TABLE Default
NTRFELD TABLE Default
NTRFINI TABLE Default
NTRFRNG TABLE Default
NTRHROL TABLE Default
NTRINST TABLE Default
NTRJINC TABLE Default
NTRJINR TABLE Default
NTRJOBP TABLE Default
NTRJTGR TABLE Default
NTRJTPC TABLE Default
NTRJTRL TABLE Default
NTRJTST TABLE Default
NTRLVID TABLE Default
NTRPCLS TABLE Default
NTRPROX TABLE Default
NTRROUT TABLE Default
NTRRQUE TABLE Default
NTRSALA TABLE Default
NTRSALB TABLE Default
NTRSGRP TABLE Default
NTRSPBU TABLE Default
NTRSPEC TABLE Default
NTRSPEX TABLE Default
NTRSPPR TABLE Default
NTRSTGR TABLE Default
NTRSTRL TABLE Default
NTRTPRX TABLE Default
NTRWKSH TABLE Default
NTVACAT TABLE Default
NTVAPTY TABLE Default
NTVBPRO TABLE Default
NTVDOTT TABLE Default
NTVJOBP TABLE Default
NTVPFOC TABLE Default
NTVPNOC TABLE Default
NTVWKSH TABLE Default
NURVERS TABLE Default
PEBEMPL TABLE Default

Comments

Model View

''

Table NBBFISC

Schema Name POSNCTL
Label NBBFISC
Server name S4B70
Creation Date 08/11/2004 10:33:26:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
NBBFISC_CODE NBBFISC_CODE VARCHAR2(4) No
NBBFISC_COAS_CODE NBBFISC_COAS_CODE VARCHAR2(1) Yes
NBBFISC_ACTIVE_IND NBBFISC_ACTIVE_IND VARCHAR2(1) No
NBBFISC_BEGIN_DATE NBBFISC_BEGIN_DATE DATE No
NBBFISC_END_DATE NBBFISC_END_DATE DATE No
NBBFISC_ACTIVITY_DATE NBBFISC_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
NBBFISC_KEY_INDEX Unique NBBFISC_CODE
NBBFISC_KEY_INDEX Unique NBBFISC_COAS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
nbpbrol.pc C/C++ File N/A Use(select )
sel_fisc_begin_date C/C++ Function [F:\BANNER\C\NHRSDST.PC] Use(select )
4500-DECLARE-AND-LOAD-NBBFISC Cobol Paragraph [F:\banner\cobol].PHPFEXP.AA-COMMAND-SECT-END Use(select )
8915-TRANS-DATE-AND-FISC-CODE Cobol Paragraph [F:\banner\cobol].PHPFEXP.AA-COMMAND-SECT-END Use()
8925-FIND-NBBFISC-ENTRY Cobol Paragraph [F:\banner\cobol].PHPFEXP.AA-COMMAND-SECT-END Use()
acquire_locks C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use()
check_fisc_year C/C++ Function [F:\BANNER\C\NHRBDST.PC] Use(select )
enc_body C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(select )
get_perdemo_annual_stipend C/C++ Function [F:\BANNER\C\PEPEDEX.PC] Use(select )
invalidNBBFISC C/C++ Function [F:\BANNER\C\NBPSPUP.PC] Use(select )
load_nbbfisc C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use(select )
sel_bank_rec C/C++ Function [F:\BANNER\C\PHPCDIR.PC] Use(select )
sel_bank_rec C/C++ Function [F:\BANNER\C\PHPDIRD.PC] Use(select )
sel_budget_fcld C/C++ Function [F:\BANNER\C\NHPFIN1.PC] Use(select )
sel_budget_plbd C/C++ Function [F:\BANNER\C\NHPFIN1.PC] Use(select )
sel_chk_fiscal C/C++ Function [F:\BANNER\C\PHPMTIM.PC] Use(select )
sel_chk_fiscal C/C++ Function [F:\BANNER\C\PHPTIME.PC] Use(select )
sel_chk_fiscal C/C++ Function [F:\BANNER\C\PHRDSTT.PC] Use(select )
sel_chk_fiscal C/C++ Function [F:\BANNER\C\PHRROST.PC] Use(select )
sel_chk_fiscal C/C++ Function [F:\BANNER\C\PHRTMSH.PC] Use(select )
sel_chk_fiscal C/C++ Function [F:\BANNER\C\PHRORGT.PC] Use(select )
sel_cobra C/C++ Function [F:\BANNER\C\NHPFIN1.PC] Use(select )
sel_encumbrance C/C++ Function [F:\BANNER\C\NHPFIN1.PC] Use(select )
sel_end_fisc_info C/C++ Function [F:\BANNER\C\PHPRETO.PC] Use(select )
sel_feed_dtl C/C++ Function [F:\BANNER\C\FBRFEED.PC] Use(select )
sel_fisc_begin_date C/C++ Function [F:\BANNER\C\NHRDIST.PC] Use(select )
sel_fisc_dates C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use(select )
sel_fisc_end_date C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_fiscal C/C++ Function [F:\BANNER\C\PHPMTIM.PC] Use(select )
sel_fiscal C/C++ Function [F:\BANNER\C\PHPTIME.PC] Use(select )
sel_fiscal C/C++ Function [F:\BANNER\C\PHRDSTT.PC] Use(select )
sel_fiscal C/C++ Function [F:\BANNER\C\PHRTMSH.PC] Use(select )
sel_fiscal C/C++ Function [F:\BANNER\C\PHRROST.PC] Use(select )
sel_fiscal C/C++ Function [F:\BANNER\C\PHRORGT.PC] Use(select )
sel_ftot_master C/C++ Function [F:\BANNER\C\NHPFIN1.PC] Use(select )
sel_home_orgn_title C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_home_orgn_title C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use(select )
sel_ind_fiscal C/C++ Function [F:\BANNER\C\PHPTIME.PC] Use(select )
sel_ind_fiscal C/C++ Function [F:\BANNER\C\PHRDSTT.PC] Use(select )
sel_ind_fiscal C/C++ Function [F:\BANNER\C\PHRORGT.PC] Use(select )
sel_ind_fiscal C/C++ Function [F:\BANNER\C\PHRROST.PC] Use(select )
sel_ind_fiscal C/C++ Function [F:\BANNER\C\PHRTMSH.PC] Use(select )
sel_job_table C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_nbbfisc_begin C/C++ Function [F:\BANNER\C\PDPF496.PC] Use(select )
sel_nbbfisc_end C/C++ Function [F:\BANNER\C\PDPF496.PC] Use(select )
sel_posn_active C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_posn_all C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_posn_cancel C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_posn_frozen C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_posn_info C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use(select )
sel_posn_info1 C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use(select )
sel_posns C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_prev_fisc_date C/C++ Function [F:\BANNER\C\NBRBWRK.PC] Use(select )
sel_prop_fisc_end_date C/C++ Function [F:\BANNER\C\NBRBWRK.PC] Use(select )
sel_ptot_fcld_d C/C++ Function [F:\BANNER\C\NHPFIN1.PC] Use(select )
sel_ptvorgn_title C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_ptvorgn_title C/C++ Function [F:\BANNER\C\NBRPSTA.PC] Use(select )
sel_rev_empl C/C++ Function [F:\BANNER\C\NBRPINC.PC] Use(select )
sel_rtot_master C/C++ Function [F:\BANNER\C\NHPFIN1.PC] Use(select )
sel_start_fisc_info C/C++ Function [F:\BANNER\C\PHPRETO.PC] Use(select )
sel_table C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_total_posn C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_total_posn_active C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_total_posn_cancel C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_total_posn_frozen C/C++ Function [F:\BANNER\C\NBRPOSN.PC] Use(select )
sel_valid_current_fisc C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_valid_recast_coas_code C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use(select )
sel_valid_recast_date C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use(select )
sel_valid_year C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
sel_valid_year C/C++ Function [F:\BANNER\C\NBRBWRK.PC] Use(select )
upd_fisc_cur C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(update )
upd_fisc_new C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(update )
upd_prev_jobs_enc_hrs C/C++ Function [F:\BANNER\C\NBPMASS.PC] Use(select )
upd_validate_coas_code C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
upd_validate_coas_code C/C++ Function [F:\BANNER\C\NBRBWRK.PC] Use(select )
upd_validate_coas_code C/C++ Function [F:\BANNER\C\NBPBUDM.PC] Use(select )
upd_validate_coas_d C/C++ Function [F:\BANNER\C\NBPBROL.PC] Use(select )
validate_tax_year C/C++ Function [F:\BANNER\C\PEP1042.PC] Use(select )
NBRPTOT TABLE S4B70.POSNCTL Join
NTRFINI TABLE S4B70.POSNCTL Join
AN_FISCAL_YEAR VIEW S4B70.BANINST1 Use(select )
PBVSLB1 VIEW S4B70.BANINST1 Use(select )
PEVACP2 VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NTRBROL.KEY_BLOCK.FISC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.PTRCALN.PTRCALN.PTRCALN_FISC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NBIPORG.NBAPORG.NBBPOSN_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NTRFINI.NTRFINI.NTRFINI_FISC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NTRFINI.NTRFINI.NTRFINI_COAS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NTRFINI.NTRFINI_EXTERN.NTRFINI_FISC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NBIPLST.NBIPLST.NBBPOSN_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.NTRBROL.KEY_BLOCK.FISC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.PTRCALN.PTRCALN.PTRCALN_FISC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NBIPORG.NBAPORG.NBBPOSN_POSN Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NTRFINI.NTRFINI_EXTERN.NTRFINI_FISC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NTRFINI.NTRFINI.NTRFINI_FISC_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NTRFINI.NTRFINI.NTRFINI_COAS_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.NBIPLST.NBIPLST.NBBPOSN_POSN Use(select )
POST_CHANGE Forms Trigger BANNER7_FORMS.NTRFINI.NTRFINI_EXTERN.NTRFINI_COAS_CODE Use(select )
POST_CHANGE Forms Trigger BANNER7_FORMS_10G.NTRFINI.NTRFINI_EXTERN.NTRFINI_COAS_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.NTRSPEX.NTRSPEC.NTRSPEC_JOBS_EFFECTIVE_DATE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.PEAHIRE.JOBS.POSN Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.PEAHIRE.JOBS.POSN Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.NBAFISC.NBBFISC.NBBFISC_ACTIVE_IND Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.NTRSPEX.NTRSPEC.NTRSPEC_JOBS_EFFECTIVE_DATE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.NBAFISC.NBBFISC.NBBFISC_ACTIVE_IND Use(select )
CALC_CUR_FISC Forms Trigger BANNER7_FORMS.PEA1PAY Use(select )
CALC_CUR_FISC Forms Trigger BANNER7_FORMS_10G.PEA1PAY Use(select )
CALC_CUR_FISC Forms Trigger BANNER7_FORMS.NBAJOBS Use(select )
CALC_CUR_FISC Forms Trigger BANNER7_FORMS_10G.NOAEPAF Use(select )
CALC_CUR_FISC Forms Trigger BANNER7_FORMS_10G.NBAJOBS Use(select )
CALC_CUR_FISC Forms Trigger BANNER7_FORMS.NOAEPAF Use(select )
EDIT_ACTIVE Forms Trigger BANNER7_FORMS.NBAFISC Use(update )
EDIT_ACTIVE Forms Trigger BANNER7_FORMS_10G.NBAFISC Use(update )
EDIT_FISC Forms Trigger BANNER7_FORMS.NTRSPEX Use(select )
EDIT_FISC Forms Trigger BANNER7_FORMS.NBAPBUD Use(select )
EDIT_FISC Forms Trigger BANNER7_FORMS_10G.NBAPBUD Use(select )
EDIT_FISC Forms Trigger BANNER7_FORMS_10G.NTRSPEX Use(select )
EDIT_FISC_CODE Forms Trigger BANNER7_FORMS.NBIBTOT Use(select )
EDIT_FISC_CODE Forms Trigger BANNER7_FORMS_10G.NBIBTOT Use(select )
EDIT_FISC_PTOT Forms Trigger BANNER7_FORMS.NBAPBUD Use(select )
EDIT_FISC_PTOT Forms Trigger BANNER7_FORMS_10G.NBAPBUD Use(select )
EDIT_FMLA_YEAR Forms Trigger BANNER7_FORMS.PEAFMLA Use(select )
EDIT_FMLA_YEAR Forms Trigger BANNER7_FORMS_10G.PEAFMLA Use(select )
EDIT_FMLA_YEAR Forms Trigger BANNER7_FORMS_10G.PEIFMLA Use(select )
EDIT_FMLA_YEAR Forms Trigger BANNER7_FORMS.PEIFMLA Use(select )
EDIT_STATUS_PTOT Forms Trigger BANNER7_FORMS.NBAPBUD Use(select )
EDIT_STATUS_PTOT Forms Trigger BANNER7_FORMS_10G.NBAPBUD Use(select )
FROM_YEAR_CHECK Forms Trigger BANNER7_FORMS.PEIATOT Use(select )
FROM_YEAR_CHECK Forms Trigger BANNER7_FORMS_10G.PEIATOT Use(select )
GEN_FROM_DTES Forms Trigger BANNER7_FORMS.PEIATOT Use(select )
GEN_FROM_DTES Forms Trigger BANNER7_FORMS_10G.PEIATOT Use(select )
GEN_TO_DTES Forms Trigger BANNER7_FORMS.PEIATOT Use(select )
GEN_TO_DTES Forms Trigger BANNER7_FORMS_10G.PEIATOT Use(select )
OTHER_INFO Forms Trigger BANNER7_FORMS.NBIPINC Use(select )
OTHER_INFO Forms Trigger BANNER7_FORMS_10G.NBIPINC Use(select )
TO_YEAR_CHECK Forms Trigger BANNER7_FORMS.PEIATOT Use(select )
TO_YEAR_CHECK Forms Trigger BANNER7_FORMS_10G.PEIATOT Use(select )
VALIDATE_QRY_DATE Forms Trigger BANNER7_FORMS.NBIPINC Use(select )
VALIDATE_QRY_DATE Forms Trigger BANNER7_FORMS_10G.NBIPINC Use(select )
YEAR_CHECK Forms Trigger BANNER7_FORMS.PEIDTOT Use(select )
YEAR_CHECK Forms Trigger BANNER7_FORMS_10G.PEIJTOT Use(select )
YEAR_CHECK Forms Trigger BANNER7_FORMS_10G.PEIETOT Use(select )
YEAR_CHECK Forms Trigger BANNER7_FORMS.PEIJTOT Use(select )
YEAR_CHECK Forms Trigger BANNER7_FORMS_10G.PEIDTOT Use(select )
YEAR_CHECK Forms Trigger BANNER7_FORMS.PEIETOT Use(select )
CHECK_FISC_EFFECTIVE_DATE Forms Trigger BANNER7_FORMS.NBAPBUD.NBRPTOT Use(select )
CHECK_FISC_EFFECTIVE_DATE Forms Trigger BANNER7_FORMS_10G.NBAPBUD.NBRPTOT Use(select )
DO_SECURITY Forms Trigger BANNER7_FORMS.NBIPINC.KEY_BLOCK Use(select )
DO_SECURITY Forms Trigger BANNER7_FORMS_10G.NBIPINC.KEY_BLOCK Use(select )
WHEN-VALIDATE-RECORD Forms Trigger BANNER7_FORMS.NBAFISC.NBBFISC Use(select )
WHEN-VALIDATE-RECORD Forms Trigger BANNER7_FORMS_10G.NBAFISC.NBBFISC Use(select )
P_CALC_ENCD_NUM PROCEDURE S4B70.BANINST1 Rely on ()
P_CALC_ENCD_NUM PROCEDURE S4B70.BANINST1 Use(select )
P_EDIT_CURRENT_FISCAL_YEAR PROCEDURE S4B70.BANINST1 Rely on ()
P_EDIT_CURRENT_FISCAL_YEAR PROCEDURE S4B70.BANINST1 Use(select )
P_EDIT_PLBD_EXISTS PROCEDURE S4B70.BANINST1 Rely on ()
CALCULATE_ENCD_NUM Forms Procedure BANNER7_FORMS.NBAJOBS Use(select )
CALC_FISCDATE_JOBS Forms Procedure BANNER7_FORMS.NOAEPAF Use(select )
CALC_FISCDATE_JOBS Forms Procedure BANNER7_FORMS.NBAJOBS Use(select )
CALC_FISCDATE_JOBS Forms Procedure BANNER7_FORMS.PEA1PAY Use(select )
CALC_FISCDATE_JOBS Forms Procedure BANNER7_FORMS_10G.PEA1PAY Use(select )
CALC_FISCDATE_JOBS Forms Procedure BANNER7_FORMS_10G.NOAEPAF Use(select )
CALC_FISCDATE_JOBS Forms Procedure BANNER7_FORMS_10G.NBAJOBS Use(select )
EDIT_FISC_BEFORE_TRANSFER Forms Procedure BANNER7_FORMS.NBAPBUD Use(select )
EDIT_FISC_BEFORE_TRANSFER Forms Procedure BANNER7_FORMS_10G.NBAPBUD Use(select )
GET_FINI_FOAPAL Forms Procedure BANNER7_FORMS.NTRFBLD Use(select )
GET_FINI_FOAPAL Forms Procedure BANNER7_FORMS_10G.NTRFBLD Use(select )
GET_FISCAL_YEAR Forms Procedure BANNER7_FORMS.PEAESCH Use(select )
GET_FISCAL_YEAR Forms Procedure BANNER7_FORMS_10G.PEAESCH Use(select )
UPD_NTRFINI_IND Forms Procedure BANNER7_FORMS.NTRFBLD Use(select )
UPD_NTRFINI_IND Forms Procedure BANNER7_FORMS_10G.NTRFBLD Use(select )
F_EARNING_FLAG FUNCTION S4B70.BANINST1 Use(select )
F_EDIT_FUTURE_CHANGE_FOR_FISC FUNCTION S4B70.BANINST1 Rely on ()
F_EDIT_FUTURE_CHANGE_FOR_FISC FUNCTION S4B70.BANINST1 Use(select )
F_NBBFISC_ROWID FUNCTION S4B70.BANINST1 Use(select )
F_TOTAL_HOUR_EARNING_CODE FUNCTION S4B70.BANINST1 Use(select )
F_TOTAL_HOUR_EARNING_OTHER FUNCTION S4B70.BANINST1 Use(select )
F_TOTAL_HOUR_EARNING_YEAR FUNCTION S4B70.BANINST1 Use(select )
SELECT_NBBFISC_4 Forms Function BANNER7_FORMS.PEAESCH Use(select )
SELECT_NBBFISC_4 Forms Function BANNER7_FORMS.NBAJOBS Use(select )
SELECT_NBBFISC_4 Forms Function BANNER7_FORMS_10G.PEAESCH Use(select )
SELECT_NBBFISC_4 Forms Function BANNER7_FORMS_10G.NBAJOBS Use(select )
SELECT_NBBFISC_5 Forms Function BANNER7_FORMS.NBAJOBS Use(select )
SELECT_NBBFISC_5 Forms Function BANNER7_FORMS.PHAADJT Use(select )
SELECT_NBBFISC_5 Forms Function BANNER7_FORMS_10G.NBAJOBS Use(select )
SELECT_NBBFISC_5 Forms Function BANNER7_FORMS_10G.PHAADJT Use(select )
PK_VAR_FISC_BEGIN Package variable S4B70.BANINST1.NOKEDIT Rely on ()
PK_VAR_FISC_END Package variable S4B70.BANINST1.NOKEDIT Rely on ()
F_CHECK_MULT_FISC_YEARS Package function S4B70.BANINST1.PEKTEEX Use(select )
F_DT_USES_FISC_VAL Package function S4B70.BANINST1.EOK496R Rely on ()
F_GET_FISC_END_DATE Package function S4B70.BANINST1.PEKTEEX Use(select )
P_BUILDPETWEMP Package procedure S4B70.BANINST1.PEKWEMP Use(select )
P_EDIT_FISCYR_END_DATE Package procedure S4B70.BANINST1.NBKD2SB Use(select )
P_NBBFISC_ADR Package procedure S4B70.BANINST1.EOK496R Rely on ()
P_NBBFISC_AIR Package procedure S4B70.BANINST1.EOK496R Rely on ()
P_NBBFISC_AUR Package procedure S4B70.BANINST1.EOK496R Rely on ()
F_CALC_EARNING_TOTALS_BY_YEAR Package function S4B70.BANINST1.POKODSF Use(select )
F_CALC_EARNING_TOTALS_YTD Package function S4B70.BANINST1.POKODSF Use(select )
F_CALC_TOTAL_HOUR_EARNING_YEAR Package function S4B70.BANINST1.POKODSF Use(select )
F_FISCAL_YEAR_SPLIT_IND Package function S4B70.BANINST1.POKLIBS Use(select )
F_FISCYR_BEGIN_DATE Package function S4B70.BANINST1.NBKD2SB Use(select )
F_GET_BUDGET Package function S4B70.BANINST1.NBKD2SB Use(select )
F_GET_FISCAL_QUARTER Package function S4B70.BANINST1.POKODSF Use(select )
F_GET_FISCAL_YEAR Package function S4B70.BANINST1.NBKD2SB Use(select )
F_GET_POSITION_STATUS Package function S4B70.BANINST1.NBKD2SB Use(select )
F_POSTING_DATE Package function S4B70.BANINST1.POKLIBS Use(select )
F_POSTING_DATE Package function S4B70.BANINST1.POKLIBS Rely on ()
F_SET_PTOT_EFF_DATE Package function S4B70.BANINST1.NBKD2SB Use(select )
NBBFISC SYNONYM S4B70.PUBLIC Rely on ()
NBAPORG Forms DataBlock BANNER7_FORMS.NBIPORG Use(select )
NBAPORG Forms DataBlock BANNER7_FORMS_10G.NBIPORG Use(select )
NBBFISC Forms DataBlock BANNER7_FORMS.NBAFISC Rely on () Use(insert,update,delete,select )
NBBFISC Forms DataBlock BANNER7_FORMS_10G.NBAFISC Rely on () Use(insert,update,delete,select )
NBIPLST Forms DataBlock BANNER7_FORMS.NBIPLST Use(select )
NBIPLST Forms DataBlock BANNER7_FORMS_10G.NBIPLST Use(select )
NTRFINI Forms DataBlock BANNER7_FORMS.NTRFINI Use(select )
NTRFINI Forms DataBlock BANNER7_FORMS_10G.NTRFINI Use(select )
NTRFINI_EXTERN Forms DataBlock BANNER7_FORMS.NTRFINI Use(select )
NTRFINI_EXTERN Forms DataBlock BANNER7_FORMS_10G.NTRFINI Use(select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
NBBFISC_KEY_INDEX INDEX S4B70.POSNCTL Rely on ()
ET_NBBFISC_ADR_EXTSOL_496 TRIGGER S4B70.BANINST1 Fire(delete after each row )
ET_NBBFISC_ADR_EXTSOL_496 TRIGGER S4B70.BANIMGR Fire(delete after each row )
ET_NBBFISC_AIR_EXTSOL_496 TRIGGER S4B70.BANINST1 Fire(insert after each row )
ET_NBBFISC_AIR_EXTSOL_496 TRIGGER S4B70.BANIMGR Fire(insert after each row )
ET_NBBFISC_AUR_EXTSOL_496 TRIGGER S4B70.BANINST1 Fire(update after each row )
ET_NBBFISC_AUR_EXTSOL_496 TRIGGER S4B70.BANIMGR Fire(update after each row )

Comments

Source Code Comments

Fiscal Year Base Table

Columns Comments for NBBFISC_CODE (1)

Source Code Comments

FISCAL YEAR CODE: Code for the defined fiscal year.

Columns Comments for NBBFISC_COAS_CODE (2)

Source Code Comments

FISCAL CHART OF ACCOUNTS CODE: Chart of accounts code for the defined fiscal year. Valued only if Banner Finance is installed.

Columns Comments for NBBFISC_ACTIVE_IND (3)

Source Code Comments

ACTIVE FISCAL YEAR INDICATOR: Indicates if the defined fiscal year is active

Columns Comments for NBBFISC_BEGIN_DATE (4)

Source Code Comments

FISCAL YEAR BEGIN DATE: Begin date of the defined fiscal year.

Columns Comments for NBBFISC_END_DATE (5)

Source Code Comments

FISCAL YEAR END DATE: End date of the defined fiscal year.

Columns Comments for NBBFISC_ACTIVITY_DATE (6)

Source Code Comments

Date of the last activity for this record.

Table NBBPOSN

Schema Name POSNCTL
Label NBBPOSN
Server name S4B70
Creation Date 01/22/2004 14:15:00:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
NBBPOSN_POSN NBBPOSN_POSN VARCHAR2(6) No *
NBBPOSN_STATUS NBBPOSN_STATUS VARCHAR2(1) No
NBBPOSN_TITLE NBBPOSN_TITLE VARCHAR2(30) No
NBBPOSN_PLOC_CODE NBBPOSN_PLOC_CODE VARCHAR2(6) Yes
NBBPOSN_BEGIN_DATE NBBPOSN_BEGIN_DATE DATE No
NBBPOSN_END_DATE NBBPOSN_END_DATE DATE Yes
NBBPOSN_TYPE NBBPOSN_TYPE VARCHAR2(1) No
NBBPOSN_PCLS_CODE NBBPOSN_PCLS_CODE VARCHAR2(5) No *
NBBPOSN_ECLS_CODE NBBPOSN_ECLS_CODE VARCHAR2(2) No *
NBBPOSN_POSN_REPORTS NBBPOSN_POSN_REPORTS VARCHAR2(6) Yes
NBBPOSN_AUTH_NUMBER NBBPOSN_AUTH_NUMBER VARCHAR2(9) Yes
NBBPOSN_TABLE NBBPOSN_TABLE VARCHAR2(2) No
NBBPOSN_GRADE NBBPOSN_GRADE VARCHAR2(5) No
NBBPOSN_STEP NBBPOSN_STEP NUMBER(3,0) Yes
NBBPOSN_APPT_PCT NBBPOSN_APPT_PCT NUMBER(5,2)