Model Employee COBRA

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

List of Objects

Object Name	Object Type	Layer Name
PDRBDED	TABLE	Default
PDRDEDN	TABLE	Default
PDRFBAL	TABLE	Default
PDRFCLM	TABLE	Default
PDRFLEX	TABLE	Default
PEBEMPL	TABLE	Default

Comments

Model View

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 PDRDEDN

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
PDRDEDN_PIDM	PDRDEDN_PIDM	NUMBER(8,0)	No	*	*
PDRDEDN_BDCA_CODE	PDRDEDN_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRDEDN_BDCA_CODE	PDRDEDN_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRDEDN_EFFECTIVE_DATE	PDRDEDN_EFFECTIVE_DATE	DATE	No	*	*
PDRDEDN_STATUS	PDRDEDN_STATUS	VARCHAR2(1)	No
PDRDEDN_REF_NO	PDRDEDN_REF_NO	VARCHAR2(10)	Yes
PDRDEDN_AMOUNT1	PDRDEDN_AMOUNT1	NUMBER(11,2)	Yes
PDRDEDN_AMOUNT2	PDRDEDN_AMOUNT2	NUMBER(11,2)	Yes
PDRDEDN_AMOUNT3	PDRDEDN_AMOUNT3	NUMBER(11,2)	Yes
PDRDEDN_AMOUNT4	PDRDEDN_AMOUNT4	NUMBER(11,2)	Yes
PDRDEDN_OPT_CODE1	PDRDEDN_OPT_CODE1	VARCHAR2(2)	Yes
PDRDEDN_OPT_CODE2	PDRDEDN_OPT_CODE2	VARCHAR2(2)	Yes
PDRDEDN_OPT_CODE3	PDRDEDN_OPT_CODE3	VARCHAR2(2)	Yes
PDRDEDN_OPT_CODE4	PDRDEDN_OPT_CODE4	VARCHAR2(2)	Yes
PDRDEDN_OPT_CODE5	PDRDEDN_OPT_CODE5	VARCHAR2(2)	Yes
PDRDEDN_ACTIVITY_DATE	PDRDEDN_ACTIVITY_DATE	DATE	No
PDRDEDN_COVERAGE_DATE	PDRDEDN_COVERAGE_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
PDRDEDN_BDCA_CODE	PDRBDED_BDCA_CODE	PDRBDED
PDRDEDN_PIDM	PDRBDED_PIDM	PDRBDED
PDRDEDN_EFFECTIVE_DATE	PDRBDED_BEGIN_DATE	PDRBDED
PDRDEDN_BDCA_CODE	PTRBDPD_CODE	PTRBDPD

Index

Index Name	Index Type	Column Name
PDRDEDN_KEY2_INDEX		PDRDEDN_BDCA_CODE
PDRDEDN_KEY2_INDEX		PDRDEDN_OPT_CODE1
PDRDEDN_KEY2_INDEX		PDRDEDN_EFFECTIVE_DATE
PK_PDRDEDN	Unique	PDRDEDN_PIDM
PK_PDRDEDN	Unique	PDRDEDN_BDCA_CODE
PK_PDRDEDN	Unique	PDRDEDN_EFFECTIVE_DATE

Comments

Source Code Comments

Employee Deduction Repeating Table

Columns Comments for PDRDEDN_PIDM (1)

Source Code Comments

PIDM : Internal System Identification Number.

Columns Comments for PDRDEDN_BDCA_CODE (2)

Source Code Comments

BENEFIT/DEDUCTION CODE: The code assigned to the benefit/deduction.

Columns Comments for PDRDEDN_EFFECTIVE_DATE (3)

Source Code Comments

EFFECTIVE DATE: The date the benefit/deduction becomes effective.

Columns Comments for PDRDEDN_STATUS (4)

Source Code Comments

STATUS: The status of the benefit/deduction.

Columns Comments for PDRDEDN_REF_NO (5)

Source Code Comments

REFERENCE NUMBER: An optional alpha/numeric field.

Columns Comments for PDRDEDN_AMOUNT1 (6)

Source Code Comments

AMOUNT 1: The first amount field for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/deduction.

Columns Comments for PDRDEDN_AMOUNT2 (7)

Source Code Comments

AMOUNT 2: The second amount field for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/deduction.

Columns Comments for PDRDEDN_AMOUNT3 (8)

Source Code Comments

AMOUNT 3: The third amount field for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/deduction.

Columns Comments for PDRDEDN_AMOUNT4 (9)

Source Code Comments

AMOUNT 4: The fourth amount field for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/deduction.

Columns Comments for PDRDEDN_OPT_CODE1 (10)

Source Code Comments

OPTION CODE 1: The first option code for the benefit/deduction code. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.

Columns Comments for PDRDEDN_OPT_CODE2 (11)

Source Code Comments

OPTION CODE 2: The second option code for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.

Columns Comments for PDRDEDN_OPT_CODE3 (12)

Source Code Comments

OPTION CODE 3: The third option code for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.

Columns Comments for PDRDEDN_OPT_CODE4 (13)

Source Code Comments

OPTION CODE 4: The fourth option code for the benefit/deduction. The use of option code is determined by the calculation rule assigned to the benefit/ deduction.

Columns Comments for PDRDEDN_OPT_CODE5 (14)

Source Code Comments

OPTION CODE 5: The fifth option code for the benefit/deduction code. The use of the field is determined by the calculation rule assigned to the benefit/ deduction code.

Columns Comments for PDRDEDN_ACTIVITY_DATE (15)

Source Code Comments

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

Columns Comments for PDRDEDN_COVERAGE_DATE (16)

Source Code Comments

COVERAGE DATE; Set equal to benefit/deduction begin date via the Employee Benefit/Deduction Setup Form. Currently not utilized

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 PDRFLEX

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
PDRFLEX_PIDM	PDRFLEX_PIDM	NUMBER(8,0)	No
PDRFLEX_BDCA_CODE	PDRFLEX_BDCA_CODE	VARCHAR2(3)	No
PDRFLEX_PLAN_CODE	PDRFLEX_PLAN_CODE	VARCHAR2(2)	Yes
PDRFLEX_STATUS	PDRFLEX_STATUS	VARCHAR2(1)	No
PDRFLEX_START_DATE	PDRFLEX_START_DATE	DATE	No
PDRFLEX_END_DATE	PDRFLEX_END_DATE	DATE	Yes
PDRFLEX_AMOUNT1	PDRFLEX_AMOUNT1	NUMBER(11,2)	Yes
PDRFLEX_AMOUNT2	PDRFLEX_AMOUNT2	NUMBER(11,2)	Yes
PDRFLEX_AMOUNT3	PDRFLEX_AMOUNT3	NUMBER(11,2)	Yes
PDRFLEX_AMOUNT4	PDRFLEX_AMOUNT4	NUMBER(11,2)	Yes
PDRFLEX_LIF_OVR_UDR_AMT	PDRFLEX_LIF_OVR_UDR_AMT	NUMBER(11,2)	Yes
PDRFLEX_APPR_IND	PDRFLEX_APPR_IND	VARCHAR2(1)	Yes
PDRFLEX_PROCESS_IND	PDRFLEX_PROCESS_IND	VARCHAR2(1)	Yes
PDRFLEX_ACTIVITY_DATE	PDRFLEX_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PDRFLEX_KEY2_INDEX		PDRFLEX_APPR_IND
PDRFLEX_KEY2_INDEX		PDRFLEX_PROCESS_IND
PDRFLEX_KEY2_INDEX		PDRFLEX_STATUS
PDRFLEX_KEY_INDEX	Unique	PDRFLEX_PIDM
PDRFLEX_KEY_INDEX	Unique	PDRFLEX_BDCA_CODE
PDRFLEX_KEY_INDEX	Unique	PDRFLEX_PLAN_CODE
PDRFLEX_KEY_INDEX	Unique	PDRFLEX_STATUS
PDRFLEX_KEY_INDEX	Unique	PDRFLEX_START_DATE

Comments

Source Code Comments

Employee Flexible Benefits Table

Columns Comments for PDRFLEX_PIDM (1)

Source Code Comments

Internal ID code.

Columns Comments for PDRFLEX_BDCA_CODE (2)

Source Code Comments

Flexible Benefit Code.

Columns Comments for PDRFLEX_PLAN_CODE (3)

Source Code Comments

Flexible Benefit Plan.

Columns Comments for PDRFLEX_STATUS (4)

Source Code Comments

Status: The flexible benefit/deduction status.

Columns Comments for PDRFLEX_START_DATE (5)

Source Code Comments

Start Date: The start date of the Benefit/Deduction code.

Columns Comments for PDRFLEX_END_DATE (6)

Source Code Comments

End Date: Then end date of the Benefit/Deduction code.

Columns Comments for PDRFLEX_AMOUNT1 (7)

Source Code Comments

Amount 1

Columns Comments for PDRFLEX_AMOUNT2 (8)

Source Code Comments

Amount 2

Columns Comments for PDRFLEX_AMOUNT3 (9)

Source Code Comments

Amount 3

Columns Comments for PDRFLEX_AMOUNT4 (10)

Source Code Comments

Amount 4

Columns Comments for PDRFLEX_LIF_OVR_UDR_AMT (11)

Source Code Comments

Flexible Amount: This field holds the flexible amounts for Life Insurance and the Overage/Underage code that is created.

Columns Comments for PDRFLEX_APPR_IND (12)

Source Code Comments

Approved Indicator.

Columns Comments for PDRFLEX_PROCESS_IND (13)

Source Code Comments

Process Indicator: This field indicates if the flexible deductions have been inserted into the employee deduction table (PDRDEDN).

Columns Comments for PDRFLEX_ACTIVITY_DATE (14)

Source Code Comments

Date of Last Modification of the 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.

Columns Comments for PEBEMPL_ECLS_CODE (7)

Source Code Comments

EMPLOYEE CLASS CODE: The employee grouping to which the employee belongs.

Columns Comments for PEBEMPL_LCAT_CODE (8)

Source Code Comments

LEAVE CATEGORY CODE: The leave category to which the employee belongs.

Columns Comments for PEBEMPL_BCAT_CODE (9)

Source Code Comments

BENEFIT CATEGORY CODE: The benefit category to which the employee belongs.

Columns Comments for PEBEMPL_FIRST_HIRE_DATE (10)

Source Code Comments

FIRST HIRE DATE: The date the employee was first hired.

Columns Comments for PEBEMPL_CURRENT_HIRE_DATE (11)

Source Code Comments

CURRENT HIRE DATE: The employees current date of hire.

Columns Comments for PEBEMPL_ADJ_SERVICE_DATE (12)

Source Code Comments

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

Columns Comments for PEBEMPL_SENIORITY_DATE (13)

Source Code Comments

SENIORITY DATE: Currently not used by system. Reserved for future use.

Columns Comments for PEBEMPL_LREA_CODE (14)

Source Code Comments

LEAVE REASON CODE: A code identifying the reason of the leave of absence for the employee.

Columns Comments for PEBEMPL_LOA_BEG_DATE (15)

Source Code Comments

LEAVE OF ABSENCE BEGIN DATE: 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

TERMINATION REASON CODE: Code used to identify the reason of termination.

Columns Comments for PEBEMPL_TERM_DATE (18)

Source Code Comments

TERMINATION DATE: Termination date of the employee.

Columns Comments for PEBEMPL_I9_FORM_IND (19)

Source Code Comments

I9 FORM INDICATOR: Indicates whether or not immigration information has been received.

Columns Comments for PEBEMPL_I9_DATE (20)

Source Code Comments

I9 DATE: The date immigration information was received.

Columns Comments for PEBEMPL_I9_EXPIRE_DATE (21)

Source Code Comments

I9 EXPIRATION DATE: 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

WKPR_CODE: Work Period Code

Columns Comments for PEBEMPL_FLSA_IND (24)

Source Code Comments

FLSA INDICATOR: Used for Fair Labor Overtime compensation. (C)ash, (A)ccrual or (N)o FLSA.

Columns Comments for PEBEMPL_STGR_CODE (25)

Source Code Comments

STGR_CODE: Statistics Canada Grouping Code.

Columns Comments for PEBEMPL_DAYS_IN_CANADA (26)

Source Code Comments

DAYS IN CANADA: Number of days employee worked in Canada.

Columns Comments for PEBEMPL_1042_RECIPIENT_CD (27)

Source Code Comments

1042 RECIPIENT CODE: Identifies the type of individual who is receiving this 1042 statement.

Columns Comments for PEBEMPL_INTERNAL_FT_PT_IND (28)

Source Code Comments

Internal Part Time/Full Time Indicator, used for EEO reporting.

Columns Comments for PEBEMPL_DICD_CODE (29)

Source Code Comments

DISTRICT/DIVISION CODE: The district or division associated with an employee.

Columns Comments for PEBEMPL_EGRP_CODE (30)

Source Code Comments

EMPLOYEE GROUP CODE: An employee classification which is broken down into employee classes.

Columns Comments for PEBEMPL_IPEDS_SOFT_MONEY_IND (31)

Source Code Comments

IPEDS Soft Money Indicator.

Columns Comments for PEBEMPL_FIRST_WORK_DATE (32)

Source Code Comments

The first day that employee worked.

Columns Comments for PEBEMPL_LAST_WORK_DATE (33)

Source Code Comments

The last day that employee worked.

Columns Comments for PEBEMPL_CALIF_PENSION_IND (34)

Source Code Comments

California Pension Indicator.

Columns Comments for PEBEMPL_NRSI_CODE (35)

Source Code Comments

NRSI CODE:Non-resident Service Code.

Columns Comments for PEBEMPL_SSN_LAST_NAME (36)

Source Code Comments

Social security last name used in regulatory.

Columns Comments for PEBEMPL_SSN_FIRST_NAME (37)

Source Code Comments

Social security first name used in regulatory.

Columns Comments for PEBEMPL_SSN_MI (38)

Source Code Comments

Social security middle name used in regulatory.

Columns Comments for PEBEMPL_SSN_SUFFIX (39)

Source Code Comments

Social security name suffix used in regulatory.

Columns Comments for PEBEMPL_JBLN_CODE (40)

Source Code Comments

LOCATION CODE: The Location to which the employee belongs.

Columns Comments for PEBEMPL_COLL_CODE (41)

Source Code Comments

COLLEGE CODE: The College to which the employee belongs.

Columns Comments for PEBEMPL_CAMP_CODE (42)

Source Code Comments

CAMPUS CODE: The Campus to which the employee belongs.

Link between PDRDEDN and PDRBDED

Caller : PDRDEDN
Called : PDRBDED

Join Information

Objects list

schema-function : MALDEV8_B60.BANINST1.F_DEDUCTION_ROWID
schema-view : MALDEV8_B60.BANINST1.PDVDEDD
schema-view : MALDEV8_B60.BANINST1.PDVDEDN
scope-cursor : MALDEV8_B60.BANINST1.BWPKDBCV.PDRBDEDCOVERAGESC
scope-cursor : MALDEV8_B60.BANINST1.BWPKDBCV.PDRBDEDC
scope-function : MALDEV8_B60.BANINST1.BWPKDBCV.F_GETDEDNSTATUS
scope-cursor : MALDEV8_B60.BANINST1.PDKLIBS.DEDNPRECLUDESC
scope-cursor : MALDEV8_B60.BANINST1.PDKLIBS.PDRDEDNRANGECOUNTC
scope-procedure : MALDEV8_B60.BANINST1.PDKLIBS.P_VERIFYCOREBDCAEMP
scope-procedure : MALDEV8_B60.BANINST1.NOKPLIB.P_EDIT_PEBEMPL_BCAT_CODE
scope-procedure : MALDEV8_B60.BANINST1.PDKDEDN.P_CHECK_PRECLUSION
scope-function : MALDEV8_B60.BANINST1.POKLIBS.F_CHECK_REQD_DEDNS
scope-cursor : MALDEV8_B60.BANINST1.BWPKEBST.GETSECGRPC
scope-procedure : MALDEV8_B60.BANINST1.BWPKEBST.P_BENEFITS

Link List

Link Type	Link	Project
Join	Link Between PDRDEDN and PDRBDED	PAYROLL

Link Between PDRDEDN and PDRBDED

Caller : PDRDEDN
Called : PDRBDED
Link Type : Join
Link : Link Between PDRDEDN and PDRBDED

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PDRDEDN	PDRDEDN_PIDM	PDRBDED_PIDM	PDRBDED	(0,1)-(0,1)
PDRDEDN	PDRDEDN_BDCA_CODE	PDRBDED_BDCA_CODE	PDRBDED	(0,1)-(0,1)
PDRDEDN	PDRDEDN_EFFECTIVE_DATE	PDRBDED_BEGIN_DATE	PDRBDED	(0,1)-(0,1)

Comments

Link between PDRFCLM and PDRDEDN

Caller : PDRFCLM
Called : PDRDEDN

Join Information

Objects list
scope-cursor : MALDEV8_B60.BANINST1.PDKLIBS.FLXSAMOUNTSC

Link List

Link Type	Link	Project
Join	Link Between PDRFCLM and PDRDEDN	PAYROLL

Link Between PDRFCLM and PDRDEDN

Caller : PDRFCLM
Called : PDRDEDN
Link Type : Join
Link : Link Between PDRFCLM and PDRDEDN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PDRFCLM	PDRFCLM_PIDM	PDRDEDN_PIDM	PDRDEDN	(0,1)-(0,1)
PDRFCLM	PDRFCLM_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN	(0,1)-(0,1)

Comments

Link between PDRFBAL and PDRDEDN

Caller : PDRFBAL
Called : PDRDEDN

Join Information

Objects list
scope-cursor : MALDEV8_B60.BANINST1.PDKLIBS.FLXSAMOUNTSC

Link List

Link Type	Link	Project
Join	Link Between PDRFBAL and PDRDEDN	PAYROLL

Link Between PDRFBAL and PDRDEDN

Caller : PDRFBAL
Called : PDRDEDN
Link Type : Join
Link : Link Between PDRFBAL and PDRDEDN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PDRFBAL	PDRFBAL_PIDM	PDRDEDN_PIDM	PDRDEDN	(0,1)-(0,1)
PDRFBAL	PDRFBAL_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN	(0,1)-(0,1)

Comments

Link between PDRFBAL and PEBEMPL

Caller : PDRFBAL
Called : PEBEMPL

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between PDRFBAL and PEBEMPL	PAYROLL

Link Foreign Key Between PDRFBAL and PEBEMPL

Caller : PDRFBAL
Called : PEBEMPL
Link Type : Refer(No Action )
Link : Link Foreign Key Between PDRFBAL and PEBEMPL

Foreign Key information

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

Comments

Link between PDRFCLM and PEBEMPL

Caller : PDRFCLM
Called : PEBEMPL

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between PDRFCLM and PEBEMPL	PAYROLL

Link Foreign Key Between PDRFCLM and PEBEMPL

Caller : PDRFCLM
Called : PEBEMPL
Link Type : Refer(No Action )
Link : Link Foreign Key Between PDRFCLM and PEBEMPL

Foreign Key information

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

Comments

Link between PDRBDED and PEBEMPL

Caller : PDRBDED
Called : PEBEMPL

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between PDRBDED and PEBEMPL	PAYROLL

Link Foreign Key Between PDRBDED and PEBEMPL

Caller : PDRBDED
Called : PEBEMPL
Link Type : Refer(No Action )
Link : Link Foreign Key Between PDRBDED and PEBEMPL

Foreign Key information

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