Model Position Control

Model Label : Banner HR Position Control Module
Path : BANNER DEV/HR/Position Control

List of Objects

Object Name	Object Type	Layer Name
NBBFISC	TABLE	Default
NBBPOSN	TABLE	nbbposn
NBBWKSH	TABLE	Default
NBRBHIS	TABLE	Default
NBRBJLH	TABLE	Default
NBRBJOB	TABLE	Default
NBRBJQE	TABLE	Default
NBRCLSH	TABLE	Default
NBREARN	TABLE	Default
NBRFCLD	TABLE	Default
NBRFTOT	TABLE	nbbposn
NBRJFTE	TABLE	Default
NBRJLBD	TABLE	Default
NBRJLHS	TABLE	Default
NBRJOBS	TABLE	Default
NBRPLBD	TABLE	nbbposn
NBRPOSH	TABLE	Default
NBRPTOT	TABLE	nbbposn
NBRRJQE	TABLE	Default
NBRRTOT	TABLE	nbbposn
NBRWKSH	TABLE	Default
NBRXDED	TABLE	Default
NBTFTOT	TABLE	Default
NBTPLBD	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
NTRACAT	TABLE	Default
NTRACLV	TABLE	Default
NTRADFV	TABLE	Default
NTRALVL	TABLE	Default
NTRAPFB	TABLE	Default
NTRAPFD	TABLE	Default
NTRAUBK	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
NTRSTGR	TABLE	Default
NTRSTRL	TABLE	Default
NTRTPRX	TABLE	Default
NTRWKSH	TABLE	Default
NTVACAT	TABLE	Default
NTVAPTY	TABLE	Default
NTVDOTT	TABLE	Default
NTVJOBP	TABLE	Default
NTVPFOC	TABLE	Default
NTVPNOC	TABLE	Default
NTVWKSH	TABLE	Default
NURVERS	TABLE	Default

Comments

Model View

Table NBBFISC

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:09:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL
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

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
Server name MALDEV8_B60
Creation Date 07/30/2003 15:18:28:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
NBBPOSN_POSN	NBBPOSN_POSN	VARCHAR2(6)	No	*	*
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_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)	No
NBBPOSN_CIPC_CODE	NBBPOSN_CIPC_CODE	VARCHAR2(6)	Yes
NBBPOSN_ROLL_IND	NBBPOSN_ROLL_IND	VARCHAR2(1)	No
NBBPOSN_COAS_CODE	NBBPOSN_COAS_CODE	VARCHAR2(1)	Yes
NBBPOSN_ACTIVITY_DATE	NBBPOSN_ACTIVITY_DATE	DATE	No
NBBPOSN_SGRP_CODE	NBBPOSN_SGRP_CODE	VARCHAR2(6)	Yes
NBBPOSN_PGRP_CODE	NBBPOSN_PGRP_CODE	VARCHAR2(4)	Yes
NBBPOSN_WKSH_CODE	NBBPOSN_WKSH_CODE	VARCHAR2(4)	Yes		*
NBBPOSN_PREMIUM_ROLL_IND	NBBPOSN_PREMIUM_ROLL_IND	VARCHAR2(1)	No
NBBPOSN_PFOC_CODE	NBBPOSN_PFOC_CODE	VARCHAR2(3)	Yes
NBBPOSN_PNOC_CODE	NBBPOSN_PNOC_CODE	VARCHAR2(6)	Yes
NBBPOSN_DOTT_CODE	NBBPOSN_DOTT_CODE	VARCHAR2(11)	Yes
NBBPOSN_CHANGE_DATE_TIME	NBBPOSN_CHANGE_DATE_TIME	DATE	No
NBBPOSN_CALIF_TYPE	NBBPOSN_CALIF_TYPE	VARCHAR2(1)	Yes
NBBPOSN_EXEMPT_IND	NBBPOSN_EXEMPT_IND	VARCHAR2(1)	No
NBBPOSN_JBLN_CODE	NBBPOSN_JBLN_CODE	VARCHAR2(6)	Yes
NBBPOSN_BARG_CODE	NBBPOSN_BARG_CODE	VARCHAR2(2)	Yes
NBBPOSN_PROBATION_UNITS	NBBPOSN_PROBATION_UNITS	NUMBER(3,0)	Yes
NBBPOSN_COMMENT	NBBPOSN_COMMENT	VARCHAR2(2000)	Yes
NBBPOSN_ACCRUE_SENIORITY_IND	NBBPOSN_ACCRUE_SENIORITY_IND	VARCHAR2(1)	No
NBBPOSN_JOBP_CODE	NBBPOSN_JOBP_CODE	VARCHAR2(5)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
NBBPOSN_WKSH_CODE	NTVWKSH_CODE	NTVWKSH
NBBPOSN_PCLS_CODE	NTRPCLS_CODE	NTRPCLS
NBBPOSN_PCLS_CODE	PERSNBL_PCLS_CODE	PERSNBL
NBBPOSN_ECLS_CODE	PTREERN_ECLS_CODE	PTREERN
NBBPOSN_POSN	NBRJOBS_SUPERVISOR_POSN	NBRJOBS
NBBPOSN_POSN	NBRJOBS_POSN	NBRJOBS

Index

Index Name	Index Type	Column Name
PK_NBBPOSN	Unique	NBBPOSN_POSN

Comments

Source Code Comments

Position Base Table

Columns Comments for NBBPOSN_POSN (1)

Source Code Comments

Position.

Columns Comments for NBBPOSN_STATUS (2)

Source Code Comments

Status.

Columns Comments for NBBPOSN_TITLE (3)

Source Code Comments

Title.

Columns Comments for NBBPOSN_PLOC_CODE (4)

Source Code Comments

Position Location code.

Columns Comments for NBBPOSN_BEGIN_DATE (5)

Source Code Comments

POSITION BEGIN DATE: First date the position is funded to begin.

Columns Comments for NBBPOSN_END_DATE (6)

Source Code Comments

POSITION END DATE: End date of the position. If null, the position is presumed to be a permanent position.

Columns Comments for NBBPOSN_TYPE (7)

Source Code Comments

Single or pooled position.

Columns Comments for NBBPOSN_PCLS_CODE (8)

Source Code Comments

POSITION CLASS CODE: The position class the defined position is assigned to.

Columns Comments for NBBPOSN_ECLS_CODE (9)

Source Code Comments

POSITION EMPLOYEE CLASS CODE: Employee class code defaults from the Position Class Rule Form but can be overriden.

Columns Comments for NBBPOSN_POSN_REPORTS (10)

Source Code Comments

Position that this position reports to. A superior.

Columns Comments for NBBPOSN_AUTH_NUMBER (11)

Source Code Comments

POSITION AUTHORIZED NUMBER: The position number that authorized the approval of the defined position.

Columns Comments for NBBPOSN_TABLE (12)

Source Code Comments

Salary table.

Columns Comments for NBBPOSN_GRADE (13)

Source Code Comments

SALARY GRADE: Position salary grade defaults from the Position Class Rule Form but can be overriden.

Columns Comments for NBBPOSN_STEP (14)

Source Code Comments

Salary step.

Columns Comments for NBBPOSN_APPT_PCT (15)

Source Code Comments

POSITION APPOINTMENT PERCENT: Appointment percent indicates the percentage of full time the position uses. The salary, leave accrual and budget rolls are modified by this percentage.

Columns Comments for NBBPOSN_CIPC_CODE (16)

Source Code Comments

COLLEGE INSTRUCTIONAL PROGRAM CODE: Predefined codes that are validated against the Student College Instructional Validation Form.

Columns Comments for NBBPOSN_ROLL_IND (17)

Source Code Comments

Budget roll indicator.

Columns Comments for NBBPOSN_COAS_CODE (18)

Source Code Comments

Position Chart of Accounts Code: Valued only if Banner Finance is installed

Columns Comments for NBBPOSN_ACTIVITY_DATE (19)

Source Code Comments

Date of last activity on this record.

Columns Comments for NBBPOSN_SGRP_CODE (20)

Source Code Comments

Salary Group: The Salary group that the table/grade on position belongs to.

Columns Comments for NBBPOSN_PGRP_CODE (21)

Source Code Comments

PGRP_CODE: The Position Group code.

Columns Comments for NBBPOSN_WKSH_CODE (22)

Source Code Comments

WORK SCHEDULE CODE: Determines if a Work Schedule is defaulted when a job is established.

Columns Comments for NBBPOSN_PREMIUM_ROLL_IND (23)

Source Code Comments

PREMIUM EARNINGS ROLL INDICATOR: Indicator that specifies how to roll budget for premium earnings. Values are (C)urrent Budget Amount, (A)ctual Expenditure for Current Year, (Z)ero, or (N)ot Applicable.

Columns Comments for NBBPOSN_PFOC_CODE (24)

Source Code Comments

FEDERAL OCCUPATIONAL CODE: Federal Occupational Code.

Columns Comments for NBBPOSN_PNOC_CODE (25)

Source Code Comments

NATIONAL OCCUPATIONAL CODE: National Occupational Code.

Columns Comments for NBBPOSN_DOTT_CODE (26)

Source Code Comments

OCCUPATIONAL TITLE CODE:field specifies the Dictionary of Positions Occupational Titles Code.

Columns Comments for NBBPOSN_CHANGE_DATE_TIME (27)

Source Code Comments

CHANGE DATE TIME: Date and Time this record was changed.

Columns Comments for NBBPOSN_CALIF_TYPE (28)

Source Code Comments

CALIFORNIA TYPE:
California Pension Position Class Type.

Columns Comments for NBBPOSN_EXEMPT_IND (29)

Source Code Comments

EXEMPTION INDICATOR: Indicates if employees assigned to positions in this Position Class will be exempt or non-exempt.

Columns Comments for NBBPOSN_JBLN_CODE (30)

Source Code Comments

JOB LOCATION CODE: Code associated with this Position.

Columns Comments for NBBPOSN_BARG_CODE (31)

Source Code Comments

BARGAINING UNIT CODE: Code associated with this Position.

Columns Comments for NBBPOSN_PROBATION_UNITS (32)

Source Code Comments

PROBATION UNITS: Identifies the number of Probationary Units.

Columns Comments for NBBPOSN_COMMENT (33)

Source Code Comments

COMMENT: This field stores user comments.

Columns Comments for NBBPOSN_ACCRUE_SENIORITY_IND (34)

Source Code Comments

ACCRUE SENIORITY INDICATOR: This indicator will denote whether seniority hours are accrued against the position.

Columns Comments for NBBPOSN_JOBP_CODE (35)

Source Code Comments

JOB PROGRESSION CODE: Job Progression code associated with the position.

Table NBBWKSH

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:12:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK
NBBWKSH_PIDM	NBBWKSH_PIDM	NUMBER(8,0)	No	*
NBBWKSH_POSN	NBBWKSH_POSN	VARCHAR2(6)	No	*
NBBWKSH_SUFF	NBBWKSH_SUFF	VARCHAR2(2)	No	*
NBBWKSH_EFFECTIVE_DATE	NBBWKSH_EFFECTIVE_DATE	DATE	No	*
NBBWKSH_SCHEDULE_BEGIN_DAY	NBBWKSH_SCHEDULE_BEGIN_DAY	NUMBER(3,0)	No
NBBWKSH_SCHEDULE_END_DATE	NBBWKSH_SCHEDULE_END_DATE	DATE	Yes
NBBWKSH_ACTIVITY_DATE	NBBWKSH_ACTIVITY_DATE	DATE	No
NBBWKSH_DEEMED_HRS	NBBWKSH_DEEMED_HRS	NUMBER(6,2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_NBBWKSH	Unique	NBBWKSH_PIDM
PK_NBBWKSH	Unique	NBBWKSH_POSN
PK_NBBWKSH	Unique	NBBWKSH_SUFF
PK_NBBWKSH	Unique	NBBWKSH_EFFECTIVE_DATE

Comments

Source Code Comments

Work Schedule Base Table

Columns Comments for NBBWKSH_PIDM (1)

Source Code Comments

PIDM: Person Identification Number associated with the work schedule.

Columns Comments for NBBWKSH_POSN (2)

Source Code Comments

POSITION: Position number associated with the work schedule.

Columns Comments for NBBWKSH_SUFF (3)

Source Code Comments

SUFFIX: Suffix associated with the work schedule.

Columns Comments for NBBWKSH_EFFECTIVE_DATE (4)

Source Code Comments

EFFECTIVE DATE: Date the work schedule goes into effect for the assignment.

Columns Comments for NBBWKSH_SCHEDULE_BEGIN_DAY (5)

Source Code Comments

SCHEDULE BEGIN DAY: Number of the day on which the employee begins the schedule.

Columns Comments for NBBWKSH_SCHEDULE_END_DATE (6)

Source Code Comments

SCHEDULE END DATE: Date that schedule was no longer in effect for this assignment.

Columns Comments for NBBWKSH_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Columns Comments for NBBWKSH_DEEMED_HRS (8)

Source Code Comments

DEEMED HOURS: Reportable hours for Canadian Employment Insurance.

Table NBRBHIS

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:12:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL
NBRBHIS_POSN	NBRBHIS_POSN	VARCHAR2(6)	No
NBRBHIS_CAPTURE_DATE	NBRBHIS_CAPTURE_DATE	DATE	No
NBRBHIS_FISC_CODE	NBRBHIS_FISC_CODE	VARCHAR2(4)	No
NBRBHIS_COAS_CODE	NBRBHIS_COAS_CODE	VARCHAR2(1)	Yes
NBRBHIS_ORGN_CODE	NBRBHIS_ORGN_CODE	VARCHAR2(6)	No
NBRBHIS_BUDGET_FRNG	NBRBHIS_BUDGET_FRNG	NUMBER(11,2)	Yes
NBRBHIS_BUDGET_FTOT	NBRBHIS_BUDGET_FTOT	NUMBER(11,2)	Yes
NBRBHIS_BUDGET_PTOT	NBRBHIS_BUDGET_PTOT	NUMBER(11,2)	Yes
NBRBHIS_BUDGET_RTOT	NBRBHIS_BUDGET_RTOT	NUMBER(11,2)	Yes
NBRBHIS_ENCUMB_FRNG	NBRBHIS_ENCUMB_FRNG	NUMBER(11,2)	Yes
NBRBHIS_ENCUMB_PTOT	NBRBHIS_ENCUMB_PTOT	NUMBER(11,2)	Yes
NBRBHIS_EXPEND_FRNG	NBRBHIS_EXPEND_FRNG	NUMBER(11,2)	Yes
NBRBHIS_EXPEND_FTOT	NBRBHIS_EXPEND_FTOT	NUMBER(11,2)	Yes
NBRBHIS_EXPEND_PTOT	NBRBHIS_EXPEND_PTOT	NUMBER(11,2)	Yes
NBRBHIS_EXPEND_RTOT	NBRBHIS_EXPEND_RTOT	NUMBER(11,2)	Yes
NBRBHIS_FTE	NBRBHIS_FTE	NUMBER(7,4)	Yes
NBRBHIS_OBUD_CODE	NBRBHIS_OBUD_CODE	VARCHAR2(6)	Yes
NBRBHIS_OBPH_CODE	NBRBHIS_OBPH_CODE	VARCHAR2(6)	Yes
NBRBHIS_SGRP_CODE	NBRBHIS_SGRP_CODE	VARCHAR2(6)	Yes
NBRBHIS_BDCA_CODE	NBRBHIS_BDCA_CODE	VARCHAR2(3)	Yes
NBRBHIS_EARN_CODE	NBRBHIS_EARN_CODE	VARCHAR2(3)	Yes
NBRBHIS_ACTIVITY_DATE	NBRBHIS_ACTIVITY_DATE	DATE	No
NBRBHIS_BUDG_BASIS	NBRBHIS_BUDG_BASIS	NUMBER(6,2)	Yes
NBRBHIS_ANN_BASIS	NBRBHIS_ANN_BASIS	NUMBER(6,2)	Yes
NBRBHIS_BASE_UNITS	NBRBHIS_BASE_UNITS	NUMBER(3,1)	Yes
NBRBHIS_APPT_PCT	NBRBHIS_APPT_PCT	NUMBER(5,2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_POSN
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_CAPTURE_DATE
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_FISC_CODE
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_COAS_CODE
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_ORGN_CODE
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_OBUD_CODE
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_OBPH_CODE
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_BDCA_CODE
NBRBHIS_KEY_INDEX	Unique	NBRBHIS_EARN_CODE

Comments

Source Code Comments

Budget History Table

Columns Comments for NBRBHIS_POSN (1)

Source Code Comments

POSITION: The position code associated with this budget.

Columns Comments for NBRBHIS_CAPTURE_DATE (2)

Source Code Comments

CAPTURE DATE: The date of the budget transaction.

Columns Comments for NBRBHIS_FISC_CODE (3)

Source Code Comments

FISCAL CODE: The fiscal year of the budget transaction.

Columns Comments for NBRBHIS_COAS_CODE (4)

Source Code Comments

CHART OF ACCOUNTS CODE: The BANNER Finance chart of accounts. This field is valued only if BANNER Finance is installed.

Columns Comments for NBRBHIS_ORGN_CODE (5)

Source Code Comments

ORGANIZATION CODE: The organization or department that owns the budget for this position.

Columns Comments for NBRBHIS_BUDGET_FRNG (6)

Source Code Comments

FRINGE CHARGE BACK BUDGET: The budgeted amount for the fringe charge back. This field will be valued only if the charge back function is used.

Columns Comments for NBRBHIS_BUDGET_FTOT (7)

Source Code Comments

FRINGE TOTAL BUDGET: The total budgeted amount for the fringe benefits of this position. This field will be valued only if fringe benefits are charged using actual amounts.

Columns Comments for NBRBHIS_BUDGET_PTOT (8)

Source Code Comments

POSITION TOTAL BUDGET: The total budgeted amount for this position in a fiscal year.

Columns Comments for NBRBHIS_BUDGET_RTOT (9)

Source Code Comments

PREMIUM EARNINGS TOTAL BUDGET: The total budgeted amount for the premium earnings of this position in a fiscal year.

Columns Comments for NBRBHIS_ENCUMB_FRNG (10)

Source Code Comments

FRINGE CHARGE BACK ENCUMBRANCE: The encumbered amount for the fringe charge back. This field will be valued only if the charge back function is used.

Columns Comments for NBRBHIS_ENCUMB_PTOT (11)

Source Code Comments

TOTAL POSITION ENCUMBRANCE: The encumbered amount for the position.

Columns Comments for NBRBHIS_EXPEND_FRNG (12)

Source Code Comments

FRINGE CHARGE BACK EXPENDITURE: The expended amount for the fringe charge back. This field will be valued only if the charge back function is used.

Columns Comments for NBRBHIS_EXPEND_FTOT (13)

Source Code Comments

FRINGE TOTAL EXPENDITURE: The expended amount for the fringe benefits of this position. This field will be valued only if the actual amounts of fringe benefits are used.

Columns Comments for NBRBHIS_EXPEND_PTOT (14)

Source Code Comments

POSITION TOTAL EXPENDITURE: The expended amount for the position.

Columns Comments for NBRBHIS_EXPEND_RTOT (15)

Source Code Comments

PREMIUM EARNINGS TOTAL EXPENDITURE: The expended amount for the premium earnings associated with this position.

Columns Comments for NBRBHIS_FTE (16)

Source Code Comments

FULL TIME EQUIVALENCY: The full time equivalency percentage assigned to this job.

Columns Comments for NBRBHIS_OBUD_CODE (17)

Source Code Comments

BUDGET ID: The BANNER Finance Budget ID code associated with this position budget. This field will be valued only when BANNER Finance is installed.

Columns Comments for NBRBHIS_OBPH_CODE (18)

Source Code Comments

BUDGET PHASE: The BANNER Finance Budget Phase code associated with this position budget. This field will be valued only when BANNER Finance is installed.

Columns Comments for NBRBHIS_SGRP_CODE (19)

Source Code Comments

BUDGET SALARY GROUP CODE: The salary group code used as the parameter during the budget roll process.

Columns Comments for NBRBHIS_BDCA_CODE (20)

Source Code Comments

BENEFIT/DEDUCTION CODE: A code that identifies the Benefit/Deduction category.

Columns Comments for NBRBHIS_EARN_CODE (21)

Source Code Comments

EARNINGS CODE: A code that identifies the Premium Earning.

Columns Comments for NBRBHIS_ACTIVITY_DATE (22)

Source Code Comments

ACTIVITY DATE: Date of last activity for this record.

Columns Comments for NBRBHIS_BUDG_BASIS (23)

Source Code Comments

POSITION BUDGET BASIS: The period of the Position Annual Basis to be worked.

Columns Comments for NBRBHIS_ANN_BASIS (24)

Source Code Comments

POSITION ANNUAL BASIS: The period of time a position is based upon or budgeted for.

Columns Comments for NBRBHIS_BASE_UNITS (25)

Source Code Comments

BASE UNITS: The number of pay periods for the position.

Columns Comments for NBRBHIS_APPT_PCT (26)

Source Code Comments

APPOINTMENT PERCENT: The effort for the position.

Table NBRBJLH

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:12:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL
NBRBJLH_PIDM	NBRBJLH_PIDM	NUMBER(8,0)	No
NBRBJLH_POSN	NBRBJLH_POSN	VARCHAR2(6)	No
NBRBJLH_SUFF	NBRBJLH_SUFF	VARCHAR2(2)	No
NBRBJLH_EFFECTIVE_DATE	NBRBJLH_EFFECTIVE_DATE	DATE	No
NBRBJLH_CAPTURE_DATE	NBRBJLH_CAPTURE_DATE	DATE	No
NBRBJLH_CHANGE_REASON	NBRBJLH_CHANGE_REASON	VARCHAR2(60)	Yes
NBRBJLH_USER_ID	NBRBJLH_USER_ID	VARCHAR2(30)	No
NBRBJLH_ACTIVITY_DATE	NBRBJLH_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
NBRBJLH_KEY_INDEX		NBRBJLH_PIDM
NBRBJLH_KEY_INDEX		NBRBJLH_POSN
NBRBJLH_KEY_INDEX		NBRBJLH_SUFF
NBRBJLH_KEY_INDEX		NBRBJLH_EFFECTIVE_DATE
NBRBJLH_KEY_INDEX		NBRBJLH_CAPTURE_DATE

Comments

Source Code Comments

Base Job Labor Distribution History Table

Columns Comments for NBRBJLH_PIDM (1)

Source Code Comments

Internal ID number.

Columns Comments for NBRBJLH_POSN (2)

Source Code Comments

POSITION: The position number this job is attached to.

Columns Comments for NBRBJLH_SUFF (3)

Source Code Comments

SUFFIX: Job suffix.

Columns Comments for NBRBJLH_EFFECTIVE_DATE (4)

Source Code Comments

EFFECTIVE DATE: The date on which this Labor Distribution started.

Columns Comments for NBRBJLH_CAPTURE_DATE (5)

Source Code Comments

CAPTURE DATE: The date of the budget transaction.

Columns Comments for NBRBJLH_CHANGE_REASON (6)

Source Code Comments

CHANGE REASON: Reason for changing the Labor Distribution.

Columns Comments for NBRBJLH_USER_ID (7)

Source Code Comments

USER ID: Captures the user who created/updated the record.

Columns Comments for NBRBJLH_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: Date of last activity for this record.

Table NBRBJOB

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:09:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
NBRBJOB_PIDM	NBRBJOB_PIDM	NUMBER(8,0)	No	*	*
NBRBJOB_PIDM	NBRBJOB_PIDM	NUMBER(8,0)	No	*	*
NBRBJOB_PIDM	NBRBJOB_PIDM	NUMBER(8,0)	No	*	*
NBRBJOB_POSN	NBRBJOB_POSN	VARCHAR2(6)	No	*	*
NBRBJOB_POSN	NBRBJOB_POSN	VARCHAR2(6)	No	*	*
NBRBJOB_POSN	NBRBJOB_POSN	VARCHAR2(6)	No	*	*
NBRBJOB_SUFF	NBRBJOB_SUFF	VARCHAR2(2)	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	PEBEMPL_PIDM	PEBEMPL
NBRBJOB_SUFF	NBRJOBS_SUFF	NBRJOBS
NBRBJOB_POSN	NBRJOBS_POSN	NBRJOBS
NBRBJOB_PIDM	NBRJOBS_PIDM	NBRJOBS
NBRBJOB_END_DATE	NBRJOBS_EFFECTIVE_DATE	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

Comments

Source Code Comments

Assignment Repeating Base Table

Columns Comments for NBRBJOB_PIDM (1)

Source Code Comments

Internal ID number.

Columns Comments for NBRBJOB_POSN (2)

Source Code Comments

POSITION: The position number this job is attached to.

Columns Comments for NBRBJOB_SUFF (3)

Source Code Comments

SUFFIX: Job suffix.

Columns Comments for NBRBJOB_BEGIN_DATE (4)

Source Code Comments

BEGIN DATE: Begin date of the job.

Columns Comments for NBRBJOB_END_DATE (5)

Source Code Comments

END DATE: The date the job is scheduled to end. If left blank, the job is indefinite

Columns Comments for NBRBJOB_DEFER_BAL (6)

Source Code Comments

DEFERRED BALANCE: The amount of deferred pay accumulated for this job.

Columns Comments for NBRBJOB_CONTRACT_TYPE (7)

Source Code Comments

Job Type: Indicates whether this is the (P)rimary, (S)econdary, or (O)verload job.

Columns Comments for NBRBJOB_SALARY_ENCUMBRANCE (8)

Source Code Comments

SALARY ENCUMBRANCE: The amount of money that this person will be paid in this job during the current fiscal year.

Columns Comments for NBRBJOB_CONTRACT_BEGIN_DATE (9)

Source Code Comments

CONTRACT START DATE: Start date of the contract.

Columns Comments for NBRBJOB_CONTRACT_END_DATE (10)

Source Code Comments

CONTRACT END DATE: End date of the contract.

Columns Comments for NBRBJOB_TOTAL_CONTRACT_HRS (11)

Source Code Comments

TOTAL CONTRACT HOURS: The total number of hours of the contract. This is especially helpful if a contract spans multiple fiscal years.

Columns Comments for NBRBJOB_TOTAL_ENCUMBRANCE_HRS (12)

Source Code Comments

TOTAL ENCUMBRANCE HOURS: The sum of the NBRJOBS_ENCUMBRANCE_HRS for the currently active fiscal year.

Columns Comments for NBRBJOB_STEP_INCR_MON (13)

Source Code Comments

STEP INCREASE MONTH: Month in which an automatic step increase is to take place.

Columns Comments for NBRBJOB_STEP_INCR_DAY (14)

Source Code Comments

STEP INCREASE DAY: Day of the month in which an automatic step increase is to take place.