| # |
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 |
REPORTING_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Tax Reporting ID
|
| 5 |
TOT_SUPPLEMENTARY |
Number(7,0) |
INTEGER NOT NULL |
Total Supplementary
|
| 6 |
TTL_INCOME |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Income
|
| 7 |
TOT_EECPP_CONTR |
Number(14,2) |
DECIMAL(13,2) NOT NULL |
Total EE CPP Contribution
|
| 8 |
TOT_EE_EI_PREM |
Number(14,2) |
DECIMAL(13,2) NOT NULL |
Total EE EI Premium
|
| 9 |
TOT_REGPP_CONTR |
Number(14,2) |
DECIMAL(13,2) NOT NULL |
Total Reg PP Contribution
|
| 10 |
TOT_INCOME_TAX |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Income Tax
|
| 11 |
TOT_PENS_ADJ |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total Pension Adjustments
|
| 12 |
TOT_EI_INS_EARNS |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Total EI Insurable Earnings
|
| 13 |
TOT_ERCPP_CONTR |
Number(14,2) |
DECIMAL(13,2) NOT NULL |
Total ER CPP Contributions
|
| 14 |
TOT_ER_EI_PREM |
Number(14,2) |
DECIMAL(13,2) NOT NULL |
Total ER EI Premium
|
| 15 |
TOT_USA_COUNT |
Number(6,0) |
INTEGER NOT NULL |
Total USA Count
|
| 16 |
SAVE_SEGM_NUMBER |
Number(7,0) |
INTEGER NOT NULL |
Save Segment Number
|
| 17 |
CTX_SORT_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Code for CTX915 pgms
|
| 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 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|