Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE "OF_OWNER"."DEBUG_WBS"
- ( "WBS_ID" NUMBER(10,0) NOT NULL ENABLE,
- "OPERATION_CENTER_ID" NUMBER(10,0),
- "NAME" VARCHAR2(200 BYTE),
- "WBS_LEVEL" NUMBER(10,0),
- "EFFORT" NUMBER(15,5),
- "FROM_DATE" DATE,
- "TO_DATE" DATE,
- "DESCRIPTION" VARCHAR2(2000 BYTE),
- "PARENT_WBS_ID" NUMBER(10,0),
- "REF_NUMBER" VARCHAR2(255 BYTE),
- "POI_ID" NUMBER(10,0),
- "VO_PERSON_CATEGORY_ID" NUMBER(10,0),
- "VEHICLE_ID" NUMBER,
- "POI_TIN" VARCHAR2(50 BYTE),
- "BE_NAME" VARCHAR2(200 BYTE),
- "BE_REF_NUMBER" VARCHAR2(50 BYTE),
- "VEHICLE_OWNER_ID" NUMBER(10,0),
- "WBS_STATUS_ID" NUMBER(10,0),
- "OC_CALENDAR_ID" NUMBER(10,0),
- "PAUSE_MIN" NUMBER(10,0),
- "PAUSE_MORNING_MIN" NUMBER(10,0),
- "SHORT_DESCRIPTION" VARCHAR2(200 BYTE),
- "IS_PROJECT" CHAR(1 BYTE),
- "WBS_TASK_TYPE_ID" NUMBER(10,0),
- "PLANNED_HR" NUMBER(10,5),
- "ORDER_NUM" NUMBER(10,0),
- "IS_WORK_TIME_REPORTED" CHAR(1 BYTE),
- "CAN_ASSIGN_TEAM" CHAR(1 BYTE),
- "SHORT_NAME" VARCHAR2(50 BYTE),
- "LM_DATE" DATE,
- "WBS_PATH" VARCHAR2(2000 BYTE),
- "PERCENTAGE_COMPLETED" NUMBER(10,0),
- "PERCENTAGE_COMPLETED_DATE" DATE,
- "WORKING_SCHEDULE_ID" NUMBER(10,0),
- "HR_INPUT_FORMAT_ID" NUMBER(10,0),
- "VALIDATION_STATUS_ID" NUMBER(10,0),
- "EXPORT_TO_PAYROLL" CHAR(1 BYTE),
- "EXPORT_TO_PAYROLL_DAY_ID" NUMBER(10,0),
- "TRAJECT_CHECK_BOX" CHAR(1 BYTE),
- "TRANSPORT_CHECK_BOX" CHAR(1 BYTE),
- "MEAL_ALLOWANCE_CHECK_BOX" CHAR(1 BYTE),
- "LONG_DISTANCE_CHECK_BOX" CHAR(1 BYTE),
- "PAUSE_TAKEN_CHECK_BOX" CHAR(1 BYTE),
- "VEHICLE_ID_CHECK_BOX" CHAR(1 BYTE),
- "VEHICLE_KM_FIELD" CHAR(1 BYTE),
- "PRIVATE_KM_FIELD" CHAR(1 BYTE),
- "PRIVATE_VEHICLE_CHECK_BOX" CHAR(1 BYTE),
- "CUSTOMER_SIGNATURE_REQUESTED" CHAR(1 BYTE),
- "DEFAULT_TIME_SHEET_HRD" NUMBER(15,5),
- "PAUSE_TAKEN_DEFAULT_VALUE" CHAR(1 BYTE),
- "LM_NAME" VARCHAR2(50 BYTE),
- "BICYCLE_KM_FIELD" CHAR(1 BYTE),
- "ON_FOOT_CHECK_BOX" CHAR(1 BYTE),
- "PUBLIC_TRANSPORT_CHECK_BOX" CHAR(1 BYTE),
- "ON_FOOT_KM_FIELD" CHAR(1 BYTE),
- "MAX_WORKED_HR_PER_ACTIVITY" NUMBER(10,5),
- "EXTERNAL_VALIDATION" CHAR(1 BYTE),
- "USE_DECL_WRK_LOC_AND_JOURNEY" CHAR(1 BYTE),
- "ERP_ID" VARCHAR2(255 BYTE),
- "DISPLAY_PROJECT" CHAR(1 BYTE),
- "DISPLAY_SUB_PROJECT" CHAR(1 BYTE),
- "HRD_REP_ON_OC_POI_CATEGORY_ID" NUMBER(10,0),
- "IS_HRD_REPORTED_ON_ACTIVITY" CHAR(1 BYTE),
- "MAINTENANCE_CHECK_BOX" CHAR(1 BYTE),
- "LAUNDRY_CHECK_BOX" CHAR(1 BYTE),
- "DAY_JOURNEY_ROLE_COMBO" CHAR(1 BYTE),
- "USE_DEFAULT_VO_PARAMS" CHAR(1 BYTE),
- "PASSENGER_KM_FIELD" CHAR(1 BYTE),
- "DRIVER_KM_FIELD" CHAR(1 BYTE),
- "USE_TSL_WORK_LOCATION" CHAR(1 BYTE),
- "USE_TSL_DECLARED_VEHICLE" CHAR(1 BYTE),
- "USE_FREE_TEXT_REF_NUMBER" CHAR(1 BYTE),
- "LAUNDRY_IS_NEVER_PAID" CHAR(1 BYTE),
- "OBJECT_MODEL_ID" NUMBER(10,0),
- "TRANSPORT_DURATION_FIELD" CHAR(1 BYTE),
- "PAUSE_DURATION_FIELD" CHAR(1 BYTE),
- "WE_BLOCKED_FIELD" CHAR(1 BYTE),
- "VO_DIVISION_ID" NUMBER(10,0),
- "MAIN_CONTRACTOR_ID" NUMBER(10,0),
- "WAS_WORKING_LATE_CHECK_BOX" CHAR(1 BYTE),
- "MISSION_KM_FIELD" CHAR(1 BYTE),
- "OVERNIGHT_STAY_CHECK_BOX" CHAR(1 BYTE),
- "IS_CLONE_OF_WBS_ID" NUMBER(10,0),
- "ERP_ID2" VARCHAR2(50 BYTE),
- "START_AND_STOP_TIME_FIELD" CHAR(1 BYTE),
- "USE_START_STOP_TIME_FOR_DAY_HRD" CHAR(1 BYTE),
- "HARD_WORK_CHECK_BOX" CHAR(1 BYTE),
- "DANGEROUS_WORK_CHECK_BOX" CHAR(1 BYTE),
- "INSALUBRITY_WORK_CHECK_BOX" CHAR(1 BYTE),
- "HEIGHT_WORK_CHECK_BOX" CHAR(1 BYTE),
- "LONG_DISTANCE_EXTRA_FIELD" CHAR(1 BYTE),
- "COMPANY_SITE_OC_POI_ID" NUMBER(10,0),
- "PLANNED_BUDGET" NUMBER(15,5),
- "ALLOW_PICTURE_ON_TSL" VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,
- "NBR_PASSENGER_FIELD" VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,
- "SUB_PAUSE_FROM_TOT_HR_WHEN_START_STOP_HIF" VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,
- "REPORTED_HR" NUMBER(15,5),
- "REPORTED_BUDGET" NUMBER(15,5),
- "CLIENT_NAME" VARCHAR2(200 BYTE),
- "PLANNED_TURNOVER" NUMBER(15,5),
- "IS_ALREADY_INVOICED" VARCHAR2(1 BYTE),
- "WARNING_WHEN_REPORTING_HOURS" CHAR(1 BYTE),
- "TSL_DECLARED_VEH_MANDATORY" CHAR(1 BYTE),
- "OLD_WBS_ID" NUMBER(10,0),
- "OLD_REF_NUMBER" VARCHAR2(255 BYTE),
- "LAST_MODIFIED_DATE" DATE,
- "CURRENT_USER" VARCHAR2(200 BYTE),
- "OLD_NAME" VARCHAR2(200 BYTE)
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
- NOCOMPRESS LOGGING
- STORAGE(INITIAL 393216 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
- BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "FLEETDATA" ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement