Model Time Entry

Model Label : Banner HR Time Entry Module
Path : BANNER DEV/HR/Time Entry

List of Objects

Object Name	Object Type	Layer Name
NBRBJOB	TABLE	Default
NBRJLBD	TABLE	Default
NBRJOBS	TABLE	Default
PERDAYH	TABLE	Default
PERDAYS	TABLE	Default
PEREARH	TABLE	Default
PEREARN	TABLE	Default
PERELBD	TABLE	Default
PERELBH	TABLE	Default
PERHOUH	TABLE	Default
PERHOUR	TABLE	Default
PERJOBH	TABLE	Default
PERJOBS	TABLE	Default
PERLVTK	TABLE	Default
PERROUH	TABLE	Default
PERROUT	TABLE	Default
PERTETH	TABLE	Default
PERTITH	TABLE	Default
PERTITO	TABLE	Default
PTRCALN	TABLE	Default
PTRLVAS	TABLE	Default
PTVLCAT	TABLE	Default
SPRIDEN	TABLE	Default

Comments

Model View

Table NBRBJOB

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

Table Columns informations

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
NBRBJOB_POSN	NBBPOSN_POSN	NBBPOSN
NBRBJOB_PIDM	PERJLEV_PIDM	PERJLEV
NBRBJOB_POSN	PERJLEV_POSN	PERJLEV
NBRBJOB_SUFF	PERJLEV_SUFF	PERJLEV
NBRBJOB_PIDM	PEBEMPL_PIDM	PEBEMPL
NBRBJOB_SUFF	NBRJOBS_SUFF	NBRJOBS
NBRBJOB_POSN	NBRJOBS_POSN	NBRJOBS
NBRBJOB_PIDM	NBRJOBS_PIDM	NBRJOBS
NBRBJOB_END_DATE	NBRJOBS_EFFECTIVE_DATE	NBRJOBS

Index

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

Comments

Source Code Comments

Assignment Repeating Base Table

Columns Comments for NBRBJOB_PIDM (1)

Source Code Comments

Internal ID number.

Columns Comments for NBRBJOB_POSN (2)

Source Code Comments

POSITION: The position number this job is attached to.

Columns Comments for NBRBJOB_SUFF (3)

Source Code Comments

SUFFIX: Job suffix.

Columns Comments for NBRBJOB_BEGIN_DATE (4)

Source Code Comments

BEGIN DATE: Begin date of the job.

Columns Comments for NBRBJOB_END_DATE (5)

Source Code Comments

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

Columns Comments for NBRBJOB_DEFER_BAL (6)

Source Code Comments

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

Columns Comments for NBRBJOB_CONTRACT_TYPE (7)

Source Code Comments

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

Columns Comments for NBRBJOB_SALARY_ENCUMBRANCE (8)

Source Code Comments

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

Columns Comments for NBRBJOB_CONTRACT_BEGIN_DATE (9)

Source Code Comments

CONTRACT START DATE: Start date of the contract.

Columns Comments for NBRBJOB_CONTRACT_END_DATE (10)

Source Code Comments

CONTRACT END DATE: End date of the contract.

Columns Comments for NBRBJOB_TOTAL_CONTRACT_HRS (11)

Source Code Comments

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

Columns Comments for NBRBJOB_TOTAL_ENCUMBRANCE_HRS (12)

Source Code Comments

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

Columns Comments for NBRBJOB_STEP_INCR_MON (13)

Source Code Comments

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

Columns Comments for NBRBJOB_STEP_INCR_DAY (14)

Source Code Comments

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

Columns Comments for NBRBJOB_COAS_CODE (15)

Source Code Comments

CHART OF ACCOUNTS CODE: Valued only when Banner Finance is installed.

Columns Comments for NBRBJOB_ACTIVITY_DATE (16)

Source Code Comments

Date of last activity for this record.

Columns Comments for NBRBJOB_ACCRUE_LEAVE_IND (17)

Source Code Comments

ACCRUE LEAVE INDICATOR: Determines whether Leave is accured for this job.

Columns Comments for NBRBJOB_CIVIL_SERVICE_IND (18)

Source Code Comments

CIVIL SERVICE INDICATOR: Indicates if this assignment is a civil service job.

Columns Comments for NBRBJOB_ENCUMBRANCE_CHANGE_IND (19)

Source Code Comments

ENCUMBRANCE CHANGE INDICATOR: Indicates if the encumbrance amount has changed for this job.

Columns Comments for NBRBJOB_FRINGE_ENCUMBRANCE (20)

Source Code Comments

FRINGE ENCUMBRANCE: The cost of fringe benefits that this person will be paid in this job during the current fiscal year.

Columns Comments for NBRBJOB_IPEDS_REPT_IND (21)

Source Code Comments

IPEDS Report Indicator.

Columns Comments for NBRBJOB_FACL_STATSCAN_REPT_IND (22)

Source Code Comments

Faculty Statistical Canadian Report Indicator.

Columns Comments for NBRBJOB_PROBATION_BEGIN_DATE (23)

Source Code Comments

BEGIN DATE: The begin date of Probationary Period.

Columns Comments for NBRBJOB_PROBATION_END_DATE (24)

Source Code Comments

END DATE: The end date of Probationary Period.

Columns Comments for NBRBJOB_PROBATION_UNITS (25)

Source Code Comments

PROBATION UNITS: Identifies the number of Probationary Units.

Columns Comments for NBRBJOB_ELIGIBLE_DATE (26)

Source Code Comments

ELIGIBLE DATE: Eligible Date for the Increase MM DD.

Table NBRJLBD

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

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
NBRJLBD_PIDM	NBRJLBD_PIDM	NUMBER(8,0)	No	*
NBRJLBD_POSN	NBRJLBD_POSN	VARCHAR2(6)	No	*
NBRJLBD_SUFF	NBRJLBD_SUFF	VARCHAR2(2)	No	*
NBRJLBD_EFFECTIVE_DATE	NBRJLBD_EFFECTIVE_DATE	DATE	No
NBRJLBD_COAS_CODE	NBRJLBD_COAS_CODE	VARCHAR2(1)	Yes
NBRJLBD_ACCI_CODE	NBRJLBD_ACCI_CODE	VARCHAR2(6)	Yes
NBRJLBD_FUND_CODE	NBRJLBD_FUND_CODE	VARCHAR2(6)	Yes
NBRJLBD_ORGN_CODE	NBRJLBD_ORGN_CODE	VARCHAR2(6)	Yes
NBRJLBD_ACCT_CODE	NBRJLBD_ACCT_CODE	VARCHAR2(6)	Yes
NBRJLBD_PROG_CODE	NBRJLBD_PROG_CODE	VARCHAR2(6)	Yes
NBRJLBD_ACTV_CODE	NBRJLBD_ACTV_CODE	VARCHAR2(6)	Yes
NBRJLBD_LOCN_CODE	NBRJLBD_LOCN_CODE	VARCHAR2(6)	Yes
NBRJLBD_PROJ_CODE	NBRJLBD_PROJ_CODE	VARCHAR2(8)	Yes
NBRJLBD_CTYP_CODE	NBRJLBD_CTYP_CODE	VARCHAR2(2)	Yes
NBRJLBD_ACCT_CODE_EXTERNAL	NBRJLBD_ACCT_CODE_EXTERNAL	VARCHAR2(60)	Yes
NBRJLBD_PERCENT	NBRJLBD_PERCENT	NUMBER(5,2)	No
NBRJLBD_ENCD_NUM	NBRJLBD_ENCD_NUM	VARCHAR2(8)	Yes
NBRJLBD_ENCD_SEQ_NUM	NBRJLBD_ENCD_SEQ_NUM	NUMBER(4,0)	Yes
NBRJLBD_SALARY_ENCUMBRANCE	NBRJLBD_SALARY_ENCUMBRANCE	NUMBER(11,2)	Yes
NBRJLBD_SALARY_ENC_TO_POST	NBRJLBD_SALARY_ENC_TO_POST	NUMBER(11,2)	No
NBRJLBD_FRINGE_ENCUMBRANCE	NBRJLBD_FRINGE_ENCUMBRANCE	NUMBER(11,2)	Yes
NBRJLBD_FRINGE_ENC_TO_POST	NBRJLBD_FRINGE_ENC_TO_POST	NUMBER(11,2)	No
NBRJLBD_FUND_CODE_FRINGE	NBRJLBD_FUND_CODE_FRINGE	VARCHAR2(6)	Yes
NBRJLBD_ORGN_CODE_FRINGE	NBRJLBD_ORGN_CODE_FRINGE	VARCHAR2(6)	Yes
NBRJLBD_ACCT_CODE_FRINGE	NBRJLBD_ACCT_CODE_FRINGE	VARCHAR2(6)	Yes
NBRJLBD_PROG_CODE_FRINGE	NBRJLBD_PROG_CODE_FRINGE	VARCHAR2(6)	Yes
NBRJLBD_ACTV_CODE_FRINGE	NBRJLBD_ACTV_CODE_FRINGE	VARCHAR2(6)	Yes
NBRJLBD_LOCN_CODE_FRINGE	NBRJLBD_LOCN_CODE_FRINGE	VARCHAR2(6)	Yes
NBRJLBD_CHANGE_IND	NBRJLBD_CHANGE_IND	VARCHAR2(1)	No
NBRJLBD_ACTIVITY_DATE	NBRJLBD_ACTIVITY_DATE	DATE	No
NBRJLBD_FRINGE_RESIDUAL	NBRJLBD_FRINGE_RESIDUAL	NUMBER(11,2)	Yes
NBRJLBD_FRINGE_RES_TO_POST	NBRJLBD_FRINGE_RES_TO_POST	NUMBER(11,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
NBRJLBD_SUFF	PERJOBS_SUFF	PERJOBS
NBRJLBD_POSN	PERJOBS_POSN	PERJOBS
NBRJLBD_PIDM	PERJOBS_PIDM	PERJOBS

Index

Index Name	Index Type	Column Name
NBRJLBD_KEY2_INDEX		NBRJLBD_FUND_CODE
NBRJLBD_KEY2_INDEX		NBRJLBD_ORGN_CODE
NBRJLBD_KEY2_INDEX		NBRJLBD_ACCT_CODE
NBRJLBD_KEY2_INDEX		NBRJLBD_PROG_CODE
NBRJLBD_KEY2_INDEX		NBRJLBD_ACTV_CODE
NBRJLBD_KEY2_INDEX		NBRJLBD_LOCN_CODE
NBRJLBD_KEY3_INDEX		NBRJLBD_SALARY_ENC_TO_POST
NBRJLBD_KEY_INDEX		NBRJLBD_PIDM
NBRJLBD_KEY_INDEX		NBRJLBD_POSN
NBRJLBD_KEY_INDEX		NBRJLBD_SUFF
NBRJLBD_KEY_INDEX		NBRJLBD_EFFECTIVE_DATE

Comments

Source Code Comments

Assignment Labor Dist. Repeating Table

Columns Comments for NBRJLBD_PIDM (1)

Source Code Comments

Internal ID number.

Columns Comments for NBRJLBD_POSN (2)

Source Code Comments

Position.

Columns Comments for NBRJLBD_SUFF (3)

Source Code Comments

Suffix.

Columns Comments for NBRJLBD_EFFECTIVE_DATE (4)

Source Code Comments

Date that this record becomes effective.

Columns Comments for NBRJLBD_COAS_CODE (5)

Source Code Comments

Chart of Accounts code. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_ACCI_CODE (6)

Source Code Comments

Account Index. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_FUND_CODE (7)

Source Code Comments

Fund. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_ORGN_CODE (8)

Source Code Comments

Organization. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_ACCT_CODE (9)

Source Code Comments

Account. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_PROG_CODE (10)

Source Code Comments

Program. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_ACTV_CODE (11)

Source Code Comments

Activity. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_LOCN_CODE (12)

Source Code Comments

Location. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_PROJ_CODE (13)

Source Code Comments

PROJECT CODE: Project within Finance Cost Accounting Module.

Columns Comments for NBRJLBD_CTYP_CODE (14)

Source Code Comments

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

Columns Comments for NBRJLBD_ACCT_CODE_EXTERNAL (15)

Source Code Comments

Free form account code to allow update of an accounting system other than Banner Finance.

Columns Comments for NBRJLBD_PERCENT (16)

Source Code Comments

Percent of pay to be applied to this labor distribution.

Columns Comments for NBRJLBD_ENCD_NUM (17)

Source Code Comments

ENCUMBRANCE NUMBER: The Encumbrance number used for interface with Banner Finance

Columns Comments for NBRJLBD_ENCD_SEQ_NUM (18)

Source Code Comments

ENCUMBRANCE SEQUENCE NUMBER: The Encumbrance sequence number used for interface with Banner Finance

Columns Comments for NBRJLBD_SALARY_ENCUMBRANCE (19)

Source Code Comments

SALARY ENCUMBRANCE: Amount encumbered to this labor distribution for the active fiscal year.

Columns Comments for NBRJLBD_SALARY_ENC_TO_POST (20)

Source Code Comments

SALARY ENCUMBRANCE TO POST: Amount of encumbrance that will be posted to the finance system.

Columns Comments for NBRJLBD_FRINGE_ENCUMBRANCE (21)

Source Code Comments

FRINGE ENCUMBRANCE: Amount of fringe benefits encumbered to this labor distribution for the active fiscal year.

Columns Comments for NBRJLBD_FRINGE_ENC_TO_POST (22)

Source Code Comments

FRINGE ENCUMBRANCE TO POST: Amount of encumbrance that will be posted to the finance system.

Columns Comments for NBRJLBD_FUND_CODE_FRINGE (23)

Source Code Comments

Fringe Fund. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_ORGN_CODE_FRINGE (24)

Source Code Comments

Fringe Organization. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_ACCT_CODE_FRINGE (25)

Source Code Comments

Fringe Account. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_PROG_CODE_FRINGE (26)

Source Code Comments

Fringe Program. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_ACTV_CODE_FRINGE (27)

Source Code Comments

Fringe Activity. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_LOCN_CODE_FRINGE (28)

Source Code Comments

Fringe Location. Valued only if Banner Finance is installed.

Columns Comments for NBRJLBD_CHANGE_IND (29)

Source Code Comments

CHANGE INDICATOR: Specifies if the record is active or to be deleted.

Columns Comments for NBRJLBD_ACTIVITY_DATE (30)

Source Code Comments

Date of last activity on this record.

Columns Comments for NBRJLBD_FRINGE_RESIDUAL (31)

Source Code Comments

FRINGE ENCUMBRANCE RESIDUAL AMOUNT: Fringe encumbrance residual amount assigned to this externally funded labor distribution.

Columns Comments for NBRJLBD_FRINGE_RES_TO_POST (32)

Source Code Comments

FRINGE ENCUMBRANCE RESIDUAL TO POST : Amount of fringe encumbrance residual to post to this externally funded labor distribution.

Table NBRJOBS

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 07/30/2003 15:18:29:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
NBRJOBS_PIDM	NBRJOBS_PIDM	NUMBER(8,0)	No	*	*
NBRJOBS_POSN	NBRJOBS_POSN	VARCHAR2(6)	No	*	*
NBRJOBS_SUFF	NBRJOBS_SUFF	VARCHAR2(2)	No	*	*
NBRJOBS_EFFECTIVE_DATE	NBRJOBS_EFFECTIVE_DATE	DATE	No	*
NBRJOBS_STATUS	NBRJOBS_STATUS	VARCHAR2(1)	No
NBRJOBS_DESC	NBRJOBS_DESC	VARCHAR2(30)	Yes
NBRJOBS_ECLS_CODE	NBRJOBS_ECLS_CODE	VARCHAR2(2)	No
NBRJOBS_PICT_CODE	NBRJOBS_PICT_CODE	VARCHAR2(2)	No
NBRJOBS_COAS_CODE_TS	NBRJOBS_COAS_CODE_TS	VARCHAR2(1)	Yes
NBRJOBS_ORGN_CODE_TS	NBRJOBS_ORGN_CODE_TS	VARCHAR2(6)	No		*
NBRJOBS_SAL_TABLE	NBRJOBS_SAL_TABLE	VARCHAR2(2)	Yes		*
NBRJOBS_SAL_GRADE	NBRJOBS_SAL_GRADE	VARCHAR2(5)	Yes		*
NBRJOBS_SAL_STEP	NBRJOBS_SAL_STEP	NUMBER(3,0)	Yes
NBRJOBS_APPT_PCT	NBRJOBS_APPT_PCT	NUMBER(5,2)	No
NBRJOBS_FTE	NBRJOBS_FTE	NUMBER(6,3)	Yes
NBRJOBS_HRS_DAY	NBRJOBS_HRS_DAY	NUMBER(6,2)	No
NBRJOBS_HRS_PAY	NBRJOBS_HRS_PAY	NUMBER(6,2)	No
NBRJOBS_SHIFT	NBRJOBS_SHIFT	VARCHAR2(1)	No
NBRJOBS_REG_RATE	NBRJOBS_REG_RATE	NUMBER(11,6)	Yes
NBRJOBS_ASSGN_SALARY	NBRJOBS_ASSGN_SALARY	NUMBER(11,2)	No
NBRJOBS_FACTOR	NBRJOBS_FACTOR	NUMBER(3,1)	No
NBRJOBS_ANN_SALARY	NBRJOBS_ANN_SALARY	NUMBER(11,2)	No
NBRJOBS_PER_PAY_SALARY	NBRJOBS_PER_PAY_SALARY	NUMBER(11,2)	No
NBRJOBS_PAYS	NBRJOBS_PAYS	NUMBER(3,1)	No
NBRJOBS_PER_PAY_DEFER_AMT	NBRJOBS_PER_PAY_DEFER_AMT	NUMBER(11,2)	No
NBRJOBS_ACTIVITY_DATE	NBRJOBS_ACTIVITY_DATE	DATE	No
NBRJOBS_JCRE_CODE	NBRJOBS_JCRE_CODE	VARCHAR2(5)	Yes
NBRJOBS_SGRP_CODE	NBRJOBS_SGRP_CODE	VARCHAR2(6)	No		*
NBRJOBS_EMPR_CODE	NBRJOBS_EMPR_CODE	VARCHAR2(4)	Yes
NBRJOBS_LGCD_CODE	NBRJOBS_LGCD_CODE	VARCHAR2(4)	Yes
NBRJOBS_LOCN_CODE	NBRJOBS_LOCN_CODE	VARCHAR2(6)	Yes
NBRJOBS_SCHL_CODE	NBRJOBS_SCHL_CODE	VARCHAR2(6)	Yes
NBRJOBS_SUPERVISOR_PIDM	NBRJOBS_SUPERVISOR_PIDM	NUMBER(8,0)	Yes
NBRJOBS_SUPERVISOR_POSN	NBRJOBS_SUPERVISOR_POSN	VARCHAR2(6)	Yes
NBRJOBS_SUPERVISOR_SUFF	NBRJOBS_SUPERVISOR_SUFF	VARCHAR2(2)	Yes
NBRJOBS_WKCP_CODE	NBRJOBS_WKCP_CODE	VARCHAR2(4)	Yes
NBRJOBS_JBLN_CODE	NBRJOBS_JBLN_CODE	VARCHAR2(6)	Yes
NBRJOBS_PERS_CHG_DATE	NBRJOBS_PERS_CHG_DATE	DATE	No
NBRJOBS_PCAT_CODE	NBRJOBS_PCAT_CODE	VARCHAR2(4)	Yes
NBRJOBS_DFPR_CODE	NBRJOBS_DFPR_CODE	VARCHAR2(4)	Yes
NBRJOBS_ENCUMBRANCE_HRS	NBRJOBS_ENCUMBRANCE_HRS	NUMBER(6,2)	Yes
NBRJOBS_CONTRACT_NO	NBRJOBS_CONTRACT_NO	VARCHAR2(8)	Yes
NBRJOBS_STRS_ASSN_CODE	NBRJOBS_STRS_ASSN_CODE	VARCHAR2(2)	Yes
NBRJOBS_STRS_PAY_CODE	NBRJOBS_STRS_PAY_CODE	VARCHAR2(2)	Yes
NBRJOBS_PERS_PAY_CODE	NBRJOBS_PERS_PAY_CODE	VARCHAR2(2)	Yes
NBRJOBS_TIME_ENTRY_METHOD	NBRJOBS_TIME_ENTRY_METHOD	VARCHAR2(1)	No
NBRJOBS_TIME_ENTRY_TYPE	NBRJOBS_TIME_ENTRY_TYPE	VARCHAR2(1)	No
NBRJOBS_TIME_IN_OUT_IND	NBRJOBS_TIME_IN_OUT_IND	VARCHAR2(1)	No
NBRJOBS_LCAT_CODE	NBRJOBS_LCAT_CODE	VARCHAR2(2)	Yes
NBRJOBS_LEAV_REPT_METHOD	NBRJOBS_LEAV_REPT_METHOD	VARCHAR2(1)	No
NBRJOBS_PICT_CODE_LEAV_REPT	NBRJOBS_PICT_CODE_LEAV_REPT	VARCHAR2(2)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
NBRJOBS_SGRP_CODE	NTRSALB_SGRP_CODE	NTRSALB
NBRJOBS_SAL_TABLE	NTRSALB_TABLE	NTRSALB
NBRJOBS_SAL_GRADE	NTRSALB_GRADE	NTRSALB
NBRJOBS_ORGN_CODE_TS	POTPARM_ORGN_CODE_TS	POTPARM
NBRJOBS_SUFF	PERJLEV_SUFF	PERJLEV
NBRJOBS_POSN	PERJLEV_POSN	PERJLEV
NBRJOBS_PIDM	PERJLEV_PIDM	PERJLEV

Index

Index Name	Index Type	Column Name
NBRJOBS_KEY2_INDEX		NBRJOBS_POSN
NBRJOBS_KEY2_INDEX		NBRJOBS_SUFF
NBRJOBS_KEY2_INDEX		NBRJOBS_PIDM
NBRJOBS_KEY2_INDEX		NBRJOBS_EFFECTIVE_DATE
NBRJOBS_KEY3_INDEX		NBRJOBS_PICT_CODE
NBRJOBS_KEY3_INDEX		NBRJOBS_PIDM
NBRJOBS_KEY3_INDEX		NBRJOBS_POSN
NBRJOBS_KEY3_INDEX		NBRJOBS_SUFF
NBRJOBS_KEY3_INDEX		NBRJOBS_EFFECTIVE_DATE
NBRJOBS_KEY4_INDEX		NBRJOBS_EMPR_CODE
NBRJOBS_KEY4_INDEX		NBRJOBS_POSN
NBRJOBS_KEY4_INDEX		NBRJOBS_ECLS_CODE
NBRJOBS_KEY5_INDEX		NBRJOBS_ORGN_CODE_TS
NBRJOBS_KEY5_INDEX		NBRJOBS_COAS_CODE_TS
NBRJOBS_KEY5_INDEX		NBRJOBS_PICT_CODE
NBRJOBS_KEY5_INDEX		NBRJOBS_PIDM
NBRJOBS_KEY6_INDEX		NBRJOBS_PICT_CODE_LEAV_REPT
NBRJOBS_KEY6_INDEX		NBRJOBS_PIDM
NBRJOBS_KEY6_INDEX		NBRJOBS_EFFECTIVE_DATE
PK_NBRJOBS	Unique	NBRJOBS_PIDM
PK_NBRJOBS	Unique	NBRJOBS_POSN
PK_NBRJOBS	Unique	NBRJOBS_SUFF
PK_NBRJOBS	Unique	NBRJOBS_EFFECTIVE_DATE

Comments

Source Code Comments

Assignment Repeating Table

Columns Comments for NBRJOBS_PIDM (1)

Source Code Comments

Internal ID Number

Columns Comments for NBRJOBS_POSN (2)

Source Code Comments

POSITION: The Position to which this job is attached.

Columns Comments for NBRJOBS_SUFF (3)

Source Code Comments

SUFFIX: The Suffix attached to the job.

Columns Comments for NBRJOBS_EFFECTIVE_DATE (4)

Source Code Comments

EFFECTIVE DATE: The Date that the Jobs record becomes effective.

Columns Comments for NBRJOBS_STATUS (5)

Source Code Comments

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.

Columns Comments for NBRJOBS_DESC (6)

Source Code Comments

JOB DESCRIPTION: Description of the job. Defaults from the Position Title if left blank.

Columns Comments for NBRJOBS_ECLS_CODE (7)

Source Code Comments

EMPLOYEE CLASS CODE: The employee grouping that this Job belongs to, based on the Employee Class entered on the Position Form (NBAPOSN).

Columns Comments for NBRJOBS_PICT_CODE (8)

Source Code Comments

PAY ID CODE: The pay id to which this job belongs.

Columns Comments for NBRJOBS_COAS_CODE_TS (9)

Source Code Comments

TIME SHEET CHART OF ACCOUNTS CODE: Used only if Banner Finance is installed.

Columns Comments for NBRJOBS_ORGN_CODE_TS (10)

Source Code Comments

TIME SHEET ORGANIZATION: The organization to which the time sheet for this job will be sent.

Columns Comments for NBRJOBS_SAL_TABLE (11)

Source Code Comments

SALARY TABLE: Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Form (NBAPOSN).

Columns Comments for NBRJOBS_SAL_GRADE (12)

Source Code Comments

SALARY GRADE: Defaults from the Salary/Rate Rule Form (NTRSALA) via the Position Form (NBAPOSN).

Columns Comments for NBRJOBS_SAL_STEP (13)

Source Code Comments

SALARY STEP: Defaults from the Salary/Rate Rule Form (NTRSALA) or can be entered online.

Columns Comments for NBRJOBS_APPT_PCT (14)

Source Code Comments

APPOINTMENT PERCENTAGE:

Columns Comments for NBRJOBS_FTE (15)

Source Code Comments

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

Columns Comments for NBRJOBS_HRS_DAY (16)

Source Code Comments

HOURS PER DAY: The number of hours an employee filling this job normally works in a day.

Columns Comments for NBRJOBS_HRS_PAY (17)

Source Code Comments

HOURS PER PAY: The number of hours an employee filling this job normally works in a pay period.

Columns Comments for NBRJOBS_SHIFT (18)

Source Code Comments

SHIFT: The normal shift assigned to this job.

Columns Comments for NBRJOBS_REG_RATE (19)

Source Code Comments

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.

Columns Comments for NBRJOBS_ASSGN_SALARY (20)

Source Code Comments

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.

Columns Comments for NBRJOBS_FACTOR (21)

Source Code Comments

PAY FACTOR: The number of pays per calendar year.

Columns Comments for NBRJOBS_ANN_SALARY (22)

Source Code Comments

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.

Columns Comments for NBRJOBS_PER_PAY_SALARY (23)

Source Code Comments

PER PAY SALARY: Used for deferred pay calculations.

Columns Comments for NBRJOBS_PAYS (24)

Source Code Comments

NUMBER OF PAYS PER YEAR: Used for deferred pay calculations.

Columns Comments for NBRJOBS_PER_PAY_DEFER_AMT (25)

Source Code Comments

PER PAY DEFERRED AMOUNT: The amount deferred each pay period for deferred pay calculation.

Columns Comments for NBRJOBS_ACTIVITY_DATE (26)

Source Code Comments

Date of last activity on this record.

Columns Comments for NBRJOBS_JCRE_CODE (27)

Source Code Comments

JOB CHANGE REASON CODE: This code should be existed in the PTVJCRE form.

Columns Comments for NBRJOBS_SGRP_CODE (28)

Source Code Comments

SGRP_CODE: The Salary Group Code.

Columns Comments for NBRJOBS_EMPR_CODE (29)

Source Code Comments

EMPR_CODE: The Employer Identification code.

Columns Comments for NBRJOBS_LGCD_CODE (30)

Source Code Comments

LGCD_CODE: Longevity code.

Columns Comments for NBRJOBS_LOCN_CODE (31)

Source Code Comments

LOCATION CODE: Location to which this position belongs.

Columns Comments for NBRJOBS_SCHL_CODE (32)

Source Code Comments

SCHOOL CODE: School to which this position belongs.

Columns Comments for NBRJOBS_SUPERVISOR_PIDM (33)

Source Code Comments

SUPERVISOR PIDM: Identification number of the supervisor for this job.

Columns Comments for NBRJOBS_SUPERVISOR_POSN (34)

Source Code Comments

SUPERVISOR POSN: The position number of the supervisor.

Columns Comments for NBRJOBS_SUPERVISOR_SUFF (35)

Source Code Comments

SUPERVISOR SUFFIX: Suffix associated with the supervisor's position.

Columns Comments for NBRJOBS_WKCP_CODE (36)

Source Code Comments

WKCP CODE: Workers' Compensation Classification Code associated with
this job.

Columns Comments for NBRJOBS_JBLN_CODE (37)

Source Code Comments

JBLN CODE: Job Location Code associated with this job.

Columns Comments for NBRJOBS_PERS_CHG_DATE (38)

Source Code Comments

PERSONNEL CHANGE DATE: Date the change became effective, regardless of
payroll.

Columns Comments for NBRJOBS_PCAT_CODE (39)

Source Code Comments

PREMIUM PAY CODE: Controls premium pay generation.

Columns Comments for NBRJOBS_DFPR_CODE (40)

Source Code Comments

DEFER PAY CODE: Identifies rules governing deferred pay.

Columns Comments for NBRJOBS_ENCUMBRANCE_HRS (41)

Source Code Comments

ENCUMBRANCE HOURS: The number of hours used for calculating the encumbrance amount for this job in the active fiscal year.

Columns Comments for NBRJOBS_CONTRACT_NO (42)

Source Code Comments

Job contract number.

Columns Comments for NBRJOBS_STRS_ASSN_CODE (43)

Source Code Comments

STRS ASSIGNMENT CODE:
STRS Assignment Code.

Columns Comments for NBRJOBS_STRS_PAY_CODE (44)

Source Code Comments

STRS PAY CODE:
STRS Pay Code for the employee.

Columns Comments for NBRJOBS_PERS_PAY_CODE (45)

Source Code Comments

PERS PAY CODE:
PERS Pay Code for the employee.

Columns Comments for NBRJOBS_TIME_ENTRY_METHOD (46)

Source Code Comments

Time Entry Method: P = Payroll, W = Web, D = Departmental, T = Third Party .

Columns Comments for NBRJOBS_TIME_ENTRY_TYPE (47)

Source Code Comments

Time Entry Type: T = Time Sheet, E = Exception Time Only, N = None.

Columns Comments for NBRJOBS_TIME_IN_OUT_IND (48)

Source Code Comments

Time In and Out Indicator : Indicates that employee must report time in and time out.

Columns Comments for NBRJOBS_LCAT_CODE (49)

Source Code Comments

Leave Category Code: A code which identifies a group of leave types.

Columns Comments for NBRJOBS_LEAV_REPT_METHOD (50)

Source Code Comments

Leave Report Entry Method:(W) Leave Report on the Web; (D) Departmental Leave Report; (T) Third Party Leave Report.

Columns Comments for NBRJOBS_PICT_CODE_LEAV_REPT (51)

Source Code Comments

Leave Report Payd ID: The pay ID associated with a leave report or leave request

Table PERDAYH

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:49:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK
PERDAYH_JOBS_SEQNO	PERDAYH_JOBS_SEQNO	NUMBER(12,0)	No	*
PERDAYH_TETH_SEQNO	PERDAYH_TETH_SEQNO	NUMBER(3,0)	No	*
PERDAYH_TIME_ENTRY_DATE	PERDAYH_TIME_ENTRY_DATE	DATE	No	*
PERDAYH_JOBS_STATUS	PERDAYH_JOBS_STATUS	VARCHAR2(1)	Yes
PERDAYH_SHCD_CODE	PERDAYH_SHCD_CODE	VARCHAR2(4)	Yes
PERDAYH_ACTIVITY_DATE	PERDAYH_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PERDAYH	Unique	PERDAYH_JOBS_SEQNO
PK_PERDAYH	Unique	PERDAYH_TETH_SEQNO
PK_PERDAYH	Unique	PERDAYH_TIME_ENTRY_DATE

Comments

Source Code Comments

Time Entry Pay Period Days History Table.

Columns Comments for PERDAYH_JOBS_SEQNO (1)

Source Code Comments

JOBS SEQUENCE NUMBER: Internal time entry sequence number.

Columns Comments for PERDAYH_TETH_SEQNO (2)

Source Code Comments

TIME ENTRY TRANSACTION SEQUENCE NUMBER: Internal one-up sequence number.

Columns Comments for PERDAYH_TIME_ENTRY_DATE (3)

Source Code Comments

TIME ENTRY DATE: Begin date of effective period.

Columns Comments for PERDAYH_JOBS_STATUS (4)

Source Code Comments

JOBS STATUS: Status of job as of the time entry date.

Columns Comments for PERDAYH_SHCD_CODE (5)

Source Code Comments

TIME ENTRY SHIFT CODE: Shift code that defines a shift based on time in/out.

Columns Comments for PERDAYH_ACTIVITY_DATE (6)

Source Code Comments

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

Table PERDAYS

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:49:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK
PERDAYS_JOBS_SEQNO	PERDAYS_JOBS_SEQNO	NUMBER(12,0)	No	*
PERDAYS_TIME_ENTRY_DATE	PERDAYS_TIME_ENTRY_DATE	DATE	No	*
PERDAYS_JOBS_STATUS	PERDAYS_JOBS_STATUS	VARCHAR2(1)	Yes
PERDAYS_SHCD_CODE	PERDAYS_SHCD_CODE	VARCHAR2(4)	Yes
PERDAYS_ACTIVITY_DATE	PERDAYS_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PERDAYS	Unique	PERDAYS_JOBS_SEQNO
PK_PERDAYS	Unique	PERDAYS_TIME_ENTRY_DATE

Comments

Source Code Comments

Time Entry Pay Period Effective Date Breakdown Table.

Columns Comments for PERDAYS_JOBS_SEQNO (1)

Source Code Comments

JOBS SEQUENCE NUMBER: Internal time entry sequence number.

Columns Comments for PERDAYS_TIME_ENTRY_DATE (2)

Source Code Comments

TIME ENTRY DATE: Begin date of effective period.

Columns Comments for PERDAYS_JOBS_STATUS (3)

Source Code Comments

JOBS STATUS: Status of job as of the time entry date.

Columns Comments for PERDAYS_SHCD_CODE (4)

Source Code Comments

TIME ENTRY SHIFT CODE: Shift code that defines a shift based on time in/out.

Columns Comments for PERDAYS_ACTIVITY_DATE (5)

Source Code Comments

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

Table PEREARH

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:49:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK
PEREARH_JOBS_SEQNO	PEREARH_JOBS_SEQNO	NUMBER(12,0)	No	*
PEREARH_TETH_SEQNO	PEREARH_TETH_SEQNO	NUMBER(3,0)	No	*
PEREARH_EARN_CODE	PEREARH_EARN_CODE	VARCHAR2(3)	No	*
PEREARH_SHIFT	PEREARH_SHIFT	VARCHAR2(1)	No	*
PEREARH_SPECIAL_RATE	PEREARH_SPECIAL_RATE	NUMBER(11,6)	No	*
PEREARH_DEFAULT_HRS	PEREARH_DEFAULT_HRS	NUMBER(6,2)	Yes
PEREARH_ACTIVITY_DATE	PEREARH_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PEREARH	Unique	PEREARH_JOBS_SEQNO
PK_PEREARH	Unique	PEREARH_TETH_SEQNO
PK_PEREARH	Unique	PEREARH_EARN_CODE
PK_PEREARH	Unique	PEREARH_SHIFT
PK_PEREARH	Unique	PEREARH_SPECIAL_RATE

Comments

Source Code Comments

Time Entry Earnings History Table