Skip to content

Table: Entrepreneur Company Principal Projects

Primary Key: Entrepreneur

Fields

Field Type Size Required PK
Entrepreneur Company Principal Project ID Long 4
Date Allocation Created DateTime 8
Entrepreneur Company Programme Years ID Long 4
Principal Project Pillar ID Long 4
Allocated Amount Double 8
Monthly Allocated Amount Double 8
Selection Fee Double 8
Selection Fee Type Text 255
Replacement Status Text 255
Lump Sum Allocation Boolean 1
Replacement For Long 4
EP Replaced By Long 4
EP Replacement For Long 4
Contract Printed Boolean 1
Date Contract Signed DateTime 8
VA Packs Delivered DateTime 8
Modified By Text 255
Date Modified DateTime 8
SSMA_TimeStamp Binary 8
Element Type Text 50
Extra Sponsorship Amount Double 8
Frequency of Payments Text 50
Payment Amount Double 8
VA Pack Audit Status ID Long 4
Date VA Pack Audit Status Changed DateTime 8
VA Pack Audit Status Changed By Text 255
VA Pack Audit Score Double 8
SA SDM Notified Boolean 1

Indexes

  • Entrepreneur Company Principal Projects$Entrepreneur Company Pro
  • Entrepreneur Company Principal Projects$PrimaryKey [PRIMARY KEY] [UNIQUE]
  • Entrepreneur Company Principal Projects$Principal Project Pillar