REPORTING.TRANS_ACTY_FACT
PARTCPNT_KEY INTEGER 4 No
PLAN_SRC_KEY INTEGER 4 No
PLAN_ASSET_KEY INTEGER 4 No
PROCS_DT_KEY INTEGER 4 No
TRADE_DT_KEY INTEGER 4 No
TRANS_CD_ACTY_KEY INTEGER 4 No
TRANS_SEQ_NUM INTEGER 4 No
TRANS_ACTY_AMT DECIMAL 13 No
UNIT_SHARE_CNT DECIMAL 15 No
PAY_PER_END_DT DATE 4 Yes
RPT_DT DATE 4 No
UNIT_SHARE_COST_AMT DECIMAL 11 Yes
POST_NUM CHARACTER 5 Yes
INKIND_EVNT_IND CHARACTER 1 Yes
TRADE_DT DATE 4 Yes
UNINVESTED_CSH_AMT DECIMAL 13 No
UNIVL_PLAN_ID BIGINT 8 Yes
LAST_ACTY_DTM TIMESTAMP 10 No
CHK_DT DATE 4 Yes
REPORTING.TRANS_CD_ACTY_DIM
TRANS_CD_ACTY_KEY INTEGER 4 No
TRANS_CD_ACTY_DESC VARCHAR 200 No
TRANS_CD CHARACTER 3 No
TRANS_CD_DESC VARCHAR 100 No
TRANS_ACTY_CD CHARACTER 3 No
TRANS_ACTY_DESC VARCHAR 100 No
USG_CD CHARACTER 4 Yes
TRANS_OPER_ID CHARACTER 15 Yes
FACT_TBNAME VARCHAR 30 Yes
TRANS_CD_ACTY_CD_CMMNT VARCHAR 100 Yes
RCD_EFF_DT DATE 4 No
RCD_END_DT DATE 4 No
ACTV_RCD_IND CHARACTER 1 No
RCD_DEL_IND CHARACTER 1 No
DW_VIEW VARCHAR 30 Yes
USG_CD_DESC VARCHAR 50 Yes
TRANS_CD_ACTY_REF_ID INTEGER 4 No
DC_PLAN_NUM CHARACTER 6 Yes
SSN CHARACTER 9 Yes
LOAN_IND CHARACTER 1 Yes
TRANS_RULE_CD CHARACTER 2 Yes
TRANS_TY_TIER1_CD CHARACTER 2 Yes
TRANS_TY_TIER1_CD_DESC VARCHAR 30 Yes
TRANS_TY_TIER2_CD CHARACTER 2 Yes
TRANS_TY_TIER2_CD_DESC VARCHAR 30 Yes
TRANS_TY_TIER3_CD CHARACTER 1 Yes
TRANS_TY_TIER3_CD_DESC VARCHAR 30 Yes
USG_CODE1_POS1_CD CHARACTER 1 Yes
USG_CODE2_POS1_CD CHARACTER 1 Yes
USG_CODE3_POS1_CD CHARACTER 1 Yes
USG_CODE3_POS2_CD CHARACTER 1 Yes
USG_CODE3_POS3_CD CHARACTER 1 Yes
USG_CODE4_POS1_CD CHARACTER 1 Yes
USG_CODE4_POS2_CD CHARACTER 1 Yes
USG_CODE4_POS3_CD CHARACTER 1 Yes
USG_CODE4_POS4_CD CHARACTER 1 Yes
USG_CODE5_POS1_CD CHARACTER 1 Yes
DERVD_BILL_ITEM_USG_3_CD CHARACTER 3 Yes
REPORTING.UNIVL_PLAN_DIM
UNIVL_PLAN_KEY INTEGER 4 No
UNIVL_PLAN_DIM_EFF_DTM TIMESTAMP 10 No
UNIVL_PLAN_ID BIGINT 8 No
UNIVL_PLAN_NM VARCHAR 255 No
UNIVL_ORGANZTN_ID BIGINT 8 No
PRODT_CD CHARACTER 2 No
PRODT_DESC VARCHAR 50 No
PRODT_FAM_CD CHARACTER 2 No
PRODT_FAM_DESC VARCHAR 50 Yes
PLAN_NUM CHARACTER 6 Yes
SUBPLAN_NUM CHARACTER 6 Yes
CNTRCT_NUM CHARACTER 5 Yes
CNTRCT_SFX CHARACTER 1 Yes
DIV_NUM CHARACTER 3 No
UNIVL_PLAN_INCEP_DT DATE 4 No
UNIVL_PLAN_YR CHARACTER 4 No
UNIVL_PLAN_YR_EFF_DT DATE 4 No
UNIVL_PLAN_STAT_CD CHARACTER 1 No
UNIVL_PLAN_STAT_EFF_DT DATE 4 No
UNIVL_PLAN_EFF_DT DATE 4 No
AC_PLAN_ID INTEGER 4 Yes
RSO_PLAN_ID CHARACTER 17 Yes
MULTI_ER_IND CHARACTER 1 Yes
DATA_SRC_SYS_CD CHARACTER 8 No
UNIVL_PLAN_CONVRN_DT DATE 4 Yes
UNIVL_PLAN_CONVRN_SRC_CD CHARACTER 8 Yes
PRMPT_NM CHARACTER 5 Yes
CLIENT_KEY INTEGER 4 No
RCD_EFF_DT DATE 4 No
RCD_END_DT DATE 4 No
ACTV_RCD_IND CHARACTER 1 No
CLIENT_CONSLTNT_NM VARCHAR 50 Yes
RCD_DEL_IND CHARACTER 1 No
UNIVL_PLAN_CONVRN_SRC_CD_NM VARCHAR 30 Yes
DATA_SRC_SYS_CD_NM VARCHAR 30 Yes
GRACE_PER_NUM_DAY_AMT INTEGER 4 No
DEFLT_PER_AMT INTEGER 4 No
TAFT_HRTLY_IND CHARACTER 1 Yes
UNIVL_PLAN_TERMN_DT DATE 4 Yes
OMNIBUS_ACCT_ID CHARACTER 20 Yes
UNIVL_PLAN_YR_END_DT DATE 4 Yes
FRST_ST_ADDR_LN VARCHAR 40 Yes
SEC_ST_ADDR_LN VARCHAR 40 Yes
THRD_ST_ADDR_LN VARCHAR 40 Yes
FRTH_ST_ADDR_LN VARCHAR 40 Yes
CITY_NM VARCHAR 28 Yes
STE_CD CHARACTER 2 Yes
ZIP_CD CHARACTER 5 Yes
ZIP_CD_SFX CHARACTER 4 Yes
FRGN_POSTL_CD CHARACTER 14 Yes
REGN_PROVINCE_NM VARCHAR 30 Yes
CNTRY_CD CHARACTER 4 Yes
GOALMKR_OFFRD_IND CHARACTER 1 Yes
IFX_OFFRD_IND CHARACTER 1 Yes
DC_SVC_CNTRCT_NUM CHARACTER 7 Yes
DC_SVC_DIV_NUM CHARACTER 3 Yes
UPD_DT DATE 4 Yes
TYPE_IND CHARACTER 1 Yes
AUTOENRL_IND CHARACTER 1 Yes
ALW_GOALMKR_AGE_IND CHARACTER 1 Yes
ER_TY_CD CHARACTER 2 Yes
ER_TY_CD_DESC VARCHAR 30 Yes
VESTED_YRS_OF_SVC_HRS_NUM INTEGER 4 Yes
REPORTING.PLAN_ASSET_DIM
PLAN_ASSET_KEY INTEGER 4 No
PLAN_ASSET_EFF_DTM TIMESTAMP 10 No
PLAN_NUM CHARACTER 6 Yes
PLAN_ASSET_NM VARCHAR 60 No
CUSIP_NUM VARCHAR 15 No
FUND_INVST CHARACTER 2 Yes
CO_STOCK_IND CHARACTER 1 No
UNIVL_PLAN_ID BIGINT 8 No
ASSET_KEY INTEGER 4 No
UNIVL_PLAN_KEY INTEGER 4 No
RCD_EFF_DT DATE 4 No
RCD_END_DT DATE 4 No
ACTV_RCD_IND CHARACTER 1 No
RCD_DEL_IND CHARACTER 1 No
G_ACCT_ID CHARACTER 3 No
G_CNTRCT_ID CHARACTER 21 No
G_CNTRCT_ID_DT DATE 4 Yes
PLAN_ASSET_STAT_CD CHARACTER 2 Yes
PLAN_ASSET_STAT_CD_DT DATE 4 Yes
UPD_DT DATE 4 Yes
TYPE_IND CHARACTER 1 Yes
REPORTING.PARTCPNT_DIM
PARTCPNT_KEY INTEGER 4 No
PARTCPNT_DIM_EFF_DTM TIMESTAMP 10 No
UNIVL_CUST_ID BIGINT 8 No
UNIVL_PLAN_ID BIGINT 8 Yes
DC_PLAN_NUM CHARACTER 6 Yes
DC_SUB_PLAN_NUM CHARACTER 6 Yes
UNIVL_PLAN_NM VARCHAR 255 Yes
DC_UNIVL_PLAN_GRPNG_ID BIGINT 8 Yes
DC_UNIVL_PLAN_GRPNG_NM VARCHAR 255 Yes
DC_UNIVL_PLAN_GRPNG_EFF_DT DATE 4 Yes
UNIVL_ORGANZTN_ID BIGINT 8 No
ORGANZTN_NM VARCHAR 100 No
SSN CHARACTER 9 No
DC_PARTCPNT_TY_CD CHARACTER 1 Yes
DC_PARTCPNT_TY_DESC VARCHAR 100 Yes
DC_PARTCPNT_STAT_CD CHARACTER 2 No
DC_PARTCPNT_EXTD_STAT_CD CHARACTER 2 No
DC_PARTCPNT_STAT_DESC VARCHAR 100 Yes
DC_PARTCPNT_EXTD_STAT_DESC VARCHAR 30 Yes
EE_HIRE_DT DATE 4 Yes
EE_REHIRE_DT DATE 4 Yes
DC_ALT_VESTG_DT DATE 4 Yes
DC_PSEUDO_ENRLD_IND CHARACTER 1 Yes
DC_PSEUDO_ENRLD_DT DATE 4 Yes
DC_PARTCPNT_ENRLMT_DT DATE 4 Yes
DC_ENRLMT_ELGBL_DT DATE 4 Yes
EE_TERMN_DT DATE 4 Yes
EE_TERMN_RSN_CD CHARACTER 1 Yes
EE_TERMN_RSN_DESC VARCHAR 30 Yes
PARTCPNT_LAST_NM VARCHAR 35 No
PARTCPNT_FRST_NM VARCHAR 35 No
PARTCPNT_MID_INIT CHARACTER 1 Yes
PARTCPNT_PFX_NM CHARACTER 10 Yes
PARTCPNT_SFX_NM CHARACTER 10 Yes
HOME_FRST_ST_ADDR_LN VARCHAR 40 No
HOME_SEC_ST_ADDR_LN VARCHAR 40 Yes
HOME_THRD_ST_ADDR_LN VARCHAR 40 Yes
HOME_FRTH_ST_ADDR_LN VARCHAR 40 Yes
HOME_CITY_NM VARCHAR 30 No
HOME_STE_CD VARCHAR 2 No
HOME_ZIP_CD CHARACTER 5 No
ZIP_CD_SFX CHARACTER 4 Yes
DC_BENFY_CD CHARACTER 1 Yes
DC_BENFY_DESC VARCHAR 50 Yes
DC_RELD_PARTCPNT_ID CHARACTER 17 Yes
DC_ACCT_FROZEN_IND CHARACTER 1 No
GENDER_CD CHARACTER 1 No
BRTH_DT DATE 4 Yes
DTH_DT DATE 4 Yes
MRTL_STAT_CD CHARACTER 1 No
MRTL_STAT_DESC VARCHAR 30 Yes
INSIDER_TRADER_CD CHARACTER 1 No
INSIDER_TRADER_DESC VARCHAR 50 Yes
HCE_IND CHARACTER 1 No
DC_SELF_DIRD_IND CHARACTER 1 Yes
PYRL_FREQ_CD CHARACTER 1 No
PYRL_FREQ_DESC VARCHAR 20 Yes
DC_GOALMKR_ENRLD_IND CHARACTER 1 Yes
DC_GOALMKR_ENRLD_DT DATE 4 Yes
DC_GOALMKR_PORTF_ID CHARACTER 3 Yes
DC_AUTOREBAL_ENRLD_IND CHARACTER 1 Yes
DC_TAFT_HRTLY_EDUCATN_IND CHARACTER 1 Yes
RSO_ACCT_ID CHARACTER 28 Yes
RCD_EFF_DT DATE 4 No
RCD_END_DT DATE 4 No
ACTV_RCD_IND CHARACTER 1 No
BAD_ADDR_IND CHARACTER 1 Yes
DIVSION_SUB_ID CHARACTER 4 No
RCD_DEL_IND CHARACTER 1 No
HRS_OF_SVC_AMT DECIMAL 5 Yes
PER_OF_SVC_AMT DECIMAL 7 Yes
DC_PARTCPNT_ACCT_TY_CD CHARACTER 2 No
PARTCPNT_INIT_DT DATE 4 Yes
PARTCPNT_LAW_ENFRCMENT_IND CHARACTER 1 No
PARTCPNT_SHERRIFF_IND CHARACTER 1 No
PARTCPNT_DSO_IND CHARACTER 1 Yes
DC_RELD_PARTCPNT_SSN CHARACTER 9 Yes
ORIG_AUTO_ENRLMT_DT DATE 4 Yes
AUTO_ENRLMT_CHNG_DT DATE 4 Yes
AUTO_ENRLMT_CHNG_IND CHARACTER 1 Yes
AUTO_ENRLMT_DECLN_DT DATE 4 Yes
CNTRBN_ESCLTN_ELECT_CD CHARACTER 2 Yes
CNTRBN_ESCLTN_INCRMT_PCT DECIMAL 7 Yes
CNTRBN_ESCLTN_ORIG_EFF_DT DATE 4 Yes
CNTRBN_ESCLTN_CHNG_EFF_DT DATE 4 Yes
CNTRBN_ESCLTN_OPT_OUT_DT DATE 4 Yes
CNTRBN_ESCLTN_CTR_CNT INTEGER 4 Yes
CNTRBN_ESCLTN_INCRMT_AMT DECIMAL 15 Yes
CNTRBN_ESCLTN_INCRMT_MMDD CHARACTER 4 Yes
CNTRBN_ESCLTN_ELECT_SRC_CD CHARACTER 1 Yes
LAST_ACTY_OPER_ID VARCHAR 32 No
LAST_ACTY_DTM TIMESTAMP 10 No
SDB_ACCT_NUM CHARACTER 9 Yes
IF_FRST_DOLLR_RECVD_DT DATE 4 Yes
ORIG_IF_FRST_DOLLR_RECVD_DT DATE 4 Yes
UPD_DT DATE 4 Yes
AGE_ADJ_IND CHARACTER 1 Yes
HOME_PH_NUM VARCHAR 10 Yes
MIN_DISTRIB_SUPRSS_OPT_CD CHARACTER 1 Yes
MIN_DISTRIB_BEG_DT_OPT_CD CHARACTER 1 Yes
MIN_DISTRIB_ELGBL_DT DATE 4 Yes
DEC_SALES_LEAD_STAT_CD CHARACTER 1 Yes
ELECTED_DEFRL_RT_IND CHARACTER 1 Yes
FORCED_ACT_IND CHARACTER 1 Yes
FORCED_ACT_DT DATE 4 Yes
TYPE_IND CHARACTER 1 Yes
PARTL_GOALMKR_PCT DECIMAL 3 Yes
PPA_DEFLT_INVST_IND CHARACTER 1 Yes
PYRL_SUSPN_DT DATE 4 Yes
PYRL_SUSPN_MTH_NUM INTEGER 4 Yes
PYRL_SUSPN_END_DT DATE 4 Yes
EE_TY_CD CHARACTER 1 Yes
EE_TY_DESC VARCHAR 30 Yes
REPORTING.CTNRBN_DEFRL_FACT
PARTCPNT_KEY INTEGER 4 No
PROCS_DT_KEY INTEGER 4 No
PLAN_SRC_KEY INTEGER 4 No
CNTRBN_TY_CD CHARACTER 2 No
CNTRBN_DEFRL_AMT DECIMAL 13 Yes
CNTRBN_DEFRL_PCT DECIMAL 7 Yes
PREV_DEFRL_AMT DECIMAL 13 Yes
PREV_DEFRL_PCT DECIMAL 7 Yes
CNTRBN_TY_DESC CHARACTER 30 Yes
UNIVL_PLAN_ID BIGINT 8 Yes
CNTRBN_DEFRL_RSN_CD CHARACTER 2 Yes
CNTRBN_RSN_CD_DESC VARCHAR 50 Yes