Upgrading from Oracle Utilities Meter Data Management V2.3.0.2.0 to V24.5

New Tables

Table_Name
D1_ACTIVITY_TYPE_DIV
D1_ACTIVITY_TYPE_FLD_TASK_TYPE
D1_CONTACT_COMM
D1_CONTACT_COMM_CHAR
D1_CONTACT_COMM_K
D1_CONTACT_COMM_LOG
D1_CONTACT_COMM_LOG_PARM
D1_CONTACT_COMM_REL_OBJ
D1_DVC_ENTITY_GRP
D1_DVC_EQPMNT
D1_DVC_TYPE_VALID_DVC_CHAR
D1_DYN_OPT_QTY
D1_DYN_OPT_QUESTION
D1_DYN_OPT_RATE
D1_DYN_OPT_RULE
D1_DYN_OPT_SPECIFICATION
D1_DYN_OPT_TYPE_QTY_TYPE
D1_DYN_OPT_TYPE_REL
D1_DYN_OPT_USG_GRP
D1_ENTITY_GRP
D1_ENTITY_GRP_CHAR
D1_ENTITY_GRP_CRIT
D1_ENTITY_GRP_CRIT_VAL
D1_ENTITY_GRP_L
D1_EVT_PARTICIPATION
D1_EVT_PARTICIPATION_CHAR
D1_EVT_PARTICIPATION_K
D1_EVT_PARTICIPATION_LOG
D1_EVT_PARTICIPATION_LOG_PARM
D1_FACILITY_SP
D1_IMD_CTRL_STAGE
D1_IMD_CTRL_STAGE_K
D1_IMD_TYPE
D1_IMD_TYPE_ALG
D1_IMD_TYPE_L
D1_MSRMT_AUDIT
D1_RULE
D1_RULE_CHAR
D1_RULE_L
D1_RULE_PARM
D1_SPR_PROG
D1_SP_ENTITY_GRP
D1_SP_TYPE_DISCONNECT_LOCATION
D1_SP_TYPE_DIV
D1_SP_TYPE_FIELD_TASK_TYPE
D1_US_TYPE_VALID_US_CHAR

Dropped Tables

None

New Views

View_Name
D1_ACT_DVC_SP_VW
D1_BI_DYN_AGG_VW
D1_MC_TYPE_PER_EST_EVAL_VW
D2_MEASR_QTY_AGR_MV
D2_MEASR_QTY_MV
D2_QUALITY_CNT_AGR_MV
D2_QUALITY_CNT_MV
D2_TIMELINESS_CNT_MV
D2_TIMELINESS_QTY_MV
D2_TIMELINES_CNT_AGR_MV
D2_TIMELINES_QTY_AGR_MV

Deleted Views

None

New Indexes

Table_Name	Index_Name
D1_ACTIVITY_TYPE_DIV	D1C636P0
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	D1C631P0
D1_CONTACT	D1M180S0
D1_CONTACT_COMM	D1T653P0
D1_CONTACT_COMM	D1T653S1
D1_CONTACT_COMM_CHAR	D1T655P0
D1_CONTACT_COMM_CHAR	D1T655S1
D1_CONTACT_COMM_K	D1T654P0
D1_CONTACT_COMM_LOG	D1T656P0
D1_CONTACT_COMM_LOG_PARM	D1T657P0
D1_CONTACT_COMM_REL_OBJ	D1T658P0
D1_DVC_ENTITY_GRP	D1M674P0
D1_DVC_ENTITY_GRP	D1M674S0
D1_DVC_EQPMNT	D1M629P0
D1_DVC_EQPMNT	D1M629S0
D1_DVC_TYPE_VALID_DVC_CHAR	D1C634P0
D1_DVC_TYPE_VALID_DVC_CHAR	D1C634S1
D1_DYN_OPT_EVENT	D1T230S1
D1_DYN_OPT_EVENT	D1T230S2
D1_DYN_OPT_EVENT	D1T230S3
D1_DYN_OPT_QTY	D1M659P0
D1_DYN_OPT_QUESTION	D1M646P0
D1_DYN_OPT_RATE	D1M645P0
D1_DYN_OPT_RULE	D1M647P0
D1_DYN_OPT_SPECIFICATION	D1M638P0
D1_DYN_OPT_TYPE_QTY_TYPE	D1C660P0
D1_DYN_OPT_TYPE_REL	D1M648P0
D1_DYN_OPT_USG_GRP	D1M652P0
D1_ENTITY_GRP	D1C675P0
D1_ENTITY_GRP_CHAR	D1C670P0
D1_ENTITY_GRP_CRIT	D1C671P0
D1_ENTITY_GRP_CRIT_VAL	D1C672P0
D1_ENTITY_GRP_L	D1C669P0
D1_EVT_PARTICIPATION	D1T639P0
D1_EVT_PARTICIPATION	D1T639S2
D1_EVT_PARTICIPATION	D1T639S3
D1_EVT_PARTICIPATION	D1T652S1
D1_EVT_PARTICIPATION_CHAR	D1T641P0
D1_EVT_PARTICIPATION_CHAR	D1T641S1
D1_EVT_PARTICIPATION_K	D1T640P0
D1_EVT_PARTICIPATION_LOG	D1T642P0
D1_EVT_PARTICIPATION_LOG_PARM	D1T643P0
D1_FACILITY_SP	D1T633P0
D1_IMD_CTRL_STAGE	D1T661P0
D1_IMD_CTRL_STAGE	D1T661S0
D1_IMD_CTRL_STAGE	D1T661S1
D1_IMD_CTRL_STAGE_K	D1T663P0
D1_IMD_TYPE	D1C664P0
D1_IMD_TYPE_ALG	D1C666P0
D1_IMD_TYPE_L	D1C665P0
D1_MSRMT_AUDIT	D1T662P0
D1_RULE	D1C649P0
D1_RULE_CHAR	D1C651P0
D1_RULE_L	D1C650P0
D1_RULE_PARM	D1C667P0
D1_SPR_PROG	D1C668P0
D1_SP_ENTITY_GRP	D1M673P0
D1_SP_ENTITY_GRP	D1M673S0
D1_SP_REL	D1M317S1
D1_SP_TYPE_DISCONNECT_LOCATION	D1C637P0
D1_SP_TYPE_DIV	D1C635P0
D1_SP_TYPE_FIELD_TASK_TYPE	D1M630P0
D1_USAGE_EXCP	D1T443S1
D1_US_QTY	D1M576P0
D1_US_TYPE_VALID_US_CHAR	D1C644P0
D1_US_TYPE_VALID_US_CHAR	D1C644S1

Added Columns

Table_Name	Column_Name	Data_Type	Data_Length
CI_ACC_GRP_ROLE	ACCESS_GRP_CD	CHAR	48
CI_ACC_GRP_ROLE	ROLE_ID	CHAR	40
CI_ACC_GRP_ROLE	TD_TYPE_CD	CHAR	32
CI_ACC_GRP_ROLE	VERSION	NUMBER	22
CI_ALG_PARM	ALG_PARM_VAL	VARCHAR2	32767
CI_BATCH_CTRL	BASE_BATCH_FLG	CHAR	16
CI_BATCH_CTRL	BATCH_TEMPLATE_XFLG	VARCHAR2	1016
CI_BATCH_CTRL_OPT	BATCH_CD	CHAR	32
CI_BATCH_CTRL_OPT	BATCH_CTRL_OPT_FLG	CHAR	16
CI_BATCH_CTRL_OPT	BATCH_CTRL_OPT_VAL	VARCHAR2	1016
CI_BATCH_CTRL_OPT	OWNER_FLG	CHAR	16
CI_BATCH_CTRL_OPT	SEQ_NUM	NUMBER	22
CI_BATCH_CTRL_OPT	VERSION	NUMBER	22
CI_BATCH_INST	END_DTTM	DATE	7
CI_BATCH_INST	FILE_DETAILS	CLOB	4000
CI_BATCH_INST	START_DTTM	DATE	7
CI_BATCH_JOB	SUBMIT_METH_FLG	CHAR	16
CI_BATCH_JOB	SUBMIT_USER_ID	CHAR	32
CI_BATCH_RUN	LOG_FILE_NAME	VARCHAR2	1016
CI_CHAR_TYPE	FLD_NAME	CHAR	120
CI_CNV_DUP_KEY	CX_ID	CHAR	120
CI_CNV_KEY_TMP	CI_ID	CHAR	120
CI_CNV_KEY_TMP	CX_ID	CHAR	120
CI_CNV_KEY_TMP	INIT_ID	VARCHAR2	120
CI_CURRENCY_CD	EXT_CURRENCY_CD	CHAR	144
CI_MD_FLD_ADDTL	FLD_NAME	CHAR	120
CI_MD_FLD_ADDTL	OWNER_FLG	CHAR	16
CI_MD_FLD_ADDTL	PII_CLASS_FLG	CHAR	16
CI_MD_FLD_ADDTL	VERSION	NUMBER	22
CI_MD_FLD_L	CONTEXT_LABEL1	VARCHAR2	240
CI_MD_FLD_L	CONTEXT_LABEL2	VARCHAR2	240
CI_MD_FLD_L	CONTEXT_LABEL3	VARCHAR2	240
CI_MD_FLD_L	CONTEXT_LABEL_TYPE1	CHAR	16
CI_MD_FLD_L	CONTEXT_LABEL_TYPE2	CHAR	16
CI_MD_FLD_L	CONTEXT_LABEL_TYPE3	CHAR	16
CI_MD_FLD_L	OVRD_CONTEXT_LABEL1	VARCHAR2	240
CI_MD_FLD_L	OVRD_CONTEXT_LABEL2	VARCHAR2	240
CI_MD_FLD_L	OVRD_CONTEXT_LABEL3	VARCHAR2	240
CI_MD_IDX	IDX_CD	VARCHAR2	512
CI_MD_IDX	OWNER_FLG	CHAR	16
CI_MD_IDX	TBL_NAME	CHAR	120
CI_MD_IDX	UNIQUE_SW	CHAR	4
CI_MD_IDX	VERSION	NUMBER	22
CI_MD_IDX_FLD	FLD_NAME	CHAR	120
CI_MD_IDX_FLD	IDX_CD	VARCHAR2	512
CI_MD_IDX_FLD	OWNER_FLG	CHAR	16
CI_MD_IDX_FLD	SEQ_NUM	NUMBER	22
CI_MD_IDX_FLD	VERSION	NUMBER	22
CI_MD_TBL	KEY_PREFIX_FLD_NAME	CHAR	120
CI_MD_TBL_ADDTL	OWNER_FLG	CHAR	16
CI_MD_TBL_ADDTL	TBL_GEN_STATUS_FLG	CHAR	16
CI_MD_TBL_ADDTL	TBL_NAME	CHAR	120
CI_MD_TBL_ADDTL	VERSION	NUMBER	22
CI_NT_XID	OWNER_FLG	CHAR	16
CI_NT_XID_L	OWNER_FLG	CHAR	16
CI_PORTAL	PORTAL_ROLE_FLG	CHAR	16
CI_PORTAL_ZONE	ZONE_HEIGHT_FLG	CHAR	16
CI_PORTAL_ZONE	ZONE_LAYOUT	CHAR	16
CI_PORTAL_ZONE	ZONE_MAX_HEIGHT_PCT	NUMBER	22
CI_PORTAL_ZONE	ZONE_ROWS	CHAR	16
CI_PORTAL_ZONE	ZONE_WIDTH_FLG	CHAR	16
CI_TD_ENTRY	RTE_BATCH_CD	CHAR	32
CI_TD_ENTRY	RTE_BATCH_NBR	NUMBER	22
CI_TD_ENTRY	TD_SUB_STATUS_FLG	CHAR	16
CI_TD_ENTRY_OPEN_VW	DKSQ1	NUMBER	22
CI_TD_ENTRY_OPEN_VW	DKSQ2	NUMBER	22
CI_TD_ENTRY_OPEN_VW	DKSQ3	NUMBER	22
CI_TD_ENTRY_OPEN_VW	DKSQ4	NUMBER	22
CI_TD_ENTRY_OPEN_VW	DKSQ5	NUMBER	22
CI_TD_ENTRY_OPEN_VW	SKSQ1	NUMBER	22
CI_TD_ENTRY_OPEN_VW	SKSQ2	NUMBER	22
CI_TD_ENTRY_OPEN_VW	SKSQ3	NUMBER	22
CI_TD_ENTRY_OPEN_VW	SKSQ4	NUMBER	22
CI_TD_ENTRY_OPEN_VW	SKSQ5	NUMBER	22
CI_TD_ENTRY_OPEN_VW	TD_SUB_STATUS_FLG	CHAR	16
CI_TD_LOG	TD_LOG_STATUS_FLG	CHAR	16
CI_XAI_SENDER	OWNER_FLG	CHAR	16
CI_XAI_SENDER_L	OWNER_FLG	CHAR	16
CI_XAI_SNDR_CTX	OWNER_FLG	CHAR	16
CI_ZONE	ZONE_ROLE_FLG	CHAR	16
CI_ZONE_PRM	ZONE_PARM_VAL	VARCHAR2	32767
D1_ACTIVITY	RESCHEDULE_REASON	VARCHAR2	1016
D1_ACTIVITY_ADJ_TYPE	D1_SP_TYPE_CD	VARCHAR2	120
D1_ACTIVITY_TYPE	SP_DVC_COND_SRC_FLG	CHAR	16
D1_ACTIVITY_TYPE	THROTTLE_OPT_FLG	CHAR	16
D1_ACTIVITY_TYPE_DIV	ACTIVITY_TYPE_CD	VARCHAR2	120
D1_ACTIVITY_TYPE_DIV	DIVISION_CD	VARCHAR2	120
D1_ACTIVITY_TYPE_DIV	VERSION	NUMBER	22
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	ACTIVITY_BO_TO_CREATE	CHAR	120
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	ACTIVITY_TYPE_CD	VARCHAR2	120
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	ALTERNATE_FIELD_TASK_TYPE	VARCHAR2	1016
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	BO_DATA_AREA	CLOB	4000
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	D1_SP_TYPE_CD	VARCHAR2	120
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	DEVICE_INSTALLED_AT_SP_SW	CHAR	4
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	DISCONN_LOC_FLG	CHAR	16
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	EXEC_OVRD_ALG_SW	CHAR	4
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	FIELD_TASK_TYPE	VARCHAR2	1016
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	INSTALL_EVENT_STATUS_OVERRIDE	VARCHAR2	1016
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	SEQNO	NUMBER	22
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	SP_CATEGORY_FLG	CHAR	16
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	SP_CONNECTED_SW	CHAR	4
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	SP_DVC_COND_FLG	CHAR	16
D1_ACTIVITY_TYPE_FLD_TASK_TYPE	VERSION	NUMBER	22
D1_ACT_DVC_SP_VW	ACCESS_GRP_CD	CHAR	48
D1_ACT_DVC_SP_VW	D1_ACTIVITY_ID	CHAR	56
D1_ACT_DVC_SP_VW	D1_PK_VALUE	VARCHAR2	1016
D1_ACT_DVC_SP_VW	MAINT_OBJ_CD	CHAR	48
D1_AGG_GROUP_RUN_MC_SET	SCAN_BATCH_CD	CHAR	32
D1_AGG_GROUP_RUN_MC_SET	SCAN_BATCH_NBR	NUMBER	22
D1_AGG_GROUP_RUN_MC_SET	SCAN_BATCH_RERUN_NBR	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_ATTR1	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR10	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR11	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR12	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR13	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR14	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR15	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR16	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR17	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR18	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR19	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR2	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR20	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR3	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR4	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR5	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR6	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR7	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR8	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_ATTR9	VARCHAR2	16000
D1_BI_DYN_AGG_VW	AGG_MEASR_COMP_ID	CHAR	48
D1_BI_DYN_AGG_VW	AGG_VAL	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL1	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL10	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL2	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL3	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL4	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL5	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL6	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL7	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL8	NUMBER	22
D1_BI_DYN_AGG_VW	AGG_VAL9	NUMBER	22
D1_BI_DYN_AGG_VW	MEASR_COMP_SET_CD	VARCHAR2	120
D1_BI_DYN_AGG_VW	MSRMT_DTTM	DATE	7
D1_CONS_EXT_TYPE	INTERVAL_SCALAR_FLG	CHAR	16
D1_CONTACT	ADDRESS1	VARCHAR2	1016
D1_CONTACT	ADDRESS1_UPPER	VARCHAR2	1016
D1_CONTACT	ADDRESS2	VARCHAR2	1016
D1_CONTACT	ADDRESS3	VARCHAR2	1016
D1_CONTACT	ADDRESS4	VARCHAR2	1016
D1_CONTACT	CITY	VARCHAR2	360
D1_CONTACT	CITY_UPPER	VARCHAR2	360
D1_CONTACT	COUNTRY	CHAR	12
D1_CONTACT	COUNTY	VARCHAR2	360
D1_CONTACT	GEO_CODE	CHAR	44
D1_CONTACT	HOUSE_TYPE	CHAR	8
D1_CONTACT	IN_CITY_LIMIT	CHAR	4
D1_CONTACT	NUM1	CHAR	24
D1_CONTACT	NUM2	CHAR	16
D1_CONTACT	POSTAL	CHAR	48
D1_CONTACT	STATE	CHAR	24
D1_CONTACT_COMM	BO_DATA_AREA	CLOB	4000
D1_CONTACT_COMM	BO_STATUS_CD	CHAR	48
D1_CONTACT_COMM	BUS_OBJ_CD	CHAR	120
D1_CONTACT_COMM	CONTACT_COMM_CAT	VARCHAR2	1016
D1_CONTACT_COMM	CONTACT_COMM_CHANNEL	VARCHAR2	1016
D1_CONTACT_COMM	CONTACT_COMM_CLASS	VARCHAR2	1016
D1_CONTACT_COMM	CONTACT_COMM_ID	CHAR	56
D1_CONTACT_COMM	CONTACT_COMM_NOTES	VARCHAR2	16000
D1_CONTACT_COMM	CONTACT_ID	CHAR	48
D1_CONTACT_COMM	CRE_DTTM	DATE	7
D1_CONTACT_COMM	D1_SP_ID	CHAR	48
D1_CONTACT_COMM	ILM_ARCH_SW	CHAR	4
D1_CONTACT_COMM	ILM_DT	DATE	7
D1_CONTACT_COMM	UPD_DTTM	DATE	7
D1_CONTACT_COMM	US_ID	CHAR	48
D1_CONTACT_COMM	VERSION	NUMBER	22
D1_CONTACT_COMM_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_CONTACT_COMM_CHAR	CHAR_TYPE_CD	CHAR	32
D1_CONTACT_COMM_CHAR	CHAR_VAL	CHAR	64
D1_CONTACT_COMM_CHAR	CHAR_VAL_FK1	VARCHAR2	200
D1_CONTACT_COMM_CHAR	CHAR_VAL_FK2	VARCHAR2	200
D1_CONTACT_COMM_CHAR	CHAR_VAL_FK3	VARCHAR2	200
D1_CONTACT_COMM_CHAR	CHAR_VAL_FK4	VARCHAR2	200
D1_CONTACT_COMM_CHAR	CHAR_VAL_FK5	VARCHAR2	200
D1_CONTACT_COMM_CHAR	CONTACT_COMM_ID	CHAR	56
D1_CONTACT_COMM_CHAR	SEQ_NUM	NUMBER	22
D1_CONTACT_COMM_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
D1_CONTACT_COMM_CHAR	VERSION	NUMBER	22
D1_CONTACT_COMM_K	CONTACT_COMM_ID	CHAR	56
D1_CONTACT_COMM_K	ENV_ID	NUMBER	22
D1_CONTACT_COMM_LOG	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_CONTACT_COMM_LOG	BO_STATUS_CD	CHAR	48
D1_CONTACT_COMM_LOG	BO_STATUS_REASON_CD	VARCHAR2	120
D1_CONTACT_COMM_LOG	CHAR_TYPE_CD	CHAR	32
D1_CONTACT_COMM_LOG	CHAR_VAL	CHAR	64
D1_CONTACT_COMM_LOG	CHAR_VAL_FK1	VARCHAR2	200
D1_CONTACT_COMM_LOG	CHAR_VAL_FK2	VARCHAR2	200
D1_CONTACT_COMM_LOG	CHAR_VAL_FK3	VARCHAR2	200
D1_CONTACT_COMM_LOG	CHAR_VAL_FK4	VARCHAR2	200
D1_CONTACT_COMM_LOG	CHAR_VAL_FK5	VARCHAR2	200
D1_CONTACT_COMM_LOG	CONTACT_COMM_ID	CHAR	56
D1_CONTACT_COMM_LOG	DESCRLONG	VARCHAR2	16000
D1_CONTACT_COMM_LOG	LOG_DTTM	DATE	7
D1_CONTACT_COMM_LOG	LOG_ENTRY_TYPE_FLG	CHAR	16
D1_CONTACT_COMM_LOG	MESSAGE_CAT_NBR	NUMBER	22
D1_CONTACT_COMM_LOG	MESSAGE_NBR	NUMBER	22
D1_CONTACT_COMM_LOG	SEQNO	NUMBER	22
D1_CONTACT_COMM_LOG	USER_ID	CHAR	32
D1_CONTACT_COMM_LOG	VERSION	NUMBER	22
D1_CONTACT_COMM_LOG_PARM	CONTACT_COMM_ID	CHAR	56
D1_CONTACT_COMM_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	16
D1_CONTACT_COMM_LOG_PARM	MSG_PARM_VAL	VARCHAR2	8000
D1_CONTACT_COMM_LOG_PARM	PARM_SEQ	NUMBER	22
D1_CONTACT_COMM_LOG_PARM	SEQNO	NUMBER	22
D1_CONTACT_COMM_LOG_PARM	VERSION	NUMBER	22
D1_CONTACT_COMM_REL_OBJ	CONTACT_COMM_ID	CHAR	56
D1_CONTACT_COMM_REL_OBJ	MAINT_OBJ_CD	CHAR	48
D1_CONTACT_COMM_REL_OBJ	PK_VALUE1	VARCHAR2	1016
D1_CONTACT_COMM_REL_OBJ	PK_VALUE2	VARCHAR2	1016
D1_CONTACT_COMM_REL_OBJ	PK_VALUE3	VARCHAR2	1016
D1_CONTACT_COMM_REL_OBJ	PK_VALUE4	VARCHAR2	1016
D1_CONTACT_COMM_REL_OBJ	PK_VALUE5	VARCHAR2	1016
D1_CONTACT_COMM_REL_OBJ	SEQNO	NUMBER	22
D1_CONTACT_COMM_REL_OBJ	VERSION	NUMBER	22
D1_CONTACT_EMAIL	EMAIL_VALUE	VARCHAR2	1016
D1_CONTACT_TYPE	CONTACT_USE_FLG	CHAR	16
D1_DVC	ACCESS_GRP_CD	CHAR	48
D1_DVC	DER_AGG_SPR_CD	VARCHAR2	120
D1_DVC_ENTITY_GRP	BO_DATA_AREA	CLOB	4000
D1_DVC_ENTITY_GRP	D1_DEVICE_ID	CHAR	48
D1_DVC_ENTITY_GRP	EFF_DTTM	DATE	7
D1_DVC_ENTITY_GRP	ENTITY_GRP_CD	VARCHAR2	120
D1_DVC_ENTITY_GRP	EXPIRATION_DTTM	DATE	7
D1_DVC_ENTITY_GRP	VERSION	NUMBER	22
D1_DVC_EQPMNT	BO_DATA_AREA	CLOB	4000
D1_DVC_EQPMNT	COMMENTS	VARCHAR2	1016
D1_DVC_EQPMNT	D1_DEVICE_ID	CHAR	48
D1_DVC_EQPMNT	D1_EQPMNT_ID	CHAR	48
D1_DVC_EQPMNT	D1_INSTALL_DTTM	DATE	7
D1_DVC_EQPMNT	D1_REMOVAL_DTTM	DATE	7
D1_DVC_EQPMNT	EQPMNT_CNT	NUMBER	22
D1_DVC_EQPMNT	MEASR_COMP_ID	CHAR	48
D1_DVC_EQPMNT	VERSION	NUMBER	22
D1_DVC_SP_VW	DIVISION_CD	VARCHAR2	120
D1_DVC_TYPE	ATTACHED_TO_FLG	CHAR	16
D1_DVC_TYPE_VALID_DVC_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_DVC_TYPE_VALID_DVC_CHAR	CHAR_TYPE_CD	CHAR	32
D1_DVC_TYPE_VALID_DVC_CHAR	CHAR_VAL	CHAR	64
D1_DVC_TYPE_VALID_DVC_CHAR	CHAR_VAL_FK1	VARCHAR2	200
D1_DVC_TYPE_VALID_DVC_CHAR	CHAR_VAL_FK2	VARCHAR2	200
D1_DVC_TYPE_VALID_DVC_CHAR	CHAR_VAL_FK3	VARCHAR2	200
D1_DVC_TYPE_VALID_DVC_CHAR	CHAR_VAL_FK4	VARCHAR2	200
D1_DVC_TYPE_VALID_DVC_CHAR	CHAR_VAL_FK5	VARCHAR2	200
D1_DVC_TYPE_VALID_DVC_CHAR	DEFAULT_SW	CHAR	4
D1_DVC_TYPE_VALID_DVC_CHAR	DEVICE_TYPE_CD	VARCHAR2	120
D1_DVC_TYPE_VALID_DVC_CHAR	REQUIRED_SW	CHAR	4
D1_DVC_TYPE_VALID_DVC_CHAR	SORT_SEQ	NUMBER	22
D1_DVC_TYPE_VALID_DVC_CHAR	VERSION	NUMBER	22
D1_DYN_OPT	D1_APPROVAL_PROF_CD	VARCHAR2	120
D1_DYN_OPT	D1_INITIATIVE_CD	VARCHAR2	120
D1_DYN_OPT	DIVISION_CD	VARCHAR2	120
D1_DYN_OPT	END_DT	DATE	7
D1_DYN_OPT	EXT_DYN_OPT_ID_VALUE	VARCHAR2	480
D1_DYN_OPT	START_DT	DATE	7
D1_DYN_OPT	SUSPEND_FLG	CHAR	16
D1_DYN_OPT_EVENT	DYN_OPT_EVENT_CAT_FLG	CHAR	16
D1_DYN_OPT_EVENT	DYN_OPT_EXT_EVT_ID_VALUE	VARCHAR2	480
D1_DYN_OPT_EVENT	DYN_OPT_EXT_ID_VALUE	VARCHAR2	480
D1_DYN_OPT_QTY	DYN_OPT_ID	CHAR	48
D1_DYN_OPT_QTY	DYN_OPT_QTY	NUMBER	22
D1_DYN_OPT_QTY	DYN_OPT_QTY_TYPE	VARCHAR2	1016
D1_DYN_OPT_QTY	END_DTTM	DATE	7
D1_DYN_OPT_QTY	START_DTTM	DATE	7
D1_DYN_OPT_QTY	VERSION	NUMBER	22
D1_DYN_OPT_QUESTION	D1_ANSWER_CD	VARCHAR2	120
D1_DYN_OPT_QUESTION	D1_QUESTION_CD	VARCHAR2	120
D1_DYN_OPT_QUESTION	DYN_OPT_ID	CHAR	48
D1_DYN_OPT_QUESTION	QUESTION_CATEGORY	VARCHAR2	1016
D1_DYN_OPT_QUESTION	RESPONSE_REQ_FLG	CHAR	16
D1_DYN_OPT_QUESTION	SEQNO	NUMBER	22
D1_DYN_OPT_QUESTION	VERSION	NUMBER	22
D1_DYN_OPT_RATE	D1_RS_CD	VARCHAR2	1016
D1_DYN_OPT_RATE	DYN_OPT_ID	CHAR	48
D1_DYN_OPT_RATE	SEQNO	NUMBER	22
D1_DYN_OPT_RATE	VERSION	NUMBER	22
D1_DYN_OPT_RULE	DYN_OPT_EVENT_CAT_FLG	CHAR	16
D1_DYN_OPT_RULE	DYN_OPT_ID	CHAR	48
D1_DYN_OPT_RULE	DYN_OPT_RULE_CD	VARCHAR2	120
D1_DYN_OPT_RULE	SEQNO	NUMBER	22
D1_DYN_OPT_RULE	VERSION	NUMBER	22
D1_DYN_OPT_SPECIFICATION	D1_SPECIFICATION_CD	VARCHAR2	120
D1_DYN_OPT_SPECIFICATION	DYN_OPT_ID	CHAR	48
D1_DYN_OPT_SPECIFICATION	SEQNO	NUMBER	22
D1_DYN_OPT_SPECIFICATION	VERSION	NUMBER	22
D1_DYN_OPT_TYPE	D1_APPROVAL_PROF_CD	VARCHAR2	120
D1_DYN_OPT_TYPE	DEVICE_REQD_FLG	CHAR	16
D1_DYN_OPT_TYPE	DYN_OPT_CATEGORY	VARCHAR2	1016
D1_DYN_OPT_TYPE	DYN_OPT_EVENT_BO_CD	CHAR	120
D1_DYN_OPT_TYPE	EVENT_PARTICIPATION_BO_CD	CHAR	120
D1_DYN_OPT_TYPE	LOCATION_REQD_SOURCE_FLG	CHAR	16
D1_DYN_OPT_TYPE_QTY_TYPE	DYN_OPT_TYPE_CD	VARCHAR2	120
D1_DYN_OPT_TYPE_QTY_TYPE	DYN_OPT_TYPE_QTY_TYPE	VARCHAR2	1016
D1_DYN_OPT_TYPE_QTY_TYPE	VERSION	NUMBER	22
D1_DYN_OPT_TYPE_REL	DYN_OPT_TYPE_CD	VARCHAR2	120
D1_DYN_OPT_TYPE_REL	DYN_OPT_TYPE_REL_TYPE_CD	VARCHAR2	120
D1_DYN_OPT_TYPE_REL	SEQNO	NUMBER	22
D1_DYN_OPT_TYPE_REL	VERSION	NUMBER	22
D1_DYN_OPT_USG_GRP	CALC_GRP_CATEGORY_FLG	CHAR	16
D1_DYN_OPT_USG_GRP	DYN_OPT_ID	CHAR	48
D1_DYN_OPT_USG_GRP	EFF_DTTM	DATE	7
D1_DYN_OPT_USG_GRP	EXPIRATION_DTTM	DATE	7
D1_DYN_OPT_USG_GRP	USG_GRP_CD	VARCHAR2	120
D1_DYN_OPT_USG_GRP	VERSION	NUMBER	22
D1_ENTITY_GRP	BO_DATA_AREA	CLOB	4000
D1_ENTITY_GRP	BUS_OBJ_CD	CHAR	120
D1_ENTITY_GRP	ENTITY_GRP_ASSGN_OPT_FLG	CHAR	16
D1_ENTITY_GRP	ENTITY_GRP_CATEGORY	VARCHAR2	1016
D1_ENTITY_GRP	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP	ENTITY_GRP_DEACT_OPT_FLG	CHAR	16
D1_ENTITY_GRP	ENTITY_GRP_STAT_FLG	CHAR	16
D1_ENTITY_GRP	VERSION	NUMBER	22
D1_ENTITY_GRP_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_ENTITY_GRP_CHAR	CHAR_TYPE_CD	CHAR	32
D1_ENTITY_GRP_CHAR	CHAR_VAL	CHAR	64
D1_ENTITY_GRP_CHAR	CHAR_VAL_FK1	VARCHAR2	200
D1_ENTITY_GRP_CHAR	CHAR_VAL_FK2	VARCHAR2	200
D1_ENTITY_GRP_CHAR	CHAR_VAL_FK3	VARCHAR2	200
D1_ENTITY_GRP_CHAR	CHAR_VAL_FK4	VARCHAR2	200
D1_ENTITY_GRP_CHAR	CHAR_VAL_FK5	VARCHAR2	200
D1_ENTITY_GRP_CHAR	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP_CHAR	SEQ_NUM	NUMBER	22
D1_ENTITY_GRP_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
D1_ENTITY_GRP_CHAR	VERSION	NUMBER	22
D1_ENTITY_GRP_CRIT	CRITERIA_SEQ_NUM	NUMBER	22
D1_ENTITY_GRP_CRIT	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP_CRIT	GRP_CRITERIA_SRC	VARCHAR2	1016
D1_ENTITY_GRP_CRIT	VERSION	NUMBER	22
D1_ENTITY_GRP_CRIT_VAL	BO_DATA_AREA	CLOB	4000
D1_ENTITY_GRP_CRIT_VAL	CRITERIA_SEQ_NUM	NUMBER	22
D1_ENTITY_GRP_CRIT_VAL	CRITERIA_VALUE	CHAR	200
D1_ENTITY_GRP_CRIT_VAL	CRITERIA_VAL_SEQ_NUM	NUMBER	22
D1_ENTITY_GRP_CRIT_VAL	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP_CRIT_VAL	GRP_CRITERIA_SRC	VARCHAR2	1016
D1_ENTITY_GRP_CRIT_VAL	VERSION	NUMBER	22
D1_ENTITY_GRP_L	DESCR100	VARCHAR2	400
D1_ENTITY_GRP_L	DESCRLONG	VARCHAR2	16000
D1_ENTITY_GRP_L	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP_L	LANGUAGE_CD	CHAR	12
D1_ENTITY_GRP_L	VERSION	NUMBER	22
D1_EVT_PARTICIPATION	BO_STATUS_CD	CHAR	48
D1_EVT_PARTICIPATION	BO_STATUS_REASON_CD	VARCHAR2	120
D1_EVT_PARTICIPATION	BO_XML_DATA_AREA	XMLTYPE	2000
D1_EVT_PARTICIPATION	BUS_OBJ_CD	CHAR	120
D1_EVT_PARTICIPATION	CRE_DTTM	DATE	7
D1_EVT_PARTICIPATION	D1_DEVICE_ID	CHAR	48
D1_EVT_PARTICIPATION	DYN_OPT_EVENT_ID	CHAR	56
D1_EVT_PARTICIPATION	DYN_OPT_ID	CHAR	48
D1_EVT_PARTICIPATION	EVENT_PARTICIPATION_ID	CHAR	56
D1_EVT_PARTICIPATION	ILM_ARCH_SW	CHAR	4
D1_EVT_PARTICIPATION	ILM_DT	DATE	7
D1_EVT_PARTICIPATION	OUTCOME_FLG	CHAR	16
D1_EVT_PARTICIPATION	PARTICIPATION_END_DTTM	DATE	7
D1_EVT_PARTICIPATION	PARTICIPATION_START_DTTM	DATE	7
D1_EVT_PARTICIPATION	PREEMPTIVE_OPT_OUT_FLG	CHAR	16
D1_EVT_PARTICIPATION	RESERVATION_END_DTTM	DATE	7
D1_EVT_PARTICIPATION	RESERVATION_FLG	CHAR	16
D1_EVT_PARTICIPATION	RESERVATION_START_DTTM	DATE	7
D1_EVT_PARTICIPATION	STATUS_UPD_DTTM	DATE	7
D1_EVT_PARTICIPATION	US_ID	CHAR	48
D1_EVT_PARTICIPATION	VERSION	NUMBER	22
D1_EVT_PARTICIPATION_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_EVT_PARTICIPATION_CHAR	CHAR_TYPE_CD	CHAR	32
D1_EVT_PARTICIPATION_CHAR	CHAR_VAL	CHAR	64
D1_EVT_PARTICIPATION_CHAR	CHAR_VAL_FK1	VARCHAR2	200
D1_EVT_PARTICIPATION_CHAR	CHAR_VAL_FK2	VARCHAR2	200
D1_EVT_PARTICIPATION_CHAR	CHAR_VAL_FK3	VARCHAR2	200
D1_EVT_PARTICIPATION_CHAR	CHAR_VAL_FK4	VARCHAR2	200
D1_EVT_PARTICIPATION_CHAR	CHAR_VAL_FK5	VARCHAR2	200
D1_EVT_PARTICIPATION_CHAR	EVENT_PARTICIPATION_ID	VARCHAR2	56
D1_EVT_PARTICIPATION_CHAR	SEQ_NUM	NUMBER	22
D1_EVT_PARTICIPATION_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
D1_EVT_PARTICIPATION_CHAR	VERSION	NUMBER	22
D1_EVT_PARTICIPATION_K	ENV_ID	NUMBER	22
D1_EVT_PARTICIPATION_K	EVENT_PARTICIPATION_ID	CHAR	56
D1_EVT_PARTICIPATION_LOG	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_EVT_PARTICIPATION_LOG	BO_STATUS_CD	CHAR	48
D1_EVT_PARTICIPATION_LOG	BO_STATUS_REASON_CD	VARCHAR2	120
D1_EVT_PARTICIPATION_LOG	CHAR_TYPE_CD	CHAR	32
D1_EVT_PARTICIPATION_LOG	CHAR_VAL	CHAR	64
D1_EVT_PARTICIPATION_LOG	CHAR_VAL_FK1	VARCHAR2	200
D1_EVT_PARTICIPATION_LOG	CHAR_VAL_FK2	VARCHAR2	200
D1_EVT_PARTICIPATION_LOG	CHAR_VAL_FK3	VARCHAR2	200
D1_EVT_PARTICIPATION_LOG	CHAR_VAL_FK4	VARCHAR2	200
D1_EVT_PARTICIPATION_LOG	CHAR_VAL_FK5	VARCHAR2	200
D1_EVT_PARTICIPATION_LOG	DESCRLONG	VARCHAR2	16000
D1_EVT_PARTICIPATION_LOG	EVENT_PARTICIPATION_ID	CHAR	56
D1_EVT_PARTICIPATION_LOG	LOG_DTTM	DATE	7
D1_EVT_PARTICIPATION_LOG	LOG_ENTRY_TYPE_FLG	CHAR	16
D1_EVT_PARTICIPATION_LOG	MESSAGE_CAT_NBR	NUMBER	22
D1_EVT_PARTICIPATION_LOG	MESSAGE_NBR	NUMBER	22
D1_EVT_PARTICIPATION_LOG	SEQNO	NUMBER	22
D1_EVT_PARTICIPATION_LOG	USER_ID	CHAR	32
D1_EVT_PARTICIPATION_LOG	VERSION	NUMBER	22
D1_EVT_PARTICIPATION_LOG_PARM	EVENT_PARTICIPATION_ID	CHAR	56
D1_EVT_PARTICIPATION_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	16
D1_EVT_PARTICIPATION_LOG_PARM	MSG_PARM_VAL	VARCHAR2	8000
D1_EVT_PARTICIPATION_LOG_PARM	PARM_SEQ	NUMBER	22
D1_EVT_PARTICIPATION_LOG_PARM	SEQNO	NUMBER	22
D1_EVT_PARTICIPATION_LOG_PARM	VERSION	NUMBER	22
D1_FACILITY_SP	D1_SP_ID	CHAR	48
D1_FACILITY_SP	FACILITY_ID	CHAR	56
D1_FACILITY_SP	VERSION	NUMBER	22
D1_IMD_CTRL_STAGE	ALG_CD	CHAR	48
D1_IMD_CTRL_STAGE	D1_FROM_DTTM	DATE	7
D1_IMD_CTRL_STAGE	D1_TO_DTTM	DATE	7
D1_IMD_CTRL_STAGE	IMD_CTRL_DC_ID	CHAR	48
D1_IMD_CTRL_STAGE	IMD_CTRL_MC_ID	CHAR	48
D1_IMD_CTRL_STAGE	IMD_CTRL_STAGE_ID	CHAR	56
D1_IMD_CTRL_STAGE	IMD_STAGE_PAYLOAD_XML	CLOB	4000
D1_IMD_CTRL_STAGE	IMD_STAGE_STATUS_FLG	CHAR	16
D1_IMD_CTRL_STAGE	IMD_TYPE_CD	VARCHAR2	120
D1_IMD_CTRL_STAGE_K	ENV_ID	NUMBER	22
D1_IMD_CTRL_STAGE_K	IMD_CTRL_STAGE_ID	CHAR	56
D1_IMD_TYPE	BO_DATA_AREA	CLOB	4000
D1_IMD_TYPE	BUS_OBJ_CD	CHAR	120
D1_IMD_TYPE	IMD_BUS_OBJ_CD	CHAR	120
D1_IMD_TYPE	IMD_SEEDER_FLG	CHAR	16
D1_IMD_TYPE	IMD_TYPE_CD	VARCHAR2	120
D1_IMD_TYPE	IMD_TYPE_STATUS_FLG	CHAR	16
D1_IMD_TYPE	OWNER_FLG	CHAR	16
D1_IMD_TYPE	VERSION	NUMBER	22
D1_IMD_TYPE_ALG	ALG_CD	CHAR	48
D1_IMD_TYPE_ALG	ERROR_BO_STATUS_CD	CHAR	48
D1_IMD_TYPE_ALG	IMD_TYPE_ALG_STATUS_FLG	CHAR	16
D1_IMD_TYPE_ALG	IMD_TYPE_CD	VARCHAR2	120
D1_IMD_TYPE_ALG	IMD_TYPE_SEVT_FLG	CHAR	16
D1_IMD_TYPE_ALG	OWNER_FLG	CHAR	16
D1_IMD_TYPE_ALG	SEQ_NUM	NUMBER	22
D1_IMD_TYPE_ALG	VERSION	NUMBER	22
D1_IMD_TYPE_L	DESCR100	VARCHAR2	400
D1_IMD_TYPE_L	DESCRLONG	VARCHAR2	16000
D1_IMD_TYPE_L	IMD_TYPE_CD	VARCHAR2	120
D1_IMD_TYPE_L	LANGUAGE_CD	CHAR	12
D1_IMD_TYPE_L	OWNER_FLG	CHAR	16
D1_IMD_TYPE_L	VERSION	NUMBER	22
D1_INBOUND_COMM_VW	D1_SP_ID	CHAR	48
D1_INBOUND_COMM_VW	DIVISION_CD	VARCHAR2	120
D1_INBOUND_COMM_VW	POSTAL	CHAR	48
D1_MC_TYPE_PER_EST_EVAL_VW	CUT_OFF_TIME	VARCHAR2	32767
D1_MC_TYPE_PER_EST_EVAL_VW	EVALUATION_DTTM	DATE	7
D1_MC_TYPE_PER_EST_EVAL_VW	HRS_WAIT_BEFORE_EST	NUMBER	22
D1_MC_TYPE_PER_EST_EVAL_VW	INTERVAL_SCALAR_FLG	CHAR	16
D1_MC_TYPE_PER_EST_EVAL_VW	MC_CLASS_FLG	CHAR	16
D1_MC_TYPE_PER_EST_EVAL_VW	MEASR_COMP_TYPE_CD	VARCHAR2	120
D1_MC_TYPE_PER_EST_EVAL_VW	TIME_ZONE_CD	CHAR	40
D1_MDSI	VERSION	NUMBER	22
D1_MDSS	VERSION	NUMBER	22
D1_MEASR_COMP	ACCESS_GRP_CD	CHAR	48
D1_MEASR_COMP_SET	DISTRIBUTE_LOAD_FLG	CHAR	16
D1_MEASR_COMP_SET	LOAD_DISTRIBUTION_FORMULA	VARCHAR2	1016
D1_MEASR_COMP_SET	LOAD_DIST_MANAGED_BY_FLG	CHAR	16
D1_MEASR_COMP_SET	NBR_OF_DIGITS_TO_USE	NUMBER	22
D1_MEASR_COMP_TYPE	ANCHR_TIME	DATE	7
D1_MEASR_COMP_TYPE	IMD_HANDLING_FLG	CHAR	16
D1_MSRMT	PREVEE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT	PREVEE_MSRMT_VAL	NUMBER	22
D1_MSRMT	PREVEE_READING_COND_FLG	CHAR	24
D1_MSRMT	PREVEE_READING_VAL	NUMBER	22
D1_MSRMT	USER_ID	CHAR	32
D1_MSRMT_AUDIT	AFTER_COMBINED_MULTIPLIER	NUMBER	22
D1_MSRMT_AUDIT	AFTER_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	AFTER_MSRMT_USE_FLG	CHAR	16
D1_MSRMT_AUDIT	AFTER_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	AFTER_PREVEE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	AFTER_PREVEE_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	AFTER_PREVEE_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	AFTER_PREVEE_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	AFTER_PREV_MSRMT_DTTM	DATE	7
D1_MSRMT_AUDIT	AFTER_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	AFTER_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_COMBINED_MULTIPLIER	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	BEFORE_MSRMT_USE_FLG	CHAR	16
D1_MSRMT_AUDIT	BEFORE_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_PREVEE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	BEFORE_PREVEE_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_PREVEE_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	BEFORE_PREVEE_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_PREV_MSRMT_DTTM	DATE	7
D1_MSRMT_AUDIT	BEFORE_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	BEFORE_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	LOG_DTTM	DATE	7
D1_MSRMT_AUDIT	MEASR_COMP_ID	CHAR	48
D1_MSRMT_AUDIT	MSRMT_AUDIT_ENTRY_TYPE_FLG	CHAR	16
D1_MSRMT_AUDIT	MSRMT_DTTM	DATE	7
D1_MSRMT_AUDIT	SEQNO	NUMBER	22
D1_MSRMT_AUDIT	USER_ID	CHAR	32
D1_NW_LOC	NETWORK_NODE_1	CHAR	56
D1_NW_LOC	NETWORK_NODE_2	CHAR	56
D1_ON_DOE_VW	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_ON_DO_VW	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_ON_DVC_CFG_VW	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_ON_IE_VW	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_OUTBOUND_COMM_VW	D1_SP_ID	CHAR	48
D1_OUTBOUND_COMM_VW	DIVISION_CD	VARCHAR2	120
D1_OUTBOUND_COMM_VW	POSTAL	CHAR	48
D1_RULE	BO_DATA_AREA	CLOB	4000
D1_RULE	BO_STATUS_CD	CHAR	48
D1_RULE	BUS_OBJ_CD	VARCHAR2	120
D1_RULE	EFF_DT	DATE	7
D1_RULE	EXPIRATION_DT	DATE	7
D1_RULE	RULE_CD	VARCHAR2	120
D1_RULE	RULE_TYPE_FLG	CHAR	16
D1_RULE	VERSION	NUMBER	22
D1_RULE_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_RULE_CHAR	CHAR_TYPE_CD	CHAR	32
D1_RULE_CHAR	CHAR_VAL	CHAR	64
D1_RULE_CHAR	CHAR_VAL_FK1	VARCHAR2	200
D1_RULE_CHAR	CHAR_VAL_FK2	VARCHAR2	200
D1_RULE_CHAR	CHAR_VAL_FK3	VARCHAR2	200
D1_RULE_CHAR	CHAR_VAL_FK4	VARCHAR2	200
D1_RULE_CHAR	CHAR_VAL_FK5	VARCHAR2	200
D1_RULE_CHAR	RULE_CD	VARCHAR2	120
D1_RULE_CHAR	SEQ_NUM	NUMBER	22
D1_RULE_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
D1_RULE_CHAR	VERSION	NUMBER	22
D1_RULE_L	DESCR100	VARCHAR2	400
D1_RULE_L	DESCRLONG	VARCHAR2	16000
D1_RULE_L	LANGUAGE_CD	CHAR	12
D1_RULE_L	RULE_CD	VARCHAR2	120
D1_RULE_L	VERSION	NUMBER	22
D1_RULE_PARM	CALC_FREQUENCY	VARCHAR2	1016
D1_RULE_PARM	D1_SEASONAL_FLG	CHAR	16
D1_RULE_PARM	ELIG_ALG_CD	CHAR	48
D1_RULE_PARM	LINE_EXT_ID	VARCHAR2	1016
D1_RULE_PARM	MIN_DAYS	NUMBER	22
D1_RULE_PARM	PRORATE_OPTION_FLG	CHAR	16
D1_RULE_PARM	RULE_CD	VARCHAR2	120
D1_RULE_PARM	RULE_TYPE_CATEGORY	VARCHAR2	1016
D1_RULE_PARM	SEASON_END	CHAR	16
D1_RULE_PARM	SEASON_START	CHAR	16
D1_RULE_PARM	SEQNO	NUMBER	22
D1_RULE_PARM	SETT_FREQ_FLG	CHAR	16
D1_RULE_PARM	USG_GRP_CD	VARCHAR2	120
D1_RULE_PARM	VERSION	NUMBER	22
D1_SP	D1_ABOLISH_DT	DATE	7
D1_SP	D1_INSTALL_DT	DATE	7
D1_SP	D1_SERVICE_AREA_CD	VARCHAR2	120
D1_SPR	ACTIVE_INACTIVE_FLG	CHAR	16
D1_SPR	CONTACT_ID	CHAR	48
D1_SPR	END_DT	DATE	7
D1_SPR	START_DT	DATE	7
D1_SPR_PROG	D1_SPR_CD	VARCHAR2	120
D1_SPR_PROG	DYN_OPT_ID	CHAR	48
D1_SPR_PROG	END_DT	DATE	7
D1_SPR_PROG	SPR_LFDI	VARCHAR2	1016
D1_SPR_PROG	START_DT	DATE	7
D1_SPR_PROG	UTILITY_APPROVAL_REQD_FLG	CHAR	16
D1_SP_ENTITY_GRP	BO_DATA_AREA	CLOB	4000
D1_SP_ENTITY_GRP	D1_SP_ID	CHAR	48
D1_SP_ENTITY_GRP	EFF_DTTM	DATE	7
D1_SP_ENTITY_GRP	ENTITY_GRP_CD	VARCHAR2	120
D1_SP_ENTITY_GRP	EXPIRATION_DTTM	DATE	7
D1_SP_ENTITY_GRP	VERSION	NUMBER	22
D1_SP_EQPMNT	ACTIVE_INACTIVE_FLG	CHAR	16
D1_SP_EQPMNT	BO_DATA_AREA	CLOB	4000
D1_SP_EQPMNT	EQPMNT_CNT	NUMBER	22
D1_SP_EQPMNT	SEQNO	NUMBER	22
D1_SP_TYPE	SP_CLASS_FLG	CHAR	16
D1_SP_TYPE_DISCONNECT_LOCATION	BO_DATA_AREA	CLOB	4000
D1_SP_TYPE_DISCONNECT_LOCATION	D1_SP_TYPE_CD	VARCHAR2	120
D1_SP_TYPE_DISCONNECT_LOCATION	DISCONN_LOC_FLG	CHAR	16
D1_SP_TYPE_DISCONNECT_LOCATION	VERSION	NUMBER	22
D1_SP_TYPE_DIV	D1_SP_TYPE_CD	VARCHAR2	120
D1_SP_TYPE_DIV	DIVISION_CD	VARCHAR2	120
D1_SP_TYPE_DIV	VERSION	NUMBER	22
D1_SP_TYPE_FIELD_TASK_TYPE	BO_DATA_AREA	CLOB	4000
D1_SP_TYPE_FIELD_TASK_TYPE	D1_SP_TYPE_CD	VARCHAR2	120
D1_SP_TYPE_FIELD_TASK_TYPE	FIELD_TASK_TYPE	VARCHAR2	1016
D1_SP_TYPE_FIELD_TASK_TYPE	VERSION	NUMBER	22
D1_SVC_TYPE	STD_SVC_TYPE_FLG	CHAR	16
D1_US	PGM_ENRL_SRC_FLG	CHAR	16
D1_USAGE	EVT_SETT_REQ_TYPE_FLG	CHAR	16
D1_USAGE	EXTRACT_FLG	CHAR	16
D1_USAGE	RULE_CD	VARCHAR2	120
D1_USAGE	RULE_TYPE_CATEGORY	VARCHAR2	1016
D1_USAGE_PERIOD_SQ	D1_AMOUNT	NUMBER	22
D1_USAGE_PERIOD_SQ	D1_CURRENCY_CD	CHAR	12
D1_USAGE_PERIOD_SQ	D1_FORMULA	VARCHAR2	200
D1_USAGE_PERIOD_SQ	D1_PRICE	NUMBER	22
D1_USAGE_PERIOD_SQ	D1_QUANTITY1	NUMBER	22
D1_USAGE_PERIOD_SQ	D1_QUANTITY2	NUMBER	22
D1_USAGE_PERIOD_SQ	D1_QUANTITY3	NUMBER	22
D1_USAGE_PERIOD_SQ	D1_QUANTITY4	NUMBER	22
D1_USAGE_PERIOD_SQ	D1_QUANTITY5	NUMBER	22
D1_USAGE_PERIOD_SQ	D1_VARIABLE_NAME	CHAR	80
D1_USAGE_PERIOD_SQ	DYN_OPT_EVENT_ID	CHAR	56
D1_USAGE_PERIOD_SQ	DYN_OPT_ID	CHAR	48
D1_USAGE_PERIOD_SQ	LINE_DESCR	VARCHAR2	1016
D1_USAGE_PERIOD_SQ_DATA	D1_AMOUNT	NUMBER	22
D1_USAGE_PERIOD_SQ_DATA	D1_PRICE	NUMBER	22
D1_USG_RULE_L	LINE_DESCR	VARCHAR2	1016
D1_US_DYN_OPT	SEQNO	NUMBER	22
D1_US_SP	SEQNO	NUMBER	22
D1_US_TYPE	EVT_SETT_BO_CD	CHAR	120
D1_US_TYPE	PROC_TIMETABLE_TYPE_CD	VARCHAR2	120
D1_US_TYPE_VALID_US_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_US_TYPE_VALID_US_CHAR	CHAR_TYPE_CD	CHAR	32
D1_US_TYPE_VALID_US_CHAR	CHAR_VAL	CHAR	64
D1_US_TYPE_VALID_US_CHAR	CHAR_VAL_FK1	VARCHAR2	200
D1_US_TYPE_VALID_US_CHAR	CHAR_VAL_FK2	VARCHAR2	200
D1_US_TYPE_VALID_US_CHAR	CHAR_VAL_FK3	VARCHAR2	200
D1_US_TYPE_VALID_US_CHAR	CHAR_VAL_FK4	VARCHAR2	200
D1_US_TYPE_VALID_US_CHAR	CHAR_VAL_FK5	VARCHAR2	200
D1_US_TYPE_VALID_US_CHAR	DEFAULT_SW	CHAR	4
D1_US_TYPE_VALID_US_CHAR	REQUIRED_SW	CHAR	4
D1_US_TYPE_VALID_US_CHAR	SORT_SEQ	NUMBER	22
D1_US_TYPE_VALID_US_CHAR	US_TYPE_CD	VARCHAR2	120
D1_US_TYPE_VALID_US_CHAR	VERSION	NUMBER	22
D2_MEASR_QTY_AGR_MV	LOCAL_DT	DATE	7
D2_MEASR_QTY_AGR_MV	MEASR_COMP_ID	CHAR	48
D2_MEASR_QTY_AGR_MV	MSRMT_DT	DATE	7
D2_MEASR_QTY_AGR_MV	MSRMT_DTTM	DATE	7
D2_MEASR_QTY_AGR_MV	MSRMT_LOCAL_DTTM	DATE	7
D2_MEASR_QTY_AGR_MV	MSRMT_VAL	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL1	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL10	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL2	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL3	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL4	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL5	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL6	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL7	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL8	NUMBER	22
D2_MEASR_QTY_AGR_MV	MSRMT_VAL9	NUMBER	22
D2_MEASR_QTY_MV	CITY	VARCHAR2	200
D2_MEASR_QTY_MV	D1_MODEL_CD	VARCHAR2	200
D2_MEASR_QTY_MV	D1_SPR_CD	VARCHAR2	200
D2_MEASR_QTY_MV	D1_SVC_TPE_CD	VARCHAR2	200
D2_MEASR_QTY_MV	DEVICE_TYPE_CD	VARCHAR2	200
D2_MEASR_QTY_MV	DEVICE_TYPE_DESCR	VARCHAR2	400
D2_MEASR_QTY_MV	GEO_CODE	VARCHAR2	200
D2_MEASR_QTY_MV	HEAD_END_SYSTEM_CD	VARCHAR2	200
D2_MEASR_QTY_MV	HEAD_END_SYSTEM_DESCR	VARCHAR2	400
D2_MEASR_QTY_MV	MANUFACTURER_CD	VARCHAR2	200
D2_MEASR_QTY_MV	MANUFACTURER_DESCR	VARCHAR2	400
D2_MEASR_QTY_MV	MC_TYPE_DESCR	VARCHAR2	400
D2_MEASR_QTY_MV	MEASR_COMP_ID	CHAR	48
D2_MEASR_QTY_MV	MEASR_COMP_TYPE_CD	VARCHAR2	120
D2_MEASR_QTY_MV	MKT_CD	VARCHAR2	200
D2_MEASR_QTY_MV	MKT_DESCR	VARCHAR2	400
D2_MEASR_QTY_MV	MKT_REL_TYPE_DESCR	VARCHAR2	240
D2_MEASR_QTY_MV	MKT_REL_TYPE_FLG	VARCHAR2	200
D2_MEASR_QTY_MV	MODEL_DESCR	VARCHAR2	400
D2_MEASR_QTY_MV	POSTAL	VARCHAR2	200
D2_MEASR_QTY_MV	SPR_DESCR	VARCHAR2	400
D2_MEASR_QTY_MV	SVC_TYPE_DESCR	VARCHAR2	400
D2_MEASR_QTY_MV	USG_CALC_GRP_CD	VARCHAR2	200
D2_MEASR_QTY_MV	USG_CALC_GRP_DESCR	VARCHAR2	400
D2_QUALITY_CNT_AGR_MV	LOCAL_DT	DATE	7
D2_QUALITY_CNT_AGR_MV	MEASR_COMP_ID	CHAR	48
D2_QUALITY_CNT_AGR_MV	MSRMT_DT	DATE	7
D2_QUALITY_CNT_AGR_MV	MSRMT_DTTM	DATE	7
D2_QUALITY_CNT_AGR_MV	MSRMT_LOCAL_DTTM	DATE	7
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL1	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL10	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL2	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL3	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL4	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL5	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL6	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL7	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL8	NUMBER	22
D2_QUALITY_CNT_AGR_MV	MSRMT_VAL9	NUMBER	22
D2_QUALITY_CNT_MV	CITY	VARCHAR2	200
D2_QUALITY_CNT_MV	D1_MODEL_CD	VARCHAR2	200
D2_QUALITY_CNT_MV	D1_SPR_CD	VARCHAR2	200
D2_QUALITY_CNT_MV	D1_SVC_TPE_CD	VARCHAR2	200
D2_QUALITY_CNT_MV	DEVICE_TYPE_CD	VARCHAR2	200
D2_QUALITY_CNT_MV	DEVICE_TYPE_DESCR	VARCHAR2	400
D2_QUALITY_CNT_MV	GEO_CODE	VARCHAR2	200
D2_QUALITY_CNT_MV	HEAD_END_SYSTEM_CD	VARCHAR2	200
D2_QUALITY_CNT_MV	HEAD_END_SYSTEM_DESCR	VARCHAR2	400
D2_QUALITY_CNT_MV	MANUFACTURER_CD	VARCHAR2	200
D2_QUALITY_CNT_MV	MANUFACTURER_DESCR	VARCHAR2	400
D2_QUALITY_CNT_MV	MC_TYPE_DESCR	VARCHAR2	400
D2_QUALITY_CNT_MV	MEASR_COMP_ID	CHAR	48
D2_QUALITY_CNT_MV	MEASR_COMP_TYPE_CD	VARCHAR2	120
D2_QUALITY_CNT_MV	MKT_CD	VARCHAR2	200
D2_QUALITY_CNT_MV	MKT_DESCR	VARCHAR2	400
D2_QUALITY_CNT_MV	MKT_REL_TYPE_DESCR	VARCHAR2	240
D2_QUALITY_CNT_MV	MKT_REL_TYPE_FLG	VARCHAR2	200
D2_QUALITY_CNT_MV	MODEL_DESCR	VARCHAR2	400
D2_QUALITY_CNT_MV	POSTAL	VARCHAR2	200
D2_QUALITY_CNT_MV	SPR_DESCR	VARCHAR2	400
D2_QUALITY_CNT_MV	SVC_TYPE_DESCR	VARCHAR2	400
D2_QUALITY_CNT_MV	USG_CALC_GRP_CD	VARCHAR2	200
D2_QUALITY_CNT_MV	USG_CALC_GRP_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	CITY	VARCHAR2	200
D2_TIMELINESS_CNT_MV	D1_MODEL_CD	VARCHAR2	200
D2_TIMELINESS_CNT_MV	D1_SPR_CD	VARCHAR2	200
D2_TIMELINESS_CNT_MV	D1_SVC_TPE_CD	VARCHAR2	200
D2_TIMELINESS_CNT_MV	DEVICE_TYPE_CD	VARCHAR2	200
D2_TIMELINESS_CNT_MV	DEVICE_TYPE_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	GEO_CODE	VARCHAR2	200
D2_TIMELINESS_CNT_MV	HEAD_END_SYSTEM_CD	VARCHAR2	200
D2_TIMELINESS_CNT_MV	HEAD_END_SYSTEM_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	MANUFACTURER_CD	VARCHAR2	200
D2_TIMELINESS_CNT_MV	MANUFACTURER_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	MC_TYPE_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	MEASR_COMP_ID	CHAR	48
D2_TIMELINESS_CNT_MV	MEASR_COMP_TYPE_CD	VARCHAR2	120
D2_TIMELINESS_CNT_MV	MKT_CD	VARCHAR2	200
D2_TIMELINESS_CNT_MV	MKT_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	MKT_REL_TYPE_DESCR	VARCHAR2	240
D2_TIMELINESS_CNT_MV	MKT_REL_TYPE_FLG	VARCHAR2	200
D2_TIMELINESS_CNT_MV	MODEL_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	POSTAL	VARCHAR2	200
D2_TIMELINESS_CNT_MV	SPR_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	SVC_TYPE_DESCR	VARCHAR2	400
D2_TIMELINESS_CNT_MV	USG_CALC_GRP_CD	VARCHAR2	200
D2_TIMELINESS_CNT_MV	USG_CALC_GRP_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	CITY	VARCHAR2	200
D2_TIMELINESS_QTY_MV	D1_MODEL_CD	VARCHAR2	200
D2_TIMELINESS_QTY_MV	D1_SPR_CD	VARCHAR2	200
D2_TIMELINESS_QTY_MV	D1_SVC_TPE_CD	VARCHAR2	200
D2_TIMELINESS_QTY_MV	DEVICE_TYPE_CD	VARCHAR2	200
D2_TIMELINESS_QTY_MV	DEVICE_TYPE_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	GEO_CODE	VARCHAR2	200
D2_TIMELINESS_QTY_MV	HEAD_END_SYSTEM_CD	VARCHAR2	200
D2_TIMELINESS_QTY_MV	HEAD_END_SYSTEM_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	MANUFACTURER_CD	VARCHAR2	200
D2_TIMELINESS_QTY_MV	MANUFACTURER_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	MC_TYPE_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	MEASR_COMP_ID	CHAR	48
D2_TIMELINESS_QTY_MV	MEASR_COMP_TYPE_CD	VARCHAR2	120
D2_TIMELINESS_QTY_MV	MKT_CD	VARCHAR2	200
D2_TIMELINESS_QTY_MV	MKT_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	MKT_REL_TYPE_DESCR	VARCHAR2	240
D2_TIMELINESS_QTY_MV	MKT_REL_TYPE_FLG	VARCHAR2	200
D2_TIMELINESS_QTY_MV	MODEL_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	POSTAL	VARCHAR2	200
D2_TIMELINESS_QTY_MV	SPR_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	SVC_TYPE_DESCR	VARCHAR2	400
D2_TIMELINESS_QTY_MV	USG_CALC_GRP_CD	VARCHAR2	200
D2_TIMELINESS_QTY_MV	USG_CALC_GRP_DESCR	VARCHAR2	400
D2_TIMELINES_CNT_AGR_MV	LOCAL_DT	DATE	7
D2_TIMELINES_CNT_AGR_MV	MEASR_COMP_ID	CHAR	48
D2_TIMELINES_CNT_AGR_MV	MSRMT_DT	DATE	7
D2_TIMELINES_CNT_AGR_MV	MSRMT_DTTM	DATE	7
D2_TIMELINES_CNT_AGR_MV	MSRMT_LOCAL_DTTM	DATE	7
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL1	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL10	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL2	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL3	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL4	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL5	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL6	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL7	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL8	NUMBER	22
D2_TIMELINES_CNT_AGR_MV	MSRMT_VAL9	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	LOCAL_DT	DATE	7
D2_TIMELINES_QTY_AGR_MV	MEASR_COMP_ID	CHAR	48
D2_TIMELINES_QTY_AGR_MV	MSRMT_DT	DATE	7
D2_TIMELINES_QTY_AGR_MV	MSRMT_DTTM	DATE	7
D2_TIMELINES_QTY_AGR_MV	MSRMT_LOCAL_DTTM	DATE	7
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL1	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL10	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL2	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL3	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL4	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL5	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL6	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL7	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL8	NUMBER	22
D2_TIMELINES_QTY_AGR_MV	MSRMT_VAL9	NUMBER	22
F1_ACTION_METHOD	ACTION_METHOD_CD	VARCHAR2	120
F1_ACTION_METHOD	ACTION_METHOD_ROLE_XFLG	VARCHAR2	120
F1_ACTION_METHOD	BO_XML_DATA_AREA	XMLTYPE	2000
F1_ACTION_METHOD	BUS_OBJ_CD	CHAR	120
F1_ACTION_METHOD	VERSION	NUMBER	22
F1_ACTION_METHOD_CHAR	ACTION_METHOD_CD	VARCHAR2	120
F1_ACTION_METHOD_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
F1_ACTION_METHOD_CHAR	CHAR_TYPE_CD	CHAR	32
F1_ACTION_METHOD_CHAR	CHAR_VAL	CHAR	64
F1_ACTION_METHOD_CHAR	CHAR_VAL_FK1	VARCHAR2	200
F1_ACTION_METHOD_CHAR	CHAR_VAL_FK2	VARCHAR2	200
F1_ACTION_METHOD_CHAR	CHAR_VAL_FK3	VARCHAR2	200
F1_ACTION_METHOD_CHAR	CHAR_VAL_FK4	VARCHAR2	200
F1_ACTION_METHOD_CHAR	CHAR_VAL_FK5	VARCHAR2	200
F1_ACTION_METHOD_CHAR	SEQ_NUM	NUMBER	22
F1_ACTION_METHOD_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
F1_ACTION_METHOD_CHAR	VERSION	NUMBER	22
F1_ACTION_METHOD_L	ACTION_METHOD_CD	VARCHAR2	120
F1_ACTION_METHOD_L	DESCR100	VARCHAR2	400
F1_ACTION_METHOD_L	DESCRLONG	VARCHAR2	16000
F1_ACTION_METHOD_L	LANGUAGE_CD	CHAR	12
F1_ACTION_METHOD_L	VERSION	NUMBER	22
F1_ARC_TBL_PARTITION_HIST	ACTUAL_DROP_DTTM	DATE	7
F1_ARC_TBL_PARTITION_HIST	APPROVAL_DROP_DTTM	DATE	7
F1_ARC_TBL_PARTITION_HIST	APPROVAL_USER_ID	CHAR	32
F1_ARC_TBL_PARTITION_HIST	ARCHIVE_DTTM	DATE	7
F1_ARC_TBL_PARTITION_HIST	ARCHIVE_FILE_NAME	VARCHAR2	512
F1_ARC_TBL_PARTITION_HIST	ARCHIVE_METHOD_FLG	CHAR	16
F1_ARC_TBL_PARTITION_HIST	CRE_DTTM	DATE	7
F1_ARC_TBL_PARTITION_HIST	DROP_APPROVAL_FLG	CHAR	16
F1_ARC_TBL_PARTITION_HIST	DROP_PART_STAT_FLG	CHAR	16
F1_ARC_TBL_PARTITION_HIST	ESTIMATED_SIZE_GB	NUMBER	22
F1_ARC_TBL_PARTITION_HIST	PARTITION_MON	VARCHAR2	12
F1_ARC_TBL_PARTITION_HIST	PARTITION_YEAR	NUMBER	22
F1_ARC_TBL_PARTITION_HIST	PART_OR_SUBPART_NAME	VARCHAR2	512
F1_ARC_TBL_PARTITION_HIST	REPEAT_DTTM	DATE	7
F1_ARC_TBL_PARTITION_HIST	REPEAT_FLG	CHAR	16
F1_ARC_TBL_PARTITION_HIST	REPEAT_USER_ID	CHAR	32
F1_ARC_TBL_PARTITION_HIST	RETENTION_OR_SUBRET_DAYS	NUMBER	22
F1_ARC_TBL_PARTITION_HIST	SCHED_DROP_DTTM	DATE	7
F1_ARC_TBL_PARTITION_HIST	TBL_NAME	CHAR	120
F1_ARC_TBL_PARTITION_HIST	TBL_OWNER	VARCHAR2	512
F1_ATTACHMENT	ATTCH_CONT_LOC_FLG	CHAR	16
F1_ATTACHMENT	ATTCH_FILE_REF	VARCHAR2	8000
F1_ATTACHMENT_DATA	ATTACHMENT_ID	CHAR	56
F1_ATTACHMENT_DATA	ATTCH_DATA_USAGE_FLG	CHAR	16
F1_ATTACHMENT_DATA	ATTCH_FILE_DETAILS	CLOB	4000
F1_ATTACHMENT_DATA	SEQNO	NUMBER	22
F1_BATCH_CONF_VW	AVG_ELAPSED	NUMBER	22
F1_BATCH_CONF_VW	BATCH_CD	CHAR	32
F1_BATCH_CONF_VW	BATCH_PERF_COUNT	NUMBER	22
F1_BATCH_CONF_VW	BEST_ELAPSED	NUMBER	22
F1_BATCH_CONF_VW	CONFIDENCE	NUMBER	22
F1_BATCH_CONF_VW	MED_ELAPSED	NUMBER	22
F1_BATCH_CONF_VW	SAMPLE_SIZE	NUMBER	22
F1_BATCH_CONF_VW	STD_DEVIATION	NUMBER	22
F1_BATCH_CONF_VW	WORST_ELAPSED	NUMBER	22
F1_BATCH_RUN_ANALYTICS_SNAP	BATCH_BUS_DT	DATE	7
F1_BATCH_RUN_ANALYTICS_SNAP	BATCH_CD	CHAR	32
F1_BATCH_RUN_ANALYTICS_SNAP	BATCH_JOB_ID	CHAR	56
F1_BATCH_RUN_ANALYTICS_SNAP	BATCH_JOB_STAT_FLG	CHAR	8
F1_BATCH_RUN_ANALYTICS_SNAP	BATCH_NBR	NUMBER	22
F1_BATCH_RUN_ANALYTICS_SNAP	BATCH_RERUN_NBR	NUMBER	22
F1_BATCH_RUN_ANALYTICS_SNAP	CRE_DTTM	DATE	7
F1_BATCH_RUN_ANALYTICS_SNAP	DO_NOT_RESTART_SW	CHAR	4
F1_BATCH_RUN_ANALYTICS_SNAP	ELAPSED_SECS	NUMBER	22
F1_BATCH_RUN_ANALYTICS_SNAP	END_DTTM	DATE	7
F1_BATCH_RUN_ANALYTICS_SNAP	PROCESS_DT	DATE	7
F1_BATCH_RUN_ANALYTICS_SNAP	REC_ERR_CNT	NUMBER	22
F1_BATCH_RUN_ANALYTICS_SNAP	REC_PROC_CNT	NUMBER	22
F1_BATCH_RUN_ANALYTICS_SNAP	RUN_STATUS	CHAR	8
F1_BATCH_RUN_ANALYTICS_SNAP	START_DTTM	DATE	7
F1_BATCH_RUN_ANALYTICS_SNAP	SUBMIT_METH_FLG	CHAR	16
F1_BATCH_RUN_ANALYTICS_SNAP	SUBMIT_USER_ID	CHAR	32
F1_BATCH_RUN_ANALYTICS_SNAP	THREADPOOL	VARCHAR2	1016
F1_BATCH_RUN_ANALYTICS_SNAP	USER_ID	CHAR	32
F1_BATCH_RUN_ANALYTICS_SNAP	VERSION	NUMBER	22
F1_BATCH_RUN_HIST_VW	BATCH_BUS_DT	DATE	7
F1_BATCH_RUN_HIST_VW	BATCH_CD	CHAR	32
F1_BATCH_RUN_HIST_VW	BATCH_JOB_ID	CHAR	56
F1_BATCH_RUN_HIST_VW	BATCH_NBR	NUMBER	22
F1_BATCH_RUN_HIST_VW	BATCH_RERUN_NBR	NUMBER	22
F1_BATCH_RUN_HIST_VW	BATCH_RUN_COUNT	NUMBER	22
F1_BATCH_RUN_HIST_VW	DO_NOT_RESTART_SW	CHAR	4
F1_BATCH_RUN_HIST_VW	ELAPSED_TIME	NUMBER	22
F1_BATCH_RUN_HIST_VW	END_DTTM	DATE	7
F1_BATCH_RUN_HIST_VW	PROCESS_DT	DATE	7
F1_BATCH_RUN_HIST_VW	RUN_STATUS	CHAR	8
F1_BATCH_RUN_HIST_VW	START_DTTM	DATE	7
F1_BATCH_RUN_HIST_VW	SUBMIT_METH_FLG	CHAR	16
F1_BATCH_RUN_HIST_VW	SUBMIT_USER_ID	CHAR	32
F1_BATCH_RUN_HIST_VW	THREADPOOL	VARCHAR2	1016
F1_BATCH_RUN_HIST_VW	TOTAL_ERROR	NUMBER	22
F1_BATCH_RUN_HIST_VW	TOTAL_PROCESSED	NUMBER	22
F1_BATCH_RUN_HIST_VW	USER_ID	CHAR	32
F1_BATCH_THD_ANALYTICS_SNAP	BATCH_BUS_DT	DATE	7
F1_BATCH_THD_ANALYTICS_SNAP	BATCH_CD	CHAR	32
F1_BATCH_THD_ANALYTICS_SNAP	BATCH_JOB_ID	CHAR	56
F1_BATCH_THD_ANALYTICS_SNAP	BATCH_NBR	NUMBER	22
F1_BATCH_THD_ANALYTICS_SNAP	BATCH_RERUN_NBR	NUMBER	22
F1_BATCH_THD_ANALYTICS_SNAP	BATCH_THREAD_NBR	NUMBER	22
F1_BATCH_THD_ANALYTICS_SNAP	CRE_DTTM	DATE	7
F1_BATCH_THD_ANALYTICS_SNAP	END_DT	DATE	7
F1_BATCH_THD_ANALYTICS_SNAP	END_DTTM	DATE	7
F1_BATCH_THD_ANALYTICS_SNAP	REC_ERR_CNT	NUMBER	22
F1_BATCH_THD_ANALYTICS_SNAP	REC_PROC_CNT	NUMBER	22
F1_BATCH_THD_ANALYTICS_SNAP	RUN_STATUS	CHAR	8
F1_BATCH_THD_ANALYTICS_SNAP	SCHEDULER_ID	NUMBER	22
F1_BATCH_THD_ANALYTICS_SNAP	START_DT	DATE	7
F1_BATCH_THD_ANALYTICS_SNAP	START_DTTM	DATE	7
F1_BATCH_THD_ANALYTICS_SNAP	SUBMIT_METH_FLG	CHAR	16
F1_BATCH_THD_ANALYTICS_SNAP	SUBMIT_USER_ID	CHAR	32
F1_BATCH_THD_ANALYTICS_SNAP	THD_RETRY_CNT	NUMBER	22
F1_BATCH_THD_ANALYTICS_SNAP	THREADPOOL	VARCHAR2	1016
F1_BATCH_THD_ANALYTICS_SNAP	THREAD_STATUS	CHAR	8
F1_BATCH_THD_ANALYTICS_SNAP	VERSION	NUMBER	22
F1_BATCH_THD_CAP_VW	BATCH_BUS_DT	DATE	7
F1_BATCH_THD_CAP_VW	BATCH_CD	CHAR	32
F1_BATCH_THD_CAP_VW	BATCH_JOB_ID	CHAR	56
F1_BATCH_THD_CAP_VW	BATCH_NBR	NUMBER	22
F1_BATCH_THD_CAP_VW	BATCH_RERUN_NBR	NUMBER	22
F1_BATCH_THD_CAP_VW	BATCH_THREAD_CAP_COUNT	NUMBER	22
F1_BATCH_THD_CAP_VW	BATCH_THREAD_NBR	NUMBER	22
F1_BATCH_THD_CAP_VW	END_DT	DATE	7
F1_BATCH_THD_CAP_VW	F1_MINUTE_IN_DAY	NUMBER	22
F1_BATCH_THD_CAP_VW	F1_TIME_KEY	CHAR	16
F1_BATCH_THD_CAP_VW	JOB_END_MINS	NUMBER	22
F1_BATCH_THD_CAP_VW	JOB_START_MINS	NUMBER	22
F1_BATCH_THD_CAP_VW	RUN_PROCESSING_DT	DATE	7
F1_BATCH_THD_CAP_VW	START_DT	DATE	7
F1_BATCH_THD_CAP_VW	SUBMIT_METH_FLG	CHAR	16
F1_BATCH_THD_CAP_VW	SUBMIT_USER_ID	CHAR	32
F1_BATCH_THD_CAP_VW	THREADPOOL	VARCHAR2	1016
F1_BATCH_THD_CAP_VW	THREAD_END_DTTM	DATE	7
F1_BATCH_THD_CAP_VW	THREAD_START_DTTM	DATE	7
F1_BATCH_THD_HIST_VW	BATCH_BUS_DT	DATE	7
F1_BATCH_THD_HIST_VW	BATCH_CD	CHAR	32
F1_BATCH_THD_HIST_VW	BATCH_JOB_ID	CHAR	56
F1_BATCH_THD_HIST_VW	BATCH_NBR	NUMBER	22
F1_BATCH_THD_HIST_VW	BATCH_RERUN_NBR	NUMBER	22
F1_BATCH_THD_HIST_VW	BATCH_RUN_THD_COUNT	NUMBER	22
F1_BATCH_THD_HIST_VW	BATCH_THREAD_NBR	NUMBER	22
F1_BATCH_THD_HIST_VW	ELAPSED_TIME	NUMBER	22
F1_BATCH_THD_HIST_VW	PROCESS_DT	DATE	7
F1_BATCH_THD_HIST_VW	RECS_PER_MINUTE	NUMBER	22
F1_BATCH_THD_HIST_VW	RETRY_COUNT	NUMBER	22
F1_BATCH_THD_HIST_VW	RUN_STATUS	CHAR	8
F1_BATCH_THD_HIST_VW	THREADPOOL	VARCHAR2	1016
F1_BATCH_THD_HIST_VW	THREAD_END_DTTM	DATE	7
F1_BATCH_THD_HIST_VW	THREAD_START_DTTM	DATE	7
F1_BATCH_THD_HIST_VW	THREAD_STATUS	CHAR	8
F1_BATCH_THD_HIST_VW	TOTAL_ERROR	NUMBER	22
F1_BATCH_THD_HIST_VW	TOTAL_PROCESSED	NUMBER	22
F1_BATCH_VOL_VW	BATCH_CD	CHAR	32
F1_BATCH_VOL_VW	BATCH_NBR	NUMBER	22
F1_BATCH_VOL_VW	BATCH_RERUN_NBR	NUMBER	22
F1_BATCH_VOL_VW	BATCH_THD_VOL_COUNT	NUMBER	22
F1_BATCH_VOL_VW	MAX_PROCESSED	NUMBER	22
F1_BATCH_VOL_VW	RECS_PER_MINUTE	NUMBER	22
F1_BATCH_VOL_VW	TOTAL_PROCESSED	NUMBER	22
F1_BUS_OBJ_STATUS_L	DESCR_OVRD	VARCHAR2	240
F1_BUS_OBJ_STATUS_RSN_L	DESCR_OVRD	VARCHAR2	240
F1_BUS_OBJ_STATUS_RSN_VW	BO_STATUS_REASON_CD	VARCHAR2	120
F1_BUS_OBJ_STATUS_RSN_VW	DESCR	VARCHAR2	240
F1_BUS_OBJ_STATUS_RSN_VW	DESCRLONG	VARCHAR2	16000
F1_BUS_OBJ_STATUS_RSN_VW	LANGUAGE_CD	CHAR	12
F1_BUS_OBJ_STATUS_RSN_VW	OWNER_FLG	CHAR	16
F1_BUS_OBJ_STATUS_RSN_VW	VERSION	NUMBER	22
F1_BUS_OBJ_STATUS_VW	BO_STATUS_CD	CHAR	48
F1_BUS_OBJ_STATUS_VW	BUS_OBJ_CD	CHAR	120
F1_BUS_OBJ_STATUS_VW	DESCR	VARCHAR2	240
F1_BUS_OBJ_STATUS_VW	DESCRLONG	VARCHAR2	16000
F1_BUS_OBJ_STATUS_VW	LANGUAGE_CD	CHAR	12
F1_BUS_OBJ_STATUS_VW	OWNER_FLG	CHAR	16
F1_BUS_OBJ_STATUS_VW	VERSION	NUMBER	22
F1_BUS_OBJ_TR_RULE_L	BO_NEXT_STATUS_OVRD_LBL	VARCHAR2	240
F1_CAL_FISC_PERIOD_D	F1_FISC_PERIOD_END_DT	DATE	7
F1_CAL_FISC_PERIOD_D	F1_FISC_PERIOD_FLG	CHAR	16
F1_CAL_FISC_PERIOD_D	F1_FISC_PERIOD_IN_QUARTER	NUMBER	22
F1_CAL_FISC_PERIOD_D	F1_FISC_PERIOD_IN_YEAR	NUMBER	22
F1_CAL_FISC_PERIOD_D	F1_FISC_PERIOD_KEY	NUMBER	22
F1_CAL_FISC_PERIOD_D	F1_FISC_PERIOD_START_DT	DATE	7
F1_CAL_FISC_PERIOD_D	F1_FISC_QUARTER_END_DT	DATE	7
F1_CAL_FISC_PERIOD_D	F1_FISC_QUARTER_FLG	CHAR	16
F1_CAL_FISC_PERIOD_D	F1_FISC_QUARTER_IN_YEAR	NUMBER	22
F1_CAL_FISC_PERIOD_D	F1_FISC_QUARTER_KEY	NUMBER	22
F1_CAL_FISC_PERIOD_D	F1_FISC_QUARTER_START_DT	DATE	7
F1_CAL_FISC_PERIOD_D	F1_FISC_YEAR	NUMBER	22
F1_CAL_FISC_PERIOD_D	F1_FISC_YEAR_END_DT	DATE	7
F1_CAL_FISC_PERIOD_D	F1_FISC_YEAR_START_DT	DATE	7
F1_CAL_FISC_QUARTER_D	F1_FISC_QUARTER_END_DT	DATE	7
F1_CAL_FISC_QUARTER_D	F1_FISC_QUARTER_FLG	CHAR	16
F1_CAL_FISC_QUARTER_D	F1_FISC_QUARTER_IN_YEAR	NUMBER	22
F1_CAL_FISC_QUARTER_D	F1_FISC_QUARTER_KEY	NUMBER	22
F1_CAL_FISC_QUARTER_D	F1_FISC_QUARTER_START_DT	DATE	7
F1_CAL_FISC_QUARTER_D	F1_FISC_YEAR	NUMBER	22
F1_CAL_FISC_QUARTER_D	F1_FISC_YEAR_END_DT	DATE	7
F1_CAL_FISC_QUARTER_D	F1_FISC_YEAR_START_DT	DATE	7
F1_CAL_FISC_YEAR_D	F1_FISC_YEAR	NUMBER	22
F1_CAL_FISC_YEAR_D	F1_FISC_YEAR_END_DT	DATE	7
F1_CAL_FISC_YEAR_D	F1_FISC_YEAR_START_DT	DATE	7
F1_CAL_MONTH_D	F1MONTH_ABBR	CHAR	16
F1_CAL_MONTH_D	F1_CAL_QUARTER_END_DT	DATE	7
F1_CAL_MONTH_D	F1_CAL_QUARTER_FLG	CHAR	16
F1_CAL_MONTH_D	F1_CAL_QUARTER_IN_YEAR	NUMBER	22
F1_CAL_MONTH_D	F1_CAL_QUARTER_KEY	NUMBER	22
F1_CAL_MONTH_D	F1_CAL_QUARTER_START_DT	DATE	7
F1_CAL_MONTH_D	F1_CAL_YEAR	NUMBER	22
F1_CAL_MONTH_D	F1_CAL_YEAR_END_DT	DATE	7
F1_CAL_MONTH_D	F1_CAL_YEAR_NAME	CHAR	16
F1_CAL_MONTH_D	F1_CAL_YEAR_START_DT	DATE	7
F1_CAL_MONTH_D	F1_MONTH_END_DT	DATE	7
F1_CAL_MONTH_D	F1_MONTH_IN_QUARTER	NUMBER	22
F1_CAL_MONTH_D	F1_MONTH_IN_YEAR	NUMBER	22
F1_CAL_MONTH_D	F1_MONTH_KEY	NUMBER	22
F1_CAL_MONTH_D	F1_MONTH_START_DT	DATE	7
F1_CAL_QUARTER_D	F1_CAL_QUARTER_END_DT	DATE	7
F1_CAL_QUARTER_D	F1_CAL_QUARTER_FLG	CHAR	16
F1_CAL_QUARTER_D	F1_CAL_QUARTER_IN_YEAR	NUMBER	22
F1_CAL_QUARTER_D	F1_CAL_QUARTER_KEY	NUMBER	22
F1_CAL_QUARTER_D	F1_CAL_QUARTER_START_DT	DATE	7
F1_CAL_QUARTER_D	F1_CAL_YEAR	NUMBER	22
F1_CAL_QUARTER_D	F1_CAL_YEAR_END_DT	DATE	7
F1_CAL_QUARTER_D	F1_CAL_YEAR_NAME	CHAR	16
F1_CAL_QUARTER_D	F1_CAL_YEAR_START_DT	DATE	7
F1_CAL_WEEK_D	F1_WEEK_END_DT	DATE	7
F1_CAL_WEEK_D	F1_WEEK_IN_YEAR	NUMBER	22
F1_CAL_WEEK_D	F1_WEEK_KEY	NUMBER	22
F1_CAL_WEEK_D	F1_WEEK_NAME	CHAR	28
F1_CAL_WEEK_D	F1_WEEK_START_DT	DATE	7
F1_CAL_YEAR_D	F1_CAL_YEAR	NUMBER	22
F1_CAL_YEAR_D	F1_CAL_YEAR_END_DT	DATE	7
F1_CAL_YEAR_D	F1_CAL_YEAR_NAME	CHAR	16
F1_CAL_YEAR_D	F1_CAL_YEAR_START_DT	DATE	7
F1_COLOR_OPT	BACKGROUND_COLOR_XFLG	VARCHAR2	120
F1_COLOR_OPT	BO_XML_DATA_AREA	XMLTYPE	2000
F1_COLOR_OPT	BUS_OBJ_CD	CHAR	120
F1_COLOR_OPT	COLOR_OPT_CD	VARCHAR2	120
F1_COLOR_OPT	COLOR_OPT_CLASS_FLG	CHAR	16
F1_COLOR_OPT	FOREGROUND_COLOR_XFLG	VARCHAR2	120
F1_COLOR_OPT	OWNER_FLG	CHAR	16
F1_COLOR_OPT	VERSION	NUMBER	22
F1_COLOR_OPT_ITEM	COLOR_OPT_CD	VARCHAR2	120
F1_COLOR_OPT_ITEM	ITEM_BACKGROUND_COLOR_XFLG	VARCHAR2	120
F1_COLOR_OPT_ITEM	ITEM_FOREGROUND_COLOR_XFLG	VARCHAR2	120
F1_COLOR_OPT_ITEM	OWNER_FLG	CHAR	16
F1_COLOR_OPT_ITEM	SEQNO	NUMBER	22
F1_COLOR_OPT_ITEM	VERSION	NUMBER	22
F1_COLOR_OPT_L	COLOR_OPT_CD	VARCHAR2	120
F1_COLOR_OPT_L	DESCR100	VARCHAR2	400
F1_COLOR_OPT_L	LANGUAGE_CD	CHAR	12
F1_COLOR_OPT_L	OWNER_FLG	CHAR	16
F1_COLOR_OPT_L	VERSION	NUMBER	22
F1_CRYPTO_KEY	PUBLIC_KEY	VARCHAR2	32767
F1_CRYPTO_KEY_RING	KEY_RING_CAT_FLG	CHAR	16
F1_CRYPTO_KEY_RING	OWNER_FLG	CHAR	16
F1_CRYPTO_KEY_RING_L	OWNER_FLG	CHAR	16
F1_DATA_EXPORT_CTRL	BUS_OBJ_CD	CHAR	120
F1_DATA_EXPORT_CTRL	CRE_DTTM	DATE	7
F1_DATA_EXPORT_CTRL	F1_DATA_EXPORT_CD	VARCHAR2	120
F1_DATA_EXPORT_CTRL	F1_DATA_EXPORT_CLS_FLG	CHAR	16
F1_DATA_EXPORT_CTRL	F1_EXPORT_THRU_DTTM	DATE	7
F1_DATA_EXPORT_CTRL	F1_INIT_EXPORT_FLG	CHAR	16
F1_DATA_EXPORT_CTRL	F1_ONGEXP_STATUS_FLG	CHAR	16
F1_DATA_EXPORT_CTRL	MAINT_OBJ_CD	CHAR	48
F1_DATA_EXPORT_CTRL	VERSION	NUMBER	22
F1_DATA_EXPORT_CTRL_LOG	ADHOC_CHAR_VAL	VARCHAR2	1016
F1_DATA_EXPORT_CTRL_LOG	CHAR_TYPE_CD	CHAR	32
F1_DATA_EXPORT_CTRL_LOG	CHAR_VAL	CHAR	64
F1_DATA_EXPORT_CTRL_LOG	CHAR_VAL_FK1	VARCHAR2	200
F1_DATA_EXPORT_CTRL_LOG	CHAR_VAL_FK2	VARCHAR2	200
F1_DATA_EXPORT_CTRL_LOG	CHAR_VAL_FK3	VARCHAR2	200
F1_DATA_EXPORT_CTRL_LOG	CHAR_VAL_FK4	VARCHAR2	200
F1_DATA_EXPORT_CTRL_LOG	CHAR_VAL_FK5	VARCHAR2	200
F1_DATA_EXPORT_CTRL_LOG	DESCRLONG	VARCHAR2	16000
F1_DATA_EXPORT_CTRL_LOG	F1_DATA_EXPORT_CD	VARCHAR2	120
F1_DATA_EXPORT_CTRL_LOG	LOG_DTTM	DATE	7
F1_DATA_EXPORT_CTRL_LOG	LOG_ENTRY_TYPE_FLG	CHAR	16
F1_DATA_EXPORT_CTRL_LOG	MESSAGE_CAT_NBR	NUMBER	22
F1_DATA_EXPORT_CTRL_LOG	MESSAGE_NBR	NUMBER	22
F1_DATA_EXPORT_CTRL_LOG	SEQNO	NUMBER	22
F1_DATA_EXPORT_CTRL_LOG	USER_ID	CHAR	32
F1_DATA_EXPORT_CTRL_LOG	VERSION	NUMBER	22
F1_DATA_EXPORT_CTRL_LOG_PARM	F1_DATA_EXPORT_CD	VARCHAR2	120
F1_DATA_EXPORT_CTRL_LOG_PARM	MSG_PARM_TYP_FLG	CHAR	16
F1_DATA_EXPORT_CTRL_LOG_PARM	MSG_PARM_VAL	VARCHAR2	8000
F1_DATA_EXPORT_CTRL_LOG_PARM	PARM_SEQ	NUMBER	22
F1_DATA_EXPORT_CTRL_LOG_PARM	SEQNO	NUMBER	22
F1_DATA_EXPORT_CTRL_LOG_PARM	VERSION	NUMBER	22
F1_ETL_MP_CTRL	F1_BI_TYPE_FLD	CHAR	120
F1_ETL_MP_CTRL	F1_BI_TYPE_VALUE	CHAR	16
F1_EXTSYS_OUTMSG_PROF	OWNER_FLG	CHAR	16
F1_FILE_INT_REC	BO_XML_DATA_AREA	XMLTYPE	2000
F1_FILE_INT_REC	BUS_OBJ_CD	CHAR	120
F1_FILE_INT_REC	DATA_AREA_CD	CHAR	120
F1_FILE_INT_REC	FILE_INT_REC_CD	VARCHAR2	120
F1_FILE_INT_REC	FILE_INT_REC_STATUS_FLG	CHAR	16
F1_FILE_INT_REC	FILE_INT_TYPE_CD	VARCHAR2	120
F1_FILE_INT_REC	OWNER_FLG	CHAR	16
F1_FILE_INT_REC	PRNT_SEQ	NUMBER	22
F1_FILE_INT_REC	ROOT_ELEM	VARCHAR2	400
F1_FILE_INT_REC	SEQNO	NUMBER	22
F1_FILE_INT_REC	VERSION	NUMBER	22
F1_FILE_INT_REC_ALG	ALG_CD	CHAR	48
F1_FILE_INT_REC_ALG	FILE_INT_REC_CD	VARCHAR2	120
F1_FILE_INT_REC_ALG	FILE_INT_REC_SEVT_FLG	CHAR	16
F1_FILE_INT_REC_ALG	FILE_INT_TYPE_CD	VARCHAR2	120
F1_FILE_INT_REC_ALG	OWNER_FLG	CHAR	16
F1_FILE_INT_REC_ALG	SEQ_NUM	NUMBER	22
F1_FILE_INT_REC_ALG	VERSION	NUMBER	22
F1_FILE_INT_REC_L	DESCR100	VARCHAR2	400
F1_FILE_INT_REC_L	DESCR4000	VARCHAR2	16000
F1_FILE_INT_REC_L	FILE_INT_REC_CD	VARCHAR2	120
F1_FILE_INT_REC_L	FILE_INT_TYPE_CD	VARCHAR2	120
F1_FILE_INT_REC_L	LANGUAGE_CD	CHAR	12
F1_FILE_INT_REC_L	OWNER_FLG	CHAR	16
F1_FILE_INT_REC_L	VERSION	NUMBER	22
F1_FILE_INT_TYPE	BO_XML_DATA_AREA	XMLTYPE	2000
F1_FILE_INT_TYPE	BUS_OBJ_CD	CHAR	120
F1_FILE_INT_TYPE	FILE_INT_CLASS_FLG	CHAR	16
F1_FILE_INT_TYPE	FILE_INT_OBJ_FLG	CHAR	16
F1_FILE_INT_TYPE	FILE_INT_STATUS_FLG	CHAR	16
F1_FILE_INT_TYPE	FILE_INT_TYPE_CD	VARCHAR2	120
F1_FILE_INT_TYPE	OWNER_FLG	CHAR	16
F1_FILE_INT_TYPE	VERSION	NUMBER	22
F1_FILE_INT_TYPE_L	DESCR100	VARCHAR2	400
F1_FILE_INT_TYPE_L	DESCR4000	VARCHAR2	16000
F1_FILE_INT_TYPE_L	FILE_INT_TYPE_CD	VARCHAR2	120
F1_FILE_INT_TYPE_L	LANGUAGE_CD	CHAR	12
F1_FILE_INT_TYPE_L	OWNER_FLG	CHAR	16
F1_FILE_INT_TYPE_L	VERSION	NUMBER	22
F1_INSIGHT_GRP	BO_XML_DATA_AREA	XMLTYPE	2000
F1_INSIGHT_GRP	BUS_OBJ_CD	CHAR	120
F1_INSIGHT_GRP	INSIGHT_CLASS_FLG	CHAR	16
F1_INSIGHT_GRP	INSIGHT_GRP_CD	VARCHAR2	120
F1_INSIGHT_GRP	VERSION	NUMBER	22
F1_INSIGHT_GRP_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
F1_INSIGHT_GRP_CHAR	CHAR_TYPE_CD	CHAR	32
F1_INSIGHT_GRP_CHAR	CHAR_VAL	CHAR	64
F1_INSIGHT_GRP_CHAR	CHAR_VAL_FK1	VARCHAR2	200
F1_INSIGHT_GRP_CHAR	CHAR_VAL_FK2	VARCHAR2	200
F1_INSIGHT_GRP_CHAR	CHAR_VAL_FK3	VARCHAR2	200
F1_INSIGHT_GRP_CHAR	CHAR_VAL_FK4	VARCHAR2	200
F1_INSIGHT_GRP_CHAR	CHAR_VAL_FK5	VARCHAR2	200
F1_INSIGHT_GRP_CHAR	INSIGHT_GRP_CD	VARCHAR2	120
F1_INSIGHT_GRP_CHAR	SEQ_NUM	NUMBER	22
F1_INSIGHT_GRP_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
F1_INSIGHT_GRP_CHAR	VERSION	NUMBER	22
F1_INSIGHT_GRP_L	DESCR100	VARCHAR2	400
F1_INSIGHT_GRP_L	DESCRLONG	VARCHAR2	16000
F1_INSIGHT_GRP_L	INSIGHT_GRP_CD	VARCHAR2	120
F1_INSIGHT_GRP_L	LANGUAGE_CD	CHAR	12
F1_INSIGHT_GRP_L	VERSION	NUMBER	22
F1_INSIGHT_GRP_TYPE	INSIGHT_GRP_CD	VARCHAR2	120
F1_INSIGHT_GRP_TYPE	INSIGHT_TYPE_CD	VARCHAR2	120
F1_INSIGHT_GRP_TYPE	SEQ_NUM	NUMBER	22
F1_INSIGHT_GRP_TYPE	VERSION	NUMBER	22
F1_INSIGHT_GRP_VISUAL_STR	INSIGHT_GRP_CD	VARCHAR2	120
F1_INSIGHT_GRP_VISUAL_STR	VERSION	NUMBER	22
F1_INSIGHT_GRP_VISUAL_STR	VISUAL_STRUCTURE_FLG	CHAR	16
F1_INSIGHT_TYPE	BO_XML_DATA_AREA	XMLTYPE	2000
F1_INSIGHT_TYPE	BUS_OBJ_CD	CHAR	120
F1_INSIGHT_TYPE	INSIGHT_ACT_TRACK_FLG	CHAR	16
F1_INSIGHT_TYPE	INSIGHT_TYPE_CD	VARCHAR2	120
F1_INSIGHT_TYPE	OWNER_FLG	CHAR	16
F1_INSIGHT_TYPE	VERSION	NUMBER	22
F1_INSIGHT_TYPE	VISUAL_STRUCTURE_FLG	CHAR	16
F1_INSIGHT_TYPE_ALG	ALG_CD	CHAR	48
F1_INSIGHT_TYPE_ALG	INSIGHT_SEVT_FLG	CHAR	16
F1_INSIGHT_TYPE_ALG	INSIGHT_TYPE_CD	VARCHAR2	120
F1_INSIGHT_TYPE_ALG	OWNER_FLG	CHAR	16
F1_INSIGHT_TYPE_ALG	SEQ_NUM	NUMBER	22
F1_INSIGHT_TYPE_ALG	VERSION	NUMBER	22
F1_INSIGHT_TYPE_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
F1_INSIGHT_TYPE_CHAR	CHAR_TYPE_CD	CHAR	32
F1_INSIGHT_TYPE_CHAR	CHAR_VAL	CHAR	64
F1_INSIGHT_TYPE_CHAR	CHAR_VAL_FK1	VARCHAR2	200
F1_INSIGHT_TYPE_CHAR	CHAR_VAL_FK2	VARCHAR2	200
F1_INSIGHT_TYPE_CHAR	CHAR_VAL_FK3	VARCHAR2	200
F1_INSIGHT_TYPE_CHAR	CHAR_VAL_FK4	VARCHAR2	200
F1_INSIGHT_TYPE_CHAR	CHAR_VAL_FK5	VARCHAR2	200
F1_INSIGHT_TYPE_CHAR	INSIGHT_TYPE_CD	VARCHAR2	120
F1_INSIGHT_TYPE_CHAR	OWNER_FLG	CHAR	16
F1_INSIGHT_TYPE_CHAR	SEQ_NUM	NUMBER	22
F1_INSIGHT_TYPE_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
F1_INSIGHT_TYPE_CHAR	VERSION	NUMBER	22
F1_INSIGHT_TYPE_L	DESCR100	VARCHAR2	400
F1_INSIGHT_TYPE_L	DESCRLONG	VARCHAR2	16000
F1_INSIGHT_TYPE_L	INSIGHT_TYPE_CD	VARCHAR2	120
F1_INSIGHT_TYPE_L	LANGUAGE_CD	CHAR	12
F1_INSIGHT_TYPE_L	OWNER_FLG	CHAR	16
F1_INSIGHT_TYPE_L	VERSION	NUMBER	22
F1_INSIGHT_TYPE_USER_ACT	INSIGHT_ACT_CD	VARCHAR2	120
F1_INSIGHT_TYPE_USER_ACT	INSIGHT_ACT_CLASS_FLG	CHAR	16
F1_INSIGHT_TYPE_USER_ACT	INSIGHT_ACT_DISP_TYPE	CHAR	16
F1_INSIGHT_TYPE_USER_ACT	INSIGHT_ACT_FLD_FLG	CHAR	16
F1_INSIGHT_TYPE_USER_ACT	INSIGHT_TYPE_CD	VARCHAR2	120
F1_INSIGHT_TYPE_USER_ACT	OWNER_FLG	CHAR	16
F1_INSIGHT_TYPE_USER_ACT	SCR_CD	CHAR	48
F1_INSIGHT_TYPE_USER_ACT	VERSION	NUMBER	22
F1_INSIGHT_TYPE_USER_ACT_ALG	ALG_CD	CHAR	48
F1_INSIGHT_TYPE_USER_ACT_ALG	INSIGHT_ACT_CD	VARCHAR2	120
F1_INSIGHT_TYPE_USER_ACT_ALG	INSIGHT_ACT_SEVT_FLG	CHAR	16
F1_INSIGHT_TYPE_USER_ACT_ALG	INSIGHT_TYPE_CD	VARCHAR2	120
F1_INSIGHT_TYPE_USER_ACT_ALG	OWNER_FLG	CHAR	16
F1_INSIGHT_TYPE_USER_ACT_ALG	SEQ_NUM	NUMBER	22
F1_INSIGHT_TYPE_USER_ACT_ALG	VERSION	NUMBER	22
F1_INSIGHT_TYPE_VISUAL_SETTING	DISP_ICON_CD	CHAR	48
F1_INSIGHT_TYPE_VISUAL_SETTING	HEADER_CAT_FLG	CHAR	16
F1_INSIGHT_TYPE_VISUAL_SETTING	HEADER_COLOR_OPT_CD	VARCHAR2	120
F1_INSIGHT_TYPE_VISUAL_SETTING	ICON_COLOR_OPT_CD	VARCHAR2	120
F1_INSIGHT_TYPE_VISUAL_SETTING	INSIGHT_COLOR_OPT_CD	VARCHAR2	120
F1_INSIGHT_TYPE_VISUAL_SETTING	INSIGHT_TYPE_CD	VARCHAR2	120
F1_INSIGHT_TYPE_VISUAL_SETTING	OWNER_FLG	CHAR	16
F1_INSIGHT_TYPE_VISUAL_SETTING	SEQ_NUM	NUMBER	22
F1_INSIGHT_TYPE_VISUAL_SETTING	SEVERITY_VAL	NUMBER	22
F1_INSIGHT_TYPE_VISUAL_SETTING	VERSION	NUMBER	22
F1_INSIGHT_TYPE_VISUAL_SETTING	VISUAL_SETTING_TYPE_FLG	CHAR	16
F1_IWS_SVC	IWS_REST_VER_FLG	CHAR	16
F1_IWS_SVC	PUBLISH_FLG	CHAR	16
F1_IWS_SVC_FLDTEXT	EXAMPLE_TEXT	VARCHAR2	16000
F1_IWS_SVC_FLDTEXT	FLD_NAME	CHAR	120
F1_IWS_SVC_FLDTEXT	IN_SVC_NAME	VARCHAR2	1016
F1_IWS_SVC_FLDTEXT	IWS_HELP_TEXT	VARCHAR2	16000
F1_IWS_SVC_FLDTEXT	OWNER_FLG	CHAR	16
F1_IWS_SVC_FLDTEXT	TEXT_NAME	CHAR	120
F1_IWS_SVC_FLDTEXT	VERSION	NUMBER	22
F1_IWS_SVC_OPER	MAINT_OBJ_CD	CHAR	48
F1_IWS_SVC_OPER	SEQ_NUM	NUMBER	22
F1_IWS_SVC_OPER_L	DESCR	VARCHAR2	240
F1_IWS_SVC_OPER_L	DESCRLONG	VARCHAR2	16000
F1_IWS_SVC_OPER_L	IN_SVC_NAME	VARCHAR2	1016
F1_IWS_SVC_OPER_L	LANGUAGE_CD	CHAR	12
F1_IWS_SVC_OPER_L	OPERATION_NAME	VARCHAR2	1016
F1_IWS_SVC_OPER_L	OWNER_FLG	CHAR	16
F1_IWS_SVC_OPER_L	VERSION	NUMBER	22
F1_IWS_SVC_OPER_OPT	IN_SVC_NAME	VARCHAR2	1016
F1_IWS_SVC_OPER_OPT	IWS_OPR_OPT_FLG	CHAR	16
F1_IWS_SVC_OPER_OPT	IWS_OPR_OPT_VAL	VARCHAR2	32767
F1_IWS_SVC_OPER_OPT	OPERATION_NAME	VARCHAR2	1016
F1_IWS_SVC_OPER_OPT	OWNER_FLG	CHAR	16
F1_IWS_SVC_OPER_OPT	SEQ_NUM	NUMBER	22
F1_IWS_SVC_OPER_OPT	VERSION	NUMBER	22
F1_IWS_SVC_SCHEMA	IN_SVC_NAME	VARCHAR2	1016
F1_IWS_SVC_SCHEMA	IWS_SCHEMA_DEFN	CLOB	4000
F1_IWS_SVC_SCHEMA	IWS_SCHEMA_NAME	VARCHAR2	1016
F1_IWS_SVC_SCHEMA	IWS_SCHEMA_TYPE_FLG	CHAR	16
F1_IWS_SVC_SCHEMA	OWNER_FLG	CHAR	16
F1_IWS_SVC_SCHEMA	VERSION	NUMBER	22
F1_LGCY_OBJ	CHANGE_REF_NAME	VARCHAR2	120
F1_LGCY_OBJ	LGCY_CAT_FLG	CHAR	16
F1_MD_BI_TBL	BUS_OBJ_CD	CHAR	120
F1_MD_BI_TBL	F1_BI_HIER_DEFN	VARCHAR2	32767
F1_MD_BI_TBL	F1_BI_NAME	VARCHAR2	400
F1_MD_BI_TBL	F1_BI_TABLE_TYPE_FLG	CHAR	16
F1_MD_BI_TBL	F1_BI_TBL_NAME	CHAR	120
F1_MD_BI_TBL	OWNER_FLG	CHAR	16
F1_MD_BI_TBL	TBL_NAME	CHAR	120
F1_MD_BI_TBL	VERSION	NUMBER	22
F1_MD_BI_TBL_FLD	BI_ELEM_NAME	VARCHAR2	240
F1_MD_BI_TBL_FLD	F1_AGG_RULE_FLG	CHAR	16
F1_MD_BI_TBL_FLD	F1_BI_FLD_TYPE_FLG	CHAR	16
F1_MD_BI_TBL_FLD	F1_BI_TBL_NAME	CHAR	120
F1_MD_BI_TBL_FLD	F1_BUCKET_BO	VARCHAR2	120
F1_MD_BI_TBL_FLD	F1_CALC_EXP	VARCHAR2	16000
F1_MD_BI_TBL_FLD	F1_DEGENERATE_SW	CHAR	4
F1_MD_BI_TBL_FLD	F1_DISP_SEQ_NUM	NUMBER	22
F1_MD_BI_TBL_FLD	F1_HIDE_TIME_SW	CHAR	4
F1_MD_BI_TBL_FLD	F1_INTERNAL_SW	CHAR	4
F1_MD_BI_TBL_FLD	F1_PROC_OPT_FLG	CHAR	16
F1_MD_BI_TBL_FLD	FLD_NAME	CHAR	120
F1_MD_BI_TBL_FLD	LOGICAL_DM_NAME	VARCHAR2	240
F1_MD_BI_TBL_FLD	OVRD_FLD_NAME	CHAR	120
F1_MD_BI_TBL_FLD	OWNER_FLG	CHAR	16
F1_MD_BI_TBL_FLD	SEQ_NUM	NUMBER	22
F1_MD_BI_TBL_FLD	VERSION	NUMBER	22
F1_MD_BI_TBL_L	DESCR100	VARCHAR2	400
F1_MD_BI_TBL_L	DESCRLONG	VARCHAR2	16000
F1_MD_BI_TBL_L	F1_BI_TBL_NAME	CHAR	120
F1_MD_BI_TBL_L	LANGUAGE_CD	CHAR	12
F1_MD_BI_TBL_L	OWNER_FLG	CHAR	16
F1_MD_BI_TBL_L	VERSION	NUMBER	22
F1_MENU_APP_SVCS_VW	APP_SVC_ID	CHAR	80
F1_MENU_APP_SVCS_VW	LINE_VISIBILITY_SW	CHAR	4
F1_MENU_APP_SVCS_VW	MENU_LINE_ID	CHAR	40
F1_MIGR_DATA_ST	BULK_IMPORT_FLG	CHAR	16
F1_MIGR_DATA_ST	INSERT_ONLY_FLG	CHAR	16
F1_MIGR_DATA_ST	MIGR_FILEVERSION	NUMBER	22
F1_MIGR_DATA_ST	REDACT_OPT_FLG	CHAR	16
F1_MIGR_DATA_ST_TBL	RECORD_COUNT	NUMBER	22
F1_MIGR_OBJ	ENTITIES_CNT	NUMBER	22
F1_MIGR_OBJ_DATA	MIGR_OBJ_ID	CHAR	56
F1_MIGR_OBJ_DATA	SEQ_NUM	NUMBER	22
F1_MIGR_OBJ_DATA	TBL_DATA	CLOB	4000
F1_MIGR_OBJ_DATA	VERSION	NUMBER	22
F1_MIGR_OBJ_SQL	PK_VALUE1	VARCHAR2	1016
F1_MIGR_OBJ_SQL	PK_VALUE2	VARCHAR2	1016
F1_MIGR_OBJ_SQL	PK_VALUE3	VARCHAR2	1016
F1_MIGR_OBJ_SQL	PK_VALUE4	VARCHAR2	1016
F1_MIGR_OBJ_SQL	PK_VALUE5	VARCHAR2	1016
F1_MIGR_REQ_INSTR	ENTITY_TAG	VARCHAR2	120
F1_MO_UPD	ENT_KEY_HASH	NUMBER	22
F1_MO_UPD	MAINT_OBJ_CD	CHAR	48
F1_MO_UPD	PK_VALUE1	VARCHAR2	1016
F1_MO_UPD	PK_VALUE2	VARCHAR2	1016
F1_MO_UPD	PK_VALUE3	VARCHAR2	1016
F1_MO_UPD	PK_VALUE4	VARCHAR2	1016
F1_MO_UPD	PK_VALUE5	VARCHAR2	1016
F1_MO_UPD_BACKLOG	ENT_KEY_HASH	NUMBER	22
F1_MO_UPD_BACKLOG	MAINT_OBJ_CD	CHAR	48
F1_MO_UPD_BACKLOG	PK_VALUE1	VARCHAR2	1016
F1_MO_UPD_BACKLOG	PK_VALUE2	VARCHAR2	1016
F1_MO_UPD_BACKLOG	PK_VALUE3	VARCHAR2	1016
F1_MO_UPD_BACKLOG	PK_VALUE4	VARCHAR2	1016
F1_MO_UPD_BACKLOG	PK_VALUE5	VARCHAR2	1016
F1_MO_UPD_BACKLOG	REC_ROW_ID	VARCHAR2	400
F1_MO_UPD_BACKUP	BATCH_CD	CHAR	32
F1_MO_UPD_BACKUP	BATCH_NBR	NUMBER	22
F1_MO_UPD_BACKUP	BATCH_THREAD_NBR	NUMBER	22
F1_MO_UPD_BACKUP	CRE_DTTM	DATE	7
F1_MO_UPD_BACKUP	EXPORTED_KEYS	CLOB	4000
F1_MST_CONFIG	CONFIG_CLS_FLG	CHAR	16
F1_MST_CONFIG	CONFIG_PART_NAME	VARCHAR2	1016
F1_MST_CONFIG_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
F1_MST_CONFIG_CHAR	BUS_OBJ_CD	CHAR	120
F1_MST_CONFIG_CHAR	CHAR_TYPE_CD	CHAR	32
F1_MST_CONFIG_CHAR	CHAR_VAL	CHAR	64
F1_MST_CONFIG_CHAR	CHAR_VAL_FK1	VARCHAR2	200
F1_MST_CONFIG_CHAR	CHAR_VAL_FK2	VARCHAR2	200
F1_MST_CONFIG_CHAR	CHAR_VAL_FK3	VARCHAR2	200
F1_MST_CONFIG_CHAR	CHAR_VAL_FK4	VARCHAR2	200
F1_MST_CONFIG_CHAR	CHAR_VAL_FK5	VARCHAR2	200
F1_MST_CONFIG_CHAR	CONFIG_PART_NAME	VARCHAR2	1016
F1_MST_CONFIG_CHAR	SEQ_NUM	NUMBER	22
F1_MST_CONFIG_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
F1_MST_CONFIG_CHAR	VERSION	NUMBER	22
F1_PATCH_DETAILS	APPL_VERSION	VARCHAR2	240
F1_PATCH_DETAILS	BASE_REF_ID	VARCHAR2	240
F1_PATCH_DETAILS	EXT_PATCH_REF_ID	VARCHAR2	240
F1_PATCH_DETAILS	PATCH_CATEGORY	VARCHAR2	1016
F1_PATCH_DETAILS	PATCH_COMP_XFLG	VARCHAR2	120
F1_PATCH_DETAILS	PATCH_COPY_FLG	CHAR	16
F1_PATCH_DETAILS	PATCH_DESCR	VARCHAR2	1016
F1_PATCH_DETAILS	PATCH_ID	CHAR	48
F1_PATCH_DETAILS	PATCH_INSTALL_DTTM	DATE	7
F1_PATCH_DETAILS	PATCH_PROD_ID	VARCHAR2	120
F1_PATCH_DETAILS	PATCH_VERSION	VARCHAR2	240
F1_PATCH_DETAILS	RELATED_REF_ID	VARCHAR2	240
F1_PATCH_DETAILS	RELEASE_VER	VARCHAR2	400
F1_PATCH_DETAILS	VERSION	NUMBER	22
F1_PROC_PANEL	UI_MAP_CD	CHAR	120
F1_PROD_METRIC_SNPSHT	BO_STATUS_CD	CHAR	48
F1_PROD_METRIC_SNPSHT	BO_XML_DATA_AREA	XMLTYPE	2000
F1_PROD_METRIC_SNPSHT	BUS_OBJ_CD	CHAR	120
F1_PROD_METRIC_SNPSHT	CRE_DTTM	DATE	7
F1_PROD_METRIC_SNPSHT	METRIC_SNAPSHOT_ID	CHAR	48
F1_PROD_METRIC_SNPSHT	PROD_METRIC_TYPE_CD	VARCHAR2	120
F1_PROD_METRIC_SNPSHT	SNAPSHOT_XML_DATA_AREA	XMLTYPE	2000
F1_PROD_METRIC_SNPSHT	STATUS_UPD_DTTM	DATE	7
F1_PROD_METRIC_SNPSHT	VERSION	NUMBER	22
F1_PROD_METRIC_SNPSHT_K	ENV_ID	NUMBER	22
F1_PROD_METRIC_SNPSHT_K	METRIC_SNAPSHOT_ID	CHAR	48
F1_PROD_METRIC_SNPSHT_VAL	EXT_PROD_METRIC	CHAR	144
F1_PROD_METRIC_SNPSHT_VAL	METRIC_SNAPSHOT_ID	CHAR	48
F1_PROD_METRIC_SNPSHT_VAL	METRIC_VALUE	VARCHAR2	1016
F1_PROD_METRIC_SNPSHT_VAL	VERSION	NUMBER	22
F1_PROD_METRIC_TYPE	BO_STATUS_CD	CHAR	48
F1_PROD_METRIC_TYPE	BO_XML_DATA_AREA	XMLTYPE	2000
F1_PROD_METRIC_TYPE	BUS_OBJ_CD	CHAR	120
F1_PROD_METRIC_TYPE	OWNER_FLG	CHAR	16
F1_PROD_METRIC_TYPE	PROD_METRIC_TYPE_CD	VARCHAR2	120
F1_PROD_METRIC_TYPE	PROD_OFFERINGS	VARCHAR2	400
F1_PROD_METRIC_TYPE	SNAPSHOT_BO_CD	CHAR	120
F1_PROD_METRIC_TYPE	VERSION	NUMBER	22
F1_PROD_METRIC_TYPE_L	DESCR100	VARCHAR2	400
F1_PROD_METRIC_TYPE_L	DESCRLONG	VARCHAR2	16000
F1_PROD_METRIC_TYPE_L	LANGUAGE_CD	CHAR	12
F1_PROD_METRIC_TYPE_L	OWNER_FLG	CHAR	16
F1_PROD_METRIC_TYPE_L	PROD_METRIC_TYPE_CD	VARCHAR2	120
F1_PROD_METRIC_TYPE_L	VERSION	NUMBER	22
F1_REDACTION_RULE	BUS_OBJ_CD	CHAR	120
F1_REDACTION_RULE	FLD_NAME	CHAR	120
F1_REDACTION_RULE	REDACT_FILTER_EXP	VARCHAR2	8000
F1_REDACTION_RULE	REDACT_FUNC_XFLG	VARCHAR2	120
F1_REDACTION_RULE	REDACT_REF_FLD	CHAR	120
F1_REDACTION_RULE	REDACT_RULE_CD	VARCHAR2	120
F1_REDACTION_RULE	REDACT_SRC_TYPE_FLG	CHAR	16
F1_REDACTION_RULE	REDACT_XPATH_EXP	VARCHAR2	8000
F1_REDACTION_RULE	TBL_NAME	CHAR	120
F1_REDACTION_RULE	VERSION	NUMBER	22
F1_REDACTION_RULE_L	DESCR100	VARCHAR2	400
F1_REDACTION_RULE_L	LANGUAGE_CD	CHAR	12
F1_REDACTION_RULE_L	REDACT_RULE_CD	VARCHAR2	120
F1_REDACTION_RULE_L	VERSION	NUMBER	22
F1_REQ_TYPE	OWNER_FLG	CHAR	16
F1_REQ_TYPE_L	OWNER_FLG	CHAR	16
F1_SIBSCH_TBLS_VW	SYSTEM_TBL_SW	CHAR	4
F1_SIBSCH_TBLS_VW	TBL_NAME	CHAR	120
F1_TAG	BO_DATA_AREA	CLOB	4000
F1_TAG	BUS_OBJ_CD	CHAR	120
F1_TAG	ENTITY_TAG	VARCHAR2	120
F1_TAG	ENTITY_TAG_CLASS_FLG	CHAR	16
F1_TAG	MAINT_OBJ_CD	CHAR	48
F1_TAG	OWNER_FLG	CHAR	16
F1_TAG	TAG_STATUS_FLG	CHAR	16
F1_TAG	VERSION	NUMBER	22
F1_TAGGED_ENTITY	ENTITY_TAG	VARCHAR2	120
F1_TAGGED_ENTITY	KEYS	VARCHAR2	800
F1_TAGGED_ENTITY	MAINT_OBJ_CD	CHAR	48
F1_TAGGED_ENTITY	OWNER_FLG	CHAR	16
F1_TAGGED_ENTITY	PK_VALUE1	VARCHAR2	1016
F1_TAGGED_ENTITY	PK_VALUE2	VARCHAR2	1016
F1_TAGGED_ENTITY	PK_VALUE3	VARCHAR2	1016
F1_TAGGED_ENTITY	PK_VALUE4	VARCHAR2	1016
F1_TAGGED_ENTITY	PK_VALUE5	VARCHAR2	1016
F1_TAGGED_ENTITY	REFERENCE_NAME	VARCHAR2	240
F1_TAGGED_ENTITY	VERSION	NUMBER	22
F1_TAG_CHAR	ADHOC_CHAR_VAL	VARCHAR2	1016
F1_TAG_CHAR	CHAR_TYPE_CD	CHAR	32
F1_TAG_CHAR	CHAR_VAL	CHAR	64
F1_TAG_CHAR	CHAR_VAL_FK1	VARCHAR2	200
F1_TAG_CHAR	CHAR_VAL_FK2	VARCHAR2	200
F1_TAG_CHAR	CHAR_VAL_FK3	VARCHAR2	200
F1_TAG_CHAR	CHAR_VAL_FK4	VARCHAR2	200
F1_TAG_CHAR	CHAR_VAL_FK5	VARCHAR2	200
F1_TAG_CHAR	ENTITY_TAG	VARCHAR2	120
F1_TAG_CHAR	OWNER_FLG	CHAR	16
F1_TAG_CHAR	SEQ_NUM	NUMBER	22
F1_TAG_CHAR	SRCH_CHAR_VAL	VARCHAR2	200
F1_TAG_CHAR	VERSION	NUMBER	22
F1_TAG_L	DESCR100	VARCHAR2	400
F1_TAG_L	DESCRLONG	VARCHAR2	16000
F1_TAG_L	ENTITY_TAG	VARCHAR2	120
F1_TAG_L	LANGUAGE_CD	CHAR	12
F1_TAG_L	OWNER_FLG	CHAR	16
F1_TAG_L	VERSION	NUMBER	22
F1_TREE	APPLY_HEADER_STYLE_FLG	CHAR	16
F1_TREE	BUS_OBJ_CD	CHAR	120
F1_TREE	OWNER_FLG	CHAR	16
F1_TREE	TREE_CD	CHAR	120
F1_TREE	VERSION	NUMBER	22
F1_TREE_L	DESCR100	VARCHAR2	400
F1_TREE_L	LANGUAGE_CD	CHAR	12
F1_TREE_L	OWNER_FLG	CHAR	16
F1_TREE_L	TREE_CD	CHAR	120
F1_TREE_L	VERSION	NUMBER	22
F1_TREE_NODE	BROADCAST_NODE_FLG	CHAR	16
F1_TREE_NODE	CONTEXT_MENU_NAME	CHAR	120
F1_TREE_NODE	CTXT_MENU_USAGE_FLG	CHAR	16
F1_TREE_NODE	DISP_ICON_CD	CHAR	48
F1_TREE_NODE	INITIALLY_EXPAND_FLG	CHAR	16
F1_TREE_NODE	NODE_NAME	CHAR	120
F1_TREE_NODE	NODE_NAVIGATION_FLG	CHAR	16
F1_TREE_NODE	NODE_TEXT_FORMAT	VARCHAR2	8000
F1_TREE_NODE	NODE_TEXT_LABEL	CHAR	120
F1_TREE_NODE	OWNER_FLG	CHAR	16
F1_TREE_NODE	PARENT_NODE_NAME	CHAR	120
F1_TREE_NODE	SEQNO	NUMBER	22
F1_TREE_NODE	TREE_CD	CHAR	120
F1_TREE_NODE	VERSION	NUMBER	22
F1_TREE_NODE_ALG	ALG_CD	CHAR	48
F1_TREE_NODE_ALG	NODE_NAME	CHAR	120
F1_TREE_NODE_ALG	OWNER_FLG	CHAR	16
F1_TREE_NODE_ALG	SEQ_NUM	NUMBER	22
F1_TREE_NODE_ALG	TREE_CD	CHAR	120
F1_TREE_NODE_ALG	TREE_NODE_SEVT_FLG	CHAR	16
F1_TREE_NODE_ALG	VERSION	NUMBER	22
F1_TREE_NODE_L	DESCR100	VARCHAR2	400
F1_TREE_NODE_L	LANGUAGE_CD	CHAR	12
F1_TREE_NODE_L	NODE_NAME	CHAR	120
F1_TREE_NODE_L	OWNER_FLG	CHAR	16
F1_TREE_NODE_L	TREE_CD	CHAR	120
F1_TREE_NODE_L	VERSION	NUMBER	22
SC_APP_SERVICE_L	DESCRLONG	VARCHAR2	16000
SC_USER	DASHBOARD_LOC_FLG	CHAR	16
SC_USER	DASHBOARD_STATE_FLG	CHAR	16
SEC_INVENTORY	ENCRYPTED_BYTES	RAW	2000
SEC_INVENTORY	ENCRYPTION_ALG	VARCHAR2	120
SEC_INVENTORY	ENC_KEY_NAME	VARCHAR2	800
SEC_INVENTORY	SALT	RAW	2000
SEC_INVENTORY	SECRET_NAME	VARCHAR2	800
SEC_INVENTORY	VERIFICATION_HASH	RAW	2000
SEC_INVENTORY	VERIFICATION_HASH_ALG	VARCHAR2	120

Dropped Columns

Table_Name	Column_Name	From	To
CI_ALG_PARM	ALG_PARM_VAL	VARCHAR2	8000
CI_CNV_DUP_KEY	CX_ID	CHAR	56
CI_CNV_KEY_TMP	CI_ID	CHAR	56
CI_CNV_KEY_TMP	CX_ID	CHAR	56
CI_CNV_KEY_TMP	INIT_ID	VARCHAR2	56
CI_ZONE_PRM	ZONE_PARM_VAL	VARCHAR2	16000
D1_ACTIVITY_ADJ_TYPE	BUS_OBJ_CD	CHAR	120
D1_CONTACT_EMAIL	EMAIL_VALUE	VARCHAR2	280
D1_INBOUND_COMM_VW	D1_SP_ID	VARCHAR2	48
D1_INBOUND_COMM_VW	POSTAL	VARCHAR2	48
D1_OUTBOUND_COMM_VW	D1_SP_ID	VARCHAR2	48
D1_OUTBOUND_COMM_VW	POSTAL	VARCHAR2	48
F1_CRYPTO_KEY	PUBLIC_KEY	VARCHAR2	8000
F1_CRYPTO_KEY_RING_LINK	EXT_KEY_RING_CD	CHAR	120
F1_CRYPTO_KEY_RING_LINK	INT_KEY_RING_CD	CHAR	120
F1_CRYPTO_KEY_RING_LINK	VERSION	NUMBER	22
F1_PROC_PANEL	UI_MAP_CD	VARCHAR2	120