Model Windstar Interface

Model Label : Banner Human Resources Windstar Interface Module

List of Objects

Object Name	Object Type	Layer Name
PDR1042	SQL Table	Default
PDRBDED	SQL Table	Default
PDRDEDN	SQL Table	Default
PDRFBAL	SQL Table	Default
PDRFCLM	SQL Table	Default
PEBEMPL	SQL Table	Default
PER1042	SQL Table	Default
PERDHIS	SQL Table	Default
PERINDV	SQL Table	Default
PHR1042	SQL Table	Default
PHRHIST	SQL Table	Default
PTRBCDN	SQL Table	Default
PTRBDCA	SQL Table	Default
PTRBDCL	SQL Table	Default
PTRBDPD	SQL Table	Default
PTRBDPL	SQL Table	Default
PTRCITZ	SQL Table	Default
PTRFBEN	SQL Table	Main Objects
PTRFILE	SQL Table	Main Objects
PTRINCD	SQL Table	Default
PTRTPCM	SQL Table	Default
PTRTPCS	SQL Table	Default
PTVBTPC	SQL Table	Default
PTVTPCD	SQL Table	Default

Model View

Table PDR1042

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
PDR1042_LAST_NAME	VARCHAR2(60)	Yes
PDR1042_FIRST_NAME	VARCHAR2(60)	Yes
PDR1042_MI	VARCHAR2(60)	Yes
PDR1042_SSN	VARCHAR2(15)	Yes
PDR1042_ID	VARCHAR2(9)	Yes
PDR1042_BIRTH_DATE	DATE	Yes
PDR1042_TAX_YEAR	NUMBER(4,0)	Yes
PDR1042_INCOME_CODE	NUMBER(2,0)	Yes
PDR1042_WITHHOLDING_RATE	NUMBER(4,2)	Yes
PDR1042_INCOME_CODE_SUBTYPE	VARCHAR2(1)	Yes
PDR1042_EXEMPTION_CODE	NUMBER(1,0)	Yes
PDR1042_MAX_BENEFIT_AMOUNT	NUMBER(9,2)	Yes
PDR1042_RL_BEN_AMT_EXCEED_SW	VARCHAR2(1)	Yes
PDR1042_BEN_END_DATE	DATE	Yes
PDR1042_RL_BEN_DATE_EXCEED_SW	VARCHAR2(1)	Yes
PDR1042_CURR_RESIDENCY_STATUS	VARCHAR2(1)	Yes
PDR1042_BECOME_RA_DATE	DATE	Yes
PDR1042_TARGET_DEPARTURE_DATE	DATE	Yes
PDR1042_TAX_RES_COUNTRY_CODE	VARCHAR2(2)	Yes
PDR1042_TREATY_CHANGED_DATE	DATE	Yes
PDR1042_EXEMPT_NRA_FICA_SW	VARCHAR2(1)	Yes
PDR1042_EXEMPT_STUDNT_FICA_SW	VARCHAR2(1)	Yes
PDR1042_ADD_WITHHOLDING_SW	VARCHAR2(1)	Yes
PDR1042_ADD_WITHHOLDING_AMT	NUMBER(4,0)	Yes
PDR1042_PERSONAL_EXEMPTION	NUMBER(1,0)	Yes
PDR1042_ADD_EXEMPTION_ALLOWED	NUMBER(2,0)	Yes
PDR1042_DAYS_IN_USA	NUMBER(3,0)	Yes
PDR1042_WITHHOLD_ALLOWANCE_SW	VARCHAR2(1)	Yes
PDR1042_TREATY_BEN_ALLOWED_SW	VARCHAR2(1)	Yes
PDR1042_TREATY_BEN_START_DATE	DATE	Yes
PDR1042_RA_EFFECTIVE_DATE	DATE	Yes
PDR1042_STATE_CODE	VARCHAR2(2)	Yes
PDR1042_STATE_HONOR_TREATY_SW	VARCHAR2(1)	Yes
PDR1042_YTD_PAYMENTS	NUMBER(9,2)	Yes
PDR1042_YTD_W2_PAYMENTS	NUMBER(9,2)	Yes
PDR1042_YTD_FED_WH_W2	NUMBER(9,2)	Yes
PDR1042_YTD_TREATY_WH_ALLWNCE	NUMBER(9,2)	Yes
PDR1042_YTD_TREATY_PMT	NUMBER(9,2)	Yes
PDR1042_YTD_TREATY_WH_AMT	NUMBER(9,2)	Yes
PDR1042_RECORD_SOURCE	VARCHAR2(3)	Yes
PDR1042_VISA_TYPE	VARCHAR2(4)	Yes
PDR1042_J_SUB_TYPE	VARCHAR2(2)	Yes
PDR1042_PRIMARY_ACTIVITY	VARCHAR2(2)	Yes
PDR1042_NON_US_COUNTRY_CODE	VARCHAR2(2)	Yes
PDR1042_CITIZEN_COUNTRY_CODE	VARCHAR2(2)	Yes
PDR1042_CONST_ADDITIONAL_TAX	NUMBER(7,2)	Yes
PDR1042_ADD_WITHHOLDING_TYPE	VARCHAR2(1)	Yes
PDR1042_OTHER_TREATY_BEN	NUMBER(9,2)	Yes
PDR1042_W4_SIGNED	DATE	Yes
PDR1042_TREATY_FORM_SIGNED	DATE	Yes
PDR1042_BEN_ESTIMATED_SW	VARCHAR2(1)	Yes
PDR1042_EXEMPTION_CODE_2	VARCHAR2(2)	Yes
PDR1042_RECIPIENT_CODE	NUMBER(2,0)	Yes
PDR1042_STATUS_TYPE	VARCHAR2(1)	Yes
PDR1042_STATUS_DESC	VARCHAR2(50)	Yes
PDR1042_ADD_TO_GROSS	VARCHAR2(1)	Yes
PDR1042_SURNAME_PREFIX	VARCHAR2(60)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PDR1042_KEY1_INDEX		PDR1042_ID

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PDR1042

Object Dates

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

Source Code Comments

Windstar Payment Information Repeating Table.

Columns Comments for PDR1042_LAST_NAME (# 1)

Source Code Comments

LAST NAME: This field defines the last name of person.

Columns Comments for PDR1042_FIRST_NAME (# 2)

Source Code Comments

FIRST NAME: This field identifies the first name of person.

Columns Comments for PDR1042_MI (# 3)

Source Code Comments

MIDDLE NAME: This field identifies the middle name of person.

Columns Comments for PDR1042_SSN (# 4)

Source Code Comments

SSN: Social Security Number.

Columns Comments for PDR1042_ID (# 5)

Source Code Comments

ID: This field defines the identification number used to access person on-line.

Columns Comments for PDR1042_BIRTH_DATE (# 6)

Source Code Comments

BIRTH DATE: Date of Birth.

Columns Comments for PDR1042_TAX_YEAR (# 7)

Source Code Comments

TAX YEAR: Tax Year.

Columns Comments for PDR1042_INCOME_CODE (# 8)

Source Code Comments

INCOME CODE: Income Code.

Columns Comments for PDR1042_WITHHOLDING_RATE (# 9)

Source Code Comments

WITHHOLDING RATE: Withholding Rate.

Columns Comments for PDR1042_INCOME_CODE_SUBTYPE (# 10)

Source Code Comments

INCOME CODE SUBTYPE: Income code subtype.

Columns Comments for PDR1042_EXEMPTION_CODE (# 11)

Source Code Comments

EXEMPTION CODE: Exemption Code.

Columns Comments for PDR1042_MAX_BENEFIT_AMOUNT (# 12)

Source Code Comments

MAX BENEFIT AMOUNT: Amount supplied only for treaty benefits with a maximum.

Columns Comments for PDR1042_RL_BEN_AMT_EXCEED_SW (# 13)

Source Code Comments

RL BEN AMT EXCEED IND: Retro Lose Benefit if Amount Exceeded.

Columns Comments for PDR1042_BEN_END_DATE (# 14)

Source Code Comments

BENEFIT END DATE: Date Benefit Ends.

Columns Comments for PDR1042_RL_BEN_DATE_EXCEED_SW (# 15)

Source Code Comments

RETRO LOSE BENEFIT DATE EXCEEDED: Retro Lose Benefit if Date Exceeded.

Columns Comments for PDR1042_CURR_RESIDENCY_STATUS (# 16)

Source Code Comments

CURRENT RESIDENCY STATUS: Current Residency Status.

Columns Comments for PDR1042_BECOME_RA_DATE (# 17)

Source Code Comments

BECOME RA DATE: Date Individual becomes RA.

Columns Comments for PDR1042_TARGET_DEPARTURE_DATE (# 18)

Source Code Comments

TARGET DEPARTURE DATE: Ending Date on latest Visa/Primary Activity.

Columns Comments for PDR1042_TAX_RES_COUNTRY_CODE (# 19)

Source Code Comments

TAX RES COUNTRY CODE: IRS Codes.

Columns Comments for PDR1042_TREATY_CHANGED_DATE (# 20)

Source Code Comments

TREATY CHANGED DATE: Date this Treaty Info updated.

Columns Comments for PDR1042_EXEMPT_NRA_FICA_SW (# 21)

Source Code Comments

EXEMPT NRA FICA IND: Exempt (NRA) from FICA.

Columns Comments for PDR1042_EXEMPT_STUDNT_FICA_SW (# 22)

Source Code Comments

EXEMPT STUDENT FICA INDICATOR: Exempt Student from FICA.

Columns Comments for PDR1042_ADD_WITHHOLDING_SW (# 23)

Source Code Comments

ADDITIONAL WITHHOLDING INDICATOR: Add Withholding for NRA when no treaty.

Columns Comments for PDR1042_ADD_WITHHOLDING_AMT (# 24)

Source Code Comments

ADDITIONAL WITHHOLDING AMOUNT: Amount of Additional Withholding.

Columns Comments for PDR1042_PERSONAL_EXEMPTION (# 25)

Source Code Comments

PERSONAL EXEMPTION: Personal Exemption.

Columns Comments for PDR1042_ADD_EXEMPTION_ALLOWED (# 26)

Source Code Comments

ADDITIONAL EXEMPTION ALLOWED: Additional exemptions allowed.

Columns Comments for PDR1042_DAYS_IN_USA (# 27)

Source Code Comments

DAYS IN USA: Days in USA this Tax Year.

Columns Comments for PDR1042_WITHHOLD_ALLOWANCE_SW (# 28)

Source Code Comments

WITHHOLD ALLOWANCE INDICATOR: Eligible for Withholding Allowance.

Columns Comments for PDR1042_TREATY_BEN_ALLOWED_SW (# 29)

Source Code Comments

TREATY BENEFIT ALLOWED INDICATOR: Treaty Benefits Allowed.

Columns Comments for PDR1042_TREATY_BEN_START_DATE (# 30)

Source Code Comments

TREATY BENEFIT START DATE: Treaty Benefit Start Date.

Columns Comments for PDR1042_RA_EFFECTIVE_DATE (# 31)

Source Code Comments

RA EFFECTIVE DATE: RA Effective Date.

Columns Comments for PDR1042_STATE_CODE (# 32)

Source Code Comments

STATE CODE: State Code.

Columns Comments for PDR1042_STATE_HONOR_TREATY_SW (# 33)

Source Code Comments

STATE HONOR TREATY INDICATOR: State Honors Treaty.

Columns Comments for PDR1042_YTD_PAYMENTS (# 34)

Source Code Comments

YTD PAYMENTS: YTD Payments.

Columns Comments for PDR1042_YTD_W2_PAYMENTS (# 35)

Source Code Comments

YTD W2 PAYMENTS: YTD W2 Payments.

Columns Comments for PDR1042_YTD_FED_WH_W2 (# 36)

Source Code Comments

YTD FED WITHHOLDING W2: YTD Withholding (Federal) W2.

Columns Comments for PDR1042_YTD_TREATY_WH_ALLWNCE (# 37)

Source Code Comments

YTD TREATY WITHHOLDING ALLOWANCE: YTD Withholding Allowance (1042S).

Columns Comments for PDR1042_YTD_TREATY_PMT (# 38)

Source Code Comments

YTD TREATY PAYMENT: YTD Treaty Payments (1042S).

Columns Comments for PDR1042_YTD_TREATY_WH_AMT (# 39)

Source Code Comments

YTD TREATY WITHHELD AMOUNT: YTD Treaty Withheld Amts (1042S).

Columns Comments for PDR1042_RECORD_SOURCE (# 40)

Source Code Comments

RECORD SOURCE: Record Source (STU, SPT, CIT etc).

Columns Comments for PDR1042_VISA_TYPE (# 41)

Source Code Comments

VISA TYPE: Visa Type.

Columns Comments for PDR1042_J_SUB_TYPE (# 42)

Source Code Comments

J SUB TYPE: J Sub Type.

Columns Comments for PDR1042_PRIMARY_ACTIVITY (# 43)

Source Code Comments

PRIMARY ACTIVITY: Primary Activity.

Columns Comments for PDR1042_NON_US_COUNTRY_CODE (# 44)

Source Code Comments

NON US COUNTRY CODE: Non US Country Code.

Columns Comments for PDR1042_CITIZEN_COUNTRY_CODE (# 45)

Source Code Comments

CITIZEN COUNTRY CODE: Citizenship Country Code.

Columns Comments for PDR1042_CONST_ADDITIONAL_TAX (# 46)

Source Code Comments

CONSTANT ADDITIONAL TAX: Constant additional Tax.

Columns Comments for PDR1042_ADD_WITHHOLDING_TYPE (# 47)

Source Code Comments

ADDITIONAL WITHHOLDING TYPE: Amount of additional withholding type.

Columns Comments for PDR1042_OTHER_TREATY_BEN (# 48)

Source Code Comments

OTHER TREATY BENEFIT: Treaty benefit enjoyed at different institution in current tax year.

Columns Comments for PDR1042_W4_SIGNED (# 49)

Source Code Comments

W4 SIGNED: W4 signed.

Columns Comments for PDR1042_TREATY_FORM_SIGNED (# 50)

Source Code Comments

TREATY FORM SIGNED: Treaty form signed.

Columns Comments for PDR1042_BEN_ESTIMATED_SW (# 51)

Source Code Comments

BENEFIT ESTIMATED INDICATOR: Treaty benefits estimated.

Columns Comments for PDR1042_EXEMPTION_CODE_2 (# 52)

Source Code Comments

EXEMPTION CODE 2: Exemption Code 2.

Columns Comments for PDR1042_RECIPIENT_CODE (# 53)

Source Code Comments

RECIPIENT CODE: Recipient Code.

Columns Comments for PDR1042_STATUS_TYPE (# 54)

Source Code Comments

STATUS TYPE: Record status; 0 = no errors, 1 = error.

Columns Comments for PDR1042_STATUS_DESC (# 55)

Source Code Comments

STATUS DESC: Error messages.

Columns Comments for PDR1042_ADD_TO_GROSS (# 56)

Source Code Comments

ADD TO GROSS: New 2006 Taxation Notice 2005-76, offset standard deduction.

Columns Comments for PDR1042_SURNAME_PREFIX (# 57)

Source Code Comments

SURNAME PREFIX: Name tag preceding the last name or surname. (Van, Von, Mac, etc.)

Table PDRBDED

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
PDRBDED_PIDM	NUMBER(8,0)	No	*	*
PDRBDED_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRBDED_ADD_REPL_IND	VARCHAR2(1)	Yes
PDRBDED_ADD_REPL_EMPL	NUMBER(11,2)	Yes
PDRBDED_ADD_REPL_EMPR	NUMBER(11,2)	Yes
PDRBDED_ADD_REPL_TAX_BASE	NUMBER(11,2)	Yes
PDRBDED_ARR_STATUS	VARCHAR2(1)	Yes
PDRBDED_ARR_BALANCE	NUMBER(11,2)	Yes
PDRBDED_BOND_BALANCE	NUMBER(11,2)	Yes
PDRBDED_BEGIN_DATE	DATE	No
PDRBDED_END_DATE	DATE	Yes
PDRBDED_ACTIVITY_DATE	DATE	No
PDRBDED_ARR_RECOVER_MAX	NUMBER(11,2)	Yes
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_CODE	PTRBDPD
PDRBDED_BDCA_CODE	PTRBDPD_BDCA_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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRBCOV	SQL Table	S10B80.PAYROLL	Refer (no action)
PDRDEDN	SQL Table	S10B80.PAYROLL	Join
PDRXPID	SQL Table	S10B80.PAYROLL	Refer (no action)
PERDTOT	SQL Table	S10B80.PAYROLL	Refer (no action)
PERPCRE	SQL Table	S10B80.PAYROLL	Refer (no action)
PHRDEDN	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDPL	SQL Table	S10B80.PAYROLL	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
PDVDED1	SQL View	S10B80.BANINST1	Use (select)
PDVDEDD	SQL View	S10B80.BANINST1	Use (select)
PDVDEDN	SQL View	S10B80.BANINST1	Use (select)
F_DEDUCTION_ROWID	SQL Function	S10B80.BANINST1	Use (select)
PDRBDED_TYPE	Oracle Package Type	S10B80.BANINST1.BWPKDBCV	Rely On
PDRBDED_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
INPUT_RECTYPE	Oracle Package Type	S10B80.BANINST1.PDKDEDN	Rely On
GETSECGRPC	Oracle Package Cursor	S10B80.BANINST1.BWPKEBST	Use (select)
PDRBDEDC	Oracle Package Cursor	S10B80.BANINST1.BWPKDBCV	Use (select)
PDRBDEDCODEC	Oracle Package Cursor	S10B80.BANINST1.BWPKDBCV	Use (select)
PDRBDEDCOVERAGESC	Oracle Package Cursor	S10B80.BANINST1.BWPKDBCV	Use (select)
P_BENEFITS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (select)
P_CROSS_FIELD_EDITS	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_INPUT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_INPUT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)Rely On
P_PRINTCOVEREDPERSONS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (select)
P_SAVE_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (Insert,update)Rely On
P_UPDATEDEDNEDITDRIVER	Oracle Package Procedure	S10B80.BANINST1.BWPKDUPD	Rely On
P_UPDATEDEDNPROCRECORDS	Oracle Package Procedure	S10B80.BANINST1.BWPKDUPD	Use (Insert,update,delete)
PDRBDED_REC2	Oracle Package Variable	S10B80.BANINST1.BWPKDBCV	Rely On
F_INVALID_DEDN_EXISTS	Oracle Package Function	S10B80.BANINST1.PB_EMPLOYEE_RULES	Use (select)
DEDNPRECLUDESC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
PDRBDEDVIEWC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PDRDEDNRANGECOUNTC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
P_APPLY_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_CHECK_FLEX	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_CHECK_PRECLUSION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_EDIT_ADD_REPL_IND	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_ADD_REPL_PICT_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_ARREAR_STATUS	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_END_DATE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_PEBEMPL_BCAT_CODE	Oracle Package Procedure	S10B80.BANINST1.NOKPLIB	Use (select)
P_MOVEUPDATESTODEDN	Oracle Package Procedure	S10B80.BANINST1.BWPKDOCM	Rely On
P_OPENENROLLMENTFUNCACTIVATE	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Rely On
P_OPENENROLLMENTFUNCADDBDED	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (Insert)
P_OPENENROLLMENTFUNCBACKOUT	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Rely On
P_OPENENROLLMENTFUNCDELBDED	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (delete)
P_OPENENROLLMENTFUNCUPDBDED	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (update)
P_UPDATEDEDNSELNEWDRIVER	Oracle Package Procedure	S10B80.BANINST1.BWPKDQRY	Rely On
P_VALIDATE_DELETE	Oracle Package Procedure	S10B80.BANINST1.PB_EMPLOYEE_RULES	Use (select)
P_VERIFYCOREBDCAEMP	Oracle Package Procedure	S10B80.BANINST1.PDKLIBS	Rely On
P_VERIFYCOREBDCAEMP	Oracle Package Procedure	S10B80.BANINST1.PDKLIBS	Use (select)
F_CHECK_REQD_DEDNS	Oracle Package Function	S10B80.BANINST1.POKLIBS	Use (select)
F_GETDEDNSTATUS	Oracle Package Function	S10B80.BANINST1.BWPKDBCV	Use (select)
F_INVALID_DEDN_EXISTS	Oracle Package Function	S10B80.BANINST1.PEKEMPL	Use (select)
PDRBDED	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_PDRBDED	SQL Index	S10B80.PAYROLL	Rely On
PEBEMPL	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDCA	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDCG	SQL Table	S10B80.PAYROLL	Join
PTRBDGM	SQL Table	S10B80.PAYROLL	Join
PTRBDPD	SQL Table	S10B80.PAYROLL	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PDRBDED

Object Dates

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

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

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
PDRDEDN_PIDM	NUMBER(8,0)	No	*	*
PDRDEDN_BDCA_CODE	VARCHAR2(3)	No	*	*
PDRDEDN_EFFECTIVE_DATE	DATE	No	*	*
PDRDEDN_STATUS	VARCHAR2(1)	No
PDRDEDN_REF_NO	VARCHAR2(10)	Yes
PDRDEDN_AMOUNT1	NUMBER(11,2)	Yes
PDRDEDN_AMOUNT2	NUMBER(11,2)	Yes
PDRDEDN_AMOUNT3	NUMBER(11,2)	Yes
PDRDEDN_AMOUNT4	NUMBER(11,2)	Yes
PDRDEDN_OPT_CODE1	VARCHAR2(2)	Yes
PDRDEDN_OPT_CODE2	VARCHAR2(2)	Yes
PDRDEDN_OPT_CODE3	VARCHAR2(2)	Yes
PDRDEDN_OPT_CODE4	VARCHAR2(2)	Yes
PDRDEDN_OPT_CODE5	VARCHAR2(2)	Yes
PDRDEDN_ACTIVITY_DATE	DATE	No
PDRDEDN_COVERAGE_DATE	DATE	Yes
PDRDEDN_BDCL_CODE	VARCHAR2(8)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
PDRDEDN_BDCL_CODE	PTRBDCL_CODE	PTRBDCL
PDRDEDN_PIDM	PDRBDED_PIDM	PDRBDED
PDRDEDN_BDCA_CODE	PDRBDED_BDCA_CODE	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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRFBAL	SQL Table	S10B80.PAYROLL	Join
PDRFCLM	SQL Table	S10B80.PAYROLL	Join
PERDHIS	SQL Table	S10B80.PAYROLL	Join
PTRBCDN	SQL Table	S10B80.PAYROLL	Join
PTRBDCA	SQL Table	S10B80.PAYROLL	Join
PTRBDPL	SQL Table	S10B80.PAYROLL	Join
PTRFBEN	SQL Table	S10B80.PAYROLL	Join
PDVDAMT	SQL View	S10B80.BANINST1	Use (select)
PDVDED1	SQL View	S10B80.BANINST1	Use (select)
PDVDEDD	SQL View	S10B80.BANINST1	Use (select)
PDVDEDN	SQL View	S10B80.BANINST1	Use (select)
F_DEDUCTION_ROWID	SQL Function	S10B80.BANINST1	Use (select)
PDRDEDN_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
INPUT_RECTYPE	Oracle Package Type	S10B80.BANINST1.PDKDEDN	Rely On
GETSECGRPC	Oracle Package Cursor	S10B80.BANINST1.BWPKEBST	Use (select)
PDRBDEDC	Oracle Package Cursor	S10B80.BANINST1.BWPKDBCV	Use (select)
PDRBDEDCOVERAGESC	Oracle Package Cursor	S10B80.BANINST1.BWPKDBCV	Use (select)
PDRDEDNMAXPAIDDATEC	Oracle Package Cursor	S10B80.BANINST1.BWPKDQRY	Use (select)
P_BENEFITS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (select)
P_CHK_WAIVED_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Rely On
P_CROSS_FIELD_EDITS	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_CROSS_FIELD_EDITS	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)Rely On
P_EDIT_INPUT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_INPUT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)Rely On
P_SAVE_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (Insert,update)Rely On
P_UPDATEDEDNPROCRECORDS	Oracle Package Procedure	S10B80.BANINST1.BWPKDUPD	Rely On
P_UPDATEDEDNPROCRECORDS	Oracle Package Procedure	S10B80.BANINST1.BWPKDUPD	Use (Insert,update,delete)Rely On
F_INVALID_DEDN_EXISTS	Oracle Package Function	S10B80.BANINST1.PB_EMPLOYEE_RULES	Use (select)
DEDNPRECLUDESC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
FLXSAMOUNTSC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
PDRDEDNBYDATEC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PDRDEDNBYRANGEC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PDRDEDNRANGECOUNTC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
P_APPLY_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_CHECK_PRECLUSION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_CHECK_PRECLUSION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT	Use (select)
P_DISPDEDNHISTDRIVER	Oracle Package Procedure	S10B80.BANINST1.BWPKDQRY	Rely On
P_EDIT_AMOUNT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_END_DATE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_END_DATE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_EDIT_NEW_EFFECTIVE_DATE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_OPT_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_PEBEMPL_BCAT_CODE	Oracle Package Procedure	S10B80.BANINST1.NOKPLIB	Use (select)
P_EDIT_STATUS	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_INSERT_FLEX_BALANCE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_OPENENROLLMENTCOST	Oracle Package Procedure	S10B80.BANINST1.BWPKDOCM	Rely On
P_OPENENROLLMENTCOST	Oracle Package Procedure	S10B80.BANINST1.BWPKDOCM	Use (select)Rely On
P_OPENENROLLMENTFUNCACTIVATE	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Rely On
P_OPENENROLLMENTFUNCADDDEDN	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (Insert)
P_OPENENROLLMENTFUNCDELDEDN	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (delete)
P_OPENENROLLMENTFUNCTERM	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Rely On
P_OPENENROLLMENTFUNCTERM	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (select)Rely On
P_OPENENROLLMENTFUNCUPDDEDN	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (update)
P_SETDEDNSTATUS	Oracle Package Procedure	S10B80.BANINST1.PDKLIBS	Rely On
P_SETDEDNSTATUS	Oracle Package Procedure	S10B80.BANINST1.PDKLIBS	Use (Insert,update,select)
P_VERIFYCOREBDCAEMP	Oracle Package Procedure	S10B80.BANINST1.PDKLIBS	Rely On
P_VERIFYCOREBDCAEMP	Oracle Package Procedure	S10B80.BANINST1.PDKLIBS	Use (select)
F_CHECK_REQD_DEDNS	Oracle Package Function	S10B80.BANINST1.POKLIBS	Use (select)
F_DEDNFUTURERECDATE	Oracle Package Function	S10B80.BANINST1.PDKLIBS	Use (select)
F_GETDEDNSTATUS	Oracle Package Function	S10B80.BANINST1.BWPKDBCV	Use (select)
F_INVALID_DEDN_EXISTS	Oracle Package Function	S10B80.BANINST1.PEKEMPL	Use (select)
PDRDEDN	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRDEDN_KEY2_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PK_PDRDEDN	SQL Index	S10B80.PAYROLL	Rely On
PDRBDED	SQL Table	S10B80.PAYROLL	Join
PTRBDCL	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDPD	SQL Table	S10B80.PAYROLL	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PDRDEDN

Object Dates

Creation Date	Analysis Date
04/02/2008 13:38:11:000	04/02/2008 13:49:12:000

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

Columns Comments for PDRDEDN_BDCL_CODE (# 17)

Source Code Comments

COMBINED LIMIT CODE: A code that defines combined annual limits for a benefit/deduction.

Table PDRFBAL

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
PDRFBAL_PLAN_YEAR	NUMBER(4,0)	No
PDRFBAL_PIDM	NUMBER(8,0)	No	*
PDRFBAL_BDCA_CODE	VARCHAR2(3)	No	*
PDRFBAL_PLAN_CODE	VARCHAR2(2)	Yes
PDRFBAL_AMOUNT_AVAIL	NUMBER(11,2)	Yes
PDRFBAL_AMOUNT_SPENT	NUMBER(11,2)	Yes
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRFBAL_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
P_UPDATEDEDNPROCRECORDS	Oracle Package Procedure	S10B80.BANINST1.BWPKDUPD	Use (Insert)
FLXSAMOUNTSC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
PDRFBALVIEWC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PTRFLEXC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
P_INSERT_FLEX_BALANCE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_INSERT_FLEX_BALANCE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (Insert,select)
P_OPENENROLLMENTFUNCADDDEDN	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (Insert)
PDRFBAL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRFBAL_KEY_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PDRDEDN	SQL Table	S10B80.PAYROLL	Join
PEBEMPL	SQL Table	S10B80.PAYROLL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PDRFBAL

Object Dates

Creation Date	Analysis Date
04/02/2008 13:32:27:000	04/02/2008 13:49:06:000

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

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
PDRFCLM_PIDM	NUMBER(8,0)	No	*
PDRFCLM_BDCA_CODE	VARCHAR2(3)	No	*
PDRFCLM_PLAN_CODE	VARCHAR2(2)	Yes
PDRFCLM_CLAIM_DATE	DATE	No
PDRFCLM_REF_NO	VARCHAR2(10)	Yes
PDRFCLM_CLAIM_AMT	NUMBER(11,2)	Yes
PDRFCLM_CLAIM_PAID	NUMBER(11,2)	Yes
PDRFCLM_ACTIVITY_DATE	DATE	No
PDRFCLM_PLAN_YEAR	NUMBER(4,0)	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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRFCLM_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
FLXSAMOUNTSC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
PDRFCLMBYDATEC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PDRFCLM	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRFCLM_KEY_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PDRDEDN	SQL Table	S10B80.PAYROLL	Join
PEBEMPL	SQL Table	S10B80.PAYROLL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PDRFCLM

Object Dates

Creation Date	Analysis Date
04/02/2008 13:33:51:000	04/02/2008 13:49:08:000

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.

Columns Comments for PDRFCLM_PLAN_YEAR (# 9)

Source Code Comments

PLAN YEAR DESCRIPTION: Flex benefit spending account year for which the claim is being posted.

Table PEBEMPL

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

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

Foreign Key information

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

Index

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

Calling objects (non escalated)

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

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PEBEMPL

Object Dates

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

Source Code Comments

Employee Base Table

Columns Comments for PEBEMPL_PIDM (# 1)

Source Code Comments

Internal Identification number of person.

Columns Comments for PEBEMPL_EMPL_STATUS (# 2)

Source Code Comments

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

Columns Comments for PEBEMPL_COAS_CODE_HOME (# 3)

Source Code Comments

The Home Chart of Accounts Code for the employee.

Columns Comments for PEBEMPL_ORGN_CODE_HOME (# 4)

Source Code Comments

The Home Organization code of the employee.

Columns Comments for PEBEMPL_COAS_CODE_DIST (# 5)

Source Code Comments

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

Columns Comments for PEBEMPL_ORGN_CODE_DIST (# 6)

Source Code Comments

The organization code used for document distribution.

Columns Comments for PEBEMPL_ECLS_CODE (# 7)

Source Code Comments

The employee grouping to which the employee belongs.

Columns Comments for PEBEMPL_LCAT_CODE (# 8)

Source Code Comments

The leave category to which the employee belongs.

Columns Comments for PEBEMPL_BCAT_CODE (# 9)

Source Code Comments

The benefit category to which the employee belongs.

Columns Comments for PEBEMPL_FIRST_HIRE_DATE (# 10)

Source Code Comments

The date the employee was first hired.

Columns Comments for PEBEMPL_CURRENT_HIRE_DATE (# 11)

Source Code Comments

The employees current date of hire.

Columns Comments for PEBEMPL_ADJ_SERVICE_DATE (# 12)

Source Code Comments

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

Columns Comments for PEBEMPL_SENIORITY_DATE (# 13)

Source Code Comments

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

Columns Comments for PEBEMPL_LREA_CODE (# 14)

Source Code Comments

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

Columns Comments for PEBEMPL_LOA_BEG_DATE (# 15)

Source Code Comments

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

Columns Comments for PEBEMPL_LOA_END_DATE (# 16)

Source Code Comments

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

Columns Comments for PEBEMPL_TREA_CODE (# 17)

Source Code Comments

Code used to identify the reason of termination.

Columns Comments for PEBEMPL_TERM_DATE (# 18)

Source Code Comments

Termination date of the employee.

Columns Comments for PEBEMPL_I9_FORM_IND (# 19)

Source Code Comments

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

Columns Comments for PEBEMPL_I9_DATE (# 20)

Source Code Comments

The date immigration information was received.

Columns Comments for PEBEMPL_I9_EXPIRE_DATE (# 21)

Source Code Comments

The date the immigration information expires.

Columns Comments for PEBEMPL_ACTIVITY_DATE (# 22)

Source Code Comments

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

Columns Comments for PEBEMPL_WKPR_CODE (# 23)

Source Code Comments

Work Period Code.

Columns Comments for PEBEMPL_FLSA_IND (# 24)

Source Code Comments

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

Columns Comments for PEBEMPL_STGR_CODE (# 25)

Source Code Comments

Statistics Canada Grouping Code.

Columns Comments for PEBEMPL_DAYS_IN_CANADA (# 26)

Source Code Comments

Number of days the employee worked in Canada.

Columns Comments for PEBEMPL_1042_RECIPIENT_CD (# 27)

Source Code Comments

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

Columns Comments for PEBEMPL_INTERNAL_FT_PT_IND (# 28)

Source Code Comments

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

Columns Comments for PEBEMPL_DICD_CODE (# 29)

Source Code Comments

The district or division associated with an employee.

Columns Comments for PEBEMPL_EGRP_CODE (# 30)

Source Code Comments

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

Columns Comments for PEBEMPL_IPEDS_SOFT_MONEY_IND (# 31)

Source Code Comments

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

Columns Comments for PEBEMPL_FIRST_WORK_DATE (# 32)

Source Code Comments

The first day that the employee worked.

Columns Comments for PEBEMPL_LAST_WORK_DATE (# 33)

Source Code Comments

The last day that the employee worked.

Columns Comments for PEBEMPL_CALIF_PENSION_IND (# 34)

Source Code Comments

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

Columns Comments for PEBEMPL_NRSI_CODE (# 35)

Source Code Comments

Non-resident Service Code.

Columns Comments for PEBEMPL_SSN_LAST_NAME (# 36)

Source Code Comments

Social security last name used in reporting.

Columns Comments for PEBEMPL_SSN_FIRST_NAME (# 37)

Source Code Comments

Social security first name used in reporting.

Columns Comments for PEBEMPL_SSN_MI (# 38)

Source Code Comments

Social security middle name used in reporting.

Columns Comments for PEBEMPL_SSN_SUFFIX (# 39)

Source Code Comments

Social security name suffix used in reporting.

Columns Comments for PEBEMPL_JBLN_CODE (# 40)

Source Code Comments

The Location to which the employee belongs.

Columns Comments for PEBEMPL_COLL_CODE (# 41)

Source Code Comments

The College to which the employee belongs.

Columns Comments for PEBEMPL_CAMP_CODE (# 42)

Source Code Comments

The Campus to which the employee belongs.

Columns Comments for PEBEMPL_USER_ID (# 43)

Source Code Comments

The user who last created or updated the employee record.

Columns Comments for PEBEMPL_DATA_ORIGIN (# 44)

Source Code Comments

Source system that generated the data.

Columns Comments for PEBEMPL_EW2_CONSENT_IND (# 45)

Source Code Comments

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

Columns Comments for PEBEMPL_EW2_CONSENT_DATE (# 46)

Source Code Comments

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

Columns Comments for PEBEMPL_EW2_CONSENT_USER_ID (# 47)

Source Code Comments

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

Columns Comments for PEBEMPL_IPEDS_PRIMARY_FUNCTION (# 48)

Source Code Comments

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

Columns Comments for PEBEMPL_IPEDS_MED_DENTAL_IND (# 49)

Source Code Comments

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

Columns Comments for PEBEMPL_ETAX_CONSENT_IND (# 50)

Source Code Comments

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

Columns Comments for PEBEMPL_ETAX_CONSENT_DATE (# 51)

Source Code Comments

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

Columns Comments for PEBEMPL_ETAX_CONSENT_USER_ID (# 52)

Source Code Comments

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

Table PER1042

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
PER1042_PIDM	NUMBER(8,0)	No
PER1042_ID	VARCHAR2(9)	No
PER1042_INCOME_CODE	VARCHAR2(2)	No
PER1042_EXEMPTION_CODE	VARCHAR2(1)	No
PER1042_WITHHOLDING_RATE	NUMBER(7,2)	No
PER1042_COUNTRY_CODE	VARCHAR2(2)	No
PER1042_SSN	VARCHAR2(15)	Yes
PER1042_LAST_NAME	VARCHAR2(60)	Yes
PER1042_FIRST_NAME	VARCHAR2(60)	Yes
PER1042_MI	VARCHAR2(60)	Yes
PER1042_BIRTH_DATE	DATE	Yes
PER1042_GROSS_INCOME_PAID	NUMBER(11,2)	Yes
PER1042_WITHHOLDING_ALLOW	NUMBER(9,2)	Yes
PER1042_WITHHELD_AMOUNT	NUMBER(9,2)	Yes
PER1042_INCOME_CODE_SUBTYPE	VARCHAR2(1)	Yes
PER1042_CYCLE_DATE	DATE	Yes
PER1042_TAX_YEAR	VARCHAR2(4)	Yes
PER1042_STATE_WH_AMOUNT	NUMBER(11,2)	Yes
PER1042_STATE_CODE	VARCHAR2(2)	Yes
PER1042_RECORD_STATUS	VARCHAR2(1)	Yes
PER1042_LAST_EARN_DATE	DATE	Yes
PER1042_SURNAME_PREFIX	VARCHAR2(60)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
UK_PER1042	Unique	PER1042_PIDM
UK_PER1042	Unique	PER1042_INCOME_CODE
UK_PER1042	Unique	PER1042_EXEMPTION_CODE
UK_PER1042	Unique	PER1042_INCOME_CODE_SUBTYPE
UK_PER1042	Unique	PER1042_WITHHOLDING_RATE
UK_PER1042	Unique	PER1042_COUNTRY_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PER1042

Object Dates

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

Source Code Comments

1042S Information Upload Repeating Table.

Columns Comments for PER1042_PIDM (# 1)

Source Code Comments

PIDM: Internal identification number of the person.

Columns Comments for PER1042_ID (# 2)

Source Code Comments

ID: This field defines the identification number used to access person on-line.

Columns Comments for PER1042_INCOME_CODE (# 3)

Source Code Comments

INCOME CODE: The code which identifies the type of income received in association with this 1042 record.

Columns Comments for PER1042_EXEMPTION_CODE (# 4)

Source Code Comments

EXEMPTION CODE: Indicates a reason as to why these dollars are exempt from taxation. 0=Not Exempt, 1=Income effectively connected with US trade or business, 2=Exempt, 3=Income is non-US sourced, 4=No withholding per treaty.

Columns Comments for PER1042_WITHHOLDING_RATE (# 5)

Source Code Comments

TAX RATE: The value which indentifies the tax rate on which the withholding is calculated in association with this 1042 record.

Columns Comments for PER1042_COUNTRY_CODE (# 6)

Source Code Comments

COUNTRY CODE: The code which identifies the country for which tax treaty benefits and rates are based on in association with this 1042 record.

Columns Comments for PER1042_SSN (# 7)

Source Code Comments

SSN: Social Security Number.

Columns Comments for PER1042_LAST_NAME (# 8)

Source Code Comments

LAST NAME: This field defines the last name of person.

Columns Comments for PER1042_FIRST_NAME (# 9)

Source Code Comments

FIRST NAME: This field identifies the first name of person.

Columns Comments for PER1042_MI (# 10)

Source Code Comments

MIDDLE NAME: This field identifies the middle name of person.

Columns Comments for PER1042_BIRTH_DATE (# 11)

Source Code Comments

BIRTH DATE: Date of Birth.

Columns Comments for PER1042_GROSS_INCOME_PAID (# 12)

Source Code Comments

GROSS INCOME PAID: The total amount paid.

Columns Comments for PER1042_WITHHOLDING_ALLOW (# 13)

Source Code Comments

WITHHOLDING ALLOWANCE: The value which indentifies the amount exempted from gross before the tax is calculated in association with this 1042 record.

Columns Comments for PER1042_WITHHELD_AMOUNT (# 14)

Source Code Comments

US FEDERAL TAX: Federal Tax With held.

Columns Comments for PER1042_INCOME_CODE_SUBTYPE (# 15)

Source Code Comments

INCOME CODE SUBTYPE: Income code subtype associated with the income code.

Columns Comments for PER1042_CYCLE_DATE (# 16)

Source Code Comments

CYCLE DATE: Last payroll date

Columns Comments for PER1042_TAX_YEAR (# 17)

Source Code Comments

TAX YEAR: Tax year.

Columns Comments for PER1042_STATE_WH_AMOUNT (# 18)

Source Code Comments

STATE WITHHELD AMOUNT: State Withheld Amount.

Columns Comments for PER1042_STATE_CODE (# 19)

Source Code Comments

STATE CODE: State Code.

Columns Comments for PER1042_RECORD_STATUS (# 20)

Source Code Comments

RECORD STATUS: Records status Actual or Forecast Data.

Columns Comments for PER1042_LAST_EARN_DATE (# 21)

Source Code Comments

LAST EARN DATE: Last payroll Date.

Columns Comments for PER1042_SURNAME_PREFIX (# 22)

Source Code Comments

SURNAME PREFIX: Name tag preceding the last name or surname. (Van, Von, Mac, etc.)

Table PERDHIS

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
PERDHIS_PIDM	NUMBER(8,0)	No	*
PERDHIS_EFFECTIVE_DATE	DATE	No	*
PERDHIS_BDCA_CODE	VARCHAR2(3)	No	*
PERDHIS_STATUS	VARCHAR2(1)	Yes
PERDHIS_ADD_REPL_IND	VARCHAR2(1)	Yes
PERDHIS_ADD_REPL_EMPL	NUMBER(11,2)	Yes
PERDHIS_ADD_REPL_EMPR	NUMBER(11,2)	Yes
PERDHIS_ADD_REPL_TAX_BASE	NUMBER(11,2)	Yes
PERDHIS_ARR_STATUS	VARCHAR2(1)	Yes
PERDHIS_ARR_BALANCE	NUMBER(11,2)	Yes
PERDHIS_BEGIN_DATE	DATE	Yes
PERDHIS_END_DATE	DATE	Yes
PERDHIS_REF_NO	VARCHAR2(10)	Yes
PERDHIS_AMOUNT1	NUMBER(11,2)	Yes
PERDHIS_AMOUNT2	NUMBER(11,2)	Yes
PERDHIS_AMOUNT3	NUMBER(11,2)	Yes
PERDHIS_AMOUNT4	NUMBER(11,2)	Yes
PERDHIS_OPT_CODE1	VARCHAR2(2)	Yes
PERDHIS_OPT_CODE2	VARCHAR2(2)	Yes
PERDHIS_OPT_CODE3	VARCHAR2(2)	Yes
PERDHIS_OPT_CODE4	VARCHAR2(2)	Yes
PERDHIS_OPT_CODE5	VARCHAR2(2)	Yes
PERDHIS_CALC_INS_SALA	NUMBER(11,2)	Yes
PERDHIS_USER_ID	VARCHAR2(30)	No
PERDHIS_ACTIVITY_DATE	DATE	No
PERDHIS_ARR_RECOVER_MAX	NUMBER(11,2)	Yes
PERDHIS_DELETED_IND	VARCHAR2(1)	No
PERDHIS_CAPTURE_DATE	DATE	No
PERDHIS_OPEN_ENROLL_IND	VARCHAR2(1)	No
PERDHIS_ADD_REPL_PICT_CODE	VARCHAR2(2)	Yes
PERDHIS_BDCL_CODE	VARCHAR2(8)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
PERDHIS_PIDM	PDRDEDN_PIDM	PDRDEDN
PERDHIS_EFFECTIVE_DATE	PDRDEDN_EFFECTIVE_DATE	PDRDEDN
PERDHIS_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN

Index

Index Name	Index Type	Column Name
PERDHIS_KEY_INDEX		PERDHIS_PIDM
PERDHIS_KEY_INDEX		PERDHIS_EFFECTIVE_DATE
PERDHIS_KEY_INDEX		PERDHIS_BDCA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PERDHIS_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
DHISPRECLUDESC	Oracle Package Cursor	S10B80.BANINST1.BWPKDOEN	Use (select)
DHISPRECLUDESC	Oracle Package Cursor	S10B80.BANINST1.BWPKDOFN	Use (select)
P_CHK_WAIVED_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Rely On
P_CHK_WAIVED_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Use (select)
P_OPENENROLLMENTGRPSHOW	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Use (select)
P_SAVE_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (Insert)
P_UPDATEDEDNPROCRECORDS	Oracle Package Procedure	S10B80.BANINST1.BWPKDUPD	Use (Insert)
PERDHISBYDATEC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
P_OPENENROLLMENTCOST	Oracle Package Procedure	S10B80.BANINST1.BWPKDOCM	Rely On
P_OPENENROLLMENTCOST	Oracle Package Procedure	S10B80.BANINST1.BWPKDOCM	Use (select)
P_OPENENROLLMENTFUNCACTIVATE	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Rely On
P_OPENENROLLMENTFUNCACTIVATE	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (select)
P_OPENENROLLMENTFUNCADDDHIS	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (Insert)
P_OPENENROLLMENTFUNCBACKOUT	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Rely On
P_OPENENROLLMENTFUNCCLEAR	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (delete)
P_OPENENROLLMENTFUNCCLEARGRP	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (delete)
P_OPENENROLLMENTFUNCDELDHIS	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (delete)
P_OPENENROLLMENTFUNCDELE	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (delete)
P_OPENENROLLMENTFUNCTERM	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (select)Rely On
P_OPENENROLLMENTFUNCUPDDHIS	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Use (update)
P_SETDEDNSTATUS	Oracle Package Procedure	S10B80.BANINST1.PDKLIBS	Use (Insert,select)
F_GETMAXDHISCAPTURENONOE	Oracle Package Function	S10B80.BANINST1.BWPKDOCM	Use (select)
F_GETMAXDHISCAPTUREOE	Oracle Package Function	S10B80.BANINST1.BWPKDOCM	Use (select)
F_GETMAXDHISEFFECTIVENONOE	Oracle Package Function	S10B80.BANINST1.BWPKDOCM	Use (select)
F_GETMAXENDDATENONOE	Oracle Package Function	S10B80.BANINST1.BWPKDOCM	Use (select)
PERDHIS	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PERDHIS_KEY_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PDRDEDN	SQL Table	S10B80.PAYROLL	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PERDHIS

Object Dates

Creation Date	Analysis Date
04/02/2008 13:40:27:000	04/02/2008 13:49:15:000

Source Code Comments

Employee Deduction History Repeating Table

Columns Comments for PERDHIS_PIDM (# 1)

Source Code Comments

PIDM : Internal System Identification Number.

Columns Comments for PERDHIS_EFFECTIVE_DATE (# 2)

Source Code Comments

DEDUCTION EFFECTIVE DATE: Date from which this record was effective.

Columns Comments for PERDHIS_BDCA_CODE (# 3)

Source Code Comments

BENEFIT CODE: System defined code for employee benefit/deduction.

Columns Comments for PERDHIS_STATUS (# 4)

Source Code Comments

DEDUTION STATUS: Status of the benefit/deduction. Values (A)ctive, (W)aived, (T)erminated.

Columns Comments for PERDHIS_ADD_REPL_IND (# 5)

Source Code Comments

ADD/REPLACE INDICATOR: Values (A)dd to the employee normal deduction amount or (R)eplace the employee normal deduction amount.

Columns Comments for PERDHIS_ADD_REPL_EMPL (# 6)

Source Code Comments

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

Columns Comments for PERDHIS_ADD_REPL_EMPR (# 7)

Source Code Comments

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

Columns Comments for PERDHIS_ADD_REPL_TAX_BASE (# 8)

Source Code Comments

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

Columns Comments for PERDHIS_ARR_STATUS (# 9)

Source Code Comments

ARREARS PROCESSING STATUS: Values (Y)es, arrears for this deduction will be processed. (N)o arrears for this deduction will not be processed.

Columns Comments for PERDHIS_ARR_BALANCE (# 10)

Source Code Comments

ARREAR BALANCE: The arrear balance due the employer.

Columns Comments for PERDHIS_BEGIN_DATE (# 11)

Source Code Comments

DEDUCTION BEGIN DATE: Date the deduction/benefit began.

Columns Comments for PERDHIS_END_DATE (# 12)

Source Code Comments

DEDUCTION END DATE: Date the deduction/benefit ends.

Columns Comments for PERDHIS_REF_NO (# 13)

Source Code Comments

REFERENCE NUMBER: An optional alphanumeric free form field.

Columns Comments for PERDHIS_AMOUNT1 (# 14)

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 this deduction.

Columns Comments for PERDHIS_AMOUNT2 (# 15)

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 this deduction.

Columns Comments for PERDHIS_AMOUNT3 (# 16)

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 this deduction.

Columns Comments for PERDHIS_AMOUNT4 (# 17)

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 this deduction.

Columns Comments for PERDHIS_OPT_CODE1 (# 18)

Source Code Comments

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

Columns Comments for PERDHIS_OPT_CODE2 (# 19)

Source Code Comments

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

Columns Comments for PERDHIS_OPT_CODE3 (# 20)

Source Code Comments

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

Columns Comments for PERDHIS_OPT_CODE4 (# 21)

Source Code Comments

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

Columns Comments for PERDHIS_OPT_CODE5 (# 22)

Source Code Comments

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

Columns Comments for PERDHIS_CALC_INS_SALA (# 23)

Source Code Comments

CALCULATED INSURANCE SALARY: The salary calculated in the Life Insurance Calculation Process(pdplife) to determine the employee life insurance coverage.

Columns Comments for PERDHIS_USER_ID (# 24)

Source Code Comments

USER ID: ORACLE Id of the User whose modifications resulted in the creation of this deduction history record.

Columns Comments for PERDHIS_ACTIVITY_DATE (# 25)

Source Code Comments

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

Columns Comments for PERDHIS_ARR_RECOVER_MAX (# 26)

Source Code Comments

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

Columns Comments for PERDHIS_DELETED_IND (# 27)

Source Code Comments

DELETED INDICATOR: Indicates if the Benefits/Deduction record has been deleted.

Columns Comments for PERDHIS_CAPTURE_DATE (# 28)

Source Code Comments

CAPTURE DATE: The date of the budget transaction.

Columns Comments for PERDHIS_OPEN_ENROLL_IND (# 29)

Source Code Comments

OPEN ENROLLMENT IND: This indicates if a record was created from Open Enrollment through the Web. These records will not be displayed in PDADEDN

Columns Comments for PERDHIS_ADD_REPL_PICT_CODE (# 30)

Source Code Comments

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

Columns Comments for PERDHIS_BDCL_CODE (# 31)

Source Code Comments

COMBINED LIMIT CODE: A code that defines combined annual limits for a benefit/deduction.

Table PERINDV

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
PERINDV_PIDM	NUMBER(8,0)	No	*
PERINDV_ID	VARCHAR2(9)	No
PERINDV_SSN	VARCHAR2(15)	Yes
PERINDV_LAST_NAME	VARCHAR2(60)	Yes
PERINDV_FIRST_NAME	VARCHAR2(60)	Yes
PERINDV_MI	VARCHAR2(60)	Yes
PERINDV_BIRTH_DATE	DATE	Yes
PERINDV_TITLE	VARCHAR2(20)	Yes
PERINDV_SUFFIX	VARCHAR2(20)	Yes
PERINDV_US_STREET_LINE1	VARCHAR2(75)	Yes
PERINDV_US_STREET_LINE2	VARCHAR2(75)	Yes
PERINDV_US_STREET_LINE3	VARCHAR2(75)	Yes
PERINDV_US_CITY	VARCHAR2(50)	Yes
PERINDV_US_STATE	VARCHAR2(2)	Yes
PERINDV_US_ZIP	VARCHAR2(30)	Yes
PERINDV_FR_STREET_LINE1	VARCHAR2(75)	Yes
PERINDV_FR_STREET_LINE2	VARCHAR2(75)	Yes
PERINDV_FR_STREET_LINE3	VARCHAR2(75)	Yes
PERINDV_FR_CITY	VARCHAR2(50)	Yes
PERINDV_FR_STATE	VARCHAR2(2)	Yes
PERINDV_FR_ZIP	VARCHAR2(30)	Yes
PERINDV_FR_COUNTRY_CODE	VARCHAR2(2)	Yes
PERINDV_CITZ_COUNTRY_CODE	VARCHAR2(2)	Yes
PERINDV_TAX_RES_COUNTRY_CODE	VARCHAR2(2)	Yes
PERINDV_SURNAME_PREFIX	VARCHAR2(60)	Yes
PERINDV_US_HOUSE_NUMBER	VARCHAR2(10)	Yes
PERINDV_US_STREET_LINE4	VARCHAR2(75)	Yes
PERINDV_FR_HOUSE_NUMBER	VARCHAR2(10)	Yes
PERINDV_FR_STREET_LINE4	VARCHAR2(75)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PERINDV	Unique	PERINDV_PIDM

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PERINDV

Object Dates

Creation Date	Analysis Date
04/02/2008 13:38:07:000	04/02/2008 13:49:12:000

Source Code Comments

Individual Information Upload Repeating Table.

Columns Comments for PERINDV_PIDM (# 1)

Source Code Comments

PIDM: Internal identification number of the person.

Columns Comments for PERINDV_ID (# 2)

Source Code Comments

ID: This field defines the identification number used to access person on-line.

Columns Comments for PERINDV_SSN (# 3)

Source Code Comments

SSN: Social Security Number.

Columns Comments for PERINDV_LAST_NAME (# 4)

Source Code Comments

LAST NAME: This field defines the last name of person.

Columns Comments for PERINDV_FIRST_NAME (# 5)

Source Code Comments

FIRST NAME: This field identifies the first name of person.

Columns Comments for PERINDV_MI (# 6)

Source Code Comments

MIDDLE NAME: This field identifies the middle name of person.

Columns Comments for PERINDV_BIRTH_DATE (# 7)

Source Code Comments

BIRTH DATE: Date of Birth.

Columns Comments for PERINDV_TITLE (# 8)

Source Code Comments

TITLE This field maintains the prefix (Mr, Mrs, etc) used before person name.

Columns Comments for PERINDV_SUFFIX (# 9)

Source Code Comments

SUFFIX: This field maintains the suffix (Jr, Sr, etc) used after person name.

Columns Comments for PERINDV_US_STREET_LINE1 (# 10)

Source Code Comments

US_STREET_LINE1: This field maintains the first line of the address associated with person.

Columns Comments for PERINDV_US_STREET_LINE2 (# 11)

Source Code Comments

US_STREET_LINE2: This field maintains the second line of the address associated with person.

Columns Comments for PERINDV_US_STREET_LINE3 (# 12)

Source Code Comments

US_STREET_LINE3: This field maintains the third line of the address associated with person.

Columns Comments for PERINDV_US_CITY (# 13)

Source Code Comments

US_CITY: This field maintains the city associated with the address of person.

Columns Comments for PERINDV_US_STATE (# 14)

Source Code Comments

US_STATE: This field maintains the state associated with the address of person.

Columns Comments for PERINDV_US_ZIP (# 15)

Source Code Comments

US_ZIP: This field maintains the zip code associated with the address of person.

Columns Comments for PERINDV_FR_STREET_LINE1 (# 16)

Source Code Comments

FR_STREET_LINE1: This field maintains the first line of the foreign address associated with person.

Columns Comments for PERINDV_FR_STREET_LINE2 (# 17)

Source Code Comments

FR_STREET_LINE2: This field maintains the second line of the foreign address associated with person.

Columns Comments for PERINDV_FR_STREET_LINE3 (# 18)

Source Code Comments

FR_STREET_LINE3: This field maintains the third line of the foreign address associated with person.

Columns Comments for PERINDV_FR_CITY (# 19)

Source Code Comments

FR_CITY: This field maintains the city associated with the address of person.

Columns Comments for PERINDV_FR_STATE (# 20)

Source Code Comments

FR_STATE: This field maintains the foreign state associated with the address of person.

Columns Comments for PERINDV_FR_ZIP (# 21)

Source Code Comments

FR_ZIP: This field maintains the foreign zip code associated with the address of person.

Columns Comments for PERINDV_FR_COUNTRY_CODE (# 22)

Source Code Comments

FR_COUNTRY_CODE: This field maintains the nation/country associated with the address of person.

Columns Comments for PERINDV_CITZ_COUNTRY_CODE (# 23)

Source Code Comments

CITZ_COUNTRY_CODE: This field maintains the citizenship nation/country associated with the person.

Columns Comments for PERINDV_TAX_RES_COUNTRY_CODE (# 24)

Source Code Comments

TAX_RES_COUNTRY_CODE: This field maintains the Tax Residency nation/country associated with the person.

Columns Comments for PERINDV_SURNAME_PREFIX (# 25)

Source Code Comments

SURNAME PREFIX: Name tag preceding the last name or surname. (Van, Von, Mac, etc.)

Columns Comments for PERINDV_US_HOUSE_NUMBER (# 26)

Source Code Comments

US HOUSE NUMBER: Building or lot number on a street or in an area of the US address associated with person.

Columns Comments for PERINDV_US_STREET_LINE4 (# 27)

Source Code Comments

US STREET LINE 4: This field maintains the fourth line of the US address associated with person.

Columns Comments for PERINDV_FR_HOUSE_NUMBER (# 28)

Source Code Comments

FOREIGN HOUSE NUMBER: Building or lot number on a street or in an area of the foreign address associated with person.

Columns Comments for PERINDV_FR_STREET_LINE4 (# 29)

Source Code Comments

FOREIGN STREET LINE 4: This field maintains the fourth line of the foreign address associated with person.

Table PHR1042

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
PHR1042_YEAR	VARCHAR2(4)	No	*
PHR1042_PICT_CODE	VARCHAR2(2)	No	*
PHR1042_PAYNO	NUMBER(3,0)	No	*
PHR1042_PIDM	NUMBER(8,0)	No	*
PHR1042_SEQ_NO	NUMBER(2,0)	No	*
PHR1042_EMPR_CODE	VARCHAR2(4)	No
PHR1042_INCOME_CD	VARCHAR2(2)	No
PHR1042_COUNTRY_CD	VARCHAR2(2)	No
PHR1042_TAX_RATE	NUMBER(7,4)	No
PHR1042_EXEMPTION_CD	VARCHAR2(1)	No
PHR1042_GRADUATED_TAX_IND	VARCHAR2(1)	No
PHR1042_GROSS_INCOME_PAID	NUMBER(11,2)	Yes
PHR1042_WITHHOLDING_ALLOW	NUMBER(9,2)	Yes
PHR1042_US_FEDERAL_TAX	NUMBER(9,2)	Yes
PHR1042_ACTIVITY_DATE	DATE	Yes
PHR1042_BDCA_CODE	VARCHAR2(3)	No
PHR1042_ALLOWANCE_TAKEN	NUMBER(9,2)	Yes
PHR1042_INCOME_CD_SUB_TYPE	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
PHR1042_SEQ_NO	PHRHIST_SEQ_NO	PHRHIST
PHR1042_PIDM	PHRHIST_PIDM	PHRHIST
PHR1042_PAYNO	PHRHIST_PAYNO	PHRHIST
PHR1042_PICT_CODE	PHRHIST_PICT_CODE	PHRHIST
PHR1042_YEAR	PHRHIST_YEAR	PHRHIST

Index

Index Name	Index Type	Column Name
PHR1042_KEY_INDEX	Unique	PHR1042_YEAR
PHR1042_KEY_INDEX	Unique	PHR1042_PICT_CODE
PHR1042_KEY_INDEX	Unique	PHR1042_PAYNO
PHR1042_KEY_INDEX	Unique	PHR1042_PIDM
PHR1042_KEY_INDEX	Unique	PHR1042_SEQ_NO
PHR1042_KEY_INDEX	Unique	PHR1042_EMPR_CODE
PHR1042_KEY_INDEX	Unique	PHR1042_BDCA_CODE
PHR1042_KEY_INDEX	Unique	PHR1042_INCOME_CD
PHR1042_KEY_INDEX	Unique	PHR1042_COUNTRY_CD
PHR1042_KEY_INDEX	Unique	PHR1042_TAX_RATE
PHR1042_KEY_INDEX	Unique	PHR1042_EXEMPTION_CD
PHR1042_KEY_INDEX	Unique	PHR1042_GRADUATED_TAX_IND

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2006	Use (select)
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2007	Use (select)
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2	Use (select)
PHR1042	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PHR1042_KEY_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PHRHIST	SQL Table	S10B80.PAYROLL	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PHR1042

Object Dates

Creation Date	Analysis Date
04/02/2008 13:39:45:000	04/02/2008 13:49:14:000

Source Code Comments

1042 REPORTING TABLE

Columns Comments for PHR1042_YEAR (# 1)

Source Code Comments

YEAR: The year associated with this 1042 record.

Columns Comments for PHR1042_PICT_CODE (# 2)

Source Code Comments

PAYROLL IDENTIFICATION CODE: The payroll identification code of the pay event associated with this 1042 record.

Columns Comments for PHR1042_PAYNO (# 3)

Source Code Comments

PAYROLL NUMBER: The payroll number of the pay event associated with this 1042 record.

Columns Comments for PHR1042_PIDM (# 4)

Source Code Comments

PIDM: The internal ID number associated with this 1042 record.

Columns Comments for PHR1042_SEQ_NO (# 5)

Source Code Comments

SEQUENCE NUMBER: The sequence number of the pay event associated with this 1042 record.

Columns Comments for PHR1042_EMPR_CODE (# 6)

Source Code Comments

EMPLOYER CODE: The employer code associated with this 1042 record.

Columns Comments for PHR1042_INCOME_CD (# 7)

Source Code Comments

INCOME CODE: The code which identifies the type of income received in association with this 1042 record.

Columns Comments for PHR1042_COUNTRY_CD (# 8)

Source Code Comments

COUNTRY CODE: The code which identifies the country for which tax treaty benefits and rates are based on in association with this 1042 record.

Columns Comments for PHR1042_TAX_RATE (# 9)

Source Code Comments

TAX RATE: The value which indentifies the tax rate on which the withholding is calculated in association with this 1042 record.

Columns Comments for PHR1042_EXEMPTION_CD (# 10)

Source Code Comments

Columns Comments for PHR1042_GRADUATED_TAX_IND (# 11)

Source Code Comments

GRADUATED TAX INDICATOR: Indicates whether the tax rate associated with this 1042 record is graduated or not.

Columns Comments for PHR1042_GROSS_INCOME_PAID (# 12)

Source Code Comments

GROSS INCOME PAID: The total amount paid.

Columns Comments for PHR1042_WITHHOLDING_ALLOW (# 13)

Source Code Comments

WITHHOLDING ALLOWANCE: The value which indentifies the amount exempted from gross before the tax is calculated in association with this 1042 record.

Columns Comments for PHR1042_US_FEDERAL_TAX (# 14)

Source Code Comments

US FEDERAL TAX:

Columns Comments for PHR1042_ACTIVITY_DATE (# 15)

Source Code Comments

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

Columns Comments for PHR1042_BDCA_CODE (# 16)

Source Code Comments

BENEFIT/DEDUCTION CODE: Benefit/Deduction Code in Association with This 1042 Record.

Columns Comments for PHR1042_ALLOWANCE_TAKEN (# 17)

Source Code Comments

ALLOWANCE AMOUNT TAKEN: The Value which Indentifies the Amount Taken from Allowance in Association with This 1042 Record.

Columns Comments for PHR1042_INCOME_CD_SUB_TYPE (# 18)

Source Code Comments

INCOME CODE SUB TYPE: This field indicates income code sub type associated with the income code.

Table PHRHIST

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
PHRHIST_YEAR	VARCHAR2(4)	No	*	*
PHRHIST_PICT_CODE	VARCHAR2(2)	No	*	*
PHRHIST_PAYNO	NUMBER(3,0)	No	*	*
PHRHIST_PIDM	NUMBER(8,0)	No	*	*
PHRHIST_SEQ_NO	NUMBER(2,0)	No	*	*
PHRHIST_DISP	VARCHAR2(2)	No
PHRHIST_EVENT_DATE	DATE	Yes
PHRHIST_GROSS	NUMBER(11,2)	Yes
PHRHIST_NET	NUMBER(11,2)	Yes
PHRHIST_TYPE_IND	VARCHAR2(1)	No
PHRHIST_CALC_IND	VARCHAR2(1)	No
PHRHIST_PRINT_IND	VARCHAR2(1)	No
PHRHIST_ADJS_SEQ_NO	NUMBER(2,0)	Yes
PHRHIST_ADJS_DATE	DATE	Yes
PHRHIST_ADJ_BY_SEQ_NO	VARCHAR2(2)	Yes
PHRHIST_ADJ_BY_DATE	DATE	Yes
PHRHIST_ASSOC_SEQ_NO	NUMBER(2,0)	Yes
PHRHIST_ACTIVITY_DATE	DATE	No
PHRHIST_UI_WEEKS	NUMBER(5,3)	Yes
PHRHIST_UI_EXCEPTION_IND	VARCHAR2(1)	Yes
PHRHIST_UPDT_DATE	DATE	Yes
PHRHIST_POSTING_OVERRIDE_DATE	DATE	Yes
PHRHIST_USER_ID	VARCHAR2(30)	Yes
PHRHIST_COMMENT	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
PHRHIST_YEAR	PTRCALN_YEAR	PTRCALN
PHRHIST_PICT_CODE	PTRCALN_PICT_CODE	PTRCALN
PHRHIST_PAYNO	PTRCALN_PAYNO	PTRCALN
PHRHIST_PIDM	PEBEMPL_PIDM	PEBEMPL
PHRHIST_YEAR	PHRJOBS_YEAR	PHRJOBS
PHRHIST_PICT_CODE	PHRJOBS_PICT_CODE	PHRJOBS
PHRHIST_PAYNO	PHRJOBS_PAYNO	PHRJOBS
PHRHIST_SEQ_NO	PHRJOBS_SEQ_NO	PHRJOBS
PHRHIST_PIDM	PHRJOBS_PIDM	PHRJOBS
PHRHIST_SEQ_NO	PHRDOCM_SEQ_NO	PHRDOCM
PHRHIST_PAYNO	PHRDOCM_PAYNO	PHRDOCM
PHRHIST_PICT_CODE	PHRDOCM_PICT_CODE	PHRDOCM
PHRHIST_YEAR	PHRDOCM_YEAR	PHRDOCM
PHRHIST_PIDM	PHRDOCM_PIDM	PHRDOCM

Index

Index Name	Index Type	Column Name
PHRHIST_KEY2_INDEX		PHRHIST_PIDM
PHRHIST_KEY2_INDEX		PHRHIST_YEAR
PHRHIST_KEY2_INDEX		PHRHIST_PICT_CODE
PHRHIST_KEY2_INDEX		PHRHIST_PAYNO
PHRHIST_KEY2_INDEX		PHRHIST_SEQ_NO
PHRHIST_KEY3_INDEX		PHRHIST_DISP
PHRHIST_KEY3_INDEX		PHRHIST_YEAR
PHRHIST_KEY3_INDEX		PHRHIST_PICT_CODE
PHRHIST_KEY3_INDEX		PHRHIST_PAYNO
PHRHIST_KEY3_INDEX		PHRHIST_PRINT_IND
PHRHIST_KEY4_INDEX		PHRHIST_YEAR
PHRHIST_KEY4_INDEX		PHRHIST_PICT_CODE
PHRHIST_KEY4_INDEX		PHRHIST_PAYNO
PHRHIST_KEY4_INDEX		PHRHIST_SEQ_NO
PHRHIST_KEY4_INDEX		PHRHIST_DISP
PHRHIST_KEY5_INDEX		PHRHIST_UPDT_DATE
PK_PHRHIST	Unique	PHRHIST_YEAR
PK_PHRHIST	Unique	PHRHIST_PICT_CODE
PK_PHRHIST	Unique	PHRHIST_PAYNO
PK_PHRHIST	Unique	PHRHIST_PIDM
PK_PHRHIST	Unique	PHRHIST_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PERJLEV	SQL Table	S10B80.PAYROLL	Join
PHR1042	SQL Table	S10B80.PAYROLL	Join
PHRCMNT	SQL Table	S10B80.PAYROLL	Refer (no action)
PHREARN	SQL Table	S10B80.PAYROLL	Join
PHRJACR	SQL Table	S10B80.PAYROLL	Join
PTRPICT	SQL Table	S10B80.PAYROLL	Join
PHVUPDT	SQL View	S10B80.BANINST1	Use (select)
PAY_SUM_TYPE	Oracle Package Type	S10B80.BANINST1.BWPKHSTB	Rely On
PAYNO	Oracle Package Variable	S10B80.BANINST1.BWPKHSTB	Rely On
PICT	Oracle Package Variable	S10B80.BANINST1.BWPKHSTB	Rely On
SEQ_NO	Oracle Package Variable	S10B80.BANINST1.BWPKHSTB	Rely On
YR	Oracle Package Variable	S10B80.BANINST1.BWPKHSTB	Rely On
GET_ADJS_DOCC	Oracle Package Cursor	S10B80.BANINST1.BWPKHSTB	Use (select)
GET_GROSS_NETC	Oracle Package Cursor	S10B80.BANINST1.BWPKHSTB	Use (select)
PRINT_THIS_EVENT	Oracle Package Cursor	S10B80.BANINST1.BWPKHSTB	Use (select)
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2006	Use (select)
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2007	Use (select)
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2	Use (select)
P_GET_ORIGINAL_DATE	Oracle Package Procedure	S10B80.BANINST1.BWPKHSTB	Use (select)
UT_NB_JOB_EARNINGSDELETEAPI	Oracle Package Procedure	S10B80.BANINST1.UT_NB_JOB_EARNINGS	Use (Insert)
UT_NB_JOB_EARNINGSUPDATEAPI	Oracle Package Procedure	S10B80.BANINST1.UT_NB_JOB_EARNINGS	Use (Insert)
F_CHECK_IF_ADJUSTED	Oracle Package Function	S10B80.BANINST1.BWPKHSTB	Use (select)
GET_PAY_SUMC	Oracle Package Cursor	S10B80.BANINST1.BWPKHSTB	Use (select)
PHRHISTC	Oracle Package Cursor	S10B80.BANINST1.PHKLIBS	Use (select)Rely On
P_ACCRUE_SENIORITY_HOURS	Oracle Package Procedure	S10B80.BANINST1.PEKSNBL	Use (select)
P_CHOOSEPAYSTUBYEAR	Oracle Package Procedure	S10B80.BANINST1.BWPKHSTB	Use (select)
P_DISPPAYSTUBDTL	Oracle Package Procedure	S10B80.BANINST1.BWPKHSTB	Rely On
P_MAIN_ROLL	Oracle Package Procedure	S10B80.BANINST1.PEKLEAV	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.PB_PAYHIST_COMMENT_RULES	Use (select)
P_VIEWDIRECTDEPOSIT	Oracle Package Procedure	S10B80.BANINST1.BWPKHPAY	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_PAYHIST_COMMENT	Use (Insert)
F_GET_JOB_LEAVE_ACCRUAL	Oracle Package Function	S10B80.BANINST1.PEKLEAV	Use (select)
F_GET_LAST_PAID_DATE	Oracle Package Function	S10B80.BANINST1.NOKPLIB	Use (select)
F_GET_POSN_LAST_PAID_DATE	Oracle Package Function	S10B80.BANINST1.NOKP3LB	Use (select)
F_LASTPAIDDATE	Oracle Package Function	S10B80.BANINST1.POKLIBS	Use (select)
F_VALID_EMPR_CODE	Oracle Package Function	S10B80.BANINST1.PX_RECORD_OF_EMPLOYMENT	Use (select)
F_VALID_EMPR_CODE	Oracle Package Function	S10B80.BANINST1.PX_MASS_ROE	Use (select)
PHRHIST	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PHRHIST_KEY2_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PHRHIST_KEY3_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PHRHIST_KEY4_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PHRHIST_KEY5_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PK_PHRHIST	SQL Index	S10B80.PAYROLL	Rely On
PEBEMPL	SQL Table	S10B80.PAYROLL	Refer (no action)
PHRDOCM	SQL Table	S10B80.PAYROLL	Join
PHRJOBS	SQL Table	S10B80.PAYROLL	Join
PTRCALN	SQL Table	S10B80.PAYROLL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PHRHIST

Object Dates

Creation Date	Analysis Date
04/02/2008 13:33:58:000	04/02/2008 13:49:08:000

Source Code Comments

Pay History Repeating Table

Columns Comments for PHRHIST_YEAR (# 1)

Source Code Comments

Year; The year of the payroll.

Columns Comments for PHRHIST_PICT_CODE (# 2)

Source Code Comments

PAYROLL IDENTIFICATION CODE: The pay id of the event.

Columns Comments for PHRHIST_PAYNO (# 3)

Source Code Comments

PAYROLL NUMBER: The pay number of the year for this payroll.

Columns Comments for PHRHIST_PIDM (# 4)

Source Code Comments

PIDM: Internal ID number.

Columns Comments for PHRHIST_SEQ_NO (# 5)

Source Code Comments

SEQUENCE NUMBER: The sequence number of the event.

Columns Comments for PHRHIST_DISP (# 6)

Source Code Comments

DISPOSITION: Indicates the status of this pay event through the pay cycle.

Columns Comments for PHRHIST_EVENT_DATE (# 7)

Source Code Comments

PAY EVENT DATE: The date on the checks or notices of direct deposit. Or the date of the event when no document is associated.

Columns Comments for PHRHIST_GROSS (# 8)

Source Code Comments

GROSS AMOUNT: The total gross for the event.

Columns Comments for PHRHIST_NET (# 9)

Source Code Comments

NET AMOUNT: The total net amount of the event.

Columns Comments for PHRHIST_TYPE_IND (# 10)

Source Code Comments

TYPE INDICATOR: Indicates the type of pay event.

Columns Comments for PHRHIST_CALC_IND (# 11)

Source Code Comments

CALCULATION INDICATOR: Indicates how this event was calculated (manually or via the calc program).

Columns Comments for PHRHIST_PRINT_IND (# 12)

Source Code Comments

PRINT INDICATOR: Indicates if the event was manually printed outside of the system.

Columns Comments for PHRHIST_ADJS_SEQ_NO (# 13)

Source Code Comments

ADJUSTS SEQUENCE NUMBER: The sequence number of the pay event that this one adjusts.

Columns Comments for PHRHIST_ADJS_DATE (# 14)

Source Code Comments

ADJUSTS DATE: The date of the pay event that this event adjusts.

Columns Comments for PHRHIST_ADJ_BY_SEQ_NO (# 15)

Source Code Comments

ADJUSTED BY SEQUENCE NUMBER: The sequence number of the pay event that adjuststhis pay event.

Columns Comments for PHRHIST_ADJ_BY_DATE (# 16)

Source Code Comments

ADJUSTED BY DATE: The date of the pay event that adjusts this pay event.

Columns Comments for PHRHIST_ASSOC_SEQ_NO (# 17)

Source Code Comments

ASSOCIATED SEQUENCE NUMBER: The sequence of the event that corresponds to thisevent for two step adjustments.

Columns Comments for PHRHIST_ACTIVITY_DATE (# 18)

Source Code Comments

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

Columns Comments for PHRHIST_UI_WEEKS (# 19)

Source Code Comments

UI WEEKS: Unemployment Insurance insurable for this pay period.

Columns Comments for PHRHIST_UI_EXCEPTION_IND (# 20)

Source Code Comments

UNEMPLOYMENT EXCEPTION INDICATOR: (H)ourly, (M)aximum, numbers, null can be accepted. This field is associated with insurable earnings by pay period.

Columns Comments for PHRHIST_UPDT_DATE (# 21)

Source Code Comments

UPDATE DATE: The date that the phpupdt payroll process was run for supplemental pay or adjustments. Used in Tax Reporting.

Columns Comments for PHRHIST_POSTING_OVERRIDE_DATE (# 22)

Source Code Comments

POSTING OVERRIDE DATE: Finance Posting Override Date.

Columns Comments for PHRHIST_USER_ID (# 23)

Source Code Comments

USER ID: User Identification Number.

Columns Comments for PHRHIST_COMMENT (# 24)

Source Code Comments

COMMENT: This field stores user comments

Table PTRBCDN

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
PTRBCDN_BCAT_CODE	VARCHAR2(2)	No	*
PTRBCDN_BDCA_CODE	VARCHAR2(3)	No	*
PTRBCDN_REQ_IND	VARCHAR2(1)	No
PTRBCDN_SETUP_IND	VARCHAR2(1)	No
PTRBCDN_ACTIVITY_DATE	DATE	No
PTRBCDN_SEQ_NO	NUMBER(2,0)	Yes
PTRBCDN_AMOUNT1	NUMBER(11,2)	Yes
PTRBCDN_AMOUNT2	NUMBER(11,2)	Yes
PTRBCDN_AMOUNT3	NUMBER(11,2)	Yes
PTRBCDN_AMOUNT4	NUMBER(11,2)	Yes
PTRBCDN_OPT_CODE1	VARCHAR2(2)	Yes
PTRBCDN_OPT_CODE2	VARCHAR2(2)	Yes
PTRBCDN_OPT_CODE3	VARCHAR2(2)	Yes
PTRBCDN_OPT_CODE4	VARCHAR2(2)	Yes
PTRBCDN_OPT_CODE5	VARCHAR2(2)	Yes
PTRBCDN_BEGIN_DATE_IND	VARCHAR2(1)	No
PTRBCDN_DEDN_STATUS	VARCHAR2(1)	Yes
PTRBCDN_BEGIN_DATE	DATE	No
PTRBCDN_END_DATE	DATE	Yes
PTRBCDN_COVERAGE_END_DATE_IND	VARCHAR2(1)	No
PTRBCDN_DISP_ON_STMT_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PTRBCDN_BCAT_CODE	PTRBCAT_CODE	PTRBCAT
PTRBCDN_BCAT_CODE	PEBEMPL_BCAT_CODE	PEBEMPL
PTRBCDN_BDCA_CODE	PTRBDCA_CODE	PTRBDCA
PTRBCDN_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN

Index

Index Name	Index Type	Column Name
PTRBCDN_KEY_INDEX	Unique	PTRBCDN_BCAT_CODE
PTRBCDN_KEY_INDEX	Unique	PTRBCDN_BDCA_CODE
PTRBCDN_KEY_INDEX	Unique	PTRBCDN_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PTRBCDN_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
GETSECGRPC	Oracle Package Cursor	S10B80.BANINST1.BWPKEBST	Use (select)
P_BENEFITS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (select)
P_CHK_WAIVED_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Rely On
F_INVALID_DEDN_EXISTS	Oracle Package Function	S10B80.BANINST1.PB_EMPLOYEE_RULES	Use (select)
PTRBCDNBDCAC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PTRBCDNC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
P_EDIT_BDCA	Oracle Package Procedure	S10B80.BANINST1.NOKPLIB	Use (select)
P_EDIT_BDCA_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_BDCA_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_EDIT_NEW_EFFECTIVE_DATE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_EDIT_PEBEMPL_BCAT_CODE	Oracle Package Procedure	S10B80.BANINST1.NOKPLIB	Use (select)
P_VERIFYCOREBDCAEMP	Oracle Package Procedure	S10B80.BANINST1.PDKLIBS	Rely On
F_CHECK_REQD_DEDNS	Oracle Package Function	S10B80.BANINST1.POKLIBS	Use (select)
F_COREDEDNIND	Oracle Package Function	S10B80.BANINST1.PDKLIBS	Rely On
F_DEDNISREQUIRED	Oracle Package Function	S10B80.BANINST1.PDKLIBS	Use (select)
F_INVALID_DEDN_EXISTS	Oracle Package Function	S10B80.BANINST1.PEKEMPL	Use (select)
F_VERIFYCOREBDCABCAT	Oracle Package Function	S10B80.BANINST1.PDKLIBS	Rely On
F_VERIFYCOREBDCABCAT	Oracle Package Function	S10B80.BANINST1.PDKLIBS	Use (select)
PTRBCDN	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PTRBCDN_KEY_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PDRDEDN	SQL Table	S10B80.PAYROLL	Join
PEBEMPL	SQL Table	S10B80.PAYROLL	Join
PTRBCAT	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDCA	SQL Table	S10B80.PAYROLL	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRBCDN

Object Dates

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

Source Code Comments

Benefit Category Set-up Rule Table

Columns Comments for PTRBCDN_BCAT_CODE (# 1)

Source Code Comments

BENEFIT CATEGORY CODE: A code that identifies a group of benefits which can then be assigned to an employee.

Columns Comments for PTRBCDN_BDCA_CODE (# 2)

Source Code Comments

BENEFIT/DEDUCTION CODE: A code which identifies a particular benefit/ deduction. Employees assigned to this benefit category will be eligible for this benefit/deduction.

Columns Comments for PTRBCDN_REQ_IND (# 3)

Source Code Comments

REQUIRED INDICATOR: Indicates whether this benefit/deduction is required for all employees in this benefit category or not.

Columns Comments for PTRBCDN_SETUP_IND (# 4)

Source Code Comments

SETUP-INDICATOR: Indicates if this benefit/deduction should be setup on (defaulted to) the Employee Deduction Setup Form (PDABDSU) for quick setup.

Columns Comments for PTRBCDN_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for PTRBCDN_SEQ_NO (# 6)

Source Code Comments

SEQUENCE NUMBER: Check print sequence number associated this benefit/deduction.

Columns Comments for PTRBCDN_AMOUNT1 (# 7)

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 PTRBCDN_AMOUNT2 (# 8)

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 PTRBCDN_AMOUNT3 (# 9)

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 PTRBCDN_AMOUNT4 (# 10)

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 PTRBCDN_OPT_CODE1 (# 11)

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 PTRBCDN_OPT_CODE2 (# 12)

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 PTRBCDN_OPT_CODE3 (# 13)

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 PTRBCDN_OPT_CODE4 (# 14)

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 PTRBCDN_OPT_CODE5 (# 15)

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 PTRBCDN_BEGIN_DATE_IND (# 16)

Source Code Comments

BEGIN DATE INDICATOR; Defines date to use for deduction begin date when benefit/deduction is established via the Employee Benefit/Deduction Setup Form

Columns Comments for PTRBCDN_DEDN_STATUS (# 17)

Source Code Comments

STATUS OF THE DEDUCTION: Values (A)ctive, (W)aived, and (T)erminated.

Columns Comments for PTRBCDN_BEGIN_DATE (# 18)

Source Code Comments

BEGIN DATE: Date from which the deduction is valid for the benefit category.

Columns Comments for PTRBCDN_END_DATE (# 19)

Source Code Comments

END DATE: Date to which the deduction is valid for the benefit category.

Columns Comments for PTRBCDN_COVERAGE_END_DATE_IND (# 20)

Source Code Comments

COVERAGE END DATE INDICATOR; Defines date to use for deduction end date when benefit/deduction is established via the Employee Benefit/Deduction Setup Form

Columns Comments for PTRBCDN_DISP_ON_STMT_IND (# 21)

Source Code Comments

Statement Indicator:This flag indicates if benefit/deduction will be displayed on the online benefit statement.

Table PTRBDCA

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
PTRBDCA_CODE	VARCHAR2(3)	No	*	*
PTRBDCA_SHORT_DESC	VARCHAR2(8)	No
PTRBDCA_LONG_DESC	VARCHAR2(30)	No
PTRBDCA_PRIORITY	NUMBER(2,0)	No
PTRBDCA_CALC_RULE	VARCHAR2(2)	No
PTRBDCA_WEEK1_IND	VARCHAR2(1)	No
PTRBDCA_WEEK2_IND	VARCHAR2(1)	No
PTRBDCA_WEEK3_IND	VARCHAR2(1)	No
PTRBDCA_WEEK4_IND	VARCHAR2(1)	No
PTRBDCA_WEEK5_IND	VARCHAR2(1)	No
PTRBDCA_AMT1_IND	VARCHAR2(1)	No
PTRBDCA_AMT2_IND	VARCHAR2(1)	No
PTRBDCA_AMT3_IND	VARCHAR2(1)	No
PTRBDCA_AMT4_IND	VARCHAR2(1)	No
PTRBDCA_AMT1_TITLE	VARCHAR2(8)	Yes
PTRBDCA_AMT2_TITLE	VARCHAR2(8)	Yes
PTRBDCA_AMT3_TITLE	VARCHAR2(8)	Yes
PTRBDCA_AMT4_TITLE	VARCHAR2(8)	Yes
PTRBDCA_OPTION1_IND	VARCHAR2(1)	No
PTRBDCA_OPTION2_IND	VARCHAR2(1)	No
PTRBDCA_OPTION3_IND	VARCHAR2(1)	No
PTRBDCA_OPTION4_IND	VARCHAR2(1)	No
PTRBDCA_OPTION5_IND	VARCHAR2(1)	No
PTRBDCA_OPTION1_TITLE	VARCHAR2(8)	Yes
PTRBDCA_OPTION2_TITLE	VARCHAR2(8)	Yes
PTRBDCA_OPTION3_TITLE	VARCHAR2(8)	Yes
PTRBDCA_OPTION4_TITLE	VARCHAR2(8)	Yes
PTRBDCA_OPTION5_TITLE	VARCHAR2(8)	Yes
PTRBDCA_GROSS_REPORT_IND	VARCHAR2(1)	Yes
PTRBDCA_BENEFIT_IND	VARCHAR2(1)	No
PTRBDCA_TXCD_CODE	VARCHAR2(8)	Yes
PTRBDCA_TAX_TYPE_IND	VARCHAR2(1)	Yes
PTRBDCA_OVERLOAD_IND	VARCHAR2(1)	No
PTRBDCA_ARREAR_IND	VARCHAR2(1)	No
PTRBDCA_ACTIVITY_DATE	DATE	No
PTRBDCA_BDTY_CODE	VARCHAR2(2)	Yes		*
PTRBDCA_AMT1_DESC	VARCHAR2(30)	Yes
PTRBDCA_AMT2_DESC	VARCHAR2(30)	Yes
PTRBDCA_AMT3_DESC	VARCHAR2(30)	Yes
PTRBDCA_AMT4_DESC	VARCHAR2(30)	Yes
PTRBDCA_1099_CODE	VARCHAR2(2)	Yes		*
PTRBDCA_FLAT_AMT_IND	VARCHAR2(1)	Yes
PTRBDCA_YTD_START_MONTH	NUMBER(2,0)	Yes
PTRBDCA_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_WEB_INFO_URL	VARCHAR2(100)	Yes
PTRBDCA_OPTION1_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_OPTION2_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_OPTION3_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_OPTION4_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_OPTION5_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_AMT1_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_AMT2_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_AMT3_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_AMT4_WEB_DESC	VARCHAR2(100)	Yes
PTRBDCA_BDCL_CODE	VARCHAR2(8)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
PTRBDCA_1099_CODE	PTV1099_CODE	PTV1099
PTRBDCA_BDCL_CODE	PTRBDCL_CODE	PTRBDCL
PTRBDCA_BDTY_CODE	PTVBDTY_CODE	PTVBDTY
PTRBDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN
PTRBDCA_CODE	PDRBCOV_BDCA_CODE	PDRBCOV

Index

Index Name	Index Type	Column Name
PK_PTRBDCA	Unique	PTRBDCA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRBDED	SQL Table	S10B80.PAYROLL	Refer (no action)
PERDTOT	SQL Table	S10B80.PAYROLL	Join
PHRDEDN	SQL Table	S10B80.PAYROLL	Join
PPRCOLR	SQL Table	S10B80.PAYROLL	Join
PTRBCDN	SQL Table	S10B80.PAYROLL	Join
PTRBDAS	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDCG	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDFQ	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDGM	SQL Table	S10B80.PAYROLL	Join
PTRBDID	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDLD	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDLG	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDPD	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDPL	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDXD	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDXE	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRCBEN	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRCOVR	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRDCHN	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRFBEN	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRFLEX	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRLIFE	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRLIFI	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRPREM	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRSDED	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRSTDE	SQL Table	S10B80.PAYROLL	Refer (no action)
PXRFSTA	SQL Table	S10B80.PAYROLL	Join
PXRRDED	SQL Table	S10B80.PAYROLL	Join
PXRTXCD	SQL Table	S10B80.PAYROLL	Join
PDVBCOV	SQL View	S10B80.BANINST1	Use (select)
PDVDAMT	SQL View	S10B80.BANINST1	Use (select)
PDVDED1	SQL View	S10B80.BANINST1	Use (select)
PDVDEDD	SQL View	S10B80.BANINST1	Use (select)
PDVDEDN	SQL View	S10B80.BANINST1	Use (select)
PEVATYP	SQL View	S10B80.BANINST1	Use (select)
PEVDEDT	SQL View	S10B80.BANINST1	Use (select)
F_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
PAY_DEDN_TYPE	Oracle Package Type	S10B80.BANINST1.BWPKHSTB	Rely On
PERDTOT_SUM_TYPE	Oracle Package Type	S10B80.BANINST1.BWPKHDED	Rely On
PTRBDCA_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
PTRBDCA_REC	Oracle Package Variable	S10B80.BANINST1.PXKLIBS	Rely On
GETSECGRPC	Oracle Package Cursor	S10B80.BANINST1.BWPKEBST	Use (select)
PTRBDCAC	Oracle Package Cursor	S10B80.BANINST1.BWPKDBCV	Use (select)
PTRBDCA_C	Oracle Package Cursor	S10B80.BANINST1.PP_W2	Rely On
PTRBDCA_C	Oracle Package Cursor	S10B80.BANINST1.PP_W2	Use (select)
BDCA_EXISTS	Oracle Package Procedure	S10B80.BANINST1.POKPVAL	Use (select)
P_BENEFITS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (select)
P_BUILD_W2	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2006	Rely On
P_BUILD_W2	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2006	Use (select)
P_BUILD_W2	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2007	Rely On
P_BUILD_W2	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2007	Use (select)
P_BUILD_W2_REC	Oracle Package Procedure	S10B80.BANINST1.PP_W2	Rely On
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2006	Use (select)
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2_2007	Use (select)
P_COMPUTE_BOX_AMOUNTS	Oracle Package Procedure	S10B80.BANINST1.PP_W2	Use (select)
P_CROSS_FIELD_EDITS	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_INPUT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_INPUT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)Rely On
P_OPENENROLLMENTGRPSHOW	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Rely On
P_PRINTCOVEREDPERSONS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Rely On
P_PRINTCOVEREDPERSONS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (select)
UT_PB_W2_FEDERALDELETEAPI	Oracle Package Procedure	S10B80.BANINST1.UT_PB_W2_FEDERAL	Use (select)
PTRBDCA_REC	Oracle Package Variable	S10B80.BANINST1.BWPKDBCV	Rely On
GET_PAY_DEDNC	Oracle Package Cursor	S10B80.BANINST1.BWPKHSTB	Use (select)
PERDTOTSUMC	Oracle Package Cursor	S10B80.BANINST1.BWPKHDED	Use (select)
PTRBDCABYBDTYC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PTRBDCABYDESCC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PTRBDCAVIEWC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
P_APPLY_DEDUCTION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_CHECK_PRECLUSION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT	Use (select)
P_EDIT_AMOUNT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_BDCA	Oracle Package Procedure	S10B80.BANINST1.NOKPLIB	Use (select)
P_EDIT_BDCA_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_BDCA_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_EDIT_NEW_EFFECTIVE_DATE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_NTRFRNG_BDCA_CODE	Oracle Package Procedure	S10B80.BANINST1.NOKPLIB	Use (select)
P_EDIT_OPT_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_OPT_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_OPENENROLLMENTFUNCADDDHIS	Oracle Package Procedure	S10B80.BANINST1.BWPKDOFN	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.PB_W2_LOCAL_RULES	Use (select)
P_VIEWDEDNSUMMARYBODY	Oracle Package Procedure	S10B80.BANINST1.BWPKHDED	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_W2_LOCAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_DEDN_LMT_GRP	Use (Insert)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_PB_DEDN_LMT_GRP	Use (select)
F_CHECK_DECIMAL_DIGITS	Oracle Package Function	S10B80.BANINST1.PDKDEDN	Rely On
F_CHECK_DECIMAL_DIGITS	Oracle Package Function	S10B80.BANINST1.PDKDEDN	Use (select)
F_DISPLAYEMPRAMOUNT	Oracle Package Function	S10B80.BANINST1.BWPKDCMN	Rely On
PTRBDCA	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_PTRBDCA	SQL Index	S10B80.PAYROLL	Rely On
PDRBCOV	SQL Table	S10B80.PAYROLL	Join
PDRDEDN	SQL Table	S10B80.PAYROLL	Join
PTRBDCL	SQL Table	S10B80.PAYROLL	Refer (no action)
PTV1099	SQL Table	S10B80.PAYROLL	Refer (no action)
PTVBDTY	SQL Table	S10B80.PAYROLL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRBDCA

Object Dates

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

Source Code Comments

Benefit/Deduction Calculation Rule Table

Columns Comments for PTRBDCA_CODE (# 1)

Source Code Comments

BENEFIT/DEDUCTION CODE: A unique three-character code used to identify the benefit/deduction defined.

Columns Comments for PTRBDCA_SHORT_DESC (# 2)

Source Code Comments

SHORT DESCRIPTION: A brief description of the benefit/deduction.

Columns Comments for PTRBDCA_LONG_DESC (# 3)

Source Code Comments

LONG DESCRIPTION: Full description of the benefit/deduction.

Columns Comments for PTRBDCA_PRIORITY (# 4)

Source Code Comments

PRIORITY CODE: The priority code indicates the order in which the deduction should be processed. For example, it is important that a deduction which is exempt from taxes, such as a 401K contribution, be calculated before the tax.

Columns Comments for PTRBDCA_CALC_RULE (# 5)

Source Code Comments

CALCULATION RULE: Defines how a benefit/deduction is processed by the system. The Calc Rule selected also determines how the Deduction Form (PDADEDN) and the Deduction Set-up Form (PDABDSU) function.

Columns Comments for PTRBDCA_WEEK1_IND (# 6)

Source Code Comments

PAY PERIOD 1 INDICATOR: Indicates if the benefit/deduction should be processedin the first pay period of the month.

Columns Comments for PTRBDCA_WEEK2_IND (# 7)

Source Code Comments

PAY PERIOD 2 INDICATOR: Indicates if the benefit/deduction should be processedin the second pay period of the month.

Columns Comments for PTRBDCA_WEEK3_IND (# 8)

Source Code Comments

PAY PERIOD 3 INDICATOR: Indicates if the benefit/deduction should be processedin the third pay period of the month.

Columns Comments for PTRBDCA_WEEK4_IND (# 9)

Source Code Comments

PAY PERIOD 4 INDICATOR: Indicates if the benefit/deduction should be processedduring the fourth pay period of the month.

Columns Comments for PTRBDCA_WEEK5_IND (# 10)

Source Code Comments

PAY PERIOD 5 INDICATOR: Indicates if the benefit/deduction should be processedduring the fifth pay period of the month.

Columns Comments for PTRBDCA_AMT1_IND (# 11)

Source Code Comments

AMOUNT 1 INDICATOR: Indicates if the entry of Amount 1 is required, optional, or not allowed, on the Employee Deduction Form (PDADEDN), and/or the Employee Deduction Setup Form (PDABDSU).

Columns Comments for PTRBDCA_AMT2_IND (# 12)

Source Code Comments

AMOUNT 2 INDICATOR: Indicates if the entry of amount 2 is required, optional, or not allowed on the Employee Deduction Form (PDADEDN) and/or the Employee Deduction Setup Form.

Columns Comments for PTRBDCA_AMT3_IND (# 13)

Source Code Comments

AMOUNT 3 INDICATOR: Indicates if entry in Amount 3 is required, optional, or not allowed on the Employee Deduction Form (PDADEDN) and/or the Employee Deduction Setup Form (PDABDSU)

Columns Comments for PTRBDCA_AMT4_IND (# 14)

Source Code Comments

AMOUNT 4 INDICATOR: Indicates if entry in Amount 4 on the Employee Deduction Form (PDADEDN) and/or the Employee Deduction Setup Form (PDABDSU) will be required, optional, or not allowed.

Columns Comments for PTRBDCA_AMT1_TITLE (# 15)

Source Code Comments

AMOUNT 1 TITLE: The title associated with Amount 1. The Title will default tothe Employee Deduction Form (PDADEDN) and the Employee Deduction Setup Form (PDABDSU).

Columns Comments for PTRBDCA_AMT2_TITLE (# 16)

Source Code Comments

AMOUNT 2 TITLE: The Title associated with Amount 2. Will default to the Employee Deduction Form (PDADEDN) and the Employee Deduction Setup Form (PDABDSU).

Columns Comments for PTRBDCA_AMT3_TITLE (# 17)

Source Code Comments

AMOUNT 3 TITLE: The Title associated with Amount 3. The Title will default to the Employee Deduction Form (PDADEDN) and the Employee Deduction Setup Form (PDABDSU).

Columns Comments for PTRBDCA_AMT4_TITLE (# 18)

Source Code Comments

AMOUNT 4 TITLE: The Title associated with Amount 4. The Title will default tothe Employee Deduction Form (PDADEDN) and the Employee Deduction Setup Form (PDABDSU).

Columns Comments for PTRBDCA_OPTION1_IND (# 19)

Source Code Comments

OPTION 1 INDICATOR: Indicates if entry in Option 1 on the Employee Deduction Form (PDADEDN) and/or the Employee Deduction Setup Form (PDABDSU) will be required, optional or not allowed.

Columns Comments for PTRBDCA_OPTION2_IND (# 20)

Source Code Comments

OPTION 2 INDICATOR: Indicates if entry in Option 2 on the Employee Deduction Form (PDADEDN) and/or the Employee Deduction Set up Form (PDABDSU) is required, optional, or not allowed.

Columns Comments for PTRBDCA_OPTION3_IND (# 21)

Source Code Comments

OPTION 3 INDICATOR: Indicates if entry in Option 3 on the Employee Deduction Form (PDADEDN) and/or the Employee Deduction Setup Form (PDADEDN) is required,optional, or not allowed.

Columns Comments for PTRBDCA_OPTION4_IND (# 22)

Source Code Comments

OPTION 4 INDICATOR: Indicates if entry in Option 4 on the Employee Deduction Form (PDADEDN) and/or the Employee Deduction Setup Form (PDABDSU) is required,optional, or not allowed.

Columns Comments for PTRBDCA_OPTION5_IND (# 23)

Source Code Comments

OPTION 5 INDICATOR: Indicates if entry in Option 5 on the Employee Deduction Form (PDADEDN) and the Employee Deduction Setup Form (PDABDSU) is required, optional, or not allowed.

Columns Comments for PTRBDCA_OPTION1_TITLE (# 24)

Source Code Comments

OPTION 1 TITLE: The title associated with Option 1. The Title will default to the Employee Deduction Form (PDADEDN) and the Employee Deduction Set up Form (PDABDSU).

Columns Comments for PTRBDCA_OPTION2_TITLE (# 25)

Source Code Comments

OPTION 2 TITLE: The title associated with Option 2. The Title will default to the Employee Deduction Form (PDADEDN) and the Employee Deduction Setup Form (PDABDSU).

Columns Comments for PTRBDCA_OPTION3_TITLE (# 26)

Source Code Comments

OPTION 3 TITLE: The title associated with Option 3. The Title will default to the Employee Deduction Setup Form (PDABDSU) and the Employee Deduction Form (PDADEDN).

Columns Comments for PTRBDCA_OPTION4_TITLE (# 27)

Source Code Comments

OPTION 4 TITLE: The Title associated with Option 4. The title will default to the Employee Deduction Form (PDADEDN) and the Employee Deduction Setup Form(PDABDSU).

Columns Comments for PTRBDCA_OPTION5_TITLE (# 28)

Source Code Comments

OPTION 5 TITLE: The Title associated with Option 5 on the Employee Deduction Form (PDADEDN) and the Employee Deduction Setup Form (PDABDSU).

Columns Comments for PTRBDCA_GROSS_REPORT_IND (# 29)

Source Code Comments

GROSS REPORTING INDICATOR: Indicates if applicable gross is to be maintained for the deduction/benefit.

Columns Comments for PTRBDCA_BENEFIT_IND (# 30)

Source Code Comments

BENEFIT INDICATOR: Indicates if the employer portion of the benefit is processed when an employee is on leave with benefits.

Columns Comments for PTRBDCA_TXCD_CODE (# 31)

Source Code Comments

TAX INDICATOR: Indicates the taxing authority associated with this benefit/ deduction code.

Columns Comments for PTRBDCA_TAX_TYPE_IND (# 32)

Source Code Comments

DEDUCTION TYPE: A sytem defined indicator which identifies the type of benefit/deduction being defined.

Columns Comments for PTRBDCA_OVERLOAD_IND (# 33)

Source Code Comments

OVERLOAD INDICATOR: Indicates if overload pay (pay froma non-primary job) should be included when processing this benefit/deuction.

Columns Comments for PTRBDCA_ARREAR_IND (# 34)

Source Code Comments

ARREAR INDICATOR: Indicates how a deduction is processed if the pay amount drops below the amount of the deduction.

Columns Comments for PTRBDCA_ACTIVITY_DATE (# 35)

Source Code Comments

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

Columns Comments for PTRBDCA_BDTY_CODE (# 36)

Source Code Comments

BENEFIT/DEDUCTION TYPE CODE: Type of the benefit/deduction can be validated from the PTVBDTY Form.

Columns Comments for PTRBDCA_AMT1_DESC (# 37)

Source Code Comments

AMOUNT 1 DESCRIPTION: The long description associated with Amount 1.

Columns Comments for PTRBDCA_AMT2_DESC (# 38)

Source Code Comments

AMOUNT 2 DESCRIPTION: The long description associated with Amount 2.

Columns Comments for PTRBDCA_AMT3_DESC (# 39)

Source Code Comments

AMOUNT 3 DESCRIPTION: The long description associated with Amount 3.

Columns Comments for PTRBDCA_AMT4_DESC (# 40)

Source Code Comments

AMOUNT 4 DESCRIPTION: The long description associated with Amount 4.

Columns Comments for PTRBDCA_1099_CODE (# 41)

Source Code Comments

1099 CODE: 1099-R Distribution Code associated with the deduction code.

Columns Comments for PTRBDCA_FLAT_AMT_IND (# 42)

Source Code Comments

FLAT AMOUNT INDICATOR; Obsolete

Columns Comments for PTRBDCA_YTD_START_MONTH (# 43)

Source Code Comments

START MONTH: First month of fiscal year for deduction/benefit purposes.

Columns Comments for PTRBDCA_WEB_DESC (# 44)

Source Code Comments

WEB DESCRIPTION: Long description of deduction code to be displayed on the Web.

Columns Comments for PTRBDCA_WEB_INFO_URL (# 45)

Source Code Comments

WEB INFO URL: URL to be linked to from Web for more information about the deduction code.

Columns Comments for PTRBDCA_OPTION1_WEB_DESC (# 46)

Source Code Comments

OPTION 1 WEB DESCRIPTION:User-defined title for Option 1 on the web.

Columns Comments for PTRBDCA_OPTION2_WEB_DESC (# 47)

Source Code Comments

OPTION 2 WEB DESCRIPTION:User-defined title for Option 2 on the web.

Columns Comments for PTRBDCA_OPTION3_WEB_DESC (# 48)

Source Code Comments

OPTION 3 WEB DESCRIPTION:User-defined title for Option 3 on the web.

Columns Comments for PTRBDCA_OPTION4_WEB_DESC (# 49)

Source Code Comments

OPTION 4 WEB DESCRIPTION:User-defined title for Option 4 on the web.

Columns Comments for PTRBDCA_OPTION5_WEB_DESC (# 50)

Source Code Comments

OPTION 5 WEB DESCRIPTION:User-defined title for Option 5 on the web.

Columns Comments for PTRBDCA_AMT1_WEB_DESC (# 51)

Source Code Comments

AMOUNT 1 WEB DESCRIPTION: User-defined title for Amount 1 on the web.

Columns Comments for PTRBDCA_AMT2_WEB_DESC (# 52)

Source Code Comments

AMOUNT 2 WEB DESCRIPTION: User-defined title for Amount 2 on the web.

Columns Comments for PTRBDCA_AMT3_WEB_DESC (# 53)

Source Code Comments

AMOUNT 3 WEB DESCRIPTION: User-defined title for Amount 3 on the web.

Columns Comments for PTRBDCA_AMT4_WEB_DESC (# 54)

Source Code Comments

AMOUNT 4 WEB DESCRIPTION: User-defined title for Amount 4 on the web.

Columns Comments for PTRBDCA_BDCL_CODE (# 55)

Source Code Comments

COMBINED LIMIT CODE: A code that defines combined annual limits for a benefit/deduction.

Table PTRBDCL

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
PTRBDCL_CODE	VARCHAR2(8)	No	*
PTRBDCL_DESC	VARCHAR2(30)	No
PTRBDCL_USER_ID	VARCHAR2(30)	No
PTRBDCL_ACTIVITY_DATE	DATE	No
PTRBDCL_DATA_ORIGIN	VARCHAR2(30)	Yes
PTRBDCL_EMPL_LIMIT	NUMBER(17,2)	Yes
PTRBDCL_EMPR_LIMIT	NUMBER(17,2)	Yes
PTRBDCL_EMPL_EMPR_LIMIT	NUMBER(17,2)	Yes
PTRBDCL_MAX_GROSS	NUMBER(17,2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PTRBDCL	Unique	PTRBDCL_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRDEDN	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDCA	SQL Table	S10B80.PAYROLL	Refer (no action)
PTRBDMC	SQL Table	S10B80.PAYROLL	Refer (no action)
DEDN_COMB_LMT_REC	Oracle Package Type	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
P_EDIT_INPUT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_INPUT	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
F_BUILD_PTRBDCL_REC	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_PTRBDCL	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_PTRBDCL	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_PTRBDCL	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.PB_DEDN_COMB_LMT_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.PB_DEDN_COMB_LMT	Use (select)
PTRBDCL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRBDCL

Object Dates

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

Source Code Comments

Benefit/Deduction Combined Limits Rule Table.

Columns Comments for PTRBDCL_CODE (# 1)

Source Code Comments

COMBINED LIMIT CODE: A code that defines combined annual limits for a benefit/deduction.

Columns Comments for PTRBDCL_DESC (# 2)

Source Code Comments

DESCRIPTION: The combined limit code description.

Columns Comments for PTRBDCL_USER_ID (# 3)

Source Code Comments

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

Columns Comments for PTRBDCL_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for PTRBDCL_DATA_ORIGIN (# 5)

Source Code Comments

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

Columns Comments for PTRBDCL_EMPL_LIMIT (# 6)

Source Code Comments

EMPLOYEE LIMIT: Annual employee amount limit for combined (associated) deductions as defined by the combined limit code.

Columns Comments for PTRBDCL_EMPR_LIMIT (# 7)

Source Code Comments

EMPLOYER LIMIT: Annual employer amount limit for combined (associated) deductions as defined by the combined limit code.

Columns Comments for PTRBDCL_EMPL_EMPR_LIMIT (# 8)

Source Code Comments

COMBINED EMPLOYEE/EMPLOYER LIMIT: Annual employee plus employer amount limit for combined (associated) deductions as defined by the combined limit code.

Columns Comments for PTRBDCL_MAX_GROSS (# 9)

Source Code Comments

MAXIMUM APPLICABLE GROSS: The maximum applicable gross to be considered for employer contributions.

Table PTRBDPD

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
PTRBDPD_CODE	VARCHAR2(3)	No	*
PTRBDPD_BDCA_CODE	VARCHAR2(3)	No	*	*
PTRBDPD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PTRBDPD_BDCA_CODE	PTRBDCA_CODE	PTRBDCA

Index

Index Name	Index Type	Column Name
PK_PTRBDPD	Unique	PTRBDPD_CODE
PK_PTRBDPD	Unique	PTRBDPD_BDCA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDRBDED	SQL Table	S10B80.PAYROLL	Join
PDRDEDN	SQL Table	S10B80.PAYROLL	Join
DHISPRECLUDESC	Oracle Package Cursor	S10B80.BANINST1.BWPKDOEN	Use (select)
DHISPRECLUDESC	Oracle Package Cursor	S10B80.BANINST1.BWPKDOFN	Use (select)
P_OPENENROLLMENTGRPSHOW	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Rely On
P_OPENENROLLMENTGRPSHOW	Oracle Package Procedure	S10B80.BANINST1.BWPKDOEN	Use (select)
DEDNPRECLUDESC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
P_CHECK_PRECLUSION	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
PTRBDPD	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_PTRBDPD	SQL Index	S10B80.PAYROLL	Rely On
PTRBDCA	SQL Table	S10B80.PAYROLL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRBDPD

Object Dates

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

Source Code Comments

Precluded Deduction Rule Table

Columns Comments for PTRBDPD_CODE (# 1)

Source Code Comments

BENEFIT/DEDUCTION CODE: The benefit/deduction being defined.

Columns Comments for PTRBDPD_BDCA_CODE (# 2)

Source Code Comments

PRECLUDED BENEFIT/DEDUCTION CODE: The Benefit/Deduction which is precluded from the benefit/deduction you are defining.

Columns Comments for PTRBDPD_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table PTRBDPL

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
PTRBDPL_BDCA_CODE	VARCHAR2(3)	No	*
PTRBDPL_CODE	VARCHAR2(2)	Yes
PTRBDPL_DESC	VARCHAR2(30)	Yes
PTRBDPL_AMT1	NUMBER(13,4)	Yes
PTRBDPL_AMT2	NUMBER(13,4)	Yes
PTRBDPL_AMT3	NUMBER(11,2)	Yes
PTRBDPL_AMT4	NUMBER(11,2)	Yes
PTRBDPL_ACTIVITY_DATE	DATE	No
PTRBDPL_EFFECTIVE_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PTRBDPL_BDCA_CODE	PTRBDCA_CODE	PTRBDCA
PTRBDPL_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN
PTRBDPL_BDCA_CODE	PDRBDED_BDCA_CODE	PDRBDED

Index

Index Name	Index Type	Column Name
PTRBDPL_KEY_INDEX	Unique	PTRBDPL_BDCA_CODE
PTRBDPL_KEY_INDEX	Unique	PTRBDPL_CODE
PTRBDPL_KEY_INDEX	Unique	PTRBDPL_EFFECTIVE_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PDVDAMT	SQL View	S10B80.BANINST1	Use (select)
PDVDEDD	SQL View	S10B80.BANINST1	Use (select)
PDVDEDN	SQL View	S10B80.BANINST1	Use (select)
F_PTRBDPL_ROWID	SQL Function	S10B80.BANINST1	Use (select)
PTRBDPL_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
P_BENEFITS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Rely On
P_BENEFITS	Oracle Package Procedure	S10B80.BANINST1.BWPKEBST	Use (select)Rely On
F_GETPLANDESC	Oracle Package Function	S10B80.BANINST1.BWPKEBST	Rely On
F_GETPLANDESC	Oracle Package Function	S10B80.BANINST1.BWPKEBST	Use (select)
PTRBDPLBYDESCC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PTRBDPLBYRANGEC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
PTRBDPLVIEWC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
P_EDIT_BDPL	Oracle Package Procedure	S10B80.BANINST1.NOKPLIB	Use (select)
P_EDIT_OPT_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
F_CHECK_DECIMAL_DIGITS	Oracle Package Function	S10B80.BANINST1.PDKDEDN	Rely On
PTRBDPL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PTRBDPL_KEY_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PDRBDED	SQL Table	S10B80.PAYROLL	Join
PDRDEDN	SQL Table	S10B80.PAYROLL	Join
PTRBDCA	SQL Table	S10B80.PAYROLL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRBDPL

Object Dates

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

Source Code Comments

Benefit/Deduction Valid Plan Rule Table

Columns Comments for PTRBDPL_BDCA_CODE (# 1)

Source Code Comments

BENEFIT/DEDUCTION CODE: The benefit/deduction being defined.

Columns Comments for PTRBDPL_CODE (# 2)

Source Code Comments

PLAN CODE: A code which identifies a Plan within this Benefit/Deduction.

Columns Comments for PTRBDPL_DESC (# 3)

Source Code Comments

PLAN CODE DESCRIPTION: Description/title for the Plan Code.

Columns Comments for PTRBDPL_AMT1 (# 4)

Source Code Comments

PLAN AMOUNT 1: The Deduction amount for Amount 1 as defined by the Calculation Rule selected.

Columns Comments for PTRBDPL_AMT2 (# 5)

Source Code Comments

PLAN AMOUNT 2: The deduction amount for amount 2 as defined by the Calculation Rule selected.

Columns Comments for PTRBDPL_AMT3 (# 6)

Source Code Comments

PLAN AMOUNT 3: The deduction amount for Amount 3 as defined by the Calculation Rule selected.

Columns Comments for PTRBDPL_AMT4 (# 7)

Source Code Comments

PLAN AMOUNT 4: The deduction amount for Amount 4 as defined by the Calculation Rule selected.

Columns Comments for PTRBDPL_ACTIVITY_DATE (# 8)

Source Code Comments

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

Columns Comments for PTRBDPL_EFFECTIVE_DATE (# 9)

Source Code Comments

EFFECTIVE DATE: Date from which the plan is valid.

Table PTRCITZ

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
PTRCITZ_CITZ_CODE	VARCHAR2(2)	No
PTRCITZ_WS_IRC_STATUS	VARCHAR2(1)	No	*
PTRCITZ_WS_VISA_TYPE	VARCHAR2(4)	No	*
PTRCITZ_USER_ID	VARCHAR2(30)	No
PTRCITZ_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PTRCITZ	Unique	PTRCITZ_WS_IRC_STATUS
PK_PTRCITZ	Unique	PTRCITZ_WS_VISA_TYPE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRCITZ

Object Dates

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

Source Code Comments

Table Description:Foreign Persons Citizenship Rule Table.

Columns Comments for PTRCITZ_CITZ_CODE (# 1)

Source Code Comments

CITIZENSHIP CODE: This field indicates Foreign Persons Citizenship code.

Columns Comments for PTRCITZ_WS_IRC_STATUS (# 2)

Source Code Comments

CURRENT RESIDENCY STATUS: This field indicates Foreign Persons Current Residency Status.

Columns Comments for PTRCITZ_WS_VISA_TYPE (# 3)

Source Code Comments

VISA TYPE: This field indicates Foreign Persons Visa Type.

Columns Comments for PTRCITZ_USER_ID (# 4)

Source Code Comments

USER ID: This field indicates USER ID who inserted or modified last record.

Columns Comments for PTRCITZ_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date on which the record was created or last updated.

Table PTRFBEN

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
PTRFBEN_BDCA_CODE	VARCHAR2(3)	No	*
PTRFBEN_PLAN_CODE	VARCHAR2(2)	Yes
PTRFBEN_FSA_IND	VARCHAR2(1)	No
PTRFBEN_AVAIL_IND	VARCHAR2(1)	No
PTRFBEN_FLEX_AMT	NUMBER(11,2)	Yes
PTRFBEN_EMPL_AMT	NUMBER(11,2)	Yes
PTRFBEN_PREM_AMT	NUMBER(11,2)	Yes
PTRFBEN_DEDN_FREQ	NUMBER(2,0)	No
PTRFBEN_ACTIVITY_DATE	DATE	No
PTRFBEN_FSA_GRACE_PERIOD_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
PTRFBEN_BDCA_CODE	PTRBDCA_CODE	PTRBDCA
PTRFBEN_BDCA_CODE	PDRDEDN_BDCA_CODE	PDRDEDN

Index

Index Name	Index Type	Column Name
PTRFBEN_KEY2_INDEX		PTRFBEN_FSA_IND
PTRFBEN_KEY_INDEX	Unique	PTRFBEN_BDCA_CODE
PTRFBEN_KEY_INDEX	Unique	PTRFBEN_PLAN_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PTRFBEN_REC	Oracle Package Variable	S10B80.BANINST1.PDKLIBS	Rely On
GLOBAL_RECTYPE	Oracle Package Type	S10B80.BANINST1.PDKDEDN	Rely On
FLXSAMOUNTSC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)
PTRFBENFSAC	Oracle Package Cursor	S10B80.BANINST1.PDKLIBS	Use (select)Rely On
P_EDIT_BDCA_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Rely On
P_EDIT_BDCA_CODE	Oracle Package Procedure	S10B80.BANINST1.PDKDEDN	Use (select)
PTRFBEN	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PTRFBEN_KEY2_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PTRFBEN_KEY_INDEX	SQL Index	S10B80.PAYROLL	Rely On
PDRDEDN	SQL Table	S10B80.PAYROLL	Join
PTRBDCA	SQL Table	S10B80.PAYROLL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRFBEN

Object Dates

Creation Date	Analysis Date
04/02/2008 13:38:15:000	04/02/2008 13:49:12:000

Source Code Comments

Flexible Benefits Rule Table

Columns Comments for PTRFBEN_BDCA_CODE (# 1)

Source Code Comments

Flexible Benefit Code: This code must be a valid benefit/deduction code defined on the Benefit/Deduction Rule Form (PTRBDCA).

Columns Comments for PTRFBEN_PLAN_CODE (# 2)

Source Code Comments

Flexible Benefit Plan.

Columns Comments for PTRFBEN_FSA_IND (# 3)

Source Code Comments

Flexible Spending Account Indicator: This indicates whether or not the flexible deduction is a flexible spending account.

Columns Comments for PTRFBEN_AVAIL_IND (# 4)

Source Code Comments

Availability of Funds Indicator: This field is used with Flexible Spending Accounts and determines if the amount is available based on what is currently deposited or what will be deposited over the benefit period.

Columns Comments for PTRFBEN_FLEX_AMT (# 5)

Source Code Comments

Employer Contribution/Flexible Amount of flexible benefit.

Columns Comments for PTRFBEN_EMPL_AMT (# 6)

Source Code Comments

Employee amount of flexible benefit plan.

Columns Comments for PTRFBEN_PREM_AMT (# 7)

Source Code Comments

Premium amount of flexible benefit plan.

Columns Comments for PTRFBEN_DEDN_FREQ (# 8)

Source Code Comments

Deduction Frequency Number: This number determines how many times the FlexibleDeduction will taken per month and is considered when creating employee deduction records from the flexible deduction records.

Columns Comments for PTRFBEN_ACTIVITY_DATE (# 9)

Source Code Comments

Date of Last Modification of the Record.

Columns Comments for PTRFBEN_FSA_GRACE_PERIOD_IND (# 10)

Source Code Comments

FSA GRACE PERIOD INDICATOR: Indicator to signify FSA Grace Period is used/not used for each benefit code. Values are Y(es) or N(o).

Table PTRFILE

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
PTRFILE_PROCESS_ID	VARCHAR2(30)	No	*
PTRFILE_RECORD_ID	VARCHAR2(3)	No	*
PTRFILE_COL_NAME	VARCHAR2(30)	No	*
PTRFILE_POS	NUMBER(4,0)	No
PTRFILE_LENGTH	NUMBER(3,0)	No
PTRFILE_DATA_TYPE	VARCHAR2(10)	No
PTRFILE_REQUIRED_IND	VARCHAR2(1)	No
PTRFILE_USER_ID	VARCHAR2(30)	No
PTRFILE_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PTRFILE	Unique	PTRFILE_PROCESS_ID
PK_PTRFILE	Unique	PTRFILE_RECORD_ID
PK_PTRFILE	Unique	PTRFILE_COL_NAME

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRFILE

Object Dates

Creation Date	Analysis Date
04/02/2008 13:37:54:000	04/02/2008 13:49:12:000

Source Code Comments

Flat File Column Definition Rule Table.

Columns Comments for PTRFILE_PROCESS_ID (# 1)

Source Code Comments

PROCESS ID: The process/program name.

Columns Comments for PTRFILE_RECORD_ID (# 2)

Source Code Comments

RECORD ID: The record id is used to identify a set of columns.

Columns Comments for PTRFILE_COL_NAME (# 3)

Source Code Comments

COLUMN NAME: The database column name maps to the field in the flat file.

Columns Comments for PTRFILE_POS (# 4)

Source Code Comments

POSITION: The start postion of the field in the flat file.

Columns Comments for PTRFILE_LENGTH (# 5)

Source Code Comments

LENGTH: The length of the field in the flat file.

Columns Comments for PTRFILE_DATA_TYPE (# 6)

Source Code Comments

DATA TYPE: The data type of the field in the flat file

Columns Comments for PTRFILE_REQUIRED_IND (# 7)

Source Code Comments

REQUIRED IND: This indicates whether a field is required.

Columns Comments for PTRFILE_USER_ID (# 8)

Source Code Comments

USER ID: The user identification who inserts or last modifies.

Columns Comments for PTRFILE_ACTIVITY_DATE (# 9)

Source Code Comments

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

Table PTRINCD

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
PTRINCD_BEN_DED_CODE	VARCHAR2(3)	No
PTRINCD_USER_ID	VARCHAR2(30)	No
PTRINCD_ACTIVITY_DATE	DATE	No
PTRINCD_WS_INCOME_CODE	NUMBER(2,0)	Yes
PTRINCD_WS_INCOME_SUBTYPE	VARCHAR2(1)	Yes
PTRINCD_WS_EXEMPTION_CODE	VARCHAR2(2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
UK_PTRINCD	Unique	PTRINCD_BEN_DED_CODE
UK_PTRINCD	Unique	PTRINCD_WS_INCOME_CODE
UK_PTRINCD	Unique	PTRINCD_WS_EXEMPTION_CODE
UK_PTRINCD	Unique	PTRINCD_WS_INCOME_SUBTYPE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRINCD

Object Dates

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

Source Code Comments

Table Description:Foreign Persons Income Deduction Rule Table.

Columns Comments for PTRINCD_BEN_DED_CODE (# 1)

Source Code Comments

BENEFIT DEDUCTION CODE: This field indicates Foreign Persons Benefit Deduction code.

Columns Comments for PTRINCD_USER_ID (# 2)

Source Code Comments

USER ID: This field indicates USER ID who inserted or modified last record.

Columns Comments for PTRINCD_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: This field indicates Date the record was inserted or last modified.

Columns Comments for PTRINCD_WS_INCOME_CODE (# 4)

Source Code Comments

INCOME CODE: This field indicates Foreign Persons Income Code.

Columns Comments for PTRINCD_WS_INCOME_SUBTYPE (# 5)

Source Code Comments

INCOME SUBTYPE CODE: This field indicates Foreign Persons Income Subtype Code.

Columns Comments for PTRINCD_WS_EXEMPTION_CODE (# 6)

Source Code Comments

EXEMPTION CODE: This field indicates Foreign Persons Exemption Code.

Table PTRTPCM

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
PTRTPCM_TPCD_CODE	VARCHAR2(5)	No	*
PTRTPCM_BTPC_CODE	VARCHAR2(5)	No	*
PTRTPCM_PROGRAM_NAME	VARCHAR2(7)	No	*
PTRTPCM_COLUMN_NAME	VARCHAR2(30)	No	*
PTRTPCM_USER_ID	VARCHAR2(30)	No
PTRTPCM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PTRTPCM	Unique	PTRTPCM_TPCD_CODE
PK_PTRTPCM	Unique	PTRTPCM_BTPC_CODE
PK_PTRTPCM	Unique	PTRTPCM_PROGRAM_NAME
PK_PTRTPCM	Unique	PTRTPCM_COLUMN_NAME

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRTPCM

Object Dates

Creation Date	Analysis Date
04/02/2008 13:31:52:000	04/02/2008 13:49:05:000

Source Code Comments

Third Party Category Code and Map Column Repeating Table.

Columns Comments for PTRTPCM_TPCD_CODE (# 1)

Source Code Comments

TP CODE: Third Party Vendor Code

Columns Comments for PTRTPCM_BTPC_CODE (# 2)

Source Code Comments

CATEGORY CODE: Third Party Category Code

Columns Comments for PTRTPCM_PROGRAM_NAME (# 3)

Source Code Comments

MAP PROGRAM NAME: The form name uses this Category Code.

Columns Comments for PTRTPCM_COLUMN_NAME (# 4)

Source Code Comments

MAP COLUMN NAME: The column name of a rule table in the form uses this Category Code for LOV.

Columns Comments for PTRTPCM_USER_ID (# 5)

Source Code Comments

USER ID: The user identification who inserts or last modifies.

Columns Comments for PTRTPCM_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table PTRTPCS

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
PTRTPCS_TPCD_CODE	VARCHAR2(5)	No	*
PTRTPCS_BTPC_CODE	VARCHAR2(5)	No	*
PTRTPCS_CODE	VARCHAR2(5)	No	*
PTRTPCS_CODE_DESC	VARCHAR2(30)	No
PTRTPCS_USER_ID	VARCHAR2(30)	No
PTRTPCS_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PTRTPCS	Unique	PTRTPCS_TPCD_CODE
PK_PTRTPCS	Unique	PTRTPCS_BTPC_CODE
PK_PTRTPCS	Unique	PTRTPCS_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRTPCS

Object Dates

Creation Date	Analysis Date
04/02/2008 13:31:52:000	04/02/2008 13:49:05:000

Source Code Comments

Third Party Category Code Repeating Table.

Columns Comments for PTRTPCS_TPCD_CODE (# 1)

Source Code Comments

TP CODE: Third Party Vendor Code

Columns Comments for PTRTPCS_BTPC_CODE (# 2)

Source Code Comments

TP CATEGORY CODE: Third Party Category Code

Columns Comments for PTRTPCS_CODE (# 3)

Source Code Comments

TP VALUE: Third Party Value associates with the Category.

Columns Comments for PTRTPCS_CODE_DESC (# 4)

Source Code Comments

TP VALUE: Third Party Value Description.

Columns Comments for PTRTPCS_USER_ID (# 5)

Source Code Comments

USER ID: The user identification who inserts or last modifies.

Columns Comments for PTRTPCS_ACTIVITY_DATE (# 6)

Source Code Comments

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

Table PTVBTPC

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
PTVBTPC_TPCD_CODE	VARCHAR2(5)	No	*
PTVBTPC_CATEGORY_CODE	VARCHAR2(5)	No	*
PTVBTPC_CAT_CODE_DESC	VARCHAR2(30)	No
PTVBTPC_USER_ID	VARCHAR2(30)	No
PTVBTPC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PTVBTPC	Unique	PTVBTPC_TPCD_CODE
PK_PTVBTPC	Unique	PTVBTPC_CATEGORY_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTVBTPC

Object Dates

Creation Date	Analysis Date
04/02/2008 13:38:19:000	04/02/2008 13:49:12:000

Source Code Comments

Third Party Category Code Base Table.

Columns Comments for PTVBTPC_TPCD_CODE (# 1)

Source Code Comments

TP CODE: Third Party Vendor Code

Columns Comments for PTVBTPC_CATEGORY_CODE (# 2)

Source Code Comments

CATEGORY CODE: Third Party Category Code

Columns Comments for PTVBTPC_CAT_CODE_DESC (# 3)

Source Code Comments

CATEGORY DESC: The Category description.

Columns Comments for PTVBTPC_USER_ID (# 4)

Source Code Comments

USER ID: The user identification who inserts or last modifies.

Columns Comments for PTVBTPC_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table PTVTPCD

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
PTVTPCD_CODE	VARCHAR2(5)	No	*
PTVTPCD_DESC	VARCHAR2(30)	No
PTVTPCD_USER_ID	VARCHAR2(30)	No
PTVTPCD_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_PTVTPCD	Unique	PTVTPCD_CODE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

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

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTVTPCD

Object Dates

Creation Date	Analysis Date
04/02/2008 13:32:52:000	04/02/2008 13:49:06:000

Source Code Comments

Third Party Vendor Code Validation Table.

Columns Comments for PTVTPCD_CODE (# 1)

Source Code Comments

TP CODE: Third Party Vendor Code

Columns Comments for PTVTPCD_DESC (# 2)

Source Code Comments

TP DESCRIPTION: Third Party Vendor Description.

Columns Comments for PTVTPCD_USER_ID (# 3)

Source Code Comments

USER ID: The user identification who inserts or last modifies.

Columns Comments for PTVTPCD_ACTIVITY_DATE (# 4)

Source Code Comments

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

Link between PTRBDPL and PDRDEDN

Join Information

Objects list
schema-view : S10B80.BANINST1.PDVDAMT schema-view : S10B80.BANINST1.PDVDEDN

Link List

Link Type	Link	Project
Join	Link Between PTRBDPL and PDRDEDN	PAYROLL

List of Real links

Link type	Between	And
Join	PTRBDPL	PDRDEDN

Link between PTRBDCA and PDRDEDN

Join Information

Objects list
schema-view : S10B80.BANINST1.PDVDAMT schema-view : S10B80.BANINST1.PDVDEDN scope-cursor : S10B80.BANINST1.BWPKEBST.GETSECGRPC scope-procedure : S10B80.BANINST1.BWPKEBST.P_BENEFITS

Link List

Link Type	Link	Project
Join	Link Between PTRBDCA and PDRDEDN	PAYROLL

List of Real links

Link type	Between	And
Join	PTRBDCA	PDRDEDN

Link between PDRDEDN and PDRBDED

Join Information

Objects list

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

Link List

Link Type	Link	Project
Join	Link Between PDRDEDN and PDRBDED	PAYROLL

List of Real links

Link type	Between	And
Join	PDRDEDN	PDRBDED

Link between PTRBDPL and PDRBDED

Join Information

Objects list
schema-view : S10B80.BANINST1.PDVDEDD

Link List

Link Type	Link	Project
Join	Link Between PTRBDPL and PDRBDED	PAYROLL

List of Real links

Link type	Between	And
Join	PTRBDPL	PDRBDED

Link between PHR1042 and PHRHIST

Join Information

Objects list
scope-procedure : S10B80.BANINST1.PP_W2_2006.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.PP_W2_2007.P_COMPUTE_BOX_AMOUNTS scope-procedure : S10B80.BANINST1.PP_W2.P_COMPUTE_BOX_AMOUNTS

Link List

Link Type	Link	Project
Join	Link Between PHR1042 and PHRHIST	PAYROLL

List of Real links

Link type	Between	And
Join	PHR1042	PHRHIST

Link between PERDHIS and PDRDEDN

Join Information

Objects list
scope-procedure : S10B80.BANINST1.BWPKDOCM.P_OPENENROLLMENTCOST

Link List

Link Type	Link	Project
Join	Link Between PERDHIS and PDRDEDN	PAYROLL

List of Real links

Link type	Between	And
Join	PERDHIS	PDRDEDN

Link between PDRBDED and PTRBDPD

Join Information

Objects list
scope-cursor : S10B80.BANINST1.PDKLIBS.DEDNPRECLUDESC scope-procedure : S10B80.BANINST1.PDKDEDN.P_CHECK_PRECLUSION

Link List

Link Type	Link	Project
Join	Link Between PDRBDED and PTRBDPD	PAYROLL

List of Real links

Link type	Between	And
Join	PDRBDED	PTRBDPD

Link between PTRFBEN and PDRDEDN

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between PTRFBEN and PDRDEDN	PAYROLL

List of Real links

Link type	Between	And
Join	PTRFBEN	PDRDEDN

Link between PDRFCLM and PDRDEDN

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between PDRFCLM and PDRDEDN	PAYROLL

List of Real links

Link type	Between	And
Join	PDRFCLM	PDRDEDN

Link between PDRFBAL and PDRDEDN

Join Information

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

Link List

Link Type	Link	Project
Join	Link Between PDRFBAL and PDRDEDN	PAYROLL

List of Real links

Link type	Between	And
Join	PDRFBAL	PDRDEDN

Link between PTRBCDN and PEBEMPL

Join Information

Objects list
scope-function : S10B80.BANINST1.PDKLIBS.F_DEDNISREQUIRED scope-cursor : S10B80.BANINST1.BWPKEBST.GETSECGRPC

Link List

Link Type	Link	Project
Join	Link Between PTRBCDN and PEBEMPL	PAYROLL

List of Real links

Link type	Between	And
Join	PTRBCDN	PEBEMPL

Link between PTRBCDN and PTRBDCA

Join Information

Objects list
scope-procedure : S10B80.BANINST1.PDKDEDN.P_EDIT_BDCA_CODE scope-cursor : S10B80.BANINST1.BWPKEBST.GETSECGRPC

Link List

Link Type	Link	Project
Join	Link Between PTRBCDN and PTRBDCA	PAYROLL

List of Real links

Link type	Between	And
Join	PTRBCDN	PTRBDCA

Link between PDRDEDN and PTRBDPD

Join Information

Objects list
scope-procedure : S10B80.BANINST1.PDKDEDN.P_CHECK_PRECLUSION

Link List

Link Type	Link	Project
Join	Link Between PDRDEDN and PTRBDPD	PAYROLL

List of Real links

Link type	Between	And
Join	PDRDEDN	PTRBDPD

Link between PTRBCDN and PDRDEDN

Join Information

Objects list
scope-function : S10B80.BANINST1.POKLIBS.F_CHECK_REQD_DEDNS scope-procedure : S10B80.BANINST1.BWPKEBST.P_BENEFITS

Link List

Link Type	Link	Project
Join	Link Between PTRBCDN and PDRDEDN	PAYROLL

List of Real links

Link type	Between	And
Join	PTRBCDN	PDRDEDN

Link between PTRBDCA and PTRBDCL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PTRBDCA and PTRBDCL (FK1_PTRBDCA_INV_PTRBDCL_KEY)	PAYROLL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PTRBDCA	PTRBDCA_BDCL_CODE	PTRBDCL_CODE	PTRBDCL	(0,1)-(0,n)

Link between PTRBDPD and PTRBDCA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PTRBDPD and PTRBDCA (FK1_PTRBDPD_INV_PTRBDCA_KEY)	PAYROLL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PTRBDPD	PTRBDPD_BDCA_CODE	PTRBDCA_CODE	PTRBDCA	(1,1)-(0,n)

Link between PTRBDPL and PTRBDCA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PTRBDPL and PTRBDCA (FK1_PTRBDPL_INV_PTRBDCA_KEY)	PAYROLL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PTRBDPL	PTRBDPL_BDCA_CODE	PTRBDCA_CODE	PTRBDCA	(1,1)-(0,n)

Link between PDRFBAL and PEBEMPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PDRFBAL and PEBEMPL (FK1_PDRFBAL_INV_PEBEMPL_KEY)	PAYROLL

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)

Link between PDRFCLM and PEBEMPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PDRFCLM and PEBEMPL (FK1_PDRFCLM_INV_PEBEMPL_KEY)	PAYROLL

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)

Link between PHRHIST and PEBEMPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PHRHIST and PEBEMPL (FK1_PHRHIST_INV_PEBEMPL_KEY)	PAYROLL

Foreign Key information

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

Link between PDRDEDN and PTRBDCL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PDRDEDN and PTRBDCL (FK1_PDRDEDN_INV_PTRBDCL_KEY)	PAYROLL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PDRDEDN	PDRDEDN_BDCL_CODE	PTRBDCL_CODE	PTRBDCL	(0,1)-(0,n)

Link between PTRFBEN and PTRBDCA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PTRFBEN and PTRBDCA (FK1_PTRFBEN_INV_PTRBDCA_KEY)	PAYROLL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PTRFBEN	PTRFBEN_BDCA_CODE	PTRBDCA_CODE	PTRBDCA	(1,1)-(0,n)

Link between PDRBDED and PEBEMPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PDRBDED and PEBEMPL (FK1_PDRBDED_INV_PEBEMPL_KEY)	PAYROLL

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)

Link between PDRBDED and PTRBDCA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between PDRBDED and PTRBDCA (FK1_PDRBDED_INV_PTRBDCA_KEY)	PAYROLL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
PDRBDED	PDRBDED_BDCA_CODE	PTRBDCA_CODE	PTRBDCA	(1,1)-(0,n)