Model Deductions

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

List of Objects

Object Name	Object Type	Layer Name
PDRBCOV	TABLE	Default
PDRBDED	TABLE	Default
PDRBENE	TABLE	Default
PDRBFLX	TABLE	Default
PDRDEDN	TABLE	Default
PDRFBAL	TABLE	Default
PDRFCLM	TABLE	Default
PDRFLEX	TABLE	Default
PDRXPID	TABLE	Default
PEBEMPL	TABLE	Default
PERDTOT	TABLE	Default
PERPCRE	TABLE	Default
PHRDEDN	TABLE	Default
PTRBDCA	TABLE	Default
PTRBDCG	TABLE	Default
PTRBDGM	TABLE	Default
PTRBDPD	TABLE	Default
PTRBDPL	TABLE	Default
SPRIDEN	TABLE	Default

Comments

Model View

Table PDRBCOV

Schema Name PAYROLL
Label PDRBCOV
Server name S4B70
Creation Date 01/23/2004 11:55:42:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PDRBCOV_PIDM	PDRBCOV_PIDM	NUMBER(8,0)	No	*	*
PDRBCOV_BDCA_CODE	PDRBCOV_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRBCOV_BENE_SEQ_NO	PDRBCOV_BENE_SEQ_NO	NUMBER(2,0)	No	*
PDRBCOV_BEGIN_DATE	PDRBCOV_BEGIN_DATE	DATE	No
PDRBCOV_END_DATE	PDRBCOV_END_DATE	DATE	Yes
PDRBCOV_OTHER_COV_IND	PDRBCOV_OTHER_COV_IND	VARCHAR2(1)	Yes
PDRBCOV_ACTIVITY_DATE	PDRBCOV_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PDRBCOV_PIDM	PDRBDED_PIDM	PDRBDED
PDRBCOV_BDCA_CODE	PDRBDED_BDCA_CODE	PDRBDED

Index

Index Name	Index Type	Column Name
PK_PDRBCOV	Unique	PDRBCOV_PIDM
PK_PDRBCOV	Unique	PDRBCOV_BDCA_CODE
PK_PDRBCOV	Unique	PDRBCOV_BENE_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
main	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use()
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_bene_age	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_bene_age	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_d_bene	C/C++ Function	[F:\BANNER\C\PDRBCOV.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_per_age	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_pers_age	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_trans_code	C/C++ Function	[F:\BANNER\C\PDPMR87.PC]	Use(select )
PDRBCOV	SYNONYM	S4B70.PUBLIC	Rely on ()
AP_BENEFICIARY_DEPENDENT	VIEW	S4B70.BANINST1	Use(select )
PDVBCOV	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PDABENE.PDRBENE.PDRBENE_SEQ_NO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PDABENE.PDRBENE.PDRBENE_SEQ_NO	Use(select )
DEL_FROM_PDRBCOV	Forms Trigger	BANNER7_FORMS.PDADEDN	Use(delete )
DEL_FROM_PDRBCOV	Forms Trigger	BANNER7_FORMS_10G.PDADEDN	Use(delete )
KEY-DELREC	Forms Trigger	BANNER7_FORMS.PDABENE.PDRBENE	Use(select )
KEY-DELREC	Forms Trigger	BANNER7_FORMS_10G.PDABENE.PDRBENE	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS.PDABCOV.PDRBCOV	Use(select )
PRE-INSERT	Forms Trigger	BANNER7_FORMS_10G.PDABCOV.PDRBCOV	Use(select )
PDRDEDN_DELETE_1	Forms Procedure	BANNER7_FORMS.PDADEDN	Use(select )
PDRDEDN_DELETE_1	Forms Procedure	BANNER7_FORMS_10G.PDADEDN	Use(select )
UPDATE_PDRBCOV	Forms Procedure	BANNER7_FORMS.PEAESCH	Use(update )
UPDATE_PDRBCOV	Forms Procedure	BANNER7_FORMS_10G.PEAESCH	Use(update )
F_BENEFICIARY_INFO	FUNCTION	S4B70.BANINST1	Use(select )
P_PRINTCOVEREDPERSONS	Package procedure	S4B70.BANINST1.BWPKEBST	Use(select )
P_REMOVEPDRBCOVENDDATE	Package procedure	S4B70.BANINST1.BWPKDUPD	Use(update )
P_UPDATEDEDNPROCRECORDS	Package procedure	S4B70.BANINST1.BWPKDUPD	Use(delete )
P_UPDATEPDRBCOVENDDATE	Package procedure	S4B70.BANINST1.BWPKDUPD	Use(update )
PDRBCOVC	Package cursor	S4B70.BANINST1.BWPKDUPD	Use(select )
PDRBCOVC	Package cursor	S4B70.BANINST1.BWPKDBCV	Use(select )
PDRBCOVCODEC	Package cursor	S4B70.BANINST1.BWPKDBCV	Use(select )
PDRBDEDC	Package cursor	S4B70.BANINST1.BWPKDBCV	Use(select )
PDRBDEDCOVERAGESC	Package cursor	S4B70.BANINST1.BWPKDBCV	Use(select )
PDRBCOV_REC	Package variable	S4B70.BANINST1.BWPKDUPD	Rely on ()
PDRBCOV_REC	Package variable	S4B70.BANINST1.BWPKDBCV	Rely on ()
PDRBCOV_REC	Package variable	S4B70.BANINST1.BWPKDBCV	Rely on ()
PDRBCOV_REC	Package variable	S4B70.BANINST1.BWPKDUPD	Rely on ()
P_OPENENROLLMENTFUNCDELBDED	Package procedure	S4B70.BANINST1.BWPKDOFN	Use(delete )
F_UPDATECOVERAGE	Package function	S4B70.BANINST1.BWPKDBCV	Use(insert,update )
PDRBCOV	Forms DataBlock	BANNER7_FORMS.PDABCOV	Rely on () Use(insert,update,delete,select )
PDRBCOV	Forms DataBlock	BANNER7_FORMS_10G.PDABCOV	Rely on () Use(insert,update,delete,select )
PDRBCOV	Forms DataBlock	BANNER7_FORMS_10G.PDICLST	Rely on () Use(select )
PDRBCOV	Forms DataBlock	BANNER7_FORMS.PDICLST	Rely on () Use(select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_PDRBCOV	INDEX	S4B70.PAYROLL	Rely on ()
PT_PDRBCOV_AUDIT_DELETES	TRIGGER	S4B70.PAYROLL	Fire(delete after each row )
PT_PDRBCOV_AUDIT_INSERTS	TRIGGER	S4B70.PAYROLL	Fire(insert after each row )
PT_PDRBCOV_AUDIT_UPDATES	TRIGGER	S4B70.PAYROLL	Fire(update after each row )
PDRBDED	TABLE	S4B70.PAYROLL	Refer( No Action )

Comments

Source Code Comments

Beneficiary Coverage Repeating Table

Columns Comments for PDRBCOV_PIDM (1)

Source Code Comments

Internal ID number.

Columns Comments for PDRBCOV_BDCA_CODE (2)

Source Code Comments

The Coverage Benefit/Deduction Code.

Columns Comments for PDRBCOV_BENE_SEQ_NO (3)

Source Code Comments

The Sequence Number which ties in with the PDRBENE Beneficiary Sequence number to identify the Beneficiary.

Columns Comments for PDRBCOV_BEGIN_DATE (4)

Source Code Comments

Benefit Coverage Begin Date.

Columns Comments for PDRBCOV_END_DATE (5)

Source Code Comments

Benefit Coverage End Date.

Columns Comments for PDRBCOV_OTHER_COV_IND (6)

Source Code Comments

Indicator which indicates whether Beneficiary is otherwise covered.

Columns Comments for PDRBCOV_ACTIVITY_DATE (7)

Source Code Comments

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

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 PDRBENE

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PDRBENE_PIDM	PDRBENE_PIDM	NUMBER(8,0)	No	*
PDRBENE_SEQ_NO	PDRBENE_SEQ_NO	NUMBER(2,0)	No	*
PDRBENE_BENE_PIDM	PDRBENE_BENE_PIDM	NUMBER(8,0)	Yes		*
PDRBENE_BENE_LAST_NAME	PDRBENE_BENE_LAST_NAME	VARCHAR2(30)	Yes
PDRBENE_BENE_FIRST_NAME	PDRBENE_BENE_FIRST_NAME	VARCHAR2(15)	Yes
PDRBENE_BENE_MI	PDRBENE_BENE_MI	VARCHAR2(15)	Yes
PDRBENE_BREL_CODE	PDRBENE_BREL_CODE	VARCHAR2(1)	No		*
PDRBENE_SEX_IND	PDRBENE_SEX_IND	VARCHAR2(1)	Yes
PDRBENE_BIRTH_DATE	PDRBENE_BIRTH_DATE	DATE	Yes
PDRBENE_COLLEGE_IND	PDRBENE_COLLEGE_IND	VARCHAR2(1)	No
PDRBENE_ACTIVITY_DATE	PDRBENE_ACTIVITY_DATE	DATE	No
PDRBENE_SSN	PDRBENE_SSN	VARCHAR2(9)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
PDRBENE_BREL_CODE	PTRBREL_CODE	PTRBREL
PDRBENE_BENE_PIDM	SPBPERS_PIDM	SPBPERS

Index

Index Name	Index Type	Column Name
PK_PDRBENE	Unique	PDRBENE_PIDM
PK_PDRBENE	Unique	PDRBENE_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
5200-SELECT-EMPLOYEE-INFO	Cobol Paragraph	[F:\banner\cobol].PXPMTPR.AAA	Use(select )
get_spouse_ssn	C/C++ Function	[F:\BANNER\C\PXPW2MP.PC]	Use(select )
sel_bene_age	C/C++ Function	[F:\BANNER\C\PDPCFLX.PC]	Use(select )
sel_bene_age	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_bene_age	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_d_bene	C/C++ Function	[F:\BANNER\C\PDRBLST.PC]	Use(select )
sel_d_bene	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_dep_bene_age	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_dep_pers_age	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_option4	C/C++ Function	[F:\BANNER\C\PORAUDT.PC]	Use(select )
sel_pdrbene	C/C++ Function	[F:\BANNER\C\PDRBLST.PC]	Use(select )
sel_pdrbene	C/C++ Function	[F:\BANNER\C\PDRBCOV.PC]	Use(select )
sel_per_age	C/C++ Function	[F:\BANNER\C\PDRLIFE.PC]	Use(select )
sel_pers_age	C/C++ Function	[F:\BANNER\C\PDPCFLX.PC]	Use(select )
sel_pers_age	C/C++ Function	[F:\BANNER\C\PDPLIFE.PC]	Use(select )
sel_spouse_ssn	C/C++ Function	[F:\BANNER\C\PXRW2PR.PC]	Use(select )
sel_trans_code	C/C++