Return to PSG Models documentation page

PENSIM output file .XSD

--- .XSD file contains cross-section survey statistics for each living
         resident cohort sample member, where the survey statistics are
         gathered at age XSD.xs_age if XSD.olc_mode is false, or at the
         age determined by XSD.olc_year and XSD.olc_moment if XSD.olc_mode
         is true.  The surveys that have a retrospective (i.e., prior year)
         supplement are conducted if the individual is a living resident
         during the prior year, while other surveys are conducted if the
         individual is a living resident at the time of the survey.
    IMPORTANT NOTE: If XSD.olc_mode is true, be sure to combine the
         many xsdNNNNN.YYY files into a single xsdNNNNN.all file using
         the xsall utility from the Windows command-line prompt in the 
         PENSIM database directory or by calling the xsall utility from
         a post-simulation tabulation script specified by the SSASIM
         RUN.tab_script input parameter.

The PENSIM runNNNNN.xsd file has no heading lines and no summary 
lines.  Individual survey results are written to a tab-delimited
file that has one row per person interview, making the survey
results file suitable for tabulating with an AWK program.

FORMAT OF INDIVIDUAL SINGLE-ROW RECORD:
( 1) scenario: (positive integer).
( 2) ind id: (positive integer).
( 3) ind age: (exact age in years at time of survey).
( 4) ind gender: 1=female, 0=male.
( 5) ind highest schooling: 0=never_in_high_school,  1=high_school_attended,
                            2=high_school_completed, 3=college_attended,
                            4=four_year_college_degree_or_graduate_degree.
( 6) employment status: 0=not-employed, 1=employed.
( 7) immigration-age-emigration-age-code where code=((100+iage)*1000)+eage,
     where iage (immigration age) and eage (emigration age) are coded as in
     the PENSIM .cov and GEMINI .sum output files, which means, for example,
     a native-born individual who never emigrates has a code of 100999, 
     and a foreign-born individual who immigrates at age 25 and emigrates
     at age 29 has a code of 125029.
------------------------------------------------------------------------------
END OF CORE SURVEY QUESTIONS
------------------------------------------------------------------------------
SUPPLEMENT is determined by specified value of XSD.supplement input parameter
------------------------------------------------------------------------------
++++ NON-RETROSPECTIVE SUPPLEMENT 1 QUESTIONS for EMPLOYED individuals:
---------------------------------------------     ^^^^^^^^
++++ the basic DB and DC pension supplement:
( 8) part-time: 0=full-time, 1=part-time job.
( 9) nominal monthly earnings: (dollars per month).
(10) relative earnings: annualized nominal monthly earnings divided by AWI.
(11) unionized: 0=no, 1=yes.
(12) employer industry: 0..9 (one-digit SIC code).
(13) employer size: 1=less than 25 employees, 2=25-99 employees,
                    3=at least 100 employees.
(14) employer sponsors BLS-style pension: 0=no, 1=yes. (See notes below.)
(15) job-sponsored current DB plan type: 0=none, 1=career_earnings,
                    2=cash_account, 3=dollar_amount, 4=terminal_earnings.
                    Note: 1-4 are BLS-style DB pensions.
(16) job-sponsored current DC plan type: 0=none, 1=money_purchase, 
                    2=profit_sharing, 3=savings_thrift, 4=savings_thrift_zm,
                    5=automatic_ira.
                    Note: 1-3 are BLS-style DC pensions.
(17) current DC plan is pretax-salary-reduction plan: 0=no, 1=yes.
(18) eligible for current DB plan: 0=no, 1=yes (even if plan is frozen).
(19) eligible for current DC plan: 0=no, 1=yes [see (20) below].
(20) age at current DC plan eligibility: (exact eligibility age in years).
(21) participates in current DC plan: 0=no, 1=yes [see (41) below].
(22) active participant in current DC plan: 0=no, 1=yes [see (42) below].
(23) prior year employee contribution percent in current DC plan.
(24) prior year employer contribution percent in current DC plan.
(25) real prior year employee contribution in cur DC plan (COHORT.cpi_year $K).
(26) real prior year employer contribution in cur DC plan (COHORT.cpi_year $K).
(27) real prior year company-stock balance in cur DC plan (COHORT.cpi_year $K).
(28) real prior year individ-stock balance in cur DC plan (COHORT.cpi_year $K).
(29) real prior year MMfund balance in current DC plan (COHORT.cpi_year $K).
(30) real prior year GBfund balance in current DC plan (COHORT.cpi_year $K).
(31) real prior year EIfund balance in current DC plan (COHORT.cpi_year $K).
(32) real prior year DEfund balance in current DC plan (COHORT.cpi_year $K).
(33) real prior year TDfund balance in current DC plan (COHORT.cpi_year $K).
(34) real prior year SVfund balance in current DC plan (COHORT.cpi_year $K).
(35) real prior year GRfund balance in current DC plan (COHORT.cpi_year $K).
(36) real cumulative account returns in DC plan (COHORT.cpi_year $K).
(37) participation probability at DC eligibility (in percent).
(38) DC plan has automatic-enrollment: 0=no, 1=yes.
(39) current DC/ST plan employer match rate percent (er matching of ee contrib)
           in plan description even if there is a temporary match suspension.
(40) current DC/ST plan employer match upto percent (er matching of ee contrib)
           in plan description even if there is a temporary match suspension.
(41) age at current DC plan participation (exact part age in years).
(42) age at current DC plan active participation (exact actpart age in years).
(43) prior year employee current DC plan contribution (eec) limitation code:
                    0=no_eec_limitation,
                    1=eec_limited_by_plan_rules,
                    2=eec_limited_by_govt_rules (or by both plan and govt).
(44) deferred annuity contract units owned by individual at time of survey.
(45) current job duration (in years) [incomplete job spell].
(46) prior year employee current DC plan contribution is zero but was positive
                    in the year before that: 0=no, 1=yes.
(47) vested in current DB plan: 0=no, 1=yes [all DB plans have cliff vesting].
(48) years cur DB plan has been frozen (0 implies no DB plan or DB not frozen).
(49) current DB plan is frozen hard (not soft): 0=no, 1=yes
                    [valid only if (48)>0].
(50) no BLS-style DC plan offered after freeze of cur DB-only plan: 0=no, 1=yes
                    [valid only if (48)>0].
------------------------------------------------------------------------------
++++ RETROSPECTIVE SUPPLEMENT 2 QUESTIONS for ALL individuals:
-----------------------------------------     ^^^
++++ the annual earnings versus maximum taxable earnings (MTE) supplement:
( 8) annual earnings in prior year as percent of prior year MTE.
( 9) earnings above MTE in year before prior year: 0=no, 1=yes.
------------------------------------------------------------------------------
++++ RETROSPECTIVE SUPPLEMENT 3 QUESTIONS for ALL individuals:
-----------------------------------------     ^^^
++++ the DC-rollover-retrospective supplement:
( 8) age at "recent" job ending (exact in years)("recent" means in past year).
     NOTE: only job endings not associated with death, retirement or disability
           are included in this survey supplement; if individual experiences
           more than one job ending in past year, only the first is included in
           this survey supplement; only job endings with DC job-coverage are
           included in this survey supplement.
( 9) duration of job that is ending (exact number of years).
(10) annualized monthly earnings at job end (expressed as percent of job-ending
                                             average wage index, AWI).
(11) industry of job that is ending (sic 0..9 with 9=govt-sector).
(12) pctage vested balance at job ending (expressed as percent of job-end AWI).
(13) dollar vested balance at job ending (expressed in COHORT.cpi_year $K).
(14) rollover decision: 1=yes(rollover), 0=no(zero-vested-balance-or-cashout)
(15) job-sponsored DC plan type: 0=none, 1=money_purchase, 
                    2=profit_sharing, 3=savings_thrift, 4=savings_thrift_zm,
                    5=automatic_ira.
------------------------------------------------------------------------------
++++ RETROSPECTIVE SUPPLEMENT 4 QUESTIONS for ALL individuals:
-----------------------------------------     ^^^
++++ the pension-vesting-retrospective supplement:
( 8) age at "recent" job ending (exact in years)("recent" means in past year).
     NOTE: all "recent" job endings are included in this survey supplement,
           but if individual experiences more than one job ending in past year,
           only the first is included in this survey supplement.
( 9) duration of job that is ending (exact number of years).
(10) annualized monthly earnings at job end (expressed as percent of job-ending
                                             average wage index, AWI).
(11) industry of job that is ending (sic 0..9 with 9=govt-sector).
(12) employer sponsors BLS-style pension: 0=no, 1=yes. (See notes below.)
(13) job-sponsored DB plan type: 0=none, 1=career_earnings,
                    2=cash_account, 3=dollar_amount, 4=terminal_earnings.
                    Note: 1-4 are BLS-style DB pensions.
(14) job-sponsored DC plan type: 0=none, 1=money_purchase, 
                    2=profit_sharing, 3=savings_thrift, 4=savings_thrift_zm,
                    5=automatic_ira.
                    Note: 1-3 are BLS-style DC pensions.
(15) eligible for DB plan: 0=no, 1=yes.
(16) eligible for DC plan: 0=no, 1=yes.
(17) age at DB plan eligibility: (exact age in years; zero if not eligible).
(18) age at DC plan eligibility: (exact age in years; zero if not eligible).
(19) percentage vested in DB plan at job ending.
(20) percentage vested in DC plan at job ending.
------------------------------------------------------------------------------
++++ RETROSPECTIVE SUPPLEMENT 5 QUESTIONS for ALL individuals:
-----------------------------------------     ^^^
++++ the CPS-style prior-year-retrospective supplement:
NOTE that 'annuity' in this supplement refers to an immediate annuity
( 8) annual earnings ($K) from all jobs held in calendar year before survey.
( 9) annuity price paid in calendar year before survey (0.0 ==> no purchase).
(10) annuity contract survivor percent (0 ==> single-life annuity or no purch).
(11) spouse age at annuity purchase (0 ==> no spouse or no purchase).
(12) nominal annual amount of saver's credit (s.c.) paid to individual ($K).
(13) real amount of (12) (COHORT.cpi_year $K).
(14) sum of real s.c. paid to individual thru this age (COHORT.cpi_year $K).
(15) s.c. take-up probability (-1.0 ==> ineligible for s.c.).
(16) nominal annual AGI of individual's tax filing unit ($K).
(17) relative life expectancy (rle) used in annuity balance fraction calcs.
(18) annuity purchase balance fraction (after rle adjustment).
(19) age, student-status, and AGI eligible for s.c. (0=no, 1=yes).
(20) positive income tax liability before s.c. (0=no, 1=yes).
(21) income tax filing status:
       -1 = not a tax unit because is a dependent on another tax return,
        0 = single (apply unit weight in income tax tabulations),
        1 = married filing jointly (apply half weight in tabulations),
        2 = head of household (apply unit weight in tabulations).
     The parenthetical statements above are instructions about
     how to tabulate aggregate tax-return statistics from a PENSIM
     cross-sectional sample of individuals; failing to apply a
     one-half (0.5) weight to individuals who file jointly will result
     in the double counting of joint tax units.
     NOTE: when tabulating income tax statistics, remember that
           PENSIM does not simulate cohorts born before 1935.
(22) nominal annual EITC of individual's tax filing unit ($K).
(23) number of EITC-qualified kids in individual's tax filing unit.
(24) elderly tax unit with at least one person age 65+ (0=no, 1=yes).
(25) tax unit is nonfiler (0=no, 1=yes).
     NOTE: can be nonfiler because of -1 filing status or low income.
     IMPORTANT NOTE: ignore any non-zero tax statistics for a nonfiler.
(26) nominal annual income tax liability of individual's tax filing unit ($K).
(27) nominal annual savers credit paid to individual's tax filing unit ($K).
------------------------------------------------------------------------------
++++ NON-RETROSPECTIVE SUPPLEMENT 6 QUESTIONS for ALL individuals:
---------------------------------------------     ^^^
++++ the SCF-style family account-balance and DC-plan-participation supplement:
( 8) family head age: (exact age in years at time of survey).
     NOTE: all resident individuals alive are surveyed, so be sure to remove
           young individuals (who presumably would not be living alone or with
           a spouse) from your tabulations to make the sample comparable to 
           the family sample drawn for the Survey of Consumer Finances (SCF).
( 9) family head gender: 1=female, 0=male.
(10) head highest schooling: 0=never_in_high_school,  1=high_school_attended,
                             2=high_school_completed, 3=college_attended,
                             4=four_year_college_degree_or_graduate_degree.
(11) family head employment status: 0=not-employed, 1=employed.
(12) f. "has" a DB or DC pension from current or past employer: 0=no, 1=yes.
(13) f. participates in DC plan from current employer: 0=no, 1=yes.
(14) f. current DC balance total (nominal $K at end of prior calendar year).
(15) f. rollover account balance (nominal $K at end of prior calendar year).
(16) family currently receives traditional DB pension benefit: 0=no, 1=yes.
------------------------------------------------------------------------------
++++ NON-RETROSPECTIVE SUPPLEMENT 7 QUESTIONS for EMPLOYED individuals:
---------------------------------------------     ^^^^^^^^
++++ the DB plan normal (i.e., unreduced) benefit eligibility supplement:
( 8) part-time: 0=full-time, 1=part-time job.
( 9) nominal monthly earnings: (dollars per month).
(10) relative earnings: annualized nominal monthly earnings divided by AWI.
(11) unionized: 0=no, 1=yes.
(12) employer industry: 0..9 (one-digit SIC code).
(13) employer size: 1=less than 25 employees, 2=25-99 employees,
                    3=at least 100 employees.
(14) job-sponsored DB plan type: 0=none, 1=career_earnings,
                    2=cash_account, 3=dollar_amount, 4=terminal_earnings.
(15) eligible for job-sponsored DB plan: 0=no, 1=yes.
(16) eligible now for non-reduced (normal) DB benefits: 0=no, 1=yes.
(17) eligible a year ago for non-reduced (normal) DB benefits: 0=no, 1=yes.
(18) current job duration (in years) [incomplete job spell].
------------------------------------------------------------------------------
++++ NON-RETROSPECTIVE SUPPLEMENT 8 QUESTIONS for EMPLOYED individuals:
---------------------------------------------     ^^^^^^^^
++++ nominal DC pension balance supplement:
( 8) part-time: 0=full-time, 1=part-time job.
( 9) nominal monthly earnings: (dollars per month).
(10) relative earnings: annualized nominal monthly earnings divided by AWI.
(11) unionized: 0=no, 1=yes.
(12) employer industry: 0..9 (one-digit SIC code).
(13) employer size: 1=less than 25 employees, 2=25-99 employees,
                    3=at least 100 employees.
(14) employer sponsors BLS-style pension: 0=no, 1=yes. (See notes below.)
(15) job-sponsored DB plan type: 0=none, 1=career_earnings,
                    2=cash_account, 3=dollar_amount, 4=terminal_earnings.
                    Note: 1-4 are BLS-style DB pensions.
(16) job-sponsored DC plan type: 0=none, 1=money_purchase, 
                    2=profit_sharing, 3=savings_thrift, 4=savings_thrift_zm,
                    5=automatic_ira.
                    Note: 1-3 are BLS-style DC pensions.
(17) DC plan is pretax-salary-reduction plan: 0=no, 1=yes.
(18) eligible for DB plan: 0=no, 1=yes (even if plan is frozen).
(19) eligible for DC plan: 0=no, 1=yes.
(20) age at DC plan eligibility: (exact eligibility age in years).
(21) participates in DC plan: 0=no, 1=yes.
(22) nominal DC plan balance (in thousands of current year dollars).
(23) current job duration (in years) [incomplete job spell].
------------------------------------------------------------------------------