Model COBRA

Model Label : Banner HR COBRA Module
Path : Default Folder/B70/payroll/Banner HR COBRA Module

List of Objects

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

Comments

Model View

Table PDRBDED

Schema Name PAYROLL
Label PDRBDED
Server name S4B70
Creation Date 09/29/2003 12:16:12:000

Table Columns information

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_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	PTRBDCG_CODE	PTRBDCG
PDRBDED_BDCA_CODE	PTRBDCG_BDCA_CODE	PTRBDCG
PDRBDED_PIDM	PDRDEDN_PIDM	PDRDEDN
PDRBDED_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN
PDRBDED_BDCA_CODE	PTRBDMC_BDCA_CODE	PTRBDMC

Index

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
pdp1042.pc	C/C++ File	N/A	Use(select )
29022-OPEN-DECLARE-C6	Cobol Paragraph	[F:\banner\cobol].PHPCALC.AA-COMMAND-SECT-END	Use(select )
29024-DECLARE-C7	Cobol Paragraph	[F:\banner\cobol].PHPCALC.AA-COMMAND-SECT-END	Use(select )
29032-DECLARE-C11	Cobol Paragraph	[F:\banner\cobol].PHPCALC.AA-COMMAND-SECT-END	Use(select )
29038-DECLARE-C14	Cobol Paragraph	[F:\banner\cobol].PHPCALC.AA-COMMAND-SECT-END	Use(select )
check_new_ded	C/C++ Function	[F:\BANNER\C\PDPBDMC.PC]	Use(select )
check_t_rec	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
del_future_dedn	C/C++ Function	[F:\BANNER\C\PDP1042.PC]	Use(update,select )
del_ovg_udg_bded	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(delete )
ins_pdrbded	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(insert )
ins_perdhis_bded	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(select )
sel_arrear_balance	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(select )
sel_bdca	C/C++ Function	[F:\BANNER\C\PDRBFDN.PC]	Use(select )
sel_bdca_cnt	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_bdca_name	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_bdpl_cnt	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_bdpl_name	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_ben_cnt	C/C++ Function	[F:\BANNER\C\NBPBROL.PC]	Use(select )
sel_ben_pidm	C/C++ Function	[F:\BANNER\C\NBPBROL.PC]	Use(select )
sel_benefit	C/C++ Function	[F:\BANNER\C\PDRBFDN.PC]	Use(select )
sel_d_dedn	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_d_dedn_cnt	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_dedn	C/C++ Function	[F:\BANNER\C\PHPBOND.PC]	Use(select )
sel_dedn	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
sel_emp	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_emp	C/C++ Function	[F:\BANNER\C\PHPBOND.PC]	Use(select )
sel_empl	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_gtax	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_gtax_dedn	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_life_dedns	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_life_dedns	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_pdrbded	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(select )
sel_plan	C/C++ Function	[F:\BANNER\C\PDRBFDN.PC]	Use(select )
sel_plan_code	C/C++ Function	[F:\BANNER\C\PDRBFDN.PC]	Use(select )
sel_quan_pur	C/C++ Function	[F:\BANNER\C\PHPBOND.PC]	Use(select )
sel_supp_dedn	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
sel_taxable_life_exists	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
select_employees	C/C++ Function	[F:\BANNER\C\PDPBDMC.PC]	Use(select )
upd_add_repl	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(update )
upd_arrear_balance	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(update )
upd_bond_bal_body	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(update )
upd_bond_bal_sel	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(select )
upd_ovg_udg_bded	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(update )
upd_pdrbded	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(update )
upd_pdrdedn_bond	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(select )
updt_gurfded_term	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(select )
verify_dedn	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
PDRBCOV	TABLE	S4B70.PAYROLL	Refer( No Action )
PDRXPID	TABLE	S4B70.PAYROLL	Refer( No Action )
PERDTOT	TABLE	S4B70.PAYROLL	Refer( No Action )
PERPCRE	TABLE	S4B70.PAYROLL	Refer( No Action )
PHRDEDN	TABLE	S4B70.PAYROLL	Refer( No Action )
AP_BENEFIT_DEDUCTION	VIEW	S4B70.BANINST1	Use(select )
AP_TAX	VIEW	S4B70.BANINST1	Use(select )
PDVDED1	VIEW	S4B70.BANINST1	Use(select )
PDVDEDD	VIEW	S4B70.BANINST1	Use(select )
PDVDEDN	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PDABCOV.KEY_BLOCK.BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PEAEMPL.PEBEMPL.PEBEMPL_BCAT_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PDADEDN.KEY_BLOCK.BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PDAFCLM.KEY_BLOCK.ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PEAPCRE.PERPCRE.PERPCRE_BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PDAFCLM.KEY_BLOCK.ID	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PEAPCRE.PERPCRE.PERPCRE_BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PDADEDN.KEY_BLOCK.BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PEAEMPL.PEBEMPL.PEBEMPL_BCAT_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PDABCOV.KEY_BLOCK.BDCA_CODE	Use(select )
CHECK_ACTIVE_DEDNS	Forms Trigger	BANNER7_FORMS.PEAESCH	Use(select )
CHECK_ACTIVE_DEDNS	Forms Trigger	BANNER7_FORMS_10G.PEAESCH	Use(select )
CHECK_ALREADY_TERMED	Forms Trigger	BANNER7_FORMS.PEAESCH	Use(select )
CHECK_ALREADY_TERMED	Forms Trigger	BANNER7_FORMS_10G.PEAESCH	Use(select )
CHECK_DEDN	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_DEDN	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CHECK_PDRBDED	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(insert )
CHECK_PDRBDED	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(insert )
CHECK_PDRDEDN_REC	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_PDRDEDN_REC	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS_10G.PTRBDMC	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS_10G.PDAFLEX	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS.PTRBDMC	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS.PDAFLEX	Use(select )
CHECK_PRECLUDED_PRE_INSERT	Forms Trigger	BANNER7_FORMS.PDABDSU	Use(select )
CHECK_PRECLUDED_PRE_INSERT	Forms Trigger	BANNER7_FORMS_10G.PDABDSU	Use(select )
CHECK_TERM_DATE	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_TERM_DATE	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CLEAR_END_DATE	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(update )
CLEAR_END_DATE	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(update )
INSERT_PDRBDED_PDRDEDN	Forms Trigger	BANNER7_FORMS.PDABDSU	Use(insert )
INSERT_PDRBDED_PDRDEDN	Forms Trigger	BANNER7_FORMS_10G.PDABDSU	Use(insert )
NEW_REC_PDRBDED	Forms Trigger	BANNER7_FORMS.PEAFDED	Use(insert )
NEW_REC_PDRBDED	Forms Trigger	BANNER7_FORMS_10G.PEAFDED	Use(insert )
QUERY_NEW_BDCA	Forms Trigger	BANNER7_FORMS.PDCCOCE	Use(select )
QUERY_NEW_BDCA	Forms Trigger	BANNER7_FORMS_10G.PDCCOCE	Use(select )
TERM_CORE	Forms Trigger	BANNER7_FORMS.PDAFLEX	Use(select )
TERM_CORE	Forms Trigger	BANNER7_FORMS_10G.PDAFLEX	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.PDABCOV.KEY_BLOCK	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS.PDADEDN.KEY_BLOCK	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.PDADEDN.KEY_BLOCK	Use(select )
CHECK_KEYS	Forms Trigger	BANNER7_FORMS_10G.PDABCOV.KEY_BLOCK	Use(select )
DEFAULT_DEDNS	Forms Trigger	BANNER7_FORMS.PHAADJT.PHRJOBS	Use(select )
DEFAULT_DEDNS	Forms Trigger	BANNER7_FORMS_10G.PHAADJT.PHRJOBS	Use(select )
GET_CURR_STATUS	Forms Trigger	BANNER7_FORMS.PDCCOCE.CURRENT_CONTINGENT	Use(select )
GET_CURR_STATUS	Forms Trigger	BANNER7_FORMS_10G.PDCCOCE.CURRENT_CONTINGENT	Use(select )
GET_DRDEDN_DATA	Forms Trigger	BANNER7_FORMS.PHCDEDN.PHRDEDN	Use(select )
GET_DRDEDN_DATA	Forms Trigger	BANNER7_FORMS_10G.PHCDEDN.PHRDEDN	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.PEAEMPL.PEBEMPL	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.PEAEMPL.PEBEMPL	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS.PDIDLST.PDRDEDN	Use(select )
POST-QUERY	Forms Trigger	BANNER7_FORMS_10G.PDIDLST.PDRDEDN	Use(select )
POST-UPDATE	Forms Trigger	BANNER7_FORMS.PEAFDED.GURFDED	Use(update,delete,select )
POST-UPDATE	Forms Trigger	BANNER7_FORMS_10G.PEAFDED.GURFDED	Use(update,delete,select )
PRE-BLOCK	Forms Trigger	BANNER7_FORMS.PDADEDN.PDRBDED	Use(select )
PRE-BLOCK	Forms Trigger	BANNER7_FORMS_10G.PDADEDN.PDRBDED	Use(select )
QUERY_BDCA	Forms Trigger	BANNER7_FORMS.PDCCOCE.CURRENT_CONTINGENT	Use(select )
QUERY_BDCA	Forms Trigger	BANNER7_FORMS_10G.PDCCOCE.CURRENT_CONTINGENT	Use(select )
CHECK_PHRDEDN_RECS	Forms Procedure	BANNER7_FORMS.PHCDEDN	Use(select )
CHECK_PHRDEDN_RECS	Forms Procedure	BANNER7_FORMS_10G.PHCDEDN	Use(select )
INSERT_PERDHIS	Forms Procedure	BANNER7_FORMS.PEAESCH	Use(select )
INSERT_PERDHIS	Forms Procedure	BANNER7_FORMS_10G.PEAESCH	Use(select )
PINS_REQUIRED_DEFAULT_DEDNS	Forms Procedure	BANNER7_FORMS.PEAHIRE	Rely on ()
PINS_REQUIRED_DEFAULT_DEDNS	Forms Procedure	BANNER7_FORMS.PEAHIRE	Use(insert,select )
PINS_REQUIRED_DEFAULT_DEDNS	Forms Procedure	BANNER7_FORMS_10G.PEAHIRE	Rely on ()
PINS_REQUIRED_DEFAULT_DEDNS	Forms Procedure	BANNER7_FORMS_10G.PEAHIRE	Use(insert,select )
F_DEDUCTION_ROWID	FUNCTION	S4B70.BANINST1	Use(select )
DEDN_EXISTS	Forms Function	BANNER7_FORMS.PEAHIRE	Use(select )
DEDN_EXISTS	Forms Function	BANNER7_FORMS_10G.PEAHIRE	Use(select )
SELECT_PDRBDED_3	Forms Function	BANNER7_FORMS.PDADEDN	Use(select )
SELECT_PDRBDED_3	Forms Function	BANNER7_FORMS_10G.PDADEDN	Use(select )
SELECT_PDRBDED_4	Forms Function	BANNER7_FORMS.PDADEDN	Use(select )
SELECT_PDRBDED_4	Forms Function	BANNER7_FORMS_10G.PDADEDN	Use(select )
SELECT_PDRDEDN_2	Forms Function	BANNER7_FORMS.PDABCOV	Use(select )
SELECT_PDRDEDN_2	Forms Function	BANNER7_FORMS_10G.PDABCOV	Use(select )
PDRBDED_TYPE	Package Type	S4B70.BANINST1.BWPKDBCV	Rely on ()
PDRBDED_REC	Package variable	S4B70.BANINST1.PDKLIBS	Rely on ()
PDRBDED_REC	Package variable	S4B70.BANINST1.PDKLIBS	Rely on ()
INPUT_RECTYPE	Package Type	S4B70.BANINST1.PDKDEDN	Rely on ()
P_BENEFITS	Package procedure	S4B70.BANINST1.BWPKEBST	Use(select )
P_CROSS_FIELD_EDITS	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_EDIT_INPUT	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_EDIT_INPUT	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on () Use(select )
P_PRINTCOVEREDPERSONS	Package procedure	S4B70.BANINST1.BWPKEBST	Use(select )
P_SAVE_DEDUCTION	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on () Use(insert,update )
P_UPDATEDEDNEDITDRIVER	Package procedure	S4B70.BANINST1.BWPKDUPD	Rely on ()
P_UPDATEDEDNEDITDRIVER	Package procedure	S4B70.BANINST1.BWPKDUPD	Rely on ()
P_UPDATEDEDNPROCRECORDS	Package procedure	S4B70.BANINST1.BWPKDUPD	Use(insert,update,delete )
GETSECGRPC	Package cursor	S4B70.BANINST1.BWPKEBST	Use(select )
PDRBDEDC	Package cursor	S4B70.BANINST1.BWPKDBCV	Use(select )
PDRBDEDCODEC	Package cursor	S4B70.BANINST1.BWPKDBCV	Use(select )
PDRBDEDCOVERAGESC	Package cursor	S4B70.BANINST1.BWPKDBCV	Use(select )
PDRBDED_REC2	Package variable	S4B70.BANINST1.BWPKDBCV	Rely on ()
PDRBDED_REC2	Package variable	S4B70.BANINST1.BWPKDBCV	Rely on ()
F_INVALID_DEDN_EXISTS	Package function	S4B70.BANINST1.PB_EMPLOYEE_RULES	Use(select )
P_APPLY_DEDUCTION	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_APPLY_DEDUCTION	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_CHECK_FLEX	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_CHECK_PRECLUSION	Package procedure	S4B70.BANINST1.PDKDEDN	Use(select )
P_EDIT_ADD_REPL_IND	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_EDIT_ADD_REPL_PICT_CODE	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_EDIT_ARREAR_STATUS	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_EDIT_END_DATE	Package procedure	S4B70.BANINST1.PDKDEDN	Rely on ()
P_EDIT_PEBEMPL_BCAT_CODE	Package procedure	S4B70.BANINST1.NOKPLIB	Use(select )
P_MOVEUPDATESTODEDN	Package procedure	S4B70.BANINST1.BWPKDOCM	Rely on ()
P_MOVEUPDATESTODEDN	Package procedure	S4B70.BANINST1.BWPKDOCM	Rely on ()
P_OPENENROLLMENTFUNCACTIVATE	Package procedure	S4B70.BANINST1.BWPKDOFN	Rely on ()
P_OPENENROLLMENTFUNCACTIVATE	Package procedure	S4B70.BANINST1.BWPKDOFN	Rely on ()
P_OPENENROLLMENTFUNCADDBDED	Package procedure	S4B70.BANINST1.BWPKDOFN	Use(insert )
P_OPENENROLLMENTFUNCBACKOUT	Package procedure	S4B70.BANINST1.BWPKDOFN	Rely on ()
P_OPENENROLLMENTFUNCBACKOUT	Package procedure	S4B70.BANINST1.BWPKDOFN	Rely on ()
P_OPENENROLLMENTFUNCDELBDED	Package procedure	S4B70.BANINST1.BWPKDOFN	Use(delete )
P_OPENENROLLMENTFUNCUPDBDED	Package procedure	S4B70.BANINST1.BWPKDOFN	Use(update )
P_UPDATEDEDNSELNEWDRIVER	Package procedure	S4B70.BANINST1.BWPKDQRY	Rely on ()
P_UPDATEDEDNSELNEWDRIVER	Package procedure	S4B70.BANINST1.BWPKDQRY	Rely on ()
P_VALIDATE_DELETE	Package procedure	S4B70.BANINST1.PB_EMPLOYEE_RULES	Use(select )
P_VERIFYCOREBDCAEMP	Package procedure	S4B70.BANINST1.PDKLIBS	Rely on ()
P_VERIFYCOREBDCAEMP	Package procedure	S4B70.BANINST1.PDKLIBS	Use(select )
DEDNPRECLUDESC	Package cursor	S4B70.BANINST1.PDKLIBS	Use(select )
PDRBDEDVIEWC	Package cursor	S4B70.BANINST1.PDKLIBS	Rely on () Use(select )
PDRDEDNRANGECOUNTC	Package cursor	S4B70.BANINST1.PDKLIBS	Use(select )
F_CHECK_REQD_DEDNS	Package function	S4B70.BANINST1.POKLIBS	Use(select )
F_GETDEDNSTATUS	Package function	S4B70.BANINST1.BWPKDBCV	Use(select )
PDRBDED	SYNONYM	S4B70.PUBLIC	Rely on ()
PDRBDED	Forms DataBlock	BANNER7_FORMS.PEAESCH	Rely on () Use(insert,update,select )
PDRBDED	Forms DataBlock	BANNER7_FORMS.PDADEDN	Rely on () Use(insert,update,delete,select )
PDRBDED	Forms DataBlock	BANNER7_FORMS_10G.PEAESCH	Rely on () Use(insert,update,select )
PDRBDED	Forms DataBlock	BANNER7_FORMS_10G.PDADEDN	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_PDRBDED	INDEX	S4B70.PAYROLL	Rely on ()
PDRDEDN	TABLE	S4B70.PAYROLL	Join
PEBEMPL	TABLE	S4B70.PAYROLL	Refer( No Action )
PTRBDCA	TABLE	S4B70.PAYROLL	Refer( No Action )
PTRBDCG	TABLE	S4B70.PAYROLL	Join
PTRBDMC	TABLE	S4B70.PAYROLL	Join

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
Label PDRDEDN
Server name S4B70
Creation Date 09/29/2003 12:16:12:000

Table Columns information

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_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	PTRBDPD_CODE	PTRBDPD
PDRDEDN_BDCA_CODE	PTRBDCA_CODE	PTRBDCA

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
pdp1042.pc	C/C++ File	N/A	Use(select )
29022-OPEN-DECLARE-C6	Cobol Paragraph	[F:\banner\cobol].PHPCALC.AA-COMMAND-SECT-END	Use(select )
check_t_rec	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
del_future_dedn	C/C++ Function	[F:\BANNER\C\PDP1042.PC]	Use(delete,select )
del_ovg_udg_dedn	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(delete )
empl_body	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use()
ins_gtax_dedn	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(insert )
ins_new_dedn	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(insert )
ins_pdrdedn	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(insert )
ins_perdhis_bded	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(select )
sel_arrear_balance	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(select )
sel_bdca_cnt	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_bdca_name	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_bdpl_cnt	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_bdpl_name	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_ben_cnt	C/C++ Function	[F:\BANNER\C\NBPBROL.PC]	Use(select )
sel_ben_pidm	C/C++ Function	[F:\BANNER\C\NBPBROL.PC]	Use(select )
sel_benefit	C/C++ Function	[F:\BANNER\C\PDRBFDN.PC]	Use(select )
sel_code_empl_cnt	C/C++ Function	[F:\BANNER\C\PHRDREG.PC]	Use(select )
sel_cont1	C/C++ Function	[F:\BANNER\C\PDPBDMC.PC]	Use(select )
sel_cont2	C/C++ Function	[F:\BANNER\C\PDPBDMC.PC]	Use(select )
sel_d_dedn	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_d_dedn_cnt	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_dedn	C/C++ Function	[F:\BANNER\C\PHPBOND.PC]	Use(select )
sel_dedn	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
sel_dedns	C/C++ Function	[F:\BANNER\C\PHRDREG.PC]	Use(select )
sel_def_dedn	C/C++ Function	[F:\BANNER\C\NBRBWRK.PC]	Use(select )
sel_emp	C/C++ Function	[F:\BANNER\C\PHPBOND.PC]	Use(select )
sel_grand_empl_cnt	C/C++ Function	[F:\BANNER\C\PHRDREG.PC]	Use(select )
sel_gtax	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_gtax_dedn	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_life_dedns	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_life_dedns	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_pdrdedn	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(select )
sel_plan	C/C++ Function	[F:\BANNER\C\PDRBFDN.PC]	Use(select )
sel_plan_code	C/C++ Function	[F:\BANNER\C\PDRBFDN.PC]	Use(select )
sel_plan_empl_cnt	C/C++ Function	[F:\BANNER\C\PHRDREG.PC]	Use(select )
sel_quan_pur	C/C++ Function	[F:\BANNER\C\PHPBOND.PC]	Use(select )
sel_state_withheld	C/C++ Function	[F:\BANNER\C\PEP1042.PC]	Use(select )
sel_supp_dedn	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
sel_tax_res_cc	C/C++ Function	[F:\BANNER\C\PEP1042.PC]	Use(select )
sel_taxable_life_exists	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
select_employees	C/C++ Function	[F:\BANNER\C\PDPBDMC.PC]	Use(select )
up_quan_pur	C/C++ Function	[F:\BANNER\C\PHPBOND.PC]	Use(update )
upd_bond_bal_sel	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(select )
upd_dedn	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(update )
upd_dedn_ovg	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(update )
upd_gtax_dedn	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(update )
upd_pdrdedn	C/C++ Function	[F:\BANNER\C\PDPFLEX.PC]	Use(update )
upd_pdrdedn_bond	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(update )
upd_pdrfbal_sel	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(select )
updt_gurfded_term	C/C++ Function	[F:\BANNER\C\PHPUPDT.PC]	Use(select )
verify_dedn	C/C++ Function	[F:\BANNER\C\PHPTIME.PC]	Use(select )
PDRBDED	TABLE	S4B70.PAYROLL	Join
PDRFBAL	TABLE	S4B70.PAYROLL	Join
PHRDEDN	TABLE	S4B70.PAYROLL	Join
PTRBCDN	TABLE	S4B70.PAYROLL	Join
PTRFBEN	TABLE	S4B70.PAYROLL	Join
AP_BENEFIT_DEDUCTION	VIEW	S4B70.BANINST1	Use(select )
AP_TAX	VIEW	S4B70.BANINST1	Use(select )
PDVDAMT	VIEW	S4B70.BANINST1	Use(select )
PDVDED1	VIEW	S4B70.BANINST1	Use(select )
PDVDEDD	VIEW	S4B70.BANINST1	Use(select )
PDVDEDN	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PDAFCLM.KEY_BLOCK.BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PEAPCRE.PERPCRE.PERPCRE_BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PDADEDN.PDRDEDN.PDRDEDN_STATUS	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PEAEMPL.PEBEMPL.PEBEMPL_BCAT_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PDADEDN.PDRDEDN.PDRDEDN_STATUS	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PDAFCLM.KEY_BLOCK.BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PEAPCRE.PERPCRE.PERPCRE_BDCA_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PEAEMPL.PEBEMPL.PEBEMPL_BCAT_CODE	Use(select )
WHEN_VALIDATE_ITEM	Forms Trigger	BANNER7_FORMS.PDICLST.PDRBCOV.PDRBCOV_BDCA_CODE	Use(select )
WHEN_VALIDATE_ITEM	Forms Trigger	BANNER7_FORMS_10G.PDICLST.PDRBCOV.PDRBCOV_BDCA_CODE	Use(select )
CHECK_DEDN	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_DEDN	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CHECK_DEDN_FUTURE	Forms Trigger	BANNER7_FORMS.PEAESCH	Use(delete,select )
CHECK_DEDN_FUTURE	Forms Trigger	BANNER7_FORMS_10G.PEAESCH	Use(delete,select )
CHECK_DEDN_STATUS	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_DEDN_STATUS	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CHECK_DEDN_TAKEN	Forms Trigger	BANNER7_FORMS.PEAFDED	Use(select )
CHECK_DEDN_TAKEN	Forms Trigger	BANNER7_FORMS_10G.PEAFDED	Use(select )
CHECK_END_DATE	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_END_DATE	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CHECK_PDRDEDN_REC	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_PDRDEDN_REC	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS.PDAFLEX	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS_10G.PDAFLEX	Use(select )
CHECK_PRECLUDED	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
CHECK_PRECLUDED_PRE_INSERT	Forms Trigger	BANNER7_FORMS.PDABDSU	Use(select )
CHECK_PRECLUDED_PRE_INSERT	Forms Trigger	BANNER7_FORMS_10G.PDABDSU	Use(select )
CHECK_TERM_DATE	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
CHECK_TERM_DATE	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
EDIT_BDPLS_EXIST_IN_PDRDEDN	Forms Trigger	BANNER7_FORMS.PTRBDCA	Use(select )
EDIT_BDPLS_EXIST_IN_PDRDEDN	Forms Trigger	BANNER7_FORMS_10G.PTRBDCA	Use(select )
EDIT_END_DATE	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
EDIT_END_DATE	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
GET_ALLOWANCE_INFO	Forms Trigger	BANNER7_FORMS.PHCDEDN	Use(select )
GET_ALLOWANCE_INFO	Forms Trigger	BANNER7_FORMS_10G.PHCDEDN	Use(select )
GET_MIN_QDATE	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(select )
GET_MIN_QDATE	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(select )
INSERT_PDRDEDN_TERMINATE	Forms Trigger	BANNER7_FORMS.PDABDSU	Use(insert )
INSERT_PDRDEDN_TERMINATE	Forms Trigger