Return to PSG Models documentation page

PENSIM input table ASSETS

Parent table for pension-related asset tables.

Parent table is: RUN

Child table is: CSTOCK

Child table is: TDF_AA

Child table is: DACCHAR

Go to PENSIM input parameters overview

PENSIM:   ASSETS . id
Identifies assets characteristics specified on this row of table, so id value should be unique.

Valid values: 1 to 999999999, Integer

PENSIM:   ASSETS . notes
Describes specification of table row in free-form note.

Valid values: any ASCII text, Memo (Note: do not copy and paste from a word processor because of the possibility of embedded non-ASCII characters.)

PENSIM:   ASSETS . cstock_id
Points to a row in the child CSTOCK table, which specifies the characteristics of different corporate equity asset classes.

Valid values: 1 to 999999999, Integer

PENSIM:   ASSETS . mmf_fee_jb
Specifies the money-market-fund management fee in basis points when fund is held in a job-based pension account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . mmf_fee_ro
Specifies the money-market-fund management fee in basis points when fund is held in a rollover account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . gbf_fee_jb
Specifies the government-bond-fund management fee in basis points when fund is held in a job-based pension account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . gbf_fee_ro
Specifies the government-bond-fund management fee in basis points when fund is held in a rollover account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . eif_fee_jb
Specifies the equity-index-fund management fee in basis points when fund is held in a job-based pension account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . eif_fee_ro
Specifies the equity-index-fund management fee in basis points when fund is held in a rollover account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . def_fee_jb
Specifies the diversified-equity-fund management fee in basis points when fund is held in a job-based pension account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . def_fee_ro
Specifies the diversified-equity-fund management fee in basis points when fund is held in a rollover account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . tdf_fee_jb
Specifies the target-date-fund management fee in basis points when fund is held in a job-based pension account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . tdf_fee_ro
Specifies the target-date-fund management fee in basis points when fund is held in a rollover account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . tdf_aa_id
Points to a row in the child TDF_AA table, which specifies the age-specific asset allocations of the target-date-fund asset.

Valid values: 1 to 999999999, Integer

PENSIM:   ASSETS . svf_spd_bp
Specifies the assumed stable-value-fund gross asset return spread over Treasury bills in basis points.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . svf_fee_jb
Specifies the stable-value-fund management fee in basis points when fund is held in a job-based pension account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . svf_fee_ro
Specifies the stable-value-fund management fee in basis points when fund is held in a rollover account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . grf_rorpct
Specifies the assumed pre-fee real rate of return provided by the guaranteed-return fund. The pre-fee nominal rate of return (expressed in decimal rather than percentage terms) for a calendar year equals (1+R/100)*(1+I/100)-1, where R denotes grf_rorpct and I denotes the percentage inflation rate for that calendar year.

Valid values: 0.0 to 10.0, Real

PENSIM:   ASSETS . grf_fee_jb
Specifies the guaranteed-return-fund management fee in basis points when fund is held in a job-based pension account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . grf_fee_ro
Specifies the guaranteed-return-fund management fee in basis points when fund is held in a rollover account.

Valid values: any non-negative value, Integer

PENSIM:   ASSETS . dacchar_id
Points to a row in the child DACCHAR table, which specifies the characteristics of the deferred annuity contract.

Valid values: 1 to 999999999, Integer