PMO report

Tables (8)

GBM (GBM_Master)

  • EmpID (emp_Id) — INT — Foreign key → ID.EmpID — NOT NULL
  • GBM (gbm) — Varchar(20)
  • Gbm_Id (gbm_id) — Int — NOT NULL

Group (Group_Master)

  • Key (Group_Id) — INT — Primary key — NOT NULL
  • Key (Team_Id2) — INT — Foreign key → Team.Key — NOT NULL
  • Field (Group_Name) — Varchar(200)
  • Field (Team_Id) — INT

ID (EmployeeMaster)

  • EmpID (emp_Id) — INT — Primary key — NOT NULL
  • Emp_Type (emptype) — INT
  • EmpName (emp_name) — Varchar(50)
  • EmpSingleId (emp_singleid) — Varchar(50)
  • DOJ (doj) — Date
  • GBM_ID (gbm) — INT
  • Cost_Center (Field) — Varchar(100)
  • Resign_Date (resign_date) — Date
  • Relieving_Date (Field2) — Date
  • Band (Field3) — Varchar(10)
  • Degree (Field4) — Varchar(50)
  • ResourceTypeId (r_type) — INT
  • DeptId (Field5) — INT
  • ID (Key) — INT — Foreign key → Resource.ID — NOT NULL

Project Resource Mapping (PLM)

  • AutoId (Key) — INT — Primary key — NOT NULL
  • EmpID (emp_Id) — Varchar(10) — Foreign key → ID.EmpID — NOT NULL
  • PLMCode (Field) — Varchar(20)

RemarkReason (Master)

  • ID (Key) — INT — Primary key — NOT NULL
  • Reason (Field) — Varchar(200)
  • AutoId (Key2) — INT — Foreign key → project.AutoId — NOT NULL
  • EmpID (emp_Id) — Varchar(10) — Foreign key → project.EmpID — NOT NULL

Resource (Type Master)

  • ID (Key) — INT — Primary key — NOT NULL
  • ResourceType (Field)

Team (Team_Master)

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

project (ProjectMaster)

  • AutoId (Key) — INT — Primary key — NOT NULL
  • EmpID (emp_Id) — Varchar(10) — Foreign key → Project Resource Mapping.EmpID — NOT NULL
  • PLMCode (p_code) — Varchar(20)
  • ProjectName (p_name) — Varchar(100)
  • StartDate (s_date) — Date
  • EndDate (e_date) — Date
  • Project_GBM (p_gbm) — INT
  • Project_Status (p_status) — Varchar(20)
  • PL_EmpID (pl_id) — Varchar(10)
  • DevTypeId (d_typeid) — INT
  • ADPCode (adp_code) — Varchar(20)
  • ADPName (adp_name)