PMO

Tables (13)

ADP_PLM_Mapping (Untitled2)

    Actual_Project_PLM (ProjectMaster)

    • PLM_Code (Key) — VARCHAR(100) — Primary key — NOT NULL
    • Status_id (Key2) — INT — Foreign key → Status.Status_id — NOT NULL
    • Dev_ID (Devtype_id) — INT — Foreign key → Devtype.ID — NOT NULL
    • PLM_Project (Field) — VARCHAR(300)
    • GBM_ID (Key3) — INT — Foreign key → GBM.GBM_ID — NOT NULL
    • CostcenterID (Key4) — INT — Foreign key → Cost_Center.CostcenterID — NOT NULL

    Cost_Center (Cost_master)

    • CostcenterID (Key) — INT — Primary key — NOT NULL
    • Costcenter (Field) — VARCHAR(100)
    • GBM_ID (Key2) — INT — Foreign key → GBM.GBM_ID — NOT NULL

    Devtype (DevType)

    • ID (Devtype_id) — INT — Primary key — NOT NULL
    • Name (Devname) — VARCHAR(200)

    Employee (Untitled3)

    • ID (Field) — INT — Primary key
    • Name (Field2) — VARCHAR(100)
    • KNOXID (Field3) — VARCHAR(100)
    • Joining_Date (Field4) — Date
    • Resign_Date (Field5) — Date
    • Relieving_Date (Field6) — Date
    • Career_Level (Field7)
    • Qualification (Field8) — VARCHAR(100)
    • HQ_Team (Field9) — VARCHAR(100)
    • HQ_Lab (Field10) — VARCHAR(100)
    • PLM_Allocation (Field11) — VARCHAR(100)
    • Person_Month_PLM (Field12)
    • SWC info(Needs clarity) (Field13)
    • Field14
    • CostcenterID (Key) — INT — Foreign key → Cost_Center.CostcenterID — NOT NULL
    • ID (Restype_id) — INT — Foreign key → Resourcetype.ID — NOT NULL

    GBM (GBM_master)

    • GBM_ID (Key) — INT — Primary key — NOT NULL
    • GBMname (Field) — VARCHAR(100)

    Organisation (OrgMaster)

    • Dept_id (Key) — INT — Primary key — NOT NULL
    • Dname (Field) — VARCHAR(300)
    • Team_id (Key2) — INT — Foreign key → Team.Team_id — NOT NULL

    Planned_Project_ADP (ADP_Master)

    • ADP _Code (Key) — VARCHAR(50) — Primary key — NOT NULL
    • PLM_Code (Key2) — VARCHAR(100) — Foreign key → Actual_Project_PLM.PLM_Code — NOT NULL
    • Status_id (Key22) — INT — Foreign key → Actual_Project_PLM.Status_id — NOT NULL
    • Dev_ID (Devtype_id) — INT — Foreign key → Actual_Project_PLM.Dev_ID — NOT NULL
    • ADPname (Field) — VARCHAR(100)
    • ADPstatus (Field2) — VARCHAR(100)
    • DevPlant (Field3) — VARCHAR(50)
    • Scheduled from date (Field4) — DATE
    • Scheduled to date (Field5) — DATE
    • ADP_HeadCount (Field6) — INT

    ProjectMapping (Mapping_master)

    • ProjectMap_ID (Key3) — INT — Primary key — NOT NULL
    • ProjectCode(PLM) (Key2) — VARCHAR(100) — Foreign key → Actual_Project_PLM.PLM_Code — NOT NULL
    • Status_id (Key22) — INT — Foreign key → Actual_Project_PLM.Status_id — NOT NULL
    • Dev_ID (Devtype_id) — INT — Foreign key → Actual_Project_PLM.Dev_ID — NOT NULL

    Resourcetype (ResourceType)

    • ID (Restype_id) — INT — Primary key — NOT NULL
    • Name (ResourceTypename) — VARCHAR(100)
    • Field

    Status (StatusMaster)

    • Status_id (Key) — INT — Primary key — NOT NULL
    • Statusname (Field) — VARCHAR(200)

    Team (Team_master)

    • Team_id (Key) — INT — Primary key — NOT NULL
    • Teamname (Field) — VARCHAR(100)

    Tech_Domain (Untitled)

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