| Field Name |
Business Name |
Data Type |
Description |
| BEN_RATE_SEL_CODE |
BENEFITS RATE SELECTOR CODE |
VARCHAR2(5) |
The combination of bargaining unit code, representative
code, special
handling code and distribution code used
to determine rates for a particular
deduction, reduction,
or contribution. |
| DED_SOURCE_CODE |
DEDUCTION SORUCE CODE |
VARCHAR2(1) |
The code indicating the source or disposition of a deduction
(A=prepayment,
P=deduction from a prepayment, S=deduction
was suspended, R=deduction was
suspended as a receivable,
N=deduction was not taken, D=deduction was taken from
a previously suspended balance, V=deduction was taken from
a previously suspended receivable, or
BLANK=normal deduction
from gross). |
| EMPLOYEE_ID |
EMPLOYEE ID NUMBER |
VARCHAR2(9) |
The unique employee identification number. |
| ENTRY_SEQ_NO |
ENTRY SEQUENCE NUMBER |
NUMBER(5) |
|
| GTN_AMT |
GROSS-TO-NET AMOUNT |
NUMBER(7,2) |
|
| GTN_GROUP |
GROSS-TO-NET GROUP CODE |
VARCHAR2(1) |
The code indicating the category to which this
gross-to-net entry belongs
(T=tax, I=insurance, R=retirement,
M=miscellaneous deduction, U=union
dues). |
| GTN_NUMBER |
GROSS-TO-NET NUMBER |
VARCHAR2(3) |
The gross-to-net number that identifies the deduction, reduction,
or
contribution, |
| GTN_TYPE |
GROSS-TO-NET TYPE CODE |
VARCHAR2(1) |
The code indicating the gross-to-net type entry (D=deduction,
R=reduction,
C=contribution). |
| PAY_CYCLE_CODE |
PAY CYCLE CODE |
VARCHAR2(2) |
The code indicating the pay cycle for which the payroll
audit record was
generated. |
| PAY_CYCLE_END_DATE |
PAY CYCLE END DATE |
DATE |
The last date in the pay cycle for which the payroll audit
record was
generated. |
| PRI_GROSS_CTL |
PAYROLL AUDIT RECORD GENERATION NUMBER |
VARCHAR2(3) |
The number identifying the payroll audit record generation
produced for the
individual. |
| QTD_DED_IND |
DEDUCTION QUARTER CODE |
VARCHAR2(1) |
The code indicating which quarter-to-date deduction balance is affected
(0=no
affect, 1=current year, 1st quarter, 2=current year, 2nd quarter,
3=current
year, 3rd quarter, 4=current year, 4th quarter or
BLANK=current
quarter). |
| RECORD_TYPE |
RECORD TYPE |
VARCHAR2(2) |
|
| TRANS_TYPE |
TRANSFER TYPE |
VARCHAR2(1) |
|
| YTD_DED_IND |
DEDUCTION YEAR CODE |
VARCHAR2(1) |
The code indicating whether a deduction affected a year-to-date
deduction
balance (Y=yes, year-to-date balances affected, N=no,
year-to-date
balances not affected, or BLANK=yes, year-to-date
balances
affected). |
