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)