Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
BEGINNING_DATE		Date the benefit/deduction begins.	DATE		PDRBDED	PDRBDED_BEGIN_DATE
CALCULATION_RULE		This rule defines how a benefit or deduction is processed by the system.	VARCHAR2(2)
COVERAGE_DATE		Set equal to benefit/deduction begin date.	DATE		PDRDEDN	PDRDEDN_COVERAGE_DATE
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EFFECTIVE_DATE		Date the benefit/deduction becomes effective.	DATE		PDRDEDN	PDRDEDN_EFFECTIVE_DATE
EFFECTIVE_END_DATE		End effective date.	DATE		FUNCTION	POKODSF.F_GET_END_PDRDEDN_DATE
EFFECTIVE_START_DATE		Start effective date.	DATE		PDRDEDN	PDRDEDN_EFFECTIVE_DATE
EMPLOYEE_ADD_WITHHOLDING_AMT		Amount for the benefit/deduction.	NUMBER		FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_AGE_OVER_65_IND		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)		FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS
EMPLOYEE_ALT_WAGE_BASE_MAX		Amount for the benefit/deduction. Primarily used for Canadian pension plan (equivalent to U.S. social security) calculations.	NUMBER		FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_ANNUALWAGE_DEDUCTIONS		Amount for the benefit/deduction. Primarily used for Canadian Federal Income Tax calculations.	NUMBER		FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
EMPLOYEE_AREA_CREDIT		Primarily used for Canadian Income Tax calculations.	VARCHAR2(63)		FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS
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		Filing status for tax deduction.	VARCHAR2(63)		FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS
EMPLOYEE_FILING_STATUS_DESC		Description of the filing status for tax deduction	VARCHAR2(255)
EMPLOYEE_NET_CLAIM_AMT		Amount for the benefit/deduction.	NUMBER		FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
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)		FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS
EMPLOYEE_NUMBER_OF_EXEMPTIONS		Number of exemptions claimed for tax deduction.	VARCHAR2(63)		FUNCTION	POKODSF.F_GET_DEDUCTION_OPTIONS
EMPLOYEE_TAX_CREDITS		Amount for the benefit/deduction.	NUMBER		FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
ENDING_DATE		Date the benefit/deduction ends.	DATE		PDRBDED	PDRBDED_END_DATE
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		PDRBDED	PDRBDED_PIDM
PROFILE_DATE		Profile Date associated with this record.	DATE		FUNCTION	F_PROFILE_DATE
STATE_INCOME_TAX_EXEMPTION_AMT		Amount of earnings exempt from state, province, etc. income tax.	NUMBER		FUNCTION	POKODSF.F_GET_DEDUCTION_AMOUNTS
STATE_INCOME_TAX_INDICATOR1		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(2)		PDRDEDN	PDRDEDN_OPT_CODE1
STATE_INCOME_TAX_INDICATOR2		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(2)		PDRDEDN	PDRDEDN_OPT_CODE2
STATE_INCOME_TAX_INDICATOR3		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(2)		PDRDEDN	PDRDEDN_OPT_CODE3
STATE_INCOME_TAX_INDICATOR4		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(2)		PDRDEDN	PDRDEDN_OPT_CODE4
STATE_INCOME_TAX_INDICATOR5		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(2)		PDRDEDN	PDRDEDN_OPT_CODE5
STATUS		Status of the benefit/deduction.	VARCHAR2(1)		PDRDEDN	PDRDEDN_STATUS
STATUS_DESC		Status description.	VARCHAR2(30)		CALCULATION	DECODE(PDRDEDN_STATUS,'A','ACTIVE','B','EXEMPT','W','WAIVED','T','TERMINATED')
TAX_DEDUCTION		Identifies the specific Benefit/deduction.	VARCHAR2(3)		PDRBDED	PDRBDED_BDCA_CODE
TAX_DEDUCTION_LONG_DESC		Benefit/deduction long description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
TAX_DEDUCTION_SHORT_DESC		Benefit/deduction short description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
TAX_DEDUCTION_YEAR		Deduction Year.	VARCHAR2(4)		FUNCTION	F_YEAR
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: