Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AMOUNT1	Amount1	The first amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT1
AMOUNT2	Amount2	The second amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT2
AMOUNT3	Amount3	The third amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT3
AMOUNT4	Amount4	The fourth amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT4
APPLICABLE_GROSS_QTR1	Applicable Gross Quarter 1	Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR2	Applicable Gross Quarter 2	Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR3	Applicable Gross Quarter 3	Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
APPLICABLE_GROSS_QTR4	Applicable Gross Quarter 4	Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
BEGINNING_DATE	Beginning Date	Date the benefit/deduction begins.	DATE	PDRBDED	PDRBDED_BEGIN_DATE
CALCULATION_RULE	Calculation Rule	Defines how a benefit/deduction is processed by the system. The calc rule selected also determines how the deduction form and the deduction set-up form function.	VARCHAR2(63)	PTRBDCA	PTRBDCA_CALC_RULE
COVERAGE_DATE	Coverage Date	Set equal to benefit/deduction begin date.	DATE	PDRDEDN	PDRDEDN_COVERAGE_DATE
EFFECTIVE_DATE	Effective Date	Date the benefit/deduction becomes effective.	DATE	PDRDEDN	PDRDEDN_EFFECTIVE_DATE
EFFECTIVE_END_DATE	Effective End Date	End effective date.	DATE	FUNCTION	POKODSF.F_GET_END_PDRDEDN_DATE
EFFECTIVE_START_DATE	Effective Start Date	Start effective date.	DATE	PDRDEDN	PDRDEDN_EFFECTIVE_DATE
EMPLOYEE_ADD_WITHHOLDING_AMT	Employee Add Withholding Amount	Amount for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT1
EMPLOYEE_AGE_OVER_65_IND	Employee Age Over 65 Indicator	Primarily used for Canadian Income Tax calculations. Represents if employee if over the age of 65 for tax implications related to those living in Saskatchewan.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE4
EMPLOYEE_ALT_WAGE_BASE_MAX	Employee Alt Wage Base Maximum	Amount for the benefit/deduction. Primarily used for Canadian pension plan (equivalent to U.S. social security) calculations.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT2
EMPLOYEE_ANNUALWAGE_DEDUCTIONS	Employee Annualwage Deductions	Amount for the benefit/deduction. Primarily used for Canadian Federal Income Tax calculations.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT3
EMPLOYEE_AREA_CREDIT	Employee Area Credit	Primarily used for Canadian Income Tax calculations.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE2
EMPLOYEE_CONTRIBUTION_QTR1	Employee Contribution Quarter 1	Quarter 1 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QTR2	Employee Contribution Quarter 2	Quarter 2 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QTR3	Employee Contribution Quarter 3	Quarter 3 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_QTR4	Employee Contribution Quarter 4	Quarter 4 employee contribution.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYEE_CONTRIBUTION_YTD	Employee Contribution Year to Date	Year to date employee contribution for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
EMPLOYEE_DEPENDENTS_UNDER_19	Employee Dependents Under 19	Primarily used for Canadian Income Tax calculations. Represents number of dependents under age 19 for tax implications related to those living in Saskatchewan.	VARCHAR2(63)	FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS
EMPLOYEE_FILING_STATUS	Employee Filing Status	Filing status for tax deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE1
EMPLOYEE_FILING_STATUS_DESC	Employee Filing Status Description	Filing status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMPLOYEE_NET_CLAIM_AMT	Employee Net Claim Amount	Amount for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT2
EMPLOYEE_NUMBER_OF_DEPENDENTS	Employee Number Of Dependents	Primarily used for Canadian Income Tax calculations. Represent number of dependents for Ontario and as Married or Equivalent for Saskatchewan.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE3
EMPLOYEE_NUMBER_OF_EXEMPTIONS	Employee Number Of Exemptions	Number of exemptions claimed for tax deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE2
EMPLOYEE_TAX_CREDITS	Employee Tax Credits	Amount for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT4
EMPLOYER_CONTRIBUTION_QTR1	Employer Contribution Quarter 1	Quarter 1 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR2	Employer Contribution Quarter 2	Quarter 2 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR3	Employer Contribution Quarter 3	Quarter 3 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_QTR4	Employer Contribution Quarter 4	Quarter 4 employer total contribution for a specific deduction.	NUMBER	FUNCTION	POKODSF.F_QUARTERLY_DEDUCTION_TOTAL
EMPLOYER_CONTRIBUTION_YTD	Employer Contribution Year to Date	Year to date employer contribution for a specific deduction.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
ENDING_DATE	Ending Date	Date the benefit/deduction ends.	DATE	PDRBDED	PDRBDED_END_DATE
GROSS_COMPENSATION_YTD	Gross Compensation Year to Date	Year to date gross contribution.	NUMBER	FUNCTION	F_YEARLY_DEDUCTION_TOTAL
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
LIMIT_BEN_1042S_CODE	Limit Ben 1042S Code	Identifies qualification for reduced rate of withholding on a tax treaty for 1042S reporting.	VARCHAR2(63)	PDRDEDN	PDRDEDN_1042S_LIMIT_BEN_CDE
LIMIT_BEN_1042S_DESC	Limit Ben 1042S Desc	Description for LIMIT_BEN_1042S_CODE.	VARCHAR2(255)	FUNCTION	SELECT MTVPARM_DESC FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'ODS VAL CODES' AND MTVPARM_INTERNAL_CODE = '1042S_LIMIT_BEN_CDE' AND MTVPARM_INTERNAL_CODE_2 = PDRDEDN_1042S_LIMIT_BEN_CDE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Person's full name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PDRBDED	PDRBDED_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROFILE_DATE	Profile Date	Profile Date associated with this record.	DATE	FUNCTION	F_PROFILE_DATE
REFERENCE_NUMBER	Reference number	An optional alpha/numeric field.	VARCHAR2(10)	PDRDEDN	PDRDEDN_REF_NO
STATE_INCOME_TAX_EXEMPTION_AMT	State Income Tax Exemption Amount	Second amount field for the benefit/deduction.	NUMBER	PDRDEDN	PDRDEDN_AMOUNT2
STATE_INCOME_TAX_INDICATOR1	State Income Tax Indicator 1	Miscellaneous field to track options related to the calculation of state income tax. The value and usage of this field varies by state, province, etc.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE1
STATE_INCOME_TAX_INDICATOR2	State Income Tax Indicator 2	Miscellaneous field to track options related to the calculation of state income tax. The value and usage of this field varies by state, province, etc.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE2
STATE_INCOME_TAX_INDICATOR3	State Income Tax Indicator 3	Miscellaneous field to track options related to the calculation of state income tax. The value and usage of this field varies by state, province, etc.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE3
STATE_INCOME_TAX_INDICATOR4	State Income Tax Indicator 4	Miscellaneous field to track options related to the calculation of state income tax. The value and usage of this field varies by state, province, etc.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE4
STATE_INCOME_TAX_INDICATOR5	State Income Tax Indicator 5	Miscellaneous field to track options related to the calculation of state income tax. The value and usage of this field varies by state, province, etc.	VARCHAR2(63)	PDRDEDN	PDRDEDN_OPT_CODE5
STATUS	Status	Status of the benefit/deduction.	VARCHAR2(63)	PDRDEDN	PDRDEDN_STATUS
STATUS_DESC	Status Description	Status description.	VARCHAR2(255)	CALCULATION	DECODE(PDRDEDN_STATUS,'A','ACTIVE','B','EXEMPT','W','WAIVED','T','TERMINATED')
TAX_DEDUCTION	Tax Deduction	Identifies the specific Benefit/deduction.	VARCHAR2(63)	PDRBDED	PDRBDED_BDCA_CODE
TAX_DEDUCTION_LONG_DESC	Tax Deduction Long Description	Benefit/deduction long description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TAX_DEDUCTION_SHORT_DESC	Tax Deduction Short Description	Benefit/deduction short description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TAX_DEDUCTION_YEAR	Tax Deduction Year	Deduction year.	NUMBER	FUNCTION	F_YEAR

Ver: 9.2