Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_TAX

Description Source composite view contains tax deduction information for an employee. Data includes information pertaining to the tax deduction, deduction amounts, Canadian deduction amounts, filing status, exemptions and deduction options.

Target Column Business Definition Database Data Type 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: 8.0