PMO Report ERD

Tables (12)

CostCenter (.)

  • Cost_Center_ID (Key) — INT — Primary key — NOT NULL
  • Cost_Center (Field5) — Varchar(100) — Primary key
  • PLMCode (Field) — Varchar(20)
  • ADPCode (Field2) — Varchar(20)
  • Project_Name (Field3) — Varchar(100)
  • ADP_Name (Field4) — Varchar(100)

Department (Group_Master)

  • Key (Dept_Id) — INT — Primary key — NOT NULL
  • Field (Deparment_Name) — Varchar(200) — Primary key
  • Key (Team_Id) — INT — Foreign key → Team_Group.Key — NOT NULL

DevType (Untitled3)

  • DevTypeId (Key) — INT — Primary key — NOT NULL
  • DevType (Field) — Varchar(50)

GBM (GBM_Master)

  • Gbm_Id (gbm_id) — Int — Primary key — NOT NULL
  • GBM (gbm) — Varchar(20)

ID (EmployeeMaster)

  • EmpID (emp_Id) — Varchar(10) — Primary key — NOT NULL
  • DevTypeId (Key2) — INT — Foreign key → DevType.DevTypeId — NOT NULL
  • ResourceTypeId (Key3) — INT — Foreign key → ResourceType.ResourceTypeId — NOT NULL
  • Gbm_Id (gbm_id) — Int — Foreign key → GBM.Gbm_Id — NOT NULL
  • Emp_Type (emptype) — INT
  • EmpName (emp_name) — Varchar(50)
  • EmpSingleId (emp_singleid) — Varchar(50)
  • DOJ (doj) — Date
  • Resign_Date (resign_date) — Date
  • Relieving_Date (Field2) — Date
  • Band (Field3) — Varchar(10)
  • Degree (Field4) — Varchar(50)
  • DeptId (Field5) — INT
  • HQ_Team (Field6) — Varchar(100)
  • HQ_Lab (Field7) — Varchar(50)
  • SRI-D_Team_PLM (Field8) — Varchar(100)
  • SRI-D_Group_PLM (Field9) — Varchar(100)
  • SRI-D_Part_PLM (Field10) — Varchar(100)
  • SRI-D_Team_Workday (Field11) — Varchar(50)
  • SRI-D_Group_Workday (Field12) — Varchar(50)
  • SRI-D_Part_Workday (Field13) — Varchar(50)
  • PLM_Allocation (Field14) — Varchar(50\)
  • Person_Month_PLM (Field15) — Varchar(50)
  • SWC_Eligible_NonEligible (Field16) — Bool
  • Development_Member (Field17) — INT
  • Non-Development_Member (Field18) — INT
  • Cost_Center_ID (Key) — INT — Foreign key → CostCenter.Cost_Center_ID — NOT NULL
  • Dept_Id (Group_Id) — INT — Foreign key → Department.Key — NOT NULL
  • Team_Id — INT — Foreign key → Department.Key — NOT NULL

Project Resource Mapping (PLM)

  • AutoId (Key) — INT — Primary key — NOT NULL
  • EmpID (emp_Id) — Varchar(10) — Foreign key → ID.EmpID — NOT NULL
  • Cost_Center (Field52) — Varchar(100) — Foreign key
  • PLMCode (p_code) — Varchar(20) — Foreign key → project.PLMCode

Project_ADP (ADP)

  • ADP_Project_Code (Key) — INT — Primary key — NOT NULL
  • Status_Id (Key2) — INT — Foreign key → Status.Status_Id — NOT NULL
  • PLMCode (pa_code) — Varchar(20)
  • ADP_Project_Name (Field) — Varchar(100)
  • Year (Field2) — INT
  • StartDate (Field3) — Date
  • EndDate (Field4) — Date
  • MonthlyHR _ADP_Cnt (Field5) — INT
  • HQ_PL_Name (Field7) — Varchar(20)
  • HQ_PL_SingleId (Field8) — Varchar(50)
  • SRI-D_PL_Name (Field9) — Varchar(50)
  • SRI-D_PL_SingleID (Field10) — Varchar(50)
  • GBM_Id (Field11) — INT
  • HQ_Team (Dev.,CS..) — Varchar(10)
  • HQ_Lab (Field12) — Varchar(20)
  • SRI-D_Team (Field13) — Varchar(100)
  • SRI-D_Group (Field14) — Varchar(100)
  • SRI-D_Part (Field15) — Varchar(100)
  • Baseline (Field16) — Varchar(50)
  • Additional_Project (Field17) — Varchar(100)
  • Domain (Field18) — Varchar(50)
  • Reason_Id (Key3) — INT — Foreign key → RemarkReason.Reason_Id — NOT NULL

RemarkReason (Master)

  • Reason_Id (Key) — INT — Primary key — NOT NULL
  • Reason (Field) — Varchar(200)

ResourceType (Untitled2)

  • ResourceTypeId (Key) — INT — Primary key — NOT NULL
  • ResourceType (Field) — Varchar(100)

Status (Untitled)

  • Status_Id (Key) — INT — Primary key — NOT NULL
  • Status (Field) — Varchar(20)

Team_Group (Team_Master)

  • Key (Team_Id) — INT — Primary key — NOT NULL
  • Field (Team_Name) — Varchar(200)

project (ProjectMaster)

  • PLMCode (p_code) — Varchar(20) — Primary key
  • Status_Id (Key2) — INT — Foreign key → Status.Status_Id — NOT NULL
  • ADP_Project_Code (Key3) — INT — Foreign key → Project_ADP.ADP_Project_Code — NOT NULL
  • Status_Id (Key22) — INT — Foreign key → Project_ADP.Status_Id — NOT NULL
  • Gbm_Id (gbm_id) — Int — Foreign key → GBM.Gbm_Id — NOT NULL
  • ProjectName (p_name) — Varchar(100)
  • StartDate (s_date) — Date
  • EndDate (e_date) — Date
  • HQ_PL_Name (pl_id) — Varchar(50)
  • HQ_PL SingleId (d_typeid) — Varchar(50)
  • SRI-D_PL_Name (pl_name) — Varchar(50)
  • SRI-D_PL_SingleId (adp_name) — Varchar(50)
  • HQ_Team (Field) — Varchar(100)
  • HQ_Lab (Field2) — Varchar(50)
  • SRI-D_Team (Field3) — Varchar(100)
  • SRI-D_Group (Field4) — Varchar(100)
  • SRI-D_Part (Field5) — Varchar(100)
  • Domain (Field6) — Varchar(50)