The translation of valid Gross-to-Net (GTN) for payroll deduction, reduction and contribution codes. Each one of the employees' payroll deductions contains this code which represents the type of deduction being taken (i.e. tax, medical, loan repayment, etc.) Codes within this table indicate processing options such as the type of deduction (reduction or contribution), whether it can be suspended and whether to maintain quarterly and yearly balances for these deductions. The data originates from the Payroll Control Table (CTL).
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| GTN_BASE | CALCULATION BASE | VARCHAR2(1) | The code indicating the base amount or base hours to be used in the calculation of a deduction, reduction or contribution. (values are T=total gross, W=federal withholding tax gross, F=FICA gross, S=state withholding tax gross and R=retirement gross) |
| GTN_BEN_CODE | SPECIAL BENEFITS PROCESSING CODE | VARCHAR2(1) | The code indicating whether the GTN is associated with special benefits processing. (values are A=faculty benefit cost offset/management benefit special processing, H=health contribution processing, D=dental contribution processing, V=vision contribution process and blank=no special benefits processing) |
| GTN_BENEFIT_PLAN | BENEFIT PLAN CODE | VARCHAR2(2) | The code indicating the associated benefit plan, if applicable. |
| GTN_BENEFIT_TYPE | BENEFIT TYPE CODE | VARCHAR2(1) | The code indicating the type of benefit represented by the GTN. (values are A=accidental death & dismemberment insurance, D=dental insurance, H=health insurance, J=legal insurance, L=group life insurance, S=employee paid temporary disability insurance, V=optical insurance, X=long term disability insurance and Y=dependent life insurance) |
| GTN_BI_SCHED_CODE | PAY SCHED BIWEEKLY CODE | VARCHAR2(2) | The code indicating the payroll cycle during which a deduction, reduction or contribution is processed if the employee's primary pay cycle is "biweekly". (values are A=all biweekly payroll cycles, B=all biweekly payrolls except the 3rd in a month, 1=first biweekly payroll of the month, 2=second biweekly payroll of the month, X=all payroll cycles and blank=default to 'A') |
| GTN_CB_BEHAV_CODE | INELIGIBLE ACTION CODE | VARCHAR2(1) | The code indicating the action to be taken when an individual is ineligible on collective bargaining grounds, for a benefit or miscellaneous deduction in which the employee is enrolled or attempting to enroll. (values are 1=enroll if ineligible-do not de-enroll, 2=do not enroll if ineligible-de-enroll if ineligible, 3=do not enroll if ineligible-do not de-enroll if ineligible and blank=no collective bargaining agreement) |
| GTN_CB_ELIG_IND | COLLECTIVE BARGAINING ELIG CODE | VARCHAR2(1) | The code indicating the combination of collective bargaining attributes which are to be used in determining the eligibility for the deduction, reduction or contribution. (see notes below) |
| GTN_CON_EDIT_RTN | UNEMPLOYMENT INSURANCE GROSS INDICATOR | NUMBER(3) | The code identifying the program routine number which performs the consistency edit on the GTN. |
| GTN_DECLINING_BAL | DECLINING BAL INDICATOR | VARCHAR2(1) | The code indicating whether a declining balance is to be maintained on the employee's record. (values are D=declining balance maintained and blank=no declining balance maintained) |
| GTN_DEDUCTION_CODE | RETIREMENT CONTRIBUTION CODE | VARCHAR2(2) | The code indicating the type of contribution to a retirement system. Only used with PERS. (values are 34=additional contribution and 38=buy-back) |
| GTN_DESCRIPTION | GTN DESCRIPTION | VARCHAR2(15) | The description of the GTN number. |
| GTN_DISPLAY_IDED | IDED SCREEN DISPLAY FLAG | VARCHAR2(1) | The code indicating whether to display the GTN on the IDED Departmental Deductions EDB Screen. (values are Y=yes and blank=no) |
| GTN_DISPLAY_IGTN | IGTN SCREEN DISPLAY FLAG | VARCHAR2(1) | The code indicating whether to display the GTN on the IGTN Central Office Deductions EDB Screen. (values are Y=yes and blank=no) |
| GTN_DISPLAY_IRET | IRET SCREEN DISPLAY FLAG | VARCHAR2(1) | The code indicating whether to display the GTN on the IRET Departmental Retirement/Savings Program EDB Screen. (values are Y=yes and blank=no) |
| GTN_DISPLAY_IRTR | IRTR SCREEN DISPLAY FLAG | VARCHAR2(1) | The code indicating whether to display the GTN on the IRTR Central Office Retirement/Savings Program EDB Screen. (values are Y=yes and blank=no) |
| GTN_ETD | EMPLOYEE TO DATE INDICATOR | VARCHAR2(1) | The code indicating whether an employment-to-date balance is to be maintained on the employee's record. (values are E=employment-to-date balance maintained and blank=no employment-to-date balance maintained) |
| GTN_FULL_PART | PARTIAL PAYMENT INDICATOR | VARCHAR2(1) | The code indicating whether a partial amount may be deducted when there is not sufficient net pay to cover the full amount. (values are F=full amt must be deducted and P=partial amt may be deducted) |
| GTN_FYTD | FISCAL YTD INDICATOR | VARCHAR2(1) | The code indicating whether a fical year-to-date balance is to be maintained on the employee's record. (values are F=fiscal year-to-date balance maintained and blank=no fiscal year-to-date balance maintained) |
| GTN_GROUP | GTN GROUP | VARCHAR2(1) | The code which categorizes the GTN number. (values are T=tax, R=retirement, I=insurance, M=miscellaneous and U=union dues) |
| GTN_ICED_INDICATOR | ICED INDICATOR | VARCHAR2(1) | Under research. |
| GTN_LAST_ACTION | LAST ACTION CODE | VARCHAR2(1) | The code indicating the last action which affected the GTN entry. (values are A=added, C=changed and D=deleted-which only show on the report, not in the data base) |
| GTN_LAST_ACTION_DT | LAST ACTION DATE | DATE | The date of the last action which affected the GTN entry. |
| GTN_LIABILITY_FAU | LIABILITY FAU | VARCHAR2(30) | The FAU to which a deduction, reduction or contribution is charged as a liability. |
| GTN_LIABILITY_OBJ | LIABILITY OBJECT | VARCHAR2(4) | The object to which a deduction, reduction or contribution is charged as a liability. |
| GTN_MATCH_ELEMENT | RELATED GTN NUMBER | VARCHAR2(3) | The GTN number of a related deduction, reduction or contribution which whould be processed in conjunction with another deduction, reduction or contribution. |
| GTN_MAX_AMOUNT | YEARLY MAX DEDUCTION AMT | NUMBER(7,2) | The amount of the maximum deduction activity per year per employee for this deduction. |
| GTN_MN_SCHED_CODE | PAY SCHED MONTHLY CODE | VARCHAR2(2) | The code indicating the payroll cycle during which a deduction, reduction or contribution is processed if the employee's primary pay cycle is "monthly". (values are A=all monthly payroll cycles, X=all payroll cycles and blank=default to 'A') |
| GTN_NUMBER | GTN NUMBER | VARCHAR2(3) | The number uniquely identifying an entry (deduction, reduction or contribution). NOTE: There are deduction numbers used internally by the PPS system that are not shown (and must not be added) to the GTN table - i.e. 132-FICA contribution, 135-Workers' Compensation.) (KEY) |
| GTN_OVRD_DED | GTN Ovrd Deduction | VARCHAR2(3) | Under reserach. |
| GTN_PREPAYMENT_FAU | PREPAYMENT FAU | VARCHAR2(30) | The FAU to which a deduction, reduction or contribution is charged a prepayment. |
| GTN_PRIORITY | PRIORITY NUMBER | VARCHAR2(4) | The number indicating the order of priority for processing the deduction, reduction or contribution. |
| GTN_PRT_YTD_ON_CK | PRINT YTD BAL ON CHECK INDICATOR | VARCHAR2(1) | The code indicating whether a calendar year-to-date balance is to be printed on the payroll check stub. |
| GTN_QTD | QTD INDICATOR | VARCHAR2(1) | The code indicating whether a calendar quarter-to-date balance is to be maintained on the employee's record in the Employee Data Base (EDB) for the deduction, reduction or contribution. |
| GTN_RECEIVABLE_FAU | RECEIVABLES FAU | VARCHAR2(30) | The FAU to which a deduction, reduction or contribution is shown as a receivable. |
| GTN_REDUCE_BASE | REDUCTION INDICATOR | VARCHAR2(1) | The code indicating whether the base amount identified in the GTN_BASE should be reduced by the deduction amount. (values are R=calculation base amt reduced and blank=calculation base amt not reduced) |
| GTN_REDUCTION_FICA | FICA WITHHOLDING FLAG | VARCHAR2(2) | The code indicating FICA Gross is affected by the amount of a deduction. (values are Y=yes, do reduce FICA gross, N=no, don't reduce and blank=if blank when input, defaults to 'Y') |
| GTN_REDUCTION_FWT | FEDERAL WITHOLDING TAX FLAG | VARCHAR2(1) | The code indicating whether Federal Withholding Tax Gross is affected by the amount of a deduction. (values are Y=yes, do reduce FWT taxable gross, N=no, don't reduce and blank=if blank when input, defaults to 'Y') |
| GTN_REDUCTION_SWT | STATE WITHOLDING TAX FLAG | VARCHAR2(1) | The code indicating whether State Withholding Tax Gross is affected by the amount of a deduction. (values are Y=yes, do reduce SWT taxable gross, N=no, don't reduce and blank=if blank when input, defaults to 'Y') |
| GTN_SET_INDICATOR | SET INDICATOR | VARCHAR2(1) | Under research. |
| GTN_SP_CALC_IND | SPECIAL CALC INDICATOR | VARCHAR2(1) | The code indicating when a special calc routine number is to be invoked. (values are M=mandatory, routine always invoked, C=conditional, routine invoked only if the GTN balance is not zero and blank=no special calculation routine invoked) |
| GTN_SP_CALC_NO | SPECIAL CALC NUMBER | VARCHAR2(2) | The number identifying a calculation routine other than one specified in the Calculation Usage Code. (see notes at bottom of page) |
| GTN_SP_UPDATE_NO | SPECIAL CALC UPDATE ROUTINE | VARCHAR2(2) | The number identifying a routine to update the employee's record after the deduction, reduction or contribution has been calculated. (see notes below) |
| GTN_SM_SCHED_CODE | PAY SCHED SM CODE | VARCHAR2(2) | The code indicating the payroll cycle during which a deduction, reduction or contribution is processed if the employee's primary pay cycle is "semi-monthly". (values are A=all semi-monthly payroll cycles, 1=first semi-monthly payroll of the month, 2=second semi-monthly payroll of the month, X=all payroll cycles and blank=default to 'A'). NOTE: Semi-monthly pay cycle is not used at UCD. |
| GTN_STATUS | STATUS INDICATOR | VARCHAR2(1) | The code indicating whether any calculation activity may be processed for the deduction, reduction or contribution. (values are I=calculation cannot be processed and blank=calculation may be processed) |
| GTN_STOP_AT_TERM | STOP AT SEPARATION INDICATOR | VARCHAR2(1) | The code indicating whether a deduction, reduction or contribution can be processed for an individual who has separated from University employment. (values are S=not processed and blank=is processed) |
| GTN_SUSPENSE | SUSPENSE INDICATOR | VARCHAR2(1) | The code indicating whether and how the GTN is to be suspended. (values are S=suspend, R=suspend as a receivable, blank=not to be suspended) |
| GTN_TYPE | GTN TYPE | VARCHAR2(1) | The code indicating whether the entry on the GTN table is a deduction, reduction or contribution. (values are D=deduction, an amt subtracted from net pay; R=reduction, an amt subtracted from gross pay before Fed and State taxes are calculated and C=employer contribution) |
| GTN_USAGE | CALCULATION USAGE | VARCHAR2(1) | The code indicating the method of calculating the deduction, reduction or contribution. (see notes at bottom of page) |
| GTN_USER | USER CONTROLLED INDICATOR | VARCHAR2(1) | The code indicating whether a user-controlled balance is to be maintained on the employee's record. (values are U=user-controlled balance maintained and blank=no user controlled balance maintained) |
| GTN_VALUE_RNG_EDIT | RANGE EDIT INDICATOR | VARCHAR2(1) | The code indicating whether and how the balance should be edited against an acceptable value or range of values. (values are V=value edit, R=range edit and blank=no edit) |
| GTN_VALUE1 | EDIT VALUE 1 | NUMBER(7,2) | The specified value or a lower range value to be used when editing a GTN balance. |
| GTN_VALUE2 | EDIT VALUE 2 | NUMBER(7,2) | The higher range value to be used when editing a GTN balance. |
| GTN_YTD | YTD INDICATOR | VARCHAR2(1) | The code indicating whether a calendar year-to-date balance is to be maintained on the employee's record in the Employee Data Base (EDB) for the deduction, reduction or contribution. |
ADDITIONAL CODE INTERPRETATION NOTES:
Some of the lists of code translations are fairly lengthy so they are listed here.
GTN_CB_ELIG_IND
BLANK: none, no collective bargaining eligibility requirement
1: HEERA Employee Unit Code plus HEERA Employee Representation Code
2: Title Unit Code plus HEERA Appointment Representation Code
3: Title Unit Code and HEERA Appointment Representation Code plus HEERA Title Special
Handling Code
4: Title Unit Code and HEERA Appointment Representation Code plus HEERA Distribution Unit
Code
5: Title Unit Code and HEERA Appointment Representation Code and HEERA Title Special
Handling Code plus HEERA Distribution Unit Code
GTN_SP_CALC_NO
blank: no special calculation routine
04: creates retirement deduction, reduction and contribution
05: creates percentage-based voluntary UCRS tax-deffered retirement deductions
06: creates vision insurance deduction and contribution
07: creates health insurance deduction and contribution
08: creates dental insurance deduction and contribution
09: creates AD&D insurance deduction
10: creates life insurance deduction
15: creates deductions limited by a monthly maximum
20: creates FICA deduction and contribution
22: creates federal withholding tax deduction
24: creates federal Earned Income Credit payment
25: creates state withholding tax deduction
GTN_SP_UPDATE_NO
54: updates various retirement grosses, rates and amounts
55: updates YTD deduction amounts
56: updates health insurance de-enrollment indicator
58: updates dental insurance de-enrollment indicator
59: updates AD&D insurance de-enrollment indicator
60: updates life insurance de-enrollment indicator
64: updates vision insurance de-enrollment indicator
72: updates federal withholding tax grosses, YTD and QTD
75: updates state withholding tax grosses, YTD and QTD
99: updates both federal and state withholding tax grosses, YTD and QTD
GTN_USAGE- Each of the values has a different calculation routine. F,P and H
use the amount field in the deduction record while 1,2 and 3 use the system parameter
specified in the GTN_AMT field on the deduction record:
blank: use the special calculation routine number
F: it is the fixed amount indicated in the calculation base code
P: it is the percent of the amount indicated in the calculation base code
H: it is the rate multiplied by the hours indicated in the calculation base code
1: it is the fixed amount taken from the system parameter specified on the deduction
2: it is the percent of the amount taken from the system parameter specified on the
deduction
3: it is the rate multiplied by the hours indicated byt the system parameter specified on
the deduction
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comments to: PPS Data Warehouse Support at paysys-support@ucdavis.edu
Last Updated: June 08, 2001