ERD_PMO_1stMeetingChanges

Tables (13)

Actual_Project_PLM (Project_Master)

  • PLM_Code (P_Code) — Varchar(20) — Primary key
  • ADP_Project_Code (Adp_Project_Code) — INT — Foreign key → Planned_Project_ADP.ADP_Project_Code — NOT NULL
  • Dev_Type_Id (Dev_Id) — INT — Foreign key → DevType.Dev_Type_ID — NOT NULL
  • Status_Id — INT — Foreign key → Status.Status_Id — NOT NULL
  • Project_Name (P_Name) — Varchar(100)
  • Actual_Start_Date (S_Date) — Date
  • Actual_End_Date (E_Date) — Date
  • HQ_PL_Name (HQPL_Id) — Varchar(50)
  • HQ_PL_ SingleId (HQPL_Singleid) — Varchar(50)

Cost_Center (Cost_Center_Master)

  • Cost_Id — INT — Primary key — NOT NULL
  • Cost_Center_Name (Center_Name) — Varchar(100)

DevType (DevType_Master)

  • Dev_Type_ID (Dev_Id) — INT — Primary key — NOT NULL
  • Dev_Type (DevType_Name) — Varchar(50)

Employee (Employee_Master)

  • Emp_Id — Varchar(10) — Primary key — NOT NULL
  • Gbm_Id — INT — Foreign key → GBM.Gbm_Id — NOT NULL
  • Resource_Type_Id (Resource_Id) — INT — Foreign key → ResourceType.Resource_Type_Id — NOT NULL
  • Name (Emp_Name) — Varchar(50)
  • Knox_Id (Emp_Singleid) — Varchar(50)
  • Joining_Date — Date
  • Resign_Date (Resigning_Date) — Date
  • Relieving_Date (Releive_Date) — Date
  • Career_Level — Varchar(10)
  • Qualification (Qualfication) — Varchar(50)
  • PLM_Allocation (Plm_Allocation) — Varchar(50)
  • Title_Band — Varchar(20)
  • Org_Id — INT — Foreign key → Organisation.Org_Id — NOT NULL
  • Cost_Id — INT — Foreign key → Cost_Center.Cost_Id — NOT NULL
  • SWC_Status_Id — INT — Foreign key → EmployeeSWCStatus.SWC_Status_Id — NOT NULL

EmployeeSWCStatus (Emp_Swc_Status)

  • SWC_Status_Id — INT — Primary key — NOT NULL
  • SWC_Status_Name — Varchar(100)

GBM (GBM_Master)

  • Gbm_Id — INT — Primary key — NOT NULL
  • GBM (Gbm_Name) — Varchar(20)
  • HQ_Team (Hq_Team) — Varchar(100)
  • HQ_Lab (Hq_Lab) — Varchar(100)

Organisation (Org_Master)

  • Org_Id — INT — Primary key — NOT NULL
  • SRID_Team (Org_Name) — Varchar(200)
  • SRID_Group (Srid_Group) — Varchar(200)
  • SRID_Part (Srid_Part) — Varchar(200)

Planned_Project_ADP (ADP_Master)

  • ADP_Project_Code — INT — Primary key — NOT NULL
  • ADP_Project_Name (Adp_Project_Name) — Varchar(100)
  • Start_Date — Date
  • End_Date — Date
  • MonthlyHR _ADP_Count (ADP_Count) — INT
  • HQ_PL_Name (HQPL_Name) — Varchar(20)
  • HQ_PL_SingleId (HQPL_Singleid) — Varchar(50)
  • SRID_PL_Name (PL_Name) — Varchar(50)
  • SRID_PL_Singleid (PL_Singleid) — Varchar(50)
  • Additional_Project — Varchar(100)
  • ADP_Status — Varchar(100)
  • Gbm_Id — INT — Foreign key → GBM.Gbm_Id — NOT NULL

Project Resource Mapping (Pro_Emp_Mapping_Master)

  • Auto_Id — INT — Primary key — NOT NULL
  • Emp_Id — Varchar(10) — Foreign key → Employee.Emp_Id — NOT NULL
  • PLMCode (P_Code) — Varchar(20) — Foreign key → Actual_Project_PLM.PLM_Code
  • Person_Month_PLM (Person_Month_Plm) — Varchar(100)
  • SRID_PL_SingleID (PL_Singleid) — Varchar(50)

ProjectDomainMapping (Project_Domain_Mapping)

  • Map_Id — INT — Primary key — NOT NULL
  • Domain_Id — INT — Foreign key → Tech_Domain.Domain_Id — NOT NULL
  • ADP_Project_Code — INT — Foreign key → Planned_Project_ADP.ADP_Project_Code — NOT NULL

ResourceType (ResourceType_Master)

  • Resource_Type_Id (Resource_Id) — INT — Primary key — NOT NULL
  • Resource_Type — Varchar(100)

Status (Status_Master)

  • Status_Id — INT — Primary key — NOT NULL
  • Status (Status_Type) — Varchar(50)

Tech_Domain (Tech_Domain_Master)

  • Domain_Id — INT — Primary key — NOT NULL
  • Name (Domain_Name) — VARCHAR(100)