TAX - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
PERSON_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
PDRBDED |
PDRBDED_PIDM |
UNKNOWN |
PERSON_NAME |
WOULD WANT DISPLAY OF PERSON NAME HERE |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
TAX_DEDUCTION |
CODE WHICH IDENTIFIES THE BENEFIT/DEDUCTION. |
|
PDRBDED |
PDRBDED_BDCA_CODE |
UNKNOWN |
TAX_DEDUCTION_SHORT_DESC |
BENEFIT / DEDUCTION SHORT DESCRIPTION. |
|
PTRBDCA |
PTRBDCA_SHORT_DESC |
UNKNOWN |
TAX_DEDUCTION_LONG_DESC |
BENEFIT / DEDUCTION LONG DESCRIPTION. |
|
PTRBDCA |
PTRBDCA_LONG_DESC |
UNKNOWN |
TAX_DEDUCTION_YEAR |
DEDUCTION YEAR. |
|
FUNCTION |
F_YEAR |
UNKNOWN |
PROFILE_DATE |
INFORMATION IN THIS MODEL WILL BE RETURNED 'AS OF' THE PROFILE DATE |
|
FUNCTION |
F_PROFILE_DATE |
UNKNOWN |
BEGINNING_DATE |
DATE THE BENEFIT/DEDUCTION BEGINS. |
|
PDRBDED |
PDRBDED_BEGIN_DATE |
UNKNOWN |
ENDING_DATE |
DATE THE BENEFIT/DEDUCTION ENDS. |
|
PDRBDED |
PDRBDED_END_DATE |
UNKNOWN |
EFFECTIVE_DATE |
DATE ON WHICH THE BARGAINING UNIT BECAME EFFECTIVE FOR THIS PERSON. |
|
PDRDEDN |
PDRDEDN_EFFECTIVE_DATE |
UNKNOWN |
EFFECTIVE_START_DATE |
BEGINNING DATE FOR EFFECTIVE DATE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
EFFECTIVE_END_DATE |
DATE ON WHICH THE BARGAINING UNIT WAS NO LONGER ASSOCIATED WITH THIS PERSON. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
STATUS |
STATUS OF THE ACADEMIC OUTCOME AND IDENTIFIES THOSE OUTCOMES THAT ARE PENDING OR AWARDED. |
|
PDRDEDN |
PDRDEDN_STATUS |
UNKNOWN |
STATUS_DESC |
DESCRIPTION FOR THE STATUS CODE . |
|
NA |
NOT AVAILABLE |
UNKNOWN |
EMPLOYEE_ADD_WITHHOLDING_AMT |
EMPLOYEE ADDITIONAL WITHHOLDING AMOUNT |
|
PDRDEDN |
PDRDEDN_AMOUNT1 |
UNKNOWN |
EMPLOYEE_NET_CLAIM_AMT |
PRIMARILY CANADIAN TD1 |
|
PDRDEDN |
PDRDEDN_AMOUNT2 |
UNKNOWN |
EMPLOYEE_ALT_WAGE_BASE_MAX |
PRIMARILY USED FOR CANADIAN PENSION PLAN (EQUIVALENT OF U.S. SOCIAL SECURITY) CALCULATIONS |
|
PDRDEDN |
PDRDEDN_AMOUNT2 |
UNKNOWN |
EMPLOYEE_ANNUALWAGE_DEDUCTIONS |
PRIMARILY USED FOR CANADIAN FEDERAL INCOME TAX CALCULATIONS |
|
PDRDEDN |
PDRDEDN_AMOUNT3 |
UNKNOWN |
EMPLOYEE_TAX_CREDITS |
PRIMARILY USED FOR CANADIAN FEDERAL INCOME TAX CALCULATIONS |
|
PDRDEDN |
PDRDEDN_AMOUNT4 |
UNKNOWN |
EMPLOYEE_FILING_STATUS |
FILING STATUS FOR TAX DEDUCTION |
|
PDRDEDN |
PDRDEDN_OPTION1 |
UNKNOWN |
EMPLOYEE_NUMBER_OF_EXEMPTIONS |
NUMBER OF EXEMPTIONS CLAIMED FOR TAX DEDUCTION |
|
PDRDEDN |
PDRDEDN_OPTION2 |
UNKNOWN |
EMPLOYEE_AREA_CREDIT |
PRIMARILY USED FOR CANADIAN INCOME TAX CALCULATIONS |
|
PDRDEDN |
PDRDEDN_OPTION2 |
UNKNOWN |
EMPLOYEE_NUMBER_OF_DEPENDENTS |
PRIMARILY USED FOR CANADIAN INCOME TAX CALCULATIONS. REPRESENT NUMBER OF DEPENDENTS FOR ONTARIO AND AS MARRIED OR EQUIVALENT FOR SASKATCHEWAN. |
|
PDRDEDN |
PDRDEDN_OPTION3 |
UNKNOWN |
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. |
|
PDRDEDN |
PDRDEDN_OPTION4 |
UNKNOWN |
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. |
|
PDRDEDN |
PDRDEDN_OPTION5 |
UNKNOWN |
STATE_INCOME_TAX_EXEMPTION_AMT |
AMOUNT OF EARNINGS EXEMPT FROM STATE |
|
PDRDEDN |
PDRDEDN_AMOUNT2 |
UNKNOWN |
STATE_INCOME_TAX_INDICATOR1 |
MISCELLANEOUS FIELD TO TRACK OPTIONS RELATED TO THE CALCULATION OF STATE INCOME TAX. VALUE AND USAGE OF THIS FIELD VARIES BY STATE |
|
PDRDEDN |
PDRDEDN_OPTION1 |
UNKNOWN |
STATE_INCOME_TAX_INDICATOR2 |
MISCELLANEOUS FIELD TO TRACK OPTIONS RELATED TO THE CALCULATION OF STATE INCOME TAX. VALUE AND USAGE OF THIS FIELD VARIES BY STATE |
|
PDRDEDN |
PDRDEDN_OPTION2 |
UNKNOWN |
STATE_INCOME_TAX_INDICATOR3 |
MISCELLANEOUS FIELD TO TRACK OPTIONS RELATED TO THE CALCULATION OF STATE INCOME TAX. VALUE AND USAGE OF THIS FIELD VARIES BY STATE |
|
PDRDEDN |
PDRDEDN_OPTION3 |
UNKNOWN |
STATE_INCOME_TAX_INDICATOR4 |
MISCELLANEOUS FIELD TO TRACK OPTIONS RELATED TO THE CALCULATION OF STATE INCOME TAX. VALUE AND USAGE OF THIS FIELD VARIES BY STATE |
|
PDRDEDN |
PDRDEDN_OPTION4 |
UNKNOWN |
STATE_INCOME_TAX_INDICATOR5 |
MISCELLANEOUS FIELD TO TRACK OPTIONS RELATED TO THE CALCULATION OF STATE INCOME TAX. VALUE AND USAGE OF THIS FIELD VARIES BY STATE |
|
PDRDEDN |
PDRDEDN_OPTION5 |
UNKNOWN |
COVERAGE_DATE |
SET EQUAL TO BENEFIT/DEDUCTION BEGIN DATE VIA THE EMPLOYEE BENEFIT/DEDUCTION SETUP FORM. CURRENTLY NOT UTILIZED |
|
PDRDEDN |
PDRDEDN_COVERAGE_DATE |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_QTR1 |
TOTAL EMPLOYEE CONTRIBUTION FOR THE FIRST QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_QTR1 |
TOTAL EMPLOYER CONTRIBUTION FOR THE FIRST QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
APPLICABLE_GROSS_QTR1 |
TOTAL APPLICABLE GROSS EARNINGS FOR THE FIRST QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_QTR2 |
TOTAL EMPLOYEE CONTRIBUTION FOR THE SECOND QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_QTR2 |
TOTAL EMPLOYER CONTRIBUTION FOR THE SECOND QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
APPLICABLE_GROSS_QTR2 |
TOTAL APPLICABLE GROSS EARNINGS FOR THE SECOND QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_QTR3 |
TOTAL EMPLOYEE CONTRIBUTION FOR THE THIRD QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_QTR3 |
TOTAL EMPLOYER CONTRIBUTION FOR THE THIRD QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
APPLICABLE_GROSS_QTR3 |
TOTAL APPLICABLE GROSS EARNINGS FOR THE THIRD QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_QTR4 |
TOTAL EMPLOYEE CONTRIBUTION FOR THE FOURTH QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_QTR4 |
TOTAL EMPLOYER CONTRIBUTION FOR THE FOURTH QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
APPLICABLE_GROSS_QTR4 |
TOTAL APPLICABLE GROSS EARNINGS FOR THE FOURTH QUARTER. |
|
FUNCTION |
F_QUARTERLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYEE_CONTRIBUTION_YTD |
TOTAL EMPLOYEE CONTRIBUTION YEAR TO DATE. |
|
FUNCTION |
F_YEARLY_DEDUCTION_TOTAL |
UNKNOWN |
EMPLOYER_CONTRIBUTION_YTD |
TOTAL EMPLOYER CONTRIBUTION YEAR TO DATE. |
|
FUNCTION |
F_YEARLY_DEDUCTION_TOTAL |
UNKNOWN |
GROSS_COMPENSATION_YTD |
TOTAL APPLICABLE GROSS EARNINGS YEAR TO DATE. |
|
FUNCTION |
F_YEARLY_DEDUCTION_TOTAL |
UNKNOWN |