Model Employee

Model Label : Banner HR Employee Module
Path : BANNER DEV/HR/Employee

List of Objects

Object Name	Object Type	Layer Name
NBRBJOB	TABLE	pebempl
PABAPPL	TABLE	pebempl
PDRBDED	TABLE	pebempl
PDRBFLX	TABLE	pebempl
PDRFBAL	TABLE	pebempl
PDRFCLM	TABLE	pebempl
PEBEMPL	TABLE	Default
PEBROEC	TABLE	Default
PERBARG	TABLE	pebempl
PERBFAC	TABLE	Default
PERCAPL	TABLE	Default
PERCAPR	TABLE	Default
PERDHIS	TABLE	Default
PERDIRD	TABLE	pebempl
PERDTOT	TABLE	Default
PEREHIS	TABLE	Default
PERETOT	TABLE	pebempl
PERFACC	TABLE	Default
PERFACL	TABLE	Default
PERFAPL	TABLE	Default
PERFAPR	TABLE	Default
PERGRPA	TABLE	pebempl
PERJBBG	TABLE	pebempl
PERJFAC	TABLE	Default
PERJHIS	TABLE	Default
PERJLEV	TABLE	Default
PERJLHS	TABLE	Default
PERJOBP	TABLE	Default
PERJTOT	TABLE	Default
PERLEAV	TABLE	pebempl
PERLHIS	TABLE	Default
PERLVTK	TABLE	Default
PERPADV	TABLE	Default
PERRCMT	TABLE	pebempl
PERREVW	TABLE	pebempl
PERRHOL	TABLE	pebempl
PERROTH	TABLE	pebempl
PERSAHS	TABLE	Default
PERSNBL	TABLE	Default
PERXJOB	TABLE	Default
PHRACCR	TABLE	Default
PHRHIST	TABLE	pebempl
POTPARM	TABLE	pebempl
PTRBCAT	TABLE	pebempl
PTRBCDN	TABLE	pebempl
PTRBSDD	TABLE	pebempl
PTRECLS	TABLE	pebempl
PTRJBLN	TABLE	pebempl
PTRLREA	TABLE	pebempl
PTRTREA	TABLE	pebempl
PTRWKPR	TABLE	pebempl
PTVLCAT	TABLE	pebempl
PTVNRSI	TABLE	pebempl
PTVSTGR	TABLE	pebempl
SORDEGR	TABLE	pebempl
SPBPERS	TABLE	pebempl
SPRIDEN	TABLE	pebempl

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 PABAPPL

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 07/30/2003 15:18:53:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
PABAPPL_PIDM	PABAPPL_PIDM	NUMBER(8,0)	No	*
PABAPPL_PIDM	PABAPPL_PIDM	NUMBER(8,0)	No	*
PABAPPL_PIDM	PABAPPL_PIDM	NUMBER(8,0)	No	*
PABAPPL_DATE	PABAPPL_DATE	DATE	No
PABAPPL_FULL_PART_IND	PABAPPL_FULL_PART_IND	VARCHAR2(1)	Yes
PABAPPL_ESKL_CODE	PABAPPL_ESKL_CODE	VARCHAR2(2)	Yes	*
PABAPPL_ASRC_CODE	PABAPPL_ASRC_CODE	VARCHAR2(2)	No	*
PABAPPL_DESIRED_SALARY	PABAPPL_DESIRED_SALARY	NUMBER(11,2)	Yes
PABAPPL_ACTIVITY_DATE	PABAPPL_ACTIVITY_DATE	DATE	No
PABAPPL_REQ_NO	PABAPPL_REQ_NO	VARCHAR2(10)	Yes	*
PABAPPL_POSN	PABAPPL_POSN	VARCHAR2(6)	Yes	*
PABAPPL_POSN	PABAPPL_POSN	VARCHAR2(6)	Yes	*
PABAPPL_PCLS_CODE	PABAPPL_PCLS_CODE	VARCHAR2(5)	No	*
PABAPPL_DESIRED_HOURLY	PABAPPL_DESIRED_HOURLY	NUMBER(11,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
PABAPPL_ASRC_CODE	PTVASRC_CODE	PTVASRC
PABAPPL_PCLS_CODE	NTRPCLS_CODE	NTRPCLS
PABAPPL_ESKL_CODE	PTVESKL_CODE	PTVESKL
PABAPPL_POSN	NBBPOSN_POSN	NBBPOSN
PABAPPL_PIDM	SPRIDEN_PIDM	SPRIDEN
PABAPPL_PIDM	SPBPERS_PIDM	SPBPERS
PABAPPL_REQ_NO	PABREQU_REQ_NO	PABREQU
PABAPPL_POSN	PABREQU_POSN	PABREQU
PABAPPL_PIDM	PEBEMPL_PIDM	PEBEMPL

Index

Index Name	Index Type	Column Name
PABAPPL_KEY2_INDEX		PABAPPL_REQ_NO
PABAPPL_KEY2_INDEX		PABAPPL_PIDM
PABAPPL_KEY3_INDEX		PABAPPL_POSN
PABAPPL_KEY3_INDEX		PABAPPL_PIDM
PABAPPL_KEY_INDEX	Unique	PABAPPL_PIDM
PABAPPL_KEY_INDEX	Unique	PABAPPL_REQ_NO
PABAPPL_KEY_INDEX	Unique	PABAPPL_POSN
PABAPPL_KEY_INDEX	Unique	PABAPPL_PCLS_CODE

Comments

Source Code Comments

Applicant Base Table

Columns Comments for PABAPPL_PIDM (1)

Source Code Comments

PIDM: Internal person identification number.

Columns Comments for PABAPPL_DATE (2)

Source Code Comments

DATE: Date of application.

Columns Comments for PABAPPL_FULL_PART_IND (3)

Source Code Comments

FULLTIME PARTTIME INDICATOR: Indicates whether the applicant wishes to work parttime of fulltime.

Columns Comments for PABAPPL_ESKL_CODE (4)

Source Code Comments

EEO SKILL CODE: EEO skill code associated with this applicant.

Columns Comments for PABAPPL_ASRC_CODE (5)

Source Code Comments

APPLICANT SOURCE CODE: Source where applicant found out about job opening.

Columns Comments for PABAPPL_DESIRED_SALARY (6)

Source Code Comments

DESIRED SALARY: Annual salary applicant desires.

Columns Comments for PABAPPL_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: Date the record was inserted or last updated.

Columns Comments for PABAPPL_REQ_NO (8)

Source Code Comments

REQUISITION NUMBER: Requisition number of the Position Class and Position Number.

Columns Comments for PABAPPL_POSN (9)

Source Code Comments

POSITION NUMBER: The position associated with this applicant entry.

Columns Comments for PABAPPL_PCLS_CODE (10)

Source Code Comments

POSITION CLASS CODE: Position Class associated with this applicant entry.

Columns Comments for PABAPPL_DESIRED_HOURLY (11)

Source Code Comments

DESIRED HOURLY RATE: Hourly rate applicant desires.

Table PDRBDED

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

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
PDRBDED_PIDM	PDRBDED_PIDM	NUMBER(8,0)	No	*	*
PDRBDED_BDCA_CODE	PDRBDED_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRBDED_BDCA_CODE	PDRBDED_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRBDED_BDCA_CODE	PDRBDED_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRBDED_BDCA_CODE	PDRBDED_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRBDED_BDCA_CODE	PDRBDED_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRBDED_BDCA_CODE	PDRBDED_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRBDED_ADD_REPL_IND	PDRBDED_ADD_REPL_IND	VARCHAR2(1)	Yes
PDRBDED_ADD_REPL_EMPL	PDRBDED_ADD_REPL_EMPL	NUMBER(11,2)	Yes
PDRBDED_ADD_REPL_EMPR	PDRBDED_ADD_REPL_EMPR	NUMBER(11,2)	Yes
PDRBDED_ADD_REPL_TAX_BASE	PDRBDED_ADD_REPL_TAX_BASE	NUMBER(11,2)	Yes
PDRBDED_ARR_STATUS	PDRBDED_ARR_STATUS	VARCHAR2(1)	Yes
PDRBDED_ARR_BALANCE	PDRBDED_ARR_BALANCE	NUMBER(11,2)	Yes
PDRBDED_BOND_BALANCE	PDRBDED_BOND_BALANCE	NUMBER(11,2)	Yes
PDRBDED_BEGIN_DATE	PDRBDED_BEGIN_DATE	DATE	No
PDRBDED_END_DATE	PDRBDED_END_DATE	DATE	Yes
PDRBDED_ACTIVITY_DATE	PDRBDED_ACTIVITY_DATE	DATE	No
PDRBDED_ARR_RECOVER_MAX	PDRBDED_ARR_RECOVER_MAX	NUMBER(11,2)	Yes
PDRBDED_ADD_REPL_PICT_CODE	PDRBDED_ADD_REPL_PICT_CODE	VARCHAR2(2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
PDRBDED_PIDM	PEBEMPL_PIDM	PEBEMPL
PDRBDED_BDCA_CODE	PTRBDCA_CODE	PTRBDCA
PDRBDED_BDCA_CODE	PTRBDGM_BDCA_CODE	PTRBDGM
PDRBDED_BDCA_CODE	PTRBDPD_BDCA_CODE	PTRBDPD
PDRBDED_BDCA_CODE	PTRBDPD_CODE	PTRBDPD
PDRBDED_BDCA_CODE	PTRBDCG_BDCA_CODE	PTRBDCG
PDRBDED_BDCA_CODE	PTRBDCG_CODE	PTRBDCG

Index

Index Name	Index Type	Column Name
PK_PDRBDED	Unique	PDRBDED_PIDM
PK_PDRBDED	Unique	PDRBDED_BDCA_CODE

Comments

Source Code Comments

Employee Deduction Repeating Base Table

Columns Comments for PDRBDED_PIDM (1)

Source Code Comments

PIDM: Internal System Indentification Number.

Columns Comments for PDRBDED_BDCA_CODE (2)

Source Code Comments

BENEFIT/DEDUCTION CODE: The code which identifies the benefit/deduction.

Columns Comments for PDRBDED_ADD_REPL_IND (3)

Source Code Comments

ADD/REPLACE INDICATOR: Indicates whether the amount is to be added to the employees normal deduction or replaces the employees normal deduction.

Columns Comments for PDRBDED_ADD_REPL_EMPL (4)

Source Code Comments

ADD/REPLACE EMPLOYEE: The employe amount to either add to the normal deduction or replace the normal deduction.

Columns Comments for PDRBDED_ADD_REPL_EMPR (5)

Source Code Comments

ADD/REPLACE EMPLOYER: The employer amount to either add to the normal employer deduction or replace the employer deduction.

Columns Comments for PDRBDED_ADD_REPL_TAX_BASE (6)

Source Code Comments

APPLICABLE GROSS: The applicable gross to be used with the add/replace amount.

Columns Comments for PDRBDED_ARR_STATUS (7)

Source Code Comments

ARREARS STATUS: The ststus of the arrears.

Columns Comments for PDRBDED_ARR_BALANCE (8)

Source Code Comments

ARREARS BALANCE: The arrears balance due the employer.

Columns Comments for PDRBDED_BOND_BALANCE (9)

Source Code Comments

BOND BALANCE: If the deduction is for savings bonds this field contains the balance available toward the purchase of a bond.

Columns Comments for PDRBDED_BEGIN_DATE (10)

Source Code Comments

BENEFIT/DEDUCTION BEGIN DATE: The date the benefit/deduction begins.

Columns Comments for PDRBDED_END_DATE (11)

Source Code Comments

BENEFIT/DEDUCTION END DATE: The date the benefit/deduction ends.

Columns Comments for PDRBDED_ACTIVITY_DATE (12)

Source Code Comments

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

Columns Comments for PDRBDED_ARR_RECOVER_MAX (13)

Source Code Comments

MAXIMUM ARREARS RECOVERY: The maximum amount of arrears allowed to be recovered in a pay event.

Columns Comments for PDRBDED_ADD_REPL_PICT_CODE (14)

Source Code Comments

The Payroll ID where this benefit/deduction override should be applied.

Table PDRBFLX

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

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
PDRBFLX_PIDM	PDRBFLX_PIDM	NUMBER(8,0)	No	*	*
PDRBFLX_FLEX_AMT	PDRBFLX_FLEX_AMT	NUMBER(11,2)	Yes
PDRBFLX_ACTIVITY_DATE	PDRBFLX_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PDRBFLX_PIDM	PEBEMPL_PIDM	PEBEMPL

Index

Index Name	Index Type	Column Name
PK_PDRBFLX	Unique	PDRBFLX_PIDM

Comments

Source Code Comments

Flex Benefit Base Table

Columns Comments for PDRBFLX_PIDM (1)

Source Code Comments

PIDM: Internal person identification number.

Columns Comments for PDRBFLX_FLEX_AMT (2)

Source Code Comments

FLEX AMOUNT: Employee available flex amount.

Columns Comments for PDRBFLX_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date the record was inserted or last updated.

Table PDRFBAL

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

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
PDRFBAL_PLAN_YEAR	PDRFBAL_PLAN_YEAR	NUMBER(4,0)	No
PDRFBAL_PIDM	PDRFBAL_PIDM	NUMBER(8,0)	No	*
PDRFBAL_PIDM	PDRFBAL_PIDM	NUMBER(8,0)	No	*
PDRFBAL_BDCA_CODE	PDRFBAL_BDCA_CODE	VARCHAR2(3)	No	*
PDRFBAL_PLAN_CODE	PDRFBAL_PLAN_CODE	VARCHAR2(2)	Yes
PDRFBAL_AMOUNT_AVAIL	PDRFBAL_AMOUNT_AVAIL	NUMBER(11,2)	Yes
PDRFBAL_AMOUNT_SPENT	PDRFBAL_AMOUNT_SPENT	NUMBER(11,2)	Yes
PDRFBAL_ACTIVITY_DATE	PDRFBAL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PDRFBAL_PIDM	PEBEMPL_PIDM	PEBEMPL
PDRFBAL_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN
PDRFBAL_PIDM	PDRDEDN_PIDM	PDRDEDN

Index

Index Name	Index Type	Column Name
PDRFBAL_KEY_INDEX	Unique	PDRFBAL_PLAN_YEAR
PDRFBAL_KEY_INDEX	Unique	PDRFBAL_PIDM
PDRFBAL_KEY_INDEX	Unique	PDRFBAL_BDCA_CODE
PDRFBAL_KEY_INDEX	Unique	PDRFBAL_PLAN_CODE

Comments

Source Code Comments

Employee Flexible Benefits Balance Table

Columns Comments for PDRFBAL_PLAN_YEAR (1)

Source Code Comments

Benefit Plan Year.

Columns Comments for PDRFBAL_PIDM (2)

Source Code Comments

Employee Identification Number.

Columns Comments for PDRFBAL_BDCA_CODE (3)

Source Code Comments

Flexible Spending Account code.

Columns Comments for PDRFBAL_PLAN_CODE (4)

Source Code Comments

Flexible Spending Account plan code.

Columns Comments for PDRFBAL_AMOUNT_AVAIL (5)

Source Code Comments

Total amount available for this account.

Columns Comments for PDRFBAL_AMOUNT_SPENT (6)

Source Code Comments

Total amount spent for this account.

Columns Comments for PDRFBAL_ACTIVITY_DATE (7)

Source Code Comments

Date of Last Modification of the Record.

Table PDRFCLM

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

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
PDRFCLM_PIDM	PDRFCLM_PIDM	NUMBER(8,0)	No	*
PDRFCLM_PIDM	PDRFCLM_PIDM	NUMBER(8,0)	No	*
PDRFCLM_BDCA_CODE	PDRFCLM_BDCA_CODE	VARCHAR2(3)	No	*
PDRFCLM_PLAN_CODE	PDRFCLM_PLAN_CODE	VARCHAR2(2)	Yes
PDRFCLM_CLAIM_DATE	PDRFCLM_CLAIM_DATE	DATE	No
PDRFCLM_REF_NO	PDRFCLM_REF_NO	VARCHAR2(10)	Yes
PDRFCLM_CLAIM_AMT	PDRFCLM_CLAIM_AMT	NUMBER(11,2)	Yes
PDRFCLM_CLAIM_PAID	PDRFCLM_CLAIM_PAID	NUMBER(11,2)	Yes
PDRFCLM_ACTIVITY_DATE	PDRFCLM_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PDRFCLM_PIDM	PEBEMPL_PIDM	PEBEMPL
PDRFCLM_PIDM	PDRDEDN_PIDM	PDRDEDN
PDRFCLM_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN

Index

Index Name	Index Type	Column Name
PDRFCLM_KEY_INDEX	Unique	PDRFCLM_PIDM
PDRFCLM_KEY_INDEX	Unique	PDRFCLM_BDCA_CODE
PDRFCLM_KEY_INDEX	Unique	PDRFCLM_PLAN_CODE
PDRFCLM_KEY_INDEX	Unique	PDRFCLM_CLAIM_DATE

Comments

Source Code Comments

Employee Flexible Benefits Claims Table

Columns Comments for PDRFCLM_PIDM (1)

Source Code Comments

Employee Identification Number.

Columns Comments for PDRFCLM_BDCA_CODE (2)

Source Code Comments

Flexible Spending Account code.

Columns Comments for PDRFCLM_PLAN_CODE (3)

Source Code Comments

Flexible Spending Account plan code.

Columns Comments for PDRFCLM_CLAIM_DATE (4)

Source Code Comments

Date of claim.

Columns Comments for PDRFCLM_REF_NO (5)

Source Code Comments

Reference number of claim.

Columns Comments for PDRFCLM_CLAIM_AMT (6)

Source Code Comments

Amount of claim that will be paid.

Columns Comments for PDRFCLM_CLAIM_PAID (7)

Source Code Comments

Date of Last Modification of the Record.

Columns Comments for PDRFCLM_ACTIVITY_DATE (8)

Source Code Comments

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

Table PEBEMPL

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 07/30/2003 15:18:53:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
PEBEMPL_PIDM	PEBEMPL_PIDM	NUMBER(8,0)	No	*	*
PEBEMPL_EMPL_STATUS	PEBEMPL_EMPL_STATUS	VARCHAR2(1)	No
PEBEMPL_COAS_CODE_HOME	PEBEMPL_COAS_CODE_HOME	VARCHAR2(1)	Yes
PEBEMPL_ORGN_CODE_HOME	PEBEMPL_ORGN_CODE_HOME	VARCHAR2(6)	No		*
PEBEMPL_COAS_CODE_DIST	PEBEMPL_COAS_CODE_DIST	VARCHAR2(1)	Yes
PEBEMPL_ORGN_CODE_DIST	PEBEMPL_ORGN_CODE_DIST	VARCHAR2(6)	No		*
PEBEMPL_ECLS_CODE	PEBEMPL_ECLS_CODE	VARCHAR2(2)	No		*
PEBEMPL_LCAT_CODE	PEBEMPL_LCAT_CODE	VARCHAR2(2)	No		*
PEBEMPL_BCAT_CODE	PEBEMPL_BCAT_CODE	VARCHAR2(2)	No		*
PEBEMPL_FIRST_HIRE_DATE	PEBEMPL_FIRST_HIRE_DATE	DATE	No
PEBEMPL_CURRENT_HIRE_DATE	PEBEMPL_CURRENT_HIRE_DATE	DATE	No
PEBEMPL_ADJ_SERVICE_DATE	PEBEMPL_ADJ_SERVICE_DATE	DATE	No
PEBEMPL_SENIORITY_DATE	PEBEMPL_SENIORITY_DATE	DATE	No
PEBEMPL_LREA_CODE	PEBEMPL_LREA_CODE	VARCHAR2(2)	Yes
PEBEMPL_LOA_BEG_DATE	PEBEMPL_LOA_BEG_DATE	DATE	Yes
PEBEMPL_LOA_END_DATE	PEBEMPL_LOA_END_DATE	DATE	Yes
PEBEMPL_TREA_CODE	PEBEMPL_TREA_CODE	VARCHAR2(2)	Yes		*
PEBEMPL_TERM_DATE	PEBEMPL_TERM_DATE	DATE	Yes
PEBEMPL_I9_FORM_IND	PEBEMPL_I9_FORM_IND	VARCHAR2(1)	Yes
PEBEMPL_I9_DATE	PEBEMPL_I9_DATE	DATE	Yes
PEBEMPL_I9_EXPIRE_DATE	PEBEMPL_I9_EXPIRE_DATE	DATE	Yes
PEBEMPL_ACTIVITY_DATE	PEBEMPL_ACTIVITY_DATE	DATE	No
PEBEMPL_WKPR_CODE	PEBEMPL_WKPR_CODE	VARCHAR2(4)	Yes		*
PEBEMPL_FLSA_IND	PEBEMPL_FLSA_IND	VARCHAR2(1)	No
PEBEMPL_STGR_CODE	PEBEMPL_STGR_CODE	VARCHAR2(2)	Yes		*
PEBEMPL_DAYS_IN_CANADA	PEBEMPL_DAYS_IN_CANADA	NUMBER(3,0)	Yes
PEBEMPL_1042_RECIPIENT_CD	PEBEMPL_1042_RECIPIENT_CD	VARCHAR2(2)	Yes
PEBEMPL_INTERNAL_FT_PT_IND	PEBEMPL_INTERNAL_FT_PT_IND	VARCHAR2(1)	No
PEBEMPL_DICD_CODE	PEBEMPL_DICD_CODE	VARCHAR2(3)	Yes
PEBEMPL_EGRP_CODE	PEBEMPL_EGRP_CODE	VARCHAR2(4)	Yes
PEBEMPL_IPEDS_SOFT_MONEY_IND	PEBEMPL_IPEDS_SOFT_MONEY_IND	VARCHAR2(1)	Yes
PEBEMPL_FIRST_WORK_DATE	PEBEMPL_FIRST_WORK_DATE	DATE	Yes
PEBEMPL_LAST_WORK_DATE	PEBEMPL_LAST_WORK_DATE	DATE	Yes
PEBEMPL_CALIF_PENSION_IND	PEBEMPL_CALIF_PENSION_IND	VARCHAR2(1)	Yes
PEBEMPL_NRSI_CODE	PEBEMPL_NRSI_CODE	VARCHAR2(4)	Yes		*
PEBEMPL_SSN_LAST_NAME	PEBEMPL_SSN_LAST_NAME	VARCHAR2(20)	Yes
PEBEMPL_SSN_FIRST_NAME	PEBEMPL_SSN_FIRST_NAME	VARCHAR2(15)	Yes
PEBEMPL_SSN_MI	PEBEMPL_SSN_MI	VARCHAR2(15)	Yes
PEBEMPL_SSN_SUFFIX	PEBEMPL_SSN_SUFFIX	VARCHAR2(4)	Yes
PEBEMPL_JBLN_CODE	PEBEMPL_JBLN_CODE	VARCHAR2(6)	Yes		*
PEBEMPL_COLL_CODE	PEBEMPL_COLL_CODE	VARCHAR2(2)	Yes		*
PEBEMPL_CAMP_CODE	PEBEMPL_CAMP_CODE	VARCHAR2(3)	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_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

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

Comments

Source Code Comments

Employee Base Table

Columns Comments for PEBEMPL_PIDM (1)

Source Code Comments

PIDM: Internal System Identification Number.

Columns Comments for PEBEMPL_EMPL_STATUS (2)

Source Code Comments

EMPLOYEE STATUS: The status of the employee.

Columns Comments for PEBEMPL_COAS_CODE_HOME (3)

Source Code Comments

CHART OF ACCOUNTS CODE HOME: The home Chart of Accounts Code for the employee.

Columns Comments for PEBEMPL_ORGN_CODE_HOME (4)

Source Code Comments

HOME ORGANIZATION CODE: The home organization code of the employee.

Columns Comments for PEBEMPL_COAS_CODE_DIST (5)

Source Code Comments

CHART OF ACCOUNTS CODE DISTRIBUTION: The Chart of Accounts Code to which this emplyees labor is distributed.

Columns Comments for PEBEMPL_ORGN_CODE_DIST (6)

Source Code Comments

ORGANIZATION CODE DISTRIBUTION: The organization code used for labor distribution.