PMO report ERD SPE
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)