Valuation Extract Layout
Below is a table showing the layout of the standard extract generated by DB Precision as part of the standard extract. Below this table is additional tables that show a description of values for specific columns such as gender and payment forms.

Field Type Position
     
SSN S.S.Num. 1
StatusCode Coded 2
NameLast Character 3
NameFirst Character 4
NameMiddle Character 5
Sex Coded 6
SexCA Coded 7
DOB Date 8
DOBCA Date 9
DOH Date 10
DOT Date 11
NRD Date 12
ServiceCred Numeric 13
ServiceVest Numeric 14
ServicePart Numeric 15
BenAmount Numeric 16
BenForm Coded 17
BenFracBoth Numeric 18
BenFracPart Numeric 19
BenFracCA Numeric 20
CertainPeriod Numeric 21
BenCertEndDate Date 22
ACD Date 23
BenStopDate Date 24
SALARY Numeric 25
SALARY_PRIOR_01 Numeric 26
SALARY_PRIOR_02 Numeric 27
SALARY_PRIOR_03 Numeric 28
SALARY_PRIOR_04 Numeric 29
SALARY_PRIOR_05 Numeric 30
SALARY_PRIOR_06 Numeric 31
SALARY_PRIOR_07 Numeric 32
SALARY_PRIOR_08 Numeric 33
SALARY_PRIOR_09 Numeric 34
SALARY_PRIOR_10 Numeric 35
SALARY_PRIOR_11 Numeric 36
SALARY_PRIOR_12 Numeric 37
SALARY_PRIOR_13 Numeric 38
SALARY_PRIOR_14 Numeric 39
SALARY_PRIOR_15 Numeric 40
SALARY_PRIOR_16 Numeric 41
SALARY_PRIOR_17 Numeric 42
SALARY_PRIOR_18 Numeric 43
SALARY_PRIOR_19 Numeric 44
SALARY_PRIOR_20 Numeric 45
SALARY_PRIOR_21 Numeric 46
SALARY_PRIOR_22 Numeric 47
SALARY_PRIOR_23 Numeric 48
SALARY_PRIOR_24 Numeric 49
SALARY_PRIOR_25 Numeric 50
SALARY_PRIOR_26 Numeric 51
SALARY_PRIOR_27 Numeric 52
SALARY_PRIOR_28 Numeric 53
SALARY_PRIOR_29 Numeric 54
SALARY_PRIOR_30 Numeric 55
SALARY_PRIOR_31 Numeric 56
SALARY_PRIOR_32 Numeric 57
SALARY_PRIOR_33 Numeric 58
SALARY_PRIOR_34 Numeric 59
SALARY_PRIOR_35 Numeric 60
SALARY_PRIOR_36 Numeric 61
SALARY_PRIOR_37 Numeric 62
SALARY_PRIOR_38 Numeric 63
SALARY_PRIOR_39 Numeric 64
RPTAMT_01 Numeric 65
RPTAMT_02 Numeric 66
RPTAMT_03 Numeric 67
RPTAMT_04 Numeric 68
RPTAMT_05 Numeric 69
RPTAMT_06 Numeric 70
RPTAMT_07 Numeric 71
RPTAMT_08 Numeric 72
RPTAMT_09 Numeric 73
RPTAMT_10 Numeric 74
RPTAMT_11 Numeric 75
RPTAMT_12 Numeric 76
RPTAMT_13 Numeric 77
RPTAMT_14 Numeric 78
RPTAMT_15 Numeric 79
RPTAMT_16 Numeric 80
RPTAMT_17 Numeric 81
RPTAMT_18 Numeric 82
RPTAMT_19 Numeric 83
RPTAMT_20 Numeric 84
MISCAMT_01 Numeric 85
MISCAMT_02 Numeric 86
MISCAMT_03 Numeric 87
MISCAMT_04 Numeric 88
MISCAMT_05 Numeric 89
MISCAMT_06 Numeric 90
MISCAMT_07 Numeric 91
MISCAMT_08 Numeric 92
MISCAMT_09 Numeric 93
MISCAMT_10 Numeric 94
MISCAMT_11 Numeric 95
MISCAMT_12 Numeric 96
MISCAMT_13 Numeric 97
MISCAMT_14 Numeric 98
MISCAMT_15 Numeric 99
MISCAMT_16 Numeric 100
MISCAMT_17 Numeric 101
MISCAMT_18 Numeric 102
MISCAMT_19 Numeric 103
MISCAMT_20 Numeric 104
Benefit Type Numeric 105
Credited Service Start Date Date 106
Vesting Service Start Date Date 107
Date of Participation Date 108
Prior Status Numeric 109
Date of Death Date 110
True SSN Numeric 111
CA SSN Numeric 112
PIA Level Income Date Date 112
PIA Level Income Amount Numeric 113


Details Regarding Specific Columns Above Status Code (position 2); Prior Status (position 109)
File Code Label
   
0 Non-participating
1 Active
2 Inactive
3 Terminated Vested
4 Disabled
5 Retired
6 Survivor
7 Non-vested Termination
8 Lump Sum Cash-Out
9 Death
10 Active (Hired on Val Date)


Sex/SexCA (position 6 and 7)

File Code
Label
   
M Male
F Female


BenForm (position 17)

File Code
Label
   
1  Life Annuity
2  Joint Life Annuity
3  Certain Only Annuity
4  Certain & Life Annuity
5  Certain & Joint Life Annuity
6  Life Insurance
7  Lump Sum (not contingent)
8  Lump Sum (life contingent)
9  PIA Level Income


Benefit Type (position 105)

File Code
Label
   
0  Unknown
1  Retirement
2  Disability
3  Survivor
4  Minimum Distribution
5  401(k) Payout
6  403(b) Payout
7  Health Care Stipend
8  QDRO
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com