NBREHDR NBREJLD NBREJOB NBREPLD NBREPSA NBRERRN NBRLOCK NBRSALC NBRSPLC NBTEMPF NBTFPRM NBTJERR NBTJOBF NBTORSF NBTPERR NBTPOSF NSRSPSC NTRSPBU NTRSPEC NTRSPEX NTRSPPR NTVBPRO

Model Salary Planner


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

List of Objects

Object Name Object Type Layer Name
NBREHDR TABLE Default
NBREJLD TABLE Default
NBREJOB TABLE Default
NBREPLD TABLE Default
NBREPSA TABLE Default
NBRERRN TABLE Default
NBRLOCK TABLE Default
NBRSALC TABLE Default
NBRSPLC TABLE Default
NBTEMPF TABLE Default
NBTFPRM TABLE Default
NBTJERR TABLE Default
NBTJOBF TABLE Default
NBTORSF TABLE Default
NBTPERR TABLE Default
NBTPOSF TABLE Default
NSRSPSC TABLE Default
NTRSPBU TABLE Default
NTRSPEC TABLE Default
NTRSPEX TABLE Main Objects
NTRSPPR TABLE Default
NTVBPRO TABLE Default

Comments

Model View

''

Table NBREHDR

Schema Name POSNCTL
Label NBREHDR
Server name S4B70
Creation Date 01/22/2004 15:20:11:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
NBREHDR_SPEX_CODE NBREHDR_SPEX_CODE VARCHAR2(12) No *
NBREHDR_SCENARIO NBREHDR_SCENARIO VARCHAR2(30) No *
NBREHDR_FISC_CODE NBREHDR_FISC_CODE VARCHAR2(4) No
NBREHDR_PTOT_STATUS NBREHDR_PTOT_STATUS VARCHAR2(1) No
NBREHDR_JOBS_EFFECTIVE_DATE NBREHDR_JOBS_EFFECTIVE_DATE DATE No
NBREHDR_LOCK_IND NBREHDR_LOCK_IND VARCHAR2(1) No
NBREHDR_USER_ID NBREHDR_USER_ID VARCHAR2(30) No
NBREHDR_ACTIVITY_DATE NBREHDR_ACTIVITY_DATE DATE No
NBREHDR_COAS_CODE NBREHDR_COAS_CODE VARCHAR2(1) Yes
NBREHDR_OBUD_CODE NBREHDR_OBUD_CODE VARCHAR2(6) Yes
NBREHDR_OBPH_CODE NBREHDR_OBPH_CODE VARCHAR2(6) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_NBREHDR Unique NBREHDR_SPEX_CODE
PK_NBREHDR Unique NBREHDR_SCENARIO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
report_unlocked C/C++ Function [F:\BANNER\C\NBPSPUP.PC] Use(select )
NBREHDR SYNONYM S4B70.PUBLIC Rely on ()
NBREPSA TABLE S4B70.POSNCTL Refer( No Action )
F_NBREHDR_EXISTS Forms Function BANNER7_FORMS.NTRSPEX Use(select )
F_NBREHDR_EXISTS Forms Function BANNER7_FORMS_10G.NTRSPEX Use(select )
G_INIT_SCENARIO Package variable S4B70.BANINST1.NBKBUDG Rely on ()
G_INIT_STATUS Package variable S4B70.BANINST1.NBKBUDG Rely on ()
G_NEW_INITIAL_SCENARIO Package variable S4B70.BANINST1.NBKBUDG Rely on ()
G_OLD_INITIAL_SCENARIO Package variable S4B70.BANINST1.NBKBUDG Rely on ()
P_ADD_NEW_NBREHDR Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_ADD_NEW_NBREHDR Package procedure S4B70.BANINST1.NBKBUDG Use(update,select )
P_ADD_NEW_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_ADD_NEW_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_ADD_NEW_NBREPLD Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_ADD_NEW_NBREPSA Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_ADD_NEW_NBRERRN Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_COPY_NBREHDR Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_COPY_NBREHDR Package procedure S4B70.BANINST1.NBKBUDG Use(insert,select )
P_COPY_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_COPY_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_COPY_NBREPLD Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_COPY_NBREPSA Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_COPY_NBRERRN Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_DELETE_INVALID_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_DELETE_INVALID_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_DELETE_INVALID_NBREPLD Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_DELETE_INVALID_NBREPSA Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_DELETE_INVALID_NBRERRN Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_DELETE_NBREHDR Package procedure S4B70.BANINST1.NBKBUDG Use(delete )
P_DISPORGNSTOTALSTABLE Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_DISPORGNSTOTALSTABLE Package procedure S4B70.BANINST1.BWPKSTOT Rely on ()
P_EMPLPRINTTOTALS Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_EMPLPRINTTOTALS Package procedure S4B70.BANINST1.BWPKSMEX Use(select )
P_EXTRACT_NBREHDR Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_EXTRACT_NBREHDR Package procedure S4B70.BANINST1.NBKBUDG Use(insert )
P_EXTRACT_NBREPSA Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_GETEXTRACTSCENARIOLIST Package procedure S4B70.BANINST1.BWPKSMEX Use(select )
P_GETORGNLIST Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_GETORGNLIST Package procedure S4B70.BANINST1.BWPKSMEX Use(select )
P_GET_CURR_PTOT_REC Package procedure S4B70.BANINST1.BWPKSPOS Rely on ()
P_GET_CURR_PTOT_REC Package procedure S4B70.BANINST1.BWPKSPOS Rely on ()
P_GET_EXTRACT_LIST Package procedure S4B70.BANINST1.BWPKSORG Use(select )
P_GET_SCENARIO_LIST Package procedure S4B70.BANINST1.BWPKSORG Use(select )
P_INS_INTO_TEMP_TABLES Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_ORGNPRINTEXTRACTTOTALS Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_POSNPRINTTOTALS Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_POSNPRINTTOTALS Package procedure S4B70.BANINST1.BWPKSMEX Use(select )
P_PRINTEJLD Package procedure S4B70.BANINST1.BWPKSJOB Rely on ()
P_PRINTEJLDFINANCE Package procedure S4B70.BANINST1.BWPKSDST Rely on ()
P_PRINTEJLDNOFINANCE Package procedure S4B70.BANINST1.BWPKSDST Rely on ()
P_PRINTEJOB Package procedure S4B70.BANINST1.BWPKSJOB Rely on ()
P_PRINTEPLD Package procedure S4B70.BANINST1.BWPKSPOS Rely on ()
P_PRINTEPSA Package procedure S4B70.BANINST1.BWPKSPOS Rely on ()
P_PRINTERRN Package procedure S4B70.BANINST1.BWPKSJOB Rely on ()
P_PRINTINFOFINANCE Package procedure S4B70.BANINST1.BWPKSDST Rely on ()
P_PRINTINFONOFINANCE Package procedure S4B70.BANINST1.BWPKSDST Rely on ()
P_PRINTOTHERJOBSTABLE Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_PRINTSALC Package procedure S4B70.BANINST1.BWPKSJOB Rely on ()
P_PRINT_POSN_DETL_INFO Package procedure S4B70.BANINST1.BWPKSPOS Rely on ()
SCEN_EXISTS Package procedure S4B70.BANINST1.NOKPVAL Use(select )
NBREHDRC Package cursor S4B70.BANINST1.BWPKSALA Use(select )
NBRJLBDC Package cursor S4B70.BANINST1.BWPKSDST Use(select )
NBRPLBDC Package cursor S4B70.BANINST1.BWPKSDST Use(select )
EXTRACTID Package variable S4B70.BANINST1.BWPKSPOS Rely on ()
G_COAS_CODE Package variable S4B70.BANINST1.BWPKSALA Rely on ()
G_COAS_CODE Package variable S4B70.BANINST1.BWPKSTOT Rely on ()
G_COAS_CODE Package variable S4B70.BANINST1.BWPKSMEX Rely on ()
G_COAS_CODE Package variable S4B70.BANINST1.BWPKSJOB Rely on ()
G_EXTRACT Package variable S4B70.BANINST1.BWPKSJOB Rely on ()
G_EXTRACT Package variable S4B70.BANINST1.BWPKSTOT Rely on ()
G_JOBS_EFF_DATE Package variable S4B70.BANINST1.BWPKSALA Rely on ()
G_JOBS_EFF_DATE Package variable S4B70.BANINST1.BWPKSJOB Rely on ()
G_JOBS_EFF_DATE Package variable S4B70.BANINST1.BWPKSTOT Rely on ()
G_JOBS_EFF_DATE Package variable S4B70.BANINST1.BWPKSMEX Rely on ()
G_SCENARIO Package variable S4B70.BANINST1.BWPKSJOB Rely on ()
G_SCENARIO Package variable S4B70.BANINST1.BWPKSTOT Rely on ()
NBREHDR_REC Package variable S4B70.BANINST1.BWPKSPOS Rely on ()
NBREHDR_REC Package variable S4B70.BANINST1.BWPKSMEX Rely on ()
NBREHDR_REC Package variable S4B70.BANINST1.BWPKSALA Rely on ()
NBREHDR_REC Package variable S4B70.BANINST1.BWPKSDST Rely on ()
NBREHDR_REC Package variable S4B70.BANINST1.BWPKSPOS Rely on ()
NBREHDR_REC Package variable S4B70.BANINST1.BWPKSDST Rely on ()
NBREHDR_REC Package variable S4B70.BANINST1.BWPKSMEX Rely on ()
NBREHDR_REC Package variable S4B70.BANINST1.BWPKSALA Rely on ()
SCENARIO Package variable S4B70.BANINST1.BWPKSPOS Rely on ()
SCENARIO_NM Package variable S4B70.BANINST1.BWPKSALA Rely on ()
SPEX_CODE Package variable S4B70.BANINST1.BWPKSALA Rely on ()
VAR_ASOF_DATE Package variable S4B70.BANINST1.BWPKSPOS Rely on ()
VAR_COAS_CODE Package variable S4B70.BANINST1.BWPKSPOS Rely on ()
F_HYPERLINK_ORGN Package function S4B70.BANINST1.BWPKSORG Rely on ()
F_IS_ORGN_IN_NSRSPSC Package function S4B70.BANINST1.BWPKSORG Rely on ()
P_CHECKEXTRACTLIST Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_COPY_NBRLOCK Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_COPY_NBRLOCK_WEB Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_COPY_SCENARIO Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_COPY_SCENARIO_WEB Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_CREATESCENARIO Package procedure S4B70.BANINST1.BWPKSALA Rely on ()
P_DELETE_INVALID_BUDGETS Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_DELETE_SCENARIO Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_DISPACCTDIST Package procedure S4B70.BANINST1.BWPKSDST Rely on ()
P_DISPLOCKEDORGNS Package procedure S4B70.BANINST1.BWPKSPOS Rely on ()
P_DISPMULTIPLEEMPLOYEE Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_DISPMULTIPLEPOSITIONS Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
P_DISPORGNSWOUTDATA Package procedure S4B70.BANINST1.BWPKSPOS Rely on ()
P_EXTRACT_BUDGET Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_GET_EXTRACT_LIST Package procedure S4B70.BANINST1.BWPKSALA Use(select )
P_GET_SCENARIO_LIST Package procedure S4B70.BANINST1.BWPKSALA Use(select )
P_JOBLABORDIST Package procedure S4B70.BANINST1.BWPKSDST Rely on ()
P_POSNLABORDIST Package procedure S4B70.BANINST1.BWPKSDST Rely on ()
P_PRINTFILTER Package procedure S4B70.BANINST1.BWPKSALA Rely on ()
P_PRINTORGNSWOUTDATALINK Package procedure S4B70.BANINST1.BWPKSPOS Rely on ()
P_UPDATE_EXTRACT_LOCK Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_UPDATE_EXTRACT_LOCK Package procedure S4B70.BANINST1.NBKBUDG Use(update )
P_UPDATE_NBRPLBD Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_VIEWEXTRACTS Package procedure S4B70.BANINST1.BWPKSMEX Rely on ()
GET_NBREHDR Package cursor S4B70.BANINST1.NBKBUDG Rely on () Use(select )
F_EXTRACT_EXISTS Package function S4B70.BANINST1.NBKBUDG Rely on ()
F_EXTRACT_EXISTS Package function S4B70.BANINST1.NBKBUDG Use(select )
F_EXTRACT_SCENARIO_EXISTS Package function S4B70.BANINST1.NBKBUDG Rely on ()
F_EXTRACT_SCENARIO_EXISTS Package function S4B70.BANINST1.NBKBUDG Use(select )
F_UNLOCKED_ORGN_LIST Package function S4B70.BANINST1.NBKBUDG Rely on ()
F_UNLOCKED_ORGN_LIST Package function S4B70.BANINST1.NBKBUDG Use(select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_NBREHDR INDEX S4B70.POSNCTL Rely on ()

Comments

Source Code Comments

Salary Planner Extract Header Table.

Columns Comments for NBREHDR_SPEX_CODE (1)

Source Code Comments

SPEX CODE: Salary planner extract code.

Columns Comments for NBREHDR_SCENARIO (2)

Source Code Comments

SCENARIO: Scenario code associated with this extract ID.

Columns Comments for NBREHDR_FISC_CODE (3)

Source Code Comments

FISC CODE: Fiscal Year of the Salary planner extract code.

Columns Comments for NBREHDR_PTOT_STATUS (4)

Source Code Comments

PTOT STATUS: Salary Planner Budget status, values are (W)orking or (A)pproved.

Columns Comments for NBREHDR_JOBS_EFFECTIVE_DATE (5)

Source Code Comments

JOBS EFFECTIVE DATE: Effective Date from the Job Effective Date parameter from the Extract Process.

Columns Comments for NBREHDR_LOCK_IND (6)

Source Code Comments

Scenario Locked Indicator

Columns Comments for NBREHDR_USER_ID (7)

Source Code Comments

USER ID: User who inserted the record or last modified the record.

Columns Comments for NBREHDR_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: Date when the record was inserted or last modified.

Columns Comments for NBREHDR_COAS_CODE (9)

Source Code Comments

COAS CODE: Chart of Accounts code.

Columns Comments for NBREHDR_OBUD_CODE (10)

Source Code Comments

OBUD CODE: Budget ID code.

Columns Comments for NBREHDR_OBPH_CODE (11)

Source Code Comments

OBPH CODE: Budget Phase code.

Table NBREJLD

Schema Name POSNCTL
Label NBREJLD
Server name S4B70
Creation Date 01/22/2004 15:20:11:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
NBREJLD_SPEX_CODE NBREJLD_SPEX_CODE VARCHAR2(12) No
NBREJLD_SCENARIO NBREJLD_SCENARIO VARCHAR2(30) No
NBREJLD_PIDM NBREJLD_PIDM NUMBER(8,0) No
NBREJLD_POSN NBREJLD_POSN VARCHAR2(6) No
NBREJLD_SUFF NBREJLD_SUFF VARCHAR2(2) No
NBREJLD_EFFECTIVE_DATE NBREJLD_EFFECTIVE_DATE DATE No
NBREJLD_ORGN_CODE_POSN NBREJLD_ORGN_CODE_POSN VARCHAR2(6) No
NBREJLD_PERCENT_PROPOSED NBREJLD_PERCENT_PROPOSED NUMBER(5,2) No
NBREJLD_RECORD_STATUS NBREJLD_RECORD_STATUS VARCHAR2(1) No
NBREJLD_USER_ID NBREJLD_USER_ID VARCHAR2(30) No
NBREJLD_ACTIVITY_DATE NBREJLD_ACTIVITY_DATE DATE No
NBREJLD_COAS_CODE NBREJLD_COAS_CODE VARCHAR2(1) Yes
NBREJLD_ACCI_CODE NBREJLD_ACCI_CODE VARCHAR2(6) Yes
NBREJLD_FUND_CODE NBREJLD_FUND_CODE VARCHAR2(6) Yes
NBREJLD_ORGN_CODE NBREJLD_ORGN_CODE VARCHAR2(6) Yes
NBREJLD_ACCT_CODE NBREJLD_ACCT_CODE VARCHAR2(6) Yes
NBREJLD_PROG_CODE NBREJLD_PROG_CODE VARCHAR2(6) Yes
NBREJLD_ACTV_CODE NBREJLD_ACTV_CODE VARCHAR2(6) Yes
NBREJLD_LOCN_CODE NBREJLD_LOCN_CODE VARCHAR2(6) Yes
NBREJLD_PROJ_CODE NBREJLD_PROJ_CODE VARCHAR2(8) Yes
NBREJLD_CTYP_CODE NBREJLD_CTYP_CODE VARCHAR2(2) Yes
NBREJLD_ACCT_CODE_EXTERNAL NBREJLD_ACCT_CODE_EXTERNAL VARCHAR2(60) Yes
NBREJLD_TRANSACTION_NO NBREJLD_TRANSACTION_NO NUMBER(15,0) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
NBREJLD_SPEX_INDEX NBREJLD_SPEX_CODE
NBREJLD_SPEX_INDEX NBREJLD_SCENARIO
NBREJLD_SPEX_INDEX NBREJLD_ORGN_CODE_POSN
NBREJLD_SPEX_INDEX NBREJLD_PIDM
NBREJLD_SPEX_INDEX NBREJLD_POSN
NBREJLD_SPEX_INDEX NBREJLD_SUFF
NBREJLD_SPEX_INDEX NBREJLD_EFFECTIVE_DATE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
sel_ejld C/C++ Function [F:\BANNER\C\NBPSPUP.PC] Use(select )
NBREJLD SYNONYM S4B70.PUBLIC Rely on ()
P_ADD_NEW_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Use(insert,select )
P_COPYJOBTOPOSN Package procedure S4B70.BANINST1.BWPKSDST Use(select )
P_COPYPOSNTOJOB Package procedure S4B70.BANINST1.BWPKSDST Use(insert,delete )
P_COPYPOSNTOJOBBYJOB Package procedure S4B70.BANINST1.BWPKSDST Use(insert,delete )
P_COPY_JOBS_INFO Package procedure S4B70.BANINST1.BWPKSALA Use(insert,delete,select )
P_COPY_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Use(insert,select )
P_DELETE_INVALID_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Use(delete,select )
P_DELETE_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Use(delete )
P_EXTRACT_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_EXTRACT_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Use(insert )
P_INSERTNBREJLD Package procedure S4B70.BANINST1.BWPKSDST Use(insert )
P_PRINTEJLD Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_UPDATENBREJLD Package procedure S4B70.BANINST1.BWPKSDST Use(update )
P_UPDATE_NBREJLD_PRETRAN Package procedure S4B70.BANINST1.NBKBUDG Use(update )
NBREJLDBYPIDMC Package cursor S4B70.BANINST1.BWPKSDST Use(select )
NBREJLDC Package cursor S4B70.BANINST1.BWPKSDST Use(select )
NBREJLDEPAFC Package cursor S4B70.BANINST1.BWPKSDST Use(select )
NBREJLD_ROW Package variable S4B70.BANINST1.BWPKSDST Rely on ()
NBREJLD_ROW Package variable S4B70.BANINST1.BWPKSDST Rely on ()
F_NBREJLD_PERCENT_TOTAL Package function S4B70.BANINST1.BWPKSDST Use(select )
P_COPY_POSN_DIST_TO_JOBS Package procedure S4B70.BANINST1.NBKBUDG Use(insert,delete )
P_SUBMIT_EPAF_JLBD Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_UPDATEACCTDIST Package procedure S4B70.BANINST1.BWPKSDST Use(delete )
P_UPDATE_NBREJLD_W_REC_STATUS Package procedure S4B70.BANINST1.NBKBUDG Use(update )
P_VALIDATE_JLBD Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_VALIDATE_JOBS_FOPAL Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
F_GET_NBREJLD_CHG_STATUS Package function S4B70.BANINST1.NBKBUDG Use(select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
NBREJLD_SPEX_INDEX INDEX S4B70.POSNCTL Rely on ()

Comments

Source Code Comments

Extracted Job Labor Distribution Salary Planner Table.

Columns Comments for NBREJLD_SPEX_CODE (1)

Source Code Comments

SPEX CODE: Salary planner extract code.

Columns Comments for NBREJLD_SCENARIO (2)

Source Code Comments

SCENARIO: Scenario code associated with this extract ID.

Columns Comments for NBREJLD_PIDM (3)

Source Code Comments

PIDM: Internal identification number of the person.

Columns Comments for NBREJLD_POSN (4)

Source Code Comments

POSITION: The Position to which this job is attached.

Columns Comments for NBREJLD_SUFF (5)

Source Code Comments

SUFFIX: The Suffix attached to the job.

Columns Comments for NBREJLD_EFFECTIVE_DATE (6)

Source Code Comments

EFFECTIVE DATE: Date this will be effective.

Columns Comments for NBREJLD_ORGN_CODE_POSN (7)

Source Code Comments

ORGANIZAITION CODE:Identifies the organization code that goes with this position.

Columns Comments for NBREJLD_PERCENT_PROPOSED (8)

Source Code Comments

PERCENT PROPOSED: The proposed percentage.

Columns Comments for NBREJLD_RECORD_STATUS (9)

Source Code Comments

RECORD STATUS: The status of this record, valid values are (N)o Changes, (C)hanged, (U)ploaded.

Columns Comments for NBREJLD_USER_ID (10)

Source Code Comments

USER ID: User who inserted the record or last modified the record.

Columns Comments for NBREJLD_ACTIVITY_DATE (11)

Source Code Comments

ACTIVITY DATE: Date when the record was inserted or last modified.

Columns Comments for NBREJLD_COAS_CODE (12)

Source Code Comments

CHART OF ACCOUNTS CODE: The primary identification code for any chart of accounts.

Columns Comments for NBREJLD_ACCI_CODE (13)

Source Code Comments

ACCOUNT INDEX CODE: The user defined value representing a summerization of any combination of user-defined FOAPAL elements.

Columns Comments for NBREJLD_FUND_CODE (14)

Source Code Comments

FUND CODE: Identifies the fund code that appears on a transaction.

Columns Comments for NBREJLD_ORGN_CODE (15)

Source Code Comments

ORGANIZATION CODE: Identifies the organization code that appears on a transaction.

Columns Comments for NBREJLD_ACCT_CODE (16)

Source Code Comments

ACCOUNTING CODE: Finance accounting code.

Columns Comments for NBREJLD_PROG_CODE (17)

Source Code Comments

PROGRAM CODE: The user-defined value to the program classification structure.

Columns Comments for NBREJLD_ACTV_CODE (18)

Source Code Comments

ACTIVITY CODE: The activity that is primarily associated with this organization.

Columns Comments for NBREJLD_LOCN_CODE (19)

Source Code Comments

LOCATION CODE: The physical location of the institution's financial manager.

Columns Comments for NBREJLD_PROJ_CODE (20)

Source Code Comments

PROJECT CODE: A unique code to identify a cost accounting project.

Columns Comments for NBREJLD_CTYP_CODE (21)

Source Code Comments

COST TYPE CODE: Cost Type within Finance Cost Accounting Module.

Columns Comments for NBREJLD_ACCT_CODE_EXTERNAL (22)

Source Code Comments

EXTERNAL ACCOUNTING CODE: The external Finance accounting code.

Columns Comments for NBREJLD_TRANSACTION_NO (23)

Source Code Comments

TRANSACTION NUMBER: EPAF Transaction number of the record.

Table NBREJOB

Schema Name POSNCTL
Label NBREJOB
Server name S4B70
Creation Date 01/23/2004 13:33:13:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
NBREJOB_SPEX_CODE NBREJOB_SPEX_CODE VARCHAR2(12) No
NBREJOB_SCENARIO NBREJOB_SCENARIO VARCHAR2(30) No
NBREJOB_PIDM NBREJOB_PIDM NUMBER(8,0) No
NBREJOB_POSN NBREJOB_POSN VARCHAR2(6) No
NBREJOB_SUFF NBREJOB_SUFF VARCHAR2(2) No
NBREJOB_EFFECTIVE_DATE NBREJOB_EFFECTIVE_DATE DATE No
NBREJOB_EFF_DATE_PROPOSED NBREJOB_EFF_DATE_PROPOSED DATE No
NBREJOB_PERS_CHG_DATE NBREJOB_PERS_CHG_DATE DATE No
NBREJOB_ORGN_CODE_POSN NBREJOB_ORGN_CODE_POSN VARCHAR2(6) No
NBREJOB_ECLS_CODE_POSN NBREJOB_ECLS_CODE_POSN VARCHAR2(2) No
NBREJOB_ECLS_CODE NBREJOB_ECLS_CODE VARCHAR2(2) No
NBREJOB_ANN_SALARY NBREJOB_ANN_SALARY NUMBER(11,2) No
NBREJOB_ANN_SALARY_PROPOSED NBREJOB_ANN_SALARY_PROPOSED NUMBER(11,2) No
NBREJOB_APPT_PCT NBREJOB_APPT_PCT NUMBER(5,2) No
NBREJOB_APPT_PCT_PROPOSED NBREJOB_APPT_PCT_PROPOSED NUMBER(5,2) No
NBREJOB_HRS_DAY NBREJOB_HRS_DAY NUMBER(6,2) No
NBREJOB_HRS_DAY_PROPOSED NBREJOB_HRS_DAY_PROPOSED NUMBER(6,2) No
NBREJOB_HRS_PAY NBREJOB_HRS_PAY NUMBER(6,2) No
NBREJOB_HRS_PAY_PROPOSED NBREJOB_HRS_PAY_PROPOSED NUMBER(6,2) No
NBREJOB_SGRP_CODE NBREJOB_SGRP_CODE VARCHAR2(6) No
NBREJOB_SGRP_CODE_PROPOSED NBREJOB_SGRP_CODE_PROPOSED VARCHAR2(6) No
NBREJOB_BUDGET_FACTOR NBREJOB_BUDGET_FACTOR NUMBER(5,2) No
NBREJOB_EST_FY_BUDGET NBREJOB_EST_FY_BUDGET NUMBER(11,2) No
NBREJOB_EXCL_TOTALS_IND NBREJOB_EXCL_TOTALS_IND VARCHAR2(1) No
NBREJOB_HIDE_IND NBREJOB_HIDE_IND VARCHAR2(1) No
NBREJOB_EXTRACT_STATUS NBREJOB_EXTRACT_STATUS VARCHAR2(1) No
NBREJOB_RECORD_STATUS NBREJOB_RECORD_STATUS VARCHAR2(1) No
NBREJOB_USER_ID NBREJOB_USER_ID VARCHAR2(30) No
NBREJOB_ACTIVITY_DATE NBREJOB_ACTIVITY_DATE DATE No
NBREJOB_DESC NBREJOB_DESC VARCHAR2(30) Yes
NBREJOB_DESC_PROPOSED NBREJOB_DESC_PROPOSED VARCHAR2(30) Yes
NBREJOB_REG_RATE NBREJOB_REG_RATE NUMBER(11,6) Yes
NBREJOB_REG_RATE_PROPOSED NBREJOB_REG_RATE_PROPOSED NUMBER(11,6) Yes
NBREJOB_FTE NBREJOB_FTE NUMBER(6,3) Yes
NBREJOB_FTE_PROPOSED NBREJOB_FTE_PROPOSED NUMBER(6,3) Yes
NBREJOB_SAL_TABLE NBREJOB_SAL_TABLE VARCHAR2(2) Yes
NBREJOB_SAL_TABLE_PROPOSED NBREJOB_SAL_TABLE_PROPOSED VARCHAR2(2) Yes
NBREJOB_SAL_GRADE NBREJOB_SAL_GRADE VARCHAR2(5) Yes
NBREJOB_SAL_GRADE_PROPOSED NBREJOB_SAL_GRADE_PROPOSED VARCHAR2(5) Yes
NBREJOB_SAL_STEP NBREJOB_SAL_STEP NUMBER(3,0) Yes
NBREJOB_SAL_STEP_PROPOSED NBREJOB_SAL_STEP_PROPOSED NUMBER(3,0) Yes
NBREJOB_RANK_CODE NBREJOB_RANK_CODE VARCHAR2(2) Yes
NBREJOB_COMMENTS NBREJOB_COMMENTS VARCHAR2(1300) Yes
NBREJOB_FACTOR NBREJOB_FACTOR NUMBER(4,0) Yes
NBREJOB_PAYS NBREJOB_PAYS NUMBER(4,0) Yes
NBREJOB_EMPR_CODE NBREJOB_EMPR_CODE VARCHAR2(4) Yes
NBREJOB_ROUNDING_METHOD NBREJOB_ROUNDING_METHOD NUMBER(6,2) Yes
NBREJOB_TRANSACTION_NO NBREJOB_TRANSACTION_NO NUMBER(15,0) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
NBREJOB_ECLS_INDEX NBREJOB_SPEX_CODE
NBREJOB_ECLS_INDEX NBREJOB_SCENARIO
NBREJOB_ECLS_INDEX NBREJOB_ECLS_CODE_POSN
NBREJOB_KEY_INDEX Unique NBREJOB_SPEX_CODE
NBREJOB_KEY_INDEX Unique NBREJOB_SCENARIO
NBREJOB_KEY_INDEX Unique NBREJOB_PIDM
NBREJOB_KEY_INDEX Unique NBREJOB_POSN
NBREJOB_KEY_INDEX Unique NBREJOB_SUFF
NBREJOB_KEY_INDEX Unique NBREJOB_EFFECTIVE_DATE
NBREJOB_ORGN_INDEX NBREJOB_SPEX_CODE
NBREJOB_ORGN_INDEX NBREJOB_SCENARIO
NBREJOB_ORGN_INDEX NBREJOB_ORGN_CODE_POSN

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
control_report C/C++ Function [F:\BANNER\C\NBPSPEX.PC] Use(select )
control_report C/C++ Function [F:\BANNER\C\NBPSPUP.PC] Use(select )
sel_all_ftvorgn C/C++ Function [F:\BANNER\C\NBPSPEX.PC] Use(select )
sel_all_ptvorgn C/C++ Function [F:\BANNER\C\NBPSPEX.PC] Use(select )
sel_ejob C/C++ Function [F:\BANNER\C\NBPSPUP.PC] Use(select )
sel_ftvorgn C/C++ Function [F:\BANNER\C\NBPSPEX.PC] Use(select )
sel_ftvorgn_succ C/C++ Function [F:\BANNER\C\NBPSPEX.PC] Use(select )
sel_ptvorgn C/C++ Function [F:\BANNER\C\NBPSPEX.PC] Use(select )
sel_ptvorgn_succ C/C++ Function [F:\BANNER\C\NBPSPEX.PC] Use(select )
NBREJOB SYNONYM S4B70.PUBLIC Rely on ()
P_ADD_NEW_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Use(insert,select )
P_APPLYMASSLIST Package procedure S4B70.BANINST1.BWPKSJOB Rely on ()
P_CALCORGNJOBINFO Package procedure S4B70.BANINST1.BWPKSTOT Use(select )
P_COPYPOSNTOJOB Package procedure S4B70.BANINST1.BWPKSDST Use(select )
P_COPYPOSNTOJOBBYJOB Package procedure S4B70.BANINST1.BWPKSDST Use(select )
P_COPY_JOBS_INFO Package procedure S4B70.BANINST1.BWPKSALA Use(insert,delete,select )
P_COPY_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Use(insert,select )
P_DELETE_INVALID_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Use(delete,select )
P_DELETE_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Use(delete )
P_DISPORGNSSUMMARYTOTALS Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_EMPLPRINTTOTALS Package procedure S4B70.BANINST1.BWPKSMEX Use(select )
P_EXCL_POSN_JOBS Package procedure S4B70.BANINST1.BWPKSPOS Use(update )
P_EXTRACT_NBREJLD Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_EXTRACT_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Rely on ()
P_EXTRACT_NBREJOB Package procedure S4B70.BANINST1.NBKBUDG Rely on () Use(insert )
P_EXTRACT_NBRERRN Package procedure S4B70.BANINST1.NBKBUDG Use(select )
P_HIDE_POSN_JOBS Package procedure S4B70.BANINST1.BWPKSPOS Use(update )
P_INS_NBTEMPF_NBTJOBF Package procedure S4B70.BANINST1.BWPKSMEX Use(select )
P_PRINTEJLD Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_PRINTEJOB Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_PRINTEMPLEXTRACTTOTALS Package procedure S4B70.BANINST1.BWPKSMEX Use(select )
P_PRINTEMPLOYEEROW Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_PRINTERRN Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_PRINTORGNTOTALROW Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_PRINTOTHERJOBSTABLE Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_PRINTSALC Package procedure S4B70.BANINST1.BWPKSJOB Use(select )
P_PRINT_POSN_BUDG_INFO Package procedure S4B70.BANINST1.BWPKSPOS Use(select )
P_SAVEEMPDETLCHANGES Package procedure S4B70.BANINST1.BWPKSJOB Use(update )
P_SAVEJOBDETLCHANGES Package procedure S4B70.BANINST1.BWPKSJOB Use(update )
P_UPD_NBREJOB_SALARY_DATA Package procedure S4B70.BANINST1.BWPKSJOB Use(update )
FACRANKSC Package cursor S4B70.BANINST1.BWPKSALA Rely on ()
FACRANKSC Package cursor S4B70.BANINST1.BWPKSALA Use(select )
GET_NBRSALCC Package cursor S4B70.BANINST1.BWPKSJOB Use(select )
NBREJLDBYPIDMC Package cursor S4B70.BANINST1.BWPKSDST Use(select )
NBREJLDC Package cursor S4B70.BANINST1.BWPKSDST Use(select )
NBREJOBBYEMPFSEQNOC Package cursor S4B70.BANINST1.BWPKSJOB Use(select )
NBREJOBBYJOBFSEQNOC