| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CUSTOM_STMT_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Custom Statement Name
|
| 2 |
MAR_FORM_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Married form code
Default Value: LIFE
Prompt Table:
PA_DFN_FORM_CD
|
| 3 |
SIN_FORM_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Single Form code
Default Value: LIFE
Prompt Table:
PA_DFN_FORM_CD
|
| 4 |
MAR_YRS_CERT |
Number(2,0) |
SMALLINT NOT NULL |
Married Years Certainty
Default Value: 0
|
| 5 |
SIN_YRS_CERT |
Number(2,0) |
SMALLINT NOT NULL |
Single Years Certainty
Default Value: 0
|
| 6 |
MAR_PCT_CONTD |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Married Percentage Continued
Default Value: 0
|
| 7 |
SIN_PCT_CONTD |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Single Percentage Continued
Default Value: 0
|
| 8 |
BEN_CMDT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ben Commencement Date Type
A=Alias Name
D=Date Constant
Default Value: A
|
| 9 |
BEN_CMDT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Benefit Commencement Dt Alias
Prompt Table:
PA_DTDB_ALS_VW
|
| 10 |
BEN_CMDT_DATE |
Date(10) |
DATE |
Benefit Commencement Date
|
| 11 |
PYMT_FREQ |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Frequency
0=One Time Payment
1=Annual Payment
12=Monthly Payment
2=Semi-Annual
24=Semi-Monthly Payment
26=BiWeekly Payment
4=Quarterly
Default Value: 12
|
| 12 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 13 |
PYMT_FREQ_NM |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Frequency Name
ANN=Annual (1)
BWK=Bi-Weekly (26)
LUMP=Lump Sum (Single)
MTH=Monthly (12)
QTR=Quarterly (4)
SANN=Semi-Annual (2)
SMTH=Semi_monthly (24)
Default Value: MTH
|
| 14 |
PA_SS_AUTOBEN_PCT |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Automatic Benefit for Survivor
|