| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
NRD_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Normal Retirement Data Name
Prompt Table:
PA_DATE_ALS_VW
|
| 4 |
CREDIT_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit is Based on
C=Consolidated Contributions
E=Consolidated Earnings
Default Value: C
|
| 5 |
CONS_DEDUCT_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Consolidated Deduction Name
Prompt Table:
PA_CONS_DED_VW
|
| 6 |
PROJECT_CONSOL |
Character(10) |
VARCHAR2(10) NOT NULL |
Projection Rule Name
Prompt Table:
PA_CONS_EARN_VW
|
| 7 |
EARNINGS_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Consolidated Earnings
Prompt Table:
PA_CONS_EARN_VW
|
| 8 |
PROJECT_EARNINGS |
Character(10) |
VARCHAR2(10) NOT NULL |
Project Consol Earnings Name
Prompt Table:
PA_PROJECTIONS
|
| 9 |
APPLY_401A17 |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply 401(a)(17)
Y/N Table Edit
Default Value: N
|
| 10 |
APPLY_401A17_PROJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply 401(a)(17) - projections
Y/N Table Edit
Default Value: N
|
| 11 |
DFN_401A17 |
Character(10) |
VARCHAR2(10) NOT NULL |
401(a)(17) Limit
Prompt Table:
PA_401A17_PARMS
|
| 12 |
ACCUM_PD |
Character(1) |
VARCHAR2(1) NOT NULL |
Accumulation Period
C=Calendar Year
M=Calendar Month
P=Plan Year
|
| 13 |
DFN_INTEREST |
Character(10) |
VARCHAR2(10) NOT NULL |
Interest Parameter Set Name
Prompt Table:
PA_DFN_INTEREST
|
| 14 |
DFN_INTEREST2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Balance Interest After Event
Prompt Table:
PA_DFN_INTEREST
|
| 15 |
DFN_INTEREST_CRED |
Character(10) |
VARCHAR2(10) NOT NULL |
Interest Definition for Credit
Prompt Table:
PA_DFN_INTEREST
|
| 16 |
CREDIT_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Credit according to
L=Level Rate
N=No Credit
S=Step Rate
U=User Code
Default Value: L
|
| 17 |
STEP_RT_THRESHOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Step Rate Threshold
C=Constant Amount
P=Percentage of Table Lookup
T=Percentage of MTWB
U=User Code
Default Value: U
|
| 18 |
STEP_RT_THD_AMT |
Number(7,0) |
INTEGER NOT NULL |
Constant Amount
|
| 19 |
STEP_RT_THD_TBL_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Lookup Table Name
Prompt Table:
PA_TBL_ALS_SRCH
|
| 20 |
TA_THD_TBL_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Aware Threshold Table Nam
Prompt Table:
PA_TBL_INT_SRCH
|
| 21 |
TBL_LOOKUP_PCT |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Lookup Percent
|
| 22 |
TA_TBL_LOOKUP_PCT |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Time Aware Percent
|
| 23 |
TA_TBL_OPTIONS |
Character(3) |
VARCHAR2(3) NOT NULL |
Time Aware Table Options
FPD=First Day of the Period
FYC=First Day of the Calendar Year
FYP=First Day of the Plan Year
LPD=Last Day of the Period
Default Value: FPD
|
| 24 |
MINIMUM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to Minimum
Y/N Table Edit
Default Value: N
|
| 25 |
MAXIMUM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to Maximum
Y/N Table Edit
Default Value: N
|
| 26 |
CREDIT_MIN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Credit Field Type
L=Lookup Table
U=User Code
|
| 27 |
CREDIT_MIN_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Lookup Table Name
Prompt Table:
PA_TBL_ALS_SRCH
|
| 28 |
CREDIT_MAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Maximum Credit Field Type
L=Lookup Table
U=User Code
|
| 29 |
CREDIT_MAX_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Lookup Table Name
Prompt Table:
PA_TBL_ALS_SRCH
|
| 30 |
CREDIT_FULL_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Full Period Rule
C=Custom Statement
F=Flat Percentage
T=Program Generated Lookup
U=User Table
Default Value: F
|
| 31 |
FULL_PCT1 |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Up To Threshold
|
| 32 |
FULL_PCT2 |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Full Period Flat Percent 2
|
| 33 |
FULL_TABLE1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Up To Threshold
Prompt Table:
PA_TBL_ALS_SRCH
|
| 34 |
FULL_TABLE2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Above Threshold
Prompt Table:
PA_TBL_ALS_SRCH
|
| 35 |
FULL_TA_TBL1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Up To Treshold
Prompt Table:
PA_TBL_INT_SRCH
|
| 36 |
FULL_TA_TBL2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Above Threshold
Prompt Table:
PA_TBL_INT_SRCH
|
| 37 |
FULL_STMT1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Up To Threshold
Prompt Table:
PA_CUSTOM
|
| 38 |
FULL_STMT2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Above Threshold
Prompt Table:
PA_CUSTOM
|
| 39 |
FULL_TA_TBL_OPT1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Up To Threshold LookUp
AAS=Age and Service
AGE=Age
APS=Age Plus Service
SVC=Service
Default Value: AGE
|
| 40 |
FULL_TA_AGE_OPT1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Age End Date
FPD=First Day of the Period
LPD=Last Day of the Period
Default Value: FPD
|
| 41 |
FULL_TA_SVC_OPT1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Service As Of
FPD=First Day of the Period
LPD=Last Day of the Period
Default Value: FPD
|
| 42 |
FULL_TA_TBL_OPT2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Above Threshold Lookup
AAS=Age + Svc
AGE=Age
APS=Age + Svc
SVC=Svc
Default Value: AGE
|
| 43 |
FULL_TA_AGE_STRT1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Aware Age Start Date1
Prompt Table:
PA_DATE_ALS_VW
|
| 44 |
FULL_TA_AGE_MTHD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Age Method
Prompt Table:
PA_DURATION_OPT
|
| 45 |
FULL_TA_SVC_NM1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Aware Service Name1
Prompt Table:
PA_DFN_SVC_VW
|
| 46 |
FULL_TA_AGE_OPT2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Age End Date
FPD=First Day of the Period
LPD=Last Day of the Period
Default Value: FPD
|
| 47 |
FULL_TA_SVC_OPT2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Service As Of
FPD=First Day of the Period
LPD=Last Day of the Period
Default Value: FPD
|
| 48 |
FULL_TA_AGE_STRT2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Aware Age Start 2
Prompt Table:
PA_DATE_ALS_VW
|
| 49 |
FULL_TA_AGE_MTHD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Age Method
Prompt Table:
PA_DURATION_OPT
|
| 50 |
FULL_TA_SVC_MN2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Aware Service Name2
Prompt Table:
PA_DFN_SVC_VW
|
| 51 |
CREDIT_PARTIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Period Rule
N=No Credit
S=Same as Full Period
U=User Code
Default Value: S
|
| 52 |
AGE_STRT1_ALT |
Character(2) |
VARCHAR2(2) NOT NULL |
Age Start Alial Type
|
| 53 |
AGE_STRT2_ALT |
Character(2) |
VARCHAR2(2) NOT NULL |
Age Start Alias Type
|
| 54 |
NRD_ALT |
Character(2) |
VARCHAR2(2) NOT NULL |
NRD Alias Type
|
| 55 |
INTEREST_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Only (No Credits)
Y/N Table Edit
Default Value: N
|
| 56 |
EACCT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Account Type
1=Contribution Account
2=Withdrawal Account
3=Service Purchase
Default Value: 1
|