Below is a table showing the layout of the standard extract generated by DB Precision as part of the standard extract. Below this table are 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
|
113
|
|
PIA Level Income Amount
|
Numeric
|
114
|
|
Estimated Prior Year Benefit Payments
|
Numeric
|
115
|
|
BenAmount_2 (supplemental)
|
Numeric
|
116
|
|
BenForm_2 (supplemental)
|
Coded
|
117
|
|
BenFracBoth_2 (supplemental)
|
Numeric
|
118
|
|
BenFracPart_2 (supplemental)
|
Numeric
|
119
|
|
BenFracCA_2 (supplemental)
|
Numeric
|
120
|
|
CertainPeriod_2 (supplemental)
|
Numeric
|
121
|
|
BenCertEndDate_2 (supplemental)
|
Date
|
122
|
|
ACD_2 (supplemental)
|
Date
|
123
|
|
BenStopDate_2 (supplemental)
|
Date
|
124
|
Details Regarding Specific Columns Above
Status Code (position 2); Prior Status (position 109)
| File Code
|
Label
|
|
|
|
|
0
|
Non-participating
|
|
1
|
Active
|
|
2
|
Active non-accruing
|
|
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
|
|
10
|
Joint Life with Popup
|
|
11
|
Joint and Last Survivor
|
|
12
|
Certain and Joint and Last Survivor
|
Benefit Type (position 105)
File Code
|
Label
|
|
|
|
|
0
|
Unknown
|
|
1
|
Retirement
|
|
2
|
Disability
|
|
3
|
Survivor
|
|
4
|
In-Service Distribution
|
|
5
|
401(k) Payout
|
|
6
|
403(b) Payout
|
| 7 |
Health Care Stipend |
|
8
|
QDRO
|
