| # |
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 |
SS_BENEFIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
SS Benefit Type
D=Disability Retirement
O=Old Age Retirement
Default Value: O
|
| 4 |
USE_EARN_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Consolidated Earn Periods
A=All Consolidated Periods
C=Current Period Only
Default Value: C
|
| 5 |
REGRESSION_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Earnings Regression Method
F=Use Flat Percentage
W=Use National Average Wage
Z=Regress using Zero
Default Value: W
|
| 6 |
REGRESS_PCT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Earnings Regression Flat Pct
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 7 |
REGRESS_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Earnings Regression Flat Pct
|
| 8 |
REGRESS_PCT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Earnings Regression Flat Pct
Prompt Table:
PA_ALIAS_USE
|
| 9 |
PROJECTION_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Earnings Projection Method
N=Do Not Project
P=Project Using
Default Value: N
|
| 10 |
PROJECT_METHOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Projection Method Name
Prompt Table:
PA_PROJECTIONS
|
| 11 |
TERM_PROJECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Start Projection
A=Projection Method Amount
C=with Actual Current Year
P=with Prior Year
Default Value: C
|
| 12 |
ANNUALIZE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
by Method
D=Count Days
M=Count Months
|
| 13 |
LAG_REGRESSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Lag Year Regression Method
A=Use Alternative II Assumptions
F=Use a Flat Percentage
Default Value: A
|
| 14 |
LAG_PCT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Lag Year Regression Flat Pct
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 15 |
LAG_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Lag Year Regression Flat Pct
|
| 16 |
LAG_PCT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Lag Year Regression Flat Pct
Prompt Table:
PA_ALIAS_USE
|
| 17 |
COMMENCE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Commencement Option
A=Use Commencement Age
D=Use Commencement Date
N=Use Social Security NRA
Default Value: N
|
| 18 |
COMMENCE_AGE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Commencement
A=Alias Name
N=Numeric Constant
|
| 19 |
COMMENCE_AGE |
Number(3,0) |
SMALLINT NOT NULL |
Social Security Commencement
|
| 20 |
COMMENCE_AGE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Social Security Commencement
Prompt Table:
PA_DURATION
|
| 21 |
SS_COMMENCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Commencement
A=Alias Name
D=Date Constant
|
| 22 |
SS_COMMENCE_DT |
Date(10) |
DATE |
Social Security Commencement
|
| 23 |
SS_COMMENCE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Social Security Commencement
Prompt Table:
PA_DATE
|
| 24 |
EARN_CONSOLIDATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Earnings Consolidation
Prompt Table:
PA_PIA_EARNS_VW
|
| 25 |
PIA_EARN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
PIA Earnings type
C=Consolidated Earnings
F=FAE Earnings result
Default Value: C
|
| 26 |
EARLIEST_AGE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Earliest Age
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 27 |
EARLIEST_AGE |
Number(3,0) |
SMALLINT NOT NULL |
Earliest Age
|
| 28 |
EARLIEST_AGE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Earliest Age
Prompt Table:
PA_DURATION
|
| 29 |
LATEST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Latest Age Option
N=Use Latest Age
Y=Use Social Security NRA
Default Value: N
|
| 30 |
LATEST_AGE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Latest Age
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 31 |
LATEST_AGE |
Number(3,0) |
SMALLINT NOT NULL |
Latest Age
|
| 32 |
LATEST_AGE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Latest Age
Prompt Table:
PA_DURATION
|
| 33 |
DISABILITY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Entitlement Date Type
A=Alias Name
D=Date Constant
Default Value: D
|
| 34 |
DISABILITY_DT |
Date(10) |
DATE |
Entitlement Date
|
| 35 |
DISABILITY_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Entitlement date Alias
Prompt Table:
PA_DATE
|
| 36 |
EARLY_COMMENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Early Commence Reduction
Y/N Table Edit
Default Value: N
|
| 37 |
DEFERRED_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Deferred Retire Credit
Y/N Table Edit
Default Value: N
|
| 38 |
ATTAINED_AGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Disregard Attained Age Rule
Y/N Table Edit
Default Value: N
|
| 39 |
AGE_62_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Disregard Age 62 Entitle Rule
Y/N Table Edit
Default Value: N
|
| 40 |
REGRESS_PCT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type For Regress Pct
|
| 41 |
LAG_PCT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for Lag Pct
|
| 42 |
COMMENCE_AGE_ALIAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for Commence Age
|
| 43 |
SS_COMMENCE_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for SS Commence Dat
|
| 44 |
EARLIEST_AGE_ALIAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for Earliest Age
|
| 45 |
LATEST_AGE_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for Latest Age
|
| 46 |
DISABILITY_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias Type for Entitlement Dat
|
| 47 |
LAW_EFF_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Law in Effect Type
A=alias name
N=numeric constant
Default Value: N
|
| 48 |
LAW_EFF_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Law in Effect Year
|
| 49 |
LAW_EFF_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Law in Effect Alias
Prompt Table:
PA_ALIAS_USE
|
| 50 |
LAW_EFF_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Law in Effect Alias Type
|
| 51 |
TERM_REGRESSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Start Regression Using
A=1st Year Annualized
C=Actual 1st Year Amount
R=1st Year Annual Pay Rate
Default Value: C
|