Oracle Utilities Operational Device Management V2.2.0.6.0 to V2.4.0.0.0

New Tables

The following tables are added to Oracle Utilities Operational Device Management in this release:

Table_Name
W1_ACTIVITY_MEASUREMENT_TYPE
W1_ADJUSTMENT
W1_ADJUSTMENT_CHAR
W1_ADJUSTMENT_DOCUMENT
W1_ADJUSTMENT_DTL
W1_ADJUSTMENT_IDENTIFIER
W1_ADJUSTMENT_LOG
W1_ADJUSTMENT_LOG_PARM
W1_ADJUSTMENT_TYPE
W1_ADJUSTMENT_TYPE_CHAR
W1_ADJUSTMENT_TYPE_L
W1_CHANGE_REQ
W1_CHANGE_REQ_APPR_PROF
W1_CHANGE_REQ_CHAR
W1_CHANGE_REQ_DOCUMENT
W1_CHANGE_REQ_K
W1_CHANGE_REQ_LOG
W1_CHANGE_REQ_LOG_PARM
W1_CHANGE_REQ_TYPE
W1_CHANGE_REQ_TYPE_CHAR
W1_CHANGE_REQ_TYPE_L
W1_CREW_STR_ASSN
W1_EMP_AUTO_TIMESHEET
W1_EU_TIMESHEET
W1_PROCESS
W1_PROCESS_CHAR
W1_PROCESS_DOCUMENT
W1_PROCESS_IDENTIFIER
W1_PROCESS_K
W1_PROCESS_LOC
W1_PROCESS_LOG
W1_PROCESS_LOG_PARM
W1_PROCESS_TYPE
W1_PROCESS_TYPE_CHAR
W1_PROCESS_TYPE_L
W1_PROJECT_CATEGORY_LOG
W1_PROJECT_CATEGORY_LOG_PARM
W1_RCPT_LINE_SHIP_DEFICIENCY
W1_SHIP_DEFICIENCY_TYPE
W1_SHIP_DEFICIENCY_TYPE_CHAR
W1_SHIP_DEFICIENCY_TYPE_L
W1_SHIPPING_LINE
W1_SHIPPING_LINE_ASSET
W1_SHIPPING_LINE_CHAR
W1_SHIPPING_LINE_K
W1_SHIPPING_LINE_LOT
W1_SHIPPING_MEMO
W1_SHIPPING_MEMO_CHAR
W1_SHIPPING_MEMO_DOCUMENT
W1_SHIPPING_MEMO_IDENTIFIER
W1_SHIPPING_MEMO_K
W1_SHIPPING_MEMO_LOG
W1_SHIPPING_MEMO_LOG_PARM
W1_SHIPPING_MEMO_NOTE
W1_TIMEKEEPER
W1_TIMEKEEPER_CHAR
W1_TIMEKEEPER_EMP
W1_TIMEKEEPER_L
W1_TIMEKEEPER_LOG
W1_TIMEKEEPER_LOG_PARM
W1_VENDOR_LOC_PAYTO_LOC
W1_VENDOR_LOG
W1_VENDOR_LOG_PARM

Dropped Tables

There are no dropped tables in this Oracle Utilities Operational Device Management release.

New Fields

The following fields are added to Oracle Utilities Operational Device Management in this release:

Table_Name	Column_Name	Data Type	Data Length
W1_ACTIVITY_MEASUREMENT_TYPE	ACT_ID	CHAR	14
W1_ACTIVITY_MEASUREMENT_TYPE	MEASUREMENT_TYPE_CD	VARCHAR2	30
W1_ACTIVITY_MEASUREMENT_TYPE	VERSION	NUMBER	22
W1_ADJUSTMENT	ADJUSTMENT_ID	CHAR	14
W1_ADJUSTMENT	ADJUSTMENT_TYPE_CD	VARCHAR2	30
W1_ADJUSTMENT	APPROVAL_PROF_CD	VARCHAR2	30
W1_ADJUSTMENT	BO_DATA_AREA	CLOB	4000
W1_ADJUSTMENT	BO_STATUS_CD	CHAR	12
W1_ADJUSTMENT	BO_STATUS_REASON_CD	VARCHAR2	30
W1_ADJUSTMENT	BUS_OBJ_CD	CHAR	30
W1_ADJUSTMENT	CREATE_BY_USER	CHAR	8
W1_ADJUSTMENT	CRE_DTTM	DATE	7
W1_ADJUSTMENT	CURRENCY_CD	CHAR	3
W1_ADJUSTMENT	DESCR100	VARCHAR2	100
W1_ADJUSTMENT	DESCR254	VARCHAR2	254
W1_ADJUSTMENT	STATUS_UPD_DTTM	DATE	7
W1_ADJUSTMENT	TRANSFER_FLG	CHAR	4
W1_ADJUSTMENT	VERSION	NUMBER	22
W1_ADJUSTMENT_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_ADJUSTMENT_CHAR	ADJUSTMENT_ID	CHAR	14
W1_ADJUSTMENT_CHAR	CHAR_TYPE_CD	CHAR	8
W1_ADJUSTMENT_CHAR	CHAR_VAL	CHAR	16
W1_ADJUSTMENT_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_ADJUSTMENT_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_ADJUSTMENT_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_ADJUSTMENT_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_ADJUSTMENT_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_ADJUSTMENT_CHAR	SEQ_NUM	NUMBER	22
W1_ADJUSTMENT_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_ADJUSTMENT_CHAR	VERSION	NUMBER	22
W1_ADJUSTMENT_DOCUMENT	ADJUSTMENT_ID	CHAR	14
W1_ADJUSTMENT_DOCUMENT	ATTACHMENT_ID	CHAR	14
W1_ADJUSTMENT_DOCUMENT	CRE_DTTM	DATE	7
W1_ADJUSTMENT_DOCUMENT	DOCUMENT_ID	CHAR	12
W1_ADJUSTMENT_DOCUMENT	USER_ID	CHAR	8
W1_ADJUSTMENT_DOCUMENT	VERSION	NUMBER	22
W1_ADJUSTMENT_DTL	ACT_ID	CHAR	14
W1_ADJUSTMENT_DTL	ADJUSTMENT_ID	CHAR	14
W1_ADJUSTMENT_DTL	AMT	NUMBER	22
W1_ADJUSTMENT_DTL	COST_CENTER_CD	VARCHAR2	30
W1_ADJUSTMENT_DTL	EXPENSE_CD	VARCHAR2	30
W1_ADJUSTMENT_DTL	PRJ_ID	CHAR	12
W1_ADJUSTMENT_DTL	VERSION	NUMBER	22
W1_ADJUSTMENT_IDENTIFIER	ADJUSTMENT_ID	CHAR	14
W1_ADJUSTMENT_IDENTIFIER	ADJUSTMENT_ID_TYPE_FLG	CHAR	4
W1_ADJUSTMENT_IDENTIFIER	VERSION	NUMBER	22
W1_ADJUSTMENT_IDENTIFIER	W1_ID_VALUE	VARCHAR2	60
W1_ADJUSTMENT_LOG	ADHOC_CHAR_VAL	VARCHAR2	254
W1_ADJUSTMENT_LOG	ADJUSTMENT_ID	CHAR	14
W1_ADJUSTMENT_LOG	BO_STATUS_CD	CHAR	12
W1_ADJUSTMENT_LOG	BO_STATUS_REASON_CD	VARCHAR2	30
W1_ADJUSTMENT_LOG	CHAR_TYPE_CD	CHAR	8
W1_ADJUSTMENT_LOG	CHAR_VAL	CHAR	16
W1_ADJUSTMENT_LOG	CHAR_VAL_FK1	VARCHAR2	50
W1_ADJUSTMENT_LOG	CHAR_VAL_FK2	VARCHAR2	50
W1_ADJUSTMENT_LOG	CHAR_VAL_FK3	VARCHAR2	50
W1_ADJUSTMENT_LOG	CHAR_VAL_FK4	VARCHAR2	50
W1_ADJUSTMENT_LOG	CHAR_VAL_FK5	VARCHAR2	50
W1_ADJUSTMENT_LOG	DESCRLONG	VARCHAR2	4000
W1_ADJUSTMENT_LOG	LOG_DTTM	DATE	7
W1_ADJUSTMENT_LOG	LOG_ENTRY_TYPE_FLG	CHAR	4
W1_ADJUSTMENT_LOG	MESSAGE_CAT_NBR	NUMBER	22
W1_ADJUSTMENT_LOG	MESSAGE_NBR	NUMBER	22
W1_ADJUSTMENT_LOG	SEQNO	NUMBER	22
W1_ADJUSTMENT_LOG	USER_ID	CHAR	8
W1_ADJUSTMENT_LOG	VERSION	NUMBER	22
W1_ADJUSTMENT_LOG_PARM	ADJUSTMENT_ID	CHAR	14
W1_ADJUSTMENT_LOG_PARM	F1_MSG_PARM_VLONG	VARCHAR2	2000
W1_ADJUSTMENT_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	4
W1_ADJUSTMENT_LOG_PARM	PARM_SEQ	NUMBER	22
W1_ADJUSTMENT_LOG_PARM	SEQNO	CHAR	5
W1_ADJUSTMENT_LOG_PARM	VERSION	NUMBER	22
W1_ADJUSTMENT_TYPE	ADJUSTMENT_BUS_OBJ_CD	CHAR	30
W1_ADJUSTMENT_TYPE	ADJUSTMENT_TYPE_CD	VARCHAR2	30
W1_ADJUSTMENT_TYPE	APPROVAL_PROF_CD	VARCHAR2	30
W1_ADJUSTMENT_TYPE	BO_DATA_AREA	CLOB	4000
W1_ADJUSTMENT_TYPE	BUS_OBJ_CD	CHAR	30
W1_ADJUSTMENT_TYPE	DISTRIBUTION_CD	VARCHAR2	30
W1_ADJUSTMENT_TYPE	OFFSET_COST_CENTER_CD	VARCHAR2	30
W1_ADJUSTMENT_TYPE	OFFSET_EXPENSE_CD	VARCHAR2	30
W1_ADJUSTMENT_TYPE	OWNING_ACCESS_GRP_CD	CHAR	12
W1_ADJUSTMENT_TYPE	VERSION	NUMBER	22
W1_ADJUSTMENT_TYPE_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_ADJUSTMENT_TYPE_CHAR	ADJUSTMENT_TYPE_CD	VARCHAR2	30
W1_ADJUSTMENT_TYPE_CHAR	CHAR_TYPE_CD	CHAR	8
W1_ADJUSTMENT_TYPE_CHAR	CHAR_VAL	CHAR	16
W1_ADJUSTMENT_TYPE_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_ADJUSTMENT_TYPE_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_ADJUSTMENT_TYPE_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_ADJUSTMENT_TYPE_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_ADJUSTMENT_TYPE_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_ADJUSTMENT_TYPE_CHAR	SEQ_NUM	NUMBER	22
W1_ADJUSTMENT_TYPE_CHAR	SRCH_CHAR_VAL	VARCHAR2	22
W1_ADJUSTMENT_TYPE_CHAR	VERSION	NUMBER	22
W1_ADJUSTMENT_TYPE_L	ADJUSTMENT_TYPE_CD	VARCHAR2	30
W1_ADJUSTMENT_TYPE_L	DESCR100	VARCHAR2	100
W1_ADJUSTMENT_TYPE_L	LANGUAGE_CD	CHAR	3
W1_ADJUSTMENT_TYPE_L	VERSION	NUMBER	22
W1_ASSESS_GRP	BUS_OBJ_CD	CHAR	30
W1_ASSET	CALENDAR_PM_RESET_DT	DATE	7
W1_ASSET_NODE	ACT_ID	CHAR	14
W1_CHANGE_REQ	APPROVAL_PROF_CD	VARCHAR2	30
W1_CHANGE_REQ	BO_DATA_AREA	CLOB	4000
W1_CHANGE_REQ	BO_STATUS_CD	CHAR	12
W1_CHANGE_REQ	BO_STATUS_REASON_CD	VARCHAR2	30
W1_CHANGE_REQ	BUS_OBJ_CD	CHAR	30
W1_CHANGE_REQ	CHANGE_REQ_ID	CHAR	14
W1_CHANGE_REQ	CHANGE_REQ_NUM	VARCHAR2	14
W1_CHANGE_REQ	CHANGE_REQ_TYPE_CD	VARCHAR2	30
W1_CHANGE_REQ	CRE_DTTM	DATE	7
W1_CHANGE_REQ	DESCR100	VARCHAR2	100
W1_CHANGE_REQ	DESCRLONG	VARCHAR2	4000
W1_CHANGE_REQ	FINAL_DTTM	DATE	7
W1_CHANGE_REQ	IMPACT	VARCHAR2	4000
W1_CHANGE_REQ	JUSTIFICATION	VARCHAR2	4000
W1_CHANGE_REQ	MAINT_OBJ_CD	CHAR	12
W1_CHANGE_REQ	PK_VALUE1	VARCHAR2	254
W1_CHANGE_REQ	PK_VALUE2	VARCHAR2	254
W1_CHANGE_REQ	PK_VALUE3	VARCHAR2	254
W1_CHANGE_REQ	PK_VALUE4	VARCHAR2	254
W1_CHANGE_REQ	PK_VALUE5	VARCHAR2	254
W1_CHANGE_REQ	REQUESTOR_ID	CHAR	8
W1_CHANGE_REQ	REQUIRED_BY_DT	DATE	7
W1_CHANGE_REQ	STATUS_UPD_DTTM	DATE	7
W1_CHANGE_REQ	USER_ID	CHAR	8
W1_CHANGE_REQ	VERSION	NUMBER	22
W1_CHANGE_REQ	W1_DESCR100_UPR	VARCHAR2	100
W1_CHANGE_REQ_APPR_PROF	APPROVAL_PROF_CD	VARCHAR2	30
W1_CHANGE_REQ_APPR_PROF	CHANGE_REQ_TYPE_CD	VARCHAR2	30
W1_CHANGE_REQ_APPR_PROF	VERSION	NUMBER	22
W1_CHANGE_REQ_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_CHANGE_REQ_CHAR	CHANGE_REQ_ID	CHAR	14
W1_CHANGE_REQ_CHAR	CHAR_TYPE_CD	CHAR	8
W1_CHANGE_REQ_CHAR	CHAR_VAL	CHAR	16
W1_CHANGE_REQ_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_CHANGE_REQ_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_CHANGE_REQ_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_CHANGE_REQ_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_CHANGE_REQ_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_CHANGE_REQ_CHAR	SEQ_NUM	NUMBER	22
W1_CHANGE_REQ_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_CHANGE_REQ_CHAR	VERSION	NUMBER	22
W1_CHANGE_REQ_ DOCUMENT	ATTACHMENT_ID	CHAR	14
W1_CHANGE_REQ_ DOCUMENT	CHANGE_REQ_ID	CHAR	14
W1_CHANGE_REQ_ DOCUMENT	CRE_DTTM	DATE	7
W1_CHANGE_REQ_ DOCUMENT	DOCUMENT_ID	CHAR	12
W1_CHANGE_REQ_ DOCUMENT	USER_ID	CHAR	8
W1_CHANGE_REQ_ DOCUMENT	VERSION	NUMBER	22
W1_CHANGE_REQ_K	CHANGE_REQ_ID	CHAR	14
W1_CHANGE_REQ_K	ENV_ID	NUMBER	22
W1_CHANGE_REQ_LOG	ADHOC_CHAR_VAL	VARCHAR2	254
W1_CHANGE_REQ_LOG	BO_STATUS_CD	CHAR	12
W1_CHANGE_REQ_LOG	BO_STATUS_REASON_CD	VARCHAR2	30
W1_CHANGE_REQ_LOG	CHANGE_REQ_ID	CHAR	14
W1_CHANGE_REQ_LOG	CHAR_TYPE_CD	CHAR	8
W1_CHANGE_REQ_LOG	CHAR_VAL	CHAR	16
W1_CHANGE_REQ_LOG	CHAR_VAL_FK1	VARCHAR2	50
W1_CHANGE_REQ_LOG	CHAR_VAL_FK2	VARCHAR2	50
W1_CHANGE_REQ_LOG	CHAR_VAL_FK3	VARCHAR2	50
W1_CHANGE_REQ_LOG	CHAR_VAL_FK4	VARCHAR2	50
W1_CHANGE_REQ_LOG	CHAR_VAL_FK5	VARCHAR2	50
W1_CHANGE_REQ_LOG	DESCRLONG	VARCHAR2	4000
W1_CHANGE_REQ_LOG	LOG_DTTM	DATE	7
W1_CHANGE_REQ_LOG	LOG_ENTRY_TYPE_FLG	CHAR	4
W1_CHANGE_REQ_LOG	MESSAGE_CAT_NBR	NUMBER	22
W1_CHANGE_REQ_LOG	MESSAGE_NBR	NUMBER	22
W1_CHANGE_REQ_LOG	SEQNO	NUMBER	22
W1_CHANGE_REQ_LOG	USER_ID	CHAR	8
W1_CHANGE_REQ_LOG	VERSION	NUMBER	22
W1_CHANGE_REQ_LOG_PARM	CHANGE_REQ_ID	CHAR	14
W1_CHANGE_REQ_LOG_PARM	F1_MSG_PARM_VLONG	VARCHAR2	2000
W1_CHANGE_REQ_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	4
W1_CHANGE_REQ_LOG_PARM	PARM_SEQ	NUMBER	22
W1_CHANGE_REQ_LOG_PARM	SEQNO	NUMBER	22
W1_CHANGE_REQ_LOG_PARM	VERSION	NUMBER	22
W1_CHANGE_REQ_TYPE	BO_DATA_AREA	CLOB	4000
W1_CHANGE_REQ_TYPE	BUS_OBJ_CD	CHAR	30
W1_CHANGE_REQ_TYPE	CHANGE_REQ_BUS_OBJ_CD	CHAR	30
W1_CHANGE_REQ_TYPE	CHANGE_REQ_TYPE_CD	VARCHAR2	30
W1_CHANGE_REQ_TYPE	REL_OBJ_FLG	VARCHAR2	254
W1_CHANGE_REQ_TYPE	VERSION	NUMBER	22
W1_CHANGE_REQ_TYPE_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_CHANGE_REQ_TYPE_CHAR	CHANGE_REQ_TYPE_CD	VARCHAR2	30
W1_CHANGE_REQ_TYPE_CHAR	CHAR_TYPE_CD	CHAR	8
W1_CHANGE_REQ_TYPE_CHAR	CHAR_VAL	CHAR	16
W1_CHANGE_REQ_TYPE_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_CHANGE_REQ_TYPE_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_CHANGE_REQ_TYPE_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_CHANGE_REQ_TYPE_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_CHANGE_REQ_TYPE_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_CHANGE_REQ_TYPE_CHAR	SEQ_NUM	NUMBER	22
W1_CHANGE_REQ_TYPE_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_CHANGE_REQ_TYPE_CHAR	VERSION	NUMBER	22
W1_CHANGE_REQ_TYPE_L	CHANGE_REQ_TYPE_CD	VARCHAR2	30
W1_CHANGE_REQ_TYPE_L	DESCR100	VARCHAR2	100
W1_CHANGE_REQ_TYPE_L	LANGUAGE_CD	CHAR	3
W1_CHANGE_REQ_TYPE_L	VERSION	NUMBER	22
W1_CREW_STR_ASSN	NODE_ID	CHAR	12
W1_CREW_STR_ASSN	PRIMARY_FLG	CHAR	4
W1_CREW_STR_ASSN	STOREROOM_CAT_FLG	CHAR	4
W1_CREW_STR_ASSN	VERSION	NUMBER	22
W1_CREW_STR_ASSN	W1_CREW_ID	CHAR	12
W1_EMPLOYEE	AUTO_TS_CREATION	CHAR	1
W1_EMPLOYEE	AUTO_TS_CRE_END_DT	DATE	7
W1_EMPLOYEE	AUTO_TS_CRE_START_DT	DATE	7
W1_EMPLOYEE	CALENDAR_CD	CHAR	8
W1_EMPLOYEE_TRAINING	EFFECTIVE_DT	DATE	7
W1_EMPLOYEE_TRAINING	EMPLOYEE_NOTIFIED	CHAR	1
W1_EMPLOYEE_TRAINING	SUPERVISOR_NOTIFIED	CHAR	1
W1_EMPLOYEE_TRAINING	W1EXPIRATION_DT	DATE	7
W1_EMP_AUTO_TIMESHEET	ACT_ID	CHAR	14
W1_EMP_AUTO_TIMESHEET	CHARGE_TYPE_FLG	CHAR	4
W1_EMP_AUTO_TIMESHEET	COST_CENTER_CD	VARCHAR2	30
W1_EMP_AUTO_TIMESHEET	CREW_SHIFT_TYPE_CD	VARCHAR2	30
W1_EMP_AUTO_TIMESHEET	EMPLOYEE_ID	CHAR	12
W1_EMP_AUTO_TIMESHEET	END_DT	DATE	7
W1_EMP_AUTO_TIMESHEET	EU_TYPE_CD	VARCHAR2	30
W1_EMP_AUTO_TIMESHEET	FRI	CHAR	1
W1_EMP_AUTO_TIMESHEET	HOURS	NUMBER	22
W1_EMP_AUTO_TIMESHEET	LABOR_EARNING_TYPE_CD	VARCHAR2	30
W1_EMP_AUTO_TIMESHEET	LAST_PROC_DT	DATE	7
W1_EMP_AUTO_TIMESHEET	MON	CHAR	1
W1_EMP_AUTO_TIMESHEET	OVERTIME_TYPE_CD	VARCHAR2	30
W1_EMP_AUTO_TIMESHEET	PRJ_ID	CHAR	12
W1_EMP_AUTO_TIMESHEET	REG_OVERTIME_FLG	CHAR	4
W1_EMP_AUTO_TIMESHEET	RESRC_TYPE_ID	CHAR	12
W1_EMP_AUTO_TIMESHEET	SAT	CHAR	1
W1_EMP_AUTO_TIMESHEET	SEQNO	NUMBER	22
W1_EMP_AUTO_TIMESHEET	START_DT	DATE	7
W1_EMP_AUTO_TIMESHEET	SUN	CHAR	1
W1_EMP_AUTO_TIMESHEET	THU	CHAR	1
W1_EMP_AUTO_TIMESHEET	TUE	CHAR	1
W1_EMP_AUTO_TIMESHEET	VERSION	NUMBER	22
W1_EMP_AUTO_TIMESHEET	WED	CHAR	1
W1_EU	AUTO_TS_CREATION	CHAR	1
W1_EU_TIMESHEET	EU_DT	DATE	7
W1_EU_TIMESHEET	EU_ID	CHAR	12
W1_EU_TIMESHEET	HOURS	NUMBER	22
W1_EU_TIMESHEET	VERSION	NUMBER	22
W1_FT	ADJUSTMENT_ID	CHAR	14
W1_MAINT_TRIGGER	AUTO_SCHEDULE_FLG	CHAR	4
W1_MAINT_TRIGGER	W1_CREW_ID	CHAR	12
W1_MAT_REQ_HEADER	MAT_REQ_HEADER_NUM	VARCHAR2	14
W1_MAT_REQ_HEADER	W1_REQUESTER_EMAIL	VARCHAR2	70
W1_NODE_TYPE	STOREROOM_CAT_FLG	CHAR	4
W1_PI_HEADER	PI_HEADER_NUM	VARCHAR2	14
W1_PO_HEADER_DOCUMENT	PRINT_FLG	CHAR	4
W1_PO_LINE	RR_ID	CHAR	14
W1_PO_LINE_DOCUMENT	PRINT_FLG	CHAR	4
W1_PROCESS	BO_DATA_AREA	CLOB	4000
W1_PROCESS	BO_STATUS_CD	CHAR	12
W1_PROCESS	BO_STATUS_REASON_CD	VARCHAR2	30
W1_PROCESS	BUS_OBJ_CD	CHAR	30
W1_PROCESS	CRE_DTTM	DATE	7
W1_PROCESS	DESCR100	VARCHAR2	100
W1_PROCESS	DESCRLONG	VARCHAR2	4000
W1_PROCESS	MAINTMGR_CD	VARCHAR2	30
W1_PROCESS	PLANNER_CD	VARCHAR2	30
W1_PROCESS	PROCESS_ID	CHAR	12
W1_PROCESS	PROCESS_TYPE_CD	VARCHAR2	30
W1_PROCESS	STATUS_UPD_DTTM	DATE	7
W1_PROCESS	VERSION	NUMBER	22
W1_PROCESS	W1_DESCR100_UPR	VARCHAR2	100
W1_PROCESS_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_PROCESS_CHAR	CHAR_TYPE_CD	CHAR	8
W1_PROCESS_CHAR	CHAR_VAL	CHAR	16
W1_PROCESS_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_PROCESS_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_PROCESS_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_PROCESS_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_PROCESS_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_PROCESS_CHAR	PROCESS_ID	CHAR	12
W1_PROCESS_CHAR	SEQ_NUM	NUMBER	22
W1_PROCESS_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_PROCESS_CHAR	VERSION	NUMBER	22
W1_PROCESS_DOCUMENT	ATTACHMENT_ID	CHAR	14
W1_PROCESS_DOCUMENT	CRE_DTTM	DATE	7
W1_PROCESS_DOCUMENT	DOCUMENT_ID	CHAR	12
W1_PROCESS_DOCUMENT	PROCESS_ID	CHAR	12
W1_PROCESS_DOCUMENT	USER_ID	CHAR	8
W1_PROCESS_DOCUMENT	VERSION	NUMBER	22
W1_PROCESS_IDENTIFIER	PROCESS_ID	CHAR	12
W1_PROCESS_IDENTIFIER	PROCESS_ID_TYPE_FLG	CHAR	4
W1_PROCESS_IDENTIFIER	VERSION	NUMBER	22
W1_PROCESS_IDENTIFIER	W1_ID_VALUE	VARCHAR2	60
W1_PROCESS_K	ENV_ID	NUMBER	22
W1_PROCESS_K	PROCESS_ID	CHAR	12
W1_PROCESS_LOC	NODE_ID	CHAR	12
W1_PROCESS_LOC	PROCESS_ID	CHAR	12
W1_PROCESS_LOC	VERSION	NUMBER	22
W1_PROCESS_LOC	W1_INCL_CHILD_FLG	CHAR	4
W1_PROCESS_LOG	ADHOC_CHAR_VAL	VARCHAR2	254
W1_PROCESS_LOG	BO_STATUS_CD	CHAR	12
W1_PROCESS_LOG	BO_STATUS_REASON_CD	VARCHAR2	30
W1_PROCESS_LOG	CHAR_TYPE_CD	CHAR	8
W1_PROCESS_LOG	CHAR_VAL	CHAR	16
W1_PROCESS_LOG	CHAR_VAL_FK1	VARCHAR2	50
W1_PROCESS_LOG	CHAR_VAL_FK2	VARCHAR2	50
W1_PROCESS_LOG	CHAR_VAL_FK3	VARCHAR2	50
W1_PROCESS_LOG	CHAR_VAL_FK4	VARCHAR2	50
W1_PROCESS_LOG	CHAR_VAL_FK5	VARCHAR2	50
W1_PROCESS_LOG	DESCRLONG	VARCHAR2	4000
W1_PROCESS_LOG	LOG_DTTM	DATE	7
W1_PROCESS_LOG	LOG_ENTRY_TYPE_FLG	CHAR	4
W1_PROCESS_LOG	MESSAGE_CAT_NBR	NUMBER	22
W1_PROCESS_LOG	MESSAGE_NBR	NUMBER	22
W1_PROCESS_LOG	PROCESS_ID	CHAR	12
W1_PROCESS_LOG	SEQNO	NUMBER	22
W1_PROCESS_LOG	USER_ID	CHAR	8
W1_PROCESS_LOG	VERSION	NUMBER	22
W1_PROCESS_LOG_PARM	F1_MSG_PARM_VLONG	VARCHAR2	2000
W1_PROCESS_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	4
W1_PROCESS_LOG_PARM	PARM_SEQ	NUMBER	22
W1_PROCESS_LOG_PARM	PROCESS_ID	CHAR	12
W1_PROCESS_LOG_PARM	SEQNO	NUMBER	22
W1_PROCESS_LOG_PARM	VERSION	NUMBER	22
W1_PROCESS_TYPE	BO_DATA_AREA	CLOB	4000
W1_PROCESS_TYPE	BUS_OBJ_CD	CHAR	30
W1_PROCESS_TYPE	PROCESS_BUS_OBJ_CD	CHAR	30
W1_PROCESS_TYPE	PROCESS_TYPE_CD	VARCHAR2	30
W1_PROCESS_TYPE	VERSION	NUMBER	22
W1_PROCESS_TYPE_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_PROCESS_TYPE_CHAR	CHAR_TYPE_CD	CHAR	8
W1_PROCESS_TYPE_CHAR	CHAR_VAL	CHAR	16
W1_PROCESS_TYPE_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_PROCESS_TYPE_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_PROCESS_TYPE_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_PROCESS_TYPE_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_PROCESS_TYPE_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_PROCESS_TYPE_CHAR	PROCESS_TYPE_CD	VARCHAR2	30
W1_PROCESS_TYPE_CHAR	SEQ_NUM	NUMBER	22
W1_PROCESS_TYPE_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_PROCESS_TYPE_CHAR	VERSION	NUMBER	22
W1_PROCESS_TYPE_L	DESCR100	VARCHAR2	100
W1_PROCESS_TYPE_L	LANGUAGE_CD	CHAR	3
W1_PROCESS_TYPE_L	PROCESS_TYPE_CD	VARCHAR2	30
W1_PROCESS_TYPE_L	VERSION	NUMBER	22
W1_PROJECT_CATEGORY	BO_STATUS_CD	CHAR	12
W1_PROJECT_CATEGORY	BO_STATUS_REASON_CD	VARCHAR2	30
W1_PROJECT_CATEGORY_LOG	ADHOC_CHAR_VAL	VARCHAR2	254
W1_PROJECT_CATEGORY_LOG	BO_STATUS_CD	CHAR	12
W1_PROJECT_CATEGORY_LOG	BO_STATUS_REASON_CD	VARCHAR2	30
W1_PROJECT_CATEGORY_LOG	CHAR_TYPE_CD	CHAR	8
W1_PROJECT_CATEGORY_LOG	CHAR_VAL	CHAR	16
W1_PROJECT_CATEGORY_LOG	CHAR_VAL_FK1	VARCHAR2	50
W1_PROJECT_CATEGORY_LOG	CHAR_VAL_FK2	VARCHAR2	50
W1_PROJECT_CATEGORY_LOG	CHAR_VAL_FK3	VARCHAR2	50
W1_PROJECT_CATEGORY_LOG	CHAR_VAL_FK4	VARCHAR2	50
W1_PROJECT_CATEGORY_LOG	CHAR_VAL_FK5	VARCHAR2	50
W1_PROJECT_CATEGORY_LOG	DESCRLONG	VARCHAR2	4000
W1_PROJECT_CATEGORY_LOG	LOG_DTTM	DATE	7
W1_PROJECT_CATEGORY_LOG	LOG_ENTRY_TYPE_FLG	CHAR	4
W1_PROJECT_CATEGORY_LOG	MESSAGE_CAT_NBR	NUMBER	22
W1_PROJECT_CATEGORY_LOG	MESSAGE_NBR	NUMBER	22
W1_PROJECT_CATEGORY_LOG	PRJ_CAT_CD	VARCHAR2	30
W1_PROJECT_CATEGORY_LOG	SEQNO	NUMBER	22
W1_PROJECT_CATEGORY_LOG	USER_ID	CHAR	8
W1_PROJECT_CATEGORY_LOG	VERSION	NUMBER	22
W1_PROJECT_CATEGORY_LOG_PARM	F1_MSG_PARM_VLONG	VARCHAR2	2000
W1_PROJECT_CATEGORY_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	4
W1_PROJECT_CATEGORY_LOG_PARM	PARM_SEQ	NUMBER	22
W1_PROJECT_CATEGORY_LOG_PARM	PRJ_CAT_CD	VARCHAR2	30
W1_PROJECT_CATEGORY_LOG_PARM	SEQNO	NUMBER	22
W1_PROJECT_CATEGORY_LOG_PARM	VERSION	NUMBER	22
W1_RCPT_LINE_SHIP_DEFICIENCY	COMMENT_LONG	VARCHAR2	2000
W1_RCPT_LINE_SHIP_DEFICIENCY	INITIATION_DT	DATE	7
W1_RCPT_LINE_SHIP_DEFICIENCY	RCPT_LINE_ID	CHAR	14
W1_RCPT_LINE_SHIP_DEFICIENCY	RESOLVED_DT	DATE	7
W1_RCPT_LINE_SHIP_DEFICIENCY	RESOLVED_FLG	CHAR	4
W1_RCPT_LINE_SHIP_DEFICIENCY	SHIPMENT_DEFICIENCY_TYPE_CD	VARCHAR2	30
W1_RCPT_LINE_SHIP_DEFICIENCY	VERSION	NUMBER	22
W1_RR	BC_LINE_ID	CHAR	14
W1_SHIPPING_LINE	BO_DATA_AREA	CLOB	4000
W1_SHIPPING_LINE	BUS_OBJ_CD	CHAR	30
W1_SHIPPING_LINE	DESCR100	VARCHAR2	100
W1_SHIPPING_LINE	MAT_ISS_LINE_ID	CHAR	14
W1_SHIPPING_LINE	PO_ITEM_NUM	NUMBER	22
W1_SHIPPING_LINE	RESRC_TYPE_ID	CHAR	12
W1_SHIPPING_LINE	RESRC_UOM_CD	VARCHAR2	30
W1_SHIPPING_LINE	RTN_LINE_ID	CHAR	14
W1_SHIPPING_LINE	SHIPPING_LINE_ID	CHAR	14
W1_SHIPPING_LINE	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_LINE	VERSION	NUMBER	22
W1_SHIPPING_LINE	W1_QUANTITY	NUMBER	22
W1_SHIPPING_LINE_ASSET	ASSET_ID	CHAR	12
W1_SHIPPING_LINE_ASSET	MAT_ISS_LINE_ID	CHAR	14
W1_SHIPPING_LINE_ASSET	SHIPPING_LINE_ID	CHAR	14
W1_SHIPPING_LINE_ASSET	VERSION	NUMBER	22
W1_SHIPPING_LINE_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_SHIPPING_LINE_CHAR	CHAR_TYPE_CD	CHAR	8
W1_SHIPPING_LINE_CHAR	CHAR_VAL	CHAR	16
W1_SHIPPING_LINE_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_SHIPPING_LINE_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_SHIPPING_LINE_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_SHIPPING_LINE_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_SHIPPING_LINE_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_SHIPPING_LINE_CHAR	SEQ_NUM	NUMBER	22
W1_SHIPPING_LINE_CHAR	SHIPPING_LINE_ID	CHAR	14
W1_SHIPPING_LINE_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_SHIPPING_LINE_CHAR	VERSION	NUMBER	22
W1_SHIPPING_LINE_K	ENV_ID	NUMBER	22
W1_SHIPPING_LINE_K	SHIPPING_LINE_ID	CHAR	14
W1_SHIPPING_LINE_LOT	LOT_ID	VARCHAR2	100
W1_SHIPPING_LINE_LOT	MAT_ISS_LINE_ID	CHAR	14
W1_SHIPPING_LINE_LOT	SHIPPING_LINE_ID	CHAR	14
W1_SHIPPING_LINE_LOT	VERSION	NUMBER	22
W1_SHIPPING_LINE_LOT	W1_QUANTITY	NUMBER	22
W1_SHIPPING_MEMO	ADDRESS1	VARCHAR2	254
W1_SHIPPING_MEMO	ADDRESS2	VARCHAR2	254
W1_SHIPPING_MEMO	ADDRESS3	VARCHAR2	254
W1_SHIPPING_MEMO	ADDRESS4	VARCHAR2	254
W1_SHIPPING_MEMO	BO_DATA_AREA	CLOB	4000
W1_SHIPPING_MEMO	BO_STATUS_CD	CHAR	12
W1_SHIPPING_MEMO	BO_STATUS_REASON_CD	VARCHAR2	30
W1_SHIPPING_MEMO	BUS_OBJ_CD	CHAR	30
W1_SHIPPING_MEMO	CITY	VARCHAR2	90
W1_SHIPPING_MEMO	COUNTRY	CHAR	3
W1_SHIPPING_MEMO	COUNTY	VARCHAR2	90
W1_SHIPPING_MEMO	CRE_DTTM	DATE	7
W1_SHIPPING_MEMO	DESCR100	VARCHAR2	100
W1_SHIPPING_MEMO	FINAL_DTTM	DATE	7
W1_SHIPPING_MEMO	GEO_CODE	CHAR	11
W1_SHIPPING_MEMO	HOUSE_TYPE	CHAR	2
W1_SHIPPING_MEMO	IN_CITY_LIMIT	CHAR	1
W1_SHIPPING_MEMO	MAT_REQ_HEADER_ID	CHAR	14
W1_SHIPPING_MEMO	NUM1	CHAR	6
W1_SHIPPING_MEMO	NUM2	CHAR	4
W1_SHIPPING_MEMO	POSTAL	CHAR	12
W1_SHIPPING_MEMO	PO_HEADER_ID	CHAR	14
W1_SHIPPING_MEMO	RMA_NUM	VARCHAR2	30
W1_SHIPPING_MEMO	SHIPPED_DT	DATE	7
W1_SHIPPING_MEMO	SHIPPING_MEMO_CAT_FLG	CHAR	4
W1_SHIPPING_MEMO	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_MEMO	SHIPPING_MEMO_NUM	VARCHAR2	14
W1_SHIPPING_MEMO	SHIP_TO_VENDOR_LOC_ID	CHAR	12
W1_SHIPPING_MEMO	STATE	CHAR	6
W1_SHIPPING_MEMO	STATUS_UPD_DTTM	DATE	7
W1_SHIPPING_MEMO	TRACKING_NUM	VARCHAR2	30
W1_SHIPPING_MEMO	USER_ID	CHAR	8
W1_SHIPPING_MEMO	VENDOR_LOC_ID	CHAR	12
W1_SHIPPING_MEMO	VERSION	NUMBER	22
W1_SHIPPING_MEMO	W1_CONTACT_EMAIL	VARCHAR2	70
W1_SHIPPING_MEMO	W1_CONTACT_NAME	VARCHAR2	254
W1_SHIPPING_MEMO	W1_DESCR100_UPR	VARCHAR2	100
W1_SHIPPING_MEMO	W1_PHONE	VARCHAR2	24
W1_SHIPPING_MEMO_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_SHIPPING_MEMO_CHAR	CHAR_TYPE_CD	CHAR	8
W1_SHIPPING_MEMO_CHAR	CHAR_VAL	CHAR	16
W1_SHIPPING_MEMO_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_SHIPPING_MEMO_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_SHIPPING_MEMO_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_SHIPPING_MEMO_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_SHIPPING_MEMO_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_SHIPPING_MEMO_CHAR	SEQ_NUM	NUMBER	22
W1_SHIPPING_MEMO_CHAR	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_MEMO_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_SHIPPING_MEMO_CHAR	VERSION	NUMBER	22
W1_SHIPPING_MEMO_DOCUMENT	ATTACHMENT_ID	CHAR	14
W1_SHIPPING_MEMO_DOCUMENT	CRE_DTTM	DATE	7
W1_SHIPPING_MEMO_DOCUMENT	DOCUMENT_ID	CHAR	12
W1_SHIPPING_MEMO_DOCUMENT	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_MEMO_DOCUMENT	USER_ID	CHAR	8
W1_SHIPPING_MEMO_DOCUMENT	VERSION	NUMBER	22
W1_SHIPPING_MEMO_IDENTIFIER	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_MEMO_IDENTIFIER	SHIPPING_MEMO_ID_TYPE_FLG	CHAR	4
W1_SHIPPING_MEMO_IDENTIFIER	VERSION	NUMBER	22
W1_SHIPPING_MEMO_IDENTIFIER	W1_ID_VALUE	VARCHAR2	60
W1_SHIPPING_MEMO_K	ENV_ID	NUMBER	22
W1_SHIPPING_MEMO_K	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_MEMO_LOG	ADHOC_CHAR_VAL	VARCHAR2	254
W1_SHIPPING_MEMO_LOG	BO_STATUS_CD	CHAR	12
W1_SHIPPING_MEMO_LOG	BO_STATUS_REASON_CD	VARCHAR2	30
W1_SHIPPING_MEMO_LOG	CHAR_TYPE_CD	CHAR	8
W1_SHIPPING_MEMO_LOG	CHAR_VAL	CHAR	16
W1_SHIPPING_MEMO_LOG	CHAR_VAL_FK1	VARCHAR2	50
W1_SHIPPING_MEMO_LOG	CHAR_VAL_FK2	VARCHAR2	50
W1_SHIPPING_MEMO_LOG	CHAR_VAL_FK3	VARCHAR2	50
W1_SHIPPING_MEMO_LOG	CHAR_VAL_FK4	VARCHAR2	50
W1_SHIPPING_MEMO_LOG	CHAR_VAL_FK5	VARCHAR2	50
W1_SHIPPING_MEMO_LOG	DESCRLONG	VARCHAR2	4000
W1_SHIPPING_MEMO_LOG	LOG_DTTM	DATE	7
W1_SHIPPING_MEMO_LOG	LOG_ENTRY_TYPE_FLG	CHAR	4
W1_SHIPPING_MEMO_LOG	MESSAGE_CAT_NBR	NUMBER	22
W1_SHIPPING_MEMO_LOG	MESSAGE_NBR	NUMBER	22
W1_SHIPPING_MEMO_LOG	SEQNO	NUMBER	22
W1_SHIPPING_MEMO_LOG	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_MEMO_LOG	USER_ID	CHAR	8
W1_SHIPPING_MEMO_LOG	VERSION	NUMBER	22
W1_SHIPPING_MEMO_LOG_PARM	F1_MSG_PARM_VLONG	VARCHAR2	2000
W1_SHIPPING_MEMO_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	4
W1_SHIPPING_MEMO_LOG_PARM	PARM_SEQ	NUMBER	22
W1_SHIPPING_MEMO_LOG_PARM	SEQNO	NUMBER	22
W1_SHIPPING_MEMO_LOG_PARM	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_MEMO_LOG_PARM	VERSION	NUMBER	22
W1_SHIPPING_MEMO_NOTE	NOTE_DTTM	DATE	7
W1_SHIPPING_MEMO_NOTE	NOTE_TYPE_FLG	CHAR	4
W1_SHIPPING_MEMO_NOTE	NOTE_VALUE	VARCHAR2	4000
W1_SHIPPING_MEMO_NOTE	SEQNO	NUMBER	22
W1_SHIPPING_MEMO_NOTE	SHIPPING_MEMO_ID	CHAR	14
W1_SHIPPING_MEMO_NOTE	USER_ID	CHAR	8
W1_SHIPPING_MEMO_NOTE	VERSION	NUMBER	22
W1_SHIP_DEFICIENCY_TYPE	BO_DATA_AREA	CLOB	4000
W1_SHIP_DEFICIENCY_TYPE	BUS_OBJ_CD	CHAR	30
W1_SHIP_DEFICIENCY_TYPE	SHIPMENT_DEFICIENCY_TYPE_CD	VARCHAR2	30
W1_SHIP_DEFICIENCY_TYPE	VERSION	NUMBER	22
W1_SHIP_DEFICIENCY_TYPE_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_SHIP_DEFICIENCY_TYPE_CHAR	CHAR_TYPE_CD	CHAR	8
W1_SHIP_DEFICIENCY_TYPE_CHAR	CHAR_VAL	CHAR	16
W1_SHIP_DEFICIENCY_TYPE_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_SHIP_DEFICIENCY_TYPE_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_SHIP_DEFICIENCY_TYPE_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_SHIP_DEFICIENCY_TYPE_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_SHIP_DEFICIENCY_TYPE_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_SHIP_DEFICIENCY_TYPE_CHAR	SEQ_NUM	NUMBER	22
W1_SHIP_DEFICIENCY_TYPE_CHAR	SHIPMENT_DEFICIENCY_TYPE_CD	VARCHAR2	30
W1_SHIP_DEFICIENCY_TYPE_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_SHIP_DEFICIENCY_TYPE_CHAR	VERSION	NUMBER	22
W1_SHIP_DEFICIENCY_TYPE_L	DESCR100	VARCHAR2	100
W1_SHIP_DEFICIENCY_TYPE_L	LANGUAGE_CD	CHAR	3
W1_SHIP_DEFICIENCY_TYPE_L	SHIPMENT_DEFICIENCY_TYPE_CD	VARCHAR2	30
W1_SHIP_DEFICIENCY_TYPE_L	VERSION	NUMBER	22
W1_STOCK_ITEM_DTL	EXPENSE_CD	VARCHAR2	30
W1_TIMEKEEPER	BO_DATA_AREA	CLOB	4000
W1_TIMEKEEPER	BO_STATUS_CD	CHAR	12
W1_TIMEKEEPER	BO_STATUS_REASON_CD	VARCHAR2	30
W1_TIMEKEEPER	BUS_OBJ_CD	CHAR	30
W1_TIMEKEEPER	CRE_DTTM	DATE	7
W1_TIMEKEEPER	STATUS_UPD_DTTM	DATE	7
W1_TIMEKEEPER	TIMEKEEPER_CD	VARCHAR2	30
W1_TIMEKEEPER	USER_ID	CHAR	8
W1_TIMEKEEPER	VERSION	NUMBER	22
W1_TIMEKEEPER_CHAR	ADHOC_CHAR_VAL	VARCHAR2	254
W1_TIMEKEEPER_CHAR	CHAR_TYPE_CD	CHAR	8
W1_TIMEKEEPER_CHAR	CHAR_VAL	CHAR	16
W1_TIMEKEEPER_CHAR	CHAR_VAL_FK1	VARCHAR2	50
W1_TIMEKEEPER_CHAR	CHAR_VAL_FK2	VARCHAR2	50
W1_TIMEKEEPER_CHAR	CHAR_VAL_FK3	VARCHAR2	50
W1_TIMEKEEPER_CHAR	CHAR_VAL_FK4	VARCHAR2	50
W1_TIMEKEEPER_CHAR	CHAR_VAL_FK5	VARCHAR2	50
W1_TIMEKEEPER_CHAR	SEQ_NUM	NUMBER	22
W1_TIMEKEEPER_CHAR	SRCH_CHAR_VAL	VARCHAR2	50
W1_TIMEKEEPER_CHAR	TIMEKEEPER_CD	VARCHAR2	30
W1_TIMEKEEPER_CHAR	VERSION	NUMBER	22
W1_TIMEKEEPER_EMP	EMPLOYEE_ID	CHAR	12
W1_TIMEKEEPER_EMP	TIMEKEEPER_CD	VARCHAR2	30
W1_TIMEKEEPER_EMP	VERSION	NUMBER	22
W1_TIMEKEEPER_L	DESCR100	VARCHAR2	100
W1_TIMEKEEPER_L	LANGUAGE_CD	CHAR	3
W1_TIMEKEEPER_L	TIMEKEEPER_CD	VARCHAR2	30
W1_TIMEKEEPER_L	VERSION	NUMBER	22
W1_TIMEKEEPER_LOG	ADHOC_CHAR_VAL	VARCHAR2	254
W1_TIMEKEEPER_LOG	BO_STATUS_CD	CHAR	12
W1_TIMEKEEPER_LOG	BO_STATUS_REASON_CD	VARCHAR2	30
W1_TIMEKEEPER_LOG	CHAR_TYPE_CD	CHAR	8
W1_TIMEKEEPER_LOG	CHAR_VAL	CHAR	16
W1_TIMEKEEPER_LOG	CHAR_VAL_FK1	VARCHAR2	50
W1_TIMEKEEPER_LOG	CHAR_VAL_FK2	VARCHAR2	50
W1_TIMEKEEPER_LOG	CHAR_VAL_FK3	VARCHAR2	50
W1_TIMEKEEPER_LOG	CHAR_VAL_FK4	VARCHAR2	50
W1_TIMEKEEPER_LOG	CHAR_VAL_FK5	VARCHAR2	50
W1_TIMEKEEPER_LOG	DESCRLONG	VARCHAR2	4000
W1_TIMEKEEPER_LOG	LOG_DTTM	DATE	7
W1_TIMEKEEPER_LOG	LOG_ENTRY_TYPE_FLG	CHAR	4
W1_TIMEKEEPER_LOG	MESSAGE_CAT_NBR	NUMBER	22
W1_TIMEKEEPER_LOG	MESSAGE_NBR	NUMBER	22
W1_TIMEKEEPER_LOG	SEQNO	NUMBER	22
W1_TIMEKEEPER_LOG	TIMEKEEPER_CD	VARCHAR2	30
W1_TIMEKEEPER_LOG	USER_ID	CHAR	8
W1_TIMEKEEPER_LOG	VERSION	NUMBER	22
W1_TIMEKEEPER_LOG_PARM	F1_MSG_PARM_VLONG	VARCHAR2	1000
W1_TIMEKEEPER_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	4
W1_TIMEKEEPER_LOG_PARM	PARM_SEQ	NUMBER	22
W1_TIMEKEEPER_LOG_PARM	SEQNO	NUMBER	22
W1_TIMEKEEPER_LOG_PARM	TIMEKEEPER_CD	VARCHAR2	30
W1_TIMEKEEPER_LOG_PARM	VERSION	NUMBER	22
W1_TIMESHEET_DETAIL	EU_ID	CHAR	12
W1_TMPL_ACT	BACK_LOG_GRP_FLG	CHAR	4
W1_TMPL_ACT	OUTAGE_TYPE_FLG	CHAR	4
W1_TMPL_ACT	WORK_PRIORITY_FLG	CHAR	4
W1_TMPL_WO	W1_CREW_ID	CHAR	12
W1_VENDOR_LOC_PAYTO_LOC	PAY_TO_LOC	CHAR	12
W1_VENDOR_LOC_PAYTO_LOC	VENDOR_LOC_ID	CHAR	12
W1_VENDOR_LOC_PAYTO_LOC	VERSION	NUMBER	22
W1_VENDOR_LOG	ADHOC_CHAR_VAL	VARCHAR2	254
W1_VENDOR_LOG	BO_STATUS_CD	CHAR	12
W1_VENDOR_LOG	BO_STATUS_REASON_CD	VARCHAR2	30
W1_VENDOR_LOG	CHAR_TYPE_CD	CHAR	8
W1_VENDOR_LOG	CHAR_VAL	CHAR	16
W1_VENDOR_LOG	CHAR_VAL_FK1	VARCHAR2	50
W1_VENDOR_LOG	CHAR_VAL_FK2	VARCHAR2	50
W1_VENDOR_LOG	CHAR_VAL_FK3	VARCHAR2	50
W1_VENDOR_LOG	CHAR_VAL_FK4	VARCHAR2	50
W1_VENDOR_LOG	CHAR_VAL_FK5	VARCHAR2	50
W1_VENDOR_LOG	DESCRLONG	VARCHAR2	4000
W1_VENDOR_LOG	LOG_DTTM	DATE	7
W1_VENDOR_LOG	LOG_ENTRY_TYPE_FLG	CHAR	4
W1_VENDOR_LOG	MESSAGE_CAT_NBR	NUMBER	22
W1_VENDOR_LOG	MESSAGE_NBR	NUMBER	22
W1_VENDOR_LOG	SEQNO	NUMBER	22
W1_VENDOR_LOG	USER_ID	CHAR	8
W1_VENDOR_LOG	VENDOR_CD	VARCHAR2	30
W1_VENDOR_LOG	VERSION	NUMBER	22
W1_VENDOR_LOG_PARM	F1_MSG_PARM_VLONG	VARCHAR2	2000
W1_VENDOR_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	4
W1_VENDOR_LOG_PARM	PARM_SEQ	NUMBER	22
W1_VENDOR_LOG_PARM	SEQNO	NUMBER	22
W1_VENDOR_LOG_PARM	VENDOR_CD	VARCHAR2	30
W1_VENDOR_LOG_PARM	VERSION	NUMBER	22

Updated Fields

The following fields are updated in this Oracle Utilities Operational Device Management release:

Table_Name	Column_Name	Data Type	Data Length
W1_ACTIVITY_ASSET	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_ACTIVITY_COST_ CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_ACT_RECON_COST_CENTER	W1_PERCENTAGE	NUMBER 5,2	NUMBER 8,5
W1_ASSESS_GRP	BUS_OBJ_CD	VARCHAR2 30	CHAR 30
W1_INVOICE_HEADER_COST_CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_INVOICE_LINE_ COST_CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_MAT_REQ_HEADER_COST_CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_MAT_RET_HEADER_COST_CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_NODE_COST_ CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_ODC_DTL_COST	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_OVERHEAD	W1_PERCENTAGE	NUMBER 5,2	NUMBER 8,5
W1_PO_HEADER_COST_CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_PO_LINE_COST_ CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_PROJECT_COST_ CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_PR_HDR_COST_CTR	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_PR_LINE_COST	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_TIMSHEETDTL_ COST_CTR	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_TMPL_ACT_COST_ CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_TMPL_ACT_COST_ DIST	PERCENTAGE	NUMBER 3	NUMBER 8,5
W1_WO_COST_CENTER	PERCENTAGE	NUMBER 3	NUMBER 8,5

Dropped Fields

The following fields are dropped in this Oracle Utilities Operational Device Management release:

Table_Name	Column_Name
W1_TMPL_WO	WORK_CATEGORY_FLG
W1_TMPL_WO	WORK_CLASS_FLG
W1_WO	WORK_CATEGORY_FLG
W1_WO	WORK_CLASS_FLG

New Indexes

The following fields are added to Oracle Utilities Operational Device Management this release:

Table_Name	Index_Name
W1_ACPT_LINE	W1T475S2
W1_ACTIVITY	W1T244S18
W1_ACTIVITY	W1T244S19
W1_ACTIVITY	W1T244S20
W1_ACTIVITY_ASSET	W1T366S1
W1_ACTIVITY_MEASUREMENT_TYPE	W1T962P0
W1_ACTIVITY_TYPE	W1C237S3
W1_ACT_CONSTR_LOC_CU_ASSET	W1T786S1
W1_ADJUSTMENT	W1C890P0
W1_ADJUSTMENT_CHAR	W1C892P0
W1_ADJUSTMENT_DOCUMENT	W1C895P0
W1_ADJUSTMENT_DTL	W1C891P0
W1_ADJUSTMENT_IDENTIFIER	W1C893P0
W1_ADJUSTMENT_LOG	W1C896P0
W1_ADJUSTMENT_LOG_PARM	W1C897P0
W1_ADJUSTMENT_TYPE	W1889P0
W1_ADJUSTMENT_TYPE_CHAR	W1C892S1
W1_ADJUSTMENT_TYPE_CHAR	W1C900P0
W1_ADJUSTMENT_TYPE_L	W1C899P0
W1_ASSET	W1M007S8
W1_ASSET_NODE	W1M008S8
W1_BC_LINE	W1T355S2
W1_BC_LINE	W1T355S3
W1_CHANGE_REQ	W1T936P0
W1_CHANGE_REQ	W1T936S1
W1_CHANGE_REQ	W1T936S2
W1_CHANGE_REQ	W1T936S3
W1_CHANGE_REQ	W1T936S4
W1_CHANGE_REQ	W1T936S5
W1_CHANGE_REQ	W1T936S6
W1_CHANGE_REQ_APPR_PROF	W1C935P0
W1_CHANGE_REQ_CHAR	W1T937P0
W1_CHANGE_REQ_CHAR	W1T937S1
W1_CHANGE_REQ_DOCUMENT	W1T940P0
W1_CHANGE_REQ_K	W1T941P0
W1_CHANGE_REQ_LOG	W1T938P0
W1_CHANGE_REQ_LOG	W1T938S1
W1_CHANGE_REQ_LOG	W1T938S2
W1_CHANGE_REQ_LOG_PARM	W1T939P0
W1_CHANGE_REQ_TYPE	W1C932P0
W1_CHANGE_REQ_TYPE_CHAR	W1C934P0
W1_CHANGE_REQ_TYPE_CHAR	W1C934S1
W1_CHANGE_REQ_TYPE_L	W1C933P0
W1_CREW_STR_ASSN	W1M919P0
W1_EMPLOYEE_TRAINING	W1M502P0
W1_EMP_AUTO_TIMESHEET	W1M954P0
W1_EU_TIMESHEET	W1M961P0
W1_INVOICE_HEADER	W1T500S2
W1_INVOICE_LINE	W1T509S2
W1_INVOICE_LINE	W1T509S3
W1_INVOICE_LINE	W1T509S4
W1_INVOICE_LINE	W1T509S5
W1_MAINT_TRIGGER	W1M658S3
W1_MAT_REQ_HEADER	W1T378S2
W1_MAT_REQ_LINE	W1T384S5
W1_MAT_RET_LINE	W1T400S1
W1_NODE	W1M205S10
W1_NODE	W1M205S11
W1_NODE_TYPE	W1C200S1
W1_ODC_DTL	W1T340S2
W1_PI_CNT_LINE	W1T329S2
W1_PI_CNT_MST	W1T324S2
W1_PI_CNT_MST	W1T324S3
W1_PI_HEADER	W1T319S2
W1_PO_HEADER	W1T410S2
W1_PO_HEADER	W1T410S3
W1_PO_HEADER	W1T410S4
W1_PO_HEADER	W1T410S5
W1_PO_LINE	W1T418S2
W1_PO_LINE	W1T418S3
W1_PO_LINE	W1T418S4
W1_PO_LINE	W1T418S5
W1_PO_LINE	W1T418S6
W1_PO_LINE	W1T418S7
W1_PO_LINE	W1T418S8
W1_PROCESS	W1M923P0
W1_PROCESS_CHAR	W1M926P0
W1_PROCESS_DOCUMENT	W1M930P0
W1_PROCESS_IDENTIFIER	W1M927P0
W1_PROCESS_K	W1M924P0
W1_PROCESS_LOC	W1M925P0
W1_PROCESS_LOG	W1M928P0
W1_PROCESS_LOG_PARM	W1M929P0
W1_PROCESS_TYPE	W1C920P0
W1_PROCESS_TYPE_CHAR	W1C921P0
W1_PROCESS_TYPE_L	W1C922P0
W1_PROJECT_CATEGORY_LOG	W1C963P0
W1_PROJECT_CATEGORY_LOG_PARM	W1C964P0
W1_PR_LINE	W1T443S2
W1_PR_LINE	W1T443S3
W1_RCPT_HDR	W1T460S3
W1_RCPT_LINE	W1T468S2
W1_RCPT_LINE	W1T468S3
W1_RCPT_LINE_SHIP_DEFICIENCY	W1T916P0
W1_RTN_LINE	W1T483S2
W1_RTN_LINE	W1T483S3
W1_RTN_LINE	W1T483S4
W1_RTN_LINE	W1T483S5
W1_RTN_LINE	W1T483S6
W1_SHIPPING_LINE	W1T911P0
W1_SHIPPING_LINE	W1T911S1
W1_SHIPPING_LINE	W1T911S2
W1_SHIPPING_LINE	W1T911S3
W1_SHIPPING_LINE	W1T911S4
W1_SHIPPING_LINE	W1T911S5
W1_SHIPPING_LINE	W1T911S6
W1_SHIPPING_LINE_ASSET	W1T913P0
W1_SHIPPING_LINE_ASSET	W1T913S1
W1_SHIPPING_LINE_ASSET	W1T913S2
W1_SHIPPING_LINE_CHAR	W1T914P0
W1_SHIPPING_LINE_CHAR	W1T914S1
W1_SHIPPING_LINE_K	W1T915P0
W1_SHIPPING_LINE_LOT	W1T912P0
W1_SHIPPING_LINE_LOT	W1T912S1
W1_SHIPPING_LINE_LOT	W1T912S2
W1_SHIPPING_MEMO	W1T903P0
W1_SHIPPING_MEMO	W1T903S2
W1_SHIPPING_MEMO	W1T903S3
W1_SHIPPING_MEMO	W1T903S4
W1_SHIPPING_MEMO	W1T903S5
W1_SHIPPING_MEMO	W1T903S6
W1_SHIPPING_MEMO	W1T903S7
W1_SHIPPING_MEMO_CHAR	W1T904P0
W1_SHIPPING_MEMO_CHAR	W1T904S1
W1_SHIPPING_MEMO_DOCUMENT	W1T908P0
W1_SHIPPING_MEMO_IDENTIFIER	W1T905P0
W1_SHIPPING_MEMO_IDENTIFIER	W1T905S1
W1_SHIPPING_MEMO_K	W1T910P0
W1_SHIPPING_MEMO_LOG	W1T906P0
W1_SHIPPING_MEMO_LOG	W1T906S1
W1_SHIPPING_MEMO_LOG	W1T906S2
W1_SHIPPING_MEMO_LOG_PARM	W1T907P0
W1_SHIPPING_MEMO_NOTE	W1T909P0
W1_SHIP_DEFICIENCY_TYPE	W1C923P0
W1_SHIP_DEFICIENCY_TYPE_CHAR	W1C924P0
W1_SHIP_DEFICIENCY_TYPE_CHAR	W1C924S1
W1_SHIP_DEFICIENCY_TYPE_L	W1C925P0
W1_STOCK_ITEM_DTL	W1M568S2
W1_STOCK_ITEM_DTL	W1M568S3
W1_STOCK_ITEM_DTL	W1M568S4
W1_STOCK_ITEM_DTL	W1M568S5
W1_STOCK_TRANS	W1T306S2
W1_STOCK_TRANS	W1T306S3
W1_STOCK_TRANS	W1T306S4
W1_STOCK_TRANS	W1T306S5
W1_TIMEKEEPER	W1C948P0
W1_TIMEKEEPER_CHAR	W1C950P0
W1_TIMEKEEPER_EMP	W1C949P0
W1_TIMEKEEPER_L	W1C951P0
W1_TIMEKEEPER_LOG	W1C952P0
W1_TIMEKEEPER_LOG_PARM	W1C953P0
W1_TIMESHEET_DETAIL	W1M595S2
W1_TIMESHEET_DETAIL	W1M595S3
W1_TMPL_ACT	W1M617S1
W1_TMPL_WO	W1M610S3
W1_VENDOR_LOC	W1M637S1
W1_VENDOR_LOC_PAYTO_LOC	W1M955P0
W1_VENDOR_LOG	W1M943P0
W1_VENDOR_LOG	W1M943S1
W1_VENDOR_LOG	W1M943S2
W1_VENDOR_LOG_PARM	W1M944P0
W1_WO	W1T232S13
W1_WO	W1T232S14
W1_WORK_REQ	W1T298S8

Updated Indexes

There are no updated indexes in this Oracle Utilities Operational Device Management release.

Dropped Indexes

No indexes are dropped in this Oracle Utilities Operational Device Management release.

New Views

The following views are added in this Oracle Utilities Operational Device Management release:

View_Name
W1_BI_ACTIVITY_VW
W1_BI_ASSET_SN_VW
W1_BI_FORECASTEDACTHOURS_VW
W1_BI_FORECASTEDASSETPMCOST_VW
W1_BI_FORECASTEDASSETPMHRS_VW
W1_BI_LABORHOURS_VW
W1_BI_SERVICEHISTORY_VW
W1_BI_SPECIFICATION_MODEL_VW
W1_BI_STOCK_ITEM_DTL_VW
W1_BI_STOCK_ITEM_DTLS_F_VW
W1_BI_STOCK_ITEM_VW
W1_BI_STOCK_TRANS_VW
W1_BI_STOREROOM_VW
W1_BI_WO_FINISHDT_VW
W1_BI_WO_VW
W1_ON_CRAFT_VW

New Materialized Views

There are no materialized views added in this Oracle Utilities Operational Device Management release.