| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PA_AUDIT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Audit Indicator
D=Produce Display Output Only
N=Inactivate Application Trace
S=Produce SQL Output Only
Y=Produce Display and SQL Output
Default Value: N
|
| 2 |
PA_TRACE_PEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Plan Eligibility
Y/N Table Edit
Default Value: N
|
| 3 |
PA_TRACE_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Participation
Y/N Table Edit
Default Value: N
|
| 4 |
PA_TRACE_SRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Service
Y/N Table Edit
Default Value: N
|
| 5 |
PA_TRACE_VST |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Vesting
Y/N Table Edit
Default Value: N
|
| 6 |
PA_TRACE_BEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Benefit Eligibility
Y/N Table Edit
Default Value: N
|
| 7 |
PA_TRACE_FAE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Final Average Earnings
Y/N Table Edit
Default Value: N
|
| 8 |
PA_TRACE_CSH |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Cash Balance/Empl Acct
Y/N Table Edit
Default Value: N
|
| 9 |
PA_TRACE_SOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Social Security
Y/N Table Edit
Default Value: N
|
| 10 |
PA_TRACE_CMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Covered Compensation
Y/N Table Edit
Default Value: N
|
| 11 |
PA_TRACE_AGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Early/Late Adjustments
Y/N Table Edit
Default Value: N
|
| 12 |
PA_TRACE_DTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Death Coverage
Y/N Table Edit
Default Value: N
|
| 13 |
PA_TRACE_CLC |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Benefit Formula
Y/N Table Edit
Default Value: N
|
| 14 |
PA_TRACE_EPB |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Employee Paid Benefit
Y/N Table Edit
Default Value: N
|
| 15 |
PA_TRACE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Optional Forms
Y/N Table Edit
Default Value: N
|
| 16 |
PA_TRACE_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Actuarial Calculations
Y/N Table Edit
Default Value: N
|
| 17 |
PA_TRACE_415 |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace 415 Limitations
Y/N Table Edit
Default Value: N
|
| 18 |
PA_TRACE_ERN |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Earnings Consolidations
Y/N Table Edit
Default Value: N
|
| 19 |
PA_TRACE_HRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Hours Consolidations
Y/N Table Edit
Default Value: N
|
| 20 |
PA_TRACE_DED |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Deductions Consolidation
Y/N Table Edit
Default Value: N
|
| 21 |
PA_TRACE_PMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Payments/Trustee Extract
Y/N Table Edit
Default Value: N
|