AWP

Tables (28)

AWP Auth User List[0424] (dbo.AWP_AUTH_USER_LIST)

  • Project Code (PJT_NO) — varchar(32) — Primary key — NOT NULL
  • Upv/ Swp3d (TYPE) — varchar(32) — Primary key — NOT NULL
  • User ID (USERID) — varchar(64) — Primary key — NOT NULL
  • Authority (Auth) — varchar(64)
  • Update Date (UPDATE_DT) — datetime
  • Update By (UPDATE_BY) — varchar(64)

AWP System Hierarchy Set-up[0424] (dbo.AWP_ADMIN_SYSPATH)

  • Project Code (PJT_NO) — varchar(32) — Primary key — NOT NULL
  • Category (CATEGORY) — varchar(32) — Primary key — NOT NULL
  • PIPING Sample Value (PIPING_SAMPLE) — varchar(64)
  • PIPING IWP Key (PIPING_KEY) — varchar(32)
  • PIPING IWP SubString Digit (PIPING_SUBSTR) — varchar(64)
  • CIVIL Sample Value (CIVIL_SAMPLE) — varchar(64)
  • CIVIL IWP Key (CIVIL_KEY) — varchar(64)
  • CIVIL IWP Substring Digit (CIVIL_SUBSTR) — varchar(64)
  • Equipment Sample Value (EQUIP_SAMPLE) — varchar(64)
  • Equipment IWP Key (EQUIP_KEY) — varchar(64)
  • Equipment SubString Digit (EQUIP_SUBSTR) — varchar(64)
  • Structure Sample Value (STRUC_SAMPLE) — varchar(64)
  • Structure IWP Key (STRUC_KEY) — varchar(64)
  • Structure IWP Substring Digit (STRUC_SUBSTR) — varchar(64)

AWP_FILE_PATH

  • Project No (PJT_NO) — varchar(32)
  • Create by (CREATEBY) — varchar(64)
  • Report Path Type (PATH_TYPE) — varchar(32)
  • Report Path (PATH_VALUE) — nvarchar(max)

AWP_PJTNO_MODEL_MAP

  • Project No (PJT_NO) — varchar(32)
  • Model Path (MODELINFO) — varchar(128)
  • Create Date (CREATEDT) — datetime
  • Create by (CREATEBY) — varchar(64)
  • Update Date (UPDATEDT) — datetime
  • Update by (UPDATEBY) — varchar(64)

AWP_PRIOR_WORK_LIST_ISO

  • Project No (PJT_NO) — varchar(32) — NOT NULL
  • Model Path (MODELINFO) — varchar(128) — NOT NULL
  • CWP Code (CWP_CODE) — varchar(64) — NOT NULL
  • ISO No (ISONO) — varchar(64) — NOT NULL
  • Item Type (ITEMTYPE) — varchar(256)
  • Item No (ITEMNO) — varchar(256)
  • Create by (CREATEBY) — varchar(64)
  • Create date (CREATEDT) — datetime
  • User manual (USER_MANUAL) — int

Assgined UID in Volume Info [0427] (dbo.AWP_VOLUME_INFO_ASS_ITEM)

  • Volume Info Index (VI_IDX) — int — Foreign key → Volume Info [0427].Volume Info Index
  • Discipline (DISCIPLINE) — varchar(64)
  • Item Type (ITEM_TYPE) — varchar(64)
  • Item No (ITEM_NO) — varchar(256)
  • Dwg No (DWG_NO) — varchar(512)
  • Iso No (ISO_NO) — varchar(512)
  • Block No (BLOCK_NO) — varchar(512)
  • Assembly No (ASSEMBLY_NO) — varchar(512)
  • Guid (GUID) — varchar(256)
  • Uid (UID) — varchar(256)

Assigned Piping Item List in IWP[0424] (dbo.AWP_IWP_ASS_ITEM)

  • Orginal Item No (ORG_ITEMNO) — varchar(64) — Primary key
  • UID — varchar(MAX) — Primary key
  • Project Code (PJT_NO) — varchar(32) — Foreign key → IWP List[0424].Project Code — NOT NULL
  • IWP Code (IWP_CODE) — varchar(64) — Foreign key → IWP List[0424].IWP Code — NOT NULL
  • CWP Code (CWP_CODE) — varchar(64) — Foreign key → IWP List[0424].CWP Code — NOT NULL
  • Item Type (TYPE) — varchar(16)
  • System Path (SYSPATH) — varchar(MAX)
  • Discipline — varchar(64)
  • Area (AREA) — varchar(32)
  • Item No (ITEMNO) — varchar(64)
  • DWG No (DWGNO) — varchar(64)
  • WF — varchar(32)
  • sequence (SEQNO) — int

Attachment List[0508] (dbo.AWP_ATTCHFILES)

  • File Index (FILEID) — int — Primary key — NOT NULL
  • IWP Code (IWP_CODE) — varchar(64) — Foreign key → IWP List[0424].IWP Code — NOT NULL
  • Project Code (PJT_NO) — varchar(32) — Foreign key → IWP List[0424].Project Code — NOT NULL
  • CWP Code (CWP_CODE) — varchar(64) — Foreign key → IWP List[0424].CWP Code — NOT NULL
  • File Name (FILENM) — varchar(max)
  • File Path (FILEPATH) — varchar(max)
  • File Size (FILESIZE) — int
  • UPV View Info (UPV_VIEW_INFO) — varchar(max)
  • Create Date (CREATE_DT) — datetime
  • Create User ID (CREATE_BY) — varchar(64)
  • Update Date (UPDATE_DT) — dateTIme
  • Update User ID (UPDATE_BY) — varchar(64)
  • View Type (VIEW_TYPE) — varchar(32)

CWP List[0424] (dbo.CSIM_AWP_UPV_MAP)

  • Project Code (PJT_NO) — varchar(100) — Primary key — NOT NULL
  • CWA — varchar(100) — Primary key — NOT NULL
  • CWA B (CWA_B) — varchar(100) — Primary key — NOT NULL
  • CWP Code (CWP_CODE) — varchar(100) — Primary key — NOT NULL
  • UPV Mapping (UPV_MAPPING) — varchar(500) — Primary key
  • CWP Description (CWP_DESC) — varchar(MAX)
  • CWP Start Date (CWP_START_DATE) — varchar(50)
  • CWP Finish Date (CWP_FINISH_DATE) — varchar(50)
  • BOQ_QTY(?) (BOQ_QTY) — numeric(38,0)
  • Actural Quantity (ACTUAL_QTY) — numeric(38,0)
  • Actural Start Date (ACTUAL_START_DATE) — varchar(50)
  • Actural Finish Date (ACTUAL_FINISH_DATE) — varchar(50)
  • ENG_PLAN_DATE(?) (ENG_PLAN_DATE) — varchar(50)
  • WF_DATE(?) (WF_DATE) — varchar(50)
  • UOM(?) (UOM) — varchar(50)
  • Work Category (WORK_CATEGORY) — varchar(500)
  • UPV Discipline (UPV_DISC) — varchar(50)
  • UPV Area (UPV_AREA) — varchar(50)
  • IF Date (IF_DATE) — datetime
  • UPV Mapping Type (UPV_MAPPING_TYPE) — varchar(64)
  • UPV 3D Where Rule (UPV_3D_WHERE_RULE) — varchar(64)

Custom Attribute[0424] (dbo.CustAttr_UPV_Extraction_Attribute)

  • Project No (PJT_NO) — varchar(32) — Primary key — NOT NULL
  • Category — varchar(50) — Primary key — NOT NULL
  • Sequence (Seq) — int — Primary key — NOT NULL
  • Attribute — varchar(50)
  • Create ID (CreateId) — varchar(50)
  • Create Date (CreateDt) — datetime
  • Update ID (UpdateId) — varchar(50)
  • Update Date (UpdateDt) — datetime

Custom Attribute Map Data[0615] (dbo.AWP_UPV_VALUE)

  • Project No (PJT_NO) — varchar(64) — NOT NULL
  • Model Info (ModelInfo) — varchar(64) — NOT NULL
  • Discipline (DISCIPLINE) — varchar(64) — NOT NULL
  • Area (AREA) — varchar(32)
  • System Path (SYSPATH) — varchar(500) — NOT NULL
  • Item Type (ITEMTYPE) — varchar(256) — NOT NULL
  • H/E Level 1 (HE1) — varchar(256)
  • H/E Level 2 (HE2) — varchar(256)
  • Item No\ (ITEMNO) — varchar(256) — NOT NULL
  • Iso No (ISONO) — varchar(256)
  • Uid (UID) — varchar(128) — NOT NULL
  • Create Date (CreateDT) — datetime — NOT NULL
  • Field

Custom Attribute Value[0424] (dbo.CustAttr_UPV_Extraction_Value)

  • Project No (PJT_NO) — varchar(32) — Primary key
  • Category (CATEGORY) — varchar(50) — Primary key
  • Model Info (MODELINFO) — varchar(500) — Primary key
  • Sequence (Seq) — int — Primary key
  • ATTRVALUE_1 — varchar(500)
  • ATTRVALUE_2 — varchar(500)
  • ATTRVALUE_3 — varchar(500)
  • ATTRVALUE_4 — varchar(500)
  • ATTRVALUE_5 — varchar(500)
  • ATTRVALUE_6 — varchar(500)
  • ATTRVALUE_7 — varchar(500)
  • ATTRVALUE_8 — varchar(500)
  • ATTRVALUE_9 — varchar(500)
  • ATTRVALUE_10 — varchar(500)
  • Create Date (CREATEDT) — datetime

Discipline For Item Tag Type [0424] (dbo.AWP_ITEMTAGTYPE_DISCIPLINE)

  • Project No (PJT_NO) — varchar(64) — Primary key — NOT NULL
  • Discipline (DISCIPLINE) — varchar(64) — Primary key — NOT NULL

HE For Item Tag Type [0424] (dbo.ITEMTAGTYPE_HE)

  • Project No (PJT_NO) — varchar(64) — Primary key — NOT NULL
  • Discipline (DISCIPLINE) — varchar(64) — Primary key — NOT NULL
  • H/E Level 1 (HE_LV_1) — varchar(128) — Primary key — NOT NULL
  • H/E Lebel 2 (HE_LV_2) — varchar(128) — Primary key — NOT NULL
  • Template Code (TEMPLATE_CODE)

IWP Code Numbering[0427] (dbo.AWP_IWP_NUMBERING_RULE)

  • Project Code (PJT_NO) — varchar(64)
  • TYPE — varchar(32)
  • Contents (CONTENT) — varchar(MAX)

IWP List[0424] (dbo.AWP_IWP_LIST)

  • IWP Code (IWP_CODE) — varchar(64) — Primary key — NOT NULL
  • Project Code (PJT_NO) — varchar(32) — Foreign key → CWP List[0424].Project Code — NOT NULL
  • CWP Code (CWP_CODE) — varchar(64) — Foreign key → CWP List[0424].CWP Code — NOT NULL
  • Model Path (ModelPath) — varchar(max)
  • Model Cooridnate (ModelView) — varchar(max)
  • Status WF — varchar(10)
  • Status Cnst (StatusCnst) — varchar(10)
  • Plan Start Date (PlanStartDt) — dateTime
  • Plan End Date (PlanEndDt) — dateTime
  • Actual Start Date (ActualStartDt) — dateTime
  • Actual End Date (ActualEndDt) — dateTime
  • WorkFace Planner (UserWP) — varchar(64)
  • Super Intendent (UserSI) — varchar(64)
  • Supervisor (UserSP) — varchar(64)
  • ForeMan (UserFM) — varchar(64)
  • Rev. (Rev) — int
  • Remark — varchar(max)
  • Image Path (ImgPath) — varchar(max)
  • Sub Key (SUB_KEY) — varchar(64)
  • CWA Code (CWA_Code) — varchar(64) — NOT NULL
  • Seq No (SEQNO) — int
  • Discipline — varchar(16)

Item Tag List (dbo.AWP_ITEMTAGLIST)

  • Index (IDX) — int — Primary key — NOT NULL
  • Project No (PJT_NO) — varchar(32)
  • Model Path (MODELINFO) — varchar(128)
  • Item Tag Type (ITEMTAGTYPE) — varchar(128)
  • Area (AREA) — varchar(64)
  • Item Tag No (ITEM_TAG_NO) — varchar(128)
  • H/E Level 1 (HE_LV_1) — varchar(128)
  • H/E Level 2 (HE_LV_2) — varchar(128)
  • System Path Level 1 (SYSPATH_LV1) — varchar(64)
  • System Path Level 2 (SYSPATH_LV2) — varchar(64)
  • System Path Level 3 (SYSPATH_LV3) — varchar(64)
  • System Path Level 4 (SYSPATH_LV4) — varchar(64)
  • System Path Level 5 (SYSPATH_LV5) — varchar(64)
  • System Path Level 6 (SYSPATH_LV6) — varchar(64)
  • System Path Level 7 (SYSPATH_LV7) — varchar(256)
  • System Path Level 8 (SYSPATH_LV8) — varchar(256)
  • System Path Level 9 (SYSPATH_LV9) — varchar(256)
  • System Path Level 10 (SYSPATH_LV10) — varchar(256)
  • Create Date (CREATEDT) — datetime
  • Create by (CREATEBY) — varchar(64)
  • Update Date (UPDATEDT) — datetime
  • Update by (UPDATEBY) — varchar(64)
  • Discipline (DISCIPLINE) — varchar(64)
  • UID — varchar(128)
  • User Manual (USER_MANUAL) — bit

Item Tag Type [0424] (dbo.AWP_ITEMTAGTYPE)

  • Index (IDX) — int — Primary key — NOT NULL
  • Project No (PJT_NO) — varchar(32)
  • Discipline (DISCIPLINE) — varchar(64)
  • H/E Level 1 (HE_LV_1) — varchar(128)
  • H/E Level 2 (HE_LV_2) — varchar(128)
  • Item Type (ITEMTYPE) — varchar(128)
  • UPV Attribute (UPV_ATT) — varchar(64)
  • UPV Value (UPV_VALUE) — varchar(64)
  • UPV Condition (UPV_CONDITION) — varchar(16)
  • Result UPV Attribute (ITEM_ATT_VALUE) — varchar(64)
  • W/F L/D Table (WF_LD_TABLE) — varchar(256)
  • W/F L/D Column 1 (WF_LD_COLUMN_1) — varchar(256)
  • W/F L/D Column 2 (WF_LD_COLUMN_2) — varchar(256)
  • W/F L/D Column 3 (WF_LD_COLUMN_3) — varchar(256)
  • W/F 3D DB 3D Key 1 (WF_3DDB_3DKEY_1) — varchar(256)
  • W/F 3D DB 3D Key 2 (WF_3DDB_3DKEY_2) — varchar(256)
  • W/F 3D DB 3D Key3 (WF_3DDB_3DKEY_3) — varchar(256)
  • W/F/R L/D Table (WFR_LD_TABLE) — varchar(256)
  • W/F/R L/D Column (WFR_LD_COLUMN) — varchar(256)
  • W/F/R SQL (WFR/SQL) — varchar(Max)
  • Dept Level 1 (DEPT_LV_1) — int
  • Dept Level 2 (DEPT_LV_2) — int
  • Dept Lebel 3 (DEPT_LV_3) — int
  • Category — varchar(64)

Log TBL for development (dbo.AWP_LOG_FORDEV)

  • Index (IDX) — int — Primary key — NOT NULL
  • TYPE — varchar(64)
  • SUB TYPE (SUB_TYPE) — varchar(64)
  • Catergory (CATEGORY) — varchar(64)
  • Sub Category (SUB_CATEGORY) — varchar(64)
  • Contents (CONTENTS) — varchar(max)
  • Create Date (CREATEDT) — datetime
  • Create User ID (CREATEBY) — varchar(64)

MMS (dbo.CSIM_AWP_UPV_MAP_ME)

  • Project No (PJT_NO) — varchar(20) — Primary key — NOT NULL
  • CWP Code (CWP_CODE) — varchar(50)
  • Const Area (CONST_AREA) — varchar(10)
  • HD Element CD (HD_ELEM_CD) — varchar(10)
  • Item No (ITEM_NO) — varchar(50)
  • Req No (REQ_NO) — varchar(50)
  • Item Name (ITEM_NM) — varchar(200)
  • UOM — varchar(50)
  • Item Sequence (ITEM_SEQ) — float
  • Const Schedules Status (CONST_SCHEDULE_STATUS) — varchar(50)
  • Field

TEMP TBL for UID[0427] (dbo.AWP_UID_TEMP)

  • UPV UID (UPV_UID) — varchar(128)
  • Session UID (SES_UID) — varchar(128)
  • Create Date (CREATEDT) — datetime
  • Confirm_Status (CONFIRM_STATUS) — tinyint

User List[04240] (dbo.AWP_USER_LIST)

  • User ID (UserId) — varchar(64) — Primary key — NOT NULL
  • JobType — varchar(32) — Primary key — NOT NULL
  • Project Code (PJT_NO) — varchar(32) — Primary key — NOT NULL
  • Discipline — varchar(64)
  • Mail Address (MailAddr) — varchar(128)
  • Create ID (CreateBy) — varchar(64)
  • Create Date (CreateDt) — dateTime
  • Update ID (UpdateBy) — varchar(64)
  • Update Date (UpdateDt) — dateTime

Volume Group Info [0427] (dbo.AWP_VOLUME_GROUP)

  • Volume Group Index (VG_IDX) — int — Primary key — NOT NULL
  • Project No (PJT_NO) — varchar(128)
  • Model Info (MODELINFO) — varchar(128)
  • Volume Group Name (VOLUMNEGROUP) — varchar(128)
  • Create Date (CREATEDT) — datetime
  • Create by (CREATEBY) — varchar(64)
  • Update Date (UPDATEDT) — datetime
  • Update by (UPDATEBY) — varchar(64)

Volume Info Condition [0427] (dbo.AWP_VOLUME_INFO_CONDITION)

  • Volume Info Index (VI_IDX) — int — Foreign key → Volume Info [0427].Volume Info Index
  • Attribute Name (ATT_NAME) — varchar(128)
  • Attribute Value (ATT_VALUE) — varchar(256)
  • Condition(equal,like) (CONDITION) — varchar(16)
  • And/Or (AND_OR) — varchar(3)
  • Sequence Index (IDX) — int

Volume Info Report Condition [0427] (dbo.AWO_VOLUME_INFO_REPORT)

  • Volume Info Index (VI_IDX) — int — Foreign key → Volume Info [0427].Volume Info Index
  • Attribute Name (ATT_NAME) — varchar(128)

Volume Info Report Value (dbo.AWP_VOLUME_INFO_REPORT_VALUE)

  • Volume Info Index (VI_IDX) — int — Foreign key → Volume Info [0427].Volume Info Index
  • Uid (UID) — int
  • Attribute Name (ATT_NAME) — varchar(128)
  • Attribute Value (ATT_VALUE) — varchar(max)

Volume Info [0427] (dbo.AWP_VOLUME_INFO)

  • Volume Info Index (VI_IDX) — int — Primary key
  • Volume List Index (VL_IDX) — int — Foreign key → Volume List Info [0427].Volume List Index
  • Volume Name (VOLUME_NAME) — varchar(128)
  • Description (DESC) — varchar(max)
  • Create Mode (CREATE_MODE) — varchar(2)
  • Group Code (GROUP_CODE) — varchar(16)
  • Select By (SELECTBY) — varchar(16)
  • Create Date (CREATEDT) — datetime
  • Create By (CREATEBY) — varchar(64)
  • Update Date (UPDATEDT) — datetime
  • Volume Color (COLOR) — varchar(32)
  • Update by (UPDATEBY) — varchar(64)
  • Min x (MIN_X) — float
  • Min y (MIN_Y) — float
  • Min z (MIN_Z) — float
  • Max x (MAX_X) — float
  • Max y (MAX_Y) — float
  • Max z (MAX_Z) — float
  • Quantity (QTY) — in

Volume List Info [0427] (dbo.AWP_VOLUME_LIST)

  • Volume List Index (VL_IDX) — int — Primary key
  • Volume Group Index (VG_IDX) — int — Foreign key → Volume Group Info [0427].Volume Group Index — NOT NULL
  • Discipline (DISCIPLINE) — varchar(64)
  • Volume List Name (VL_NAME) — varchar(128)
  • Description (DESC) — varchar(max)
  • Create Date (CREATDT) — datetime
  • Create By (CREATEBY) — varchar(64)
  • Update Date (UPDATEDT) — datetime
  • Update by (UPDATEBY) — varchar(64)