PDRBCOV PDRBDED PDRBENE PDRBFLX PDRDEDN PDRFBAL PDRFCLM PDRFLEX PDRXPID PEBEMPL PERDTOT PERPCRE PHRDEDN PTRBDCA PTRBDCG PTRBDGM PTRBDPD PTRBDPL SPRIDEN

Model Deductions


Model Label : Banner HR Deductions Module
Path : BANNER DEV/HR/Benefit / Deductions

List of Objects

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

Comments

Model View

''

Table PDRBCOV

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

Table Columns informations

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Beneficiary Coverage Repeating Table

Columns Comments for PDRBCOV_PIDM (1)

Source Code Comments

Internal ID number.

Columns Comments for PDRBCOV_BDCA_CODE (2)

Source Code Comments

The Coverage Benefit/Deduction Code.

Columns Comments for PDRBCOV_BENE_SEQ_NO (3)

Source Code Comments

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

Columns Comments for PDRBCOV_BEGIN_DATE (4)

Source Code Comments

Benefit Coverage Begin Date.

Columns Comments for PDRBCOV_END_DATE (5)

Source Code Comments

Benefit Coverage End Date.

Columns Comments for PDRBCOV_OTHER_COV_IND (6)

Source Code Comments

Indicator which indicates whether Beneficiary is otherwise covered.

Columns Comments for PDRBCOV_ACTIVITY_DATE (7)

Source Code Comments

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

Table PDRBDED

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

Table Columns informations

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Employee Deduction Repeating Base Table

Columns Comments for PDRBDED_PIDM (1)

Source Code Comments

PIDM: Internal System Indentification Number.

Columns Comments for PDRBDED_BDCA_CODE (2)

Source Code Comments

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

Columns Comments for PDRBDED_ADD_REPL_IND (3)

Source Code Comments

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

Columns Comments for PDRBDED_ADD_REPL_EMPL (4)

Source Code Comments

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

Columns Comments for PDRBDED_ADD_REPL_EMPR (5)

Source Code Comments

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

Columns Comments for PDRBDED_ADD_REPL_TAX_BASE (6)

Source Code Comments

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

Columns Comments for PDRBDED_ARR_STATUS (7)

Source Code Comments

ARREARS STATUS: The ststus of the arrears.

Columns Comments for PDRBDED_ARR_BALANCE (8)

Source Code Comments

ARREARS BALANCE: The arrears balance due the employer.

Columns Comments for PDRBDED_BOND_BALANCE (9)

Source Code Comments

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

Columns Comments for PDRBDED_BEGIN_DATE (10)

Source Code Comments

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

Columns Comments for PDRBDED_END_DATE (11)

Source Code Comments

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

Columns Comments for PDRBDED_ACTIVITY_DATE (12)

Source Code Comments

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

Columns Comments for PDRBDED_ARR_RECOVER_MAX (13)

Source Code Comments

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

Columns Comments for PDRBDED_ADD_REPL_PICT_CODE (14)

Source Code Comments

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

Table PDRBENE

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

Table Columns informations

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

Foreign Key information

Column name is Foreign Key For Column on Table
PDRBENE_BREL_CODE PTRBREL_CODE PTRBREL
PDRBENE_SEQ_NO PDRBCOV_BENE_SEQ_NO PDRBCOV
PDRBENE_PIDM PDRBCOV_PIDM PDRBCOV
PDRBENE_BENE_PIDM SPBPERS_PIDM SPBPERS

Index

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

Comments

Source Code Comments

Dependent and Beneficiary Repeating Table

Columns Comments for PDRBENE_PIDM (1)

Source Code Comments

Internal ID number.

Columns Comments for PDRBENE_SEQ_NO (2)

Source Code Comments

Sequence number identifying the Dependent/Beneficiary.

Columns Comments for PDRBENE_BENE_PIDM (3)

Source Code Comments

Internal ID number of Dependent/Beneficiary. This may be left NULL if the indi dual has not been established on the system.

Columns Comments for PDRBENE_BENE_LAST_NAME (4)

Source Code Comments

Beneficiary Last Name. This will be NULL if the Beneficiary PIDM column is fil d.

Columns Comments for PDRBENE_BENE_FIRST_NAME (5)

Source Code Comments

Beneficiary First Name. This will be NULL if the Beneficiary PIDM column is fi ed.

Columns Comments for PDRBENE_BENE_MI (6)

Source Code Comments

Beneficiary Middle Initial. This will be NULL if the Beneficiary PIDM column i filled.

Columns Comments for PDRBENE_BREL_CODE (7)

Source Code Comments

RELATIONSHIP CODE: Code used to identify the relationship of the beneficiary to the employee. The relationship code must be previously defined on the Beneficiary Relationship Rule Form (PTRBREL).

Columns Comments for PDRBENE_SEX_IND (8)

Source Code Comments

Indicates Gender of Beneficiary. This will be NULL if the Beneficiary PIDM col n is filled.

Columns Comments for PDRBENE_BIRTH_DATE (9)

Source Code Comments

Birth Date of Beneficiary. This will be NULL if the Beneficiary PIDM column is illed.

Columns Comments for PDRBENE_COLLEGE_IND (10)

Source Code Comments

COLLEGE INDICATOR; Indicates if the beneficiary is presently attending college

Columns Comments for PDRBENE_ACTIVITY_DATE (11)

Source Code Comments

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

Columns Comments for PDRBENE_SSN (12)

Source Code Comments

Beneficiary Social Security Number.

Table PDRBFLX

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

Table Columns informations

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

Foreign Key information

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

Index

Index Name Index Type Column Name
PK_PDRBFLX Unique PDRBFLX_PIDM

Comments

Source Code Comments

Flex Benefit Base Table

Columns Comments for PDRBFLX_PIDM (1)

Source Code Comments

PIDM: Internal person identification number.

Columns Comments for PDRBFLX_FLEX_AMT (2)

Source Code Comments

FLEX AMOUNT: Employee available flex amount.

Columns Comments for PDRBFLX_ACTIVITY_DATE (3)

Source Code Comments

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

Table PDRDEDN

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

Table Columns informations

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Employee Deduction Repeating Table

Columns Comments for PDRDEDN_PIDM (1)

Source Code Comments

PIDM : Internal System Identification Number.

Columns Comments for PDRDEDN_BDCA_CODE (2)

Source Code Comments

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

Columns Comments for PDRDEDN_EFFECTIVE_DATE (3)

Source Code Comments

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

Columns Comments for PDRDEDN_STATUS (4)

Source Code Comments

STATUS: The status of the benefit/deduction.

Columns Comments for PDRDEDN_REF_NO (5)

Source Code Comments

REFERENCE NUMBER: An optional alpha/numeric field.

Columns Comments for PDRDEDN_AMOUNT1 (6)

Source Code Comments

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

Columns Comments for PDRDEDN_AMOUNT2 (7)

Source Code Comments

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

Columns Comments for PDRDEDN_AMOUNT3 (8)

Source Code Comments

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

Columns Comments for PDRDEDN_AMOUNT4 (9)

Source Code Comments

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

Columns Comments for PDRDEDN_OPT_CODE1 (10)

Source Code Comments

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

Columns Comments for PDRDEDN_OPT_CODE2 (11)

Source Code Comments

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

Columns Comments for PDRDEDN_OPT_CODE3 (12)

Source Code Comments

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

Columns Comments for PDRDEDN_OPT_CODE4 (13)

Source Code Comments

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

Columns Comments for PDRDEDN_OPT_CODE5 (14)

Source Code Comments

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

Columns Comments for PDRDEDN_ACTIVITY_DATE (15)

Source Code Comments

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

Columns Comments for PDRDEDN_COVERAGE_DATE (16)

Source Code Comments

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

Table PDRFBAL

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

Table Columns informations

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Employee Flexible Benefits Balance Table

Columns Comments for PDRFBAL_PLAN_YEAR (1)

Source Code Comments

Benefit Plan Year.

Columns Comments for PDRFBAL_PIDM (2)

Source Code Comments

Employee Identification Number.

Columns Comments for PDRFBAL_BDCA_CODE (3)

Source Code Comments

Flexible Spending Account code.

Columns Comments for PDRFBAL_PLAN_CODE (4)

Source Code Comments

Flexible Spending Account plan code.

Columns Comments for PDRFBAL_AMOUNT_AVAIL (5)

Source Code Comments

Total amount available for this account.

Columns Comments for PDRFBAL_AMOUNT_SPENT (6)

Source Code Comments

Total amount spent for this account.

Columns Comments for PDRFBAL_ACTIVITY_DATE (7)

Source Code Comments

Date of Last Modification of the Record.

Table PDRFCLM

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

Table Columns informations

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Employee Flexible Benefits Claims Table

Columns Comments for PDRFCLM_PIDM (1)

Source Code Comments

Employee Identification Number.

Columns Comments for PDRFCLM_BDCA_CODE (2)

Source Code Comments

Flexible Spending Account code.

Columns Comments for PDRFCLM_PLAN_CODE (3)

Source Code Comments

Flexible Spending Account plan code.

Columns Comments for PDRFCLM_CLAIM_DATE (4)

Source Code Comments

Date of claim.

Columns Comments for PDRFCLM_REF_NO (5)

Source Code Comments

Reference number of claim.

Columns Comments for PDRFCLM_CLAIM_AMT (6)

Source Code Comments

Amount of claim that will be paid.

Columns Comments for PDRFCLM_CLAIM_PAID (7)

Source Code Comments

Date of Last Modification of the Record.

Columns Comments for PDRFCLM_ACTIVITY_DATE (8)

Source Code Comments

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

Table PDRFLEX

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

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PDRFLEX_PIDM PDRFLEX_PIDM NUMBER(8,0) No
PDRFLEX_BDCA_CODE PDRFLEX_BDCA_CODE VARCHAR2(3) No
PDRFLEX_PLAN_CODE PDRFLEX_PLAN_CODE VARCHAR2(2) Yes
PDRFLEX_STATUS PDRFLEX_STATUS VARCHAR2(1) No
PDRFLEX_START_DATE PDRFLEX_START_DATE DATE No
PDRFLEX_END_DATE PDRFLEX_END_DATE DATE Yes
PDRFLEX_AMOUNT1 PDRFLEX_AMOUNT1 NUMBER(11,2) Yes
PDRFLEX_AMOUNT2 PDRFLEX_AMOUNT2 NUMBER(11,2) Yes
PDRFLEX_AMOUNT3 PDRFLEX_AMOUNT3 NUMBER(11,2) Yes
PDRFLEX_AMOUNT4 PDRFLEX_AMOUNT4 NUMBER(11,2) Yes
PDRFLEX_LIF_OVR_UDR_AMT PDRFLEX_LIF_OVR_UDR_AMT NUMBER(11,2) Yes
PDRFLEX_APPR_IND PDRFLEX_APPR_IND VARCHAR2(1) Yes
PDRFLEX_PROCESS_IND PDRFLEX_PROCESS_IND VARCHAR2(1) Yes
PDRFLEX_ACTIVITY_DATE PDRFLEX_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

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

Comments

Source Code Comments

Employee Flexible Benefits Table

Columns Comments for PDRFLEX_PIDM (1)

Source Code Comments

Internal ID code.

Columns Comments for PDRFLEX_BDCA_CODE (2)

Source Code Comments

Flexible Benefit Code.

Columns Comments for PDRFLEX_PLAN_CODE (3)

Source Code Comments

Flexible Benefit Plan.

Columns Comments for PDRFLEX_STATUS (4)

Source Code Comments

Status: The flexible benefit/deduction status.

Columns Comments for PDRFLEX_START_DATE (5)

Source Code Comments

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

Columns Comments for PDRFLEX_END_DATE (6)

Source Code Comments

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

Columns Comments for PDRFLEX_AMOUNT1 (7)

Source Code Comments

Amount 1

Columns Comments for PDRFLEX_AMOUNT2 (8)

Source Code Comments

Amount 2

Columns Comments for PDRFLEX_AMOUNT3 (9)

Source Code Comments

Amount 3

Columns Comments for PDRFLEX_AMOUNT4 (10)

Source Code Comments

Amount 4

Columns Comments for PDRFLEX_LIF_OVR_UDR_AMT (11)

Source Code Comments

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

Columns Comments for PDRFLEX_APPR_IND (12)

Source Code Comments

Approved Indicator.

Columns Comments for PDRFLEX_PROCESS_IND (13)

Source Code Comments

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

Columns Comments for PDRFLEX_ACTIVITY_DATE (14)

Source Code Comments

Date of Last Modification of the Record.

Table PDRXPID

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

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PDRXPID_PIDM PDRXPID_PIDM NUMBER(8,0) No * *
PDRXPID_BDCA_CODE PDRXPID_BDCA_CODE VARCHAR2(3) No * *
PDRXPID_PICT_CODE PDRXPID_PICT_CODE VARCHAR2(2) No * *
PDRXPID_ACTIVITY_DATE PDRXPID_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PDRXPID_PIDM PDRBDED_PIDM PDRBDED
PDRXPID_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED
PDRXPID_PICT_CODE PTRPICT_CODE PTRPICT

Index

Index Name Index Type Column Name
PK_PDRXPID Unique PDRXPID_PIDM
PK_PDRXPID Unique PDRXPID_BDCA_CODE
PK_PDRXPID Unique PDRXPID_PICT_CODE

Comments

Source Code Comments

Emp Dedn Excl Pay Id Repeating Table

Columns Comments for PDRXPID_PIDM (1)

Source Code Comments

PIDM: Internal ID number.

Columns Comments for PDRXPID_BDCA_CODE (2)

Source Code Comments

DEDUCTION CODE: The deduction code for which an excluded Pay ID is being defined.

Columns Comments for PDRXPID_PICT_CODE (3)

Source Code Comments

PAY ID CODE: The Pay ID code which is being excluded from processing for this deduction.

Columns Comments for PDRXPID_ACTIVITY_DATE (4)

Source Code Comments

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

Table PEBEMPL

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

Table Columns informations

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

Foreign Key information

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

Index

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

Comments

Source Code Comments

Employee Base Table

Columns Comments for PEBEMPL_PIDM (1)

Source Code Comments

PIDM: Internal System Identification Number.

Columns Comments for PEBEMPL_EMPL_STATUS (2)

Source Code Comments

EMPLOYEE STATUS: The status of the employee.

Columns Comments for PEBEMPL_COAS_CODE_HOME (3)

Source Code Comments

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

Columns Comments for PEBEMPL_ORGN_CODE_HOME (4)

Source Code Comments

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

Columns Comments for PEBEMPL_COAS_CODE_DIST (5)

Source Code Comments

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

Columns Comments for PEBEMPL_ORGN_CODE_DIST (6)

Source Code Comments

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

Columns Comments for PEBEMPL_ECLS_CODE (7)

Source Code Comments

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

Columns Comments for PEBEMPL_LCAT_CODE (8)

Source Code Comments

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

Columns Comments for PEBEMPL_BCAT_CODE (9)

Source Code Comments

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

Columns Comments for PEBEMPL_FIRST_HIRE_DATE (10)

Source Code Comments

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

Columns Comments for PEBEMPL_CURRENT_HIRE_DATE (11)

Source Code Comments

CURRENT HIRE DATE: The employees current date of hire.

Columns Comments for PEBEMPL_ADJ_SERVICE_DATE (12)

Source Code Comments

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

Columns Comments for PEBEMPL_SENIORITY_DATE (13)

Source Code Comments

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

Columns Comments for PEBEMPL_LREA_CODE (14)

Source Code Comments

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

Columns Comments for PEBEMPL_LOA_BEG_DATE (15)

Source Code Comments

LEAVE OF ABSENCE BEGIN DATE: The begin date of a leave of absence for the employee.

Columns Comments for PEBEMPL_LOA_END_DATE (16)

Source Code Comments

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

Columns Comments for PEBEMPL_TREA_CODE (17)

Source Code Comments

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

Columns Comments for PEBEMPL_TERM_DATE (18)

Source Code Comments

TERMINATION DATE: Termination date of the employee.

Columns Comments for PEBEMPL_I9_FORM_IND (19)

Source Code Comments

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

Columns Comments for PEBEMPL_I9_DATE (20)

Source Code Comments

I9 DATE: The date immigration information was received.

Columns Comments for PEBEMPL_I9_EXPIRE_DATE (21)

Source Code Comments

I9 EXPIRATION DATE: The date the immigration information expires.

Columns Comments for PEBEMPL_ACTIVITY_DATE (22)

Source Code Comments

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

Columns Comments for PEBEMPL_WKPR_CODE (23)

Source Code Comments

WKPR_CODE: Work Period Code

Columns Comments for PEBEMPL_FLSA_IND (24)

Source Code Comments

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

Columns Comments for PEBEMPL_STGR_CODE (25)

Source Code Comments

STGR_CODE: Statistics Canada Grouping Code.

Columns Comments for PEBEMPL_DAYS_IN_CANADA (26)

Source Code Comments

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

Columns Comments for PEBEMPL_1042_RECIPIENT_CD (27)

Source Code Comments

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

Columns Comments for PEBEMPL_INTERNAL_FT_PT_IND (28)

Source Code Comments

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

Columns Comments for PEBEMPL_DICD_CODE (29)

Source Code Comments

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

Columns Comments for PEBEMPL_EGRP_CODE (30)

Source Code Comments

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

Columns Comments for PEBEMPL_IPEDS_SOFT_MONEY_IND (31)

Source Code Comments

IPEDS Soft Money Indicator.

Columns Comments for PEBEMPL_FIRST_WORK_DATE (32)

Source Code Comments

The first day that employee worked.

Columns Comments for PEBEMPL_LAST_WORK_DATE (33)

Source Code Comments

The last day that employee worked.

Columns Comments for PEBEMPL_CALIF_PENSION_IND (34)

Source Code Comments

California Pension Indicator.

Columns Comments for PEBEMPL_NRSI_CODE (35)

Source Code Comments

NRSI CODE:Non-resident Service Code.

Columns Comments for PEBEMPL_SSN_LAST_NAME (36)

Source Code Comments

Social security last name used in regulatory.

Columns Comments for PEBEMPL_SSN_FIRST_NAME (37)

Source Code Comments

Social security first name used in regulatory.

Columns Comments for PEBEMPL_SSN_MI (38)

Source Code Comments

Social security middle name used in regulatory.

Columns Comments for PEBEMPL_SSN_SUFFIX (39)

Source Code Comments

Social security name suffix used in regulatory.

Columns Comments for PEBEMPL_JBLN_CODE (40)

Source Code Comments

LOCATION CODE: The Location to which the employee belongs.

Columns Comments for PEBEMPL_COLL_CODE (41)

Source Code Comments

COLLEGE CODE: The College to which the employee belongs.

Columns Comments for PEBEMPL_CAMP_CODE (42)

Source Code Comments

CAMPUS CODE: The Campus to which the employee belongs.

Table PERDTOT

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:11:000

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PERDTOT_PIDM PERDTOT_PIDM NUMBER(8,0) No * *
PERDTOT_PIDM PERDTOT_PIDM NUMBER(8,0) No * *
PERDTOT_YEAR PERDTOT_YEAR NUMBER(4,0) No * *
PERDTOT_BDCA_CODE PERDTOT_BDCA_CODE VARCHAR2(3) No * *
PERDTOT_BDCA_CODE PERDTOT_BDCA_CODE VARCHAR2(3) No * *
PERDTOT_BDCA_CODE PERDTOT_BDCA_CODE VARCHAR2(3) No * *
PERDTOT_BDCA_CODE PERDTOT_BDCA_CODE VARCHAR2(3) No * *
PERDTOT_MONTH PERDTOT_MONTH NUMBER(2,0) No *
PERDTOT_EMPL_AMT PERDTOT_EMPL_AMT NUMBER(11,2) Yes
PERDTOT_EMPR_AMT PERDTOT_EMPR_AMT NUMBER(11,2) Yes
PERDTOT_APPL_GRS PERDTOT_APPL_GRS NUMBER(11,2) Yes
PERDTOT_ACTIVITY_DATE PERDTOT_ACTIVITY_DATE DATE No
PERDTOT_EMPR_CODE PERDTOT_EMPR_CODE VARCHAR2(4) No * *
PERDTOT_EMPR_CODE PERDTOT_EMPR_CODE VARCHAR2(4) No * *

Foreign Key information

Column name is Foreign Key For Column on Table
PERDTOT_PIDM PDRBDED_PIDM PDRBDED
PERDTOT_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED
PERDTOT_EMPR_CODE PTREMPR_CODE PTREMPR
PERDTOT_BDCA_CODE PTRBDAS_BDCA_CODE PTRBDAS
PERDTOT_BDCA_CODE PXRRDED_BDCA_CODE PXRRDED
PERDTOT_EMPR_CODE PXRREPT_EMPR_CODE PXRREPT
PERDTOT_YEAR PXRREPT_YEAR PXRREPT
PERDTOT_PIDM PXRREPT_PIDM PXRREPT
PERDTOT_BDCA_CODE PTRBDCA_CODE PTRBDCA

Index

Index Name Index Type Column Name
PERDTOT_KEY2_INDEX PERDTOT_EMPR_CODE
PERDTOT_KEY2_INDEX PERDTOT_YEAR
PERDTOT_KEY2_INDEX PERDTOT_MONTH
PERDTOT_KEY2_INDEX PERDTOT_BDCA_CODE
PK_PERDTOT Unique PERDTOT_PIDM
PK_PERDTOT Unique PERDTOT_YEAR
PK_PERDTOT Unique PERDTOT_EMPR_CODE
PK_PERDTOT Unique PERDTOT_BDCA_CODE
PK_PERDTOT Unique PERDTOT_MONTH

Comments

Source Code Comments

Employee Monthly Benefit / Deduction Totals Repeating Table

Columns Comments for PERDTOT_PIDM (1)

Source Code Comments

Person Identification Number for this record.

Columns Comments for PERDTOT_YEAR (2)

Source Code Comments

Payroll Deduction Year; calendar year in which the payroll deduction took place for this record.

Columns Comments for PERDTOT_BDCA_CODE (3)

Source Code Comments

Benefit/Deduction Code that defines the deduction of pay.

Columns Comments for PERDTOT_MONTH (4)

Source Code Comments

Calendar month in which the payroll deduction took place.

Columns Comments for PERDTOT_EMPL_AMT (5)

Source Code Comments

Employee contribution amount toward the deduction.

Columns Comments for PERDTOT_EMPR_AMT (6)

Source Code Comments

Employer contribution amount toward the deduction.

Columns Comments for PERDTOT_APPL_GRS (7)

Source Code Comments

Total Gross Conpensation toward which deduction is applicable.

Columns Comments for PERDTOT_ACTIVITY_DATE (8)

Source Code Comments

Last insert or update of this record.

Columns Comments for PERDTOT_EMPR_CODE (9)

Source Code Comments

EMPR_CODE: The Employer Identification Code.

Table PERPCRE

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

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PERPCRE_YEAR PERPCRE_YEAR NUMBER(4,0) No
PERPCRE_EMPR_CODE PERPCRE_EMPR_CODE VARCHAR2(4) No *
PERPCRE_PIDM PERPCRE_PIDM NUMBER(8,0) No *
PERPCRE_BDCA_CODE PERPCRE_BDCA_CODE VARCHAR2(3) No *
PERPCRE_BDPL_CODE PERPCRE_BDPL_CODE VARCHAR2(2) Yes
PERPCRE_PENSION_CREDIT PERPCRE_PENSION_CREDIT NUMBER(11,2) No
PERPCRE_CREDIT_OVERRIDE PERPCRE_CREDIT_OVERRIDE NUMBER(11,2) Yes
PERPCRE_PENSION_SERVICE PERPCRE_PENSION_SERVICE NUMBER(6,2) No
PERPCRE_SERVICE_OVERRIDE PERPCRE_SERVICE_OVERRIDE NUMBER(6,2) Yes
PERPCRE_ACTIVITY_DATE PERPCRE_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PERPCRE_PIDM PDRBDED_PIDM PDRBDED
PERPCRE_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED
PERPCRE_EMPR_CODE PTREMPR_CODE PTREMPR

Index

Index Name Index Type Column Name
PERPCRE_KEY_INDEX Unique PERPCRE_YEAR
PERPCRE_KEY_INDEX Unique PERPCRE_EMPR_CODE
PERPCRE_KEY_INDEX Unique PERPCRE_PIDM
PERPCRE_KEY_INDEX Unique PERPCRE_BDCA_CODE
PERPCRE_KEY_INDEX Unique PERPCRE_BDPL_CODE

Comments

Source Code Comments

Employee Canadian Pension Credit Repeating Table.

Columns Comments for PERPCRE_YEAR (1)

Source Code Comments

CALENDAR YEAR.

Columns Comments for PERPCRE_EMPR_CODE (2)

Source Code Comments

EMPLOYER CODE.

Columns Comments for PERPCRE_PIDM (3)

Source Code Comments

PIDM : Internal Identification Number associated with a person.

Columns Comments for PERPCRE_BDCA_CODE (4)

Source Code Comments

DEDUCTION CODE.

Columns Comments for PERPCRE_BDPL_CODE (5)

Source Code Comments

BENEFIT/DEDUCTION PLAN CODE: Identifies the Plan associated with the benefit defined.

Columns Comments for PERPCRE_PENSION_CREDIT (6)

Source Code Comments

PENSION CREDIT : A measure of the value of benefits accruing to an employee under the pension plan. Each benefit provision of an RPP (Registered Pension Plan) or DPSP (Deferred Profit Sharing Plan) produces a pension credit for the participating employee.

Columns Comments for PERPCRE_CREDIT_OVERRIDE (7)

Source Code Comments

PENSION CREDIT OVERRIDE : The value to override the calculated pension credit must be entered in this field. If this field has a value, the system uses the override value in the calculation of the Pension Adjustment.

Columns Comments for PERPCRE_PENSION_SERVICE (8)

Source Code Comments

PENSIONABLE SERVICE : Pensionable service of employee. Maximum value is 1.

Columns Comments for PERPCRE_SERVICE_OVERRIDE (9)

Source Code Comments

PENSIONABLE SERVICE OVERRIDE: The value to override the calculated pensionable service must be enterd in this field. If this field has a value, then the system uses this value in the calculation of the Pension Credit.

Columns Comments for PERPCRE_ACTIVITY_DATE (10)

Source Code Comments

ACTIVITY DATE: Date of last modification to the record.

Table PHRDEDN

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

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PHRDEDN_YEAR PHRDEDN_YEAR VARCHAR2(4) No *
PHRDEDN_PICT_CODE PHRDEDN_PICT_CODE VARCHAR2(2) No *
PHRDEDN_PAYNO PHRDEDN_PAYNO NUMBER(3,0) No *
PHRDEDN_PIDM PHRDEDN_PIDM NUMBER(8,0) No * *
PHRDEDN_SEQ_NO PHRDEDN_SEQ_NO NUMBER(2,0) No *
PHRDEDN_EFFECTIVE_DATE PHRDEDN_EFFECTIVE_DATE DATE No *
PHRDEDN_STATUS PHRDEDN_STATUS VARCHAR2(1) No *
PHRDEDN_BDCA_CODE PHRDEDN_BDCA_CODE VARCHAR2(3) No * *
PHRDEDN_BDCA_CODE PHRDEDN_BDCA_CODE VARCHAR2(3) No * *
PHRDEDN_BDCA_CODE PHRDEDN_BDCA_CODE VARCHAR2(3) No * *
PHRDEDN_EMPLOYEE_AMT PHRDEDN_EMPLOYEE_AMT NUMBER(11,2) Yes
PHRDEDN_EMPLOYER_AMT PHRDEDN_EMPLOYER_AMT NUMBER(11,2) Yes
PHRDEDN_APPLICABLE_GROSS PHRDEDN_APPLICABLE_GROSS NUMBER(11,2) Yes
PHRDEDN_ARREAR_TAKEN PHRDEDN_ARREAR_TAKEN NUMBER(11,2) Yes
PHRDEDN_ARREAR_RECOVERED PHRDEDN_ARREAR_RECOVERED NUMBER(11,2) Yes
PHRDEDN_ACTIVITY_DATE PHRDEDN_ACTIVITY_DATE DATE No
PHRDEDN_EMPR_CODE PHRDEDN_EMPR_CODE VARCHAR2(4) No * *

Foreign Key information

Column name is Foreign Key For Column on Table
PHRDEDN_PIDM PDRBDED_PIDM PDRBDED
PHRDEDN_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED
PHRDEDN_EMPR_CODE PTREMPR_CODE PTREMPR
PHRDEDN_BDCA_CODE PTRBDGM_BDCA_CODE PTRBDGM
PHRDEDN_BDCA_CODE PTRBDCA_CODE PTRBDCA

Index

Index Name Index Type Column Name
PHRDEDN_KEY2_INDEX PHRDEDN_PIDM
PHRDEDN_KEY2_INDEX PHRDEDN_YEAR
PHRDEDN_KEY2_INDEX PHRDEDN_PICT_CODE
PHRDEDN_KEY2_INDEX PHRDEDN_PAYNO
PHRDEDN_KEY2_INDEX PHRDEDN_SEQ_NO
PHRDEDN_KEY2_INDEX PHRDEDN_EMPR_CODE
PHRDEDN_KEY3_INDEX PHRDEDN_PIDM
PHRDEDN_KEY3_INDEX PHRDEDN_BDCA_CODE
PHRDEDN_KEY3_INDEX PHRDEDN_EFFECTIVE_DATE
PK_PHRDEDN Unique PHRDEDN_YEAR
PK_PHRDEDN Unique PHRDEDN_PICT_CODE
PK_PHRDEDN Unique PHRDEDN_PAYNO
PK_PHRDEDN Unique PHRDEDN_PIDM
PK_PHRDEDN Unique PHRDEDN_SEQ_NO
PK_PHRDEDN Unique PHRDEDN_EMPR_CODE
PK_PHRDEDN Unique PHRDEDN_BDCA_CODE
PK_PHRDEDN Unique PHRDEDN_EFFECTIVE_DATE
PK_PHRDEDN Unique PHRDEDN_STATUS

Comments

Source Code Comments

Pay History Deduction Repeating Table

Columns Comments for PHRDEDN_YEAR (1)

Source Code Comments

YEAR; The year associated with this payroll.

Columns Comments for PHRDEDN_PICT_CODE (2)

Source Code Comments

PAYROLL IDENTIFICATION CODE: The pay id code associated with this payroll.

Columns Comments for PHRDEDN_PAYNO (3)

Source Code Comments

PAYROLL NUMBER; The pay number associated with this payroll.

Columns Comments for PHRDEDN_PIDM (4)

Source Code Comments

PIDM: Internal ID number.

Columns Comments for PHRDEDN_SEQ_NO (5)

Source Code Comments

SEQUENCE NUMBER; The internal sequence number associated with this pay event.

Columns Comments for PHRDEDN_EFFECTIVE_DATE (6)

Source Code Comments

EFFECTIVE DATE; The effective date associated with the deduction for this pay period.

Columns Comments for PHRDEDN_STATUS (7)

Source Code Comments

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

Columns Comments for PHRDEDN_BDCA_CODE (8)

Source Code Comments

BENEFIT/DEDUCTION CODE: History Benefit/Deduction Code.

Columns Comments for PHRDEDN_EMPLOYEE_AMT (9)

Source Code Comments

EMPLOYEE DEDUCTION AMOUNT.

Columns Comments for PHRDEDN_EMPLOYER_AMT (10)

Source Code Comments

EMPLOYER DEDUCTION AMOUNT.

Columns Comments for PHRDEDN_APPLICABLE_GROSS (11)

Source Code Comments

EMPLOYEE APPLICABLE GROSS AMOUNT.

Columns Comments for PHRDEDN_ARREAR_TAKEN (12)

Source Code Comments

ARREARAGE TAKEN; The amount of arrearage generated during this pay period.

Columns Comments for PHRDEDN_ARREAR_RECOVERED (13)

Source Code Comments

ARREARAGE RECOVERED: The amount of arrearage recovered this pay period.

Columns Comments for PHRDEDN_ACTIVITY_DATE (14)

Source Code Comments

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

Columns Comments for PHRDEDN_EMPR_CODE (15)

Source Code Comments

EMPR_CODE: The Employer Identification Code.

Table PTRBDCA

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 08/15/2002 14:19:54:000

Table Columns informations

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

Foreign Key information

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

Index

Index Name Index Type Column Name
PK_PTRBDCA Unique PTRBDCA_CODE

Comments

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

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.

Table PTRBDCG

Schema Name PAYROLL
Server name MALDEV8_B60
Creation Date 02/24/2003 16:51:56:000

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PTRBDCG_CODE PTRBDCG_CODE VARCHAR2(3) No * *
PTRBDCG_BDCA_CODE PTRBDCG_BDCA_CODE VARCHAR2(3) No * *
PTRBDCG_USER_ID PTRBDCG_USER_ID VARCHAR2(30) No
PTRBDCG_ACTIVITY_DATE PTRBDCG_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_PTRBDCG Unique PTRBDCG_CODE
PK_PTRBDCG Unique PTRBDCG_BDCA_CODE
PTRBDCG_BDCA_CODE_INDEX PTRBDCG_BDCA_CODE

Comments

Source Code Comments

Benefit / Deduction Contingent Rule Table

Columns Comments for PTRBDCG_CODE (1)

Source Code Comments

CONTINGENT DEDUCTION CODE: This fieldindicates Contingent Deduction Code.

Columns Comments for PTRBDCG_BDCA_CODE (2)

Source Code Comments

CORE DEDUCTION CODE: This field indicates Core Deduction Code.

Columns Comments for PTRBDCG_USER_ID (3)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user who changed the record.

Columns Comments for PTRBDCG_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date thatthe information for the row was inserted or updated in the PTRBDCG table.

Table PTRBDGM

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

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PTRBDGM_BDCA_CODE PTRBDGM_BDCA_CODE VARCHAR2(3) No * *
PTRBDGM_BDPG_CODE PTRBDGM_BDPG_CODE VARCHAR2(2) No *
PTRBDGM_BDSG_CODE PTRBDGM_BDSG_CODE VARCHAR2(4) No *
PTRBDGM_WEB_SEL_IND PTRBDGM_WEB_SEL_IND VARCHAR2(1) No
PTRBDGM_WEB_INS_IND PTRBDGM_WEB_INS_IND VARCHAR2(1) No
PTRBDGM_WEB_UPD_IND PTRBDGM_WEB_UPD_IND VARCHAR2(1) No
PTRBDGM_WEB_DEL_IND PTRBDGM_WEB_DEL_IND VARCHAR2(1) No
PTRBDGM_WEB_EMPR_IND PTRBDGM_WEB_EMPR_IND VARCHAR2(1) No
PTRBDGM_WEB_CVG_SEL_IND PTRBDGM_WEB_CVG_SEL_IND VARCHAR2(1) No
PTRBDGM_WEB_CVG_INS_IND PTRBDGM_WEB_CVG_INS_IND VARCHAR2(1) No
PTRBDGM_WEB_CVG_UPD_IND PTRBDGM_WEB_CVG_UPD_IND VARCHAR2(1) No
PTRBDGM_WEB_CVG_DEL_IND PTRBDGM_WEB_CVG_DEL_IND VARCHAR2(1) No
PTRBDGM_WEB_OPEN_IND PTRBDGM_WEB_OPEN_IND VARCHAR2(1) No
PTRBDGM_ACTIVITY_DATE PTRBDGM_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
PTRBDGM_BDSG_CODE PTRBDSG_CODE PTRBDSG
PTRBDGM_BDPG_CODE PTRBDSG_BDPG_CODE PTRBDSG
PTRBDGM_BDCA_CODE PTRBDCA_CODE PTRBDCA

Index

Index Name Index Type Column Name
PK_PTRBDGM Unique PTRBDGM_BDCA_CODE

Comments

Source Code Comments

Benefit/Deduction group member rule table

Columns Comments for PTRBDGM_BDCA_CODE (1)

Source Code Comments

PTRBDGM_BDCA_CODE: Deduction code from PTRBDCA table

Columns Comments for PTRBDGM_BDPG_CODE (2)

Source Code Comments

PTRBDGM_BDPG_CODE:Primary Group Code

Columns Comments for PTRBDGM_BDSG_CODE (3)

Source Code Comments

PTRBDGM_BDSG_CODE: Indicates which Secondary group this group member belongs to

Columns Comments for PTRBDGM_WEB_SEL_IND (4)

Source Code Comments

PTRBDGM_WEB_SEL_IND: Should members of this Group be displayed on the WEB

Columns Comments for PTRBDGM_WEB_INS_IND (5)

Source Code Comments

PTRBDGM_WEB_INS_IND: should members of this group be allowed inserts from Web

Columns Comments for PTRBDGM_WEB_UPD_IND (6)

Source Code Comments

PTRBDGM_WEB_UPD_IND: Should members of this group be allowed updates from the Web

Columns Comments for PTRBDGM_WEB_DEL_IND (7)

Source Code Comments

PTRBDGM_WEB_DEL_IND: Should members of this group be allowed deletes from the Web

Columns Comments for PTRBDGM_WEB_EMPR_IND (8)

Source Code Comments

PTRBDGM_WEB_EMPR_IND: Should Employer amounts be processed on Web

Columns Comments for PTRBDGM_WEB_CVG_SEL_IND (9)

Source Code Comments

PTRBDGM_WEB_CVG_SEL_IND: Can deduction coverage be displayed on Web

Columns Comments for PTRBDGM_WEB_CVG_INS_IND (10)

Source Code Comments

PTRBDGM_WEB_CVG_INS_IND: Can deduction coverage be inserted on Web

Columns Comments for PTRBDGM_WEB_CVG_UPD_IND (11)

Source Code Comments

PTRBDGM_WEB_CVG_UPD_IND: Can deduction coverage be updated on Web

Columns Comments for PTRBDGM_WEB_CVG_DEL_IND (12)

Source Code Comments

PTRBDGM_WEB_CVG_DEL_IND: Can deduction coverage be deleted on Web

Columns Comments for PTRBDGM_WEB_OPEN_IND (13)

Source Code Comments

PTRBDGM_WEB_OPEN_IND: Should members of this group be in the Open Enrollment

Columns Comments for PTRBDGM_ACTIVITY_DATE (14)

Source Code Comments

PTRBDGM_ACTIVITY_DATE: date of last update

Table PTRBDPD

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

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PTRBDPD_CODE PTRBDPD_CODE VARCHAR2(3) No *
PTRBDPD_BDCA_CODE PTRBDPD_BDCA_CODE VARCHAR2(3) No * *
PTRBDPD_ACTIVITY_DATE 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

Comments

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

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

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
PTRBDPL_BDCA_CODE PTRBDPL_BDCA_CODE VARCHAR2(3) No *
PTRBDPL_BDCA_CODE PTRBDPL_BDCA_CODE VARCHAR2(3) No *
PTRBDPL_BDCA_CODE PTRBDPL_BDCA_CODE VARCHAR2(3) No *
PTRBDPL_CODE PTRBDPL_CODE VARCHAR2(2) Yes
PTRBDPL_DESC PTRBDPL_DESC VARCHAR2(30) Yes
PTRBDPL_AMT1 PTRBDPL_AMT1 NUMBER(11,2) Yes
PTRBDPL_AMT2 PTRBDPL_AMT2 NUMBER(11,2) Yes
PTRBDPL_AMT3 PTRBDPL_AMT3 NUMBER(11,2) Yes
PTRBDPL_AMT4 PTRBDPL_AMT4 NUMBER(11,2) Yes
PTRBDPL_ACTIVITY_DATE PTRBDPL_ACTIVITY_DATE DATE No
PTRBDPL_EFFECTIVE_DATE 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 PDRBDED_BDCA_CODE PDRBDED
PTRBDPL_BDCA_CODE PDRDEDN_BDCA_CODE PDRDEDN

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

Comments

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 SPRIDEN

Schema Name SATURN
Server name MALDEV8_B60
Creation Date 08/01/2003 10:01:36:000

Table Columns informations

Column Name Label Column Type Allow NULL PK FK
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_PIDM SPRIDEN_PIDM NUMBER(8,0) No *
SPRIDEN_ID SPRIDEN_ID VARCHAR2(9) No *
SPRIDEN_LAST_NAME SPRIDEN_LAST_NAME VARCHAR2(60) No
SPRIDEN_FIRST_NAME SPRIDEN_FIRST_NAME VARCHAR2(15) Yes
SPRIDEN_MI SPRIDEN_MI VARCHAR2(15) Yes
SPRIDEN_CHANGE_IND SPRIDEN_CHANGE_IND VARCHAR2(1) Yes
SPRIDEN_ENTITY_IND SPRIDEN_ENTITY_IND VARCHAR2(1) Yes
SPRIDEN_ACTIVITY_DATE SPRIDEN_ACTIVITY_DATE DATE No
SPRIDEN_USER SPRIDEN_USER VARCHAR2(30) Yes
SPRIDEN_ORIGIN SPRIDEN_ORIGIN VARCHAR2(30) Yes
SPRIDEN_SEARCH_LAST_NAME SPRIDEN_SEARCH_LAST_NAME VARCHAR2(60) Yes
SPRIDEN_SEARCH_FIRST_NAME SPRIDEN_SEARCH_FIRST_NAME VARCHAR2(15) Yes
SPRIDEN_SEARCH_MI SPRIDEN_SEARCH_MI VARCHAR2(15) Yes
SPRIDEN_SOUNDEX_LAST_NAME SPRIDEN_SOUNDEX_LAST_NAME CHAR(4) Yes
SPRIDEN_SOUNDEX_FIRST_NAME SPRIDEN_SOUNDEX_FIRST_NAME CHAR(4) Yes
SPRIDEN_NTYP_CODE SPRIDEN_NTYP_CODE VARCHAR2(4) Yes
SPRIDEN_CREATE_USER SPRIDEN_CREATE_USER VARCHAR2(30) Yes
SPRIDEN_CREATE_DATE SPRIDEN_CREATE_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SPRIDEN_PIDM SGBSTDN_PIDM SGBSTDN
SPRIDEN_PIDM PEBEMPL_PIDM PEBEMPL
SPRIDEN_PIDM SORPCOL_PIDM SORPCOL
SPRIDEN_PIDM TBRISTL_PIDM TBRISTL
SPRIDEN_PIDM RPRATRM_PIDM RPRATRM
SPRIDEN_PIDM RPRAWRD_PIDM RPRAWRD
SPRIDEN_PIDM TBRCOLC_PIDM TBRCOLC
SPRIDEN_PIDM ASRSORG_PIDM ASRSORG
SPRIDEN_PIDM SHRTTRM_PIDM SHRTTRM
SPRIDEN_PIDM SMBSLIB_PIDM SMBSLIB
SPRIDEN_PIDM APRCHLD_CHLD_PIDM APRCHLD
SPRIDEN_PIDM APREHIS_EMPR_PIDM APREHIS
SPRIDEN_PIDM PERBARG_PIDM PERBARG
SPRIDEN_PIDM PARAPIN_PIDM PARAPIN
SPRIDEN_PIDM TBRACCD_PIDM TBRACCD
SPRIDEN_PIDM PDRBDED_PIDM PDRBDED
SPRIDEN_PIDM SORAROL_PIDM SORAROL
SPRIDEN_PIDM SIRASGN_PIDM SIRASGN
SPRIDEN_PIDM FTVFMGR_FMGR_CODE_PIDM FTVFMGR
SPRIDEN_PIDM TBRDEPO_PIDM TBRDEPO
SPRIDEN_PIDM FPBPOHD_VEND_PIDM FPBPOHD
SPRIDEN_PIDM SLBEVNT_AGENCY_PIDM SLBEVNT
SPRIDEN_PIDM FTVVEND_PIDM FTVVEND
SPRIDEN_PIDM RNRTMNT_PIDM RNRTMNT
SPRIDEN_PIDM SHBHEAD_PIDM SHBHEAD
SPRIDEN_PIDM SMRRQCM_ORIG_PIDM SMRRQCM
SPRIDEN_PIDM SMRRQCM_PIDM SMRRQCM
SPRIDEN_PIDM GORSEVD_DEP_PIDM GORSEVD
SPRIDEN_PIDM GOBSEVS_PIDM GOBSEVS
SPRIDEN_PIDM PETJOBS_PIDM PETJOBS
SPRIDEN_PIDM TBBESTU_PIDM TBBESTU
SPRIDEN_PIDM FCREMPO_PIDM FCREMPO
SPRIDEN_PIDM SORAINF_PIDM SORAINF
SPRIDEN_PIDM NBRJOBS_PIDM NBRJOBS
SPRIDEN_PIDM GORSEVS_PIDM GORSEVS
SPRIDEN_PIDM FTVAGCY_AGCY_CODE_PIDM FTVAGCY
SPRIDEN_PIDM PDRBENE_BENE_PIDM PDRBENE
SPRIDEN_PIDM FPBREQH_VEND_PIDM FPBREQH
SPRIDEN_PIDM APRCHIS_PIDM APRCHIS
SPRIDEN_PIDM PERREVW_REVIEWER_PIDM PERREVW
SPRIDEN_PIDM FTVFUND_FMGR_CODE_PIDM FTVFUND
SPRIDEN_PIDM TBBACCT_PIDM TBBACCT
SPRIDEN_PIDM GERATTD_PIDM GERATTD
SPRIDEN_PIDM GORSVAS_ACT_SITE_PIDM GORSVAS
SPRIDEN_PIDM GORSVEI_EMPLOYER_PIDM GORSVEI
SPRIDEN_PIDM AGBMGID_EMPR_PIDM AGBMGID
SPRIDEN_PIDM AGBMGID_EMPL_PIDM AGBMGID
SPRIDEN_PIDM PERTETH_TRANS_PIDM PERTETH
SPRIDEN_PIDM PERJOBS_PIDM PERJOBS
SPRIDEN_PIDM PERROUT_ACTION_PIDM PERROUT
SPRIDEN_PIDM PERROUT_APPR_PIDM PERROUT
SPRIDEN_PIDM SHRMRKS_PIDM SHRMRKS
SPRIDEN_PIDM SHRSMRK_PIDM SHRSMRK
SPRIDEN_PIDM GOBEACC_PIDM GOBEACC
SPRIDEN_PIDM RCRAPP1_PIDM RCRAPP1
SPRIDEN_PIDM RPRLAPP_LENDER_PIDM RPRLAPP
SPRIDEN_PIDM SFRAREG_PIDM SFRAREG
SPRIDEN_PIDM GORVISA_PIDM GORVISA
SPRIDEN_ID SRTIDEN_ID SRTIDEN
SPRIDEN_PIDM SRTIDEN_PIDM SRTIDEN
SPRIDEN_PIDM FTVIMGR_IMGR_CODE_PIDM FTVIMGR
SPRIDEN_PIDM APRACYR_PIDM APRACYR
SPRIDEN_PIDM AORJPST_EMPR_PIDM AORJPST
SPRIDEN_PIDM FPBAGRH_VEND_PIDM FPBAGRH
SPRIDEN_PIDM GERPART_PIDM GERPART
SPRIDEN_PIDM SMBPOGN_PIDM SMBPOGN
SPRIDEN_PIDM PERHSIP_PIDM PERHSIP
SPRIDEN_PIDM FIRBOND_IMGR_CODE_PIDM FIRBOND
SPRIDEN_PIDM FIRCERD_IMGR_CODE_PIDM FIRCERD
SPRIDEN_PIDM FIRMMKT_IMGR_CODE_PIDM FIRMMKT
SPRIDEN_PIDM FIRPRTY_IMGR_CODE_PIDM FIRPRTY
SPRIDEN_PIDM FIRSTCK_IMGR_CODE_PIDM FIRSTCK
SPRIDEN_PIDM FIRSTOP_IMGR_CODE_PIDM FIRSTOP
SPRIDEN_PIDM SHRLGPA_PIDM SHRLGPA
SPRIDEN_PIDM SPBPERS_PIDM SPBPERS
SPRIDEN_PIDM NBRBJOB_PIDM NBRBJOB
SPRIDEN_PIDM SARADAP_PIDM SARADAP
SPRIDEN_PIDM GLBEXTR_KEY GLBEXTR
SPRIDEN_PIDM FTVCUST_PIDM FTVCUST
SPRIDEN_PIDM TBBCONT_PIDM TBBCONT
SPRIDEN_PIDM TBBCSTU_STU_PIDM TBBCSTU
SPRIDEN_PIDM SFRSTCR_PIDM SFRSTCR
SPRIDEN_PIDM SHRDGMR_PIDM SHRDGMR
SPRIDEN_PIDM RORSTAT_PIDM RORSTAT
SPRIDEN_PIDM APRXREF_XREF_PIDM APRXREF
SPRIDEN_PIDM SFBETRM_PIDM SFBETRM
SPRIDEN_PIDM SRBRECR_PIDM SRBRECR
SPRIDEN_PIDM APRCATG_PIDM APRCATG
SPRIDEN_PIDM PERJOBP_PIDM PERJOBP
SPRIDEN_PIDM AMRINFO_PIDM AMRINFO
SPRIDEN_PIDM SORHSCH_PIDM SORHSCH
SPRIDEN_PIDM SIBINST_PIDM SIBINST
SPRIDEN_PIDM AOBORGN_MG_PIDM AOBORGN
SPRIDEN_PIDM AOBORGN_PIDM AOBORGN
SPRIDEN_PIDM GOBSRVR_PIDM GOBSRVR
SPRIDEN_PIDM SRRRSRC_PIDM SRRRSRC
SPRIDEN_PIDM FABINVH_VEND_PIDM FABINVH
SPRIDEN_PIDM FABINVH_VEND_CHECK_PIDM FABINVH
SPRIDEN_PIDM APRDHIS_PIDM APRDHIS
SPRIDEN_PIDM SLRRMAT_PIDM SLRRMAT
SPRIDEN_PIDM SABSTUD_PIDM SABSTUD
SPRIDEN_PIDM SGRASSI_PIDM SGRASSI
SPRIDEN_PIDM SHTTRAN_PIDM SHTTRAN
SPRIDEN_PIDM APBCONS_PIDM APBCONS
SPRIDEN_PIDM ASRSSAG_PIDM ASRSSAG
SPRIDEN_PIDM SFRENRL_PIDM SFRENRL

Index

Index Name Index Type Column Name
SPRIDEN_INDEX_ID SPRIDEN_ID
SPRIDEN_INDEX_ID SPRIDEN_ENTITY_IND
SPRIDEN_INDEX_ID SPRIDEN_CHANGE_IND
SPRIDEN_INDEX_PERS SPRIDEN_LAST_NAME
SPRIDEN_INDEX_PERS SPRIDEN_FIRST_NAME
SPRIDEN_INDEX_PERS SPRIDEN_MI
SPRIDEN_INDEX_PERS SPRIDEN_ENTITY_IND
SPRIDEN_INDEX_PERS SPRIDEN_CHANGE_IND
SPRIDEN_INDEX_SEARCH SPRIDEN_SEARCH_LAST_NAME
SPRIDEN_INDEX_SEARCH SPRIDEN_SEARCH_FIRST_NAME
SPRIDEN_INDEX_SEARCH SPRIDEN_SEARCH_MI
SPRIDEN_INDEX_SOUNDEX SPRIDEN_SOUNDEX_LAST_NAME
SPRIDEN_INDEX_SOUNDEX SPRIDEN_SOUNDEX_FIRST_NAME
SPRIDEN_KEY_INDEX Unique SPRIDEN_PIDM
SPRIDEN_KEY_INDEX Unique SPRIDEN_ID
SPRIDEN_KEY_INDEX Unique SPRIDEN_LAST_NAME
SPRIDEN_KEY_INDEX Unique SPRIDEN_FIRST_NAME
SPRIDEN_KEY_INDEX Unique SPRIDEN_MI
SPRIDEN_KEY_INDEX Unique SPRIDEN_CHANGE_IND
SPRIDEN_KEY_INDEX Unique SPRIDEN_NTYP_CODE

Comments

Source Code Comments

Person Identification/Name Repeating Table

Impact job : LN_last_name_col New Job

Impact job : SPRIDEN_LAST_NAME New Job

Impacted objects

Object Name Object Type
F_BENEFICIARY_INFO FUNCTION
F_CHILD_INFO FUNCTION
F_CONCAT_SGRADVR FUNCTION
F_FACT_NAME FUNCTION
F_FORMAT_NAME FUNCTION
F_GET_ORDERBY_LAST_NAME FUNCTION
F_GET_SPRIDEN_PREV FUNCTION
F_GIFT_SOLICITOR FUNCTION
F_INSTRUCTOR_FNC FUNCTION
F_INTERVIEWER_NAME FUNCTION
F_JOB_INFO FUNCTION
F_MATCHING_GIFT_COMPANY_NAME FUNCTION
F_ORDER_BY FUNCTION
F_ORDER_BY_LAST FUNCTION
F_PLEDGE_SOLICITOR FUNCTION
F_SECONDARY_CONTACT_NAME FUNCTION
F_SPOUSE_INFO FUNCTION
F_SUPERVISOR_INFO FUNCTION
AA_CAMPAIGN_GIVING_BY_ID VIEW
AA_CONSTITUENT_IDENTIFICATION VIEW
AA_CONSTITUENT_ORGANIZ_SHARED VIEW
AA_DESIGNATION_GIVING_BY_ID VIEW
AA_GIFT_DETAIL VIEW
AA_GIFT_MEMO_DETAIL VIEW
AA_GIVING VIEW
AA_ORGANIZATION VIEW
AA_PLEDGE_DETAIL VIEW
ADVAWRD VIEW
ADVDSG1 VIEW
AFVCMP1 VIEW
AGVGFD1 VIEW
AGVGIV1 VIEW
AGVGMD1 VIEW
AGVMGID VIEW
AGVPLD1 VIEW
AG_ENTITY_DATA VIEW
AG_EVENTS_AND_FUNCTIONS VIEW
ALVADDS VIEW
AMVINFO VIEW
AOVCOMP VIEW
AOVCONT VIEW
AOVIDEN VIEW
AOVORG1 VIEW
AOVORGN VIEW
APVBRWS VIEW
APVCATG VIEW
APVCHLD VIEW
APVCNI1 VIEW
APVCONS VIEW
APVCSLT VIEW
APVCSPS VIEW
APVCTYP VIEW
APVDPRI VIEW
APVEHIS VIEW
APVLRVW VIEW
APVSHR1 VIEW
APVSPRI VIEW
APVSRES VIEW
APVXREF VIEW
AP_DEDUCTIONS_BENEFITS VIEW
AP_EMPLOYEE_PROFILE VIEW
AP_EMPLOYEE_SENIORITY VIEW
AP_EMPLOYMENT_VERIFICATION VIEW
AP_EMPLOY_RECRUITMENT_ACTIVITY VIEW
AP_JOB_SUMMARY VIEW
AR_AWARD_DETAIL_BY_TERM VIEW
AR_AWARD_DETAIL_BY_YEAR VIEW
AR_BUDGET_COMPONENTS VIEW
AR_FINAID_APPLICANT VIEW
AR_FINAID_STUDENT_SUMMARY VIEW
AR_TRACKING_REQUIREMENTS VIEW
ASVASCT VIEW
ASVCAMP VIEW
ASVSORG VIEW
ASVSSAG VIEW
ASVYEAR VIEW
AS_ACADEMIC_HISTORY_DETAIL VIEW
AS_ACADEMIC_HISTORY_SUMMARY VIEW
AS_ADMISSIONS_APPLICANT VIEW
AS_AGING_ANALYSIS VIEW
AS_CATALOG_SCHEDULE VIEW
AS_CLEARED_TO_ATTEND VIEW
AS_FACULTY_DATA VIEW
AS_RECRUITING_DATA VIEW
AS_RECRUITING_SOURCE_ANALYSIS VIEW
AS_RESIDENTIAL_LIFE VIEW
AS_RESIDENTIAL_LIFE_CHANGES VIEW
AS_STUDENT_DATA VIEW
AS_STUDENT_ENROLLMENT_SUMMARY VIEW
AS_STUDENT_REGISTRATION_DETAIL VIEW
AS_THIRD_PARTY_CONTRACTS VIEW
AT_APPLICATION_OF_PAYMENTS_CHG VIEW
AT_APPLICATION_OF_PAYMENTS_PAY VIEW
AT_AR_BALANCE_BY_ENTITY VIEW
AT_DEPOSITS VIEW
AT_INSTALLMENTS VIEW
FAVCARR VIEW
FAVINSE VIEW
FAVVEND VIEW
FAVVNAL VIEW
FAVVNDR VIEW
FCVCUST VIEW
FCVEMPL VIEW
FGVAGCY VIEW
FGVFMGR VIEW
FOVDOCU VIEW
FPVRCPO VIEW
FPVVNPO VIEW
GEVATTD VIEW
GEVEVN1 VIEW
GEVEVN2 VIEW
GLVEXTR VIEW
GOVSRVR VIEW
GOVSVAS VIEW
GOVSVDP VIEW
GOVSVEI VIEW
GOVSVEV VIEW
GOVSVSD VIEW
GPVENT1 VIEW
GUVALTI VIEW
NBVPINC VIEW
PAVAPPL VIEW
PAVREQ1 VIEW
PDVBEN1 VIEW
PDVBENE VIEW
PDVDED1 VIEW
PEVEBRG VIEW
PEVEMPL VIEW
PEVEPRO VIEW
PEVJOB1 VIEW
PEVJPS1 VIEW
PEVJPS2 VIEW
PEVPBRG VIEW
PEVPRF1 VIEW
PEVREVW VIEW
PEVVER1 VIEW
PEVVER2 VIEW
PHVTIME VIEW
RBVBUD1 VIEW
RBVBUD2 VIEW
RCVAPL1 VIEW
RCVAPL2 VIEW
REVRMRR VIEW
ROVCONT VIEW
ROVFINS VIEW
ROVSTU1 VIEW
ROVSTU2 VIEW
ROVSTU3 VIEW
RPVAWT1 VIEW
RPVAWT2 VIEW
RPVAWY1 VIEW
RPVAWY2 VIEW
RRVREQ1 VIEW
SAVADAS1 VIEW
SAVADM1 VIEW
SAVADM2 VIEW
SAVADMT VIEW
SAVAMC2 VIEW
SAVAMCD VIEW
SAVAMCT VIEW
SAVHEAD VIEW
SAVLIF1 VIEW
SAVLIFE VIEW
SAVPCO1 VIEW
SAVSEC1 VIEW
SAVSGEO VIEW
SEVSSER VIEW
SFVENRL VIEW
SFVETR1 VIEW
SFVETR2 VIEW
SFVRCRS VIEW
SFVSTC1 VIEW
SFVSTC2 VIEW
SFVSTMS VIEW
SFVTFAN VIEW
SGVASSI VIEW
SGVSTD1 VIEW
SGVSTD2 VIEW
SGVSTDN VIEW
SGVSTEN VIEW
SGVSTHD VIEW
SGVSTNE VIEW
SHVACST VIEW
SHVAWRD VIEW
SHVCOMI VIEW
SHVCOMM VIEW
SHVDEAN VIEW
SHVDTL1 VIEW
SHVDTL2 VIEW
SHVEDIS VIEW
SHVGCOL VIEW
SHVPEND VIEW
SHVSEEK VIEW
SHVSUM1 VIEW
SHVSUM2 VIEW
SHVTER1 VIEW
SHVTERM VIEW
SHVTRAN VIEW
SHVTRE1 VIEW
SHVYEA1 VIEW
SHVYEAR VIEW
SIVFAC1 VIEW
SIVFAC2 VIEW
SIVFACL VIEW
SIVFACQ VIEW
SIVINST VIEW
SLVRES1 VIEW
SLVRES2 VIEW
SLVRMAT VIEW
SLVRSM2 VIEW
SLVRUSE VIEW
SMVRQCM VIEW
SMVSLIB VIEW
SOVAGI1 VIEW
SOVAINF VIEW
SOVAROL VIEW
SOVCTA1 VIEW
SOVCTA2 VIEW
SOVCURR VIEW
SOVEIDN VIEW
SOVGEOR VIEW
SOVPCUR VIEW
SOVTPC1 VIEW
SPRIDEN_V2 VIEW
SPVADDF VIEW
SPVADDR VIEW
SPVADDS VIEW
SPVCURR VIEW
SPVLIFE VIEW
SPVPCOL VIEW
SPVPERS VIEW
SPVPVID VIEW
SPVPVNM VIEW
SPVSECS VIEW
SPVTER1 VIEW
SPVTERM VIEW
SPVYEA1 VIEW
SPVYEAR VIEW
SRVLIF1 VIEW
SRVLIFE VIEW
SRVPCO1 VIEW
SRVRCR1 VIEW
SRVRECR VIEW
SRVRSR1 VIEW
SRVSEC1 VIEW
SSVSEC2 VIEW
TBVACC1 VIEW
TBVAGES VIEW
TBVCOLC VIEW
TBVCSTU VIEW
TBVESTU VIEW
TBVTPCN VIEW
TOVAPC1 VIEW
TOVAPP1 VIEW
TOVDEP1 VIEW
TOVINS1 VIEW
TOVINS2 VIEW
ADVR_REC Package Type
AMRPLAN_SEARCH_TYPE Package Type
ASSIGN_TYPE Package Type
BIO_DATA Package Type
COMMENTS_RECTYPE Package Type
COMMENTS_RECTYPE Package Type
COMP_TYPE Package Type
CONTACT_TYPE Package Type
CONTACT_TYPE Package Type
CONTACT_TYPE Package Type
EMP_TYPE Package Type
GOBEACC_TYPE Package Type
HISTORY_RECTYPE Package Type
HISTORY_RECTYPE Package Type
ID_NAME_RECORD Package Type
INPUT_DATA Package Type
JPST_TYPE Package Type
LOAN_GUAR_TYPE Package Type
LOAN_LENDER_TYPE Package Type
ORG_TYPE Package Type
PREV_TYPE Package Type
PROSPECT_TYPE Package Type
PROSPECT_TYPE Package Type
REC_RESULTSET Package Type
ROUTING_RECTYPE Package Type
ROUTING_RECTYPE Package Type
R_RESULTSET Package Type
SRCH_TYPE Package Type
SRCH_TYPE Package Type
SRCH_TYPE Package Type
STUDENT_LIST_TYP Package Type
TIME_LIST_RECTYPE Package Type
TIME_RECTYPE Package Type
TIME_RECTYPE Package Type
F_FORMAT_NAME Package function
P_COMPARE_CURRENT_ACT_SITE Package procedure
P_COMPARE_CURRENT_DEP Package procedure
P_COMPARE_CURRENT_EMP_INFO Package procedure
P_COMPARE_CURRENT_EV Package procedure
P_COMPARE_CURRENT_STU Package procedure
P_CREATE_EV_ROW Package procedure
P_CREATE_STU_ROW Package procedure
P_FIND_MATCHING_PERSON Package procedure
P_GET_BIOGRAPHIC_DATA Package procedure
P_GET_EMPL_INFO Package procedure
P_GET_PAF_POSN_INFO Package procedure
P_GET_SPRIDEN Package procedure
P_GET_SPRIDEN Package procedure
P_LOAD_SPRIDEN Package procedure
P_SELECT_GOVSVAS Package procedure
P_SELECT_GOVSVDP Package procedure
P_SELECT_GOVSVEI Package procedure
P_SELECT_GOVSVEV Package procedure
P_SELECT_GOVSVSD Package procedure
P_SEND_UPD_PERSON_IDEN Package procedure
P_SPRIDENINSERT Package procedure
P_SPRIDENUPDATE Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_VALIDATE_EV_REQ_FIELDS Package procedure
P_VALIDATE_STUDENT_ID Package procedure
P_VALIDATE_STU_REQ_FIELDS Package procedure
AMRPLAN_SEARCH_REC Package variable
AMVINFO_REC Package variable
AMVINFO_REC Package variable
AORJPST_REC Package variable
ASSIGN_REC Package variable
AS_ADMISSIONS_APPLICANT_REC Package variable
AS_RECRUITING_DATA_REC Package variable
AS_STUDENT_DATA_REC Package variable
COMPANY_REC Package variable
COMP_REC Package variable
CONIDEN_REC Package variable
CONTACT_REC Package variable
CONTACT_REC Package variable
CONTACT_REC Package variable
EMPLOYER_REC Package variable
GLVEXTR_REC Package variable
GOBEACC_REC Package variable
PREV_SPRIDEN_REC Package variable
PROSPECT_REC Package variable
PROSPECT_REC Package variable
SHVTRE1_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SRCH_REC Package variable
SRCH_REC Package variable
V_RESSET Package variable
V_RESULTSET Package variable
CONF_IND_BLOCK_QUERY Forms Function
DEAD_IND_BLOCK_QUERY Forms Function
F_GET_NAME Forms Function
F_GET_NAME Forms Function
F_GET_NAME Forms Function
F_GET_NAME Forms Function
GET_AIDM Forms Function
SELECT_ADVAWRD_TEST Forms Function
SELECT_ADVAWRD_TEST Forms Function
SELECT_SHVEDIS_1 Forms Function
SELECT_TBVCSTU_14 Forms Function
SELECT_TBVCSTU_7 Forms Function
SELECT_TBVCSTU_8 Forms Function
A$_SEL_ID_INFO Forms Procedure
A$_SEL_ID_PERS_INFO Forms Procedure
SEL_ID_ORG_INFO Forms Procedure
SEL_ID_ORG_INFO Forms Procedure
SEL_ID_ORG_INFO Forms Procedure
SEL_ID_ORG_INFO Forms Procedure
SEL_ORG_INFO Forms Procedure
SET_ROUTE_STAT Forms Procedure
GUEST_INFO_NAV_OPTION Forms Trigger
POPULATE_PERROUT_BLOCK_INFO Forms Trigger
RECS_EXIST Forms Trigger
REFRESH_REC Forms Trigger
SET_CATG Forms Trigger
SUMMARY_INFO1 Forms Trigger
SUMMARY_INFO2 Forms Trigger
SUMMARY_INFO_NO_ORGN Forms Trigger
ADVAWRD Forms DataBlock
ADVAWRD Forms DataBlock
AOVCOMP Forms DataBlock
AOVCONT Forms DataBlock
APVBRWS Forms DataBlock
APVCTYP Forms DataBlock
APVCTYP Forms DataBlock
APVCTYP_DETAIL Forms DataBlock
APVCTYP_DETAIL Forms DataBlock
APVCTYP_DETAIL Forms DataBlock
APVLRVW Forms DataBlock
ASVASCT Forms DataBlock
ASVCAMP Forms DataBlock
ASVSSAG Forms DataBlock
ASVYEAR Forms DataBlock
AS_STUDENT_DATA Forms DataBlock
FAVVEND Forms DataBlock
FCVCUST Forms DataBlock
FCVEMPL Forms DataBlock
FOVDOCU Forms DataBlock
FTVCARD Forms DataBlock
GEVATTD Forms DataBlock
GLVEXTR Forms DataBlock
GOVSRVR Forms DataBlock
GUVALTI Forms DataBlock
NBVPINC Forms DataBlock
PEBEMPL Forms DataBlock
PERASGN Forms DataBlock
PERDEMO Forms DataBlock
PERJOBI Forms DataBlock
PERROUT Forms DataBlock
PEVEBRG Forms DataBlock
PEVEPRO Forms DataBlock
PEVPBRG Forms DataBlock
PEVPCSN Forms DataBlock
PHVTIME Forms DataBlock
PHVTIME Forms DataBlock
PHVTIME Forms DataBlock
PXRASCC Forms DataBlock
PXRASCF Forms DataBlock
PXRASCP Forms DataBlock
REVRMRR Forms DataBlock
SEVSSER Forms DataBlock
SFRENRL Forms DataBlock
SFVENRL Forms DataBlock
SFVSTMS Forms DataBlock
SGVASSI Forms DataBlock
SHVACST Forms DataBlock
SHVCOMI Forms DataBlock
SHVCOMI Forms DataBlock
SHVCOMM Forms DataBlock
SHVCOMM Forms DataBlock
SHVCOMM Forms DataBlock
SHVDEAN Forms DataBlock
SHVEDIS Forms DataBlock
SHVGCOL Forms DataBlock
SHVGCOL_2 Forms DataBlock
SIVFACQ Forms DataBlock
SIVFACQ Forms DataBlock
SIVINST Forms DataBlock
SIVINST Forms DataBlock
SLRVMAT Forms DataBlock
SLVRUSE Forms DataBlock
SMVRQCM Forms DataBlock
SMVSLIB Forms DataBlock
SMVSLIB Forms DataBlock
SOVAINF Forms DataBlock
SOVAROL Forms DataBlock
SOVEIDN Forms DataBlock
SOVGEOR Forms DataBlock
SPVADDS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
TBVACC1 Forms DataBlock
TBVCOLC Forms DataBlock
TBVCSTU Forms DataBlock
TBVCSTU2 Forms DataBlock
TBVESTU Forms DataBlock
CHECK_DUPLICATES Forms Trigger
CHECK_DUPLICATES Forms Trigger
CHECK_KEYS Forms Trigger
CHECK_TERM_CODE Forms Trigger
DENY_DOC Forms Trigger
FTE_TOTAL Forms Trigger
GET_DONR_CODE Forms Trigger
GET_DONR_CODE Forms Trigger
KEY-DELREC Forms Trigger
ON-CHECK-DELETE-MASTER Forms Trigger
POPSEL_NXTBLK Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST_QUERY_ORIG Forms Trigger
GET_MATCH_ID Forms Trigger
KEY-CQUERY Forms Trigger
KEY-CQUERY Forms Trigger
POST-CHANGE Forms Trigger
POST-CHANGE Forms Trigger
POST-CHANGE Forms Trigger
POST_CHANGE Forms Trigger
WHEN-VALIDATE-ITEM Forms Trigger
WHEN-VALIDATE-ITEM Forms Trigger
WHEN-VALIDATE-ITEM Forms Trigger
ADVAWRD_RG Forms Record Group
ASVSORG_SOL_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
ROVCONT_RG Forms Record Group
ROVCONT_RG Forms Record Group
ROVCONT_RG Forms Record Group
SHVTRAN_RG Forms Record Group
SHVTRAN_RG Forms Record Group
SOVEIDN_RG Forms Record Group
rerpell.pc C/C++ File
rprelap.pc C/C++ File
smrbcmp.pc C/C++ File
sel_stud_addr C/C++ Function
select_address C/C++ Function
select_address C/C++ Function
all_camp_no_orgs_cons C/C++ Function
all_camp_orgs_cons C/C++ Function
all_sol_orgs C/C++ Function
all_year_orgs C/C++ Function
camp_null_org_info C/C++ Function
camp_orgs C/C++ Function
get_addr_ind C/C++ Function
get_addr_ind C/C++ Function
get_address C/C++ Function
get_address C/C++ Function
get_apvcslt C/C++ Function
get_asvssag C/C++ Function
get_camp_contacts C/C++ Function
get_fpvvnpo C/C++ Function
get_no_org_con C/C++ Function
get_rec C/C++ Function
get_tape_info C/C++ Function
get_year_contacts C/C++ Function
getaddr C/C++ Function
getaddr C/C++ Function
getaddr C/C++ Function
sb_get_collector_pidms C/C++ Function
sb_get_etrm_pidms C/C++ Function
sb_get_pop_pidms C/C++ Function
sb_pidmaddr C/C++ Function
sel_addr C/C++ Function
sel_address C/C++ Function
sel_address C/C++ Function
sel_address C/C++ Function
sel_fund C/C++ Function
sel_invoice C/C++ Function
sel_mass_order_zip_id C/C++ Function
sel_mass_order_zip_id C/C++ Function
sel_mass_order_zip_id_popsel C/C++ Function
sel_mass_order_zip_id_popsel C/C++ Function
sel_mass_order_zip_name C/C++ Function
sel_mass_order_zip_name C/C++ Function
sel_mass_order_zip_name_popsel C/C++ Function
sel_mass_order_zip_name_popsel C/C++ Function
sel_phone_num C/C++ Function
sel_po C/C++ Function
sel_sivfacq C/C++ Function
sel_stud_addr C/C++ Function
sel_vendor C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
selall C/C++ Function
selapplicant C/C++ Function
selbasegift C/C++ Function
selbasegift_pop C/C++ Function
selclassmacro C/C++ Function
selclassmacro C/C++ Function
selclassmacro_pop C/C++ Function
selclassmacro_pop C/C++ Function
selcntplg C/C++ Function
selcolr C/C++ Function
selcolr C/C++ Function
selcolr1 C/C++ Function
selcolr1 C/C++ Function
selcolr1_1 C/C++ Function
selcolr1_1 C/C++ Function
selcolr1_2 C/C++ Function
selcolr1_2 C/C++ Function
selcolr1_3 C/C++ Function
selcolr1_3 C/C++ Function
selcolr_1 C/C++ Function
selcolr_1 C/C++ Function
selcolr_2 C/C++ Function
selcolr_2 C/C++ Function
selcolr_3 C/C++ Function
selcolr_3 C/C++ Function
selcomb_name C/C++ Function
selcomb_zip C/C++ Function
selcons_name C/C++ Function
selcons_zip C/C++ Function
selcont C/C++ Function
selcont C/C++ Function
seldonrcatg C/C++ Function
select_from_saturn_spvadds C/C++ Function
selgrp C/C++ Function
selgrp C/C++ Function
selid C/C++ Function
selid_nopop C/C++ Function
seliden C/C++ Function
selinclall C/C++ Function
selinclmemo C/C++ Function
selinclmgcr C/C++ Function
sellyball C/C++ Function
sellybcnt C/C++ Function
sellybplg C/C++ Function
selmacro C/C++ Function
selmass C/C++ Function
selmass_nopop C/C++ Function
selname C/C++ Function
selnamemacro C/C++ Function
selnamemacro C/C++ Function
selnamemacro_pop C/C++ Function
selnamemacro_pop C/C++ Function
selnew C/C++ Function
selpers_addr2 C/C++ Function
selpers_addr2 C/C++ Function
selpers_addr2 C/C++ Function
selpers_addr2 C/C++ Function
selrenewed C/C++ Function
selroom C/C++ Function
selroom_nopop C/C++ Function
selspvadds C/C++ Function
selspvadds C/C++ Function
sol_orgs C/C++ Function
valid_rater C/C++ Function
year_driver C/C++ Function
year_orgs C/C++ Function
D00-PROCESS-GLRVFRM Cobol Section
D00A-FETCH-GLRVFRM Cobol Section
D00B-PROCESS-GLRSFRM Cobol Section
D00C-FETCH-GLRSFRM Cobol Section
D03-PROCESS-PARMS Cobol Section
D04F-STORE-ON-CHAIN Cobol Section
D05-PROCESS-SPVADDS-RTN Cobol Section
D06A-PROCESS-SPVADDS-DATA Cobol Section
E01-PROCESS-ORDER Cobol Section
E03-GET-GLRCMPL Cobol Section
E04-FETCH-STATEMENT Cobol Section
E05-PROCESS-SPVADDS-STATEMENT Cobol Section
E05A-PROCESS-SPVADDS Cobol Section
P17-STRING-GURMAIL Cobol Section
S01-BUILD-SPVADDS Cobol Section
S02-PROCESS-SPVADDS Cobol Section
S03-PROCESS-CONT Cobol Section
S03A-BUILD-SPVADDS-STRING Cobol Section
S05-SPVADDS-APPL-RULES Cobol Section
Y00-GET-CREATOR Cobol Section

Impact job : spriden_last_name3 New Job

Impacted objects

Object Name Object Type
F_BENEFICIARY_INFO FUNCTION
F_CHILD_INFO FUNCTION
F_CONCAT_SGRADVR FUNCTION
F_FACT_NAME FUNCTION
F_FORMAT_NAME FUNCTION
F_GET_ORDERBY_LAST_NAME FUNCTION
F_GET_SPRIDEN_PREV FUNCTION
F_GIFT_SOLICITOR FUNCTION
F_INSTRUCTOR_FNC FUNCTION
F_INTERVIEWER_NAME FUNCTION
F_JOB_INFO FUNCTION
F_MATCHING_GIFT_COMPANY_NAME FUNCTION
F_ORDER_BY FUNCTION
F_ORDER_BY_LAST FUNCTION
F_PLEDGE_SOLICITOR FUNCTION
F_SECONDARY_CONTACT_NAME FUNCTION
F_SPOUSE_INFO FUNCTION
F_SUPERVISOR_INFO FUNCTION
AA_CAMPAIGN_GIVING_BY_ID VIEW
AA_CONSTITUENT_IDENTIFICATION VIEW
AA_CONSTITUENT_ORGANIZ_SHARED VIEW
AA_DESIGNATION_GIVING_BY_ID VIEW
AA_GIFT_DETAIL VIEW
AA_GIFT_MEMO_DETAIL VIEW
AA_GIVING VIEW
AA_ORGANIZATION VIEW
AA_PLEDGE_DETAIL VIEW
ADVAWRD VIEW
ADVDSG1 VIEW
AFVCMP1 VIEW
AGVGFD1 VIEW
AGVGIV1 VIEW
AGVGMD1 VIEW
AGVMGID VIEW
AGVPLD1 VIEW
AG_ENTITY_DATA VIEW
AG_EVENTS_AND_FUNCTIONS VIEW
ALVADDS VIEW
AMVINFO VIEW
AOVCOMP VIEW
AOVCONT VIEW
AOVIDEN VIEW
AOVORG1 VIEW
AOVORGN VIEW
APVBRWS VIEW
APVCATG VIEW
APVCHLD VIEW
APVCNI1 VIEW
APVCONS VIEW
APVCSLT VIEW
APVCSPS VIEW
APVCTYP VIEW
APVDPRI VIEW
APVEHIS VIEW
APVLRVW VIEW
APVSHR1 VIEW
APVSPRI VIEW
APVSRES VIEW
APVXREF VIEW
AP_DEDUCTIONS_BENEFITS VIEW
AP_EMPLOYEE_PROFILE VIEW
AP_EMPLOYEE_SENIORITY VIEW
AP_EMPLOYMENT_VERIFICATION VIEW
AP_EMPLOY_RECRUITMENT_ACTIVITY VIEW
AP_JOB_SUMMARY VIEW
AR_AWARD_DETAIL_BY_TERM VIEW
AR_AWARD_DETAIL_BY_YEAR VIEW
AR_BUDGET_COMPONENTS VIEW
AR_FINAID_APPLICANT VIEW
AR_FINAID_STUDENT_SUMMARY VIEW
AR_TRACKING_REQUIREMENTS VIEW
ASVASCT VIEW
ASVCAMP VIEW
ASVSORG VIEW
ASVSSAG VIEW
ASVYEAR VIEW
AS_ACADEMIC_HISTORY_DETAIL VIEW
AS_ACADEMIC_HISTORY_SUMMARY VIEW
AS_ADMISSIONS_APPLICANT VIEW
AS_AGING_ANALYSIS VIEW
AS_CATALOG_SCHEDULE VIEW
AS_CLEARED_TO_ATTEND VIEW
AS_FACULTY_DATA VIEW
AS_RECRUITING_DATA VIEW
AS_RECRUITING_SOURCE_ANALYSIS VIEW
AS_RESIDENTIAL_LIFE VIEW
AS_RESIDENTIAL_LIFE_CHANGES VIEW
AS_STUDENT_DATA VIEW
AS_STUDENT_ENROLLMENT_SUMMARY VIEW
AS_STUDENT_REGISTRATION_DETAIL VIEW
AS_THIRD_PARTY_CONTRACTS VIEW
AT_APPLICATION_OF_PAYMENTS_CHG VIEW
AT_APPLICATION_OF_PAYMENTS_PAY VIEW
AT_AR_BALANCE_BY_ENTITY VIEW
AT_DEPOSITS VIEW
AT_INSTALLMENTS VIEW
FAVCARR VIEW
FAVINSE VIEW
FAVVEND VIEW
FAVVNAL VIEW
FAVVNDR VIEW
FCVCUST VIEW
FCVEMPL VIEW
FGVAGCY VIEW
FGVFMGR VIEW
FOVDOCU VIEW
FPVRCPO VIEW
FPVVNPO VIEW
GEVATTD VIEW
GEVEVN1 VIEW
GEVEVN2 VIEW
GLVEXTR VIEW
GOVSRVR VIEW
GOVSVAS VIEW
GOVSVDP VIEW
GOVSVEI VIEW
GOVSVEV VIEW
GOVSVSD VIEW
GPVENT1 VIEW
GUVALTI VIEW
NBVPINC VIEW
PAVAPPL VIEW
PAVREQ1 VIEW
PDVBEN1 VIEW
PDVBENE VIEW
PDVDED1 VIEW
PEVEBRG VIEW
PEVEMPL VIEW
PEVEPRO VIEW
PEVJOB1 VIEW
PEVJPS1 VIEW
PEVJPS2 VIEW
PEVPBRG VIEW
PEVPRF1 VIEW
PEVREVW VIEW
PEVVER1 VIEW
PEVVER2 VIEW
PHVTIME VIEW
RBVBUD1 VIEW
RBVBUD2 VIEW
RCVAPL1 VIEW
RCVAPL2 VIEW
REVRMRR VIEW
ROVCONT VIEW
ROVFINS VIEW
ROVSTU1 VIEW
ROVSTU2 VIEW
ROVSTU3 VIEW
RPVAWT1 VIEW
RPVAWT2 VIEW
RPVAWY1 VIEW
RPVAWY2 VIEW
RRVREQ1 VIEW
SAVADAS1 VIEW
SAVADM1 VIEW
SAVADM2 VIEW
SAVADMT VIEW
SAVAMC2 VIEW
SAVAMCD VIEW
SAVAMCT VIEW
SAVHEAD VIEW
SAVLIF1 VIEW
SAVLIFE VIEW
SAVPCO1 VIEW
SAVSEC1 VIEW
SAVSGEO VIEW
SEVSSER VIEW
SFVENRL VIEW
SFVETR1 VIEW
SFVETR2 VIEW
SFVRCRS VIEW
SFVSTC1 VIEW
SFVSTC2 VIEW
SFVSTMS VIEW
SFVTFAN VIEW
SGVASSI VIEW
SGVSTD1 VIEW
SGVSTD2 VIEW
SGVSTDN VIEW
SGVSTEN VIEW
SGVSTHD VIEW
SGVSTNE VIEW
SHVACST VIEW
SHVAWRD VIEW
SHVCOMI VIEW
SHVCOMM VIEW
SHVDEAN VIEW
SHVDTL1 VIEW
SHVDTL2 VIEW
SHVEDIS VIEW
SHVGCOL VIEW
SHVPEND VIEW
SHVSEEK VIEW
SHVSUM1 VIEW
SHVSUM2 VIEW
SHVTER1 VIEW
SHVTERM VIEW
SHVTRAN VIEW
SHVTRE1 VIEW
SHVYEA1 VIEW
SHVYEAR VIEW
SIVFAC1 VIEW
SIVFAC2 VIEW
SIVFACL VIEW
SIVFACQ VIEW
SIVINST VIEW
SLVRES1 VIEW
SLVRES2 VIEW
SLVRMAT VIEW
SLVRSM2 VIEW
SLVRUSE VIEW
SMVRQCM VIEW
SMVSLIB VIEW
SOVAGI1 VIEW
SOVAINF VIEW
SOVAROL VIEW
SOVCTA1 VIEW
SOVCTA2 VIEW
SOVCURR VIEW
SOVEIDN VIEW
SOVGEOR VIEW
SOVPCUR VIEW
SOVTPC1 VIEW
SPRIDEN_V2 VIEW
SPVADDF VIEW
SPVADDR VIEW
SPVADDS VIEW
SPVCURR VIEW
SPVLIFE VIEW
SPVPCOL VIEW
SPVPERS VIEW
SPVPVID VIEW
SPVPVNM VIEW
SPVSECS VIEW
SPVTER1 VIEW
SPVTERM VIEW
SPVYEA1 VIEW
SPVYEAR VIEW
SRVLIF1 VIEW
SRVLIFE VIEW
SRVPCO1 VIEW
SRVRCR1 VIEW
SRVRECR VIEW
SRVRSR1 VIEW
SRVSEC1 VIEW
SSVSEC2 VIEW
TBVACC1 VIEW
TBVAGES VIEW
TBVCOLC VIEW
TBVCSTU VIEW
TBVESTU VIEW
TBVTPCN VIEW
TOVAPC1 VIEW
TOVAPP1 VIEW
TOVDEP1 VIEW
TOVINS1 VIEW
TOVINS2 VIEW
ADVR_REC Package Type
AMRPLAN_SEARCH_TYPE Package Type
ASSIGN_TYPE Package Type
BIO_DATA Package Type
COMMENTS_RECTYPE Package Type
COMMENTS_RECTYPE Package Type
COMP_TYPE Package Type
CONTACT_TYPE Package Type
CONTACT_TYPE Package Type
CONTACT_TYPE Package Type
EMP_TYPE Package Type
GOBEACC_TYPE Package Type
HISTORY_RECTYPE Package Type
HISTORY_RECTYPE Package Type
ID_NAME_RECORD Package Type
INPUT_DATA Package Type
JPST_TYPE Package Type
LOAN_GUAR_TYPE Package Type
LOAN_LENDER_TYPE Package Type
ORG_TYPE Package Type
PREV_TYPE Package Type
PROSPECT_TYPE Package Type
PROSPECT_TYPE Package Type
REC_RESULTSET Package Type
ROUTING_RECTYPE Package Type
ROUTING_RECTYPE Package Type
R_RESULTSET Package Type
SRCH_TYPE Package Type
SRCH_TYPE Package Type
SRCH_TYPE Package Type
STUDENT_LIST_TYP Package Type
TIME_LIST_RECTYPE Package Type
TIME_RECTYPE Package Type
TIME_RECTYPE Package Type
F_FORMAT_NAME Package function
P_COMPARE_CURRENT_ACT_SITE Package procedure
P_COMPARE_CURRENT_DEP Package procedure
P_COMPARE_CURRENT_EMP_INFO Package procedure
P_COMPARE_CURRENT_EV Package procedure
P_COMPARE_CURRENT_STU Package procedure
P_CREATE_EV_ROW Package procedure
P_CREATE_STU_ROW Package procedure
P_FIND_MATCHING_PERSON Package procedure
P_GET_BIOGRAPHIC_DATA Package procedure
P_GET_EMPL_INFO Package procedure
P_GET_PAF_POSN_INFO Package procedure
P_GET_SPRIDEN Package procedure
P_GET_SPRIDEN Package procedure
P_LOAD_SPRIDEN Package procedure
P_SELECT_GOVSVAS Package procedure
P_SELECT_GOVSVDP Package procedure
P_SELECT_GOVSVEI Package procedure
P_SELECT_GOVSVEV Package procedure
P_SELECT_GOVSVSD Package procedure
P_SEND_UPD_PERSON_IDEN Package procedure
P_SPRIDENINSERT Package procedure
P_SPRIDENUPDATE Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AIR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_SPRIDEN_AUR Package procedure
P_VALIDATE_EV_REQ_FIELDS Package procedure
P_VALIDATE_STUDENT_ID Package procedure
P_VALIDATE_STU_REQ_FIELDS Package procedure
AMRPLAN_SEARCH_REC Package variable
AMVINFO_REC Package variable
AMVINFO_REC Package variable
AORJPST_REC Package variable
ASSIGN_REC Package variable
AS_ADMISSIONS_APPLICANT_REC Package variable
AS_RECRUITING_DATA_REC Package variable
AS_STUDENT_DATA_REC Package variable
COMPANY_REC Package variable
COMP_REC Package variable
CONIDEN_REC Package variable
CONTACT_REC Package variable
CONTACT_REC Package variable
CONTACT_REC Package variable
EMPLOYER_REC Package variable
GLVEXTR_REC Package variable
GOBEACC_REC Package variable
PREV_SPRIDEN_REC Package variable
PROSPECT_REC Package variable
PROSPECT_REC Package variable
SHVTRE1_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SPRIDEN_REC Package variable
SRCH_REC Package variable
SRCH_REC Package variable
V_RESSET Package variable
V_RESULTSET Package variable
CONF_IND_BLOCK_QUERY Forms Function
DEAD_IND_BLOCK_QUERY Forms Function
F_GET_NAME Forms Function
F_GET_NAME Forms Function
F_GET_NAME Forms Function
F_GET_NAME Forms Function
GET_AIDM Forms Function
SELECT_ADVAWRD_TEST Forms Function
SELECT_ADVAWRD_TEST Forms Function
SELECT_SHVEDIS_1 Forms Function
SELECT_TBVCSTU_14 Forms Function
SELECT_TBVCSTU_7 Forms Function
SELECT_TBVCSTU_8 Forms Function
A$_SEL_ID_INFO Forms Procedure
A$_SEL_ID_PERS_INFO Forms Procedure
SEL_ID_ORG_INFO Forms Procedure
SEL_ID_ORG_INFO Forms Procedure
SEL_ID_ORG_INFO Forms Procedure
SEL_ID_ORG_INFO Forms Procedure
SEL_ORG_INFO Forms Procedure
SET_ROUTE_STAT Forms Procedure
GUEST_INFO_NAV_OPTION Forms Trigger
POPULATE_PERROUT_BLOCK_INFO Forms Trigger
RECS_EXIST Forms Trigger
REFRESH_REC Forms Trigger
SET_CATG Forms Trigger
SUMMARY_INFO1 Forms Trigger
SUMMARY_INFO2 Forms Trigger
SUMMARY_INFO_NO_ORGN Forms Trigger
ADVAWRD Forms DataBlock
ADVAWRD Forms DataBlock
AOVCOMP Forms DataBlock
AOVCONT Forms DataBlock
APVBRWS Forms DataBlock
APVCTYP Forms DataBlock
APVCTYP Forms DataBlock
APVCTYP_DETAIL Forms DataBlock
APVCTYP_DETAIL Forms DataBlock
APVCTYP_DETAIL Forms DataBlock
APVLRVW Forms DataBlock
ASVASCT Forms DataBlock
ASVCAMP Forms DataBlock
ASVSSAG Forms DataBlock
ASVYEAR Forms DataBlock
AS_STUDENT_DATA Forms DataBlock
FAVVEND Forms DataBlock
FCVCUST Forms DataBlock
FCVEMPL Forms DataBlock
FOVDOCU Forms DataBlock
FTVCARD Forms DataBlock
GEVATTD Forms DataBlock
GLVEXTR Forms DataBlock
GOVSRVR Forms DataBlock
GUVALTI Forms DataBlock
NBVPINC Forms DataBlock
PEBEMPL Forms DataBlock
PERASGN Forms DataBlock
PERDEMO Forms DataBlock
PERJOBI Forms DataBlock
PERROUT Forms DataBlock
PEVEBRG Forms DataBlock
PEVEPRO Forms DataBlock
PEVPBRG Forms DataBlock
PEVPCSN Forms DataBlock
PHVTIME Forms DataBlock
PHVTIME Forms DataBlock
PHVTIME Forms DataBlock
PXRASCC Forms DataBlock
PXRASCF Forms DataBlock
PXRASCP Forms DataBlock
REVRMRR Forms DataBlock
SEVSSER Forms DataBlock
SFRENRL Forms DataBlock
SFVENRL Forms DataBlock
SFVSTMS Forms DataBlock
SGVASSI Forms DataBlock
SHVACST Forms DataBlock
SHVCOMI Forms DataBlock
SHVCOMI Forms DataBlock
SHVCOMM Forms DataBlock
SHVCOMM Forms DataBlock
SHVCOMM Forms DataBlock
SHVDEAN Forms DataBlock
SHVEDIS Forms DataBlock
SHVGCOL Forms DataBlock
SHVGCOL_2 Forms DataBlock
SIVFACQ Forms DataBlock
SIVFACQ Forms DataBlock
SIVINST Forms DataBlock
SIVINST Forms DataBlock
SLRVMAT Forms DataBlock
SLVRUSE Forms DataBlock
SMVRQCM Forms DataBlock
SMVSLIB Forms DataBlock
SMVSLIB Forms DataBlock
SOVAINF Forms DataBlock
SOVAROL Forms DataBlock
SOVEIDN Forms DataBlock
SOVGEOR Forms DataBlock
SPVADDS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
TBVACC1 Forms DataBlock
TBVCOLC Forms DataBlock
TBVCSTU Forms DataBlock
TBVCSTU2 Forms DataBlock
TBVESTU Forms DataBlock
CHECK_DUPLICATES Forms Trigger
CHECK_DUPLICATES Forms Trigger
CHECK_KEYS Forms Trigger
CHECK_TERM_CODE Forms Trigger
DENY_DOC Forms Trigger
FTE_TOTAL Forms Trigger
GET_DONR_CODE Forms Trigger
GET_DONR_CODE Forms Trigger
KEY-DELREC Forms Trigger
ON-CHECK-DELETE-MASTER Forms Trigger
POPSEL_NXTBLK Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST-QUERY Forms Trigger
POST_QUERY_ORIG Forms Trigger
GET_MATCH_ID Forms Trigger
KEY-CQUERY Forms Trigger
KEY-CQUERY Forms Trigger
POST-CHANGE Forms Trigger
POST-CHANGE Forms Trigger
POST-CHANGE Forms Trigger
POST_CHANGE Forms Trigger
WHEN-VALIDATE-ITEM Forms Trigger
WHEN-VALIDATE-ITEM Forms Trigger
WHEN-VALIDATE-ITEM Forms Trigger
ADVAWRD_RG Forms Record Group
ASVSORG_SOL_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCARR_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
FTVCUST_RG Forms Record Group
ROVCONT_RG Forms Record Group
ROVCONT_RG Forms Record Group
ROVCONT_RG Forms Record Group
SHVTRAN_RG Forms Record Group
SHVTRAN_RG Forms Record Group
SOVEIDN_RG Forms Record Group
rerpell.pc C/C++ File
rprelap.pc C/C++ File
smrbcmp.pc C/C++ File
sel_stud_addr C/C++ Function
select_address C/C++ Function
select_address C/C++ Function
all_camp_no_orgs_cons C/C++ Function
all_camp_orgs_cons C/C++ Function
all_sol_orgs C/C++ Function
all_year_orgs C/C++ Function
camp_null_org_info C/C++ Function
camp_orgs C/C++ Function
get_addr_ind C/C++ Function
get_addr_ind C/C++ Function
get_address C/C++ Function
get_address C/C++ Function
get_apvcslt C/C++ Function
get_asvssag C/C++ Function
get_camp_contacts C/C++ Function
get_fpvvnpo C/C++ Function
get_no_org_con C/C++ Function
get_rec C/C++ Function
get_tape_info C/C++ Function
get_year_contacts C/C++ Function
getaddr C/C++ Function
getaddr C/C++ Function
getaddr C/C++ Function
sb_get_collector_pidms C/C++ Function
sb_get_etrm_pidms C/C++ Function
sb_get_pop_pidms C/C++ Function
sb_pidmaddr C/C++ Function
sel_addr C/C++ Function
sel_address C/C++ Function
sel_address C/C++ Function
sel_address C/C++ Function
sel_fund C/C++ Function
sel_invoice C/C++ Function
sel_mass_order_zip_id C/C++ Function
sel_mass_order_zip_id C/C++ Function
sel_mass_order_zip_id_popsel C/C++ Function
sel_mass_order_zip_id_popsel C/C++ Function
sel_mass_order_zip_name C/C++ Function
sel_mass_order_zip_name C/C++ Function
sel_mass_order_zip_name_popsel C/C++ Function
sel_mass_order_zip_name_popsel C/C++ Function
sel_phone_num C/C++ Function
sel_po C/C++ Function
sel_sivfacq C/C++ Function
sel_stud_addr C/C++ Function
sel_vendor C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
seladdr C/C++ Function
selall C/C++ Function
selapplicant C/C++ Function
selbasegift C/C++ Function
selbasegift_pop C/C++ Function
selclassmacro C/C++ Function
selclassmacro C/C++ Function
selclassmacro_pop C/C++ Function
selclassmacro_pop C/C++ Function
selcntplg C/C++ Function
selcolr C/C++ Function
selcolr C/C++ Function
selcolr1 C/C++ Function
selcolr1 C/C++ Function
selcolr1_1 C/C++ Function
selcolr1_1 C/C++ Function
selcolr1_2 C/C++ Function
selcolr1_2 C/C++ Function
selcolr1_3 C/C++ Function
selcolr1_3 C/C++ Function
selcolr_1 C/C++ Function
selcolr_1 C/C++ Function
selcolr_2 C/C++ Function
selcolr_2 C/C++ Function
selcolr_3 C/C++ Function
selcolr_3 C/C++ Function
selcomb_name C/C++ Function
selcomb_zip C/C++ Function
selcons_name C/C++ Function
selcons_zip C/C++ Function
selcont C/C++ Function
selcont C/C++ Function
seldonrcatg C/C++ Function
select_from_saturn_spvadds C/C++ Function
selgrp C/C++ Function
selgrp C/C++ Function
selid C/C++ Function
selid_nopop C/C++ Function
seliden C/C++ Function
selinclall C/C++ Function
selinclmemo C/C++ Function
selinclmgcr C/C++ Function
sellyball C/C++ Function
sellybcnt C/C++ Function
sellybplg C/C++ Function
selmacro C/C++ Function
selmass C/C++ Function
selmass_nopop C/C++ Function
selname C/C++ Function
selnamemacro C/C++ Function
selnamemacro C/C++ Function
selnamemacro_pop C/C++ Function
selnamemacro_pop C/C++ Function
selnew C/C++ Function
selpers_addr2 C/C++ Function
selpers_addr2 C/C++ Function
selpers_addr2 C/C++ Function
selpers_addr2 C/C++ Function
selrenewed C/C++ Function
selroom C/C++ Function
selroom_nopop C/C++ Function
selspvadds C/C++ Function
selspvadds C/C++ Function
sol_orgs C/C++ Function
valid_rater C/C++ Function
year_driver C/C++ Function
year_orgs C/C++ Function
D00-PROCESS-GLRVFRM Cobol Section
D00A-FETCH-GLRVFRM Cobol Section
D00B-PROCESS-GLRSFRM Cobol Section
D00C-FETCH-GLRSFRM Cobol Section
D03-PROCESS-PARMS Cobol Section
D04F-STORE-ON-CHAIN Cobol Section
D05-PROCESS-SPVADDS-RTN Cobol Section
D06A-PROCESS-SPVADDS-DATA Cobol Section
E01-PROCESS-ORDER Cobol Section
E03-GET-GLRCMPL Cobol Section
E04-FETCH-STATEMENT Cobol Section
E05-PROCESS-SPVADDS-STATEMENT Cobol Section
E05A-PROCESS-SPVADDS Cobol Section
P17-STRING-GURMAIL Cobol Section
S01-BUILD-SPVADDS Cobol Section
S02-PROCESS-SPVADDS Cobol Section
S03-PROCESS-CONT Cobol Section
S03A-BUILD-SPVADDS-STRING Cobol Section
S05-SPVADDS-APPL-RULES Cobol Section
Y00-GET-CREATOR Cobol Section

Impact job : ln_spriden_first_name ln_spriden_first_name

Impact job : LN_spriden_first_name2 New Job

Columns Comments for SPRIDEN_PIDM (1)

Source Code Comments

Internal identification number of the person.

Columns Comments for SPRIDEN_ID (2)

Source Code Comments

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

Columns Comments for SPRIDEN_LAST_NAME (3)

Source Code Comments

This field defines the last name of person.

Columns Comments for SPRIDEN_FIRST_NAME (4)

Source Code Comments

This field identifies the first name of person.

Columns Comments for SPRIDEN_MI (5)

Source Code Comments

This field identifies the middle name of person.

Columns Comments for SPRIDEN_CHANGE_IND (6)

Source Code Comments

This field identifies whether type of change made to the record was an ID number change or a name change. Valid values: I - ID change, N - name change.

Columns Comments for SPRIDEN_ENTITY_IND (7)

Source Code Comments

This field identifies whether record is person or non-person record. It does not display on the form. Valid values: P - person, C - non-person.

Columns Comments for SPRIDEN_ACTIVITY_DATE (8)

Source Code Comments

This field defines the most current date record is created or changed.

Columns Comments for SPRIDEN_SEARCH_LAST_NAME (11)

Source Code Comments

The Last Name field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SEARCH_FIRST_NAME (12)

Source Code Comments

The First Name field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SEARCH_MI (13)

Source Code Comments

The MI (Middle Initial) field with all spaces and punctuation removed and all letters capitalized.

Columns Comments for SPRIDEN_SOUNDEX_LAST_NAME (14)

Source Code Comments

The Last Name field in SOUNDEX phonetic format.

Columns Comments for SPRIDEN_SOUNDEX_FIRST_NAME (15)

Source Code Comments

The First Name field in SOUNDEX phonetic format.

Columns Comments for SPRIDEN_CREATE_USER (17)

Source Code Comments

Record Create User: This field contains Banner User ID which created new record

Columns Comments for SPRIDEN_CREATE_DATE (18)

Source Code Comments

Record Create Date: This field contains date new record created

Link between PTRBDPL and PDRDEDN

Caller : PTRBDPL
Called : PDRDEDN

Join Information

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

Link List

Link Type Link Project
Join Link Between PTRBDPL and PDRDEDN PAYROLL

Link Between PTRBDPL and PDRDEDN

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PTRBDPL PTRBDPL_BDCA_CODE PDRDEDN_BDCA_CODE PDRDEDN (0,1)-(0,1)

Comments

Link between PTRBDCA and PDRDEDN

Caller : PTRBDCA
Called : PDRDEDN

Join Information

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

Link List

Link Type Link Project
Join Link Between PTRBDCA and PDRDEDN PAYROLL

Link Between PTRBDCA and PDRDEDN

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PTRBDCA PTRBDCA_CODE PDRDEDN_BDCA_CODE PDRDEDN (0,1)-(0,1)

Comments

Link between PERDTOT and PTRBDCA

Caller : PERDTOT
Called : PTRBDCA

Join Information

Objects list
schema-view : MALDEV8_B60.BANINST1.PEVATYP
schema-view : MALDEV8_B60.BANINST1.PEVDEDT
scope-cursor : MALDEV8_B60.BANINST1.BWPKHDED.PERDTOTSUMC

Link List

Link Type Link Project
Join Link Between PERDTOT and PTRBDCA PAYROLL

Link Between PERDTOT and PTRBDCA

Caller : PERDTOT
Called : PTRBDCA
Link Type : Join
Link : Link Between PERDTOT and PTRBDCA

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERDTOT PERDTOT_BDCA_CODE PTRBDCA_CODE PTRBDCA (0,1)-(0,1)

Comments

Link between SPRIDEN and PEBEMPL

Caller : SPRIDEN
Called : PEBEMPL

Join Information

Objects list
schema-view : MALDEV8_B60.BANINST1.PAVAPPL
schema-view : MALDEV8_B60.BANINST1.PEVPRF1
schema-view : MALDEV8_B60.BANINST1.PEVVER2
schema-view : MALDEV8_B60.BANINST1.PEVEMPL
scope-procedure : MALDEV8_B60.BANINST1.PDKDEDN.P_EDIT_EMPLOYEE_ID
scope-function : MALDEV8_B60.BANINST1.BWPKEBST.F_GETPIDMFROMID
schema-function : MALDEV8_B60.BANINST1.F_ORDER_BY_LAST
forms-pl/sql-library-procedure : FORMS_BANNER.NOQJPLS.N$_CHECK_PIDM
forms-pl/sql-library-procedure : FORMS_BANNER.NOQPPLS.N$_CHECK_PIDM

Link List

Link Type Link Project
Join Link Between SPRIDEN and PEBEMPL PAYROLL

Link Between SPRIDEN and PEBEMPL

Caller : SPRIDEN
Called : PEBEMPL
Link Type : Join
Link : Link Between SPRIDEN and PEBEMPL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SPRIDEN SPRIDEN_PIDM PEBEMPL_PIDM PEBEMPL (0,1)-(0,1)

Comments

Link between PDRBENE and PDRBCOV

Caller : PDRBENE
Called : PDRBCOV

Join Information

Objects list
schema-function : MALDEV8_B60.BANINST1.F_BENEFICIARY_INFO
scope-procedure : MALDEV8_B60.BANINST1.BWPKEBST.P_PRINTCOVEREDPERSONS

Link List

Link Type Link Project
Join Link Between PDRBENE and PDRBCOV PAYROLL

Link Between PDRBENE and PDRBCOV

Caller : PDRBENE
Called : PDRBCOV
Link Type : Join
Link : Link Between PDRBENE and PDRBCOV

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PDRBENE PDRBENE_PIDM PDRBCOV_PIDM PDRBCOV (0,1)-(0,1)
PDRBENE PDRBENE_SEQ_NO PDRBCOV_BENE_SEQ_NO PDRBCOV (0,1)-(0,1)

Comments

Link between PDRDEDN and PDRBDED

Caller : PDRDEDN
Called : PDRBDED

Join Information

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

Link List

Link Type Link Project
Join Link Between PDRDEDN and PDRBDED PAYROLL

Link Between PDRDEDN and PDRBDED

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

Foreign Key information

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

Comments

Link between SPRIDEN and PDRBDED

Caller : SPRIDEN
Called : PDRBDED

Join Information

Objects list
schema-view : MALDEV8_B60.BANINST1.PDVDED1

Link List

Link Type Link Project
Join Link Between SPRIDEN and PDRBDED PAYROLL

Link Between SPRIDEN and PDRBDED

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SPRIDEN SPRIDEN_PIDM PDRBDED_PIDM PDRBDED (0,1)-(0,1)

Comments

Link between PTRBDPL and PDRBDED

Caller : PTRBDPL
Called : PDRBDED

Join Information

Objects list
schema-view : MALDEV8_B60.BANINST1.PDVDEDD

Link List

Link Type Link Project
Join Link Between PTRBDPL and PDRBDED PAYROLL

Link Between PTRBDPL and PDRBDED

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PTRBDPL PTRBDPL_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED (0,1)-(0,1)

Comments

Link between PTRBDCA and PDRBCOV

Caller : PTRBDCA
Called : PDRBCOV

Join Information

Objects list
schema-view : MALDEV8_B60.BANINST1.PDVBCOV
scope-procedure : MALDEV8_B60.BANINST1.BWPKEBST.P_PRINTCOVEREDPERSONS

Link List

Link Type Link Project
Join Link Between PTRBDCA and PDRBCOV PAYROLL

Link Between PTRBDCA and PDRBCOV

Caller : PTRBDCA
Called : PDRBCOV
Link Type : Join
Link : Link Between PTRBDCA and PDRBCOV

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PTRBDCA PTRBDCA_CODE PDRBCOV_BDCA_CODE PDRBCOV (0,1)-(0,1)

Comments

Link between SPRIDEN and PDRBENE

Caller : SPRIDEN
Called : PDRBENE

Join Information

Objects list
schema-view : MALDEV8_B60.BANINST1.PDVBEN1
schema-view : MALDEV8_B60.BANINST1.PDVBENE

Link List

Link Type Link Project
Join Link Between SPRIDEN and PDRBENE PAYROLL

Link Between SPRIDEN and PDRBENE

Caller : SPRIDEN
Called : PDRBENE
Link Type : Join
Link : Link Between SPRIDEN and PDRBENE

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
SPRIDEN SPRIDEN_PIDM PDRBENE_BENE_PIDM PDRBENE (0,1)-(0,1)

Comments

Link between PHRDEDN and PTRBDGM

Caller : PHRDEDN
Called : PTRBDGM

Join Information

Objects list
scope-cursor : MALDEV8_B60.BANINST1.BWPKHSTB.GET_PAY_DEDNC
scope-cursor : MALDEV8_B60.BANINST1.BWPKHSTB.GET_DEDN_SUMC

Link List

Link Type Link Project
Join Link Between PHRDEDN and PTRBDGM PAYROLL

Link Between PHRDEDN and PTRBDGM

Caller : PHRDEDN
Called : PTRBDGM
Link Type : Join
Link : Link Between PHRDEDN and PTRBDGM

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PHRDEDN PHRDEDN_BDCA_CODE PTRBDGM_BDCA_CODE PTRBDGM (0,1)-(0,1)

Comments

Link between PHRDEDN and PTRBDCA

Caller : PHRDEDN
Called : PTRBDCA

Join Information

Objects list
scope-cursor : MALDEV8_B60.BANINST1.BWPKHSTB.GET_PAY_DEDNC

Link List

Link Type Link Project
Join Link Between PHRDEDN and PTRBDCA PAYROLL

Link Between PHRDEDN and PTRBDCA

Caller : PHRDEDN
Called : PTRBDCA
Link Type : Join
Link : Link Between PHRDEDN and PTRBDCA

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PHRDEDN PHRDEDN_BDCA_CODE PTRBDCA_CODE PTRBDCA (0,1)-(0,1)

Comments

Link between PDRBDED and PTRBDGM

Caller : PDRBDED
Called : PTRBDGM

Join Information

Objects list
scope-cursor : MALDEV8_B60.BANINST1.BWPKDBCV.PDRBDEDCOVERAGESC
scope-cursor : MALDEV8_B60.BANINST1.BWPKDBCV.PDRBDEDC

Link List

Link Type Link Project
Join Link Between PDRBDED and PTRBDGM PAYROLL

Link Between PDRBDED and PTRBDGM

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PDRBDED PDRBDED_BDCA_CODE PTRBDGM_BDCA_CODE PTRBDGM (0,1)-(0,1)

Comments

Link between PDRBDED and PTRBDPD

Caller : PDRBDED
Called : PTRBDPD

Join Information

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

Link List

Link Type Link Project
Join Link Between PDRBDED and PTRBDPD PAYROLL

Link Between PDRBDED and PTRBDPD

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PDRBDED PDRBDED_BDCA_CODE PTRBDPD_BDCA_CODE PTRBDPD (0,1)-(0,1)
PDRBDED PDRBDED_BDCA_CODE PTRBDPD_CODE PTRBDPD (0,1)-(0,1)

Comments

Link between PDRFCLM and PDRDEDN

Caller : PDRFCLM
Called : PDRDEDN

Join Information

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

Link List

Link Type Link Project
Join Link Between PDRFCLM and PDRDEDN PAYROLL

Link Between PDRFCLM and PDRDEDN

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

Foreign Key information

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

Comments

Link between PDRFBAL and PDRDEDN

Caller : PDRFBAL
Called : PDRDEDN

Join Information

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

Link List

Link Type Link Project
Join Link Between PDRFBAL and PDRDEDN PAYROLL

Link Between PDRFBAL and PDRDEDN

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

Foreign Key information

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

Comments

Link between PDRBDED and PTRBDCG

Caller : PDRBDED
Called : PTRBDCG

Join Information

Objects list
scope-procedure : MALDEV8_B60.BANINST1.PDKLIBS.P_VERIFYCOREBDCAEMP

Link List

Link Type Link Project
Join Link Between PDRBDED and PTRBDCG PAYROLL

Link Between PDRBDED and PTRBDCG

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PDRBDED PDRBDED_BDCA_CODE PTRBDCG_BDCA_CODE PTRBDCG (0,1)-(0,1)
PDRBDED PDRBDED_BDCA_CODE PTRBDCG_CODE PTRBDCG (0,1)-(0,1)

Comments

Link between PDRDEDN and PTRBDPD

Caller : PDRDEDN
Called : PTRBDPD

Join Information

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

Link List

Link Type Link Project
Join Link Between PDRDEDN and PTRBDPD PAYROLL

Link Between PDRDEDN and PTRBDPD

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PDRDEDN PDRDEDN_BDCA_CODE PTRBDPD_CODE PTRBDPD (0,1)-(0,1)

Comments

Link between PTRBDGM and PTRBDCA

Caller : PTRBDGM
Called : PTRBDCA

Join Information

Objects list
scope-procedure : MALDEV8_B60.BANINST1.BWPKEBST.P_BENEFITS

Link List

Link Type Link Project
Join Link Between PTRBDGM and PTRBDCA PAYROLL

Link Between PTRBDGM and PTRBDCA

Caller : PTRBDGM
Called : PTRBDCA
Link Type : Join
Link : Link Between PTRBDGM and PTRBDCA

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PTRBDGM PTRBDGM_BDCA_CODE PTRBDCA_CODE PTRBDCA (0,1)-(0,1)

Comments

Link between PTRBDPD and PTRBDCA

Caller : PTRBDPD
Called : PTRBDCA

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between PTRBDPD and PTRBDCA PAYROLL

Link Foreign Key Between PTRBDPD and PTRBDCA

Caller : PTRBDPD
Called : PTRBDCA
Link Type : Refer(No Action )
Link : Link Foreign Key Between PTRBDPD and PTRBDCA

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)

Comments

Link between PTRBDPL and PTRBDCA

Caller : PTRBDPL
Called : PTRBDCA

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between PTRBDPL and PTRBDCA PAYROLL

Link Foreign Key Between PTRBDPL and PTRBDCA

Caller : PTRBDPL
Called : PTRBDCA
Link Type : Refer(No Action )
Link : Link Foreign Key Between PTRBDPL and PTRBDCA

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)

Comments

Link between PDRBFLX and PEBEMPL

Caller : PDRBFLX
Called : PEBEMPL

Link List

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

Link Foreign Key Between PDRBFLX and PEBEMPL

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PDRBFLX PDRBFLX_PIDM PEBEMPL_PIDM PEBEMPL (1,1)-(0,1)

Comments

Link between PDRFBAL and PEBEMPL

Caller : PDRFBAL
Called : PEBEMPL

Link List

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

Link Foreign Key Between PDRFBAL and PEBEMPL

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

Foreign Key information

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

Comments

Link between PDRFCLM and PEBEMPL

Caller : PDRFCLM
Called : PEBEMPL

Link List

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

Link Foreign Key Between PDRFCLM and PEBEMPL

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

Foreign Key information

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

Comments

Link between PDRBCOV and PDRBDED

Caller : PDRBCOV
Called : PDRBDED

Link List

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

Link Foreign Key Between PDRBCOV and PDRBDED

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PDRBCOV PDRBCOV_PIDM PDRBDED_PIDM PDRBDED (1,1)-(0,n)
PDRBCOV PDRBCOV_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED (1,1)-(0,n)

Comments

Link between PERDTOT and PDRBDED

Caller : PERDTOT
Called : PDRBDED

Link List

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

Link Foreign Key Between PERDTOT and PDRBDED

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERDTOT PERDTOT_PIDM PDRBDED_PIDM PDRBDED (1,1)-(0,n)
PERDTOT PERDTOT_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED (1,1)-(0,n)

Comments

Link between PERPCRE and PDRBDED

Caller : PERPCRE
Called : PDRBDED

Link List

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

Link Foreign Key Between PERPCRE and PDRBDED

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PERPCRE PERPCRE_PIDM PDRBDED_PIDM PDRBDED (1,1)-(0,n)
PERPCRE PERPCRE_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED (1,1)-(0,n)

Comments

Link between PHRDEDN and PDRBDED

Caller : PHRDEDN
Called : PDRBDED

Link List

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

Link Foreign Key Between PHRDEDN and PDRBDED

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PHRDEDN PHRDEDN_PIDM PDRBDED_PIDM PDRBDED (1,1)-(0,n)
PHRDEDN PHRDEDN_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED (1,1)-(0,n)

Comments

Link between PDRBDED and PEBEMPL

Caller : PDRBDED
Called : PEBEMPL

Link List

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

Link Foreign Key Between PDRBDED and PEBEMPL

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

Foreign Key information

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

Comments

Link between PDRBDED and PTRBDCA

Caller : PDRBDED
Called : PTRBDCA

Link List

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

Link Foreign Key Between PDRBDED and PTRBDCA

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

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)

Comments

Link between PDRXPID and PDRBDED

Caller : PDRXPID
Called : PDRBDED

Link List

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

Link Foreign Key Between PDRXPID and PDRBDED

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

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PDRXPID PDRXPID_PIDM PDRBDED_PIDM PDRBDED (1,1)-(0,n)
PDRXPID PDRXPID_BDCA_CODE PDRBDED_BDCA_CODE PDRBDED (1,1)-(0,n)

Comments