Advertisement
psi_mmobile

Untitled

Jul 8th, 2022
1,566
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 4.46 KB | None | 0 0
  1.  
  2.   CREATE TABLE "OF_OWNER"."DEBUG_WBS"
  3.    (    "WBS_ID" NUMBER(10,0) NOT NULL ENABLE,
  4.     "OPERATION_CENTER_ID" NUMBER(10,0),
  5.     "NAME" VARCHAR2(200 BYTE),
  6.     "WBS_LEVEL" NUMBER(10,0),
  7.     "EFFORT" NUMBER(15,5),
  8.     "FROM_DATE" DATE,
  9.     "TO_DATE" DATE,
  10.     "DESCRIPTION" VARCHAR2(2000 BYTE),
  11.     "PARENT_WBS_ID" NUMBER(10,0),
  12.     "REF_NUMBER" VARCHAR2(255 BYTE),
  13.     "POI_ID" NUMBER(10,0),
  14.     "VO_PERSON_CATEGORY_ID" NUMBER(10,0),
  15.     "VEHICLE_ID" NUMBER,
  16.     "POI_TIN" VARCHAR2(50 BYTE),
  17.     "BE_NAME" VARCHAR2(200 BYTE),
  18.     "BE_REF_NUMBER" VARCHAR2(50 BYTE),
  19.     "VEHICLE_OWNER_ID" NUMBER(10,0),
  20.     "WBS_STATUS_ID" NUMBER(10,0),
  21.     "OC_CALENDAR_ID" NUMBER(10,0),
  22.     "PAUSE_MIN" NUMBER(10,0),
  23.     "PAUSE_MORNING_MIN" NUMBER(10,0),
  24.     "SHORT_DESCRIPTION" VARCHAR2(200 BYTE),
  25.     "IS_PROJECT" CHAR(1 BYTE),
  26.     "WBS_TASK_TYPE_ID" NUMBER(10,0),
  27.     "PLANNED_HR" NUMBER(10,5),
  28.     "ORDER_NUM" NUMBER(10,0),
  29.     "IS_WORK_TIME_REPORTED" CHAR(1 BYTE),
  30.     "CAN_ASSIGN_TEAM" CHAR(1 BYTE),
  31.     "SHORT_NAME" VARCHAR2(50 BYTE),
  32.     "LM_DATE" DATE,
  33.     "WBS_PATH" VARCHAR2(2000 BYTE),
  34.     "PERCENTAGE_COMPLETED" NUMBER(10,0),
  35.     "PERCENTAGE_COMPLETED_DATE" DATE,
  36.     "WORKING_SCHEDULE_ID" NUMBER(10,0),
  37.     "HR_INPUT_FORMAT_ID" NUMBER(10,0),
  38.     "VALIDATION_STATUS_ID" NUMBER(10,0),
  39.     "EXPORT_TO_PAYROLL" CHAR(1 BYTE),
  40.     "EXPORT_TO_PAYROLL_DAY_ID" NUMBER(10,0),
  41.     "TRAJECT_CHECK_BOX" CHAR(1 BYTE),
  42.     "TRANSPORT_CHECK_BOX" CHAR(1 BYTE),
  43.     "MEAL_ALLOWANCE_CHECK_BOX" CHAR(1 BYTE),
  44.     "LONG_DISTANCE_CHECK_BOX" CHAR(1 BYTE),
  45.     "PAUSE_TAKEN_CHECK_BOX" CHAR(1 BYTE),
  46.     "VEHICLE_ID_CHECK_BOX" CHAR(1 BYTE),
  47.     "VEHICLE_KM_FIELD" CHAR(1 BYTE),
  48.     "PRIVATE_KM_FIELD" CHAR(1 BYTE),
  49.     "PRIVATE_VEHICLE_CHECK_BOX" CHAR(1 BYTE),
  50.     "CUSTOMER_SIGNATURE_REQUESTED" CHAR(1 BYTE),
  51.     "DEFAULT_TIME_SHEET_HRD" NUMBER(15,5),
  52.     "PAUSE_TAKEN_DEFAULT_VALUE" CHAR(1 BYTE),
  53.     "LM_NAME" VARCHAR2(50 BYTE),
  54.     "BICYCLE_KM_FIELD" CHAR(1 BYTE),
  55.     "ON_FOOT_CHECK_BOX" CHAR(1 BYTE),
  56.     "PUBLIC_TRANSPORT_CHECK_BOX" CHAR(1 BYTE),
  57.     "ON_FOOT_KM_FIELD" CHAR(1 BYTE),
  58.     "MAX_WORKED_HR_PER_ACTIVITY" NUMBER(10,5),
  59.     "EXTERNAL_VALIDATION" CHAR(1 BYTE),
  60.     "USE_DECL_WRK_LOC_AND_JOURNEY" CHAR(1 BYTE),
  61.     "ERP_ID" VARCHAR2(255 BYTE),
  62.     "DISPLAY_PROJECT" CHAR(1 BYTE),
  63.     "DISPLAY_SUB_PROJECT" CHAR(1 BYTE),
  64.     "HRD_REP_ON_OC_POI_CATEGORY_ID" NUMBER(10,0),
  65.     "IS_HRD_REPORTED_ON_ACTIVITY" CHAR(1 BYTE),
  66.     "MAINTENANCE_CHECK_BOX" CHAR(1 BYTE),
  67.     "LAUNDRY_CHECK_BOX" CHAR(1 BYTE),
  68.     "DAY_JOURNEY_ROLE_COMBO" CHAR(1 BYTE),
  69.     "USE_DEFAULT_VO_PARAMS" CHAR(1 BYTE),
  70.     "PASSENGER_KM_FIELD" CHAR(1 BYTE),
  71.     "DRIVER_KM_FIELD" CHAR(1 BYTE),
  72.     "USE_TSL_WORK_LOCATION" CHAR(1 BYTE),
  73.     "USE_TSL_DECLARED_VEHICLE" CHAR(1 BYTE),
  74.     "USE_FREE_TEXT_REF_NUMBER" CHAR(1 BYTE),
  75.     "LAUNDRY_IS_NEVER_PAID" CHAR(1 BYTE),
  76.     "OBJECT_MODEL_ID" NUMBER(10,0),
  77.     "TRANSPORT_DURATION_FIELD" CHAR(1 BYTE),
  78.     "PAUSE_DURATION_FIELD" CHAR(1 BYTE),
  79.     "WE_BLOCKED_FIELD" CHAR(1 BYTE),
  80.     "VO_DIVISION_ID" NUMBER(10,0),
  81.     "MAIN_CONTRACTOR_ID" NUMBER(10,0),
  82.     "WAS_WORKING_LATE_CHECK_BOX" CHAR(1 BYTE),
  83.     "MISSION_KM_FIELD" CHAR(1 BYTE),
  84.     "OVERNIGHT_STAY_CHECK_BOX" CHAR(1 BYTE),
  85.     "IS_CLONE_OF_WBS_ID" NUMBER(10,0),
  86.     "ERP_ID2" VARCHAR2(50 BYTE),
  87.     "START_AND_STOP_TIME_FIELD" CHAR(1 BYTE),
  88.     "USE_START_STOP_TIME_FOR_DAY_HRD" CHAR(1 BYTE),
  89.     "HARD_WORK_CHECK_BOX" CHAR(1 BYTE),
  90.     "DANGEROUS_WORK_CHECK_BOX" CHAR(1 BYTE),
  91.     "INSALUBRITY_WORK_CHECK_BOX" CHAR(1 BYTE),
  92.     "HEIGHT_WORK_CHECK_BOX" CHAR(1 BYTE),
  93.     "LONG_DISTANCE_EXTRA_FIELD" CHAR(1 BYTE),
  94.     "COMPANY_SITE_OC_POI_ID" NUMBER(10,0),
  95.     "PLANNED_BUDGET" NUMBER(15,5),
  96.     "ALLOW_PICTURE_ON_TSL" VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,
  97.     "NBR_PASSENGER_FIELD" VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,
  98.     "SUB_PAUSE_FROM_TOT_HR_WHEN_START_STOP_HIF" VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,
  99.     "REPORTED_HR" NUMBER(15,5),
  100.     "REPORTED_BUDGET" NUMBER(15,5),
  101.     "CLIENT_NAME" VARCHAR2(200 BYTE),
  102.     "PLANNED_TURNOVER" NUMBER(15,5),
  103.     "IS_ALREADY_INVOICED" VARCHAR2(1 BYTE),
  104.     "WARNING_WHEN_REPORTING_HOURS" CHAR(1 BYTE),
  105.     "TSL_DECLARED_VEH_MANDATORY" CHAR(1 BYTE),
  106.     "OLD_WBS_ID" NUMBER(10,0),
  107.     "OLD_REF_NUMBER" VARCHAR2(255 BYTE),
  108.     "LAST_MODIFIED_DATE" DATE,
  109.     "CURRENT_USER" VARCHAR2(200 BYTE),
  110.     "OLD_NAME" VARCHAR2(200 BYTE)
  111.    ) SEGMENT CREATION IMMEDIATE
  112.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  113.  NOCOMPRESS LOGGING
  114.   STORAGE(INITIAL 393216 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  115.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  116.   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  117.   TABLESPACE "FLEETDATA" ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement