Tables and Views for POSNCTL as of 21-JUN-2004 08:21am
Date: 21-JUN-2004 Page: 1
TABLE: ADDL_EARN
CREATOR: POSNCTL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SSN VARCHAR2 9 YES
PIDM NUMBER 8 YES
POSN VARCHAR2 6 YES
EARNCD VARCHAR2 3 YES
EFF_DATE VARCHAR2 9 YES
DEPTID VARCHAR2 6 YES
ACCT VARCHAR2 4 YES
AMOUNT NUMBER 11 2 YES
END_DATE VARCHAR2 9 YES
Date: 21-JUN-2004 Page: 2
TABLE: ADDL_EARN_GA_DUPES
CREATOR: POSNCTL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
COUNT NUMBER 1 YES
PIDM NUMBER 8 YES
Date: 21-JUN-2004 Page: 3
TABLE: CDT
CREATOR: POSNCTL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NEW_EMPLID VARCHAR2 9 YES
SSN VARCHAR2 9 YES
LASTNAME VARCHAR2 20 YES
FIRSTNAME VARCHAR2 15 YES
PDT_PAYGROUP VARCHAR2 3 YES
PDT_EMPL_STATUS VARCHAR2 1 YES
Date: 21-JUN-2004 Page: 4
TABLE: CDT_GA
CREATOR: POSNCTL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NEW_EMPLID VARCHAR2 9 YES
SSN VARCHAR2 9 YES
LASTNAME VARCHAR2 20 YES
FIRSTNAME VARCHAR2 15 YES
PDT_PAYGROUP VARCHAR2 3 YES
PDT_EMPL_STATUS VARCHAR2 1 YES
Date: 21-JUN-2004 Page: 5
TABLE: EXCEPTIONS
CREATOR: POSNCTL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ROW_ID ROWID 10 YES
OWNER VARCHAR2 30 YES
TABLE_NAME VARCHAR2 30 YES
CONSTRAINT VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 6
TABLE: GJBJOBS_INSTALL
CREATOR: POSNCTL
posnctl GJBJOBS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBJOBS_NAME VARCHAR2 30 NO
GJBJOBS_TITLE VARCHAR2 30 NO
GJBJOBS_ACTIVITY_DATE DATE 7 NO
GJBJOBS_SYSI_CODE VARCHAR2 2 YES
GJBJOBS_JOB_TYPE_IND VARCHAR2 1 YES
GJBJOBS_DESC VARCHAR2 240 YES
GJBJOBS_COMMAND_NAME VARCHAR2 30 YES
GJBJOBS_PRNT_FORM VARCHAR2 30 YES
GJBJOBS_PRNT_CODE VARCHAR2 30 YES
GJBJOBS_LINE_COUNT NUMBER 3 YES
GJBJOBS_VALIDATION VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 7
TABLE: GJBPDEF_INSTALL
CREATOR: POSNCTL
posnctl GJBPDEF rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDEF_JOB VARCHAR2 30 NO
GJBPDEF_NUMBER VARCHAR2 2 NO
GJBPDEF_DESC VARCHAR2 30 NO
GJBPDEF_LENGTH NUMBER 2 NO
GJBPDEF_TYPE_IND VARCHAR2 1 NO
GJBPDEF_OPTIONAL_IND VARCHAR2 1 NO
GJBPDEF_SINGLE_IND VARCHAR2 1 NO
GJBPDEF_ACTIVITY_DATE DATE 7 NO
GJBPDEF_LOW_RANGE VARCHAR2 30 YES
GJBPDEF_HIGH_RANGE VARCHAR2 30 YES
GJBPDEF_HELP_TEXT VARCHAR2 78 YES
GJBPDEF_VALIDATION VARCHAR2 30 YES
GJBPDEF_LIST_VALUES VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 8
TABLE: GJBPDFT_INSTALL
CREATOR: POSNCTL
posnctl GJBPDFT rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDFT_JOB VARCHAR2 30 NO
GJBPDFT_NUMBER VARCHAR2 2 NO
GJBPDFT_ACTIVITY_DATE DATE 7 NO
GJBPDFT_USER_ID VARCHAR2 30 YES
GJBPDFT_VALUE VARCHAR2 30 YES
GJBPDFT_JPRM_CODE VARCHAR2 15 YES
Date: 21-JUN-2004 Page: 9
TABLE: GJBPVAL_INSTALL
CREATOR: POSNCTL
posnctl GJBPVAL rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPVAL_JOB VARCHAR2 30 NO
GJBPVAL_NUMBER VARCHAR2 2 NO
GJBPVAL_VALUE VARCHAR2 30 NO
GJBPVAL_DESC VARCHAR2 30 NO
GJBPVAL_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 10
TABLE: GUBBHLP_INSTALL
CREATOR: POSNCTL
posnctl GUBBHLP rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBBHLP_FORM_NAME VARCHAR2 30 NO
GUBBHLP_BLOCK_NAME VARCHAR2 30 YES
GUBBHLP_FIELD_NAME VARCHAR2 30 YES
GUBBHLP_TEXT LONG NO
GUBBHLP_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 11
TABLE: GUBOBJS_INSTALL
CREATOR: POSNCTL
posnctl GUBOBJS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBOBJS_NAME VARCHAR2 30 NO
GUBOBJS_DESC VARCHAR2 80 NO
GUBOBJS_OBJT_CODE VARCHAR2 10 NO
GUBOBJS_SYSI_CODE VARCHAR2 2 NO
GUBOBJS_USER_ID VARCHAR2 30 NO
GUBOBJS_ACTIVITY_DATE DATE 7 NO
GUBOBJS_HELP_IND VARCHAR2 1 NO
GUBOBJS_EXTRACT_ENABLED_IND VARCHAR2 1 NO
Date: 21-JUN-2004 Page: 12
TABLE: GURAOBJ_INSTALL
CREATOR: POSNCTL
posnctl GURAOBJ rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURAOBJ_OBJECT VARCHAR2 30 NO
GURAOBJ_DEFAULT_ROLE VARCHAR2 30 NO
GURAOBJ_CURRENT_VERSION VARCHAR2 10 NO
GURAOBJ_SYSI_CODE VARCHAR2 2 NO
GURAOBJ_ACTIVITY_DATE DATE 7 NO
GURAOBJ_CHECKSUM VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 13
TABLE: GURDMOD_INSTALL
CREATOR: POSNCTL
posnctl GURDMOD rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURDMOD_CODE VARCHAR2 30 YES
GURDMOD_DATE DATE 7 YES
GURDMOD_APPLIED_BY_USER VARCHAR2 30 YES
GURDMOD_OBJECT VARCHAR2 30 YES
GURDMOD_DESC VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 14
TABLE: GURMENU_INSTALL
CREATOR: POSNCTL
posnctl GURMENU rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURMENU_NAME VARCHAR2 30 NO
GURMENU_OBJ_NAME VARCHAR2 30 NO
GURMENU_SORT_SEQ NUMBER NO
GURMENU_USER_ID VARCHAR2 30 NO
GURMENU_ACTIVITY_DATE DATE 7 NO
GURMENU_DESC VARCHAR2 80 YES
Date: 21-JUN-2004 Page: 15
TABLE: GUROPTM_INSTALL
CREATOR: POSNCTL
posnctl GUROPTM rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUROPTM_SORT_SEQ NUMBER 5 2 YES
GUROPTM_TYPE_IND VARCHAR2 1 NO
GUROPTM_FORM_NAME VARCHAR2 30 NO
GUROPTM_NAME1 VARCHAR2 30 NO
GUROPTM_NAME1_DESC VARCHAR2 60 YES
GUROPTM_NAME2 VARCHAR2 61 YES
GUROPTM_CAPACITY VARCHAR2 1 YES
GUROPTM_TRG_NAME VARCHAR2 30 YES
GUROPTM_TRG_TYPE VARCHAR2 1 YES
GUROPTM_BLOCK_VALID VARCHAR2 30 YES
GUROPTM_ACTIVITY_DATE DATE 7 YES
GUROPTM_USER_ID VARCHAR2 30 NO
GUROPTM_FORM_TO_BE_CALLED VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 16
TABLE: NBBFISC
CREATOR: POSNCTL
Fiscal Year Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBBFISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: Code for the defined fiscal year.
NBBFISC_COAS_CODE VARCHAR2 1 YES FISCAL CHART OF ACCOUNTS CODE: Chart of accounts code
for the defined fiscal year. Valued only if Banner
Finance is installed.
NBBFISC_ACTIVE_IND VARCHAR2 1 NO ACTIVE FISCAL YEAR INDICATOR: Indicates if the defined
fiscal year is active
NBBFISC_BEGIN_DATE DATE 7 NO FISCAL YEAR BEGIN DATE: Begin date of the defined
fiscal year.
NBBFISC_END_DATE DATE 7 NO FISCAL YEAR END DATE: End date of the defined fiscal
year.
NBBFISC_ACTIVITY_DATE DATE 7 NO Date of the last activity for this record.
Date: 21-JUN-2004 Page: 17
TABLE: NBBPOSN
CREATOR: POSNCTL
Position Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBBPOSN_POSN VARCHAR2 6 NO Position.
NBBPOSN_STATUS VARCHAR2 1 NO Status.
NBBPOSN_TITLE VARCHAR2 30 NO Title.
NBBPOSN_PLOC_CODE VARCHAR2 6 YES Position Location code.
NBBPOSN_BEGIN_DATE DATE 7 NO POSITION BEGIN DATE: First date the position is funded
to begin.
NBBPOSN_END_DATE DATE 7 YES POSITION END DATE: End date of the position. If null,
the position is presumed to be a permanent position.
NBBPOSN_TYPE VARCHAR2 1 NO Single or pooled position.
NBBPOSN_PCLS_CODE VARCHAR2 5 NO POSITION CLASS CODE: The position class the defined
position is assigned to.
NBBPOSN_ECLS_CODE VARCHAR2 2 NO POSITION EMPLOYEE CLASS CODE: Employee class code
defaults from the Position Class Rule Form but can be
overriden.
NBBPOSN_POSN_REPORTS VARCHAR2 6 YES Position that this position reports to. A superior.
NBBPOSN_AUTH_NUMBER VARCHAR2 9 YES POSITION AUTHORIZED NUMBER: The position number that
authorized the approval of the defined position.
NBBPOSN_TABLE VARCHAR2 2 NO Salary table.
NBBPOSN_GRADE VARCHAR2 5 NO SALARY GRADE: Position salary grade defaults from the
Position Class Rule Form but can be overriden.
NBBPOSN_STEP NUMBER 3 YES Salary step.
NBBPOSN_APPT_PCT NUMBER 5 2 NO 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.
NBBPOSN_CIPC_CODE VARCHAR2 6 YES COLLEGE INSTRUCTIONAL PROGRAM CODE: Predefined codes
that are validated against the Student College
Instructional Validation Form.
NBBPOSN_ROLL_IND VARCHAR2 1 NO Budget roll indicator.
NBBPOSN_COAS_CODE VARCHAR2 1 YES Position Chart of Accounts Code: Valued only if Banner
Finance is installed
NBBPOSN_ACTIVITY_DATE DATE 7 NO Date of last activity on this record.
NBBPOSN_SGRP_CODE VARCHAR2 6 YES Salary Group: The Salary group that the table/grade on
position belongs to.
NBBPOSN_PGRP_CODE VARCHAR2 4 YES PGRP_CODE: The Position Group code.
NBBPOSN_WKSH_CODE VARCHAR2 4 YES WORK SCHEDULE CODE: Determines if a Work Schedule is
defaulted when a job is established.
NBBPOSN_PREMIUM_ROLL_IND VARCHAR2 1 NO 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.
NBBPOSN_PFOC_CODE VARCHAR2 3 YES FEDERAL OCCUPATIONAL CODE: Federal Occupational Code.
NBBPOSN_PNOC_CODE VARCHAR2 6 YES NATIONAL OCCUPATIONAL CODE: National Occupational
Code.
Date: 21-JUN-2004 Page: 18
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBBPOSN_DOTT_CODE VARCHAR2 11 YES OCCUPATIONAL TITLE CODE:field specifies the Dictionary
of Positions Occupational Titles Code.
NBBPOSN_CHANGE_DATE_TIME DATE 7 NO CHANGE DATE TIME: Date and Time this record was
changed.
NBBPOSN_CALIF_TYPE VARCHAR2 1 YES CALIFORNIA TYPE:
California Pension Position Class
Type.
NBBPOSN_EXEMPT_IND VARCHAR2 1 NO EXEMPTION INDICATOR: Indicates if employees assigned
to positions in this Position Class will be exempt or
non-exempt.
NBBPOSN_JBLN_CODE VARCHAR2 6 YES JOB LOCATION CODE: Code associated with this Position.
NBBPOSN_BARG_CODE VARCHAR2 2 YES BARGAINING UNIT CODE: Code associated with this
Position.
NBBPOSN_PROBATION_UNITS NUMBER 3 YES PROBATION UNITS: Identifies the number of Probationary
Units.
NBBPOSN_COMMENT VARCHAR2 2000 YES COMMENT: This field stores user comments.
NBBPOSN_ACCRUE_SENIORITY_IND VARCHAR2 1 NO ACCRUE SENIORITY INDICATOR: This indicator will denote
whether seniority hours are accrued against the
position.
NBBPOSN_JOBP_CODE VARCHAR2 5 YES JOB PROGRESSION CODE: Job Progression code associated
with the position.
NBBPOSN_BPRO_CODE VARCHAR2 6 YES BPRO CODE: Budget Profile code.
Date: 21-JUN-2004 Page: 19
TABLE: NBBWKSH
CREATOR: POSNCTL
Work Schedule Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBBWKSH_PIDM NUMBER 8 NO PIDM: Person Identification Number associated with the
work schedule.
NBBWKSH_POSN VARCHAR2 6 NO POSITION: Position number associated with the work
schedule.
NBBWKSH_SUFF VARCHAR2 2 NO SUFFIX: Suffix associated with the work schedule.
NBBWKSH_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the work schedule goes into
effect for the assignment.
NBBWKSH_SCHEDULE_BEGIN_DAY NUMBER 3 NO SCHEDULE BEGIN DAY: Number of the day on which the
employee begins the schedule.
NBBWKSH_SCHEDULE_END_DATE DATE 7 YES SCHEDULE END DATE: Date that schedule was no longer in
effect for this assignment.
NBBWKSH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
NBBWKSH_DEEMED_HRS NUMBER 6 2 YES DEEMED HOURS: Reportable hours for Canadian Employment
Insurance.
Date: 21-JUN-2004 Page: 20
TABLE: NBRBHIS
CREATOR: POSNCTL
Budget History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRBHIS_POSN VARCHAR2 6 NO POSITION: The position code associated with this
budget.
NBRBHIS_CAPTURE_DATE DATE 7 NO CAPTURE DATE: The date of the budget transaction.
NBRBHIS_FISC_CODE VARCHAR2 4 NO FISCAL CODE: The fiscal year of the budget
transaction.
NBRBHIS_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The BANNER Finance chart of
accounts. This field is valued only if BANNER Finance
is installed.
NBRBHIS_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: The organization or department that
owns the budget for this position.
NBRBHIS_BUDGET_FRNG NUMBER 11 2 YES 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.
NBRBHIS_BUDGET_FTOT NUMBER 11 2 YES 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.
NBRBHIS_BUDGET_PTOT NUMBER 11 2 YES POSITION TOTAL BUDGET: The total budgeted amount for
this position in a fiscal year.
NBRBHIS_BUDGET_RTOT NUMBER 11 2 YES PREMIUM EARNINGS TOTAL BUDGET: The total budgeted
amount for the premium earnings of this position in a
fiscal year.
NBRBHIS_ENCUMB_FRNG NUMBER 11 2 YES 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.
NBRBHIS_ENCUMB_PTOT NUMBER 11 2 YES TOTAL POSITION ENCUMBRANCE: The encumbered amount for
the position.
NBRBHIS_EXPEND_FRNG NUMBER 11 2 YES 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.
NBRBHIS_EXPEND_FTOT NUMBER 11 2 YES 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.
NBRBHIS_EXPEND_PTOT NUMBER 11 2 YES POSITION TOTAL EXPENDITURE: The expended amount for
the position.
NBRBHIS_EXPEND_RTOT NUMBER 11 2 YES PREMIUM EARNINGS TOTAL EXPENDITURE: The expended
amount for the premium earnings associated with this
position.
NBRBHIS_FTE NUMBER 7 4 YES FULL TIME EQUIVALENCY: The full time equivalency
percentage assigned to this job.
NBRBHIS_OBUD_CODE VARCHAR2 6 YES BUDGET ID: The BANNER Finance Budget ID code
associated with this position budget. This field will
be valued only when BANNER Finance is installed.
NBRBHIS_OBPH_CODE VARCHAR2 6 YES BUDGET PHASE: The BANNER Finance Budget Phase code
associated with this position budget. This field will
be valued only when BANNER Finance is installed.
Date: 21-JUN-2004 Page: 21
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRBHIS_SGRP_CODE VARCHAR2 6 YES BUDGET SALARY GROUP CODE: The salary group code used
as the parameter during the budget roll process.
NBRBHIS_BDCA_CODE VARCHAR2 3 YES BENEFIT/DEDUCTION CODE: A code that identifies the
Benefit/Deduction category.
NBRBHIS_EARN_CODE VARCHAR2 3 YES EARNINGS CODE: A code that identifies the Premium
Earning.
NBRBHIS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity for this record.
NBRBHIS_BUDG_BASIS NUMBER 6 2 YES POSITION BUDGET BASIS: The period of the Position
Annual Basis to be worked.
NBRBHIS_ANN_BASIS NUMBER 6 2 YES POSITION ANNUAL BASIS: The period of time a position
is based upon or budgeted for.
NBRBHIS_BASE_UNITS NUMBER 3 1 YES BASE UNITS: The number of pay periods for the
position.
NBRBHIS_APPT_PCT NUMBER 5 2 YES APPOINTMENT PERCENT: The effort for the position.
Date: 21-JUN-2004 Page: 22
TABLE: NBRBJLH
CREATOR: POSNCTL
Base Job Labor Distribution History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRBJLH_PIDM NUMBER 8 NO Internal ID number.
NBRBJLH_POSN VARCHAR2 6 NO POSITION: The position number this job is attached to.
NBRBJLH_SUFF VARCHAR2 2 NO SUFFIX: Job suffix.
NBRBJLH_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The date on which this Labor
Distribution started.
NBRBJLH_CAPTURE_DATE DATE 7 NO CAPTURE DATE: The date of the budget transaction.
NBRBJLH_CHANGE_REASON VARCHAR2 60 YES CHANGE REASON: Reason for changing the Labor
Distribution.
NBRBJLH_USER_ID VARCHAR2 30 NO USER ID: Captures the user who created/updated the
record.
NBRBJLH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity for this record.
Date: 21-JUN-2004 Page: 23
TABLE: NBRBJOB
CREATOR: POSNCTL
Assignment Repeating Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRBJOB_PIDM NUMBER 8 NO Internal ID number.
NBRBJOB_POSN VARCHAR2 6 NO POSITION: The position number this job is attached to.
NBRBJOB_SUFF VARCHAR2 2 NO SUFFIX: Job suffix.
NBRBJOB_BEGIN_DATE DATE 7 NO BEGIN DATE: Begin date of the job.
NBRBJOB_END_DATE DATE 7 YES END DATE: The date the job is scheduled to end. If
left blank, the job is indefinite
NBRBJOB_DEFER_BAL NUMBER 11 2 NO DEFERRED BALANCE: The amount of deferred pay
accumulated for this job.
NBRBJOB_CONTRACT_TYPE VARCHAR2 1 NO Job Type: Indicates whether this is the (P)rimary,
(S)econdary, or (O)verload job.
NBRBJOB_SALARY_ENCUMBRANCE NUMBER 11 2 NO SALARY ENCUMBRANCE: The amount of money that this
person will be paid in this job during the current
fiscal year.
NBRBJOB_CONTRACT_BEGIN_DATE DATE 7 YES CONTRACT START DATE: Start date of the contract.
NBRBJOB_CONTRACT_END_DATE DATE 7 YES CONTRACT END DATE: End date of the contract.
NBRBJOB_TOTAL_CONTRACT_HRS NUMBER 6 2 YES TOTAL CONTRACT HOURS: The total number of hours of the
contract. This is especially helpful if a contract
spans multiple fiscal years.
NBRBJOB_TOTAL_ENCUMBRANCE_HRS NUMBER 6 2 YES TOTAL ENCUMBRANCE HOURS: The sum of the
NBRJOBS_ENCUMBRANCE_HRS for the currently active
fiscal year.
NBRBJOB_STEP_INCR_MON VARCHAR2 2 YES STEP INCREASE MONTH: Month in which an automatic step
increase is to take place.
NBRBJOB_STEP_INCR_DAY VARCHAR2 2 YES STEP INCREASE DAY: Day of the month in which an
automatic step increase is to take place.
NBRBJOB_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Valued only when Banner
Finance is installed.
NBRBJOB_ACTIVITY_DATE DATE 7 NO Date of last activity for this record.
NBRBJOB_ACCRUE_LEAVE_IND VARCHAR2 1 NO ACCRUE LEAVE INDICATOR: Determines whether Leave is
accured for this job.
NBRBJOB_CIVIL_SERVICE_IND VARCHAR2 1 YES CIVIL SERVICE INDICATOR: Indicates if this assignment
is a civil service job.
NBRBJOB_ENCUMBRANCE_CHANGE_IND VARCHAR2 1 NO ENCUMBRANCE CHANGE INDICATOR: Indicates if the
encumbrance amount has changed for this job.
NBRBJOB_FRINGE_ENCUMBRANCE NUMBER 11 2 YES FRINGE ENCUMBRANCE: The cost of fringe benefits that
this person will be paid in this job during the
current fiscal year.
NBRBJOB_IPEDS_REPT_IND VARCHAR2 1 NO IPEDS Report Indicator.
NBRBJOB_FACL_STATSCAN_REPT_IND VARCHAR2 1 NO Faculty Statistical Canadian Report Indicator.
NBRBJOB_PROBATION_BEGIN_DATE DATE 7 YES BEGIN DATE: The begin date of Probationary Period.
NBRBJOB_PROBATION_END_DATE DATE 7 YES END DATE: The end date of Probationary Period.
NBRBJOB_PROBATION_UNITS NUMBER 3 YES PROBATION UNITS: Identifies the number of Probationary
Units.
NBRBJOB_ELIGIBLE_DATE DATE 7 YES ELIGIBLE DATE: Eligible Date for the Increase MM DD.
Date: 21-JUN-2004 Page: 24
TABLE: NBRBJQE
CREATOR: POSNCTL
Override Approvals Queue Base Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRBJQE_PIDM NUMBER 8 NO PIDM: Internal ID number
NBRBJQE_USER_ID VARCHAR2 30 NO USERID: The user id of the person who inserted or
updated the record
NBRBJQE_ACAT_CODE VARCHAR2 6 NO APPROVAL CATEGORY CODE: This
code represents the
purpose of personnel action
NBRBJQE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the
record was inserted or
updated.
NBRBJQE_POSN VARCHAR2 6 NO POSITION: The position number this
job is attached to
NBRBJQE_SUFF VARCHAR2 2 NO SUFFIX: Job suffix
Date: 21-JUN-2004 Page: 25
TABLE: NBRCLSH
CREATOR: POSNCTL
Position Classification History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRCLSH_CODE VARCHAR2 5 NO POSITION CLASS CODE: A code which identifies a
Position Class which can then be assigned to a
Position.
NBRCLSH_CHANGE_DATE_TIME DATE 7 NO CHANGE DATE TIME: Date and Time this record was
changed.
NBRCLSH_DESC VARCHAR2 30 NO POSITION CLASS DESCRIPTION: The description or title
for the Position Class.
NBRCLSH_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: A code which identifies the
Employee Class that is associated with this Position
Class, and will therefore default to the Position Form
(NBAPOSN) when the Position Class is entered.
NBRCLSH_ESKL_CODE VARCHAR2 2 YES EEO SKILL CODE: The EEO Skill Code as defined by the
U.S. Federal Goverment, for use by institutions of
higher education, for EEO reporting
NBRCLSH_EFUN_CODE VARCHAR2 2 YES EEO FUNCTION CODE: For goverment agencies only. The
EEO Function Code as defined by the U.S. Federal
Goverment, for use with EEO reporting.
NBRCLSH_EXEMPT_IND VARCHAR2 1 NO EXEMPTION INDICATOR: Indicates if employees assigned
to positions in this Position Class will be exempt or
non-exempt.
NBRCLSH_TABLE VARCHAR2 2 NO SALARY TABLE: The Salary Table as defined on the
Salary/Rate Rule Form (NTRSALA) that will be
associated with positions assigned to this Position
Class and will default to the Position Form (NBAPOSN).
NBRCLSH_GRADE VARCHAR2 5 YES SALARY GRADE: The Salary Grade, as defined on the
Salary/Rate Rule Form (NTRSALA), that is associated
with positions in this Position Class and will default
to the Position Form (NBAPOSN) when this Position
Class is entered
NBRCLSH_STEP NUMBER 3 YES SALARY STEP: The Salary Step associated with the
Salary Grade as defined on the Salary/Rate Rule Form
(NTRSALA) that will be associated with positions
assigned to this Position Class.
NBRCLSH_SGRP_CODE VARCHAR2 6 NO SGRP_CODE: The salary group code.
NBRCLSH_PGRP_CODE VARCHAR2 4 YES PGRP_CODE: The position group code.
NBRCLSH_USERID VARCHAR2 30 YES USERID: The userid of person who changed this record.
NBRCLSH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBRCLSH_BARG_CODE VARCHAR2 2 YES BARGAINING UNIT CODE: Code associated with this
Position Class.
NBRCLSH_PROBATION_UNITS NUMBER 3 YES PROBATION UNITS: Identifies the number of Probationary
Units.
NBRCLSH_ACCRUE_SENIORITY_IND VARCHAR2 1 NO ACCRUE SENIORITY INDICATOR:This indicator will denote
whether seniority hours are accrued against the
position class.
Date: 21-JUN-2004 Page: 26
TABLE: NBREARN
CREATOR: POSNCTL
Employee Default Earnings Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREARN_PIDM NUMBER 8 NO Internal ID number.
NBREARN_POSN VARCHAR2 6 NO POSITION: Position number.
NBREARN_SUFF VARCHAR2 2 NO SUFFIX: Suffix of the job.
NBREARN_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date that this earnings code record
becomes effective.
NBREARN_EARN_CODE VARCHAR2 3 NO EARNINGS CODE: The earnings code attached to this job.
NBREARN_ACTIVE_IND VARCHAR2 1 NO ACTIVE INDICATOR: Indicates whether the earnings code
is active.
NBREARN_HRS NUMBER 6 2 YES HOURS OR UNITS: Hours/units defaulted on timesheets
for this earn code.
NBREARN_SPECIAL_RATE NUMBER 12 6 YES SPECIAL RATE: Special Rate defaulted onto timesheets
for this earn code.
NBREARN_SHIFT VARCHAR2 1 NO SHIFT: Shift code defaulted onto timeshhets for this
earn code.
NBREARN_ACTIVITY_DATE DATE 7 NO Date of last activity for this record.
NBREARN_DEEMED_HRS NUMBER 6 2 YES DEEMED HOURS: Reportable hours for Canadian Employment
Insurance.
Date: 21-JUN-2004 Page: 27
TABLE: NBREHDR
CREATOR: POSNCTL
Salary Planner Extract Header Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREHDR_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBREHDR_SCENARIO VARCHAR2 30 NO SCENARIO: The Scenario code associated with this
Extract ID.
NBREHDR_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: The Fiscal Year associated with this
Extract ID.
NBREHDR_PTOT_STATUS VARCHAR2 1 NO POSITION BUDGET STATUS: The budget status associated
with this Extract ID, values are (W)orking or
(A)pproved.
NBREHDR_JOBS_EFFECTIVE_DATE DATE 7 NO JOBS EFFECTIVE DATE: The Effective Date from the Job
Effective Date parameter from the Extract Process.
NBREHDR_LOCK_IND VARCHAR2 1 NO LOCK INDICATOR: The Scenario Locked Indicator used by
the Extract Process to temporarily lock the Extract,
values are Y or N.
NBREHDR_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBREHDR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBREHDR_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The Chart of Accounts code
associated with this Extract ID.
NBREHDR_OBUD_CODE VARCHAR2 6 YES BUDGET ID CODE: The Budget ID aasociated with this
Extract ID.
NBREHDR_OBPH_CODE VARCHAR2 6 YES BUDGET PHASE CODE: The Budget Phase associated with
this Extract ID.
Date: 21-JUN-2004 Page: 28
TABLE: NBREJLD
CREATOR: POSNCTL
Extracted Job Labor Distribution Salary Planner Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREJLD_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBREJLD_SCENARIO VARCHAR2 30 NO SCENARIO: The Scenario code associated with this
record.
NBREJLD_PIDM NUMBER 8 NO PIDM: The internal identification number of the
employee associated with this record.
NBREJLD_POSN VARCHAR2 6 NO POSITION: The Position to which this Job is attached.
NBREJLD_SUFF VARCHAR2 2 NO SUFFIX: The Job Suffix associated with this record.
NBREJLD_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The proposed effective date. The
proposed effective date will be used to create a new
Job LD record during the upload.
NBREJLD_ORGN_CODE_POSN VARCHAR2 6 NO POSITION ORGANIZATION CODE: Identifies the
Administrative Organization (Organization responsible
for the Budget) associated with the Position.
NBREJLD_PERCENT_PROPOSED NUMBER 5 2 NO PERCENT PROPOSED: The proposed percentage associated
with this record/account code.
NBREJLD_RECORD_STATUS VARCHAR2 1 NO RECORD STATUS: Valid values are (N)o Changes,
(C)hanged, (U)ploaded. The record status indicates if
changes have been made to the record and if the record
needs to be uploaded or has already been upload
ed.
NBREJLD_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBREJLD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBREJLD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The proposed Chart of Accounts
code associated with this record.
NBREJLD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: The proposed Index code asociated
with the record. An index code is used to default the
account distribution. Valued only if Banner Finance
is installed.
NBREJLD_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the proposed Fund to which the
Job will be charged.
NBREJLD_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the proposed
Organization to which the Job will be charged.
NBREJLD_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Identifies the proposed Account to which
the Job will be charged.
NBREJLD_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Identifies the proposed Program to which
the Job will be charged.
NBREJLD_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: Identifies the proposed Acvitity to
which the Job will be charged.
NBREJLD_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Identifies the proposed Location to
which the Job will be charged.
NBREJLD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Identifies the proposed cost accounting
Project to which the Job will be charged.
Date: 21-JUN-2004 Page: 29
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREJLD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Identifies the proposed cost
accounting Cost Type to which the Job will be charged.
NBREJLD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES EXTERNAL ACCOUNT CODE: Identifies the proposed
Non-Banner Finance System Account Distribution Code to
which this job should be charged.
NBREJLD_TRANSACTION_NO NUMBER 15 YES TRANSACTION NUMBER: The Electronic Personnel Action
Form (EPAF) Transaction number assigned to the record
during the upload process.
Date: 21-JUN-2004 Page: 30
TABLE: NBREJOB
CREATOR: POSNCTL
Extracted Job Detail Salary Planner Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREJOB_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBREJOB_SCENARIO VARCHAR2 30 NO SCENARIO: Scenario code associated with this record.
NBREJOB_PIDM NUMBER 8 NO PIDM: The internal identification number of the
employee associated with this record.
NBREJOB_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
NBREJOB_SUFF VARCHAR2 2 NO SUFFIX: The Job Suffix associated with this record.
NBREJOB_EFFECTIVE_DATE DATE 7 NO BASE EFFECTIVE DATE: The effective date of the base
job record that was extracted.
NBREJOB_EFF_DATE_PROPOSED DATE 7 NO PROPOSED EFFECTIVE DATE: The effective date to be used
during Upload when creating a new Job Record.
NBREJOB_PERS_CHG_DATE DATE 7 NO PROPOSED PERSONNEL DATE: The personnel date to be used
during Upload when creating a new Job Record.
NBREJOB_ORGN_CODE_POSN VARCHAR2 6 NO POSITION ORGANIZATION CODE: Identifies the
organization that has budgetary responsibility for
this position.
NBREJOB_ECLS_CODE_POSN VARCHAR2 2 NO EMPLOYEE CLASS CODE POSITION: The Employee Class
associated with the position record (NBRPTOT) at the
time of extract.
NBREJOB_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: The Employee class associated
with this Job.
NBREJOB_ANN_SALARY NUMBER 11 2 NO BASE ANNUAL SALARY: The base or extracted Annual
Salary for this job.
NBREJOB_ANN_SALARY_PROPOSED NUMBER 11 2 NO PROPOSED ANNUAL SALARY: The proposed Annual Salary for
this job.
NBREJOB_APPT_PCT NUMBER 5 2 NO BASE JOB APPOINTMENT PERCENT: The Base Appointment
Percent identifies the percentage of Full Time the
employee is working in this Job.
NBREJOB_APPT_PCT_PROPOSED NUMBER 5 2 NO PROPOSED JOB APPOINTMENT PERCENT: The Proposed
Appointment Percent identifies the percentage of Full
Time the employee will work in this Job.
NBREJOB_HRS_DAY NUMBER 6 2 NO HOURS PER DAY: The number of hours an employee filling
this job normally works in a day.
NBREJOB_HRS_DAY_PROPOSED NUMBER 6 2 NO PROPOSED HOURS PER DAY: The proposed number of hours
an employee filling this job will normally work in a
day.
NBREJOB_HRS_PAY NUMBER 6 2 NO HOURS PER PAY: The number of hours an employee filling
this job normally works in a pay period.
NBREJOB_HRS_PAY_PROPOSED NUMBER 6 2 NO PROPOSED HOURS PER PAY: The proposed number of hours
an employee filling this job will normally work in a
pay period.
NBREJOB_SGRP_CODE VARCHAR2 6 NO BASE SALARY GROUP: The base or extracted Salary Group
associated with this job.
NBREJOB_SGRP_CODE_PROPOSED VARCHAR2 6 NO PROPOSED SALARY GROUP: The proposed Salary Group.
NBREJOB_BUDGET_FACTOR NUMBER 5 2 NO BUDGET FACTOR: The Budget Factor is used to calculate
the Estimated Fiscal Year Budget for the Job.
Date: 21-JUN-2004 Page: 31
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREJOB_EST_FY_BUDGET NUMBER 11 2 NO ESTIMATED FISCAL YEAR BUDGET: Calculated field
(Proposed Annual Salary * Budget Factor) + ((1 -
Budget Factor) * Base Annual Salary)
NBREJOB_EXCL_TOTALS_IND VARCHAR2 1 NO EXCLUDE TOTALS INDICATOR: Indicates whether to exclude
the values for this record from the totals for the
Organization and Employee. Valid values (Y)es or (N)o
NBREJOB_HIDE_IND VARCHAR2 1 NO HIDE INDICATOR: Indicates if this Job should be hidden
from Salary Planner web pages for Scenarios other than
"INITIAL". Valid values are (Y)es or (N)o.
NBREJOB_EXTRACT_STATUS VARCHAR2 1 NO EXTRACT STATUS: The status of this Job from the
extract, valid values are (I)nitial and (N)ew.
NBREJOB_RECORD_STATUS VARCHAR2 1 NO RECORD STATUS: Valid values are (N)o Changes,
(C)hanged, (U)ploaded. The record status indicates if
changes have been made to the record and if the record
needs to be uploaded or has already been upload
ed.
NBREJOB_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBREJOB_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBREJOB_DESC VARCHAR2 30 YES BASE JOB DESCRIPTION: The base or extracted job
description associated with this Position and Suffix.
NBREJOB_DESC_PROPOSED VARCHAR2 30 YES PROPOSED JOB DESCRIPTION: The proposed job description
associated with this Position and Suffix.
NBREJOB_REG_RATE NUMBER 11 6 YES BASE REGULAR RATE: The base or extracted hourly rate
for this job.
NBREJOB_REG_RATE_PROPOSED NUMBER 11 6 YES PROPOSED REGULAR RATE: The proposed regular hourly
rate for this job.
NBREJOB_FTE NUMBER 6 3 YES BASE FULL TIME EQUIVALENCY: The full time equivalency
percentage assigned to this Job.
NBREJOB_FTE_PROPOSED NUMBER 6 3 YES PROPOSED FULL TIME EQUIVALENCY: The proposed full time
equivalency percentage assigned to this Job.
NBREJOB_SAL_TABLE VARCHAR2 2 YES BASE SALARY TABLE: The base or extracted Salary Table
associated with this job.
NBREJOB_SAL_TABLE_PROPOSED VARCHAR2 2 YES PROPOSED SALARY TABLE: The proposed Salary Table.
NBREJOB_SAL_GRADE VARCHAR2 5 YES BASE SALARY GRADE: The base or extracted Salary Grade
associated with this job.
NBREJOB_SAL_GRADE_PROPOSED VARCHAR2 5 YES PROPOSED SALARY GRADE: The proposed Salary Grade.
NBREJOB_SAL_STEP NUMBER 3 YES BASE SALARY STEP: The base or extracted Salary Step
associated with this job.
NBREJOB_SAL_STEP_PROPOSED NUMBER 3 YES PROPOSED SALARY STEP: The proposed Salary Step.
NBREJOB_RANK_CODE VARCHAR2 2 YES RANK CODE: Faculty rank code.
NBREJOB_COMMENTS VARCHAR2 1300 YES COMMENTS: User comments entered in Salary Planner for
this Job.
NBREJOB_FACTOR NUMBER 4 YES PAY FACTOR: The number of pays per calendar year.
NBREJOB_PAYS NUMBER 4 YES PAYS PER YEAR: The number of pays the employee will
receive in a calendar year.
NBREJOB_EMPR_CODE VARCHAR2 4 YES EMPLOYER CODE: The Employer Code assigned to the Job.
NBREJOB_ROUNDING_METHOD NUMBER 6 2 YES ROUNDING METHOD: The rounding method used when salary
changes were applied to the Job. Valid values are:
None (null), 1.00, 10.00, and 100.00.
Date: 21-JUN-2004 Page: 32
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREJOB_TRANSACTION_NO NUMBER 15 YES TRANSACTION NUMBER: The Electronic Personnel Action
Form (EPAF) Transaction number assigned to the record
during the upload process.
Date: 21-JUN-2004 Page: 33
TABLE: NBREPLD
CREATOR: POSNCTL
Extracted Position Labor Distribution Salary Planner Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREPLD_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBREPLD_SCENARIO VARCHAR2 30 NO SCENARIO: Scenario code associated with this record.
NBREPLD_POSN VARCHAR2 6 NO POSITION: The Position to which this Labor
Distribution record is attached.
NBREPLD_ORGN_CODE_POSN VARCHAR2 6 NO POSITION ORGANIZATION CODE: Identifies the
organization that has budgetary responsibility for
this position.
NBREPLD_PERCENT_PROPOSED NUMBER 5 2 NO PERCENT PROPOSED: The proposed percentage associated
with this record/account code.
NBREPLD_RECORD_STATUS VARCHAR2 1 NO RECORD STATUS: Valid values are (N)o Changes,
(C)hanged, (U)ploaded. The record status indicates if
changes have been made to the record and if the record
needs to be uploaded or has already been upload
ed.
NBREPLD_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBREPLD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBREPLD_BUDGET_PROPOSED NUMBER 11 2 YES BUDGET PROPOSED: The proposed budget amount associated
with this record based on the Percent Proposed.
NBREPLD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The proposed Chart of Accounts
code associated with this record.
NBREPLD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: The proposed Index code asociated
with the record. An index code is used to default the
account distribution. Valued only if Banner Finance
is installed.
NBREPLD_FUND_CODE VARCHAR2 6 YES FUND CODE: Identifies the proposed Fund to which the
Position will be charged.
NBREPLD_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Identifies the proposed
Organization to which the Position will be charged.
NBREPLD_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Identifies the proposed Account to which
the Position will be charged.
NBREPLD_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Identifies the proposed Program to which
the Position will be charged.
NBREPLD_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: Identifies the proposed Acvitity to
which the Position will be charged.
NBREPLD_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Identifies the proposed Location to
which the Position will be charged.
NBREPLD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Identifies the proposed cost accounting
Project to which the Position will be charged.
NBREPLD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Identifies the proposed cost
accounting Cost Type to which the Position will be
charged.
NBREPLD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES EXTERNAL ACCOUNT CODE: Identifies the proposed
Non-Banner Finance System Account Distribution Code to
which this Position should be charged.
Date: 21-JUN-2004 Page: 34
TABLE: NBREPSA
CREATOR: POSNCTL
Extracted Position Salary Planner Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREPSA_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBREPSA_SCENARIO VARCHAR2 30 NO SCENARIO: Scenario code associated with this record.
NBREPSA_POSN VARCHAR2 6 NO POSITION: The Positions which are extracted from the
Extract Process.
NBREPSA_PTOT_EFFECTIVE_DATE DATE 7 NO POSITION TOTAL EFFECTIVE DATE: The effective date on
the Position Budget Totals Table (NBRPTOT) record that
was extracted.
NBREPSA_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: The Organization that has budgetary
responsibility for the position.
NBREPSA_ECLS_CODE_POSN VARCHAR2 2 NO EMPLOYEE CLASS CODE POSITION: The Employee Class of
the position.
NBREPSA_POSN_TYPE VARCHAR2 1 NO POSITION TYPE: The Position Type, valid values are
(P)ool or (S)ingle.
NBREPSA_FTE NUMBER 7 4 NO BASE FULL TIME EQUIVALENCY: The full time equivalency
percentage assigned to this Position.
NBREPSA_FTE_PROPOSED NUMBER 7 4 NO PROPOSED FULL TIME EQUIVALENCY: The proposed full time
equivalency percentage assigned to this Position.
NBREPSA_APPT_PCT NUMBER 5 2 NO
NBREPSA_APPT_PCT_PROPOSED NUMBER 5 2 NO
NBREPSA_EXCL_TOTALS_IND VARCHAR2 1 NO EXCLUDE TOTALS INDICATOR: Indicator to exclude this
record from Organization totals, Valid values (Y)es or
(N)o.
NBREPSA_HIDE_IND VARCHAR2 1 NO HIDE INDICATOR: Indicates if this Position should be
hidden from Salary Planner web pages for Scenarios
other than "INITIAL". Valid values are (Y)es or (N)o.
NBREPSA_EXTRACT_STATUS VARCHAR2 1 NO EXTRACT STATUS: The status of this position from the
extract, valid values are (I)nitial and (N)ew.
NBREPSA_RECORD_STATUS VARCHAR2 1 NO RECORD STATUS: Valid values are (N)o Changes,
(C)hanged, (U)ploaded. The record status indicates if
changes have been made to the record and if the record
needs to be uploaded or has already been upload
ed.
NBREPSA_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBREPSA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBREPSA_BARG_CODE VARCHAR2 2 YES BARGAINING UNIT CODE: The Bargaining Unit associated
with this position.
NBREPSA_BUDGET NUMBER 11 2 YES BASE BUDGET: The total fiscal year base or extracted
Budget amount.
NBREPSA_BUDGET_PROPOSED NUMBER 11 2 YES BUDGET PROPOSED: The total Proposed Budget for the
Position..
NBREPSA_CHANGE_PERCENT NUMBER 11 2 YES CHANGE PERCENT: The Percentage difference between the
Base and Proposed Position Budget.
Date: 21-JUN-2004 Page: 35
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBREPSA_CHANGE_AMOUNT NUMBER 11 2 YES CHANGE AMOUNT: The difference between the Base and
Proposed Position Budget.
NBREPSA_COMMENTS VARCHAR2 1300 YES COMMENTS: User comments entered in Salary Planner for
this Position.
Date: 21-JUN-2004 Page: 36
TABLE: NBRERRN
CREATOR: POSNCTL
Extracted Job Default Hours Salary Planner Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRERRN_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBRERRN_SCENARIO VARCHAR2 30 NO SCENARIO: Scenario code associated with this record.
NBRERRN_PIDM NUMBER 8 NO PIDM: The internal identification number of the
employee associated with this record.
NBRERRN_POSN VARCHAR2 6 NO POSITION: The Position to which this Earning Code is
attached.
NBRERRN_SUFF VARCHAR2 2 NO SUFFIX: The Job Suffix associated with this record.
NBRERRN_EFFECTIVE_DATE DATE 7 NO BASE EFFECTIVE DATE: The Effective Date associated
with the Earning Code that was extracted.
NBRERRN_EFF_DATE_PROPOSED DATE 7 NO EFFECTIVE DATE: The proposed effective date will be
used to create a new Earnings record during the
upload.
NBRERRN_EARN_CODE VARCHAR2 3 NO EARN CODE: The Earnings code associated with this
record.
NBRERRN_ORGN_CODE_POSN VARCHAR2 6 NO ORGANIZATION CODE:Identifies the organization code
that goes with this position.
NBRERRN_SHIFT VARCHAR2 1 NO SHIFT: The shift associated with this record/earn
code.
NBRERRN_RECORD_STATUS VARCHAR2 1 NO RECORD STATUS: Valid values are (N)o Changes,
(C)hanged, (U)ploaded. The record status indicates if
changes have been made to the record and if the record
needs to be uploaded or has already been upload
ed.
NBRERRN_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBRERRN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBRERRN_HRS NUMBER 6 2 YES BASE HOURS: The base or extracted default Hours
associated with the Earn Code.
NBRERRN_HRS_PROPOSED NUMBER 6 2 YES HOURS PROPOSED: The Proposed Default Hours.
NBRERRN_CANCEL_DATE DATE 7 YES CANCEL DATE: Date Cancelled.
NBRERRN_SPECIAL_RATE NUMBER 12 6 YES SPECIAL RATE: The Special Rate associated with this
Earn Code.
NBRERRN_TRANSACTION_NO NUMBER 15 YES TRANSACTION NUMBER: The Electronic Personnel Action
Form (EPAF) Transaction number assigned to the record
during the upload process.
Date: 21-JUN-2004 Page: 37
TABLE: NBRFCLD
CREATOR: POSNCTL
Fringe Charge Back Position Budget. Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRFCLD_POSN VARCHAR2 6 NO Position.
NBRFCLD_FISC_CODE VARCHAR2 4 NO Fiscal Code which corrosponds with NBRPTOT Fiscal Code
NBRFCLD_OBUD_CODE VARCHAR2 6 YES Budget ID.
NBRFCLD_OBPH_CODE VARCHAR2 6 YES Budget Phase.
NBRFCLD_EFFECTIVE_DATE DATE 7 NO Date that this record becomes effective. (Tied to
NTRFBLD Rules).
NBRFCLD_CHANGE_IND VARCHAR2 1 YES CHANGE INDICATOR: Specifies if the record is active or
to be deleted.
NBRFCLD_COAS_CODE VARCHAR2 1 YES Chart of Accounts code. Valued only if Banner Finance
is installed.
NBRFCLD_FUND_CODE VARCHAR2 6 YES Fund. Valued only if Banner Finance is installed.
NBRFCLD_ORGN_CODE VARCHAR2 6 YES Organization. Valued only if Banner Finance is
installed.
NBRFCLD_ACCT_CODE VARCHAR2 6 YES Account. Valued only if Banner Finance is installed.
NBRFCLD_PROG_CODE VARCHAR2 6 YES Program. Valued only if Banner Finance is installed.
NBRFCLD_ACTV_CODE VARCHAR2 6 YES Activity. Valued only if Banner Finance is installed.
NBRFCLD_LOCN_CODE VARCHAR2 6 YES Location. Valued only if Banner Finance is installed.
NBRFCLD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NBRFCLD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
NBRFCLD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES Free form account code to allow update of an
accounting system other than Banner Finance.
NBRFCLD_BUDGET_FRNG NUMBER 11 2 YES The Fringe Charge Back budgeted dollars for this
entry.
NBRFCLD_BUDGET_FRNG_TO_POST NUMBER 11 2 YES The Fringe Charge Back budgeted dollars which have yet
to be posted to Finance.
NBRFCLD_ACTIVITY_DATE DATE 7 NO Date of last activity on this record.
Date: 21-JUN-2004 Page: 38
TABLE: NBRFTOT
CREATOR: POSNCTL
Fringe Benefits Budget Totals Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRFTOT_POSN VARCHAR2 6 NO POSITION: Position Number.
NBRFTOT_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: BANNER HR system defined code for
the fiscal year.
NBRFTOT_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date on which this record becomes
effective.
NBRFTOT_STATUS VARCHAR2 1 YES STATUS: Status of Fringe Benefits Budget Total Record.
Values (C)ancelled, (A)ctive, (F)rozen.
NBRFTOT_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS: The primary identification code for
any chart of accounts which is used to uniquely
identify that chart from any other in a multi-chart
environment.
NBRFTOT_ORGN_CODE VARCHAR2 6 NO FRINGE BENEFITS ORGANIZATION CODE: Organization that
controls the budget for the fringe benefits for this
position.
NBRFTOT_BUDGET NUMBER 11 2 YES FRINGE BENEFITS BUDGET: Amount Budgeted for the Fringe
Benefits for this position.
NBRFTOT_BUDGET_TO_POST NUMBER 11 2 YES FRINGE BENEFITS BUDGET TO POST: Amount of the Fringe
Benefits budget that has tobe posted to Finance.
NBRFTOT_EXPEND NUMBER 11 2 YES FRINGE BENEFITS EXPENDED AMOUNT: Amount of money
expended towards the Fringe Benefits Budget for this
position.
NBRFTOT_OBUD_CODE VARCHAR2 6 YES FRINGE BENEFITS BUDGET ID CODE: System defined code
for Budget Id of the fringe benefits. Validated
against BANNER FINANCE if it is installed.
NBRFTOT_OBPH_CODE VARCHAR2 6 YES FRINGE BENEFITS BUDGET PHASE CODE: A system defined
code for the Budget Phase for the fringe benefits.
Validated against BANNER FINANCE if it is installed.
NBRFTOT_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CODE: A code that identifies the
Benefit/Deduction category.
NBRFTOT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 39
TABLE: NBRJFTE
CREATOR: POSNCTL
Job FTE Calculations and Tracking Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRJFTE_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
NBRJFTE_POSN VARCHAR2 6 NO POSITION: Position Number of the Assignment.
NBRJFTE_SUFF VARCHAR2 2 NO SUFFIX: Suffix of the Assignment.
NBRJFTE_EFFECTIVE_DATE DATE 7 NO JOB EFFECTIVE DATE: The Date that the Jobs record
becomes effective.
NBRJFTE_FTE_EFFECTIVE_DATE DATE 7 NO FTE EFFECTIVE DATE: The Date that the FTE Calculations
record becomes effective.
NBRJFTE_BUDG_BASIS NUMBER 6 2 NO POSITION BUDGET BASIS: The period of the Position
Annual Basis to be worked.
NBRJFTE_ANN_BASIS NUMBER 6 2 NO POSITION ANNUAL BASIS: The period of time a position
is based upon or budgeted for.
NBRJFTE_APPT_PCT NUMBER 5 2 NO APPOINTMENT PERCENT: The effort for the position.
NBRJFTE_BASE_UNITS NUMBER 3 1 NO BASE UNITS: The number of pay periods for the
position.
NBRJFTE_ANN_FTE NUMBER 7 4 NO ANNUALIZED FTE: A calculation of FTE using the
Position Budget Basis, Position Annual Basis, and Job
Appointment Percent.
NBRJFTE_BASE_SALARY NUMBER 11 2 NO FTE BASE SALARY: The full time equivalency salary for
a Position Annual Basis.
NBRJFTE_COMMENT VARCHAR2 2000 YES COMMENT: Comment about the Job FTE calculations
record.
NBRJFTE_USER_ID VARCHAR2 30 NO USER ID: User who add or modify Job FTE calculation
information.
NBRJFTE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 40
TABLE: NBRJLBD
CREATOR: POSNCTL
Assignment Labor Dist. Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRJLBD_PIDM NUMBER 8 NO Internal ID number.
NBRJLBD_POSN VARCHAR2 6 NO Position.
NBRJLBD_SUFF VARCHAR2 2 NO Suffix.
NBRJLBD_EFFECTIVE_DATE DATE 7 NO Date that this record becomes effective.
NBRJLBD_COAS_CODE VARCHAR2 1 YES Chart of Accounts code. Valued only if Banner Finance
is installed.
NBRJLBD_ACCI_CODE VARCHAR2 6 YES Account Index. Valued only if Banner Finance is
installed.
NBRJLBD_FUND_CODE VARCHAR2 6 YES Fund. Valued only if Banner Finance is installed.
NBRJLBD_ORGN_CODE VARCHAR2 6 YES Organization. Valued only if Banner Finance is
installed.
NBRJLBD_ACCT_CODE VARCHAR2 6 YES Account. Valued only if Banner Finance is installed.
NBRJLBD_PROG_CODE VARCHAR2 6 YES Program. Valued only if Banner Finance is installed.
NBRJLBD_ACTV_CODE VARCHAR2 6 YES Activity. Valued only if Banner Finance is installed.
NBRJLBD_LOCN_CODE VARCHAR2 6 YES Location. Valued only if Banner Finance is installed.
NBRJLBD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NBRJLBD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
NBRJLBD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES Free form account code to allow update of an
accounting system other than Banner Finance.
NBRJLBD_PERCENT NUMBER 5 2 NO Percent of pay to be applied to this labor
distribution.
NBRJLBD_ENCD_NUM VARCHAR2 8 YES ENCUMBRANCE NUMBER: The Encumbrance number used for
interface with Banner Finance
NBRJLBD_ENCD_SEQ_NUM NUMBER 4 YES ENCUMBRANCE SEQUENCE NUMBER: The Encumbrance sequence
number used for interface with Banner Finance
NBRJLBD_SALARY_ENCUMBRANCE NUMBER 11 2 YES SALARY ENCUMBRANCE: Amount encumbered to this labor
distribution for the active fiscal year.
NBRJLBD_SALARY_ENC_TO_POST NUMBER 11 2 NO SALARY ENCUMBRANCE TO POST: Amount of encumbrance that
will be posted to the finance system.
NBRJLBD_FRINGE_ENCUMBRANCE NUMBER 11 2 YES FRINGE ENCUMBRANCE: Amount of fringe benefits
encumbered to this labor distribution for the active
fiscal year.
NBRJLBD_FRINGE_ENC_TO_POST NUMBER 11 2 NO FRINGE ENCUMBRANCE TO POST: Amount of encumbrance that
will be posted to the finance system.
NBRJLBD_FUND_CODE_FRINGE VARCHAR2 6 YES Fringe Fund. Valued only if Banner Finance is
installed.
NBRJLBD_ORGN_CODE_FRINGE VARCHAR2 6 YES Fringe Organization. Valued only if Banner Finance is
installed.
NBRJLBD_ACCT_CODE_FRINGE VARCHAR2 6 YES Fringe Account. Valued only if Banner Finance is
installed.
NBRJLBD_PROG_CODE_FRINGE VARCHAR2 6 YES Fringe Program. Valued only if Banner Finance is
installed.
Date: 21-JUN-2004 Page: 41
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRJLBD_ACTV_CODE_FRINGE VARCHAR2 6 YES Fringe Activity. Valued only if Banner Finance is
installed.
NBRJLBD_LOCN_CODE_FRINGE VARCHAR2 6 YES Fringe Location. Valued only if Banner Finance is
installed.
NBRJLBD_CHANGE_IND VARCHAR2 1 NO CHANGE INDICATOR: Specifies if the record is active or
to be deleted.
NBRJLBD_ACTIVITY_DATE DATE 7 NO Date of last activity on this record.
NBRJLBD_FRINGE_RESIDUAL NUMBER 11 2 YES FRINGE ENCUMBRANCE RESIDUAL AMOUNT: Fringe encumbrance
residual amount assigned to this externally funded
labor distribution.
NBRJLBD_FRINGE_RES_TO_POST NUMBER 11 2 YES FRINGE ENCUMBRANCE RESIDUAL TO POST : Amount of fringe
encumbrance residual to post to this externally funded
labor distribution.
Date: 21-JUN-2004 Page: 42
TABLE: NBRJLHS
CREATOR: POSNCTL
Assignment Labor Distribution History Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRJLHS_PIDM NUMBER 8 NO Internal ID number.
NBRJLHS_POSN VARCHAR2 6 NO Position.
NBRJLHS_SUFF VARCHAR2 2 NO Suffix.
NBRJLHS_EFFECTIVE_DATE DATE 7 NO Date that this record becomes effective.
NBRJLHS_CAPTURE_DATE DATE 7 NO CAPTURE DATE: The date of the Encumbrance transaction.
NBRJLHS_COAS_CODE VARCHAR2 1 YES Chart of Accounts code. Valued only if Banner Finance
is installed.
NBRJLHS_ACCI_CODE VARCHAR2 6 YES Account Index. Valued only if Banner Finance is
installed.
NBRJLHS_FUND_CODE VARCHAR2 6 YES Fund. Valued only if Banner Finance is installed.
NBRJLHS_ORGN_CODE VARCHAR2 6 YES Organization. Valued only if Banner Finance is
installed.
NBRJLHS_ACCT_CODE VARCHAR2 6 YES Account. Valued only if Banner Finance is installed.
NBRJLHS_PROG_CODE VARCHAR2 6 YES Program. Valued only if Banner Finance is installed.
NBRJLHS_ACTV_CODE VARCHAR2 6 YES Activity. Valued only if Banner Finance is installed.
NBRJLHS_LOCN_CODE VARCHAR2 6 YES Location. Valued only if Banner Finance is installed.
NBRJLHS_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NBRJLHS_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
NBRJLHS_ACCT_CODE_EXTERNAL VARCHAR2 60 YES Free form account code to allow update of an
accounting system other than Banner Finance.
NBRJLHS_PERCENT NUMBER 5 2 YES Percent of pay to be applied to this labor
distribution.
NBRJLHS_ENCD_NUM VARCHAR2 8 YES ENCUMBRANCE_NO: The Encumbrance number used for
interface with Banner Finance
NBRJLHS_ENCD_SEQ_NUM NUMBER 4 YES ENCUMBRANCE_SEQ_NO: The Sequence Number associated
with the Encumbrance number used for interface with
Banner Finance
NBRJLHS_SALARY_ENCUMBRANCE NUMBER 11 2 YES SALARY ENCUMBRANCE AMOUNT: Salary Encumbrance Amount
encumbered to this labor distribution.
NBRJLHS_SALARY_ENC_TO_POST NUMBER 11 2 YES SALARY ENCUMBRANCE TO POST : Amount of salary
encumbrance to post to this labor distribution
NBRJLHS_FRINGE_ENCUMBRANCE NUMBER 11 2 YES FRINGE ENCUMBRANCE AMOUNT: Fringe Encumbrance Amount
encumbered to this labor distribution.
NBRJLHS_FRINGE_ENC_TO_POST NUMBER 11 2 YES FRINGE ENCUMBRANCE TO POST : Amount of fringe
encumbrance to post to this labor distribution
NBRJLHS_FUND_CODE_FRINGE VARCHAR2 6 YES Fringe Fund. Valued only if Banner Finance is
installed.
NBRJLHS_ORGN_CODE_FRINGE VARCHAR2 6 YES Fringe Fund. Valued only if Banner Finance is
installed.
NBRJLHS_ACCT_CODE_FRINGE VARCHAR2 6 YES Fringe Fund. Valued only if Banner Finance is
installed.
NBRJLHS_PROG_CODE_FRINGE VARCHAR2 6 YES FRINGE PROGRAM: Fringe Program. Valued only if Banner
Finance is installed.
Date: 21-JUN-2004 Page: 43
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRJLHS_ACTV_CODE_FRINGE VARCHAR2 6 YES FRINGE ACTIVITY: Fringe Activity. Valued only is
Banner Finance is installed.
NBRJLHS_LOCN_CODE_FRINGE VARCHAR2 6 YES FRINGE LOCATION: Fringe Location. Valued only if
Banner Finance is installed.
NBRJLHS_ACTIVITY_DATE DATE 7 NO Date of last activity on this record.
NBRJLHS_FRINGE_RESIDUAL NUMBER 11 2 YES FRINGE ENCUMBRANCE RESIDUAL AMOUNT: Fringe encumbrance
residual amount assigned to this externally funded
labor distribution.
NBRJLHS_FRINGE_RES_TO_POST NUMBER 11 2 YES FRINGE ENCUMBRANCE RESIDUAL TO POST : Amount of fringe
encumbrance residual to post to this externally funded
labor distribution
Date: 21-JUN-2004 Page: 44
TABLE: NBRJOBS
CREATOR: POSNCTL
Assignment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRJOBS_PIDM NUMBER 8 NO Internal ID Number
NBRJOBS_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
NBRJOBS_SUFF VARCHAR2 2 NO SUFFIX: The Suffix attached to the job.
NBRJOBS_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date that the Jobs record becomes
effective.
NBRJOBS_STATUS VARCHAR2 1 NO JOB STATUS: The status of the job. Valid values are:
A-active, B-leave without pay with benefits, L-leave
without pay without benefits, F-leave with full pay
and benefits, P-leave with partial pay and benefits,
T-terminated.
NBRJOBS_DESC VARCHAR2 30 YES JOB DESCRIPTION: Description of the job. Defaults
from the Position Title if left blank.
NBRJOBS_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: The employee grouping that this
Job belongs to, based on the Employee Class entered on
the Position Form (NBAPOSN).
NBRJOBS_PICT_CODE VARCHAR2 2 NO PAY ID CODE: The pay id to which this job belongs.
NBRJOBS_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET CHART OF ACCOUNTS CODE: Used only if Banner
Finance is installed.
NBRJOBS_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION: The organization to which the
time sheet for this job will be sent.
NBRJOBS_SAL_TABLE VARCHAR2 2 YES SALARY TABLE: Defaults from the Salary/Rate Rule Form
(NTRSALA) via the Position Form (NBAPOSN).
NBRJOBS_SAL_GRADE VARCHAR2 5 YES SALARY GRADE: Defaults from the Salary/Rate Rule Form
(NTRSALA) via the Position Form (NBAPOSN).
NBRJOBS_SAL_STEP NUMBER 3 YES SALARY STEP: Defaults from the Salary/Rate Rule Form
(NTRSALA) or can be entered online.
NBRJOBS_APPT_PCT NUMBER 5 2 NO APPOINTMENT PERCENTAGE:
NBRJOBS_FTE NUMBER 6 3 YES FULL TIME EQUIVALENCY: The full time equivalency
percentage assigned to this Job.
NBRJOBS_HRS_DAY NUMBER 6 2 NO HOURS PER DAY: The number of hours an employee filling
this job normally works in a day.
NBRJOBS_HRS_PAY NUMBER 6 2 NO HOURS PER PAY: The number of hours an employee filling
this job normally works in a pay period.
NBRJOBS_SHIFT VARCHAR2 1 NO SHIFT: The normal shift assigned to this job.
NBRJOBS_REG_RATE NUMBER 11 6 YES REGULAR RATE: The regular hourly rate for this job.
If this field is entered or defaulted from the
Salary/Rate Rule Form the Assign Salary is system
calculated and vice versa.
NBRJOBS_ASSGN_SALARY NUMBER 11 2 NO ASSIGNMENT SALARY: The salary to be paid each pay
period. If the Assignment Salary is entered, the
Annual Salary is calculated based on the factor and
vice versa.
NBRJOBS_FACTOR NUMBER 3 1 NO PAY FACTOR: The number of pays per calendar year.
NBRJOBS_ANN_SALARY NUMBER 11 2 NO ANNUAL SALARY: The annual salary for the job based on
the calendar year. If the Annual Salary is entered,
the Assignment Salary is system calculated based the
factor and vice versa.
Date: 21-JUN-2004 Page: 45
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRJOBS_PER_PAY_SALARY NUMBER 11 2 NO PER PAY SALARY: Used for deferred pay calculations.
NBRJOBS_PAYS NUMBER 3 1 NO NUMBER OF PAYS PER YEAR: Used for deferred pay
calculations.
NBRJOBS_PER_PAY_DEFER_AMT NUMBER 11 2 NO PER PAY DEFERRED AMOUNT: The amount deferred each pay
period for deferred pay calculation.
NBRJOBS_ACTIVITY_DATE DATE 7 NO Date of last activity on this record.
NBRJOBS_JCRE_CODE VARCHAR2 5 YES JOB CHANGE REASON CODE: This code should be existed in
the PTVJCRE form.
NBRJOBS_SGRP_CODE VARCHAR2 6 NO SGRP_CODE: The Salary Group Code.
NBRJOBS_EMPR_CODE VARCHAR2 4 YES EMPR_CODE: The Employer Identification code.
NBRJOBS_LGCD_CODE VARCHAR2 4 YES LGCD_CODE: Longevity code.
NBRJOBS_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Location to which this position
belongs.
NBRJOBS_SCHL_CODE VARCHAR2 6 YES SCHOOL CODE: School to which this position belongs.
NBRJOBS_SUPERVISOR_PIDM NUMBER 8 YES SUPERVISOR PIDM: Identification number of the
supervisor for this job.
NBRJOBS_SUPERVISOR_POSN VARCHAR2 6 YES SUPERVISOR POSN: The position number of the
supervisor.
NBRJOBS_SUPERVISOR_SUFF VARCHAR2 2 YES SUPERVISOR SUFFIX: Suffix associated with the
supervisor's position.
NBRJOBS_WKCP_CODE VARCHAR2 4 YES WKCP CODE: Workers' Compensation Classification Code
associated with
this job.
NBRJOBS_JBLN_CODE VARCHAR2 6 YES JBLN CODE: Job Location Code associated with this job.
NBRJOBS_PERS_CHG_DATE DATE 7 NO PERSONNEL CHANGE DATE: Date the change became
effective, regardless of
payroll.
NBRJOBS_PCAT_CODE VARCHAR2 4 YES PREMIUM PAY CODE: Controls premium pay generation.
NBRJOBS_DFPR_CODE VARCHAR2 4 YES DEFER PAY CODE: Identifies rules governing deferred
pay.
NBRJOBS_ENCUMBRANCE_HRS NUMBER 6 2 YES ENCUMBRANCE HOURS: The number of hours used for
calculating the encumbrance amount for this job in the
active fiscal year.
NBRJOBS_CONTRACT_NO VARCHAR2 8 YES Job contract number.
NBRJOBS_STRS_ASSN_CODE VARCHAR2 2 YES STRS ASSIGNMENT CODE:
STRS Assignment Code.
NBRJOBS_STRS_PAY_CODE VARCHAR2 2 YES STRS PAY CODE:
STRS Pay Code for the employee.
NBRJOBS_PERS_PAY_CODE VARCHAR2 2 YES PERS PAY CODE:
PERS Pay Code for the employee.
NBRJOBS_TIME_ENTRY_METHOD VARCHAR2 1 NO Time Entry Method: P = Payroll, W = Web, D =
Departmental, T = Third Party .
NBRJOBS_TIME_ENTRY_TYPE VARCHAR2 1 NO Time Entry Type: T = Time Sheet, E = Exception Time
Only, N = None.
NBRJOBS_TIME_IN_OUT_IND VARCHAR2 1 NO Time In and Out Indicator : Indicates that employee
must report time in and time out.
NBRJOBS_LCAT_CODE VARCHAR2 2 YES Leave Category Code: A code which identifies a group
of leave types.
NBRJOBS_LEAV_REPT_METHOD VARCHAR2 1 NO Leave Report Entry Method:(P) None; (W) Leave Report
on the Web; (D) Departmental Leave Report; (T) Third
Party Leave Report.
NBRJOBS_PICT_CODE_LEAV_REPT VARCHAR2 2 NO Leave Report Payd ID: The pay ID associated with a
leave report or leave request
Date: 21-JUN-2004 Page: 46
TABLE: NBRLOCK
CREATOR: POSNCTL
Salary Planner Organization Lock Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRLOCK_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBRLOCK_SCENARIO VARCHAR2 30 NO SCENARIO: The Scenario code associated with this
record.
NBRLOCK_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Organization code as defined in
Banner Finance when Finance is installed or Banner HR
when Finance is not installed.
NBRLOCK_LOCK_IND VARCHAR2 1 NO LOCK INDICATOR: This indicates whether an Organization
is locked or unlocked. Values (L)ocked or (U)nlocked.
NBRLOCK_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
NBRLOCK_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 47
TABLE: NBRPLBD
CREATOR: POSNCTL
Position L/D Account Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRPLBD_POSN VARCHAR2 6 NO POSITION: Position Number
NBRPLBD_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: The BANNER HR system defined fiscal
year.
NBRPLBD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The BANNER FINANCE system
defined Chart of Accounts Code under which this
position is to be charged.
NBRPLBD_ACCI_CODE VARCHAR2 6 YES POSITION ACCOUNT INDEX CODE: An index code that is
used to default the account distribution to which this
position should be charged.
NBRPLBD_FUND_CODE VARCHAR2 6 YES POSITION FUND CODE: BANNER FINANCE system defined code
that identifies the fund to which this position should
be charged.
NBRPLBD_ORGN_CODE VARCHAR2 6 YES POSITION ORGANIZATION CODE: BANNER FINANCE system
defined code that identifies the Organization to which
this position should be charged.
NBRPLBD_ACCT_CODE VARCHAR2 6 YES POSITION ACCOUNT CODE : BANNER FINANCE system defined
code which identifies the position account to be
charged.
NBRPLBD_PROG_CODE VARCHAR2 6 YES POSITION PROGRAM CODE: BANNER FINANCE system defined
code that identifies the Program to which this
position should be charged.
NBRPLBD_ACTV_CODE VARCHAR2 6 YES POSITION ACTIVITY CODE: BANNER FINANCE system defined
code that identifies the activity to which the
position should be charged.
NBRPLBD_LOCN_CODE VARCHAR2 6 YES POSITION LOCATION CODE: BANNER FINANCE system defined
code that identifies the Program to which this
position should be charged.
NBRPLBD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES POSITION EXTERNAL ACCOUNT CODE: A NON-BANNER FINANCE
System Account Distribution Code to which this
position should be charged.
NBRPLBD_PERCENT NUMBER 5 2 NO POSITION LABOR DISTRIBUTION PERCENT: Percent of
Position's Budget to be applied to this labor
distribution.
NBRPLBD_ACTIVITY_DATE DATE 7 NO ACTIVITY_DATE: Date the record was inserted or last
modified.
NBRPLBD_OBUD_CODE VARCHAR2 6 YES BUDGET ID CODE: System Defined Code for the Position's
Budget Id.
NBRPLBD_OBPH_CODE VARCHAR2 6 YES BUDGET PHASE CODE: System Defined Code for the Budget
Phase of the Position.
NBRPLBD_CHANGE_IND VARCHAR2 1 YES CHANGE INDICATOR: Internally used. Indicates for
reversing remaining dollars out of old labor
distribution.
NBRPLBD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NBRPLBD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
Date: 21-JUN-2004 Page: 48
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRPLBD_BUDGET NUMBER 11 2 YES BUDGET: The amount of Position Total Budget charged to
this accounting distribution.
NBRPLBD_BUDGET_TO_POST NUMBER 11 2 YES BUDGET TO POST: The amount of Position Total Budget
charged to this accounting distribution that needs to
be posted to finance.
Date: 21-JUN-2004 Page: 49
TABLE: NBRPOSH
CREATOR: POSNCTL
Position History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRPOSH_POSN VARCHAR2 6 NO Position.
NBRPOSH_CHANGE_DATE_TIME DATE 7 NO CHANGE DATE TIME: Date and Time this record was
changed.
NBRPOSH_TITLE VARCHAR2 30 NO Title.
NBRPOSH_PCLS_CODE VARCHAR2 5 NO POSITION CLASS CODE: The position class the defined
position is assigned to.
NBRPOSH_ECLS_CODE VARCHAR2 2 NO POSITION EMPLOYEE CLASS CODE: Employee class code
defaults from the Position Class Rule Form but can be
overriden.
NBRPOSH_POSN_REPORTS VARCHAR2 6 YES Position that this position reports to. A superior.
NBRPOSH_TABLE VARCHAR2 2 NO Salary table.
NBRPOSH_GRADE VARCHAR2 5 NO SALARY GRADE: Position salary grade defaults from the
Position Class Rule Form but can be overriden.
NBRPOSH_STEP NUMBER 3 YES Salary step.
NBRPOSH_APPT_PCT NUMBER 5 2 NO 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.
NBRPOSH_PGRP_CODE VARCHAR2 4 YES PGRP_CODE: The Position Group code.
NBRPOSH_USERID VARCHAR2 30 YES USERID: The userid of person who changed this record.
NBRPOSH_ACTIVITY_DATE DATE 7 NO Date of last activity on this record.
NBRPOSH_EXEMPT_IND VARCHAR2 1 NO EXEMPTION INDICATOR: Indicates if employees assigned
to positions in this Position Class will be exempt or
non-exempt.
NBRPOSH_JBLN_CODE VARCHAR2 6 YES JOB LOCATION CODE: Code associated with this Position.
NBRPOSH_BARG_CODE VARCHAR2 2 YES BARGAINING UNIT CODE: Code associated with this
Position.
NBRPOSH_PROBATION_UNITS NUMBER 3 YES PROBATION UNITS: Identifies the number of Probationary
Units.
NBRPOSH_ACCRUE_SENIORITY_IND VARCHAR2 1 NO ACCRUE SENIORITY INDICATOR:This indicator will denote
whether seniority hours are accrued against the
position.
NBRPOSH_JOBP_CODE VARCHAR2 5 YES JOB PROGRESSION CODE: Job Progression code associated
with the position.
Date: 21-JUN-2004 Page: 50
TABLE: NBRPTOT
CREATOR: POSNCTL
Position Budget Totals Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRPTOT_POSN VARCHAR2 6 NO POSITION: The position number.
NBRPTOT_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: The BANNER HR system defined fiscal
year.
NBRPTOT_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the record becomes effective.
NBRPTOT_STATUS VARCHAR2 1 YES PTOT STATUS: Position total status.
NBRPTOT_FTE NUMBER 7 4 NO FULL TIME EQUIVALENCY: The full time equivalency
budgeted for this position.
NBRPTOT_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE : Valid only if Banner Finance
is present.
NBRPTOT_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Organization code as defined in the
Banner Finance system.
NBRPTOT_BUDGET NUMBER 11 2 YES POSITION BUDGET: The amount of money budgeted for this
position for a fiscal year.
NBRPTOT_ENCUMB NUMBER 11 2 YES ENCUMBRANCE AMOUNT: Total encumbrance amount.
NBRPTOT_EXPEND NUMBER 11 2 YES EXPENDITURE AMOUNT: Total amount of money expended.
NBRPTOT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
NBRPTOT_OBUD_CODE VARCHAR2 6 YES BUDGET ID CODE: System Defined Code for the Position
Budget Id.
NBRPTOT_OBPH_CODE VARCHAR2 6 YES BUDGET PHASE CODE: System Defined Code for the Budget
Phase.
NBRPTOT_SGRP_CODE VARCHAR2 6 YES SALARY GROUP CODE: Salary group code associated with
this record.
NBRPTOT_BUDGET_FRNG NUMBER 11 2 YES POSITION BUDGET FRINGE: The amount of money budgeted
for the fringe benefits of this position.
NBRPTOT_ENCUMB_FRNG NUMBER 11 2 YES FRINGE ENCUMBRANCE: The amount of money encumbered
towards the fringe benefits of this position.
NBRPTOT_EXPEND_FRNG NUMBER 11 2 YES FRINGE EXPENDITURE: The amount of money expended
towards the fringe benefits of this position.
NBRPTOT_ACCI_CODE_FRNG VARCHAR2 6 YES ACCOUNT INDEX CODE: Index defined in the BANNER
Finance system.
NBRPTOT_FUND_CODE_FRNG VARCHAR2 6 YES FRINGE FUND CODE: Fringe fund code as defined in the
Banner Finance system.
NBRPTOT_ORGN_CODE_FRNG VARCHAR2 6 YES FRINGE ORGANIZATION CODE: Fringe organization code as
defined in the Banner Finance system.
NBRPTOT_ACCT_CODE_FRNG VARCHAR2 6 YES FRINGE ACCOUNT CODE: Fringe account code as defined in
the Banner Finance system.
NBRPTOT_PROG_CODE_FRNG VARCHAR2 6 YES FRINGE PROGRAM CODE: Fringe program code as defined in
the Banner Finance system.
NBRPTOT_ACTV_CODE_FRNG VARCHAR2 6 YES FRINGE ACTIVITY CODE: Fringe activity code as defined
in the Banner Finance system.
NBRPTOT_LOCN_CODE_FRNG VARCHAR2 6 YES FRINGE LOCATION CODE: Fringe location code as defined
in the Banner Finance system.
NBRPTOT_RECURRING_BUDGET NUMBER 11 2 YES Recurring Budget Amount; This field will allow the
user to enter a Recurring Budget Amount which will
remain constant throughout the fiscal year even though
the Budget Amount may change due to budget
transfers
and/or budget adjustments.
Date: 21-JUN-2004 Page: 51
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRPTOT_BUDG_BASIS NUMBER 6 2 NO POSITION BUDGET BASIS: The period of the Position
Annual Basis to be worked.
NBRPTOT_ANN_BASIS NUMBER 6 2 NO POSITION ANNUAL BASIS: The period of time a position
is based upon or budgeted for.
NBRPTOT_BASE_UNITS NUMBER 3 1 NO BASE UNITS: The number of pay periods for the
position.
NBRPTOT_APPT_PCT NUMBER 5 2 NO APPOINTMENT PERCENT: The effort for the position.
NBRPTOT_CREATE_JFTE_IND VARCHAR2 1 NO CREATE NBRJFTE INDICATOR: This flag indicates when to
create NBRJFTE records. Valid values are: (Y) -
create record or (N) - do not create record.
NBRPTOT_COMMENT VARCHAR2 2000 YES COMMENT: This field stores user comments.
Date: 21-JUN-2004 Page: 52
TABLE: NBRRJQE
CREATOR: POSNCTL
Override Approvals Queue Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRRJQE_PIDM NUMBER 8 NO APPROVER PIDM: Internal ID number of
approver
NBRRJQE_USER_ID VARCHAR2 30 NO USERID: The user id of person
who inserted or updated
the record
NBRRJQE_ACAT_CODE VARCHAR2 6 NO APPROVAL CATEGORY CODE: This
code represent the
purpose of personnel action
NBRRJQE_APPR_SEQ_NO NUMBER 3 NO APPROVER SEQUENCE: Unique
Sequence number identifing
the approver
NBRRJQE_APPR_PIDM NUMBER 8 YES
NBRRJQE_APPR_POSN VARCHAR2 6 NO APPROVER POSITION: The position
number of the approver
NBRRJQE_APPR_ACTION_IND VARCHAR2 1 NO APPROVER ACTION INDICATOR:Indicator to apply approver
action to the database
NBRRJQE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the
record was inserted or
updated.
NBRRJQE_POSN VARCHAR2 6 NO POSITION: The position number this
job is attached to
NBRRJQE_SUFF VARCHAR2 2 NO SUFFIX: Job suffix
Date: 21-JUN-2004 Page: 53
TABLE: NBRRTOT
CREATOR: POSNCTL
Premium Earnings Budget Totals Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRRTOT_POSN VARCHAR2 6 NO POSITION: Position Number.
NBRRTOT_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: BANNER HR system defined code for
the fiscal year.
NBRRTOT_STATUS VARCHAR2 1 NO STATUS: Status of Premium Earnings Budget Total
Record. Values (C)ancelled, (A)ctive, (F)rozen.
NBRRTOT_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The BANNER FINANCE Chart of
Accounts Code under which the position is created.
NBRRTOT_ORGN_CODE VARCHAR2 6 NO PREMIUM EARNINGS ORGANIZATION CODE: Organization that
controls the budget for the Premium Earning for this
position.
NBRRTOT_OBUD_CODE VARCHAR2 6 YES PREMIUM EARNINGS BUDGET ID CODE: System defined code
for Budget Id of the Premium Earning. Validated
against BANNER FINANCE if it is installed.
NBRRTOT_OBPH_CODE VARCHAR2 6 YES PREMIUM EARNINGS BUDGET PHASE CODE: A system defined
code for the Budget Phase for the Premium Earnings.
Validated against BANNER FINANCE if it is installed.
NBRRTOT_EARN_CODE VARCHAR2 3 NO EARNINGS CODE: A code which identifies the Premium
Earning.
NBRRTOT_BUDGET NUMBER 11 2 YES PREMIUM EARNINGS BUDGET: Amount Budgeted for the
Premium Earnings for this position.
NBRRTOT_BUDGET_TO_POST NUMBER 11 2 YES PREMIUM EARNINGS BUDGET TO POST: Amount of the Premium
Earning budget that has to be posted to Finance.
NBRRTOT_EXPEND NUMBER 11 2 YES PREMIUM EARNINGS EXPENDED AMOUNT: Amount of money
expended towards the Premium Earning Budget for this
position.
NBRRTOT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 54
TABLE: NBRSALC
CREATOR: POSNCTL
Salary Planner Salary Change Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRSALC_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBRSALC_SCENARIO VARCHAR2 30 NO SCENARIO: The Scenario code associated with this
record.
NBRSALC_PIDM NUMBER 8 NO PIDM: The internal identification number of the
employee associated with this record.
NBRSALC_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
NBRSALC_SUFF VARCHAR2 2 NO SUFFIX: The Suffix attached to the job.
NBRSALC_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Effective Date of the Salary Change.
NBRSALC_JCRE_CODE VARCHAR2 5 NO JCRE CODE: Job Change Reason Code associated with the
Change Amount and Percent.
NBRSALC_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBRSALC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBRSALC_CHANGE_PERCENT NUMBER 11 2 YES CHANGE PERCENT: Change Percent to be applied to the
Salary or Hourly wage.
NBRSALC_CHANGE_AMOUNT NUMBER 15 6 YES CHANGE AMOUNT: The Change Amount to be applied to the
Salary or Hourly wage.
Date: 21-JUN-2004 Page: 55
TABLE: NBRSPLC
CREATOR: POSNCTL
Salary Planner Organization Lock Collector Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRSPLC_PIDM NUMBER 8 NO PIDM:Internal System Identification Number.
NBRSPLC_SPEX_CODE VARCHAR2 12 NO SPEX_CODE: Salary Planner Extract ID.
NBRSPLC_SCENARIO VARCHAR2 30 NO SCENARIO: Scenario code associated with this extract
ID.
NBRSPLC_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Identifies the organization code
which has to be Locked or Unlocked.
NBRSPLC_ORGN_LOCK_STATUS VARCHAR2 1 NO This is the lock status of the organization, valid
values are (L)ocked or (U)nlocked.
NBRSPLC_ORGN_LOCK_TYPE VARCHAR2 1 NO This is the lock type of the organization, valid
values are (P)hysical Lock or (I)nferred Lock.
NBRSPLC_ORGN_HIER_STATUS VARCHAR2 1 NO This is the hierarchy status of the organization, it
is an indicator of whether the organization has
successor organizations, valid values are (Y)es or
(N)o
NBRSPLC_ORGN_CHNG_STATUS VARCHAR2 1 NO This indicator is used to indicate whether the status
of the organization was changed.
NBRSPLC_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBRSPLC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NBRSPLC_ORGN_CODE_PRED VARCHAR2 6 YES ORGN_CODE_PRED: It is the predeccesor organization of
the organization code.
NBRSPLC_ORGN_TITLE VARCHAR2 35 YES ORGN_TITLE: It is the title of the organization.
Date: 21-JUN-2004 Page: 56
TABLE: NBRWKSH
CREATOR: POSNCTL
Work Schedule Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRWKSH_PIDM NUMBER 8 NO PIDM: Person Identification Number associated with the
work schedule.
NBRWKSH_POSN VARCHAR2 6 NO POSITION: Position number associated with the work
schedule.
NBRWKSH_SUFF VARCHAR2 2 NO SUFFIX: Suffix associated with the work schedule.
NBRWKSH_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the work schedule goes into
effect for the assignment.
NBRWKSH_DAY NUMBER 3 NO DAY: Day number of the schedule.
NBRWKSH_SHIFT VARCHAR2 1 YES SHIFT: Shift associated with this day/schedule.
NBRWKSH_HOURS NUMBER 4 2 NO HOURS: Hours scheduled to work on the day.
NBRWKSH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 57
TABLE: NBRXDED
CREATOR: POSNCTL
Excluded Deductions by Job Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBRXDED_PIDM NUMBER 8 NO PIDM: The Internal Identification Number.
NBRXDED_POSN VARCHAR2 6 NO POSN: The position on which to exclude the
Benefit/Deduction.
NBRXDED_SUFF VARCHAR2 2 NO SUFF: The suffix of the position on which to exclude
the Benefit/Deduction.
NBRXDED_BDCA_CODE VARCHAR2 3 NO BDCA CODE: The Benefit/Deduction code to exclude on
this job.
NBRXDED_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 58
TABLE: NBTEMPF
CREATOR: POSNCTL
Salary Planner Extracted Employee Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTEMPF_PIDM NUMBER 8 NO PIDM: Personal identification code for the Salary
Planner user on the web.
NBTEMPF_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBTEMPF_SCENARIO VARCHAR2 30 NO SCENARIO: The Scenario code associated with this
record.
NBTEMPF_SEQ_NO NUMBER 12 NO SEQUENCE NUMBER:Sequence Number for the Employees to
be displayed in the Salary Planner.
NBTEMPF_EMPLOYEE_PIDM NUMBER 8 NO EMPLOYEE PIDM: The internal identification number of
the employee associated with this record.
NBTEMPF_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Organization code as defined in
Banner Finance when Finance is installed or Banner HR
when Finance is not installed.
NBTEMPF_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
NBTEMPF_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 59
TABLE: NBTFPRM
CREATOR: POSNCTL
Salary Planner Filter Parameter Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTFPRM_PIDM VARCHAR2 8 NO PIDM: Internal System Identification
Number.
NBTFPRM_SPEX_CODE VARCHAR2 12 NO SPEX CODE: Salary planner extract code.
NBTFPRM_SCENARIO VARCHAR2 30 NO SCENARIO: Scenario code associated with this extract
ID.
NBTFPRM_LABEL VARCHAR2 30 NO LABEL: Name associated with the selected criteria.
NBTFPRM_VALUE VARCHAR2 30 NO VALUE: Value associated with the selection criteria.
NBTFPRM_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBTFPRM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 60
TABLE: NBTFTOT
CREATOR: POSNCTL
Fringe Actual Budget Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTFTOT_SESSION_ID NUMBER 8 NO SESSION ID: The session ID of a current user.
NBTFTOT_WORKBOOK VARCHAR2 255 NO WORK BOOK: The file name of the MS Excel Spreadsheet
Work Book where Fringe Actual Budget Data resides.
NBTFTOT_WORKSHEET VARCHAR2 255 NO WORK SHEET: The file name of the MS Excel Spreadsheet
Work Sheet that contains Fringe Actual Budget Data.
NBTFTOT_ROW_NUMBER NUMBER 8 NO ROW NUMBER: Row number on the Work Sheet that contains
Fringe Actual Budget data.
NBTFTOT_POSN VARCHAR2 6 NO POSITION: Position Number.
NBTFTOT_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: BANNER HR system defined code for
the fiscal year.
NBTFTOT_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date on which this record becomes
effective.
NBTFTOT_STATUS VARCHAR2 1 YES STATUS: Status of Fringe Benefits Budget Total Record.
Values (C)ancelled, (A)ctive, (F)rozen.
NBTFTOT_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS: The primary identification code for
any chart of accounts which is used to uniquely
identify that chart from any other in a multi-chart
environment.
NBTFTOT_ORGN_CODE VARCHAR2 6 NO FRINGE BENEFITS ORGANIZATION CODE: Organization that
controls the budget for the fringe benefits for this
position.
NBTFTOT_BUDGET NUMBER 11 2 YES FRINGE BENEFITS BUDGET: Amount Budgeted for the Fringe
Benefits for this position.
NBTFTOT_BUDGET_TO_POST NUMBER 11 2 YES FRINGE BENEFITS BUDGET TO POST: Amount of the Fringe
Benefits budget that has tobe posted to Finance.
NBTFTOT_EXPEND NUMBER 11 2 YES FRINGE BENEFITS EXPENDED AMOUNT: Amount of money
expended towards the Fringe Benefits Budget for this
position.
NBTFTOT_OBUD_CODE VARCHAR2 6 YES FRINGE BENEFITS BUDGET ID CODE: System defined code
for Budget Id of the fringe benefits. Validated
against BANNER FINANCE if it is installed.
NBTFTOT_OBPH_CODE VARCHAR2 6 YES FRINGE BENEFITS BUDGET PHASE CODE: A system defined
code for the Budget Phase for the fringe benefits.
Validated against BANNER FINANCE if it is installed.
NBTFTOT_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CODE: A code that identifies the
Benefit/Deduction category.
NBTFTOT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 61
TABLE: NBTJERR
CREATOR: POSNCTL
Salary Planner Upload Jobs Error Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTJERR_SESSION_ID VARCHAR2 30 NO SESSION ID: Oracle session ID.
NBTJERR_PIDM NUMBER 8 NO PIDM: Personal identification code for an individual
tracked in the system.
NBTJERR_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
NBTJERR_SUFF VARCHAR2 2 NO SUFFIX: The Suffix attached to the job.
NBTJERR_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date that the record becomes
effective.
NBTJERR_SEQ_NO NUMBER 6 NO SEQUENCE NUMBER: Sequence Number of record.
NBTJERR_MSG_TYPE VARCHAR2 1 NO MESSAGE TYPE: Type of Message (W)arning or (E)rror.
NBTJERR_ERROR_MSG VARCHAR2 80 NO ERROR MESSAGE: The Error Message.
NBTJERR_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
NBTJERR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 62
TABLE: NBTJOBF
CREATOR: POSNCTL
Salary Planner Employee's Jobs Filter Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTJOBF_PIDM NUMBER 8 NO PIDM: Personal identification code for the Salary
Planner user on the web.
NBTJOBF_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBTJOBF_SCENARIO VARCHAR2 30 NO SCENARIO: The Scenario code associated with this
record.
NBTJOBF_EMPF_SEQ_NO NUMBER 12 NO NBTEMPF SEQUENCE NUMBER: Sequence number of the
Employee whose job is to be displayed in the Salary
Planner.
NBTJOBF_SEQ_NO NUMBER 12 NO SEQUENCE NUMBER:Sequence number of the Jobs to be
displayed for each employee in the Salary Planner .
NBTJOBF_EMPLOYEE_PIDM NUMBER 8 NO EMPLOYEE PIDM: Personal identification code for an
employee tracked in the system.
NBTJOBF_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
NBTJOBF_SUFF VARCHAR2 2 NO SUFFIX: The Suffix attached to the job.
NBTJOBF_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date that the Jobs record becomes
effective.
NBTJOBF_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
NBTJOBF_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 63
TABLE: NBTORSF
CREATOR: POSNCTL
Salary Planner Organization Summary Filter Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTORSF_PIDM NUMBER 8 NO PIDM: Personal identification code for the Salary
Planner user on the web.
NBTORSF_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NBTORSF_SCENARIO VARCHAR2 30 NO SCENARIO: The Scenario code associated with this
record.
NBTORSF_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Organization code as defined in
Banner Finance when Finance is installed or Banner HR
when Finance is not installed.
NBTORSF_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
NBTORSF_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 64
TABLE: NBTPERR
CREATOR: POSNCTL
Salary Planner Upload Position Error Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTPERR_SESSION_ID VARCHAR2 30 NO SESSION ID: Session ID of the user.
NBTPERR_POSN VARCHAR2 6 NO POSN: Position that generated the error.
NBTPERR_SEQ_NO NUMBER 6 NO SEQ NO: Sequence number of the error.
NBTPERR_MSG_TYPE VARCHAR2 1 NO MSG TYPE: Message Type (W)arning or (E)rror.
NBTPERR_ERROR_MSG VARCHAR2 80 NO ERROR MSG: Error Message.
NBTPERR_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NBTPERR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 65
TABLE: NBTPLBD
CREATOR: POSNCTL
Position Labor Distribution Account Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTPLBD_SESSION_ID NUMBER 8 NO SESSION ID: The session ID of a current user.
NBTPLBD_WORKBOOK VARCHAR2 255 NO WORK BOOK: The file name of the MS Excel Spreadsheet
Work Book where Labor Distribution Budget Data
resides.
NBTPLBD_WORKSHEET VARCHAR2 255 NO WORK SHEET: The file name of the MS Excel Spreadsheet
Work Sheet that contains Labor Distribution Budget
Data.
NBTPLBD_ROW_NUMBER NUMBER 8 NO ROW NUMBER: Row number on the Work Sheet that contains
Labor Distribution Budget data.
NBTPLBD_POSN VARCHAR2 6 NO POSITION: Position Number
NBTPLBD_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: The BANNER HR system defined fiscal
year.
NBTPLBD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The BANNER FINANCE system
defined Chart of Accounts Code under which this
position is to be charged.
NBTPLBD_ACCI_CODE VARCHAR2 6 YES POSITION ACCOUNT INDEX CODE: An index code that is
used to default the account distribution to which this
position should be charged.
NBTPLBD_FUND_CODE VARCHAR2 6 YES POSITION FUND CODE: BANNER FINANCE system defined code
that identifies the fund to which this position should
be charged.
NBTPLBD_ORGN_CODE VARCHAR2 6 YES POSITION ORGANIZATION CODE: BANNER FINANCE system
defined code that identifies the Organization to which
this position should be charged.
NBTPLBD_ACCT_CODE VARCHAR2 6 YES POSITION ACCOUNT CODE : BANNER FINANCE system defined
code which identifies the position account to be
charged.
NBTPLBD_PROG_CODE VARCHAR2 6 YES POSITION PROGRAM CODE: BANNER FINANCE system defined
code that identifies the Program to which this
position should be charged.
NBTPLBD_ACTV_CODE VARCHAR2 6 YES POSITION ACTIVITY CODE: BANNER FINANCE system defined
code that identifies the activity to which the
position should be charged.
NBTPLBD_LOCN_CODE VARCHAR2 6 YES POSITION LOCATION CODE: BANNER FINANCE system defined
code that identifies the Program to which this
position should be charged.
NBTPLBD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES POSITION EXTERNAL ACCOUNT CODE: A NON-BANNER FINANCE
System Account Distribution Code to which this
position should be charged.
NBTPLBD_PERCENT NUMBER 5 2 NO POSITION LABOR DISTRIBUTION PERCENT: Percent of
Position's Budget to be applied to this labor
distribution.
NBTPLBD_ACTIVITY_DATE DATE 7 NO ACTIVITY_DATE: Date the record was inserted or last
modified.
NBTPLBD_OBUD_CODE VARCHAR2 6 YES BUDGET ID CODE: System Defined Code for the Position's
Budget Id.
NBTPLBD_OBPH_CODE VARCHAR2 6 YES BUDGET PHASE CODE: System Defined Code for the Budget
Phase of the Position.
Date: 21-JUN-2004 Page: 66
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTPLBD_CHANGE_IND VARCHAR2 1 YES CHANGE INDICATOR: Internally used. Indicates for
reversing remaining dollars out of old labor
distribution.
NBTPLBD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NBTPLBD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
NBTPLBD_BUDGET NUMBER 11 2 YES BUDGET: The amount of Position Total Budget charged to
this accounting distribution.
NBTPLBD_BUDGET_TO_POST NUMBER 11 2 YES BUDGET TO POST: The amount of Position Total Budget
charged to this accounting distribution that needs to
be posted to finance.
Date: 21-JUN-2004 Page: 67
TABLE: NBTPOSF
CREATOR: POSNCTL
Salary Planner Position Filter Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTPOSF_PIDM NUMBER 8 NO PIDM: Personal identification code for the Salary
Planner user on the web.
NBTPOSF_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXRACT CODE: The Extract ID associated
with this record.
NBTPOSF_SCENARIO VARCHAR2 30 NO SCENARIO: The Scenario code associated with this
record.
NBTPOSF_SEQ_NO NUMBER 12 NO SEQUENCE NUMBER:Sequence number of the Positions to be
displayed in the Salary Planner .
NBTPOSF_POSN VARCHAR2 6 NO POSITION: The Positions to be displayed in the Salary
Planner.
NBTPOSF_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Organization code as defined in the
Banner Finance system.
NBTPOSF_PTOT_EFFECTIVE_DATE DATE 7 NO POSITION TOTAL EFFECTIVE DATE: The Date that the
Position Total record becomes effective.
NBTPOSF_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
NBTPOSF_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 68
TABLE: NBTPTOT
CREATOR: POSNCTL
Salary Budget Temporary Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTPTOT_SESSION_ID NUMBER 8 NO SESSION ID: The session ID of a current user.
NBTPTOT_WORKBOOK VARCHAR2 255 NO WORK BOOK: The file name of the MS Excel Spreadsheet
Work Book where Salary Budget Data resides.
NBTPTOT_WORKSHEET VARCHAR2 255 NO WORK SHEET: The file name of the MS Excel Spreadsheet
Work Sheet that contains Salary Budget Data.
NBTPTOT_ROW_NUMBER NUMBER 8 NO ROW NUMBER: Row number on the Work Sheet that contains
Salary Budget data.
NBTPTOT_POSN VARCHAR2 6 NO POSITION: The position number.
NBTPTOT_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: The BANNER HR system defined fiscal
year.
NBTPTOT_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the record becomes effective.
NBTPTOT_STATUS VARCHAR2 1 YES PTOT STATUS: Position total status.
NBTPTOT_FTE NUMBER 7 4 NO FULL TIME EQUIVALENCY: The full time equivalency
percentage assigned.
NBTPTOT_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE : Valid only if Banner Finance
is present.
NBTPTOT_ORGN_CODE VARCHAR2 6 NO ORGANIZATION CODE: Organization code as defined in the
Banner Finance system.
NBTPTOT_BUDGET NUMBER 11 2 YES POSITION BUDGET: The amount of money budgeted for this
position for a fiscal year.
NBTPTOT_ENCUMB NUMBER 11 2 YES ENCUMBRANCE AMOUNT: Total encumbrance amount.
NBTPTOT_EXPEND NUMBER 11 2 YES EXPENDITURE AMOUNT: Total amount of money expended.
NBTPTOT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
NBTPTOT_OBUD_CODE VARCHAR2 6 YES BUDGET ID CODE: System Defined Code for the Position
Budget Id.
NBTPTOT_OBPH_CODE VARCHAR2 6 YES BUDGET PHASE CODE: System Defined Code for the Budget
Phase.
NBTPTOT_SGRP_CODE VARCHAR2 6 YES SALARY GROUP CODE: Salary group code associated with
this record.
NBTPTOT_BUDGET_FRNG NUMBER 11 2 YES POSITION BUDGET FRINGE: The amount of money budgeted
for the fringe benefits of this position.
NBTPTOT_ENCUMB_FRNG NUMBER 11 2 YES FRINGE ENCUMBRANCE: The amount of money encumbered
towards the fringe benefits of this position.
NBTPTOT_EXPEND_FRNG NUMBER 11 2 YES FRINGE EXPENDITURE: The amount of money expended
towards the fringe benefits of this position.
NBTPTOT_ACCI_CODE_FRNG VARCHAR2 6 YES ACCOUNT INDEX CODE: Index defined in the BANNER
Finance system.
NBTPTOT_FUND_CODE_FRNG VARCHAR2 6 YES FRINGE FUND CODE: Fringe fund code as defined in the
Banner Finance system.
NBTPTOT_ORGN_CODE_FRNG VARCHAR2 6 YES FRINGE ORGANIZATION CODE: Fringe organization code as
defined in the Banner Finance system.
NBTPTOT_ACCT_CODE_FRNG VARCHAR2 6 YES FRINGE ACCOUNT CODE: Fringe account code as defined in
the Banner Finance system.
Date: 21-JUN-2004 Page: 69
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTPTOT_PROG_CODE_FRNG VARCHAR2 6 YES FRINGE PROGRAM CODE: Fringe program code as defined in
the Banner Finance system.
NBTPTOT_ACTV_CODE_FRNG VARCHAR2 6 YES FRINGE ACTIVITY CODE: Fringe activity code as defined
in the Banner Finance system.
NBTPTOT_LOCN_CODE_FRNG VARCHAR2 6 YES FRINGE LOCATION CODE: Fringe location code as defined
in the Banner Finance system.
NBTPTOT_RECURRING_BUDGET NUMBER 11 2 YES Recurring Budget Amount; This field will allow the
user to enter a Recurring Budget Amount which will
remain constant throughout the fiscal year even though
the Budget Amount may change due to budget transfers
and/or budget adjustments.
NBTPTOT_BUDG_BASIS NUMBER 6 2 NO POSITION BUDGET BASIS: The period of the Position
Annual Basis to be worked.
NBTPTOT_ANN_BASIS NUMBER 6 2 NO POSITION ANNUAL BASIS: The period of time a position
is based upon or budgeted for.
NBTPTOT_BASE_UNITS NUMBER 3 1 NO BASE UNITS: The number of pay periods for the
position.
NBTPTOT_APPT_PCT NUMBER 5 2 NO APPOINTMENT PERCENT: The effort for the position.
NBTPTOT_CREATE_JFTE_IND VARCHAR2 1 NO
Date: 21-JUN-2004 Page: 70
TABLE: NBTRTOT
CREATOR: POSNCTL
Premium Earnings Budget Totals Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NBTRTOT_SESSION_ID NUMBER 8 NO SESSION ID: The session ID of a current user.
NBTRTOT_WORKBOOK VARCHAR2 255 NO WORK BOOK: The file name of the MS Excel Spreadsheet
Work Book where Premium Earnings Budget Data resides.
NBTRTOT_WORKSHEET VARCHAR2 255 NO WORK SHEET: The file name of the MS Excel Spreadsheet
Work Sheet that contains Premium Earnings Budget Data.
NBTRTOT_ROW_NUMBER NUMBER 8 NO ROW NUMBER: Row number on the Work Sheet that contains
Premium Earnings Budget data.
NBTRTOT_POSN VARCHAR2 6 NO POSITION: Position Number.
NBTRTOT_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: BANNER HR system defined code for
the fiscal year.
NBTRTOT_STATUS VARCHAR2 1 NO STATUS: Status of Premium Earnings Budget Total
Record. Values (C)ancelled, (A)ctive, (F)rozen.
NBTRTOT_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The BANNER FINANCE Chart of
Accounts Code under which the position is created.
NBTRTOT_ORGN_CODE VARCHAR2 6 NO PREMIUM EARNINGS ORGANIZATION CODE: Organization that
controls the budget for the Premium Earning for this
position.
NBTRTOT_OBUD_CODE VARCHAR2 6 YES PREMIUM EARNINGS BUDGET ID CODE: System defined code
for Budget Id of the Premium Earning. Validated
against BANNER FINANCE if it is installed.
NBTRTOT_OBPH_CODE VARCHAR2 6 YES PREMIUM EARNINGS BUDGET PHASE CODE: A system defined
code for the Budget Phase for the Premium Earnings.
Validated against BANNER FINANCE if it is installed.
NBTRTOT_EARN_CODE VARCHAR2 3 NO EARNINGS CODE: A code which identifies the Premium
Earning.
NBTRTOT_BUDGET NUMBER 11 2 YES PREMIUM EARNINGS BUDGET: Amount Budgeted for the
Premium Earnings for this position.
NBTRTOT_BUDGET_TO_POST NUMBER 11 2 YES PREMIUM EARNINGS BUDGET TO POST: Amount of the Premium
Earning budget that has to be posted to Finance.
NBTRTOT_EXPEND NUMBER 11 2 YES PREMIUM EARNINGS EXPENDED AMOUNT: Amount of money
expended towards the Premium Earning Budget for this
position.
NBTRTOT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 71
SEQUENCE: NHBTSEQ
CREATOR: POSNCTL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999999999999999
Increment: 1
Last Number: 4001758
Cache Size: 20
Order Option: ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 72
TABLE: NHRDIST
CREATOR: POSNCTL
Payroll Distribution History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRDIST_YEAR VARCHAR2 4 YES Pay Period Year for Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditure type transactions.
NHRDIST_PICT_CODE VARCHAR2 2 YES Pay Period Year for Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditures.
NHRDIST_PAYNO NUMBER 3 YES Pay Period Pay Number from Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditures.
NHRDIST_PIDM NUMBER 8 YES PIDM : Internal System Identification Number.
NHRDIST_SEQ_NO NUMBER 2 YES Pay Event Identifying Sequence Number. This will be
NULL for all transactions other than Expenditures.
NHRDIST_HIST_TYPE_IND VARCHAR2 1 YES Pay Event Type Indicator pulled from PHRHIST_TYPE_IND.
This indicates the type of Pay Event (Manual, Void,
Redistribution etc).
NHRDIST_CATEGORY_CODE VARCHAR2 1 NO An internal code which identifies the type of Finance
Interface transaction. (Earnings, Employee
deductions, Net Pay, Budget Adjustment, Encumbrance
etc. ).
NHRDIST_SOURCE VARCHAR2 10 YES This column will help tie the transaction back to its
source. Different values are stored here depending on
the transaction ... (For Earnings: Earn Code, for
Benefits/Deductions: Deduction/Benefit code, for
B
udget: Position ID etc.)
NHRDIST_FISC_CODE VARCHAR2 4 YES The Fiscal Year to which this interface transaction
will be posted.
NHRDIST_RUCL_CODE VARCHAR2 4 YES The Finance System Rule Class code to be applied to
this interface transaction.
NHRDIST_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code. Only filled if Finance System
present.
NHRDIST_FUND_CODE VARCHAR2 6 YES Fund. Filled if Banner Finance is present.
NHRDIST_ORGN_CODE VARCHAR2 6 YES Organization. Filled if Banner Finance is present.
NHRDIST_ACCT_CODE VARCHAR2 6 YES Account. Filled if Banner Finance is present.
NHRDIST_PROG_CODE VARCHAR2 6 YES Program. Can only contain a value if Banner Finance
is present.
NHRDIST_ACTV_CODE VARCHAR2 6 YES Activity. Will only contain a value if Banner Finance
is present.
NHRDIST_LOCN_CODE VARCHAR2 6 YES Location. Can only contain a value if Banner Finance
is present.
NHRDIST_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NHRDIST_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
NHRDIST_ACCT_CODE_EXTERNAL VARCHAR2 60 YES Free form Account Number to be used to interface to
Finance systems other than Banner Finance when Banner
Finance is not present.
Date: 21-JUN-2004 Page: 73
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRDIST_DR_CR_IND VARCHAR2 1 YES Interface Debit/Credit indicator. This column can
have a value of D, C, + or - depending on the
particular transaction and whether that transaction
represents a negative amount or not.
NHRDIST_AMT NUMBER 11 2 YES The absolute amount of the transaction (always a
positive number). The NHRDIST_DR_CR_IND is used when
representing negative transactions.
NHRDIST_TRANS_DATE DATE 7 NO The transaction date used to post this entry through
into the Finance system.
NHRDIST_INTERFACED_IND VARCHAR2 1 YES Indicates whether this transaction has been passed
across to the Interface transaction hold table
(GURFEED).
NHRDIST_OBUD_CODE VARCHAR2 6 YES Budget Code pulled from the NBRPTOT_OBUD_CODE column.
This will be NULL for those Finance transactions that
are not associated with a particular Budget.
NHRDIST_OBPH_CODE VARCHAR2 6 YES Budget Phase Code pulled from the NBRPTOT_OBPH_CODE
column. This will be NULL for those Finance
transactions that are not associated with a particular
Budget.
NHRDIST_POSN VARCHAR2 6 YES POSITION: Position Number
NHRDIST_ENCD_NUM VARCHAR2 8 YES ENCUMBRANCE DOCUMENT NUMBER: Used with BANNER FINANCE
to identify the encumbrance document posted from
BANNER HR for a given fiscal year.
NHRDIST_ENCD_ITEM_NUM NUMBER 4 YES ENCUMBRANCE ITEM NUMBER: Used with BANNER FINANCE to
identify the line item on the encumbrance document
posted from BANNER HR. Item 0 is salary, 1 is
standard fringe, 2 is residual fringe.
NHRDIST_ENCD_SEQ_NUM NUMBER 4 YES ENCUMBRANCE SEQUENCE NUMBER: Used with BANNER FINANCE
to identify the sequence number on the encumbrance
document posted from BANNER HR.
NHRDIST_PTOT_STATUS VARCHAR2 1 YES PTOT STATUS: Position Total Status for use in
controlling the interface of active and working
budgets to Finance.
NHRDIST_HRS NUMBER 6 2 YES Labor Distribution Hours: Populated from phrelbd
table.
NHRDIST_BDCA_CODE VARCHAR2 3 YES Benefit Code: Populated from phrdedn table.
NHRDIST_EARN_CODE VARCHAR2 3 YES Benefit Code: Populated from phrearn table.
NHRDIST_ECLS_CODE VARCHAR2 2 YES Job Employee Class: Populated from the phrjobs table.
NHRDIST_SUFF VARCHAR2 2 YES Job Suffix: Populated from the phrjobs table.
NHRDIST_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NHRDIST_EARN_EXPENDS_PTOT_IND VARCHAR2 1 YES POSITION TOTAL INDICATOR: A Y will be placed in this
field if the earning being processed updates the
position total and expended amount. Otherwise it will
be left NULL.
NHRDIST_TNUM NUMBER 15 YES NHRDIST_TNUM: Unique transaction number generated by
nhpfin1 or phpfexp process.
NHRDIST_DOC_CODE VARCHAR2 8 YES NHRDIST_DOC_CODE: Finance document code: Populated
from nhpfin2 process
NHRDIST_POSNBUD_DOC_CODE VARCHAR2 8 YES NHRDIST_POSNBUD_DOC_CODE: Finance position budget
document code. Populated from nhpfin2 process.
Date: 21-JUN-2004 Page: 74
TABLE: NHRECRT
CREATOR: POSNCTL
Temporary Table for the nhrecrt - Effort Certification Report
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRECRT_SESSIONID NUMBER 8 YES Unique ORACLE session id
NHRECRT_PIDM NUMBER 8 YES PIDM: Internal System Identification Number.
NHRECRT_CATEGORY_CODE VARCHAR2 1 YES An internal code which identifies the type of Finance
Interface transaction. (Earnings, Employee
deductions, Net Pay, Budget Adjustment, Encumbrance
etc. ).
NHRECRT_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
NHRECRT_GRNT_CODE VARCHAR2 9 YES Finance System Grant Code
NHRECRT_FUND_CODE VARCHAR2 6 YES Fund.
NHRECRT_ORGN_CODE VARCHAR2 6 YES Organization.
NHRECRT_ACCT_CODE VARCHAR2 6 YES Account.
NHRECRT_PROG_CODE VARCHAR2 6 YES Program.
NHRECRT_ACTV_CODE VARCHAR2 6 YES Activity.
NHRECRT_LOCN_CODE VARCHAR2 6 YES Location.
NHRECRT_COL1_AMT NUMBER 11 2 YES Column 1 Amount
NHRECRT_COL1_PCT NUMBER 6 2 YES Column 1 Percent
NHRECRT_COL2_AMT NUMBER 11 2 YES Column 2 Amount
NHRECRT_COL2_PCT NUMBER 6 2 YES Column 2 Percent
NHRECRT_COL3_AMT NUMBER 11 2 YES Column 3 Amount
NHRECRT_COL3_PCT NUMBER 6 2 YES Column 3 Percent
NHRECRT_COL4_AMT NUMBER 11 2 YES Column 4 Amount
NHRECRT_COL4_PCT NUMBER 6 2 YES Column 4 Percent
NHRECRT_COL5_AMT NUMBER 11 2 YES Column 5 Amount
NHRECRT_COL5_PCT NUMBER 6 2 YES Column 5 Percent
NHRECRT_COL6_AMT NUMBER 11 2 YES Column 6 Amount
NHRECRT_COL6_PCT NUMBER 6 2 YES Column 6 Percent
NHRECRT_COL7_AMT NUMBER 11 2 YES Column 7 Amount
NHRECRT_COL7_PCT NUMBER 6 2 YES Column 7 Percent
NHRECRT_COL8_AMT NUMBER 11 2 YES Column 8 Amount
NHRECRT_COL8_PCT NUMBER 6 2 YES Column 8 Percent
NHRECRT_COL9_AMT NUMBER 11 2 YES Column 9 Amount
NHRECRT_COL9_PCT NUMBER 6 2 YES Column 9 Percent
NHRECRT_COL10_AMT NUMBER 11 2 YES Column 10 Amount
NHRECRT_COL10_PCT NUMBER 6 2 YES Column 10 Percent
NHRECRT_COL11_AMT NUMBER 11 2 YES Column 11 Amount
NHRECRT_COL11_PCT NUMBER 6 2 YES Column 11 Percent
NHRECRT_COL12_AMT NUMBER 11 2 YES Column 12 Amount
NHRECRT_COL12_PCT NUMBER 6 2 YES Column 12 Percent
NHRECRT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 75
TABLE: NHRENCD
CREATOR: POSNCTL
Encumbrance Number Sequence Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRENCD_ENCD_NUM VARCHAR2 8 NO ENCUMBRANCE NUMBER: The Encumbrance number used for
interface with Banner Finance.
NHRENCD_ENCD_ITEM_NUM NUMBER 4 NO ENCUMBRANCE ITEM NUMBER: Used with BANNER FINANCE to
identify the line item on the encumbrance document
posted from BANNER HR. Item 0 is salary, 1 is
standard fringe, 2 is residual fringe.
NHRENCD_ENCD_SEQ_NUM NUMBER 4 NO ENCUMBRANCE SEQUENCE NUMBER: The Encumbrance sequence
number used for interface with Banner Finance.
NHRENCD_INTERFACED_IND VARCHAR2 1 NO INTERFACED INDICATOR: Indicates whether this
transaction has been interfaced.
NHRENCD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 76
TABLE: NHRFINC
CREATOR: POSNCTL
HR/Finance Interface Distribution Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRFINC_YEAR VARCHAR2 4 YES Pay Period Year for Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditure type transactions.
NHRFINC_PICT_CODE VARCHAR2 2 YES Pay Period Year for Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditures.
NHRFINC_PAYNO NUMBER 3 YES Pay Period Pay Number from Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditures.
NHRFINC_PIDM NUMBER 8 YES PIDM : Internal System Identification Number.
NHRFINC_SEQ_NO NUMBER 2 YES Pay Event Identifying Sequence Number. This will be
NULL for all transactions other than Expenditures.
NHRFINC_HIST_TYPE_IND VARCHAR2 1 YES Pay Event Type Indicator pulled from PHRHIST_TYPE_IND.
This indicates the type of Pay Event (Manual, Void,
Redistribution etc).
NHRFINC_CATEGORY_CODE VARCHAR2 1 NO An internal code which identifies the type of Finance
Interface transaction. (Earnings, Employee
deductions, Net Pay, Budget Adjustment, Encumbrance
etc. ).
NHRFINC_SOURCE VARCHAR2 10 YES This column will help tie the transaction back to its
source. Different values are stored here depending on
the transaction ... (For Earnings: Earn Code, for
Benefits/Deductions: Deduction/Benefit code, for
Budget: Position ID etc.)
NHRFINC_FISC_CODE VARCHAR2 4 YES The Fiscal Year to which this interface transaction
will be posted.
NHRFINC_RUCL_CODE VARCHAR2 4 YES The Finance System Rule Class code to be applied to
this interface transaction.
NHRFINC_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code. Only filled if Finance System
present.
NHRFINC_FUND_CODE VARCHAR2 6 YES Fund. Filled if Banner Finance is present.
NHRFINC_ORGN_CODE VARCHAR2 6 YES Organization. Filled if Banner Finance is present.
NHRFINC_ACCT_CODE VARCHAR2 6 YES Account. Filled if Banner Finance is present.
NHRFINC_PROG_CODE VARCHAR2 6 YES Program. Can only contain a value if Banner Finance
is present.
NHRFINC_ACTV_CODE VARCHAR2 6 YES Activity. Will only contain a value if Banner Finance
is present.
NHRFINC_LOCN_CODE VARCHAR2 6 YES Location. Can only contain a value if Banner Finance
is present.
NHRFINC_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NHRFINC_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
NHRFINC_ACCT_CODE_EXTERNAL VARCHAR2 60 YES Free form Account Number to be used to interface to
Finance systems other than Banner Finance when Banner
Finance is not present.
Date: 21-JUN-2004 Page: 77
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRFINC_DR_CR_IND VARCHAR2 1 YES Interface Debit/Credit indicator. This column can
have a value of D, C, + or - depending on the
particular transaction and whether that transaction
represents a negative amount or not.
NHRFINC_AMT NUMBER 11 2 YES The absolute amount of the transaction (always a
positive number). The NHRFINC_DR_CR_IND is used when
representing negative transactions.
NHRFINC_TRANS_DATE DATE 7 NO The transaction date used to post this entry through
into the Finance system.
NHRFINC_INTERFACED_IND VARCHAR2 1 YES Indicates whether this transaction has been passed
across to the Interface transaction hold table
(GURFEED).
NHRFINC_OBUD_CODE VARCHAR2 6 YES Budget Code pulled from the NBRPTOT_OBUD_CODE column.
This will be NULL for those Finance transactions that
are not associated with a particular Budget.
NHRFINC_OBPH_CODE VARCHAR2 6 YES Budget Phase Code pulled from the NBRPTOT_OBPH_CODE
column. This will be NULL for those Finance
transactions that are not associated with a particular
Budget.
NHRFINC_POSN VARCHAR2 6 YES POSITION: Position Number
NHRFINC_ENCD_NUM VARCHAR2 8 YES ENCUMBRANCE DOCUMENT NUMBER: Used with BANNER FINANCE
to identify the encumbrance document posted from
BANNER HR for a given fiscal year.
NHRFINC_ENCD_ITEM_NUM NUMBER 4 YES ENCUMBRANCE ITEM NUMBER: Used with BANNER FINANCE to
identify the line item on the encumbrance document
posted from BANNER HR. Item 0 is salary, 1 is
standard fringe, 2 is residual fringe.
NHRFINC_ENCD_SEQ_NUM NUMBER 4 YES ENCUMBRANCE SEQUENCE NUMBER: Used with BANNER FINANCE
to identify the sequence number on the encumbrance
document posted from BANNER HR.
NHRFINC_PTOT_STATUS VARCHAR2 1 YES PTOT STATUS: Position Total Status for use in
controlling the interface of active and working
budgets to Finance.
NHRFINC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NHRFINC_TNUM NUMBER 15 YES NHRFINC_TNUM: Unique transaction number generated by
nhpfin1 and phpfexp process.
NHRFINC_DOC_CODE VARCHAR2 8 YES :NHRFINC_DOC_CODE: Finance document code. Populated
from nhpfin2 process.
NHRFINC_POSNBUD_DOC_CODE VARCHAR2 8 YES NHRFINC_POSNBUD_DOC_CODE: Finance position budget
document code. Populated from nhpfin2 process.
NHRFINC_HRS NUMBER 6 2 YES NHRFINC_HRS: Labor Distribution Hours. Populated from
phrelbd table.
NHRFINC_BDCA_CODE VARCHAR2 3 YES NHRFINC_BDCA_CODE: Benefit Code. Populated from
phrdedn table.
NHRFINC_EARN_CODE VARCHAR2 3 YES NHRFINC_EARN_CODE: Earn Code. Populated from phrearn
table.
NHRFINC_ECLS_CODE VARCHAR2 2 YES NHRFINC_ECLS_CODE: Job Employee Class. Populated from
the phrjobs table.
NHRFINC_SUFF VARCHAR2 2 YES Job Suffix: Populated from the phrjobs table.
Date: 21-JUN-2004 Page: 78
TABLE: NHRSDST
CREATOR: POSNCTL
Collector Table for the nhrsdst report.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRSDST_SESSIONID NUMBER 8 NO Session Id
NHRSDST_PIDM NUMBER 8 YES PIDM: Internal Id Number for the Employee.
NHRSDST_COAS_CODE VARCHAR2 1 YES COAS: Chart of Accounts Code.
NHRSDST_FUND_CODE VARCHAR2 6 YES FUND: Fund Code.
NHRSDST_ORGN_CODE VARCHAR2 6 YES ORGN: Organization Code.
NHRSDST_ACCT_CODE VARCHAR2 6 YES ACCT: Account Code.
NHRSDST_PROG_CODE VARCHAR2 6 YES PROG: Program Code.
NHRSDST_ACTV_CODE VARCHAR2 6 YES ACTV: Activity Code.
NHRSDST_LOCN_CODE VARCHAR2 6 YES LOCN: Location Code.
NHRSDST_COL1_VALUE NUMBER 11 2 YES Col1 Value
NHRSDST_COL2_VALUE NUMBER 11 2 YES Col2 Value.
NHRSDST_COL3_VALUE NUMBER 11 2 YES Col3 Value.
NHRSDST_COL4_VALUE NUMBER 11 2 YES Col4 Value.
NHRSDST_COL5_VALUE NUMBER 11 2 YES Col5 Value.
NHRSDST_COL6_VALUE NUMBER 11 2 YES Col6 Value.
NHRSDST_COL7_VALUE NUMBER 11 2 YES Col7 Value.
NHRSDST_COL8_VALUE NUMBER 11 2 YES Col8 Value.
NHRSDST_ACTIVITY_DATE DATE 7 YES Activity Date: Date record gets inserted into table.
NHRSDST_TRANS_DATE DATE 7 YES Transaction Date.
NHRSDST_YEAR VARCHAR2 4 YES Payroll Year
NHRSDST_PICT_CODE VARCHAR2 2 YES Payroll ID
NHRSDST_PAYNO NUMBER 3 YES Pay Number
NHRSDST_SEQ_NO NUMBER 3 YES Sequence Number
Date: 21-JUN-2004 Page: 79
TABLE: NHRTBUD
CREATOR: POSNCTL
Payroll Distribution History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRTBUD_YEAR VARCHAR2 4 YES Pay Period Year for Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditure type transactions.
NHRTBUD_PICT_CODE VARCHAR2 2 YES Pay Period Year for Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditures.
NHRTBUD_PAYNO NUMBER 3 YES Pay Period Pay Number from Expenditure Interface
transactions. This will be NULL for all transactions
other than Expenditures.
NHRTBUD_PIDM NUMBER 8 YES PIDM : Internal System Identification Number.
NHRTBUD_SEQ_NO NUMBER 2 YES Pay Event Identifying Sequence Number. This will be
NULL for all transactions other than Expenditures.
NHRTBUD_HIST_TYPE_IND VARCHAR2 1 YES Pay Event Type Indicator pulled from PHRHIST_TYPE_IND.
This indicates the type of Pay Event (Manual, Void,
Redistribution etc).
NHRTBUD_CATEGORY_CODE VARCHAR2 1 NO An internal code which identifies the type of Finance
Interface transaction. (Earnings, Employee
deductions, Net Pay, Budget Adjustment, Encumbrance
etc. ).
NHRTBUD_SOURCE VARCHAR2 10 YES This column will help tie the transaction back to its
source. Different values are stored here depending on
the transaction ... (For Earnings: Earn Code, for
Benefits/Deductions: Deduction/Benefit code, for
Budget: Position ID etc.)
NHRTBUD_FISC_CODE VARCHAR2 4 YES The Fiscal Year to which this interface transaction
will be posted.
NHRTBUD_RUCL_CODE VARCHAR2 4 YES The Finance System Rule Class code to be applied to
this interface transaction.
NHRTBUD_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code. Only filled if Finance System
present.
NHRTBUD_FUND_CODE VARCHAR2 6 YES Fund. Filled if Banner Finance is present.
NHRTBUD_ORGN_CODE VARCHAR2 6 YES Organization. Filled if Banner Finance is present.
NHRTBUD_ACCT_CODE VARCHAR2 6 YES Account. Filled if Banner Finance is present.
NHRTBUD_PROG_CODE VARCHAR2 6 YES Program. Can only contain a value if Banner Finance
is present.
NHRTBUD_ACTV_CODE VARCHAR2 6 YES Activity. Will only contain a value if Banner Finance
is present.
NHRTBUD_LOCN_CODE VARCHAR2 6 YES Location. Can only contain a value if Banner Finance
is present.
NHRTBUD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NHRTBUD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
NHRTBUD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES Free form Account Number to be used to interface to
Finance systems other than Banner Finance when Banner
Finance is not present.
Date: 21-JUN-2004 Page: 80
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NHRTBUD_DR_CR_IND VARCHAR2 1 YES Interface Debit/Credit indicator. This column can
have a value of D, C, + or - depending on the
particular transaction and whether that transaction
represents a negative amount or not.
NHRTBUD_AMT NUMBER 11 2 YES The absolute amount of the transaction (always a
positive number). The NHRTBUD_DR_CR_IND is used when
representing negative transactions.
NHRTBUD_TRANS_DATE DATE 7 NO The transaction date used to post this entry through
into the Finance system.
NHRTBUD_INTERFACED_IND VARCHAR2 1 YES Indicates whether this transaction has been passed
across to the Interface transaction hold table
(GURFEED).
NHRTBUD_OBUD_CODE VARCHAR2 6 YES Budget Code pulled from the NBRPTOT_OBUD_CODE column.
This will be NULL for those Finance transactions that
are not associated with a particular Budget.
NHRTBUD_OBPH_CODE VARCHAR2 6 YES Budget Phase Code pulled from the NBRPTOT_OBPH_CODE
column. This will be NULL for those Finance
transactions that are not associated with a particular
Budget.
NHRTBUD_POSN VARCHAR2 6 YES POSITION: Position Number
NHRTBUD_ENCD_NUM VARCHAR2 8 YES ENCUMBRANCE DOCUMENT NUMBER: Used with BANNER FINANCE
to identify the encumbrance document posted from
BANNER HR for a given fiscal year.
NHRTBUD_ENCD_ITEM_NUM NUMBER 4 YES ENCUMBRANCE ITEM NUMBER: Used with BANNER FINANCE to
identify the line item on the encumbrance document
posted from BANNER HR. Item 0 is salary, 1 is
standard fringe, 2 is residual fringe.
NHRTBUD_ENCD_SEQ_NUM NUMBER 4 YES ENCUMBRANCE SEQUENCE NUMBER: Used with BANNER FINANCE
to identify the sequence number on the encumbrance
document posted from BANNER HR.
NHRTBUD_PTOT_STATUS VARCHAR2 1 YES PTOT STATUS: Position Total Status for use in
controlling the interface of active and working
budgets to Finance.
NHRTBUD_HRS NUMBER 6 2 YES Labor Distribution Hours: Populated from phrelbd
table.
NHRTBUD_BDCA_CODE VARCHAR2 3 YES Benefit Code: Populated from phrdedn table.
NHRTBUD_EARN_CODE VARCHAR2 3 YES Benefit Code: Populated from phrearn table.
NHRTBUD_ECLS_CODE VARCHAR2 2 YES Job Employee Class: Populated from the phrjobs table.
NHRTBUD_SUFF VARCHAR2 2 YES Job Suffix: Populated from the phrjobs table.
NHRTBUD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NHRTBUD_EARN_EXPENDS_PTOT_IND VARCHAR2 1 YES PTOT IND: Position Total indicator for use in
controlling the interface to finance.
NHRTBUD_TNUM NUMBER 15 YES NHRTBUD_TNUM: Unique transaction number generated by
nhpfin1 process.
NHRTBUD_DOC_CODE VARCHAR2 8 YES NHRTBUD_DOC_CODE: Finance document code. Populated
from nhpfin2 process
NHRTBUD_POSNBUD_DOC_CODE VARCHAR2 8 YES NHRTBUD_POSNBUD_DOC_CODE: Finance document code.
Populated from nhpfin2 process.
Date: 21-JUN-2004 Page: 81
TABLE: NOBTRAN
CREATOR: POSNCTL
Transaction Approvals Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NOBTRAN_TRANSACTION_NO NUMBER 15 NO TRANSACTION NUMBER: A number that is system generated
for approval transactions.
NOBTRAN_PIDM NUMBER 8 YES PIDM: Internal Id number.
NOBTRAN_EFFECTIVE_DATE DATE 7 YES EFFECTIVE DATE: The Date that the approval transaction
record becomes effective.
NOBTRAN_ACAT_CODE VARCHAR2 6 NO APPROVAL CATEGORY CODE: This code represents the
purpose of the personnel action.
NOBTRAN_TRANS_STATUS_IND VARCHAR2 1 NO TRANSACTION STATUS INDICATOR: The status of the
approval transaction.
NOBTRAN_SUBMITTOR_USER_ID VARCHAR2 30 YES SUBMITTOR USER ID: The user id of the submittor of the
approval transaction.
NOBTRAN_CREATED_DATE DATE 7 NO CREATED DATE: The date the approval transaction is
created.
NOBTRAN_ORIGINATOR_USER_ID VARCHAR2 30 NO ORIGINATOR USER ID: The user id of the person who
creates the transaction.
NOBTRAN_SUBMISSION_DATE DATE 7 YES SUBMISSION DATE: The date the transaction is submitted
to start the transaction through the approval queue.
NOBTRAN_APPLY_IND VARCHAR2 1 NO APPLY INDICATOR: The indicator to apply transactions
to the database.
NOBTRAN_APPLY_DATE DATE 7 YES APPLICATION DATE: The date the transaction is applied.
NOBTRAN_APPLY_USER_ID VARCHAR2 30 YES APPLY USER ID: The user id of the person who applies
the transaction.
NOBTRAN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
NOBTRAN_COMMENTS LONG YES COMMENTS: Comments with regards to the action taken on
the Approvals transaction.
Date: 21-JUN-2004 Page: 82
SEQUENCE: NOBTRAN_SEQ_NO
CREATOR: POSNCTL
===================================================================================================================
Minimum Value: 0
Maximum Value: 99999999999999999999
Increment: 1
Last Number: 45
Cache Size: 20
Order Option: NOT ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 83
TABLE: NOREAER
CREATOR: POSNCTL
Electronic Approvals Error Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NOREAER_TRANS_NO NUMBER 15 NO TRANSACTION NUMBER: Transaction number where error
occurred.
NOREAER_APTY_CODE VARCHAR2 6 NO APPROVAL TYPE CODE: Approval type with error.
NOREAER_SEQ_NO NUMBER 6 NO SEQUENCE NUMBER: Sequential number assigned to each
error generated for a transaction.
NOREAER_MSG_TYPE VARCHAR2 1 NO MESSAGE TYPE: Type of error message; warning or error
NOREAER_ERROR_MSG VARCHAR2 80 NO MESSAGE: Text of the error message.
NOREAER_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last update.
Date: 21-JUN-2004 Page: 84
TABLE: NORROUT
CREATOR: POSNCTL
Transaction Routing Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NORROUT_TRANSACTION_NO NUMBER 15 NO TRANSACTION NUMBER: A number that is system generated
for approval transactions.
NORROUT_RECIPIENT_USER_ID VARCHAR2 30 YES RECIPIENT USER ID: The user id of the approver.
NORROUT_ACTION_USER_ID VARCHAR2 30 YES ACTION USER ID: The user id of the person who took
action.
NORROUT_ALVL_CODE VARCHAR2 6 NO LEVEL CODE: A code to identify the level of approval.
NORROUT_ACTION_IND VARCHAR2 1 NO ACTION INDICATOR: The indicator for the type of action
to be taken by the approver.
NORROUT_QUEUE_STATUS_IND VARCHAR2 1 NO QUEUE STATUS IND: The indicator for the queue status
of the approver.
NORROUT_STATUS_DATE_TIME DATE 7 NO STATUS DATE TIME: The status date/time of the
approver"s action in the queue.
NORROUT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
NORROUT_LEVEL_NO NUMBER 5 2 NO LEVEL NO: Display the level codes in the approval
transaction by this level no.
Date: 21-JUN-2004 Page: 85
TABLE: NORTERN
CREATOR: POSNCTL
Transaction Approvals Default Earnings Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NORTERN_TRANSACTION_NO NUMBER 15 NO TRANSACTION NUMBER: A number that is system generated
for approval transactions.
NORTERN_APTY_CODE VARCHAR2 6 NO APPROVAL TYPE CODE: Code tied to the approval
category.
NORTERN_POSN VARCHAR2 6 NO POSITION: The position number the approval transaction
is attached to.
NORTERN_SUFF VARCHAR2 2 NO SUFFIX. Job suffix.
NORTERN_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date that the approval transaction
record becomes effective. This field is overridable.
NORTERN_EARN_CODE VARCHAR2 3 NO EARNINGS CODE: A code which identifies the transaction
approval default earnings.
NORTERN_HRS NUMBER 6 2 YES HOURS/UNITS: The hours or units to default for this
earnings code.
NORTERN_SPECIAL_RATE NUMBER 12 6 YES SPECIAL RATE: The special rate to be used for this
earnings code.
NORTERN_SHIFT VARCHAR2 1 NO SHIFT: The shift associated with earnings code.
NORTERN_CANCEL_DATE DATE 7 YES CANCEL DATE: The ended as of date of the earnings
code.
NORTERN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or last
modified.
NORTERN_APPLY_STATUS_IND VARCHAR2 1 NO APPLY STATUS INDICATOR: Indicates whether this record
has been applied to the database.
NORTERN_DEEMED_HRS NUMBER 6 2 YES DEEMED HOURS: Reportable hours for Canadian Employment
Insurance.
Date: 21-JUN-2004 Page: 86
TABLE: NORTLBD
CREATOR: POSNCTL
Transaction Approvals Labor Distributions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NORTLBD_TRANSACTION_NO NUMBER 15 NO TRANSACTION NUMBER: A number that is system generated
for approval transactions.
NORTLBD_APTY_CODE VARCHAR2 6 NO APPROVAL TYPE CODE: Code tied to the approval
category.
NORTLBD_POSN VARCHAR2 6 NO APPROVAL TRANSACTION: The APPROVAL TRANSACTION number
the approval transaction is attached to.
NORTLBD_SUFF VARCHAR2 2 NO SUFFIX. Job suffix.
NORTLBD_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date that the approval transaction
record becomes effective. This field is overridable.
NORTLBD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: The BANNER FINANCE system
defined Chart of Accounts Code under which this
APPROVAL TRANSACTION is to be charged.
NORTLBD_ACCI_CODE VARCHAR2 6 YES APPROVAL TRANSACTION ACCOUNT INDEX CODE: An index code
that is used to default the account distribution to
which this APPROVAL TRANSACTION should be charged.
NORTLBD_FUND_CODE VARCHAR2 6 YES APPROVAL TRANSACTION FUND CODE: BANNER FINANCE system
defined code that identifies the fund to which this
APPROVAL TRANSACTION should be charged.
NORTLBD_ORGN_CODE VARCHAR2 6 YES APPROVAL TRANSACTION ORGANIZATION CODE: BANNER FINANCE
system defined code that identifies the Organization
to which this APPROVAL TRANSACTION should be charged.
NORTLBD_ACCT_CODE VARCHAR2 6 YES APPROVAL TRANSACTION ACCOUNT CODE : BANNER FINANCE
system defined code which identifies the APPROVAL
TRANSACTION account to be charged.
NORTLBD_PROG_CODE VARCHAR2 6 YES APPROVAL TRANSACTION PROGRAM CODE: BANNER FINANCE
system defined code that identifies the Program to
which this APPROVAL TRANSACTION should be charged.
NORTLBD_ACTV_CODE VARCHAR2 6 YES APPROVAL TRANSACTION ACTIVITY CODE: BANNER FINANCE
system defined code that identifies the activity to
which the APPROVAL TRANSACTION should be charged.
NORTLBD_LOCN_CODE VARCHAR2 6 YES APPROVAL TRANSACTION LOCATION CODE: BANNER FINANCE
system defined code that identifies the Program to
which this APPROVAL TRANSACTION should be charged.
NORTLBD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
NORTLBD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
NORTLBD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES APPROVAL TRANSACTION EXTERNAL ACCOUNT CODE: A
NON-BANNER FINANCE System Account Distribution Code to
which this position should be charged.
NORTLBD_PERCENT NUMBER 5 2 NO APPROVAL TRANSACTION LABOR DISTRIBUTION PERCENT:
Percent of Position's Budget to be applied to this
labor distribution.
NORTLBD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or last
modified.
Date: 21-JUN-2004 Page: 87
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NORTLBD_APPLY_STATUS_IND VARCHAR2 1 NO APPLY STATUS INDICATOR: Indicates whether this record
has been applied to the database.
Date: 21-JUN-2004 Page: 88
TABLE: NORTRAN
CREATOR: POSNCTL
Transaction Approvals Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NORTRAN_TRANSACTION_NO NUMBER 15 NO TRANSACTION NUMBER: A number that is system generated
for approval transactions.
NORTRAN_APTY_CODE VARCHAR2 6 NO APPROVAL TYPE CODE: Code tied to the approval
category.
NORTRAN_POSN VARCHAR2 6 YES POSITION: The position number the approval transaction
is attached to.
NORTRAN_SUFF VARCHAR2 2 YES SUFFIX. Job suffix.
NORTRAN_AUFM_CODE VARCHAR2 7 NO FORM CODE: The form that will be sent through the
approval process.
NORTRAN_AUBK_CODE VARCHAR2 30 NO BLOCK CODE: The block that will be sent through the
approval process.
NORTRAN_AUFD_CODE VARCHAR2 30 NO FIELD CODE: The field that will be sent through the
approval process.
NORTRAN_VALUE VARCHAR2 60 YES NEW VALUE: The new value entered for the field.
NORTRAN_APPLY_STATUS_IND VARCHAR2 1 NO APPLY STATUS INDICATOR: The indicator for the status
of the transaction.
NORTRAN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
NORTRAN_DISPLAY_SEQ_NO NUMBER 5 2 YES DISPLAY SEQUENCE NO: Display the field items in the
approval transaction by this sequence no.
Date: 21-JUN-2004 Page: 89
TABLE: NPRCOLR
CREATOR: POSNCTL
Parameter Collector Repeating Table; used to hold multiple values of parameters for reports etc.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NPRCOLR_SESSIONID VARCHAR2 30 NO Unique Oracle Session ID of User running current job.
NPRCOLR_TYPE VARCHAR2 3 YES PARAMETER TYPE: Values (C)haracter; (N)umeric. Also
used as a temporary value holding field in certain
processes.
NPRCOLR_VALUE_DATE DATE 7 YES PARAMETER DATE: Effective date associated with the
parameter. Also used as a temporary value holding
field in certain processes.
NPRCOLR_VALUE_ATYP VARCHAR2 30 YES Holds actual value of the parameter being stored.
NPRCOLR_JOB VARCHAR2 30 YES Holds the file name of the report being run.
NPRCOLR_PARM_NUMBER VARCHAR2 2 YES Holds the ID for the parameter, unique by JOB.
NPRCOLR_ACTIVITY_DATE DATE 7 NO Last activity time stamp on this record.
Date: 21-JUN-2004 Page: 90
TABLE: NSRSPSC
CREATOR: POSNCTL
Salary Planner Security Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NSRSPSC_USER_CODE VARCHAR2 30 NO USER_CODE:The user ID whose security is being defined
for the Salary Planner.
NSRSPSC_ORGN_CODE VARCHAR2 6 NO ORGN_CODE:The Organization Code to which the user has
access in the Salary Planner.
NSRSPSC_ACCESS_IND VARCHAR2 1 NO ACCESS IND: The type of access the user has to the
organization. Valid values are (N)one, (Q)uery and
(U)pdate.
NSRSPSC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
NSRSPSC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
NSRSPSC_COAS_CODE VARCHAR2 1 YES COAS_CODE: The Chart of Accounts associated with the
Organization Code when Banner Finance is installed.
Date: 21-JUN-2004 Page: 91
TABLE: NTRACAT
CREATOR: POSNCTL
Approval Category Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRACAT_ACAT_CODE VARCHAR2 6 NO Category Code: A code that ident
ifies the category.
NTRACAT_APTY_CODE VARCHAR2 6 NO Approval Type Code: A code that
identifies the
approval type.
NTRACAT_APTY_ENTRY_SEQ_NO NUMBER 4 2 NO Sequence Number: Sequence Num
ber.
NTRACAT_ACTIVITY_DATE DATE 7 NO Activity Date:
Date the action was initiated
Date: 21-JUN-2004 Page: 92
TABLE: NTRACLV
CREATOR: POSNCTL
Approval Category Levels Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRACLV_ACAT_CODE VARCHAR2 6 NO Category Code: A code that ident
ifies the category.
NTRACLV_ALVL_CODE VARCHAR2 6 NO Level Code: A code that identifi
es the category
levels.
NTRACLV_ACTION_IND VARCHAR2 1 NO Action Indicator: An indicator
identifying what action
has been taken.
NTRACLV_ACTIVITY_DATE DATE 7 NO Activity Date:
Date the action was initiated
Date: 21-JUN-2004 Page: 93
TABLE: NTRADFV
CREATOR: POSNCTL
Electronic Approvals Default Values Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRADFV_ACAT_CODE VARCHAR2 6 NO EA CATEGORY CODE: A code identifying the Electronic
Approval Category code.
NTRADFV_APTY_CODE VARCHAR2 6 NO EA TYPE CODE: A code identifying the Electronic
Approval Type.
NTRADFV_AUFM_CODE VARCHAR2 7 NO FORM CODE: A code identifying the name of the Form.
NTRADFV_AUBK_CODE VARCHAR2 30 NO BLOCK CODE: A code identifying the name of the Block.
NTRADFV_AUFD_CODE VARCHAR2 30 NO FIELD CODE: A code identifying the name of the Field.
NTRADFV_AUFD_DEFAULT VARCHAR2 60 YES DEFAULT VALUE: Value which will default to NOAEPAF for
a transaction
NTRADFV_DEFAULT_OVERRIDE_IND VARCHAR2 1 NO DEFAULT VALUE OVERRIDE IND: Indicates if default value
can be changed on NOAEPAF
NTRADFV_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of the last update or insert.
Date: 21-JUN-2004 Page: 94
TABLE: NTRALVL
CREATOR: POSNCTL
Approval Level Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRALVL_CODE VARCHAR2 6 NO Category Code: A code that identifies
the category.
NTRALVL_DESC VARCHAR2 30 NO Approval Description: A description o
f the approval
level.
NTRALVL_LEVEL NUMBER 5 2 NO LEVEL NO: Display the level codes in the approval
transaction by this level no.
NTRALVL_SUPERUSER_IND VARCHAR2 1 NO Superuser Indicator: An indi
cator that identifies if
a user is a superuser.
NTRALVL_ACTIVITY_DATE DATE 7 NO Activity Date:
Date the action was initiated
Date: 21-JUN-2004 Page: 95
TABLE: NTRAPFB
CREATOR: POSNCTL
Electronic Approval Type Form/Block Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRAPFB_APTY_CODE VARCHAR2 6 NO EA Type Code:A code identifying the Electronic
Approval Type.
NTRAPFB_AUFM_CODE VARCHAR2 7 NO Form Code: A code identifying the name of the Form
NTRAPFB_AUBK_CODE VARCHAR2 30 NO Block Code: A code identifying the name of the Block
NTRAPFB_APPLY_SEQ_NO NUMBER 4 2 NO Apply Sequence Number: the sequence number of changes
made on Personnel Action Form to be applied
NTRAPFB_ACTIVITY_DATE DATE 7 NO Activity date: Date of the action was initiated
Date: 21-JUN-2004 Page: 96
TABLE: NTRAPFD
CREATOR: POSNCTL
Electronic Approval Type Field Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRAPFD_APTY_CODE VARCHAR2 6 NO EA Type Code:A code identifying the Electronic
Approval Type.
NTRAPFD_AUFM_CODE VARCHAR2 7 NO Form Code: A code identifying the name of the Form
NTRAPFD_AUBK_CODE VARCHAR2 30 NO Block Code: A code identifying the name of the Block
NTRAPFD_AUFD_CODE VARCHAR2 30 NO Field Code: a code identifying the name of the Field
NTRAPFD_DISPLAY_SEQ_NO NUMBER 5 2 YES Display Sequence Number: the sequence number of
changes made on Personnel Action Form to be displayed
NTRAPFD_ACTIVITY_DATE DATE 7 NO Activity date: Date of the action was initiated
NTRAPFD_REQUIRED_IND VARCHAR2 1 NO REQUIRED INDICATOR: Required Indicator for entry of a
field for this Approval type.
Date: 21-JUN-2004 Page: 97
TABLE: NTRAUBK
CREATOR: POSNCTL
Electronic Approval Block Usage Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRAUBK_AUFM_CODE VARCHAR2 7 NO FORM CODE: A code identifying the name of the Form.
NTRAUBK_CODE VARCHAR2 30 NO BLOCK CODE: A code identifying the name of the block.
NTRAUBK_DESC VARCHAR2 30 NO DESC: Description of the block.
NTRAUBK_EFFECTIVE_DATED_IND VARCHAR2 1 NO EFFECTIVE DATED INDICATOR: Determines if database
tables are driven by effective dates.
NTRAUBK_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of the action was initiated.
Date: 21-JUN-2004 Page: 98
TABLE: NTRAUFD
CREATOR: POSNCTL
Electronic Approval Field Usage Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRAUFD_AUFM_CODE VARCHAR2 7 NO FORM CODE: A code identifying
the name of the Form.
NTRAUFD_AUBK_CODE VARCHAR2 30 NO BLOCK CODE: A code identifying
the name of the block.
NTRAUFD_CODE VARCHAR2 30 NO FIELD CODE: A code identifying the
name of the field.
NTRAUFD_DESC VARCHAR2 20 NO DESCRIPTION: Description of the
field.
NTRAUFD_FORMAT_IND VARCHAR2 1 NO FORMAT: Format of the field.
NTRAUFD_ENTERABLE_IND VARCHAR2 1 NO ENTERABLE INDICATOR:
An indicator determines which
field is enterable.
NTRAUFD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:
Date of the action was initiated.
Date: 21-JUN-2004 Page: 99
TABLE: NTRAUFM
CREATOR: POSNCTL
Electronic Approval Form Usage Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRAUFM_CODE VARCHAR2 7 NO FORM CODE: A code identifying the name of the Form.
NTRAUFM_DESC VARCHAR2 30 NO DESC: Description of the Form.
NTRAUFM_APPROVALS_IND VARCHAR2 1 NO ELECTRONIC APPROVAL INDICATOR: An indicator determines
which Forms will have the Electronic Approval turned
on at client site.
NTRAUFM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of the action was initiated.
Date: 21-JUN-2004 Page: 100
TABLE: NTRBQUE
CREATOR: POSNCTL
Routing Queue Rules Base Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRBQUE_ACAT_CODE VARCHAR2 6 NO APPROVAL CATEGORY CODE: This code represents the
purpose of personnel action
NTRBQUE_USER_ID VARCHAR2 30 NO USERID: The user id of the person who inserted or
updated the record
NTRBQUE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
NTRBQUE_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Valued only when Banner
Finance is installed.
NTRBQUE_ORGN_CODE VARCHAR2 6 YES Organization Code.
NTRBQUE_POSN VARCHAR2 6 YES POSITION: The position number this job is attached to
Date: 21-JUN-2004 Page: 101
TABLE: NTRBROL
CREATOR: POSNCTL
Budget Roll Parameter Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRBROL_FISC_CODE VARCHAR2 4 NO FISCAL YEAR: The fiscal year to which the budget will
be rolled.
NTRBROL_ECLS_CODE VARCHAR2 2 YES BUDGET ROLL EMPLOYEE CLASS: The employee class for
which the budget roll rule is being defined.
NTRBROL_INC_DEC_IND VARCHAR2 1 YES INCREASE/DECREASE INDICATOR: Indicates whether the
budget being rolled is to be increased or decreased.
NTRBROL_PERCENT NUMBER 6 2 YES BUDGET ROLL PERCENT: Percentage by which the budget
being rolled is to be increased or decreased.
NTRBROL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 102
TABLE: NTRCROL
CREATOR: POSNCTL
Roll Contract Dates Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRCROL_BEGIN_DATE_FROM DATE 7 NO BEGIN DATE FROM : Current Base Job Contract Begin
Date.
NTRCROL_END_DATE_FROM DATE 7 NO END DATE FROM : Current Base Job Contract End Date.
NTRCROL_BEGIN_DATE_TO DATE 7 NO BEGIN DATE TO : Date to which the Base Job Contract
Begin Date is to be rolled.
NTRCROL_END_DATE_TO DATE 7 NO END DATE TO: Date to which the Base Job Contract End
Date is to be rolled.
NTRCROL_ACTIVITY_DATE DATE 7 NO Date of last activity on this record.
Date: 21-JUN-2004 Page: 103
TABLE: NTRFBEX
CREATOR: POSNCTL
Fringe External Funding Source Rate Definition Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRFBEX_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the rate becomes effective for
the FOAPAL defined.
NTRFBEX_COAS_CODE VARCHAR2 1 NO COAS CODE : Chart of Accounts Code
NTRFBEX_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE
NTRFBEX_FUND_CODE VARCHAR2 6 YES FUND CODE : Fund code to match on
NTRFBEX_ORGN_CODE VARCHAR2 6 YES ORGN CODE : organization code to match on
NTRFBEX_ACCT_CODE VARCHAR2 6 YES ACCT CODE : Account code to match on
NTRFBEX_PROG_CODE VARCHAR2 6 YES PROG CODE : Program code to match on
NTRFBEX_ACTV_CODE VARCHAR2 6 YES ACTV CODE : Activity code to match on
NTRFBEX_LOCN_CODE VARCHAR2 6 YES LOCN CODE : Location code to match on
NTRFBEX_RATE NUMBER 6 3 NO RATE: External Funding Source Fringe Rate
NTRFBEX_END_DATE DATE 7 YES END DATE: Date the record ends
NTRFBEX_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification of record.
Date: 21-JUN-2004 Page: 104
TABLE: NTRFBIN
CREATOR: POSNCTL
Fringe Installation Rate and Labor Distribution Override Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRFBIN_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the rate becomes effective
NTRFBIN_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: Employee Class Code for which the
installation fringe rate is being defined.
NTRFBIN_RATE NUMBER 6 3 NO RATE: Installation Fringe Rate
NTRFBIN_COAS_CODE VARCHAR2 1 YES COAS CODE : Chart of Accounts Code
NTRFBIN_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE
NTRFBIN_FUND_CODE VARCHAR2 6 YES FUND CODE OVERRIDE: Installation Fund code override
NTRFBIN_ORGN_CODE VARCHAR2 6 YES ORGN CODE OVERRIDE: Installation organization code
override
NTRFBIN_ACCT_CODE VARCHAR2 6 YES ACCT CODE OVERRIDE: Installation Account code override
NTRFBIN_PROG_CODE VARCHAR2 6 YES PROG CODE OVERRIDE: Installation Program code override
NTRFBIN_ACTV_CODE VARCHAR2 6 YES ACTV CODE OVERRIDE: Installation Activity code
override
NTRFBIN_LOCN_CODE VARCHAR2 6 YES LOCN CODE OVERRIDE: Installation Location code
override
NTRFBIN_END_DATE DATE 7 YES END DATE: Date the record ends
NTRFBIN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification of record.
Date: 21-JUN-2004 Page: 105
TABLE: NTRFELD
CREATOR: POSNCTL
Fringe External Funding Source Labor Distribution Override Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRFELD_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the override labor distribution
becomes effective for the FOAPAL defined.
NTRFELD_COAS_CODE VARCHAR2 1 NO COAS CODE : Chart of Accounts Code
NTRFELD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE
NTRFELD_FUND_CODE VARCHAR2 6 YES FUND CODE : Fund code to match on
NTRFELD_ORGN_CODE VARCHAR2 6 YES ORGN CODE : organization code to match on
NTRFELD_ACCT_CODE VARCHAR2 6 YES ACCT CODE : Account code to match on
NTRFELD_PROG_CODE VARCHAR2 6 YES PROG CODE : Program code to match on
NTRFELD_ACTV_CODE VARCHAR2 6 YES ACTV CODE : Activity code to match on
NTRFELD_LOCN_CODE VARCHAR2 6 YES LOCN CODE : Location code to match on
NTRFELD_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: Employee Class Code for which the
external funding source labor distribution override is
being defined.
NTRFELD_COAS_CODE_OVR VARCHAR2 1 NO COAS CODE (for override foapal) : Chart of Accounts
Code for the override FOAPAL
NTRFELD_ACCI_CODE_OVR VARCHAR2 6 YES ACCOUNT INDEX CODE
NTRFELD_FUND_CODE_OVR VARCHAR2 6 YES FUND CODE OVERRIDE: External Funding Source Fund code
override
NTRFELD_ORGN_CODE_OVR VARCHAR2 6 YES ORGN CODE OVERRIDE: External Funding Source
organization code override
NTRFELD_ACCT_CODE_OVR VARCHAR2 6 YES ACCT CODE OVERRIDE: External Funding Source Account
code override
NTRFELD_PROG_CODE_OVR VARCHAR2 6 YES PROG CODE OVERRIDE: External Funding Source Program
code override
NTRFELD_ACTV_CODE_OVR VARCHAR2 6 YES ACTV CODE OVERRIDE: External Funding Source Activity
code override
NTRFELD_LOCN_CODE_OVR VARCHAR2 6 YES LOCN CODE OVERRIDE: External Funding Source Location
code override
NTRFELD_END_DATE DATE 7 YES END DATE: Date the record ends
NTRFELD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification of record.
Date: 21-JUN-2004 Page: 106
TABLE: NTRFINI
CREATOR: POSNCTL
HR/Finance Set Up Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRFINI_FISC_CODE VARCHAR2 4 NO Fiscal Year Code. Identifies the HR fiscal year.
NTRFINI_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code. This field is valid only when
Banner Finance is installed.
NTRFINI_FSYR_CODE VARCHAR2 2 YES Banner Finance Fiscal Year Code. This field ties the
HR 4 character fiscal year with the Banner Finance 2
character fiscal year.
NTRFINI_BANK_CODE VARCHAR2 2 YES Bank Code. Identifies the bank for use in direct
deposits and checks. If Banner Finance is installed
this field is validated against the FTVBANK table.
NTRFINI_ACTIVITY_DATE DATE 7 NO Activity Date. This is the date of the last insert or
update of the record.
NTRFINI_RUCL_CODE_EXP_SAL VARCHAR2 4 YES Rule Code for Salary expenditures.
NTRFINI_RUCL_CODE_LIAB_EMPLEE VARCHAR2 4 YES Rule Code for Employee Liability transactions.
NTRFINI_RUCL_CODE_NET_PAY VARCHAR2 4 YES Rule Code for Net Pay.
NTRFINI_RUCL_CODE_EXP_BENE VARCHAR2 4 YES Rule Code for Benefit expenditures.
NTRFINI_RUCL_CODE_LIAB_EMPLER VARCHAR2 4 YES Rule code for Employer liability transactions.
NTRFINI_RUCL_CODE_DPAY_HOLD VARCHAR2 4 YES Rule Code for Deferred Pay Accruals.
NTRFINI_RUCL_CODE_DPAY_PAYOUT VARCHAR2 4 YES Rule code for Deferred Pay Payout.
NTRFINI_RUCL_CODE_FRN_CHG_EXP VARCHAR2 4 YES Rule Code for expensing fringe benefit charge back
values.
NTRFINI_RUCL_CODE_FRN_CHG_CLR VARCHAR2 4 YES Rule Code for balancing entry to fringe charge back
expense. Typically posted to Credit side of Fringe
Clearing Account.
NTRFINI_RUCL_CODE_FRN_ACT_EXP VARCHAR2 4 YES Rule Code for encumbering fringe benefit actual
expense. Typically posted to Debit side of Fringe
Clearing Account.
NTRFINI_RUCL_CODE_BUDG_ORIG VARCHAR2 4 YES Rule Code for Original Budgets. This rule code will
control the postings of this type of transaction sent
to finance from the HR system.
NTRFINI_RUCL_CODE_BUDG_ADJ VARCHAR2 4 YES Rule Code for Budget Adjustments. This is the Banner
Finace Rule Code that will control the processing of
budget adjustment transactions sent to finance from
the HR system
NTRFINI_RUCL_CODE_ENCB_SAL_ORG VARCHAR2 4 YES Rule Code for encumbering original salaries.
NTRFINI_RUCL_CODE_ENCB_SAL_ADJ VARCHAR2 4 YES Rule Code for encumbering salary adjustments.
NTRFINI_RUCL_CODE_ENCB_FRN_ORG VARCHAR2 4 YES Rule Code for encumbering original fringe benefits.
NTRFINI_RUCL_CODE_ENCB_FRN_ADJ VARCHAR2 4 YES Rule Code for encumbering fringe benefit adjustments.
NTRFINI_RUCL_CODE_COBRA_CASH VARCHAR2 4 YES Rule Code for COBRA Cash Transactions. This rule code
will control the postings in finance of this type of
transaction sent to finance from the HR system.
NTRFINI_RUCL_CODE_COBRA_PREM VARCHAR2 4 YES Rule Code for COBRA Premiums.
NTRFINI_RUCL_CODE_COBRA_ADMIN VARCHAR2 4 YES Rule Code for COBRA Administrative Costs. This rule
code will control the postings of this type of
transaction sent to finance from the HR system.
Date: 21-JUN-2004 Page: 107
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRFINI_ACCI_CODE_NET VARCHAR2 6 YES Account Index for Net Pay. This field is valid only
when Banner Finance is installed.
NTRFINI_FUND_CODE_NET VARCHAR2 6 YES Fund Code for Net Pay. This field is valid only when
Banner Finance is installed.
NTRFINI_ORGN_CODE_NET VARCHAR2 6 YES Organization Code for Net Pay. This field is valid
only when Banner Finance is installed.
NTRFINI_ACCT_CODE_NET VARCHAR2 6 YES Account code for Net Pay. This field is only valid
when Banner Finance is installed.
NTRFINI_PROG_CODE_NET VARCHAR2 6 YES Program Code for Net Pay. This field is valid only
when Banner Finance is installed.
NTRFINI_ACTV_CODE_NET VARCHAR2 6 YES Activity Code for Net Pay. This field is valid only
when Banner Finance is installed.
NTRFINI_LOCN_CODE_NET VARCHAR2 6 YES Location Code for Net Pay. This field is valid only
when Banner Finance is installed.
NTRFINI_ACCT_CODE_EXTERNAL_NET VARCHAR2 60 YES Account code for Net Pay. This field is valid only
when Banner Finance is NOT installed.
NTRFINI_ACCI_CODE_DEF VARCHAR2 6 YES Account Index for Deferred Pay. This field is valid
only when Banner Finance is installed.
NTRFINI_FUND_CODE_DEF VARCHAR2 6 YES Fund Code for Deferred Pay. This field is valid only
when Banner Finance is installed.
NTRFINI_ORGN_CODE_DEF VARCHAR2 6 YES Organization Code for Deferred Pay. This field is
valid only when Banner Finance is installed.
NTRFINI_ACCT_CODE_DEF VARCHAR2 6 YES Account for Deferred Pay. This field is valid only
when Banner Finance is installed.
NTRFINI_PROG_CODE_DEF VARCHAR2 6 YES Program Code for Deferred Pay. This field is valid
only when Banner Finance is installed.
NTRFINI_ACTV_CODE_DEF VARCHAR2 6 YES Activity Code for Deferred Pay. This field is valid
only when Banner Finance is installed.
NTRFINI_LOCN_CODE_DEF VARCHAR2 6 YES Location Code for Deferred Pay. This field is valid
only when Banner Finance is installed.
NTRFINI_ACCT_CODE_EXTERNAL_DEF VARCHAR2 60 YES Account Code for Deferred Pay. This field is valid
only when Banner Finance is NOT installed.
NTRFINI_ACCI_CODE_FRN VARCHAR2 6 YES Account Index for Fringe Clearing. This field is
valid only when Banner Finance is installed.
NTRFINI_FUND_CODE_FRN VARCHAR2 6 YES Fund Code for Fringe Clearing. This field is valid
only when Banner Finance is installed.
NTRFINI_ORGN_CODE_FRN VARCHAR2 6 YES Organization Code for Fringe Clearing. This field is
valid only when Banner Finance is installed.
NTRFINI_ACCT_CODE_FRN VARCHAR2 6 YES Account for Fringe Clearing. This field is valid only
when Banner Finance is installed.
NTRFINI_PROG_CODE_FRN VARCHAR2 6 YES Program Code for Fringe Clearing. This field is valid
only when Banner Finance is installed.
NTRFINI_ACTV_CODE_FRN VARCHAR2 6 YES Activity Code for Fringe Clearing. This field is
valid only when Banner Finance is installed.
NTRFINI_LOCN_CODE_FRN VARCHAR2 6 YES Location Code for Fringe Clearing. This field is
valid only when Banner Finance is installed.
NTRFINI_ACCT_CODE_EXTERNAL_FRN VARCHAR2 60 YES Account Code for Fringe Clearing. This field is valid
only when Banner Finance is NOT installed.
NTRFINI_UPD_BUD_IND VARCHAR2 1 NO BUDGET INDICATOR: Determines whether budget
transactions are interfaced to the budget development
tables of BANNER FINANCE System.
Date: 21-JUN-2004 Page: 108
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRFINI_M_FBEX_FUND_IND VARCHAR2 1 NO FRINGE EXPENDITURE MATCH FUND INDICATOR: A 'Y' in this
fields indicates that the FUND will be matched in a
charge back.
NTRFINI_M_FBEX_ORGN_IND VARCHAR2 1 NO FRINGE EXPENDITURE MATCH ORGN INDICATOR: A 'Y' in this
fields indicates that the ORGN will be matched in a
charge back.
NTRFINI_M_FBEX_ACCT_IND VARCHAR2 1 NO FRINGE EXPENDITURE MATCH ACCT INDICATOR: A 'Y' in this
fields indicates that the ACCT will be matched in a
charge back.
NTRFINI_M_FBEX_PROG_IND VARCHAR2 1 NO FRINGE EXPENDITURE MATCH PROG INDICATOR: A 'Y' in this
fields indicates that the PROG will be matched in a
charge back.
NTRFINI_M_FBEX_ACTV_IND VARCHAR2 1 NO FRINGE EXPENDITURE MATCH ACTV INDICATOR: A 'Y' in this
fields indicates that the ACTV will be matched in a
charge back.
NTRFINI_M_FBEX_LOCN_IND VARCHAR2 1 NO FRINGE EXPENDITURE MATCH LOCN INDICATOR: A 'Y' in this
fields indicates that the LOCN will be matched in a
charge back.
NTRFINI_FRNG_ENCUMB_IND VARCHAR2 1 NO FRINGE ENCUMBRANCE INDICATOR: Y: Encumber fringe
benefits. N: Do not encumber fringe benefits.
NTRFINI_FRNG_CALC_IND VARCHAR2 1 NO FRINGE CALCULATION INDICATOR: A: (All) Match external
first; if not found, use installation rules. E:
(Exception Only) Only match external. N: (None) No
calculations are done.
NTRFINI_FRNG_RATE_OVR_IND VARCHAR2 1 NO FRINGE RATE OVERRIDE: Y: If the installation fringe
rate is found to be less than the external rate,
override the external rate with the installation rate.
N: Do not override the external rate when
less.
NTRFINI_NTRFBLD_CHANGE_IND VARCHAR2 1 NO RULES CHANGE INDICATOR: A Y in this column will
instruct NBPBUDM to recalculate encumbrances for ALL
jobs the next time it is run.
NTRFINI_RUCL_CODE_EXP_NO_LIQ VARCHAR2 4 YES RULE CODE FOR NON-LIQUIDATED SALARY EXPENSES: Rule
Code for salary expenses that will not be liquidated.
NTRFINI_RUCL_CODE_FRN_NO_LIQ VARCHAR2 4 YES RULE CODE FOR NON-LIQUIDATED FRINGE CHARGEBACK
EXPENSES: Rule Code for fringe chargeback expenses
that will not be liquidated.
Date: 21-JUN-2004 Page: 109
TABLE: NTRFRNG
CREATOR: POSNCTL
Fringe Benefits Budgeting Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRFRNG_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: The Employee Class to which the
budget being defined should be applied.
NTRFRNG_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CODE: A code which identifies the
Benefit/Deduction to whichthe budget will apply.
NTRFRNG_BDPL_CODE VARCHAR2 2 YES BENEFIT/DEDUCTION PLAN CODE: A code which identifies
the Benefit/Deduction to which the budget should
apply.
NTRFRNG_BUDGET_IND VARCHAR2 1 NO BUDGET INDICATOR: Indicates how the budget for this
benefit/deduction should be calculated.
NTRFRNG_PERCENT NUMBER 5 2 YES BUDGET PERCENT: The percent to be applied to the
budget for this deduction code based on the code
entered in the Budget Indicator field.
NTRFRNG_AMT NUMBER 11 2 YES BUDGET AMOUNT: The amount to be applied to the budget
for this deduction code based on the value entered in
the Budget Indicator field.
NTRFRNG_PER_UNFILLED_FTE_AMT NUMBER 11 2 YES UNFILLED FTE BUDGET AMOUNT: The amount to be applied
to the budget for any unfilled positions.
NTRFRNG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 110
TABLE: NTRHROL
CREATOR: POSNCTL
Roll Encumbrance Hours Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRHROL_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: A code which identifies the
Employee Class that is associated with this Position
Class, and will therefore default to the Position Form
(NBAPOSN) when the Position Class is entered.
NTRHROL_ROLL_IND VARCHAR2 1 NO ENCUMBRANCE HOURS ROLL METHOD: Roll method for
C(Current), R(Remaining), Z(Zero).
NTRHROL_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date on which this record becomes
effective.
NTRHROL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 111
TABLE: NTRINST
CREATOR: POSNCTL
Position Control Installation Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRINST_APPROVALS_IND VARCHAR2 1 NO Approvals Indicator: An indi
cator that identifies a
(Y)es or (N)o.
NTRINST_NBRJOBS_FUTURE_CHG_IND VARCHAR2 1 NO Future Change Indi
cator: An indicator that will ask
whether or not NBRJOBS future changes can be m
ade in
between dates.
NTRINST_ACTIVITY_DATE DATE 7 NO Activity Date:
Date the action was initiated
NTRINST_PROXY_SUPERUSER_IND VARCHAR2 1 NO DOES PROXY FOR SUPERUSER ASSUME SUPERUSER ROLE: Values
(Y)es or (N)o.
NTRINST_BUDGET_ERROR_IND VARCHAR2 1 NO BUDGET ERROR INDICATOR: Specifies if the edit on
NBAJOBS Contract Value versus the position budget
should be an (E)rror or (W)arning.
NTRINST_RETAIN_NHRFINC_IND VARCHAR2 1 NO RETAIN NHRDIST RECORDS: Values (Y)es or (N)o.
NTRINST_COAS_CODE VARCHAR2 1 YES Default Chart of Accounts Code to be used in the
Institution.
NTRINST_LOCATION_IND VARCHAR2 1 NO LOCATION INDICATOR: Indicates the location of the
institution. Values (U)nited States or (C)anada.
NTRINST_REJECT_WARNINGS_IND VARCHAR2 1 NO REJECT WARNINGS IND: Specifies if Electronic Approval
transactions with warnings only should be rejected
during the mass apply process (NOPEAMA).
NTRINST_DISPLAY_WARNINGS_IND VARCHAR2 1 NO DISPLAY WARNINGS IND: Specifies if Electronic Approval
transactions with warnings only should be submitted
without review from the NOAEPAF form.
NTRINST_MAX_DOC_SEQ_NUM NUMBER 4 YES MAXIMUM DOCUMENT SEQUENCE NUMBER: Maximum document
sequence number used by nhpfin2 process.
NTRINST_ACAT_CODE_TIME_ENTRY VARCHAR2 6 YES Time Entry Approval Category.
NTRINST_TE_RETURN_TO_EMPL_IND VARCHAR2 1 NO Indicates if time sheet is returned to employee on web
for correction.
NTRINST_EA_ALT_LOGON_IND VARCHAR2 1 YES Electronic Approval Alternate Logon Indicator:
Alternate logon indicator used in Electronic Aproval
process to have the option of alternate login window.
NTRINST_PROBATION_UNIT_IND VARCHAR2 1 NO PROBATION UNIT INDICATOR: Indicate the type of units
to be used for the Probationary Period. Valid values:
(D)ays or (M)onths.
NTRINST_ACAT_CODE_LEAV_REPT VARCHAR2 6 YES The Approval Category that controls the approvals
routing of leave reporting time.
NTRINST_ENCUMBRANCE_RECAST_IND VARCHAR2 1 NO NTRINST ENCUMBRANCE RECAST INDICATOR: Indicates that
encumbrance values will be calculated for any
specified date throughout the fiscal year.
NTRINST_WEB_ALLOW_ALLJOBS_IND VARCHAR2 1 NO WEB ALLOW ALL JOBS IND: Valid Values are Y or N.
NTRINST_FLAT_AMT_PRORATE_TYPE VARCHAR2 1 NO FLAT AMT PRORATE TYPE: Valid Values: (F)te,
(A)ppointment or (N)one.
NTRINST_JOB_INFO_PRORATE_TYPE VARCHAR2 1 NO JOB INFO PRORATE TYPE: Valid Values: (F)te,
(A)ppointment or (N)one.
NTRINST_ACAT_CODE_JOB_SALARY VARCHAR2 6 YES ACAT JOB SALARY: Approval Category for Job Salary.
Date: 21-JUN-2004 Page: 112
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRINST_ACAT_CODE_DEFAULT_HRS VARCHAR2 6 YES ACAT DEFAULT HOURS: Approval Category for Default
Hours.
NTRINST_ACAT_CODE_JOB_LD VARCHAR2 6 YES ACAT JOB LD: Approval Category for Job Labor
Distribution.
NTRINST_ACAT_CODE_JOB_COMBINED VARCHAR2 6 YES ACAT JOB COMBINED: Approval Category for Combined Job.
NTRINST_SP_ORGN_SECURITY_IND VARCHAR2 1 NO SP_ORGN_SECURITY_IND:This is the indicator to switch
on Salary Planner Organization security. Valid Values
are Y or N.
Date: 21-JUN-2004 Page: 113
TABLE: NTRJINC
CREATOR: POSNCTL
Mass Job/Assignment Salary Increase Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRJINC_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: Salary group code associated with
this salary increase rule.
NTRJINC_MM_DD_STEP_INCR VARCHAR2 1 NO MONTH DAY STEP INCREASE: Indicates whether only MM/DD
step increases should be processed.
NTRJINC_PROCESS_STEP_ZERO VARCHAR2 1 NO PROCESS STEP ZERO: Indicates whether employees on step
zero should be processed.
NTRJINC_YEAR NUMBER 4 YES YEAR: Calendar year associated with MM/DD step
increases used to create future change effective date.
NTRJINC_EFFECTIVE_DATE DATE 7 YES EFFECTIVE DATE: Effective date used to create future
change date for employees with no step increase
entries in NBAJOBS.
NTRJINC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
NTRJINC_JINR_CODE VARCHAR2 12 NO RULE SET CODE: Rule Set Code for Mass Job Salary
Increase.
NTRJINC_STEP_INCR_MON_FROM VARCHAR2 2 YES MONTH FROM: Month From Date Range to process future
job salary increases.
NTRJINC_STEP_INCR_DAY_FROM VARCHAR2 2 YES DAY FROM: Day From Date Range to process future job
salary increases.
NTRJINC_STEP_INCR_MON_TO VARCHAR2 2 YES MONTH TO: Month To Date Range to process future job
salary increases.
NTRJINC_STEP_INCR_DAY_TO VARCHAR2 2 YES DAY TO: Day From Date Range to process future job
salary increases.
NTRJINC_PAY_PER_BEGIN_DATE_IND VARCHAR2 1 NO PAY PERIOD BEGIN DATE INDICATOR: Pay Period Begin Date
Indicator which allows the User to run Mass Job Salary
Update Process (NBPMASS) and process the selected
salary changes effective dates as
of the pay period
begin date in which the job MMDD occurs. Values (Y)es
and (N)o.
Date: 21-JUN-2004 Page: 114
TABLE: NTRJINR
CREATOR: POSNCTL
Rule Set Mass Job/Assignment Code Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRJINR_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: Salary group code.
NTRJINR_CODE VARCHAR2 12 NO RULE SET CODE: Rule Set Code for Mass Job Salary
Increase.
NTRJINR_DESC VARCHAR2 30 NO DESCRIPTION: Rule Set Code Description.
NTRJINR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or last
modified.
NTRJINR_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
Date: 21-JUN-2004 Page: 115
TABLE: NTRJOBP
CREATOR: POSNCTL
Job Progression Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRJOBP_JOBP_CODE VARCHAR2 5 NO NTRJOBP_JOBP_CODE: Job Progression code.
NTRJOBP_PCLS_CODE VARCHAR2 5 NO NTRJOBP_PCLS:Position Class code associated with the
Job Progression Code.
NTRJOBP_SEQ_NO NUMBER 3 NO NTRJOBP_SEQ_NO IS: Sequence number of the Position
class code.
NTRJOBP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the NTRJOBP table.
NTRJOBP_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the
record.
Date: 21-JUN-2004 Page: 116
TABLE: NTRJTGR
CREATOR: POSNCTL
Mass Job/Assignment Table Grades Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRJTGR_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: Salary group code associated with
this record.
NTRJTGR_TABLE VARCHAR2 2 NO TABLE: Salary table associated with this record.
NTRJTGR_GRADE VARCHAR2 5 NO GRADE: Salary Grade associated with the Salary Table
to be updated.
NTRJTGR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last insert or update of this
record.
NTRJTGR_JINR_CODE VARCHAR2 12 NO RULE SET CODE: Rule Set Code for Mass Job Salary
Increase.
Date: 21-JUN-2004 Page: 117
TABLE: NTRJTPC
CREATOR: POSNCTL
Mass Job/Assignment Table Position Class Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRJTPC_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: Salary group code.
NTRJTPC_JINR_CODE VARCHAR2 12 NO RULE SET CODE: Rule Set Code for Mass Job Salary
Increase.
NTRJTPC_TABLE VARCHAR2 2 NO SALARY TABLE: Corresponds to salary tables on NTRSALA.
NTRJTPC_PCLS_CODE VARCHAR2 5 NO POSITION CLASS CODE: A code which identifies a
Position Class which can then be assigned to a
Position.
NTRJTPC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NTRJTPC_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
Date: 21-JUN-2004 Page: 118
TABLE: NTRJTRL
CREATOR: POSNCTL
Mass Job/Assignment Salary Table Roll Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRJTRL_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: The salary group which is used to
update the employee jobs records.
NTRJTRL_TABLE VARCHAR2 2 NO TABLE: Salary table associated with this roll rule
record.
NTRJTRL_STEP_INCR NUMBER 3 YES STEP INCREASE: The number of steps to increase the
employee's salary steps.
NTRJTRL_PERCENT NUMBER 6 2 YES PERCENT: Percent to increase the employee's salary if
the employee is on step zero.
NTRJTRL_AMOUNT NUMBER 11 2 YES AMOUNT: Amount to increase the employee's salary when
the employee is on step zero.
NTRJTRL_ROUNDING_IND VARCHAR2 1 YES ROUNDING INDICATOR: Indicates if the salary should be
rounded up, down, or to the nearest amount specified
by the Rounding Amount.
NTRJTRL_ROUNDING_AMOUNT NUMBER 11 2 YES ROUNDING AMOUNT: Amount to round the salary to.
NTRJTRL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last insert or update of this
record.
NTRJTRL_JINR_CODE VARCHAR2 12 NO RULE SET CODE: Rule Set Code for Mass Job Salary
Increase.
NTRJTRL_COMMENTS VARCHAR2 2000 YES COMMENTS: Comments for Mass Job Table Roll Rules.
Date: 21-JUN-2004 Page: 119
TABLE: NTRJTST
CREATOR: POSNCTL
Mass Job/Assignment Table Step Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRJTST_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: Salary group code.
NTRJTST_JINR_CODE VARCHAR2 12 NO RULE SET CODE: Rule Set Code for Mass Job Salary
Increase.
NTRJTST_TABLE VARCHAR2 2 NO SALARY TABLE: Corresponds to salary tables on NTRSALA.
NTRJTST_GRADE VARCHAR2 5 NO SALARY GRADE: The Salary Grade, as defined on the
Salary/Rate Rule Form (NTRSALA), that is associated
with positions in this Position Class and will default
to the Position Form (NBAPOSN) when this Position
Class is entered.
NTRJTST_STEP NUMBER 3 NO SALARY STEP: The Salary Step associated with the
Salary Grade as defined on the SalaryRate Rule Form
(NTRSALA) that will be associated with positions
assigned to this Position Class.
NTRJTST_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: Date when the record was inserted or
last modified.
NTRJTST_USER_ID VARCHAR2 30 YES USER ID: User who inserted the record or last modified
the record.
Date: 21-JUN-2004 Page: 120
TABLE: NTRLVID
CREATOR: POSNCTL
Approval Level Id"s Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRLVID_ALVL_CODE VARCHAR2 6 NO Level Code: A code that identifi
es the approval
level.
NTRLVID_USER_ID VARCHAR2 30 NO User Id: Oracle user Id.
NTRLVID_INACTIVE_IND VARCHAR2 1 NO Inactive Indicator: Identifies
whether a value is
active with either a (Y)es or (N)o.
NTRLVID_ACTIVITY_DATE DATE 7 NO Activity Date:
Date the action was initiated
Date: 21-JUN-2004 Page: 121
TABLE: NTRPCLS
CREATOR: POSNCTL
Position Classification Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRPCLS_CODE VARCHAR2 5 NO POSITION CLASS CODE: A code which identifies a
Position Class which can then be assigned to a
Position.
NTRPCLS_DESC VARCHAR2 30 NO POSITION CLASS DESCRIPTION: The description or title
for the Position Class.
NTRPCLS_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: A code which identifies the
Employee Class that is associated with this Position
Class, and will therefore default to the Position Form
(NBAPOSN) when the Position Class is entered.
NTRPCLS_ESKL_CODE VARCHAR2 2 YES EEO SKILL CODE: The EEO Skill Code as defined by the
U.S. Federal Goverment, for use by institutions of
higher education, for EEO reporting
NTRPCLS_EFUN_CODE VARCHAR2 2 YES EEO FUNCTION CODE: For goverment agencies only. The
EEO Function Code as defined by the U.S. Federal
Goverment, for use with EEO reporting.
NTRPCLS_EXEMPT_IND VARCHAR2 1 NO EXEMPTION INDICATOR: Indicates if employees assigned
to positions in this Position Class will be exempt or
non-exempt.
NTRPCLS_TABLE VARCHAR2 2 NO SALARY TABLE: The Salary Table as defined on the
Salary/Rate Rule Form (NTRSALA) that will be
associated with positions assigned to this Position
Class and will default to the Position Form (NBAPOSN).
NTRPCLS_GRADE VARCHAR2 5 YES SALARY GRADE: The Salary Grade, as defined on the
Salary/Rate Rule Form (NTRSALA), that is associated
with positions in this Position Class and will default
to the Position Form (NBAPOSN) when this Position
Class is entered
NTRPCLS_STEP NUMBER 3 YES SALARY STEP: The Salary Step associated with the
Salary Grade as defined on the Salary/Rate Rule Form
(NTRSALA) that will be associated with positions
assigned to this Position Class.
NTRPCLS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NTRPCLS_SGRP_CODE VARCHAR2 6 NO SGRP_CODE: The salary group code.
NTRPCLS_PGRP_CODE VARCHAR2 4 YES PGRP_CODE: The position group code.
NTRPCLS_CHANGE_DATE_TIME DATE 7 NO CHANGE DATE TIME: Date and Time this record was
changed.
NTRPCLS_CALIF_TYPE VARCHAR2 1 YES CALIFORNIA TYPE:
California Pension position class
type.
NTRPCLS_STRS_FTE NUMBER 6 2 YES STRS FTE:
California STRS FTE hours.
NTRPCLS_PERS_HOURS NUMBER 6 2 YES PERS HOURS:
California PERS Work Schedule hours.
NTRPCLS_STRS_BASE_HRS NUMBER 7 2 YES STRS part-time employee base hours
NTRPCLS_BARG_CODE VARCHAR2 2 YES BARGAINING UNIT CODE: Code associated with this
Position Class.
NTRPCLS_PROBATION_UNITS NUMBER 3 YES PROBATION UNITS: Identifies the number of Probationary
Units.
Date: 21-JUN-2004 Page: 122
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRPCLS_ACCRUE_SENIORITY_IND VARCHAR2 1 NO ACCRUE SENIORITY INDICATOR:This indicator will denote
whether seniority hours are accrued against the
position class code.
Date: 21-JUN-2004 Page: 123
TABLE: NTRPROX
CREATOR: POSNCTL
Proxy Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRPROX_USER_ID VARCHAR2 30 NO Oracle User Id.
NTRPROX_ALVL_CODE VARCHAR2 6 NO Level Code of transaction.
NTRPROX_PROXY_USER_ID VARCHAR2 30 NO Proxy"s Oracle User Id.
NTRPROX_ACTIVITY_DATE DATE 7 NO Activity Date:
Date the action was initiated
Date: 21-JUN-2004 Page: 124
TABLE: NTRROUT
CREATOR: POSNCTL
Transaction Routing Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRROUT_ORIGINATOR_USER_ID VARCHAR2 30 NO Oracle User Id of Origi
nator.
NTRROUT_ACAT_CODE VARCHAR2 6 NO Category Code of transaction.
NTRROUT_RECIPIENT_USER_ID VARCHAR2 30 YES Oracle User Id of Approv
er.
NTRROUT_ALVL_CODE VARCHAR2 6 NO Level Code of transaction.
NTRROUT_ACTION_IND VARCHAR2 1 NO Type of action taken, either (F
)YI, (A)pproval,
app(L)y.
NTRROUT_ACTIVITY_DATE DATE 7 NO Activity Date:
Date the action was initiated
Date: 21-JUN-2004 Page: 125
TABLE: NTRRQUE
CREATOR: POSNCTL
Routing Queue Roles Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRRQUE_ACAT_CODE VARCHAR2 6 NO APPROVAL CATEGORY CODE: This code represents the
purpose of personnel action
NTRRQUE_APPR_SEQ_NO NUMBER 3 NO APPROVER SEQUENCE: Unique Sequence number identifing
the approver
NTRRQUE_ACTION_IND VARCHAR2 1 NO APPROVER ACTION INDICATOR: Indicator to apply approver
action to the database
NTRRQUE_USER_ID VARCHAR2 30 NO USERID: The user id of the person who inserted or
updated the record
NTRRQUE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
NTRRQUE_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
NTRRQUE_ORGN_CODE VARCHAR2 6 YES Organization Code.
NTRRQUE_POSN VARCHAR2 6 YES POSITION: The position number this job is attached to
NTRRQUE_MANDATORY_APPR_IND VARCHAR2 1 YES Indicates that the approver can not be removed from
the approval queue
NTRRQUE_APPR_POSN VARCHAR2 6 YES APPROVER POSITION: The position number this job is
attached to
Date: 21-JUN-2004 Page: 126
TABLE: NTRSALA
CREATOR: POSNCTL
Salary/Rate Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSALA_TABLE VARCHAR2 2 NO SALARY TABLE: The Salary Table being defined.
NTRSALA_GRADE VARCHAR2 5 NO SALARY GRADE: The Salary Grade associated with the
Salary Table being defined.
NTRSALA_STEP NUMBER 3 NO SALARY STEP: The Salary Step associated with the
Salary Table and Grade being defined.
NTRSALA_AMOUNT NUMBER 13 4 NO ANNUAL SALARY/HOURLY RATE AMOUNT: The annual salary or
hourly rate associated with this Table, Grade, and
Step.
NTRSALA_ACTIVITY_DATE DATE 7 NO Activity Date: Date of Last Modification of the
Record;
NTRSALA_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: The Group Code associated with a
set of Salary Tables and Grades.
Date: 21-JUN-2004 Page: 127
TABLE: NTRSALB
CREATOR: POSNCTL
Salary/Rate Base Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSALB_TABLE VARCHAR2 2 NO SALARY TABLE: The Salary Table being defined.
NTRSALB_GRADE VARCHAR2 5 NO SALARY GRADE: The Salary Grade associated with the
Salary Table being defined.
NTRSALB_IND VARCHAR2 1 NO SALARY INDICATOR: Indicates if the Salaries/Rates
being defined are hourly rates or annual salaries.
NTRSALB_LOW NUMBER 13 4 NO LOW SALARY RATE: The high end of the range for the
Salary Table and Grade being defined.
NTRSALB_MIDPOINT NUMBER 13 4 NO MIDPOINT SALARY RATE: The "midpoint", as defined by
the institution, of the salary range being defined.
The midpoint is used in the budget roll process for
position using the "sum of the midpoint" method.
NTRSALB_HIGH NUMBER 13 4 NO HIGH SALARY RATE: The high end of the range for the
Salary Table and Grade being defined.
NTRSALB_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of Last Modification of the
Record;
NTRSALB_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: The Group Code associated with a
set of Salary Tables and Grades.
Date: 21-JUN-2004 Page: 128
TABLE: NTRSGRP
CREATOR: POSNCTL
Salary Group Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSGRP_CODE VARCHAR2 6 NO Salary Group Code: Salary group code.
NTRSGRP_DESC VARCHAR2 30 NO Salary Group Description: Description of the salary
group.
NTRSGRP_TABLE VARCHAR2 2 NO Salary Table: Corresponds to salary tables on NTRSALA.
NTRSGRP_ACTIVE_IND VARCHAR2 1 NO Group Active Indicator; Values (Y)es, Currently
Active; (N)o, Currently Not Active.
NTRSGRP_ACTIVITY_DATE DATE 7 NO Activity Date: Date of Last Modification of the
Record.
Date: 21-JUN-2004 Page: 129
TABLE: NTRSPBU
CREATOR: POSNCTL
Salary Planner Extract Bargaining Unit Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSPBU_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NTRSPBU_BARG_CODE VARCHAR2 2 NO BARG CODE: Bargaining Unit code.
NTRSPBU_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
NTRSPBU_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 130
TABLE: NTRSPEC
CREATOR: POSNCTL
Salary Planner Extract Employee Class Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSPEC_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NTRSPEC_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS: Employee class code.
NTRSPEC_BUDGET_FACTOR NUMBER 5 2 NO BUDGET FACTOR: Proposed Salary Fiscal Year Budget
Factor.
NTRSPEC_JOBS_EFFECTIVE_DATE DATE 7 NO JOBS EFFECTIVE DATE: Proposed Effective date of the
job.
NTRSPEC_JOBS_PERS_CHG_DATE DATE 7 NO JOBS PERSONNEL DATE: Proposed Personnel date of the
job.
NTRSPEC_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NTRSPEC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 131
TABLE: NTRSPEX
CREATOR: POSNCTL
Salary Planner Extract Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NTRSPEX_DESC VARCHAR2 30 NO SALARY PLANNER EXTRACT DESCRIPTION: Salary Planner
Extract code description.
NTRSPEX_FISC_CODE VARCHAR2 4 NO FISCAL YEAR CODE: Fiscal Year associated with the
Salary Planner Extract code.
NTRSPEX_PTOT_STATUS VARCHAR2 1 NO POSITION BUDGET STATUS: Position Budget status
associated with the Position Budget to be extracted.
Valid values are (W)orking or (A)pproved.
NTRSPEX_INCL_SEC_JOB_IND VARCHAR2 1 NO INCLUDE SECONDARY JOBS INDICATOR: Include Secondary
Jobs, values are (Y)es or (N)o.
NTRSPEX_INCL_OVERLOAD_JOB_IND VARCHAR2 1 NO INCLUDE OVERLOAD JOBS INDICATOR: Include Overloaded
Jobs, values are (Y)es or (N)o.
NTRSPEX_INCL_NO_BARG_IND VARCHAR2 1 NO INCLUDE NULL BARGAINING UNITS INDICATOR: Include
Positions with no Bargaining Unit, values are (Y)es or
(N)o.
NTRSPEX_INCL_NO_BPRO_IND VARCHAR2 1 NO INCL NULL BUDGET PROFILE INDICATOR: Include Positions
with no Budget Profile, values are (Y)es or (N)o.
NTRSPEX_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NTRSPEX_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
NTRSPEX_COAS_CODE VARCHAR2 1 YES COAS CODE: Chart of Accounts code.
NTRSPEX_OBUD_CODE VARCHAR2 6 YES BUDGET ID CODE: Budget ID associated with the Position
Budget record to be extracted.
NTRSPEX_OBPH_CODE VARCHAR2 6 YES BUDGET PHASE CODE: Budget Phase associated with the
Position Budget record to be extracted.
Date: 21-JUN-2004 Page: 132
TABLE: NTRSPPR
CREATOR: POSNCTL
Salary Planner Extract Budget Profile Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSPPR_SPEX_CODE VARCHAR2 12 NO SALARY PLANNER EXTRACT CODE: The Extract ID associated
with this record.
NTRSPPR_BPRO_CODE VARCHAR2 6 NO BUDGET PROFILE CODE: Budget profile code associated
with the Position records to be extracted.
NTRSPPR_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NTRSPPR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 133
TABLE: NTRSTGR
CREATOR: POSNCTL
Mass Salary Table Grades Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSTGR_SGRP_CODE VARCHAR2 6 NO SALARY GROUP CODE: Salary group code associated with
this salary roll rule.
NTRSTGR_TABLE VARCHAR2 2 NO TABLE: Salary table associated with this salary roll
rule.
NTRSTGR_GRADE VARCHAR2 5 NO GRADE: Salary grade associated with the salary table
to be updated.
NTRSTGR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when this record was inserted ot
last updated.
Date: 21-JUN-2004 Page: 134
TABLE: NTRSTRL
CREATOR: POSNCTL
Mass Salary Table Roll Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRSTRL_SGRP_CODE_FROM VARCHAR2 6 NO SALARY GROUP CODE FROM: Salary group code to roll
from.
NTRSTRL_SGRP_CODE_TO VARCHAR2 6 NO SALARY GROUP CODE TO: Salary group code to roll to.
NTRSTRL_TABLE VARCHAR2 2 NO TABLE: Salary table to be rolled.
NTRSTRL_PERCENT NUMBER 6 2 YES PERCENT: Percent to increase salary table amounts.
NTRSTRL_AMOUNT NUMBER 11 2 YES AMOUNT: Amount to increase salary table amounts.
NTRSTRL_ROUNDING_IND VARCHAR2 1 YES ROUNDING INDICATOR: Indicates if the salaries should
be rounded up, down, or to the nearest amount
specified by the Rounding Amount.
NTRSTRL_ROUNDING_AMOUNT NUMBER 11 2 YES ROUNDING AMOUNT: Amount which to round salaries to.
NTRSTRL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date which this record was last updated
or inserted.
Date: 21-JUN-2004 Page: 135
TABLE: NTRTPRX
CREATOR: POSNCTL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRTPRX_USER_ID VARCHAR2 30 NO USERID: The user id of the person
who inserted or
updated the record
NTRTPRX_PROXY_USER_ID VARCHAR2 30 NO PROXY: The user id of the
person who is been set as
proxy
NTRTPRX_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the
record was inserted or
updated.
Date: 21-JUN-2004 Page: 136
TABLE: NTRWKSH
CREATOR: POSNCTL
Work Schedule Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTRWKSH_CODE VARCHAR2 4 NO CODE: Code associated with this work schedule.
NTRWKSH_DAY NUMBER 3 NO DAY: Day number within this work schedule.
NTRWKSH_SHIFT VARCHAR2 1 YES SHIFT: Shift number for a particular day within the
schedule.
NTRWKSH_HOURS NUMBER 4 2 NO HOURS: Number of hours scheduled to work on that day.
NTRWKSH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 137
TABLE: NTVACAT
CREATOR: POSNCTL
Approval Category Code Validation Form
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTVACAT_CODE VARCHAR2 6 NO CODE: Approval Category Code
NTVACAT_DESC VARCHAR2 30 NO Description of Category
NTVACAT_ACTIVITY_DATE DATE 7 NO Activity Date: Date the action was initiated
Date: 21-JUN-2004 Page: 138
TABLE: NTVAPTY
CREATOR: POSNCTL
Approval Type Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTVAPTY_CODE VARCHAR2 6 NO CODE: Approval Type Code
NTVAPTY_DESC VARCHAR2 30 NO Description of Type Code
NTVAPTY_ACTIVITY_DATE DATE 7 NO Activity Date: Date the action was initiated
Date: 21-JUN-2004 Page: 139
TABLE: NTVBPRO
CREATOR: POSNCTL
Budget Profile Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTVBPRO_CODE VARCHAR2 6 NO BUDGET PROFILE CODE: Budget profile code.
NTVBPRO_DESC VARCHAR2 30 NO BUDGET PROFILE DESCRIPTION: Description for the Budget
Profile code.
NTVBPRO_USER_ID VARCHAR2 30 NO USER ID: User who inserted the record or last modified
the record.
NTVBPRO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 140
TABLE: NTVDOTT
CREATOR: POSNCTL
Dictionary of Occupational Titles Code (DOTT) Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTVDOTT_CODE VARCHAR2 11 NO Dictionary of Occupational Titles Code (DOTT).
NTVDOTT_DESC VARCHAR2 60 NO Description of Dictionary of Occupational Titles Code
(DOTT).
NTVDOTT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity for this record.
Date: 21-JUN-2004 Page: 141
TABLE: NTVJOBP
CREATOR: POSNCTL
Job Progression Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTVJOBP_CODE VARCHAR2 5 NO NTVJOBP_CODE: Code belongs to the Job Progression
family, which has like type positions ranked in
sequence order.
NTVJOBP_DESC VARCHAR2 30 NO NTVJOBP_DESC: Job Progression Code description
NTVJOBP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the NTVJOBP table.
NTVJOBP_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the
record.
Date: 21-JUN-2004 Page: 142
TABLE: NTVPFOC
CREATOR: POSNCTL
Federal Occupational Code (FOC) Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTVPFOC_CODE VARCHAR2 3 NO Federal Occupational Code (FOC).
NTVPFOC_DESC VARCHAR2 60 NO Description of Federal Occupational Code (FOC).
NTVPFOC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity for this record.
Date: 21-JUN-2004 Page: 143
TABLE: NTVPNOC
CREATOR: POSNCTL
National Occupational Code (NOC) Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTVPNOC_CODE VARCHAR2 6 NO National Occupational Code (SOC).
NTVPNOC_DESC VARCHAR2 60 NO Description of National Occupational Code (SOC).
NTVPNOC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity for this record.
Date: 21-JUN-2004 Page: 144
TABLE: NTVWKSH
CREATOR: POSNCTL
Work Schedule Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NTVWKSH_CODE VARCHAR2 4 NO CODE: Code associated with this work schedule.
NTVWKSH_DESC VARCHAR2 30 NO DESCRIPTION: Description of the work schedule.
NTVWKSH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 145
TABLE: NURVERS
CREATOR: POSNCTL
Position Control Version Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
NURVERS_RELEASE VARCHAR2 10 NO RELEASE NUMBER: Current Release Number of the BANNER
HR product.
NURVERS_STAGE_DATE DATE 7 NO STAGE DATE: Release Date of BANNER HR.