BI Universe Change

BI Universe Change

Pamela Smulski edited comment on HRS085-7 at 5/21/15 9:33 AM:

--------------------------------------------------------------

Fields to be removed from HESA BI Universe :

From the UOE_HESA_PERSON_DETAILS table:

   ACTCHQUAL1,   ACTCHQUAL2,   ACTCHQUAL3,   ACTCHQUAL4,   ACTCHQUAL5,   ACTCHQUAL6,

  RESAST, ECRSTAT and REFUOA2014

Fields to be added to the HESA BI Universe :

• From table UOE_HESA_CONTRACT_DETAILS  add  RESAST
• From  table UOE_HESA_CONTRACT_DETS_ARCHIVE add RESAST

From  table UOE_HESA_PERSON_DETS_ARCHIVE :

•    RESAST to be renamed RESAST_PRE2014
•    Add REFUOA2014

Similar security as on the other fields from these tables should be applied to the new ones.