Friday, June 7, 2013

PS_ASU_D_PERSON_VW Enhancements

Changed Multi-Dimensional Warehouse (MDW) Tables/Views

Long-awaited enhancements to PS_ASU_D_PERSON_VW are now in production (PMPRD), as of 05/31/13. Thanks again to Marco for his development work on this!

Changes and improvements are:
  • Query performance; it is faster 
  •  New fields
    • DECEASED_FLG
    •  ASU_SIS_DIR_RL_FLG
    •  RES_HALL_STATUS
    •  RES_HALL_COMMUNITY
    •  ETHNIC_GROUP_SD_LIST
    •  ASU_CITZN_COUNTRY_LD
    •  HOME_CNTRY_LD
 For more details see PS_ASU_D_PERSON_VW enhancements - May 2013) 

 

No comments: