NBRBJOB PEBEMPL PEBGREV PEBHSIN PERGRDS PERGRPA PERGRRA PERGRRE PTVGRPT PTVGRSR PTVGRTP PTVISTA

Model Employee Relations


Model Label : Banner Human Resources Employee Relations Module

List of Objects

Object Name Object Type Layer Name
NBRBJOB SQL Table Default
PEBEMPL SQL Table Default
PEBGREV SQL Table Main Objects
PEBHSIN SQL Table Default
PERGRDS SQL Table Default
PERGRPA SQL Table Default
PERGRRA SQL Table Default
PERGRRE SQL Table Default
PTVGRPT SQL Table Default
PTVGRSR SQL Table Default
PTVGRTP SQL Table Default
PTVISTA SQL Table Default

Model View

Table NBRBJOB

Server Name S10B80
Database Name POSNCTL
Table Label

Table Columns information

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

Foreign Key information

Column name is Foreign Key For Column on Table
NBRBJOB_POSN NBBPOSN_POSN NBBPOSN
NBRBJOB_PIDM PEBEMPL_PIDM PEBEMPL
NBRBJOB_PIDM PERJLEV_PIDM PERJLEV
NBRBJOB_POSN PERJLEV_POSN PERJLEV
NBRBJOB_SUFF PERJLEV_SUFF PERJLEV
NBRBJOB_POSN NBREPSA_POSN NBREPSA

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

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
NBRJOBS SQL Table S10B80.POSNCTL Join
NPRCOLR SQL Table S10B80.POSNCTL Join
PERGRPA SQL Table S10B80.PAYROLL Refer (no action)
PERJBBG SQL Table S10B80.PAYROLL Refer (no action)
PERJOBS SQL Table S10B80.PAYROLL Join
PERJTOT SQL Table S10B80.PAYROLL Refer (no action)
PERPADV SQL Table S10B80.PAYROLL Refer (no action)
PERXJOB SQL Table S10B80.PAYROLL Refer (no action)
PHRJOBS SQL Table S10B80.PAYROLL Refer (no action)
PPRCOLR SQL Table S10B80.PAYROLL Join
SPBPERS SQL Table S10B80.SATURN Join
SPRADDR SQL Table S10B80.SATURN Join
SPRIDEN SQL Table S10B80.SATURN Join
SPRTELE SQL Table S10B80.SATURN Join
NBVPINC SQL View S10B80.BANINST1 Use (select)
PEVACP2 SQL View S10B80.BANINST1 Use (select)
PEVEPRO SQL View S10B80.BANINST1 Use (select)
PEVJLEV SQL View S10B80.BANINST1 Use (select)
PEVJOB1 SQL View S10B80.BANINST1 Use (select)
PEVJOBS SQL View S10B80.BANINST1 Use (select)
PEVPRF1 SQL View S10B80.BANINST1 Use (select)
PEVREC1 SQL View S10B80.BANINST1 Use (select)
PEVRTWK SQL View S10B80.BANINST1 Use (select)
PHVTIME SQL View S10B80.BANINST1 Use (select)
F_ALL_JOB_ROWID SQL Function S10B80.BANINST1 Use (select)
F_CURR_JOB_ROWID SQL Function S10B80.BANINST1 Use (select)
F_NUMBER_INCUMB SQL Function S10B80.BANINST1 Use (select)
F_PRIMARY_JOB_ROWID SQL Function S10B80.BANINST1 Use (select)
F_PRIM_SKILL_CODE SQL Function S10B80.BANINST1 Use (select)
JOB_ASSIGNMENT_REC Oracle Package Type S10B80.BANINST1.NP_JOB_ASSIGNMENT Rely On
JOB_BASE_REC Oracle Package Type S10B80.BANINST1.NB_JOB_BASE Rely On
LEAVE_REQUEST_TYPE_JOBS Oracle Package Type S10B80.BANINST1.BWPKTEIS Rely On
NBRBJOB_RECTYPE Oracle Package Type S10B80.BANINST1.NBKRECS Rely On
TIME_TYPE_JOBS Oracle Package Type S10B80.BANINST1.BWPKTEIS Rely On
LEAVE_REPORT_JOB_C Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
LEAVE_REPORT_JOB_C1 Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
LEAVE_REPORT_PAYPERIOD_C Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
LEAVE_REPORT_PAYPERIOD_C1 Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
LEAVE_REQUEST_JOB_C Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
LEAVE_REQUEST_TIME_ENTRY_C Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
TIME_JOB_C Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
TIME_PAYPERIOD_C Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
BASE_JOB_RECTYPE Oracle Package Type S10B80.BANINST1.NBKENCM Rely On
NBRBJOB_DATA_TYPE Oracle Package Type S10B80.BANINST1.BWPKEINF Rely On
NBRBJOB_REF Oracle Package Type S10B80.BANINST1.BWPKTEST Rely On
SALARY_RECTYPE Oracle Package Type S10B80.BANINST1.NBKJENC Rely On
JOBS_CURSOR Oracle Package Cursor S10B80.BANINST1.PEKTEEX Use (select)
NBRBJOB_BY_JLEV Oracle Package Cursor S10B80.BANINST1.BWPKEINF Use (select)
NBRBJOB_DATA Oracle Package Cursor S10B80.BANINST1.BWPKEINF Use (select)
P_APPLY_DEFAULTS Oracle Package Procedure S10B80.BANINST1.NOKEDIT Rely On
P_BALANCE_ENCUMBRANCE_HRS Oracle Package Procedure S10B80.BANINST1.NP_JOB_ASSIGNMENT Rely On
P_CALC_SAL_ENC Oracle Package Procedure S10B80.BANINST1.NBKENCM Rely On
P_EXTRACT_NBREJOB Oracle Package Procedure S10B80.BANINST1.NBKBUDG Use (select)
P_GETSOMEINDICATORS Oracle Package Procedure S10B80.BANINST1.PAKRECR Use (select)
P_GET_EMP_NBRJOBS_TOTALS Oracle Package Procedure S10B80.BANINST1.BWPKSJOB Use (select)
P_GET_INCUMBENT_PIDM Oracle Package Procedure S10B80.BANINST1.PEKTECM Rely On
P_GET_INCUMBENT_PIDM Oracle Package Procedure S10B80.BANINST1.PEKTECM Use (select)
P_GET_JOB_DATA Oracle Package Procedure S10B80.BANINST1.NBKEARN Rely On
P_GET_JOB_DATA Oracle Package Procedure S10B80.BANINST1.NBKEARN Use (select)
P_LOAD_NBRJLBD Oracle Package Procedure S10B80.BANINST1.NBKENCM Rely On
P_LOAD_NBRJLBD_SALARY_ONLY Oracle Package Procedure S10B80.BANINST1.NBKENCM Rely On
P_LOAD_UNION Oracle Package Procedure S10B80.BANINST1.NBKENCM Rely On
P_LOAD_UNION_EXTERNAL Oracle Package Procedure S10B80.BANINST1.NBKENCM Rely On
P_PROCESS_EDITS Oracle Package Procedure S10B80.BANINST1.NOKEDIT Rely On
P_PROCESS_INITIAL_EDITS Oracle Package Procedure S10B80.BANINST1.NOKEDIT Rely On
P_PROCESS_JLBD_UNION Oracle Package Procedure S10B80.BANINST1.NBKENCM Rely On
P_PROCESS_SALARY_ONLY Oracle Package Procedure S10B80.BANINST1.NBKENCM Rely On
UT_GP_CARDHOLDERPROCESSAPI Oracle Package Procedure S10B80.BANINST1.UT_GP_CARDHOLDER Use (Insert)
PK_VAR_OLD_ACCRUE_IND Oracle Package Variable S10B80.BANINST1.NOKEDIT Rely On
F_BUILD_NBRBJOB_REC Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Rely On
F_CHK_PRIMARY_JOB Oracle Package Function S10B80.BANINST1.PEKFASG Rely On
F_CHK_PRIMARY_PERFJOB Oracle Package Function S10B80.BANINST1.PEKFASG Rely On
F_ENC_PERIOD_TABLE Oracle Package Function S10B80.BANINST1.NBKJENC Rely On
F_JOBS_NOT_ENDED Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Use (select)
F_JOBS_STILL_ACTIVE Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Use (select)
F_LOCK_NBRBJOB Oracle Package Function S10B80.BANINST1.NBKENCM Rely On
F_LOCK_NBRBJOB Oracle Package Function S10B80.BANINST1.NBKENCM Use (select)
F_LOCK_NBRJOBS Oracle Package Function S10B80.BANINST1.NBKENCM Rely On
F_PRIM_SKILL_CODE Oracle Package Function S10B80.BANINST1.PEKDEGR Use (select)
F_SALARY_TABLE Oracle Package Function S10B80.BANINST1.NBKJENC Rely On
GET_NBRBJOB_VALUE_CUR Oracle Package Cursor S10B80.BANINST1.NOKEDIT Use (select)Rely On
GET_NULL_REVW_C Oracle Package Cursor S10B80.BANINST1.BWPCBREF Rely On
PTRCALNMAXENDDATEC Oracle Package Cursor S10B80.BANINST1.PDKLIBS Use (select)
P_BUILDPETWEMP Oracle Package Procedure S10B80.BANINST1.PEKWEMP Use (select)
P_CALC_DEFER_PAY Oracle Package Procedure S10B80.BANINST1.NOKPLIB Rely On
P_CALC_SALARY_ENCUMBRANCE Oracle Package Procedure S10B80.BANINST1.NBKJENC Rely On
P_CALC_SALARY_ENCUMBRANCE Oracle Package Procedure S10B80.BANINST1.NBKJENC Rely On
P_CALC_SALARY_ENCUMBRANCE Oracle Package Procedure S10B80.BANINST1.NBKJENK Rely On
P_CHECK_DATE_IN_RANGE Oracle Package Procedure S10B80.BANINST1.NBKJLBD Rely On
P_CHECK_DATE_IN_RANGE Oracle Package Procedure S10B80.BANINST1.NBKEARN Rely On
P_CHECK_ECLS_FRINGE Oracle Package Procedure S10B80.BANINST1.NBKJOBS Rely On
P_CHECK_FOR_PRIMARY_JOB Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_CHECK_FOR_PRIMARY_JOB Oracle Package Procedure S10B80.BANINST1.NBKBJOB Use (select)
P_CREATE Oracle Package Procedure S10B80.BANINST1.NP_JOB_ASSIGNMENT Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_NBRBJOB Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.NP_JOB_ASSIGNMENT Rely On
P_DELETE Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE Rely On
P_DISP_JOB_DETL_BODY Oracle Package Procedure S10B80.BANINST1.BWPKFJDT Rely On
P_DISP_JOB_DETL_BODY Oracle Package Procedure S10B80.BANINST1.BWPKFJDT Use (select)
P_EDIT_EMPR_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_EDIT_IPEDS_REPORTABLE Oracle Package Procedure S10B80.BANINST1.NOKP3LB Use (select)
P_EDIT_JOBS_STILL_ON_LEAVE Oracle Package Procedure S10B80.BANINST1.PEKEMPL Use (select)
P_EDIT_JOBS_STILL_ON_LEAVE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Use (select)
P_EDIT_LOA Oracle Package Procedure S10B80.BANINST1.NOKP2LB Use (select)
P_GETPRIMJOBSDATA Oracle Package Procedure S10B80.BANINST1.BWPKDOCM Use (select)
P_GET_JOB_DATA Oracle Package Procedure S10B80.BANINST1.NBKJLBD Rely On
P_GET_JOB_DATA Oracle Package Procedure S10B80.BANINST1.NBKJLBD Use (select)
P_GET_LEAV_MAX_LIST Oracle Package Procedure S10B80.BANINST1.PEKLEAV Use (select)
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_NBRBJOB Use (Insert)Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE Use (select)
P_MASS_EDIT Oracle Package Procedure S10B80.BANINST1.NOKEDIT Use (select)
P_NEXT_APPROVER Oracle Package Procedure S10B80.BANINST1.NOKMISC Use (select)
P_PRINT_JOBS_SELECTION Oracle Package Procedure S10B80.BANINST1.BWPKEPCR Use (select)
P_PROCESS_NBRJLBD_RECS Oracle Package Procedure S10B80.BANINST1.NOKMUPD Use (update)
P_PROCESS_THIS_JOB Oracle Package Procedure S10B80.BANINST1.NBKENCM Rely On
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE_RULES Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_NBRBJOB Use (update)Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.NP_JOB_ASSIGNMENT Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE Rely On
P_UPDATE_SALARY_ENCUMBRANCE Oracle Package Procedure S10B80.BANINST1.NP_JOB_ASSIGNMENT Rely On
P_UPD_PERSABB_DECISION Oracle Package Procedure S10B80.BANINST1.NOKP2LB Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.NB_JOB_DETAIL_RULES Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE_RULES Rely On
P_VALIDATE_BEGIN_DATE_VS_FISC Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_BEGIN_DATE_VS_LOA Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_BEGIN_DATE_VS_POSN Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_BEGIN_DATE_VS_TERM Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_CONTRACT_BEGIN_DATE Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_CONTRACT_END_DATE Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_DELETE Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE_RULES Rely On
P_VALIDATE_DELETE Oracle Package Procedure S10B80.BANINST1.NB_JOB_BASE_RULES Use (select)
P_VALIDATE_DELETE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Use (select)
P_VALIDATE_EFF_DATE_VS_BJOB Oracle Package Procedure S10B80.BANINST1.NBKJOBS Rely On
P_VALIDATE_EFF_DATE_VS_FISC Oracle Package Procedure S10B80.BANINST1.NBKJOBS Rely On
P_VALIDATE_ENCUMBRANCE_HRS Oracle Package Procedure S10B80.BANINST1.NBKJOBS Rely On
P_VALIDATE_END_DATE Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_FACL_STATSCAN_IND Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_FTE_EXCEEDS_EMPL Oracle Package Procedure S10B80.BANINST1.NBKJOBS Use (select)
P_VALIDATE_FTE_EXCEEDS_PTOT Oracle Package Procedure S10B80.BANINST1.NBKJOBS Use (select)
P_VALIDATE_IPEDS_REPT_IND Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_STEP_INCR_DAY Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_STEP_INCR_MON Oracle Package Procedure S10B80.BANINST1.NBKBJOB Rely On
P_VALIDATE_SUPERVISOR_JOB Oracle Package Procedure S10B80.BANINST1.NBKJOBS Use (select)
P_VALIDATE_SUPERVISOR_PIDM Oracle Package Procedure S10B80.BANINST1.NBKJOBS Rely On
P_VALIDATE_SUPERVISOR_PIDM Oracle Package Procedure S10B80.BANINST1.NBKJOBS Use (select)Rely On
P_VALIDATE_TS_ORGN_SECURITY_ML Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_NB_JOB_EARNINGS Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_PB_DEDN_COMB_LMT Use (Insert,select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_NB_JOB_LABOR Use (Insert,select)
F_APPR_JOB_TERMINATED Oracle Package Function S10B80.BANINST1.PEKTECM Use (select)
F_DERIVED_END_DATE Oracle Package Function S10B80.BANINST1.NBKBJOB Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Rely On
F_GET_NBRBJOB_FIELD Oracle Package Function S10B80.BANINST1.NOKEPCR Rely On
F_GET_NULL_REVW_POSN Oracle Package Function S10B80.BANINST1.BWPCBREF Rely On
F_GET_NULL_REVW_POSN Oracle Package Function S10B80.BANINST1.BWPCBREF Use (select)
F_IPEDS_REPORTABLE_IND Oracle Package Function S10B80.BANINST1.NBKBJOB Rely On
F_JOBS_NOT_ENDED Oracle Package Function S10B80.BANINST1.PEKEMPL Use (select)
F_JOBS_STILL_ACTIVE Oracle Package Function S10B80.BANINST1.PEKEMPL Use (select)
F_NBRBJOB_REC Oracle Package Function S10B80.BANINST1.NBKRECS Rely On
F_NBRJOBS_BY_DATE_RC Oracle Package Function S10B80.BANINST1.NBKJOBS Use (select)
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Use (select)
F_QUERY_BY_DATE Oracle Package Function S10B80.BANINST1.NP_JOB_ASSIGNMENT Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.NP_JOB_ASSIGNMENT Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Use (select)
F_QUERY_NEXT Oracle Package Function S10B80.BANINST1.NP_JOB_ASSIGNMENT Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.NP_JOB_ASSIGNMENT Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Use (select)
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Rely On
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.NB_JOB_BASE Use (select)
F_SALARY_ENCUMBRANCE_IND Oracle Package Function S10B80.BANINST1.NBKENCM Rely On
NBRBJOB Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
NBRBJOB_KEY2_INDEX SQL Index S10B80.POSNCTL Rely On
NBRBJOB_KEY_INDEX SQL Index S10B80.POSNCTL Rely On
PK_NBRBJOB SQL Index S10B80.POSNCTL Rely On
NBBPOSN SQL Table S10B80.POSNCTL Refer (no action)
NBREPSA SQL Table S10B80.POSNCTL Join
PEBEMPL SQL Table S10B80.PAYROLL Join
PERJLEV SQL Table S10B80.PAYROLL Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.POSNCTL.NBRBJOB

Object Dates

Creation Date Analysis Date
04/02/2008 13:29:22:000 04/02/2008 13:49:02:000

Source Code Comments

Assignment Repeating Base Table

Columns Comments for NBRBJOB_PIDM (# 1)

Source Code Comments

PIDM: Internal Identification number of the employee.

Columns Comments for NBRBJOB_POSN (# 2)

Source Code Comments

POSITION: The position to which this job is attached.

Columns Comments for NBRBJOB_SUFF (# 3)

Source Code Comments

SUFFIX: Used to uniquely create and maintain multiple jobs for the same position for the same employee.

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 will terminate. If date is null, then the job is defined as indefinite. The employee will be paid for this day.

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

CONTRACT TYPE: Indicates the type of job. Valid values are P = Primary, S = Secondary, or O = Overload. Only one primary job per person is allowed.

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: This date represents the date on which a contract begins. This date is significant to the encumbering process.

Columns Comments for NBRBJOB_CONTRACT_END_DATE (# 10)

Source Code Comments

CONTRACT END DATE: This date represents the date on which a contract ends. This date is significant to the encumbering process.

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 Job Detail Encumbrance Hours for the currently active fiscal year. The value should represent the total hours contracted to be paid in the 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: Chart of Accounts for this job, which is defaulted from the position and cannot be changed. Valued only when Banner Finance is installed.

Columns Comments for NBRBJOB_ACTIVITY_DATE (# 16)

Source Code Comments

ACTIVITY DATE: Date of last activity (insert or update) for this record.

Columns Comments for NBRBJOB_ACCRUE_LEAVE_IND (# 17)

Source Code Comments

ACCRUE LEAVE INDICATOR: Determines whether Leave is accrued for this job. Valid values are Y = Yes and N = No

Columns Comments for NBRBJOB_CIVIL_SERVICE_IND (# 18)

Source Code Comments

CIVIL SERVICE INDICATOR: Indicates if this assignment is a civil service job. Valid values are Y = Yes and N = No

Columns Comments for NBRBJOB_ENCUMBRANCE_CHANGE_IND (# 19)

Source Code Comments

ENCUMBRANCE CHANGE INDICATOR: Indicates if the encumbrance amount has changed for this job. Valid values are Y = Yes and N = No

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: Indicates if this job should be reported on the IPEDS report. Valid values are Y = Yes and N = No.

Columns Comments for NBRBJOB_FACL_STATSCAN_REPT_IND (# 22)

Source Code Comments

FACULTY STATISTICAL CANADIAN REPORT INDICATOR: This indicator will allow the Canadian user to gather data that is necessary for reporting of the Annual Faculty STATSCAN reports. Valid values are Y = Yes and N = No.

Columns Comments for NBRBJOB_PROBATION_BEGIN_DATE (# 23)

Source Code Comments

PROBATION BEGIN DATE: The begin date of Probationary Period.

Columns Comments for NBRBJOB_PROBATION_END_DATE (# 24)

Source Code Comments

PROBATION END DATE: The end date of Probationary Period. This data is calculated based on the Probationary Period and Probation Begin Date, but may be overridden. Overriding this value will NOT change the Probationary Period or Probation Begin Date.

Columns Comments for NBRBJOB_PROBATION_UNITS (# 25)

Source Code Comments

PROBATION UNITS: Identifies the number of Probationary Units. Will represent months or days depending on the Probationary Period Units institutional setting.

Columns Comments for NBRBJOB_ELIGIBLE_DATE (# 26)

Source Code Comments

ELIGIBLE DATE: Eligible Date for the Step Increase.

Columns Comments for NBRBJOB_USER_ID (# 27)

Source Code Comments

USER ID: The Oracle ID of the user who changed the record.

Columns Comments for NBRBJOB_DATA_ORIGIN (# 28)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row.

Columns Comments for NBRBJOB_FUTURE_SALARY_ENC (# 29)

Source Code Comments

FUTURE SALARY ENCUMBRANCE: The estimated amount a person will be paid in a job in future fiscal years.

Columns Comments for NBRBJOB_FUTURE_FRINGE_ENC (# 30)

Source Code Comments

FUTURE FRINGE ENCUMBRANCE: The estimated cost of fringe benefits a person will be paid in a job in future fiscal years.

Table PEBEMPL

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PEBEMPL_PIDM   NUMBER(8,0) No * *
PEBEMPL_EMPL_STATUS   VARCHAR2(1) No    
PEBEMPL_COAS_CODE_HOME   VARCHAR2(1) Yes    
PEBEMPL_ORGN_CODE_HOME   VARCHAR2(6) No   *
PEBEMPL_COAS_CODE_DIST   VARCHAR2(1) Yes    
PEBEMPL_ORGN_CODE_DIST   VARCHAR2(6) No   *
PEBEMPL_ECLS_CODE   VARCHAR2(2) No   *
PEBEMPL_LCAT_CODE   VARCHAR2(2) No   *
PEBEMPL_BCAT_CODE   VARCHAR2(2) No   *
PEBEMPL_FIRST_HIRE_DATE   DATE No    
PEBEMPL_CURRENT_HIRE_DATE   DATE No    
PEBEMPL_ADJ_SERVICE_DATE   DATE No    
PEBEMPL_SENIORITY_DATE   DATE No    
PEBEMPL_LREA_CODE   VARCHAR2(2) Yes    
PEBEMPL_LOA_BEG_DATE   DATE Yes    
PEBEMPL_LOA_END_DATE   DATE Yes    
PEBEMPL_TREA_CODE   VARCHAR2(2) Yes   *
PEBEMPL_TERM_DATE   DATE Yes    
PEBEMPL_I9_FORM_IND   VARCHAR2(1) Yes    
PEBEMPL_I9_DATE   DATE Yes    
PEBEMPL_I9_EXPIRE_DATE   DATE Yes    
PEBEMPL_ACTIVITY_DATE   DATE No    
PEBEMPL_WKPR_CODE   VARCHAR2(4) Yes   *
PEBEMPL_FLSA_IND   VARCHAR2(1) No    
PEBEMPL_STGR_CODE   VARCHAR2(2) Yes   *
PEBEMPL_DAYS_IN_CANADA   NUMBER(3,0) Yes    
PEBEMPL_1042_RECIPIENT_CD   VARCHAR2(2) Yes    
PEBEMPL_INTERNAL_FT_PT_IND   VARCHAR2(1) No    
PEBEMPL_DICD_CODE   VARCHAR2(3) Yes    
PEBEMPL_EGRP_CODE   VARCHAR2(4) Yes    
PEBEMPL_IPEDS_SOFT_MONEY_IND   VARCHAR2(1) No    
PEBEMPL_FIRST_WORK_DATE   DATE Yes    
PEBEMPL_LAST_WORK_DATE   DATE Yes    
PEBEMPL_CALIF_PENSION_IND   VARCHAR2(1) Yes    
PEBEMPL_NRSI_CODE   VARCHAR2(4) Yes   *
PEBEMPL_SSN_LAST_NAME   VARCHAR2(20) Yes    
PEBEMPL_SSN_FIRST_NAME   VARCHAR2(15) Yes    
PEBEMPL_SSN_MI   VARCHAR2(15) Yes    
PEBEMPL_SSN_SUFFIX   VARCHAR2(4) Yes    
PEBEMPL_JBLN_CODE   VARCHAR2(6) Yes   *
PEBEMPL_COLL_CODE   VARCHAR2(2) Yes   *
PEBEMPL_CAMP_CODE   VARCHAR2(3) Yes   *
PEBEMPL_USER_ID   VARCHAR2(30) Yes    
PEBEMPL_DATA_ORIGIN   VARCHAR2(30) Yes    
PEBEMPL_EW2_CONSENT_IND   VARCHAR2(1) No    
PEBEMPL_EW2_CONSENT_DATE   DATE Yes    
PEBEMPL_EW2_CONSENT_USER_ID   VARCHAR2(30) Yes    
PEBEMPL_IPEDS_PRIMARY_FUNCTION   VARCHAR2(3) No    
PEBEMPL_IPEDS_MED_DENTAL_IND   VARCHAR2(1) No    
PEBEMPL_ETAX_CONSENT_IND   VARCHAR2(1) No    
PEBEMPL_ETAX_CONSENT_DATE   DATE Yes    
PEBEMPL_ETAX_CONSENT_USER_ID   VARCHAR2(30) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
PEBEMPL_BCAT_CODE PTRBCAT_CODE PTRBCAT
PEBEMPL_ECLS_CODE PTRECLS_CODE PTRECLS
PEBEMPL_JBLN_CODE PTRJBLN_CODE PTRJBLN
PEBEMPL_TREA_CODE PTRTREA_CODE PTRTREA
PEBEMPL_LCAT_CODE PTVLCAT_CODE PTVLCAT
PEBEMPL_NRSI_CODE PTVNRSI_CODE PTVNRSI
PEBEMPL_ORGN_CODE_HOME PTVORGN_CODE PTVORGN
PEBEMPL_ORGN_CODE_DIST PTVORGN_CODE PTVORGN
PEBEMPL_STGR_CODE PTVSTGR_CODE PTVSTGR
PEBEMPL_WKPR_CODE PTRWKPR_CODE PTRWKPR
PEBEMPL_COLL_CODE STVCOLL_CODE STVCOLL
PEBEMPL_CAMP_CODE STVCAMP_CODE STVCAMP
PEBEMPL_PIDM POTPARM_PIDM POTPARM
PEBEMPL_PIDM PERJLEV_PIDM PERJLEV

Index

Index Name Index Type Column Name
PEBEMPL_HOME_INDEX   PEBEMPL_ORGN_CODE_HOME
PEBEMPL_HOME_INDEX   PEBEMPL_COAS_CODE_HOME
PEBEMPL_HOME_INDEX   PEBEMPL_PIDM
PEBEMPL_KEY2_INDEX Unique PEBEMPL_LCAT_CODE
PEBEMPL_KEY2_INDEX Unique PEBEMPL_PIDM
PEBEMPL_KEY3_INDEX   PEBEMPL_ECLS_CODE
PK_PEBEMPL Unique PEBEMPL_PIDM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOBINTL SQL Table S10B80.GENERAL Join
GORVISA SQL Table S10B80.GENERAL Join
NBRBJOB SQL Table S10B80.POSNCTL Join
NBRJOBS SQL Table S10B80.POSNCTL Join
PABAPPL SQL Table S10B80.PAYROLL Join
PDRBDED SQL Table S10B80.PAYROLL Refer (no action)
PDRBFLX SQL Table S10B80.PAYROLL Refer (no action)
PDRFBAL SQL Table S10B80.PAYROLL Refer (no action)
PDRFCLM SQL Table S10B80.PAYROLL Refer (no action)
PERBARG SQL Table S10B80.PAYROLL Refer (no action)
PERDIRD SQL Table S10B80.PAYROLL Refer (no action)
PERETOT SQL Table S10B80.PAYROLL Refer (no action)
PERGRPA SQL Table S10B80.PAYROLL Refer (no action)
PERJBBG SQL Table S10B80.PAYROLL Join
PERLEAV SQL Table S10B80.PAYROLL Join
PERRCMT SQL Table S10B80.PAYROLL Refer (no action)
PERREVW SQL Table S10B80.PAYROLL Refer (no action)
PERRHOL SQL Table S10B80.PAYROLL Refer (no action)
PERROTH SQL Table S10B80.PAYROLL Refer (no action)
PHRHIST SQL Table S10B80.PAYROLL Refer (no action)
PTRBCDN SQL Table S10B80.PAYROLL Join
PTRBSDD SQL Table S10B80.PAYROLL Join
PTRLREA SQL Table S10B80.PAYROLL Join
SORDEGR SQL Table S10B80.SATURN Join
SPBPERS SQL Table S10B80.SATURN Join
SPRADDR SQL Table S10B80.SATURN Join
SPRIDEN SQL Table S10B80.SATURN Join
SPRTELE SQL Table S10B80.SATURN Join
PT_PEBEMPL_AR_LDI SQL Trigger S10B80.PAYROLL Rely On
PAVAPPL SQL View S10B80.BANINST1 Use (select)
PDVDED1 SQL View S10B80.BANINST1 Use (select)
PEVDEG1 SQL View S10B80.BANINST1 Use (select)
PEVELEV SQL View S10B80.BANINST1 Use (select)
PEVEMPL SQL View S10B80.BANINST1 Use (select)
PEVPRF1 SQL View S10B80.BANINST1 Use (select)
PEVREC1 SQL View S10B80.BANINST1 Use (select)
PEVRTWK SQL View S10B80.BANINST1 Use (select)
PEVVER2 SQL View S10B80.BANINST1 Use (select)
PHVTIME SQL View S10B80.BANINST1 Use (select)
F_CONCAT_EMPL_DATA SQL Function S10B80.BANINST1 Use (select)
F_INCL_TERMINATED SQL Function S10B80.BANINST1 Use (select)
F_ORDER_BY_LAST SQL Function S10B80.BANINST1 Use (select)
F_PAYROLL_EMPLOYEE_IC SQL Function S10B80.BANINST1 Rely On
F_PAYROLL_EMPLOYEE_IC SQL Function S10B80.BANINST1 Use (select)
F_PAYROLL_EMPLOYEE_IND SQL Function S10B80.BANINST1 Use (select)
EMPLOYEE_REC Oracle Package Type S10B80.BANINST1.PB_EMPLOYEE Rely On
PEBEMPL_RECTYPE Oracle Package Type S10B80.BANINST1.PEKRECS Rely On
R_REVT Oracle Package Type S10B80.BANINST1.BWPCBREF Rely On
EMPL_LEAVE_IND Oracle Package Cursor S10B80.BANINST1.BWPKTEIS Use (select)
PEBEMPL_REC Oracle Package Variable S10B80.BANINST1.BWPKDOCM Rely On
GLOBAL_RECTYPE Oracle Package Type S10B80.BANINST1.PDKDEDN Rely On
EMPL_C Oracle Package Cursor S10B80.BANINST1.PP_W2_2006 Rely On
EMPL_C Oracle Package Cursor S10B80.BANINST1.PP_W2_2006 Use (select)
EMPL_C Oracle Package Cursor S10B80.BANINST1.PP_W2_2007 Rely On
EMPL_C Oracle Package Cursor S10B80.BANINST1.PP_W2_2007 Use (select)
GETSECGRPC Oracle Package Cursor S10B80.BANINST1.BWPKEBST Rely On
GETSECGRPC Oracle Package Cursor S10B80.BANINST1.BWPKEBST Use (select)
JOBS_CURSOR Oracle Package Cursor S10B80.BANINST1.PEKTEEX Use (select)
P_BENEFITS Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_CHECK_ROWID_ACCESS Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE Rely On
P_CHECK_ROWID_ACCESS Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE Use (select)Rely On
P_DELETE_ERRORS Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_EDIT_CRSE_ASSIGNMENT Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_EDIT_NIST_ASSIGNMENT Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_GETBASICEMPDATA Oracle Package Procedure S10B80.BANINST1.PEKWEMP Use (select)
P_GETEMPDATA Oracle Package Procedure S10B80.BANINST1.PEKDEGR Use (select)
P_PERSONALINFO Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_PERSONALINFO Oracle Package Procedure S10B80.BANINST1.BWPKEBST Use (select)Rely On
P_PRINTCOVEREDPERSONS Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_PRINTLINKS Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_UPDATEDEDNEDITBCATELIGIBLE Oracle Package Procedure S10B80.BANINST1.BWPKDUPD Rely On
P_UPDATEDEDNEDITOPENENROLLMENT Oracle Package Procedure S10B80.BANINST1.BWPKDUPD Rely On
PEBEMPL_REC Oracle Package Variable S10B80.BANINST1.BWPKHDED Rely On
PEBEMPL_REC Oracle Package Variable S10B80.BANINST1.BWPKDQRY Rely On
PEBEMPL_REC Oracle Package Variable S10B80.BANINST1.BWPKDCMN Rely On
PEBEMPL_REC Oracle Package Variable S10B80.BANINST1.BWPKHPAY Rely On
PEBEMPL_ROW Oracle Package Variable S10B80.BANINST1.BWPKSJOB Rely On
PIDM Oracle Package Variable S10B80.BANINST1.BWPKEBST Rely On
F_BUILD_PEBEMPL_REC Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Rely On
F_GETPIDMFROMID Oracle Package Function S10B80.BANINST1.BWPKEBST Use (select)
F_INVALID_DEDN_EXISTS Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_ISBENADMIN Oracle Package Function S10B80.BANINST1.BWPKEBST Rely On
F_JOBS_NOT_ENDED Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_JOBS_STILL_ACTIVE Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_PIDM_IN_PEBEMPL Oracle Package Function S10B80.BANINST1.EOKPSEC Use (select)
F_VALID_1042_RECIPIENT_CD Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_VALID_CALIF_PENSION_IND Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_VALID_EMPLOYEE Oracle Package Function S10B80.BANINST1.PEKFASG Rely On
F_VALID_EMPLOYEE Oracle Package Function S10B80.BANINST1.PEKFASG Use (select)
F_VALID_EMPL_STATUS Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_VALID_EW2_CONSENT_IND Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_VALID_FLSA_IND Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_VALID_I9_FORM_IND Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_VALID_INTERNAL_FT_PT_IND Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
CHECK_TERMINATED Oracle Package Cursor S10B80.BANINST1.NOKPLIB Use (select)
GET_NULL_REVW_C Oracle Package Cursor S10B80.BANINST1.BWPCBREF Use (select)
GET_REVW_INFO_C Oracle Package Cursor S10B80.BANINST1.BWPCBREF Use (select)
PEBEMPLC Oracle Package Cursor S10B80.BANINST1.NOKPLIB Use (select)
PEBEMPLC Oracle Package Cursor S10B80.BANINST1.PEKLIBS Use (select)Rely On
P_BUILDPATRECR Oracle Package Procedure S10B80.BANINST1.PAKRECR Use (select)
P_BUILDPETDEGR Oracle Package Procedure S10B80.BANINST1.PEKDEGR Use (select)
P_CALC_CRSE_COMPENSATION Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_CHECK_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Rely On
P_CREATE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE Rely On
P_CREATE_W2 Oracle Package Procedure S10B80.BANINST1.PP_W2 Rely On
P_CREATE_W2 Oracle Package Procedure S10B80.BANINST1.PP_W2 Use (select)
P_DELETE Oracle Package Procedure S10B80.BANINST1.DML_PEBEMPL Use (delete)
P_DELETE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE Rely On
P_DELETE_FACULTY_COMPENSATIONS Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_DISPBENEFITSTATEMENT Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_DISPBENEFITSTATEMENT Oracle Package Procedure S10B80.BANINST1.BWPKEBST Use (select)
P_DISPDATESELECT Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_DISPDATESELECT Oracle Package Procedure S10B80.BANINST1.BWPKEBST Use (select)Rely On
P_DISPIDSELECT Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_DO_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_EDIT_COAS_CODE_DIST Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_EDIT_COAS_CODE_HOME Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_EDIT_EMPLOYEE_ID Oracle Package Procedure S10B80.BANINST1.PDKDEDN Rely On
P_EDIT_EMPLOYEE_ID Oracle Package Procedure S10B80.BANINST1.PDKDEDN Use (select)
P_EDIT_EMPL_PIDM Oracle Package Procedure S10B80.BANINST1.NOKPLIB Use (select)
P_EDIT_JOBS_STILL_ON_LEAVE Oracle Package Procedure S10B80.BANINST1.PEKEMPL Rely On
P_EDIT_JOBS_STILL_ON_LEAVE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_EDIT_LV_DATES Oracle Package Procedure S10B80.BANINST1.NOKPLIB Use (select)
P_EDIT_ORGN_CODE_DIST Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_EDIT_ORGN_CODE_HOME Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_EDIT_PEBEMPL_TERM_EMPL Oracle Package Procedure S10B80.BANINST1.NOKPLIB Use (select)
P_GET_CRSE_ASSIGNMENT Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_GET_CRSE_ASSIGNMENT_CHANGES Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_GET_ECLS_DEFAULTS Oracle Package Procedure S10B80.BANINST1.PEKEMPL Rely On
P_GET_ECLS_DEFAULTS Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_GET_EMPL_INFO Oracle Package Procedure S10B80.BANINST1.POKWLIB Rely On
P_GET_EMPL_INFO Oracle Package Procedure S10B80.BANINST1.POKWLIB Use (select)
P_GET_EMPL_LOA Oracle Package Procedure S10B80.BANINST1.NOKP3LB Use (select)
P_GET_NIST_ASSIGNMENT Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_GET_NIST_ASSIGNMENT_CHANGES Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_INSERT Oracle Package Procedure S10B80.BANINST1.DML_PEBEMPL Use (Insert)Rely On
P_INSERT_REPORT_DATA Oracle Package Procedure S10B80.BANINST1.PXKREPT Use (select)
P_LOCK Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE Rely On
P_LOCK Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE Use (select)
P_MAIN_ROLL Oracle Package Procedure S10B80.BANINST1.PEKLEAV Use (select)
P_NBRJOBS_AIR Oracle Package Procedure S10B80.BANINST1.EOKPRTS Use (select)
P_PEBEMPL_ADR Oracle Package Procedure S10B80.BANINST1.EOKPRTS Rely On
P_PEBEMPL_AIR Oracle Package Procedure S10B80.BANINST1.EOKPRTS Rely On
P_PEBEMPL_AUR Oracle Package Procedure S10B80.BANINST1.EOKPRTS Rely On
P_PRINT_ASSIGNMENT Oracle Package Procedure S10B80.BANINST1.BWPKFLDT Rely On
P_PRINT_JOB_LIST Oracle Package Procedure S10B80.BANINST1.BWPKOLIB Rely On
P_PRINT_W2_CONSENT Oracle Package Procedure S10B80.BANINST1.BWPKXW2S Use (select)
P_REGISTER_ENTITY Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_SELECTLEAVEREPORT Oracle Package Procedure S10B80.BANINST1.BWPKTEIS Rely On
P_SELECTLEAVEREQUEST Oracle Package Procedure S10B80.BANINST1.BWPKTEIS Rely On
P_START_FACULTY_COMPENSATION Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.DML_PEBEMPL Use (update)Rely On
P_UPDATE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE Rely On
P_UPDATE_W2_CONSENT Oracle Package Procedure S10B80.BANINST1.BWPKXW2S Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_VALIDATE_DELETE Oracle Package Procedure S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
P_VIEWLEAVEBALANCESBODY Oracle Package Procedure S10B80.BANINST1.BWPKEINF Rely On
P_VIEWLEAVEDETAILBODY Oracle Package Procedure S10B80.BANINST1.BWPKEINF Rely On
P_WRITE_ERROR Oracle Package Procedure S10B80.BANINST1.PEKFASG Rely On
F_CHECK_REQD_DEDNS Oracle Package Function S10B80.BANINST1.POKLIBS Use (select)
F_DEDNISREQUIRED Oracle Package Function S10B80.BANINST1.PDKLIBS Use (select)
F_DETERMINECOVERAGEENDDATE Oracle Package Function S10B80.BANINST1.BWPKDUPD Rely On
F_EMPLOYEE_EXISTS Oracle Package Function S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT Rely On
F_EMPLOYEE_EXISTS Oracle Package Function S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT Use (select)
F_EMPLOYEE_EXISTS Oracle Package Function S10B80.BANINST1.PX_MASS_ROE Rely On
F_EMPLOYEE_EXISTS Oracle Package Function S10B80.BANINST1.PX_MASS_ROE Use (select)
F_EMPL_TERMINATED Oracle Package Function S10B80.BANINST1.PEKTECM Use (select)
F_EXISTS Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Rely On
F_EXISTS Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Use (select)
F_GET_ECLS_CODE Oracle Package Function S10B80.BANINST1.POKLIBS Use (select)
F_GET_EMPL_ECLS Oracle Package Function S10B80.BANINST1.NOKPLIB Use (select)
F_GET_LEAV_MAX_HRS Oracle Package Function S10B80.BANINST1.PEKLEAV Use (select)
F_GET_PI_TIME_REPORT_DEFAULT Oracle Package Function S10B80.BANINST1.BWPCXCHN Rely On
F_GET_REVIEW_LIST_XML Oracle Package Function S10B80.BANINST1.BWPCXCHN Rely On
F_HR_SECURITY Oracle Package Function S10B80.BANINST1.NOKSECR Rely On
F_HR_SECURITY Oracle Package Function S10B80.BANINST1.NOKSECR Use (select)
F_INCL_TERMINATED Oracle Package Function S10B80.BANINST1.PEKWEMP Use (select)
F_INVALID_DEDN_EXISTS Oracle Package Function S10B80.BANINST1.PEKEMPL Rely On
F_JOBS_NOT_ENDED Oracle Package Function S10B80.BANINST1.PEKEMPL Rely On
F_JOBS_STILL_ACTIVE Oracle Package Function S10B80.BANINST1.PEKEMPL Rely On
F_MINIMAL_ADDR_INFO_EXISTS Oracle Package Function S10B80.BANINST1.PEKEMPL Rely On
F_MINIMAL_ADDR_INFO_EXISTS Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_MINIMAL_BIO_INFO_EXISTS Oracle Package Function S10B80.BANINST1.PEKEMPL Rely On
F_MINIMAL_BIO_INFO_EXISTS Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE_RULES Rely On
F_PEBEMPL_REC Oracle Package Function S10B80.BANINST1.PEKRECS Rely On
F_QUERY_ALL Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Use (select)
F_QUERY_BY_ROWID Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Use (select)
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Rely On
F_QUERY_ONE Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Use (select)
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Rely On
F_QUERY_ONE_LOCK Oracle Package Function S10B80.BANINST1.PB_EMPLOYEE Use (select)
PEBEMPL Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PEBEMPL_HOME_INDEX SQL Index S10B80.PAYROLL Rely On
PEBEMPL_KEY2_INDEX SQL Index S10B80.PAYROLL Rely On
PEBEMPL_KEY3_INDEX SQL Index S10B80.PAYROLL Rely On
PK_PEBEMPL SQL Index S10B80.PAYROLL Rely On
PERJLEV SQL Table S10B80.PAYROLL Join
POTPARM SQL Table S10B80.PAYROLL Join
PTRBCAT SQL Table S10B80.PAYROLL Refer (no action)
PTRECLS SQL Table S10B80.PAYROLL Refer (no action)
PTRJBLN SQL Table S10B80.PAYROLL Refer (no action)
PTRTREA SQL Table S10B80.PAYROLL Refer (no action)
PTRWKPR SQL Table S10B80.PAYROLL Refer (no action)
PTVLCAT SQL Table S10B80.PAYROLL Refer (no action)
PTVNRSI SQL Table S10B80.PAYROLL Refer (no action)
PTVORGN SQL Table S10B80.PAYROLL Refer (no action)
PTVSTGR SQL Table S10B80.PAYROLL Refer (no action)
STVCAMP SQL Table S10B80.SATURN Refer (no action)
STVCOLL SQL Table S10B80.SATURN Refer (no action)
ET_PEBEMPL_ADR_EXTSOL SQL Trigger S10B80.BANIMGR Fire (delete,after,each row)
ET_PEBEMPL_AIR_EXTSOL SQL Trigger S10B80.BANIMGR Fire (Insert,after,each row)
ET_PEBEMPL_AUR_EXTSOL SQL Trigger S10B80.BANIMGR Fire (update,after,each row)
PT_PEBEMPL_AR_LDI SQL Trigger S10B80.PAYROLL Fire (Insert,update,delete,after,each row)
PT_PEBEMPL_AS_LDI SQL Trigger S10B80.PAYROLL Fire (Insert,update,delete,after,all rows)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PEBEMPL

Object Dates

Creation Date Analysis Date
04/02/2008 13:36:46:000 04/02/2008 13:49:11:000

Source Code Comments

Employee Base Table

Columns Comments for PEBEMPL_PIDM (# 1)

Source Code Comments

Internal Identification number of person.

Columns Comments for PEBEMPL_EMPL_STATUS (# 2)

Source Code Comments

The status of the employee. Valid values are A - Active, B - Leave without pay and with benefits, L -Leave without pay and without benefits, F - Leave with pay and with benefits, P - Leave with partial pay and with benefits, T - Terminated.

Columns Comments for PEBEMPL_COAS_CODE_HOME (# 3)

Source Code Comments

The Home Chart of Accounts Code for the employee.

Columns Comments for PEBEMPL_ORGN_CODE_HOME (# 4)

Source Code Comments

The Home Organization code of the employee.

Columns Comments for PEBEMPL_COAS_CODE_DIST (# 5)

Source Code Comments

The Chart of Accounts Code to which the employee's documents, such as checks, are distributed.

Columns Comments for PEBEMPL_ORGN_CODE_DIST (# 6)

Source Code Comments

The organization code used for document distribution.

Columns Comments for PEBEMPL_ECLS_CODE (# 7)

Source Code Comments

The employee grouping to which the employee belongs.

Columns Comments for PEBEMPL_LCAT_CODE (# 8)

Source Code Comments

The leave category to which the employee belongs.

Columns Comments for PEBEMPL_BCAT_CODE (# 9)

Source Code Comments

The benefit category to which the employee belongs.

Columns Comments for PEBEMPL_FIRST_HIRE_DATE (# 10)

Source Code Comments

The date the employee was first hired.

Columns Comments for PEBEMPL_CURRENT_HIRE_DATE (# 11)

Source Code Comments

The employees current date of hire.

Columns Comments for PEBEMPL_ADJ_SERVICE_DATE (# 12)

Source Code Comments

Date used to determine years of service for leave accrual if the First Hire Date and the Current Hire Date are not equal.

Columns Comments for PEBEMPL_SENIORITY_DATE (# 13)

Source Code Comments

Date that establishes service and can be used for leave accrual.

Columns Comments for PEBEMPL_LREA_CODE (# 14)

Source Code Comments

A code identifying the reason for the leave of absence of the employee.

Columns Comments for PEBEMPL_LOA_BEG_DATE (# 15)

Source Code Comments

The begin date of a leave of absence for the employee.

Columns Comments for PEBEMPL_LOA_END_DATE (# 16)

Source Code Comments

LEAVE OF ABSENCE END DATE: The anticipated end date for an employees leave of absence.

Columns Comments for PEBEMPL_TREA_CODE (# 17)

Source Code Comments

Code used to identify the reason of termination.

Columns Comments for PEBEMPL_TERM_DATE (# 18)

Source Code Comments

Termination date of the employee.

Columns Comments for PEBEMPL_I9_FORM_IND (# 19)

Source Code Comments

Indicates whether or not immigration information has been received. Valid values are R - Received, N - Not received, T - Temporary, E - Exempt, NULL - None.

Columns Comments for PEBEMPL_I9_DATE (# 20)

Source Code Comments

The date immigration information was received.

Columns Comments for PEBEMPL_I9_EXPIRE_DATE (# 21)

Source Code Comments

The date the immigration information expires.

Columns Comments for PEBEMPL_ACTIVITY_DATE (# 22)

Source Code Comments

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

Columns Comments for PEBEMPL_WKPR_CODE (# 23)

Source Code Comments

Work Period Code.

Columns Comments for PEBEMPL_FLSA_IND (# 24)

Source Code Comments

Used for Fair Labor Standards Overtime compensation. Valid values are C - Cash, A - Accrual, N - No FLSA.

Columns Comments for PEBEMPL_STGR_CODE (# 25)

Source Code Comments

Statistics Canada Grouping Code.

Columns Comments for PEBEMPL_DAYS_IN_CANADA (# 26)

Source Code Comments

Number of days the employee worked in Canada.

Columns Comments for PEBEMPL_1042_RECIPIENT_CD (# 27)

Source Code Comments

Identifies the type of individual who is receiving a 1042 statement.

Columns Comments for PEBEMPL_INTERNAL_FT_PT_IND (# 28)

Source Code Comments

Internal Part Time/Full Time Indicator, used for EEO reporting. Valid values are F - Full-time, P - Part-time, O - Other.

Columns Comments for PEBEMPL_DICD_CODE (# 29)

Source Code Comments

The district or division associated with an employee.

Columns Comments for PEBEMPL_EGRP_CODE (# 30)

Source Code Comments

The employee group is a sub-category of the Employee Class.

Columns Comments for PEBEMPL_IPEDS_SOFT_MONEY_IND (# 31)

Source Code Comments

IPEDS Soft Money Indicator. Valid values are Y - Yes, N - No.

Columns Comments for PEBEMPL_FIRST_WORK_DATE (# 32)

Source Code Comments

The first day that the employee worked.

Columns Comments for PEBEMPL_LAST_WORK_DATE (# 33)

Source Code Comments

The last day that the employee worked.

Columns Comments for PEBEMPL_CALIF_PENSION_IND (# 34)

Source Code Comments

California Pension Indicator. Valid values are B - STRS/PERS member, E - PERS retiree, N - Non member, P - PERS member, R - STRS retiree, S - STRS member, T - STRS/PERS retiree, NULL - None.

Columns Comments for PEBEMPL_NRSI_CODE (# 35)

Source Code Comments

Non-resident Service Code.

Columns Comments for PEBEMPL_SSN_LAST_NAME (# 36)

Source Code Comments

Social security last name used in reporting.

Columns Comments for PEBEMPL_SSN_FIRST_NAME (# 37)

Source Code Comments

Social security first name used in reporting.

Columns Comments for PEBEMPL_SSN_MI (# 38)

Source Code Comments

Social security middle name used in reporting.

Columns Comments for PEBEMPL_SSN_SUFFIX (# 39)

Source Code Comments

Social security name suffix used in reporting.

Columns Comments for PEBEMPL_JBLN_CODE (# 40)

Source Code Comments

The Location to which the employee belongs.

Columns Comments for PEBEMPL_COLL_CODE (# 41)

Source Code Comments

The College to which the employee belongs.

Columns Comments for PEBEMPL_CAMP_CODE (# 42)

Source Code Comments

The Campus to which the employee belongs.

Columns Comments for PEBEMPL_USER_ID (# 43)

Source Code Comments

The user who last created or updated the employee record.

Columns Comments for PEBEMPL_DATA_ORIGIN (# 44)

Source Code Comments

Source system that generated the data.

Columns Comments for PEBEMPL_EW2_CONSENT_IND (# 45)

Source Code Comments

ELECTRONIC W-2 CONSENT INDICATOR: Indicator to identify the employee has consented to receive the W-2 electronically. Valid values are (Y)es or (N)o. Default value is (N)o.

Columns Comments for PEBEMPL_EW2_CONSENT_DATE (# 46)

Source Code Comments

ELECTRONIC W-2 CONSENT DATE: This field identifies the most recent date the Electronic W-2 Consent Indicator was updated.

Columns Comments for PEBEMPL_EW2_CONSENT_USER_ID (# 47)

Source Code Comments

ELECTRONIC W-2 CONSENT USER ID: The unique identification of the user who last updated the Electronic W-2 Consent Indicator.

Columns Comments for PEBEMPL_IPEDS_PRIMARY_FUNCTION (# 48)

Source Code Comments

IPEDS PRIMARY FUNCTION: Field to select the primary function for the PERIPED report. Valid values are: None (N), Primarily Instruction (PI), Primarily Research (PR), Primarily Public Service (PS), Instruction combined with Research/Public Service (IRP)

Columns Comments for PEBEMPL_IPEDS_MED_DENTAL_IND (# 49)

Source Code Comments

IPEDS MEDICAL AND DENTAL INDICATOR: Indicator determines where the person is reported for the PERIPED report. Valid values are: Y = Yes and reported under the Medical/Dental section. N = No and reported under the Non-medical section. The default is N.

Columns Comments for PEBEMPL_ETAX_CONSENT_IND (# 50)

Source Code Comments

ELECTRONIC TAX FORM CONSENT INDICATOR: Indicator to identify the employee has consented to receive the tax form electronically. Valid values are Y and N (Default).

Columns Comments for PEBEMPL_ETAX_CONSENT_DATE (# 51)

Source Code Comments

ELECTRONIC TAX FORM CONSENT DATE: This field identifies the most recent date the Electronic Tax Form Consent Indicator was updated.

Columns Comments for PEBEMPL_ETAX_CONSENT_USER_ID (# 52)

Source Code Comments

ELECTRONIC TAX FORM CONSENT USER ID: The unique identification of the user who last updated the Electronic Tax Form Consent Indicator.

Table PEBGREV

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PEBGREV_NO   NUMBER(8,0) No *  
PEBGREV_DESC   VARCHAR2(60) No    
PEBGREV_GRTP_CODE   VARCHAR2(4) No   *
PEBGREV_ISTA_CODE   VARCHAR2(1) No   *
PEBGREV_ISTA_DATE   DATE No    
PEBGREV_FILED_DATE   DATE No    
PEBGREV_RESOLVED_DATE   DATE Yes    
PEBGREV_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
PEBGREV_GRTP_CODE PTVGRTP_CODE PTVGRTP
PEBGREV_ISTA_CODE PTVISTA_CODE PTVISTA

Index

Index Name Index Type Column Name
PK_PEBGREV Unique PEBGREV_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRPA SQL Table S10B80.PAYROLL Refer (no action)
PERGRRA SQL Table S10B80.PAYROLL Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PEBGREV SQL Index S10B80.PAYROLL Rely On
PTVGRTP SQL Table S10B80.PAYROLL Refer (no action)
PTVISTA SQL Table S10B80.PAYROLL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PEBGREV

Object Dates

Creation Date Analysis Date
04/02/2008 13:40:00:000 04/02/2008 13:49:14:000

Source Code Comments

Grievance Table.

Columns Comments for PEBGREV_NO (# 1)

Source Code Comments

GREVIANCE NUMBER: Unique identification number of this grievance.

Columns Comments for PEBGREV_DESC (# 2)

Source Code Comments

DESC: Brief description of the grievance.

Columns Comments for PEBGREV_GRTP_CODE (# 3)

Source Code Comments

GRTP CODE: Grievance Type Code associated with the grievance.

Columns Comments for PEBGREV_ISTA_CODE (# 4)

Source Code Comments

ISTA CODE: Incident Status Code associated with the grievance.

Columns Comments for PEBGREV_ISTA_DATE (# 5)

Source Code Comments

ISTA DATE: Date the status was established.

Columns Comments for PEBGREV_FILED_DATE (# 6)

Source Code Comments

FILED DATE: Date the grievance was filed.

Columns Comments for PEBGREV_RESOLVED_DATE (# 7)

Source Code Comments

RESOLVED DATE: Date the grievance was resolved.

Columns Comments for PEBGREV_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PEBHSIN

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PEBHSIN_NO   NUMBER(8,0) No *  
PEBHSIN_DESC   VARCHAR2(50) No    
PEBHSIN_INCIDENT_DATE   DATE No    
PEBHSIN_HSIL_CODE   VARCHAR2(6) Yes   *
PEBHSIN_ISTA_CODE   VARCHAR2(1) No   *
PEBHSIN_ISTA_DATE   DATE No    
PEBHSIN_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
PEBHSIN_ISTA_CODE PTVISTA_CODE PTVISTA
PEBHSIN_HSIL_CODE PTRHSIL_CODE PTRHSIL

Index

Index Name Index Type Column Name
PK_PEBHSIN Unique PEBHSIN_NO

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERHSCT SQL Table S10B80.PAYROLL Refer (no action)
PERHSIH SQL Table S10B80.PAYROLL Refer (no action)
PERHSIM SQL Table S10B80.PAYROLL Refer (no action)
PERHSIP SQL Table S10B80.PAYROLL Refer (no action)
PERHSIT SQL Table S10B80.PAYROLL Refer (no action)
PERHSRA SQL Table S10B80.PAYROLL Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PEBHSIN SQL Index S10B80.PAYROLL Rely On
PTRHSIL SQL Table S10B80.PAYROLL Refer (no action)
PTVISTA SQL Table S10B80.PAYROLL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PEBHSIN

Object Dates

Creation Date Analysis Date
04/02/2008 13:35:42:000 04/02/2008 13:49:10:000

Source Code Comments

Health and Safety Incident Table

Columns Comments for PEBHSIN_NO (# 1)

Source Code Comments

NUMBER: Unique identification number associated with this record.

Columns Comments for PEBHSIN_DESC (# 2)

Source Code Comments

DESCRIPTION: Brief description of the incident.

Columns Comments for PEBHSIN_INCIDENT_DATE (# 3)

Source Code Comments

INCIDENT DATE: The date the incident took place.

Columns Comments for PEBHSIN_HSIL_CODE (# 4)

Source Code Comments

INCIDENT LOCATION CODE: Code associated with the location of the incident.

Columns Comments for PEBHSIN_ISTA_CODE (# 5)

Source Code Comments

STATUS: Indicates the status code of the incident.

Columns Comments for PEBHSIN_ISTA_DATE (# 6)

Source Code Comments

STATUS DATE: Indicates the date that the status was changed.

Columns Comments for PEBHSIN_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERGRDS

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERGRDS_GREV_NO   NUMBER(8,0) No    
PERGRDS_TEXT   LONG Yes    
PERGRDS_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PERGRDS

Object Dates

Creation Date Analysis Date
04/02/2008 13:35:36:000 04/02/2008 13:49:09:000

Source Code Comments

Grievance Description Table

Columns Comments for PERGRDS_GREV_NO (# 1)

Source Code Comments

Grievance Number: Identification number of the grievance for this record.

Columns Comments for PERGRDS_TEXT (# 2)

Source Code Comments

Text: Free form text description of the grievance.

Columns Comments for PERGRDS_ACTIVITY_DATE (# 3)

Source Code Comments

Activity Date: Date of last modification to the record.

Table PERGRPA

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERGRPA_GREV_NO   NUMBER(8,0) No   *
PERGRPA_PIDM   NUMBER(8,0) No   *
PERGRPA_GRPT_CODE   VARCHAR2(4) No   *
PERGRPA_POSN   VARCHAR2(6) Yes   *
PERGRPA_SUFF   VARCHAR2(2) Yes   *
PERGRPA_GRIEVANT_IND   VARCHAR2(1) Yes    
PERGRPA_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
PERGRPA_PIDM NBRBJOB_PIDM NBRBJOB
PERGRPA_POSN NBRBJOB_POSN NBRBJOB
PERGRPA_SUFF NBRBJOB_SUFF NBRBJOB
PERGRPA_GRPT_CODE PTVGRPT_CODE PTVGRPT
PERGRPA_PIDM PEBEMPL_PIDM PEBEMPL
PERGRPA_GREV_NO PEBGREV_NO PEBGREV

Index

Index Name Index Type Column Name
PERGRPA_KEY_INDEX   PERGRPA_GREV_NO
PERGRPA_KEY_INDEX   PERGRPA_PIDM

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRPA_KEY_INDEX SQL Index S10B80.PAYROLL Rely On
NBRBJOB SQL Table S10B80.POSNCTL Refer (no action)
PEBEMPL SQL Table S10B80.PAYROLL Refer (no action)
PEBGREV SQL Table S10B80.PAYROLL Refer (no action)
PTVGRPT SQL Table S10B80.PAYROLL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PERGRPA

Object Dates

Creation Date Analysis Date
04/02/2008 13:36:15:000 04/02/2008 13:49:10:000

Source Code Comments

Grievance Participants Table.

Columns Comments for PERGRPA_GREV_NO (# 1)

Source Code Comments

GREVIANCE NUMBER: Identification number of the grievance this record is associated with.

Columns Comments for PERGRPA_PIDM (# 2)

Source Code Comments

PIDM: Identification number associated with a person.

Columns Comments for PERGRPA_GRPT_CODE (# 3)

Source Code Comments

GRPT CODE: Participant Type Code associated with this person.

Columns Comments for PERGRPA_POSN (# 4)

Source Code Comments

POSITION: The person's position associated with the grievance.

Columns Comments for PERGRPA_SUFF (# 5)

Source Code Comments

SUFFIX: Suffix associated with the position.

Columns Comments for PERGRPA_GRIEVANT_IND (# 6)

Source Code Comments

GRIEVANT INDICATOR: Indicates whether this person is the grievant.

Columns Comments for PERGRPA_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERGRRA

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERGRRA_GREV_NO   NUMBER(8,0) No   *
PERGRRA_GRSR_CODE   VARCHAR2(4) No   *
PERGRRA_GRSR_DATE   DATE No    
PERGRRA_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
PERGRRA_GRSR_CODE PTVGRSR_CODE PTVGRSR
PERGRRA_GREV_NO PEBGREV_NO PEBGREV

Index

Index Name Index Type Column Name
PERGRRA_KEY_INDEX   PERGRRA_GREV_NO
PERGRRA_KEY_INDEX   PERGRRA_GRSR_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRRA_KEY_INDEX SQL Index S10B80.PAYROLL Rely On
PEBGREV SQL Table S10B80.PAYROLL Refer (no action)
PTVGRSR SQL Table S10B80.PAYROLL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PERGRRA

Object Dates

Creation Date Analysis Date
04/02/2008 13:36:24:000 04/02/2008 13:49:10:000

Source Code Comments

Grievance Resulting Actions Table

Columns Comments for PERGRRA_GREV_NO (# 1)

Source Code Comments

GRIEVANCE NUMBER: Identification number of the grievance this record is associated with.

Columns Comments for PERGRRA_GRSR_CODE (# 2)

Source Code Comments

GRSR CODE: Grievance Standard Result Code associated with the grievance.

Columns Comments for PERGRRA_GRSR_DATE (# 3)

Source Code Comments

GRSR DATE: Date on which the result occurred.

Columns Comments for PERGRRA_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PERGRRE

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PERGRRE_GREV_NO   NUMBER(8,0) No    
PERGRRE_TEXT   LONG Yes    
PERGRRE_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

No Result

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

No Called objects (non escalated)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PERGRRE

Object Dates

Creation Date Analysis Date
04/02/2008 13:36:25:000 04/02/2008 13:49:10:000

Source Code Comments

Grievance Resolution Table

Columns Comments for PERGRRE_GREV_NO (# 1)

Source Code Comments

Grievance Number: Identification number of the grievance for this record.

Columns Comments for PERGRRE_TEXT (# 2)

Source Code Comments

Text: Free form text description of the resolution of the grievance.

Columns Comments for PERGRRE_ACTIVITY_DATE (# 3)

Source Code Comments

Activity Date: Date of last modification to the record.

Table PTVGRPT

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PTVGRPT_CODE   VARCHAR2(4) No *  
PTVGRPT_DESC   VARCHAR2(30) No    
PTVGRPT_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_PTVGRPT Unique PTVGRPT_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRPA SQL Table S10B80.PAYROLL Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PTVGRPT SQL Index S10B80.PAYROLL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTVGRPT

Object Dates

Creation Date Analysis Date
04/02/2008 13:35:10:000 04/02/2008 13:49:09:000

Source Code Comments

Grievance Participant Type Validation Table

Columns Comments for PTVGRPT_CODE (# 1)

Source Code Comments

CODE: Code associated with this Grievance Participant Type.

Columns Comments for PTVGRPT_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of the Grievance Participant Type.

Columns Comments for PTVGRPT_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PTVGRSR

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PTVGRSR_CODE   VARCHAR2(4) No *  
PTVGRSR_DESC   VARCHAR2(30) No    
PTVGRSR_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_PTVGRSR Unique PTVGRSR_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PERGRRA SQL Table S10B80.PAYROLL Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PTVGRSR SQL Index S10B80.PAYROLL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTVGRSR

Object Dates

Creation Date Analysis Date
04/02/2008 13:35:16:000 04/02/2008 13:49:09:000

Source Code Comments

Grievance Standard Results Validation Table

Columns Comments for PTVGRSR_CODE (# 1)

Source Code Comments

CODE: Code associated with this Grievance Result.

Columns Comments for PTVGRSR_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of the Grievance Result.

Columns Comments for PTVGRSR_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PTVGRTP

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PTVGRTP_CODE   VARCHAR2(4) No *  
PTVGRTP_DESC   VARCHAR2(30) No    
PTVGRTP_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_PTVGRTP Unique PTVGRTP_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PEBGREV SQL Table S10B80.PAYROLL Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PTVGRTP SQL Index S10B80.PAYROLL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTVGRTP

Object Dates

Creation Date Analysis Date
04/02/2008 13:35:25:000 04/02/2008 13:49:09:000

Source Code Comments

Grievance Type Validation Table

Columns Comments for PTVGRTP_CODE (# 1)

Source Code Comments

CODE: Code associated with this Grievance Type.

Columns Comments for PTVGRTP_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of the Grievance Type.

Columns Comments for PTVGRTP_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PTVISTA

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PTVISTA_CODE   VARCHAR2(1) No *  
PTVISTA_DESC   VARCHAR2(30) No    
PTVISTA_ACTIVITY_DATE   DATE No    

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_PTVISTA Unique PTVISTA_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PEBGREV SQL Table S10B80.PAYROLL Refer (no action)
PEBHSIN SQL Table S10B80.PAYROLL Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PTVISTA SQL Index S10B80.PAYROLL Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTVISTA

Object Dates

Creation Date Analysis Date
04/02/2008 13:34:38:000 04/02/2008 13:49:08:000

Source Code Comments

Incident Status Validation Table

Columns Comments for PTVISTA_CODE (# 1)

Source Code Comments

CODE: Code associated with this incident status.

Columns Comments for PTVISTA_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of the incident status.

Columns Comments for PTVISTA_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Link between NBRBJOB and PEBEMPL


Join Information

Objects list
schema-view : S10B80.BANINST1.PEVPRF1
schema-view : S10B80.BANINST1.PHVTIME
schema-view : S10B80.BANINST1.PEVRTWK
scope-cursor : S10B80.BANINST1.PEKTEEX.JOBS_CURSOR

Link List

Link Type Link Project
Join Link Between NBRBJOB and PEBEMPL POSNCTL

List of Real links

Link type Between And
Join NBRBJOB PEBEMPL

Link between PEBHSIN and PTVISTA


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PEBHSIN and PTVISTA (FK1_PEBHSIN_INV_PTVISTA_CODE) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PEBHSIN PEBHSIN_ISTA_CODE PTVISTA_CODE PTVISTA (1,1)-(0,n)

Link between PERGRPA and NBRBJOB


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PERGRPA and NBRBJOB (FK1_PERGRPA_INV_NBRBJOB_KEY) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERGRPA PERGRPA_PIDM NBRBJOB_PIDM NBRBJOB (0,1)-(0,n)
PERGRPA PERGRPA_POSN NBRBJOB_POSN NBRBJOB (0,1)-(0,n)
PERGRPA PERGRPA_SUFF NBRBJOB_SUFF NBRBJOB (0,1)-(0,n)

Link between PERGRPA and PTVGRPT


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PERGRPA and PTVGRPT (FK1_PERGRPA_INV_PTVGRPT_CODE) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERGRPA PERGRPA_GRPT_CODE PTVGRPT_CODE PTVGRPT (1,1)-(0,n)

Link between PERGRRA and PTVGRSR


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PERGRRA and PTVGRSR (FK1_PERGRRA_INV_PTVGRSR_CODE) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERGRRA PERGRRA_GRSR_CODE PTVGRSR_CODE PTVGRSR (1,1)-(0,n)

Link between PERGRPA and PEBEMPL


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PERGRPA and PEBEMPL (FK1_PERGRPA_INV_PEBEMPL_KEY) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERGRPA PERGRPA_PIDM PEBEMPL_PIDM PEBEMPL (1,1)-(0,n)

Link between PERGRPA and PEBGREV


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PERGRPA and PEBGREV (FK1_PERGRPA_INV_PEBGREV_KEY) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERGRPA PERGRPA_GREV_NO PEBGREV_NO PEBGREV (1,1)-(0,n)

Link between PERGRRA and PEBGREV


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PERGRRA and PEBGREV (FK1_PERGRRA_INV_PEBGREV_KEY) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERGRRA PERGRRA_GREV_NO PEBGREV_NO PEBGREV (1,1)-(0,n)

Link between PEBGREV and PTVGRTP


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PEBGREV and PTVGRTP (FK1_PEBGREV_INV_PTVGRTP_CODE) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PEBGREV PEBGREV_GRTP_CODE PTVGRTP_CODE PTVGRTP (1,1)-(0,n)

Link between PEBGREV and PTVISTA


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PEBGREV and PTVISTA (FK1_PEBGREV_INV_PTVISTA_CODE) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PEBGREV PEBGREV_ISTA_CODE PTVISTA_CODE PTVISTA (1,1)-(0,n)