| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
|
| 2 |
CALC_SEQ_NUM |
Number(9,0) |
DECIMAL(9) NOT NULL |
Calc Seq Num
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 4 |
LIST_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Name of group of employees
Prompt Table:
PA_CLC_GRP_VW
|
| 5 |
GROUP_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Group Name
Prompt Table:
PA_CLC_CUSTM_VW
|
| 6 |
DEPENDENT_BENEF |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default
|
| 7 |
REL_CALC_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Related Calc Name
Prompt Table:
PA_CALCULATION
|
| 8 |
REL_CALC_BEN_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Related Calc Benefit Percent
|
| 9 |
CUSTOM_STMT_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Custom Statement Name
Prompt Table:
PA_CLC_CUSTM_VW
|
| 10 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 11 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 12 |
CALCULATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Type
G=Pre-defined Group
I=Individual
L=Pre-defined List
Default Value: I
|
| 13 |
CALC_PURPOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Purpose
B=Beneficiary Payment Forms
Q=QDRO Recipient Payment Forms
R=Regular Calculation
T=Term Vested Payment Forms
Default Value: R
|
| 14 |
CALC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Protection Reason
C=Final Calculation Candidate
E=Estimate Calculation
F=Final Calculation
O=Other
P=Related Primary Calculation
Q=QDRO Recipient Candidate
Default Value: E
|
| 15 |
CALC_TS |
DateTime(26) |
TIMESTAMP |
Calculation Timestamp
|
| 16 |
CALC_RUN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc Run Status
Default Value: N
|
| 17 |
CALC_EXEC_TS |
DateTime(26) |
TIMESTAMP |
Calc Execution Timestamp
|
| 18 |
EVENT_DT |
Date(10) |
DATE |
Event Date
|
| 19 |
CALC_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Calculation Reason Code
DEF=TV-Deferred Pymt
DIS=Disability
DTH=Death
QDR=QDRO Alternate Payee
RET=Retirement
TER=TV-Immediate Pymt
WEB=Web Estimate
|
| 20 |
ASOFDATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 21 |
CALC_ARCH_DEL_DT |
Date(10) |
DATE |
Archive/Delete Dt
|
| 22 |
CALC_ARCH_DEL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Protect Calculation
Y/N Table Edit
Default Value: Y
|
| 23 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 24 |
SS_PIA_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc Soc Sec PIA
Y/N Table Edit
Default Value: N
|
| 25 |
SSPIA_RESULT_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Function Result Name
Prompt Table:
PA_SSPIA_FR_VW
|
| 26 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 27 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 28 |
SPOUSE_BIRTHDATE |
Date(10) |
DATE |
Spouse Birth Date
|
| 29 |
CALC_ALL_PLANS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate All Plans
Y/N Table Edit
Default Value: Y
|
| 30 |
VERBOSE_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Detailed Worksheet
Y/N Table Edit
Default Value: Y
|
| 31 |
EXT_EMPL_DATA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Load External Employee Data
Default Value: N
|
| 32 |
DELETE_EXIST_RSLTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Existing Results
Y/N Table Edit
Default Value: Y
|
| 33 |
ADD_YRS_TO_AGE |
Number(2,0) |
SMALLINT NOT NULL |
Number of Years added to Age
|
| 34 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 35 |
PA_SVC_RESTORE |
Character(1) |
VARCHAR2(1) NOT NULL |
Grant Full Service Credit
Y/N Table Edit
Default Value: N
|
| 36 |
EARN_ASSUMP_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Earnings Amount
|
| 37 |
HRS_ASSMP_AMT |
Number(4,0) |
SMALLINT NOT NULL |
Hours Amount
|
| 38 |
WAGE_BASE_ESCAL_RT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Wage Base Escalation Rate
|
| 39 |
SALSC_ASMP_INC_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Salary Scale Percent Increase
|
| 40 |
CPI_ASMP_INC_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
CPI Percent Increase
|
| 41 |
EVENT_AGE |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Event Age(YY.MM)
|
| 42 |
EVENT_DT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Event Date Alias
Prompt Table:
PA_DTDB_ALS_VW
|
| 43 |
EVENT_DT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Event Age Alias Type
|
| 44 |
BEN_STMT_DT |
Date(10) |
DATE |
Benefit Statement Date
|
| 45 |
BEN_CMDT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Benefit Commencement Dt Alias
Prompt Table:
PA_DTDB_ALS_VW
|
| 46 |
BEN_CMDT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Ben Com Dt Alias Type
|
| 47 |
BEN_CMDT_DATE |
Date(10) |
DATE |
Benefit Commencement Date
|