| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 2 |
CTX_TYPE_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type Code
|
| 3 |
WAGE_LOSS_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
|
| 4 |
TOT_SUPPLEMENTARY |
Number(7,0) |
INTEGER NOT NULL |
Total Supplementary
|
| 5 |
TOT_PENS_ANNUT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Pension Annuities
|
| 6 |
TOT_LUMP_SUM |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Lump Sum Payments
|
| 7 |
TOT_COMMISSIONS |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Commissions
|
| 8 |
TOT_PATRON_ALLOC |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Patronage Allocated
|
| 9 |
TOT_PAST_PENS |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Past Pension
|
| 10 |
TOT_ANNUITIES |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Annuities
|
| 11 |
TOT_OTH_INCOME |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Other Income
|
| 12 |
TOT_INCOME_TAX |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Income Tax
|
| 13 |
TOT_PENS_ADJ |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Pension Adjustments
|
| 14 |
CTX_SORT_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Code for CTX915 pgms
|
| 15 |
REPORTING_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Tax Reporting ID
|
| 16 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 17 |
TOT_USA_COUNT |
Number(6,0) |
INTEGER NOT NULL |
Total USA Count
|
| 18 |
CTX_PLAN_A |
Character(7) |
VARCHAR2(7) NOT NULL |
CTX915 Pgms - Plan A
|
| 19 |
CTX_PLAN_B |
Character(7) |
VARCHAR2(7) NOT NULL |
CTX915 Pgms - Plan B
|
| 20 |
CTX_PLAN_C |
Character(7) |
VARCHAR2(7) NOT NULL |
CTX915 Pgms - Plan C
|
| 21 |
TOT_RESP_INCOME |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total RESP Income
|
| 22 |
TOT_RESP_ASSTPAY |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total RESP Assist Pay
|
| 23 |
TOT_FEES_SERVICES |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Fees for services - T4A.
|