EITDR_DB_SPEC_20131216.pdf

PDF 590 KB Posted

Attached to
EITDR Reporting Environment
Solicitation number
FA8771-EITDR_Reporting_Environment
Issued by

About this file

EITDR_DB_SPEC

View the file

Other files

File Type Posted
RFI_for_Reporting_Environment(final)_(4).pdf PDF
EITDR_processes.pdf PDF
RFI_for_Reporting_Environment(final)_(3).pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

FA8771-EITDR_Reporting_Environment

EITDR DATABASE SPECIFICATION

PURPOSE

The purpose of this document is to describe the database specification for the EITDR database.

STATISTICS

The EITDR database consists of 530 tables. Those 530 tables contain a total of 7,542 columns/attributes.

The EITDR database size is 110 GB.

TABLE DEFINITIONS

TABLE A118

BEA_VERSION NUMBER NOT NULL

PICKLIST_CD NUMBER NOT NULL

PICKLIST_TXT VARCHAR2 (200 BYTE) NOT NULL

PICKLIST_TIP VARCHAR2 (4000 BYTE)

BEP_STAKEHOLDER VARCHAR2 (100 BYTE)

TABLE A118_XREF

PICKLIST_ID7 NUMBER NOT NULL

PICKLIST_ID8 NUMBER NOT NULL

TABLE A119_2

BEA_VERSION NUMBER NOT NULL

PICKLIST_ID NUMBER NOT NULL

PICKLIST_TXT VARCHAR2 (200 BYTE) NOT NULL

PICKLIST_TIP VARCHAR2 (4000 BYTE)

A119_SEQ_CD VARCHAR2 (20 BYTE)

A119_LVL_ID NUMBER

A119_PARENT_ID NUMBER

BEP_STAKEHOLDER VARCHAR2 (100 BYTE)

CBM_STAKEHOLDER VARCHAR2 (100 BYTE)

CREATOR NUMBER

CREATE_TS DATE

LAST_MOD_TS DATE

TABLE A119_XREF

PICKLIST_ID7 NUMBER NOT NULL

PICKLIST_ID8 NUMBER NOT NULL

TABLE A120

BEA_VERSION NUMBER NOT NULL

PICKLIST_CD NUMBER NOT NULL

PICKLIST_TXT VARCHAR2 (200 BYTE) NOT NULL

PICKLIST_TIP VARCHAR2 (4000 BYTE)

BEP_STAKEHOLDER VARCHAR2 (100 BYTE)

TABLE A120_XREF

PICKLIST_ID7 NUMBER NOT NULL

PICKLIST_ID8 NUMBER NOT NULL

TABLE A121

BEA_VERSION NUMBER NOT NULL

PICKLIST_CD NUMBER NOT NULL

PICKLIST_TXT VARCHAR2 (200 BYTE) NOT NULL

PICKLIST_TIP VARCHAR2 (4000 BYTE)

BEP_STAKEHOLDER VARCHAR2 (100 BYTE)

TABLE A121_XREF

PICKLIST_ID7 NUMBER NOT NULL

PICKLIST_ID8 NUMBER NOT NULL

TABLE ABIDES_IT_ONLY

HAF_MAJCOM VARCHAR2 (100 BYTE)

BIN VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (100 BYTE)

PEC_CODE VARCHAR2 (100 BYTE)

APPN VARCHAR2 (100 BYTE)

BA_CODE VARCHAR2 (100 BYTE)

BLI_CODE VARCHAR2 (100 BYTE)

PY NUMBER (20,6)

CY NUMBER (20,6)

BYP0 NUMBER (20,6)

BYP1 NUMBER (20,6)

BYP2 NUMBER (20,6)

BYP3 NUMBER (20,6)

BYP4 NUMBER (20,6)

BYP5 NUMBER (20,6)

OAC_CODE VARCHAR2 (5 BYTE)

TABLE ABIDES_IT_ONLY_BKP

HAF_MAJCOM VARCHAR2 (100 BYTE)

BIN VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (100 BYTE)

PEC_CODE VARCHAR2 (100 BYTE)

APPN VARCHAR2 (100 BYTE)

BA_CODE VARCHAR2 (100 BYTE)

BLI_CODE VARCHAR2 (100 BYTE)

PY NUMBER (20,6)

CY NUMBER (20,6)

BYP0 NUMBER (20,6)

BYP1 NUMBER (20,6)

BYP2 NUMBER (20,6)

BYP3 NUMBER (20,6)

BYP4 NUMBER (20,6)

BYP5 NUMBER (20,6)

OAC_CODE VARCHAR2 (5 BYTE)

TABLE ABIDES_IT_ONLY_NEW_VALUES

BIN VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (100 BYTE)

PEC_CODE VARCHAR2 (100 BYTE)

APPN VARCHAR2 (100 BYTE)

BA_CODE VARCHAR2 (100 BYTE)

BLI_CODE VARCHAR2 (100 BYTE)

PY NUMBER (20,3)

CY NUMBER (20,3)

BYP0 NUMBER (20,3)

BYP1 NUMBER (20,3)

BYP2 NUMBER (20,3)

BYP3 NUMBER (20,3)

BYP4 NUMBER (20,3)

BYP5 NUMBER (20,3)

OAC_CODE VARCHAR2 (100 BYTE)

TABLE AF_TOA

PEC_CODE VARCHAR2 (100 BYTE)

PEC_CODE_DESC VARCHAR2 (1000 BYTE)

TABLE ARCHIVE_ROLE_OPTIONS

ROLE_ID NUMBER NOT NULL

ALLOW_EDIT NUMBER

ALLOW_DELETE NUMBER

ALLOW_ARCHIVE NUMBER

ALLOW_LOCK NUMBER

ALLOW_SUBMIT NUMBER

ALLOW_APPROVE NUMBER

ALLOW_REVIEW NUMBER

ALLOW_REWORK NUMBER

ALLOW_REJECT NUMBER

ALLOW_REOPEN NUMBER

TABLE ASSESSMENT_DOCUMENT_APPROVERS

RECORD_ID NUMBER NOT NULL

GENERATE_ID NUMBER NOT NULL

USER_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE ASSESSMENT_DOCUMENT_SIGNERS

RECORD_ID NUMBER NOT NULL

GENERATE_ID NUMBER NOT NULL

USER_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE ASSESSMENT_RECORDS

RECORD_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

SYSTEM_NAME VARCHAR2 (100 BYTE)

VERSION_NAME VARCHAR2 (100 BYTE)

INVESTMENT_ID NUMBER

VERSION_ID NUMBER

REQUEST_TYPE VARCHAR2 (100 BYTE)

PRIORITY VARCHAR2 (100 BYTE)

TARGET_DATE_DESC VARCHAR2 (4000 BYTE)

RECORD_STATUS VARCHAR2 (100 BYTE)

ASSIGNED_TEAM VARCHAR2 (100 BYTE)

PRIMARY_AO_USER_ID NUMBER

OPENING_DATE DATE

CLOSING_DATE DATE

OVERALL_ASSESSMENT_SUMMARY VARCHAR2 (4000 BYTE)

TABLE ASSESSMENT_RECORD_COMMENTS

RECORD_ID NUMBER NOT NULL

COMMENT_ID NUMBER NOT NULL

USER_COMMENT VARCHAR2 (4000 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE ASSESSMENT_RECORD_DOCUMENTS

RECORD_ID NUMBER NOT NULL

GENERATE_ID NUMBER NOT NULL

SIGN_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

DOC_ID NUMBER

PHASE_ID NUMBER

AUTH_TERM_DATE DATE

ITERATION_ID NUMBER

DOCUMENT_DATA BLOB

MIME_TYPE VARCHAR2 (100 BYTE)

CHANGE_COMMENT VARCHAR2 (4000 BYTE)

COMMENT_CREATOR NUMBER

COMMENT_TS DATE

CAC_SIGNATURE VARCHAR2 (1000 BYTE)

CAC_SIGNATURE_TS DATE

TABLE AUTO_CALC_PCNT

BIN_NUMBER NUMBER NOT NULL

APPN_TITLE NVARCHAR2 (130) NOT NULL

BUDGET_TITLE NVARCHAR2 (50)

INVESTMENT_TITLE NVARCHAR2 (130)

PRIOR_PB_BY1 NUMBER (28,3)

CURRENT_CY NUMBER (28,3)

CURRENT_BY0 NUMBER (28,3)

HORIZONTAL_PCNT NUMBER (28)

VERTICAL_PCNT NUMBER (28)

CREATOR NUMBER NOT NULL

CREATE_TS TIMESTAMP NOT NULL

TABLE AUTO_CALC_PCNT2

BIN_NUMBER NUMBER NOT NULL

APPN_TITLE NVARCHAR2 (130) NOT NULL

BUDGET_TITLE NVARCHAR2 (50)

INVESTMENT_TITLE NVARCHAR2 (130)

PRIOR_PB_BY1 NUMBER (28,3)

CURRENT_CY NUMBER (28,3)

CURRENT_BY0 NUMBER (28,3)

HORIZONTAL_PCNT NUMBER (28)

VERTICAL_PCNT NUMBER (28)

CREATOR NVARCHAR2 (4) NOT NULL

CREATE_TS TIMESTAMP NOT NULL

TABLE AUTO_CALC_PCNT_BY_BIN

BIN_NUMBER NUMBER NOT NULL

INVESTMENT_TITLE NVARCHAR2 (127)

PRIOR_PB_BY1 NUMBER (28,5)

CURRENT_CY NUMBER (28,5)

CURRENT_BY0 NUMBER (28,5)

HORIZONTAL_PCNT NUMBER (28,10)

VERTICAL_PCNT NUMBER (28,10)

CREATOR NVARCHAR2 (4) NOT NULL

CREATE_TS TIMESTAMP NOT NULL

TABLE BEA_VERSION

BEA_VERSION VARCHAR2 (4 BYTE) NOT NULL

TABLE BIN_MAJCOM_ACRONYM_INV_DITPR

BIN VARCHAR2 (100 BYTE)

MAJCOM VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (500 BYTE)

INVESTMENT_ID VARCHAR2 (100 BYTE)

DITPR_ID VARCHAR2 (100 BYTE)

TABLE BIN_MJCM_ACRNYM_INV_DTPR_BKP

BIN VARCHAR2 (100 BYTE)

MAJCOM VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (500 BYTE)

INVESTMENT_ID VARCHAR2 (100 BYTE)

DITPR_ID VARCHAR2 (100 BYTE)

TABLE BIN_TO_INV_ID_TO_MAJCOM

INVESTMENT_ID VARCHAR2 (100 BYTE)

BIN VARCHAR2 (100 BYTE)

MAJCOM VARCHAR2 (100 BYTE)

TABLE BIN_TO_MAJCOM

BIN VARCHAR2 (100 BYTE) NOT NULL

HAF_MAJCOM VARCHAR2 (100 BYTE) NOT NULL

ACRONYM VARCHAR2 (100 BYTE) NOT NULL

TABLE BOOKMARK

BOOKMARK_ID NUMBER NOT NULL

TITLE VARCHAR2 (100 BYTE)

URL VARCHAR2 (1000 BYTE)

CATEGORY_ID NUMBER

USER_ID NUMBER

DATETIME DATE

TABLE BOOKMARK_CATEGORY

CATEGORY_ID NUMBER NOT NULL

NAME VARCHAR2 (100 BYTE)

USER_ID NUMBER

DATETIME DATE

TABLE BOS_B1_PROJECT_RESULTS

SURVEY_ID NUMBER NOT NULL

PROJECT_ID NUMBER NOT NULL

PROJECT_ID_USER_DEFINED VARCHAR2 (50 BYTE) NOT NULL

PROJECT_NAME VARCHAR2 (4000 BYTE) NOT NULL

OBJECTIVES_EXPECTED_OUTCOMES VARCHAR2 (4000 BYTE) NOT NULL

PROJECT_START_DATE_PLAN_ACTUAL DATE NOT NULL

PROJECT_COMPLETED_DATE DATE

PROJECT_LIFECYCLE_COST NUMBER (20,6) NOT NULL

PM_NAME VARCHAR2 (92 BYTE) NOT NULL

PM_LEVEL_OF_EXPERIENCE VARCHAR2 (100 BYTE) NOT NULL

PM_PHONE VARCHAR2 (10 BYTE) NOT NULL

PM_EXTENSION VARCHAR2 (5 BYTE)

PM_EMAIL VARCHAR2 (80 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

REBASELINE_REASON_LOV_CD VARCHAR2 (2 BYTE)

TABLE BOS_B2_PROJECT_ACTIVITY_RSLT

SURVEY_ID NUMBER NOT NULL

ACTIVITY_ID NUMBER NOT NULL

PROJECT_ID NUMBER NOT NULL

ACTIVITY_ID_USER_DEFINED VARCHAR2 (50 BYTE)

ACTIVITY_NAME VARCHAR2 (100 BYTE) NOT NULL

ACTIVITY_DESCRIPTION VARCHAR2 (4000 BYTE) NOT NULL

STRUCTURE_ID VARCHAR2 (100 BYTE)

KEY_DELIVERABLE_USABLE_FUNCT VARCHAR2 (4000 BYTE) NOT NULL

START_DATE_PLANNED DATE

START_DATE_PROJECTED DATE

START_DATE_ACTUAL DATE

COMPLETE_DATE_PLANNED DATE

COMPLETE_DATE_PROJECTED DATE

COMPLETE_DATE_ACTUAL DATE

TOTAL_COSTS_PLANNED NUMBER (20,6)

TOTAL_COSTS_PROJECTED NUMBER (20,6)

TOTAL_COSTS_ACTUAL NUMBER (20,6)

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_B2_PROJECT_ACTIVITY_RSLT_T

SURVEY_ID NUMBER NOT NULL

ACTIVITY_ID NUMBER NOT NULL

PROJECT_ID NUMBER NOT NULL

ACTIVITY_NAME VARCHAR2 (100 BYTE) NOT NULL

ACTIVITY_DESCRIPTION VARCHAR2 (4000 BYTE) NOT NULL

STRUCTURE_ID VARCHAR2 (100 BYTE)

KEY_DELIVERABLE_USABLE_FUNCT VARCHAR2 (4000 BYTE) NOT NULL

START_DATE_PLANNED DATE NOT NULL

START_DATE_PROJECTED_ACTUAL DATE

START_DATE_STATUS VARCHAR2 (10 BYTE)

COMPLETE_DATE_PLANNED DATE NOT NULL

COMPLETE_DATE_PROJECTED_ACTUAL DATE

COMPLETE_DATE_STATUS VARCHAR2 (10 BYTE)

TOTAL_COSTS_PLANNED NUMBER (20,6) NOT NULL

TOTAL_COSTS_PROJECTED_ACTUAL NUMBER (20,6) NOT NULL

TOTAL_COSTS_STATUS VARCHAR2 (10 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_B300B_13A_RISK_RESULTS

SURVEY_ID NUMBER NOT NULL

BOS_B300B_13A_RISK_RSLT_ID NUMBER NOT NULL

BOS_B300B_13A_USER_DEF_RISK_ID VARCHAR2 (100 BYTE)

BOS_B300B_13A_RISK_NAME VARCHAR2 (500 BYTE) NOT NULL

BOS_B300B_13A_RISK_CATEGORY VARCHAR2 (65 BYTE) NOT NULL

BOS_B300B_13A_RISK_PROBABILITY VARCHAR2 (20 BYTE) NOT NULL

BOS_B300B_13A_RISK_IMPACT VARCHAR2 (20 BYTE) NOT NULL

BOS_B300B_13A_RISK_MITIG_PLAN VARCHAR2 (500 BYTE) NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_BASELINE_CHANGE

SURVEY_ID NUMBER NOT NULL

CHANGE_ID NUMBER NOT NULL

MILESTONE VARCHAR2 (250 BYTE) NOT NULL

PERCENT_COMPLETE NUMBER (6,2) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

INIT_PLAN_COMPLETE_TS DATE

INIT_PLAN_TOTAL_COST NUMBER (21,6)

CURR_PLAN_COMPLETE_TS DATE

ACTUAL_COMPLETE_TS DATE

CURR_PLAN_TOTAL_COST NUMBER (21,6)

ACTUAL_TOTAL_COST NUMBER (21,6)

PLAN_PERCENT_COMPLETE NUMBER (6,2)

PLAN_START_TS DATE

ACTUAL_START_TS DATE

TABLE BOS_BUDGET_CHANGES

SURVEY_ID NUMBER NOT NULL

BOS_BUDGET_CHANGES_ID NUMBER NOT NULL

BOS_BUDGET_CHANGE_AMOUNT NUMBER (20,6)

BOS_BUDGET_CHANGE_REASON_CD VARCHAR2 (100 BYTE)

BOS_BUDGET_CHANGE_EXPLANATION VARCHAR2 (4000 BYTE)

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

APPN_ELEMENT_ID NUMBER

QUESTION_ID NUMBER

TABLE BOS_BUDGET_CHANGES_TEMP

SURVEY_ID NUMBER NOT NULL

BOS_BUDGET_CHANGES_ID NUMBER

BOS_BUDGET_CHANGE_AMOUNT NUMBER (20,6)

BOS_BUDGET_CHANGE_CATEGORY VARCHAR2 (70 BYTE)

BOS_BUDGET_CHANGE_EXPLANATION VARCHAR2 (4000 BYTE)

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_CERT_MILESTONES

SURVEY_ID NUMBER NOT NULL

MILESTONE_ID NUMBER NOT NULL

MILESTONE_TITLE VARCHAR2 (50 BYTE) NOT NULL

MILESTONE_DESC VARCHAR2 (2000 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

ACHIEVEMENT_DATE DATE

REVISED_FINISH_DATE DATE

MILESTONE_STATUS VARCHAR2 (100 BYTE)

EXPLANATION VARCHAR2 (4000 BYTE)

TABLE BOS_CLOUD_SPEND_RESULTS

SURVEY_ID NUMBER NOT NULL

CY_BASIS NUMBER (4) NOT NULL

PUBLIC_CLOUD_PREV_YR NUMBER (20,6) NOT NULL

PUBLIC_CLOUD_CURR_YR NUMBER (20,6) NOT NULL

PUBLIC_CLOUD_BDGT_YR NUMBER (20,6) NOT NULL

PRIVATE_CLOUD_PREV_YR NUMBER (20,6) NOT NULL

PRIVATE_CLOUD_CURR_YR NUMBER (20,6) NOT NULL

PRIVATE_CLOUD_BDGT_YR NUMBER (20,6) NOT NULL

COMMUNITY_CLOUD_PREV_YR NUMBER (20,6) NOT NULL

COMMUNITY_CLOUD_CURR_YR NUMBER (20,6) NOT NULL

COMMUNITY_CLOUD_BDGT_YR NUMBER (20,6) NOT NULL

HYBRID_CLOUD_PREV_YR NUMBER (20,6) NOT NULL

HYBRID_CLOUD_CURR_YR NUMBER (20,6) NOT NULL

HYBRID_CLOUD_BDGT_YR NUMBER (20,6) NOT NULL

SAAS_CLOUD_PREV_YR NUMBER (20,6) NOT NULL

SAAS_CLOUD_CURR_YR NUMBER (20,6) NOT NULL

SAAS_CLOUD_BDGT_YR NUMBER (20,6) NOT NULL

PAAS_CLOUD_PREV_YR NUMBER (20,6) NOT NULL

PAAS_CLOUD_CURR_YR NUMBER (20,6) NOT NULL

PAAS_CLOUD_BDGT_YR NUMBER (20,6) NOT NULL

IAAS_CLOUD_PREV_YR NUMBER (20,6) NOT NULL

IAAS_CLOUD_CURR_YR NUMBER (20,6) NOT NULL

IAAS_CLOUD_BDGT_YR NUMBER (20,6) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_COMPONENT_USAGE

SURVEY_ID NUMBER NOT NULL

COMP_ID NUMBER NOT NULL

COMPONENT_CODE VARCHAR2 (2 BYTE) NOT NULL

COMPONENT_TYPE_CODE CHAR (1 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

COMPONENT_STATUS_CD CHAR (1 BYTE)

EFFECTIVE_DATE DATE

TABLE BOS_CONTRACTS

SURVEY_ID NUMBER NOT NULL

CONTRACT_ID NUMBER NOT NULL

CONTRACT_TASK_ORDER_ID VARCHAR2 (250 BYTE) NOT NULL

CONTRACT_TYPE_USED VARCHAR2 (250 BYTE)

CONTRACT_TOTAL_VALUE NUMBER (21,6) NOT NULL

PERF_BASED_CONTRACT VARCHAR2 (3 BYTE) NOT NULL

EVM_REQUIRED VARCHAR2 (3 BYTE) NOT NULL

INFO_NAME VARCHAR2 (250 BYTE)

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

CONTRACT_START_DATE DATE

CONTRACT_END_DATE DATE

CONTRACT_ID2 VARCHAR2 (50 BYTE)

INFO_CITY VARCHAR2 (250 BYTE)

INFO_STATE VARCHAR2 (2 BYTE)

INFO_SUPPORTED_FUNC VARCHAR2 (250 BYTE)

CONTRACT_STATUS VARCHAR2 (250 BYTE)

PIID VARCHAR2 (50 BYTE)

IDV VARCHAR2 (50 BYTE)

SOLICITATION_ID VARCHAR2 (25 BYTE)

EXTENT_COMPETED VARCHAR2 (250 BYTE)

ACQUISITION_DESCR VARCHAR2 (2000 BYTE)

MODULAR_CONTRACTING VARCHAR2 (3 BYTE)

TABLE BOS_DATA_CENTER_SPEND_RESULTS

SURVEY_ID NUMBER NOT NULL

BOS_DATA_CNTR_SPND_RSLT_ID NUMBER NOT NULL

FACILITY_ID VARCHAR2 (4 BYTE) NOT NULL

BOS_DATA_CNTR_SPND_APPN VARCHAR2 (15 BYTE) NOT NULL

CY_BASIS NUMBER (4) NOT NULL

DATA_CNT_APPNCOST_CY_MINUS2 NUMBER (20,6) NOT NULL

DATA_CNT_APPNCOST_CY_MINUS1 NUMBER (20,6) NOT NULL

DATA_CNT_APPNCOST_CY NUMBER (20,6) NOT NULL

DATA_CNT_APPNCOST_CY_PLUS1 NUMBER (20,6) NOT NULL

DATA_CNT_APPNCOST_CY_PLUS2 NUMBER (20,6) NOT NULL

DATA_CNT_APPNCOST_CY_PLUS3 NUMBER (20,6) NOT NULL

DATA_CNT_APPNCOST_CY_PLUS4 NUMBER (20,6) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_DIACAP_POAM

SURVEY_ID NUMBER NOT NULL

WEAKNESS_ID NUMBER NOT NULL

WEAKNESS_DESC VARCHAR2 (4000 BYTE) NOT NULL

CONTROL_ID NUMBER NOT NULL

CAT_CODE VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

POC VARCHAR2 (4000 BYTE)

RESOURCES_REQUIRED VARCHAR2 (4000 BYTE)

COMPLETE_BY_TS DATE

MILESTONES_COMPLETION_DATES VARCHAR2 (4000 BYTE)

MILESTONE_CHANGES VARCHAR2 (4000 BYTE)

SOURCE_IDENTIFY_WEAKNESS VARCHAR2 (4000 BYTE)

STATUS_CODE VARCHAR2 (20 BYTE)

STATUS_DATE DATE

GENERAL_COMMENTS VARCHAR2 (4000 BYTE)

TABLE BOS_DIACAP_POAM_HEADER

SURVEY_ID NUMBER NOT NULL

INITIATION_TS DATE

POC_NAME VARCHAR2 (100 BYTE)

POC_PHONE VARCHAR2 (100 BYTE)

POC_EMAIL VARCHAR2 (100 BYTE)

SECURITY_COSTS NUMBER (20,6)

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

TABLE BOS_FEA_SRM

SURVEY_ID NUMBER NOT NULL

SRM_ID NUMBER NOT NULL

AGENCY_COMPONENT VARCHAR2 (250 BYTE) NOT NULL

AGENCY_COMPONENT_DESC VARCHAR2 (500 BYTE) NOT NULL

SRM_SERVICE_TYPE VARCHAR2 (100 BYTE) NOT NULL

SRM_COMPONENT VARCHAR2 (100 BYTE) NOT NULL

INTERNAL_EXTERNAL VARCHAR2 (10 BYTE) NOT NULL

FUNDING_PCT NUMBER (3) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

REUSED_COMPONENT_NAME VARCHAR2 (100 BYTE)

REUSED_COMPONENT_UPI VARCHAR2 (40 BYTE)

TABLE BOS_FEA_TRM

SURVEY_ID NUMBER NOT NULL

TRM_ID NUMBER NOT NULL

SRM_COMPONENT VARCHAR2 (100 BYTE) NOT NULL

SERVICE_AREA VARCHAR2 (100 BYTE) NOT NULL

SERVICE_CATEGORY VARCHAR2 (100 BYTE) NOT NULL

SERVICE_STANDARD VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

SERVICE_SPEC VARCHAR2 (250 BYTE)

TABLE BOS_FUNDING_PCT

SURVEY_ID NUMBER NOT NULL

HARDWARE_PCT NUMBER (3) NOT NULL

SOFTWARE_PCT NUMBER (3) NOT NULL

SERVICES_PCT NUMBER (3) NOT NULL

OTHER_PCT NUMBER (3) NOT NULL

IA_PCT NUMBER (3) NOT NULL

FN_PCT NUMBER (3) NOT NULL

BE_PCT NUMBER (3) NOT NULL

BF_PCT NUMBER (3) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

IPV6_PCT NUMBER (3) NOT NULL

HSPD_12_PCT NUMBER (3) NOT NULL

IA_CY_PCT NUMBER (3)

TABLE BOS_IA_ATTACHMENTS

SURVEY_ID NUMBER NOT NULL

CONTROL_ID NUMBER NOT NULL

ATTACH_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

DISPLAY_ORDER NUMBER

OBJECT_ID NUMBER

URL_REFERENCE VARCHAR2 (4000 BYTE)

ATTACH_DESC VARCHAR2 (4000 BYTE)

TABLE BOS_IA_RESULTS

SURVEY_ID NUMBER NOT NULL

CONTROL_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

COMPLIANCE_IND NUMBER

COMPLIANCE_LAST_MOD_TS DATE

INHERITED_IND NUMBER

IMPLEMENTED_IND NUMBER

PLANNED_IND NUMBER

RESPONSIBLE_ENTITIES VARCHAR2 (4000 BYTE)

RESOURCES VARCHAR2 (4000 BYTE)

ESTIMATED_COMPLETION_TS DATE

IA_CONTROL_RESPONSE VARCHAR2 (4000 BYTE)

NOT_APPLICABLE_IND NUMBER

CHANGE_ORIG_PLAN_IND NUMBER

REACCREDITATION_IND NUMBER

INHERITED_FROM_DETAILS VARCHAR2 (1000 BYTE)

TABLE BOS_IA_REVIEWS

SURVEY_ID NUMBER NOT NULL

CONTROL_ID NUMBER NOT NULL

REVIEW_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

REVIEW_DUE_TS DATE

PERFORMED_TS DATE

REVIEW_METHOD VARCHAR2 (100 BYTE)

REVIEW_RESULTS VARCHAR2 (4000 BYTE)

TABLE BOS_IA_VAL_RESULTS

SURVEY_ID NUMBER NOT NULL

CONTROL_ID NUMBER NOT NULL

PROCEDURE_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

RECORD_TS DATE NOT NULL

VAL_PROCEDURE_RESULTS VARCHAR2 (4000 BYTE)

TABLE BOS_INVESTMENT_URL_RESULTS

SURVEY_ID NUMBER NOT NULL

URL_ID NUMBER NOT NULL

URL VARCHAR2 (4000 BYTE) NOT NULL

PUBLIC_DATASET_FLAG NUMBER

PUBLIC_API_FLAG NUMBER

SOCIAL_MEDIA_FLAG NUMBER

PROVIDES_GENERAL_INFO_FLAG NUMBER

PROVIDES_GNRL_BIZ_PROCESS_FLAG NUMBER

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_INV_MANDATE_SRC_RESULTS

SURVEY_ID NUMBER NOT NULL

LEGISLATIV_MANDATE_REQD_YN VARCHAR2 (3 BYTE) NOT NULL

LEGISLATIV_MANDATE_DESCR VARCHAR2 (4000 BYTE)

LEGISLATIV_MANDATE_URLS_PRM VARCHAR2 (4000 BYTE)

OUTST_AUDIT_FINDG_REQD_YN VARCHAR2 (3 BYTE) NOT NULL

OUTST_AUDIT_FINDG_DESCR VARCHAR2 (4000 BYTE)

OUTST_AUDIT_FINDG_URLS_PRM VARCHAR2 (4000 BYTE)

ANNUAL_PERF_PLAN_REQD_YN VARCHAR2 (3 BYTE) NOT NULL

ANNUAL_PERF_PLAN_DESCR VARCHAR2 (4000 BYTE)

ANNUAL_PERF_PLAN_URLS_PRMS VARCHAR2 (4000 BYTE)

PRESIDENTL_DIRECT_REQD_YN VARCHAR2 (3 BYTE) NOT NULL

PRESIDENTL_DIRECT_DESCR VARCHAR2 (4000 BYTE)

PRESIDENTL_DIRECT_URLS_PRM VARCHAR2 (4000 BYTE)

OTHER_REQUIREMENT_REQD_YN VARCHAR2 (3 BYTE) NOT NULL

OTHER_REQUIREMENT_DESCR VARCHAR2 (4000 BYTE)

OTHER_REQUIREMENT_URLS_PRM VARCHAR2 (4000 BYTE)

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_JIE_FUNDING

SURVEY_ID NUMBER NOT NULL

BOS_JIE_FUNDING_ID NUMBER NOT NULL

JIE_INCREMENT VARCHAR2 (100 BYTE) NOT NULL

JIE_CAPABILITY VARCHAR2 (100 BYTE) NOT NULL

PEC_CODE VARCHAR2 (100 BYTE) NOT NULL

ELEMENT_CD VARCHAR2 (100 BYTE) NOT NULL

PY_AMOUNT NUMBER (20,6)

CY_AMOUNT NUMBER (20,6)

BY_AMOUNT NUMBER (20,6)

BYPLUS1_AMOUNT NUMBER (20,6)

BYPLUS2_AMOUNT NUMBER (20,6)

BYPLUS3_AMOUNT NUMBER (20,6)

BYPLUS4_AMOUNT NUMBER (20,6)

CREATOR NUMBER NOT NULL

CREATE_TS DATE DEFAULT SYSDATE NOT NULL

LAST_MOD_TS DATE DEFAULT SYSDATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_JOINT_INIT

SURVEY_ID NUMBER NOT NULL

JOINT_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

INIT_NUM VARCHAR2 (4 BYTE)

INIT_TITLE VARCHAR2 (100 BYTE)

INVESTMENT_REF_ID NUMBER

TABLE BOS_OPERATIONAL_RISK_RSLT

SURVEY_ID NUMBER NOT NULL

BOS_OPER_RISK_RSLT_ID NUMBER NOT NULL

BOS_OPER_RISK_NAME VARCHAR2 (500 BYTE) NOT NULL

BOS_OPER_RISK_CATEGORY VARCHAR2 (65 BYTE) NOT NULL

BOS_OPER_RISK_PROBABILITY VARCHAR2 (20 BYTE) NOT NULL

BOS_OPER_RISK_IMPACT VARCHAR2 (20 BYTE) NOT NULL

BOS_OPER_RISK_MITIGATION_PLAN VARCHAR2 (500 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

BOS_OPER_PROJECT_ID NUMBER

BOS_OPER_USER_DEFINED_RISK_ID VARCHAR2 (100 BYTE)

TABLE BOS_POAM

SURVEY_ID NUMBER NOT NULL

POAM_ID NUMBER NOT NULL

WEAKNESSES VARCHAR2 (4000 BYTE) NOT NULL

POC_INFO VARCHAR2 (100 BYTE) NOT NULL

RESOURCES_REQ VARCHAR2 (4000 BYTE) NOT NULL

SCHEDULED_COMP_TS DATE NOT NULL

MILESTONES VARCHAR2 (4000 BYTE) NOT NULL

AUDIT_REVIEW_INFO VARCHAR2 (4000 BYTE) NOT NULL

STATUS_INFO VARCHAR2 (4000 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

MILESTONE_CHANGES VARCHAR2 (4000 BYTE)

TABLE BOS_POAM_HEADER

SURVEY_ID NUMBER NOT NULL

COMP_NAME VARCHAR2 (100 BYTE) NOT NULL

POC_NAME VARCHAR2 (100 BYTE) NOT NULL

POC_PHONE VARCHAR2 (100 BYTE) NOT NULL

POC_EMAIL VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

TABLE BOS_PROGRAM_HL

SURVEY_ID NUMBER NOT NULL

HL_ID NUMBER NOT NULL

FISCAL_YR NUMBER (4) NOT NULL

HL_STATUS VARCHAR2 (100 BYTE) NOT NULL

HIGHLIGHT VARCHAR2 (4000 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

TABLE BOS_QUANTITATIVE_BENEFITS

SURVEY_ID NUMBER NOT NULL

BENEFIT_ID NUMBER NOT NULL

BENEFIT_YEAR VARCHAR2 (100 BYTE) NOT NULL

BUDGETED_COST_SAVINGS NUMBER (21,6) NOT NULL

COST_AVOIDANCE NUMBER (21,6) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

JUSTIFY_COST_SAVINGS VARCHAR2 (500 BYTE)

JUSTIFY_COST_AVOID VARCHAR2 (500 BYTE)

TABLE BOS_RISK_METRIC_RESULTS

SURVEY_ID NUMBER NOT NULL

BOS_RISK_M_RESULTS_ID NUMBER NOT NULL

USER_DEFINED_METRIC_ID VARCHAR2 (11 BYTE)

BOS_RISK_M_DESCRIPTION VARCHAR2 (4000 BYTE) NOT NULL

BOS_RISK_M_UNIT_OF_MEASURE VARCHAR2 (50 BYTE) NOT NULL

FEA_PRM_CATEGORY VARCHAR2 (2000 BYTE)

PREV_YEAR_TARGET NUMBER (20,6) NOT NULL

CURR_YEAR_TARGET NUMBER (20,6) NOT NULL

MEASUREMENT_CONDITION VARCHAR2 (20 BYTE) NOT NULL

REPORTING_FREQUENCY VARCHAR2 (20 BYTE) NOT NULL

CY_BASIS NUMBER (4) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_SECONDARY_SERVICES

SURVEY_ID NUMBER NOT NULL

BOS_SECONDARY_SERVICES_ID NUMBER NOT NULL

BRM_SERVICE_LOOKUP_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE DEFAULT SYSDATE NOT NULL

LAST_MOD_TS DATE DEFAULT SYSDATE NOT NULL

TABLE BOS_SPEND_SUMMARY_FTE_RPTG

SURVEY_ID NUMBER NOT NULL

BOS_SPEND_SUMM_FTE_RPTG_ID NUMBER NOT NULL

PEC VARCHAR2 (100 BYTE) NOT NULL

APPN VARCHAR2 (100 BYTE) NOT NULL

CURRENT_YEAR NUMBER (20,6) NOT NULL

BUDGET_YEAR NUMBER (20,6) NOT NULL

BUDGET_YEAR_PLUS_1 NUMBER (20,6) NOT NULL

BUDGET_YEAR_PLUS_2 NUMBER (20,6) NOT NULL

BUDGET_YEAR_PLUS_3 NUMBER (20,6) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BOS_SYSMOD_DECOM

SURVEY_ID NUMBER NOT NULL

SYSMOD_ID NUMBER NOT NULL

ACRONYM VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

UNIQUE_ID VARCHAR2 (100 BYTE)

SUNSET_DATE DATE

SYSMOD_ELIMINATED VARCHAR2 (4000 BYTE)

ENABLING_EVENT VARCHAR2 (4000 BYTE)

ACTUAL_SUNSET_DATE DATE

ESTIMATED_SAVINGS NUMBER (20,6)

ACTUAL_SAVINGS NUMBER (20,6)

INVESTMENT_REF_ID NUMBER

MIGRATION_STATUS VARCHAR2 (7 BYTE)

PARTIAL_COMMENTS VARCHAR2 (2000 BYTE)

TABLE BRM_HIERARCHY

BRM_HIERARCHY_ID NUMBER NOT NULL

SEGMENT_CODE VARCHAR2 (12 BYTE) NOT NULL

BRM_SECTOR_LOOKUP_ID NUMBER NOT NULL

BRM_SECTOR_DESCRIPTION VARCHAR2 (80 BYTE) NOT NULL

BRM_FUNCTION_LOOKUP_ID NUMBER NOT NULL

BRM_FUNCTION_DESCRIPTION VARCHAR2 (80 BYTE) NOT NULL

BRM_SERVICE_LOOKUP_ID NUMBER NOT NULL

BRM_SERVICE_DESCRIPTION VARCHAR2 (80 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE DEFAULT SYSDATE NOT NULL

LAST_MOD_TS DATE DEFAULT SYSDATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE BRM_LOAD_SOURCE_DATA

INVESTMENT_ID VARCHAR2 (10 BYTE) NOT NULL

SERVICE_CODE VARCHAR2 (20 BYTE) NOT NULL

TABLE BRM_LOAD_SOURCE_DATA2

INVESTMENT_ID VARCHAR2 (10 BYTE) NOT NULL

SERVICE_CODE VARCHAR2 (20 BYTE) NOT NULL

TABLE BUDGET_COST_FACTORS

COST_FACTOR_ID NUMBER NOT NULL

CYCLE_ID NUMBER

FTE_TYPE VARCHAR2 (50 BYTE)

CY_AMOUNT NUMBER

BY_AMOUNT NUMBER

BYPLUS1_AMOUNT NUMBER

BYPLUS2_AMOUNT NUMBER

BYPLUS3_AMOUNT NUMBER

BYPLUS4_AMOUNT NUMBER

BYPLUS5_AMOUNT NUMBER

CREATOR NUMBER

CREATE_TS DATE

LAST_MOD_TS DATE

PY_AMOUNT NUMBER

TABLE BUDGET_COST_FACTORS_TMP

COST_FACTOR_ID NUMBER

CYCLE_ID NUMBER

FTE_TYPE VARCHAR2 (50 BYTE)

CY_AMOUNT NUMBER

BY_AMOUNT NUMBER

BYPLUS1_AMOUNT NUMBER

BYPLUS2_AMOUNT NUMBER

BYPLUS3_AMOUNT NUMBER

BYPLUS4_AMOUNT NUMBER

BYPLUS5_AMOUNT NUMBER

CREATOR NUMBER

CREATE_TS DATE

LAST_MOD_TS DATE

PY_AMOUNT NUMBER

PY_AMOUNT_TMP NUMBER

TABLE BUDGET_CYCLE

CYCLE_ID NUMBER NOT NULL

MASTER_ID NUMBER NOT NULL

CYCLE_NAME VARCHAR2 (100 BYTE) NOT NULL

CY_BASIS NUMBER (4) NOT NULL

GENERAL_START_TS DATE NOT NULL

GENERAL_END_TS DATE NOT NULL

RESOURCE_START_TS DATE NOT NULL

RESOURCE_END_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

CYCLE_DESC VARCHAR2 (4000 BYTE)

UPI_FORMAT NUMBER

REGISTER_PERIOD NUMBER (3)

TABLE BUDGET_CYCLE_XREF

SURVEY_ID_PRIOR_BC NUMBER

SURVEY_ID_CURRENT_BC NUMBER

CREATOR NUMBER

CREATE_TS DATE

LAST_MOD_TS DATE

TABLE BUDGET_ORG_EXTENSIONS

ORG_ID NUMBER NOT NULL

CYCLE_ID NUMBER NOT NULL

GENERAL_START_TS DATE NOT NULL

GENERAL_END_TS DATE NOT NULL

RESOURCE_START_TS DATE NOT NULL

RESOURCE_END_TS DATE NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

EXTENSION_COMMENT VARCHAR2 (4000 BYTE)

TABLE BUDGET_ORG_LOCKS

ORG_ID NUMBER NOT NULL

CYCLE_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

LOCK_COMMENT VARCHAR2 (4000 BYTE)

TABLE BUDGET_SURVEY_EXTENSIONS

SURVEY_ID NUMBER NOT NULL

CYCLE_ID NUMBER NOT NULL

GENERAL_START_TS DATE NOT NULL

GENERAL_END_TS DATE NOT NULL

RESOURCE_START_TS DATE NOT NULL

RESOURCE_END_TS DATE NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

EXTENSION_COMMENT VARCHAR2 (4000 BYTE)

TABLE CACHE_GIG_IT_DDI

GIG_CATEGORY VARCHAR2 (200 BYTE) NOT NULL

EITDR_RESULT VARCHAR2 (4000 BYTE) NOT NULL

IT_OR_NSS VARCHAR2 (3 BYTE) NOT NULL

GIG_CD_L1 VARCHAR2 (80 BYTE)

GIG_CD_L2 VARCHAR2 (80 BYTE)

ITEM_ID NUMBER

LAST_REFRESH_TS DATE

TABLE CACHE_INVESTMENT_QUERY_TREE

TREE_TYPE VARCHAR2 (100 BYTE)

ORG_ID NUMBER

ORG_CD VARCHAR2 (100 BYTE)

ORG_NAME VARCHAR2 (100 BYTE)

CATEGORY VARCHAR2 (100 BYTE)

INVESTMENT_ID NUMBER

INVESTMENT_NAME VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (100 BYTE)

INVESTMENT_TYPE NUMBER

REGISTRY_ID VARCHAR2 (100 BYTE)

PARENT_ID NUMBER

PARENT_ACRONYM VARCHAR2 (100 BYTE)

PARENT_NAME VARCHAR2 (100 BYTE)

PARENT_REGISTRY_ID VARCHAR2 (100 BYTE)

CREATOR NUMBER

CREATOR_NAME VARCHAR2 (100 BYTE)

CREATE_TS DATE

LAST_MOD_TS DATE

CROSS_FUNC_ID NUMBER

PRIV_MASK NUMBER

PARENT_PRIV_MASK NUMBER

PRIMARY_IND NUMBER

INVESTMENT_STATUS VARCHAR2 (100 BYTE)

INVESTMENT_STATUS_IND NUMBER

RESOURCE_MOD_TS DATE

SPENDSUM_MOD_TS DATE

COMMENT_MOD_TS DATE

FISMA_EXTRACT_TS DATE

CTT_EXTRACT_TS DATE

OMB_EXTRACT_TS DATE

NEW_COMMENTS NUMBER

BIN VARCHAR2 (100 BYTE)

INVESTMENT_CRC NUMBER

INVESTMENT_NAME_CRC NUMBER

ACRONYM_CRC NUMBER

INVESTMENT_TYPE_CRC NUMBER

INVESTMENT_STATUS_CRC NUMBER

PARENT_ID_CRC NUMBER

INVESTMENT_ORG_CRC NUMBER

PRIMARY_ORG_CRC NUMBER

DITPR_ID NUMBER

WATCH_IND NUMBER

SURVEY_ID NUMBER

REGISTER_PERIOD NUMBER

DAYS_REMAIN NUMBER

PCT_REG_COMPLETE NUMBER

CREATED_TS DATE DEFAULT sysdate

TABLE CFO_AC1_VOLUMES

SURVEY_ID NUMBER

CFO_AC1_VOLUMES_ID NUMBER NOT NULL

DFAS_BLUEBOOK_VOLUME VARCHAR2 (100 BYTE)

DATE_LAST_TESTED DATE

TESTING_ORGANIZATION VARCHAR2 (100 BYTE)

TEST_RESULTS_URL VARCHAR2 (1024 BYTE)

CORRECTIVE_ACTIONS_IDENT_YN VARCHAR2 (1 BYTE)

CORRECTIVE_ACTION_PLAN_URL VARCHAR2 (1024 BYTE)

CREATOR NUMBER NOT NULL

CREATE_TS DATE DEFAULT SYSDATE NOT NULL

LAST_MOD_TS DATE DEFAULT SYSDATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE CHRISTOPHER

PARAMETER VARCHAR2 (20 BYTE)

EXCEPTION VARCHAR2 (20 BYTE)

TABLE CLUSTER_MEMBER_ARCHIVE

SURVEY_ID NUMBER NOT NULL

CLUSTER_ID NUMBER NOT NULL

INVESTMENT_ID NUMBER NOT NULL

CLUSTER_NAME VARCHAR2 (100 BYTE) NOT NULL

CLUSTER_CREATOR NUMBER

CLUSTER_CREATE_TS DATE

CLUSTER_LAST_MOD_TS DATE

PRIMARY_IND NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

RECORD_TS DATE NOT NULL

TABLE CNA_ASSESSMENT_REC_MIGRATED

INVESTMENT_ID NUMBER NOT NULL

VERSION_ID NUMBER NOT NULL

RELEASE_LABEL VARCHAR2 (100 BYTE)

REC_ID NUMBER NOT NULL

CA_VERSION_ID NUMBER NOT NULL

RECORD_TS DATE NOT NULL

TABLE CNA_COMMENTS_MIGRATED

INVESTMENT_ID NUMBER NOT NULL

SURVEY_ID NUMBER

CA_SURVEY_ID NUMBER

QUESTION_ID NUMBER

COMMENT_ID NUMBER NOT NULL

RECORD_TS DATE NOT NULL

TABLE CNA_VERSION_MIGRATED

INVESTMENT_ID NUMBER NOT NULL

ACRONYM VARCHAR2 (400 BYTE)

VERSION_ID NUMBER NOT NULL

RELEASE_LABEL VARCHAR2 (100 BYTE)

PHASE_ID NUMBER

SURVEY_ID NUMBER NOT NULL

CA_VERSION_ID NUMBER NOT NULL

CA_SURVEY_ID NUMBER NOT NULL

CA_ACTIVITY_ID NUMBER

RECORD_TS DATE NOT NULL

STATUS_IND NUMBER

VERSION_TYPE_ID NUMBER

POAM_FIXED NUMBER

SHADOW_TABLE_FIXED NUMBER

RESULT_SET_FIXED NUMBER

CA_VERSION_TYPE_ID NUMBER

SURVEY_INSTANCE_QUEST_FIXED NUMBER

TABLE COMPLIANCE_EVALUATION

SURVEY_ID NUMBER NOT NULL

QUESTION_ID NUMBER NOT NULL

ITEM_ID NUMBER NOT NULL

TABLE CONFIG_VAL

KEY VARCHAR2 (100 BYTE) NOT NULL

VALUE VARCHAR2 (4000 BYTE) NOT NULL

TABLE CONTACTS

CONTACT_ID NUMBER NOT NULL

LAST_NM VARCHAR2 (30 BYTE) NOT NULL

FIRST_NM VARCHAR2 (30 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

MIDDLE_NM VARCHAR2 (30 BYTE)

EMAIL VARCHAR2 (80 BYTE)

TITLE VARCHAR2 (100 BYTE)

PHONE VARCHAR2 (30 BYTE)

ADDRESS VARCHAR2 (50 BYTE)

CITY VARCHAR2 (30 BYTE)

LOCALE VARCHAR2 (30 BYTE)

COUNTRY VARCHAR2 (60 BYTE)

POSTAL_CD VARCHAR2 (15 BYTE)

DSN VARCHAR2 (30 BYTE)

RANK_ID NUMBER NOT NULL

TABLE CURSOR_RESULT

A1 VARCHAR2 (2000 BYTE)

A2 VARCHAR2 (2000 BYTE)

A3 VARCHAR2 (2000 BYTE)

TABLE DBG_RESULT

A1 VARCHAR2 (2000 BYTE)

A2 VARCHAR2 (2000 BYTE)

A3 VARCHAR2 (2000 BYTE)

A4 VARCHAR2 (2000 BYTE)

A5 VARCHAR2 (2000 BYTE)

A6 VARCHAR2 (2000 BYTE)

A7 VARCHAR2 (2000 BYTE)

A8 VARCHAR2 (2000 BYTE)

TABLE DEBUG_HELPER

TIME_STAMP DATE

USER_DATA VARCHAR2 (4000 BYTE)

USER_KEY VARCHAR2 (4000 BYTE)

TABLE DITPRREF_BUDGET_CYCLE

BBC_ID NUMBER

BBC_CD VARCHAR2 (12 CHAR)

BBC_TITLE VARCHAR2 (100 CHAR)

BBC_YEAR VARCHAR2 (4 CHAR)

BBC_START_DT DATE

BBC_END_DT DATE

BBC_ORD_ID NUMBER

BBC_STATUS NUMBER

BAPPN_TYP_ID NUMBER

TABLE DITPRREF_BUDGET_LINE_ITEM

BBLI_ID NUMBER

BBC_ID NUMBER

BBA_ID NUMBER

BBLI_CD VARCHAR2 (50 CHAR)

BBLI_TITLE VARCHAR2 (100 CHAR)

TABLE DITPRREF_PROGRAM_ELEMENT

BPE_ID NUMBER

BBC_ID NUMBER

BPE_CD VARCHAR2 (12 CHAR)

BPE_TITLE VARCHAR2 (100 CHAR)

BPE_DEF VARCHAR2 (25 CHAR)

TABLE DITPR_DOMAIN

DOMAIN_ID NUMBER

APPLIC_ID NUMBER

DOMAIN_ROLE VARCHAR2 (25 BYTE)

SYSD_EDTD_DT DATE

TABLE DITPR_FISMA

APPLIC_ID NUMBER

ACCRED_STATUS VARCHAR2 (10 BYTE)

ACCRED_DATE DATE

ACCRED_VEHICLE VARCHAR2 (10 BYTE)

ACCRED_REQ_CD VARCHAR2 (3 BYTE)

ACCRED_EXPLANATION VARCHAR2 (50 BYTE)

ACCRED_EXPIRE_DT DATE

COOPTEST DATE

ACCESS_CONTROL VARCHAR2 (10 BYTE)

IFSMI_POAM_REQ VARCHAR2 (3 BYTE)

SECURITY_CONTROLS_EXERCISE DATE

IFSMI_POAM_SUB_DT DATE

IFSMI_CONFIDNTLY VARCHAR2 (10 BYTE)

IFSMI_ANSECRVW_DT DATE

IFSMI_EDTD_DT DATE

ADMIN_CONTROL VARCHAR2 (10 BYTE)

TABLE DITPR_LIFE_CYCLE

SYSLCP_ID NUMBER

LIFECYCLE_ID NUMBER

APPLIC_ID NUMBER

SYSLCP_START_DT VARCHAR2 (8 BYTE)

SYSLCP_END_DT VARCHAR2 (8 BYTE)

SYSLCP_EDTD_DT DATE

SYSLCP_CD VARCHAR2 (10 BYTE)

SYSLCP_CMTS BLOB

TABLE DITPR_NDAA_CERT_DATE

BATCH_CERT_GENERATION_DATE DATE

CERTIFICATION_FISCAL_YEAR NUMBER (4)

ACTUAL_BATCH_RUN_DATE DATE

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

TABLE DITPR_POC

VAL_POC_CODE VARCHAR2 (8 BYTE)

VAL_LAST_NAME VARCHAR2 (30 BYTE)

VAL_FIRST_NAME VARCHAR2 (30 BYTE)

VAL_TITLE VARCHAR2 (10 BYTE)

VAL_COM_PHONE_NBR VARCHAR2 (18 BYTE)

VAL_DSN_PHONE_NBR VARCHAR2 (18 BYTE)

VAL_FAX_NBR VARCHAR2 (18 BYTE)

VAL_EMAIL VARCHAR2 (50 BYTE)

UPDATED_DATE DATE

TABLE DITPR_POC_ORG

ORG_CODE VARCHAR2 (8 BYTE)

COMP_CODE VARCHAR2 (2 BYTE)

ORG_NAME VARCHAR2 (45 BYTE)

ITORG_UPDTD_DT DATE

TABLE DITPR_SYSTEM

APPLIC_ID NUMBER

BCMPNT_CD VARCHAR2 (2 BYTE)

APPLIC_NAME VARCHAR2 (200 BYTE)

ACRONYM VARCHAR2 (50 BYTE)

BIN VARCHAR2 (20 BYTE)

DOD_REG_ID VARCHAR2 (10 BYTE)

TYPE_OF_NSS VARCHAR2 (30 BYTE)

SYS_DESC VARCHAR2 (4000 BYTE)

UPDATED_DATE DATE

SYS_GEN_CMTS VARCHAR2 (4000 BYTE)

UPDATE_FLAG VARCHAR2 (1 BYTE)

ISYS_PARENT_ID NUMBER

ISYS_ARCHIVE_PRS_NM VARCHAR2 (80 BYTE)

ACAT_CODE VARCHAR2 (20 BYTE)

MISSION_CRITICAL VARCHAR2 (3 BYTE)

MAC_CD VARCHAR2 (25 BYTE)

INT_WITH_SYSTEMS_IND VARCHAR2 (5 BYTE)

CONT_PLAN_IN_PLACE VARCHAR2 (5 BYTE)

SUB_ORG VARCHAR2 (15 BYTE)

RECORD_ADD_DT DATE

REC_TYPE VARCHAR2 (64 BYTE)

TABLE DITPR_SYS_EAUTH

APPLIC_ID NUMBER

EAUTH_PUB_ACCESS VARCHAR2 (1 BYTE)

EAUTH_NTPUB_EXPLN VARCHAR2 (1 BYTE)

EAUTH_AUTH_RQD VARCHAR2 (9 BYTE)

EAUTH_RSK_ASESMT VARCHAR2 (1 BYTE)

EAUTH_RSK_ASMT_DT DATE

EAUTH_AUTH_MTHD VARCHAR2 (1 BYTE)

EAUTH_ASUR_LVL NUMBER

EAUTH_PK_ENABLED NUMBER

EAUTH_PKEN_DT DATE

EAUTH_EDTD_DT DATE

EAUTH_SYS_URL VARCHAR2 (60 BYTE)

EAUTH_BRWSR_BSD VARCHAR2 (1 BYTE)

EAUTH_PCNT_L1 VARCHAR2 (1 BYTE)

EAUTH_PCNT_L3 VARCHAR2 (1 BYTE)

EAUTH_TECH_PRVDR VARCHAR2 (1 BYTE)

EAUTH_OTH_CG VARCHAR2 (250 BYTE)

EAUTH_MBR_STS VARCHAR2 (1 BYTE)

EAUTH_MILESTONE VARCHAR2 (1 BYTE)

EAUTH_EXP_EAUTH VARCHAR2 (4 BYTE)

EAUTH_EST_ACITZ VARCHAR2 (1 BYTE)

EAUTH_EST_ABUS VARCHAR2 (1 BYTE)

EAUTH_EST_AEXTRN VARCHAR2 (1 BYTE)

EAUTH_EST_AINTRN VARCHAR2 (1 BYTE)

EAUTH_EST_AFED VARCHAR2 (1 BYTE)

EAUTH_EST_TRANX VARCHAR2 (1 BYTE)

EAUTH_YRLY_LOGIN VARCHAR2 (1 BYTE)

EAUTH_G2C_AUSR VARCHAR2 (1 BYTE)

EAUTH_G2B_AUSR VARCHAR2 (1 BYTE)

EAUTH_G2G_AUSR VARCHAR2 (1 BYTE)

EAUTH_IEE_AUSR VARCHAR2 (1 BYTE)

EAUTH_DESC_CITZ VARCHAR2 (4000 BYTE)

EAUTH_DESC_BUS VARCHAR2 (4000 BYTE)

EAUTH_DESC_GOV VARCHAR2 (4000 BYTE)

TABLE DITPR_SYS_EXT

APPLIC_ID NUMBER

SYSEX_USR VARCHAR2 (1 BYTE)

SYSEX_TYP_ITSYS VARCHAR2 (1 BYTE)

SYSEX_BNDL_TX VARCHAR2 (100 BYTE)

SYSEX_TRN_PLN_ST VARCHAR2 (1 BYTE)

SYSEX_FFIS VARCHAR2 (1 BYTE)

SYSEX_SYS_OP VARCHAR2 (7 BYTE)

SYSEX_ISIN_ETP VARCHAR2 (1 BYTE)

SYSEX_WCH_ETP VARCHAR2 (1 BYTE)

SYSEX_C_P_MOD VARCHAR2 (1 BYTE)

SYSEX_EDTD_DT DATE

SYSEX_FFMIA_CD VARCHAR2 (1 BYTE)

SYSEX_FFMIA_CMTS VARCHAR2 (4000 BYTE)

SYSEX_SFIS_CD VARCHAR2 (1 BYTE)

SYSEX_SFIS_CMTS VARCHAR2 (4000 BYTE)

TABLE DITPR_SYS_POC

APPLIC_ID NUMBER

VAL_POC_CODE VARCHAR2 (8 BYTE)

ROLE_CODE VARCHAR2 (5 BYTE)

ORG_CODE VARCHAR2 (8 BYTE)

UPDATED_DATE DATE

TABLE DOCUMENT_APPROVERS

DOC_ID NUMBER NOT NULL

APPROVER_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

USER_ID NUMBER

ROLE_ID NUMBER

TABLE DOCUMENT_DISCIPLINES

DOC_ID NUMBER NOT NULL

DISCIPLINE_ID NUMBER NOT NULL

FEATURES_ENABLED NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE DOCUMENT_MILESTONES

DOC_ID NUMBER NOT NULL

PHASE_ID NUMBER NOT NULL

MILESTONE_ID NUMBER NOT NULL

FEATURES_ENABLED NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE DOCUMENT_PHASES

DOC_ID NUMBER NOT NULL

PHASE_ID NUMBER NOT NULL

FEATURES_ENABLED NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE DOCUMENT_ROLES

DOC_ID NUMBER NOT NULL

ROLE_ID NUMBER NOT NULL

FEATURES_ENABLED NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE DOCUMENT_SIGNERS

DOC_ID NUMBER NOT NULL

USER_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE DOCUMENT_SIGN_AUTHORITIES

SIGN_ID NUMBER NOT NULL

SIGNING_AUTHORITY VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE DOCUMENT_TEMPLATES

DOC_ID NUMBER NOT NULL

DOCUMENT_NAME VARCHAR2 (200 BYTE) NOT NULL

DOCUMENT_TYPE VARCHAR2 (100 BYTE) NOT NULL

CATEGORY_NAME VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

DOCUMENT_DESC VARCHAR2 (4000 BYTE)

TABLE DOCUMENT_TEMPLATES_SURVEYS

DOC_ID NUMBER NOT NULL

MASTER_ID NUMBER NOT NULL

TABLE DOCUMENT_TEMPLATE_FILES

DOC_ID NUMBER NOT NULL

TEMPLATE_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

MIME_TYPE VARCHAR2 (100 BYTE)

OBJECT_DESC VARCHAR2 (4000 BYTE)

OBJECT_FILENAME VARCHAR2 (200 BYTE)

OBJECT_DATA BLOB

VALID_IND NUMBER

TABLE DOMAINS

DOMAIN_ID NUMBER NOT NULL

DOMAIN_NAME VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE DOMAIN_AREA_ELEMENTS

DOMAIN_ID NUMBER NOT NULL

ELEMENT_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE DOMAIN_ELEMENTS

ELEMENT_ID NUMBER NOT NULL

ELEMENT_NAME VARCHAR2 (100 BYTE) NOT NULL

ELEMENT_TYPE NUMBER NOT NULL

ELEMENT_DESC VARCHAR2 (4000 BYTE) NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE DOMAIN_ELEMENT_TYPES

ELEMENT_TYPE NUMBER NOT NULL

ELEMENT_TYPE_DESC VARCHAR2 (2000 BYTE) NOT NULL

ELEMENT_TYPE_FEATURES NUMBER NOT NULL

ELEMENT_TYPE_DESCRIPTOR VARCHAR2 (4000 BYTE) NOT NULL

TABLE E41_E42_XREF

REASONCODE VARCHAR2 (6 BYTE) NOT NULL

DESCRIPTION VARCHAR2 (87 BYTE)

TABLE EITDR_AUDIT_EVENTS

AUDIT_ID NUMBER NOT NULL

AUDIT_TS DATE NOT NULL

USER_ID NUMBER NOT NULL

EVENT_CATEGORY VARCHAR2 (30 BYTE) NOT NULL

EVENT_TYPE VARCHAR2 (100 BYTE) NOT NULL

EVENT_TEXT VARCHAR2 (4000 BYTE)

TABLE EITDR_AUDIT_EVENTS_ARCHIVE

AUDIT_ID NUMBER NOT NULL

AUDIT_TS DATE NOT NULL

USER_ID NUMBER NOT NULL

EVENT_CATEGORY VARCHAR2 (30 BYTE) NOT NULL

EVENT_TYPE VARCHAR2 (100 BYTE) NOT NULL

EVENT_TEXT VARCHAR2 (4000 BYTE)

TABLE EITDR_CALENDAR

EXCLUDE_DATE DATE NOT NULL

DATE_DESC VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

TABLE EITDR_COMMENTS

COMMENT_ID NUMBER NOT NULL

INVESTMENT_ID NUMBER NOT NULL

USER_COMMENT VARCHAR2 (4000 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

REF_COMMENT_ID NUMBER

SURVEY_ID NUMBER

QUESTION_ID NUMBER

SC_ID NUMBER

METRIC_ID NUMBER

REF_PK_ID NUMBER

REQUEST_ID NUMBER

TABLE EITDR_COMMENT_STATUS

COMMENT_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

READ_IND NUMBER

READ_TS DATE

FLAG_IND NUMBER

TABLE EITDR_CONFIG

CONFIG_OPTION VARCHAR2 (100 BYTE) NOT NULL

CONFIG_VALUE VARCHAR2 (4000 BYTE)

DEFAULT_DISCO_CONNECT VARCHAR2 (100 BYTE)

TABLE EITDR_DB_LOG

EITDR_DB_LOG_ID NUMBER NOT NULL

LOG_KEY VARCHAR2 (75 BYTE)

LOG_DATA VARCHAR2 (4000 BYTE)

LOG_USER_ID NUMBER

LOG_CREATE_TS TIMESTAMP WITH LOCAL TIME ZONE DEFAULT SYSTIMESTAMP NOT NULL

LOG_USER VARCHAR2 (30 BYTE) DEFAULT USER NOT NULL

TABLE EITDR_E14_BINS

HAF_MAJCOM VARCHAR2 (100 BYTE)

BIN VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (100 BYTE)

PEC_CODE VARCHAR2 (100 BYTE)

APPN VARCHAR2 (100 BYTE)

BA_CODE VARCHAR2 (100 BYTE)

BLI_CODE VARCHAR2 (100 BYTE)

OAC_CODE VARCHAR2 (20 BYTE)

PY NUMBER (20,6)

CY NUMBER (20,6)

BYP0 NUMBER (20,6)

BYP1 NUMBER (20,6)

BYP2 NUMBER (20,6)

BYP3 NUMBER (20,6)

BYP4 NUMBER (20,6)

BYP5 NUMBER (20,6)

STATUS_IND NUMBER

CREATOR NUMBER

CREATE_TS DATE

LAST_MOD_TS DATE

TABLE EITDR_E14_BINS_BACKUP

HAF_MAJCOM VARCHAR2 (100 BYTE)

BIN VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (100 BYTE)

PEC_CODE VARCHAR2 (100 BYTE)

APPN VARCHAR2 (100 BYTE)

BA_CODE VARCHAR2 (100 BYTE)

BLI_CODE VARCHAR2 (100 BYTE)

OAC_CODE VARCHAR2 (20 BYTE)

PY NUMBER (20,6)

CY NUMBER (20,6)

BYP0 NUMBER (20,6)

BYP1 NUMBER (20,6)

BYP2 NUMBER (20,6)

BYP3 NUMBER (20,6)

BYP4 NUMBER (20,6)

BYP5 NUMBER (20,6)

STATUS_IND NUMBER

CREATOR NUMBER

CREATE_TS DATE

LAST_MOD_TS DATE

TABLE EITDR_E14_BINS_SUMMARY

HAF_MAJCOM VARCHAR2 (100 BYTE)

BIN VARCHAR2 (100 BYTE)

ACRONYM VARCHAR2 (100 BYTE)

PEC_CODE VARCHAR2 (100 BYTE)

APPN VARCHAR2 (100 BYTE)

BA_CODE VARCHAR2 (100 BYTE)

BLI_CODE VARCHAR2 (100 BYTE)

OAC_CODE VARCHAR2 (20 BYTE)

PY NUMBER (20,6)

CY NUMBER (20,6)

BYP0 NUMBER (20,6)

BYP1 NUMBER (20,6)

BYP2 NUMBER (20,6)

BYP3 NUMBER (20,6)

BYP4 NUMBER (20,6)

BYP5 NUMBER (20,6)

STATUS_IND NUMBER

CREATOR NUMBER

CREATE_TS DATE

LAST_MOD_TS DATE

TABLE EITDR_EVENTS

EVENT_ID NUMBER NOT NULL

EVENT_NAME VARCHAR2 (100 BYTE) NOT NULL

EVENT_DESC VARCHAR2 (4000 BYTE) NOT NULL

CATEGORY_NAME VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE EITDR_EVENT_NOTIFY

EVENT_ID NUMBER NOT NULL

ADDRESSEE_ID NUMBER NOT NULL

ADDRESSEE_TYPE NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE EITDR_FUNDING_EXPORT

INVESTMENT_ID NUMBER NOT NULL

SURVEY_ID NUMBER NOT NULL

INIT_NUM VARCHAR2 (100 BYTE)

IA_PCT NUMBER (15,5)

FN_PCT NUMBER (15,5)

BE_PCT NUMBER (15,5)

BF_PCT NUMBER (15,5)

IPV6_PCT NUMBER (15,5)

HSPD_PCT NUMBER (15,5)

IA_CY_PCT NUMBER (15,5)

TABLE EITDR_GROUPS

GROUP_ID NUMBER NOT NULL

GROUP_NAME VARCHAR2 (100 BYTE) NOT NULL

GROUP_DESC VARCHAR2 (4000 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

TABLE EITDR_GROUP_MEMBERS

GROUP_ID NUMBER NOT NULL

CONTACT_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

TABLE EITDR_MESSAGES

MESSAGE_ID NUMBER NOT NULL

EVENT_ID NUMBER NOT NULL

SUBJECT VARCHAR2 (200 BYTE) NOT NULL

MESSAGE_TX VARCHAR2 (4000 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

INVESTMENT_ID NUMBER

VERSION_ID NUMBER

PHASE_ID NUMBER

DISCIPLINE_ID NUMBER

MILESTONE_ID NUMBER

SURVEY_ID NUMBER

QUESTION_ID NUMBER

ORG_ID NUMBER

USER_ID NUMBER

TABLE EITDR_MESSAGE_ATTACHMENTS

ATTACHMENT_ID NUMBER NOT NULL

MESSAGE_ID NUMBER

ATTACHMENT_DATA BLOB NOT NULL

SESSION_ID VARCHAR2 (100 BYTE)

FILE_NAME VARCHAR2 (255 BYTE)

CREATOR NUMBER

CREATE_TS DATE NOT NULL

TABLE EITDR_MESSAGE_RECIPIENTS

MESSAGE_ID NUMBER NOT NULL

CONTACT_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

READ_IND NUMBER

READ_TS DATE

EMAIL_STATUS_IND NUMBER

EMAIL_SENT_TS DATE

TABLE EITDR_NEWS

NEWS_ID NUMBER NOT NULL

HEADLINE VARCHAR2 (100 BYTE) NOT NULL

CONTENT VARCHAR2 (2000 BYTE) NOT NULL

START_TS DATE NOT NULL

EXPIRE_TS DATE NOT NULL

AUTHOR VARCHAR2 (80 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

OWNER_ID NUMBER NOT NULL

TABLE EITDR_OBJECTS

OBJECT_ID NUMBER NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

MIME_TYPE VARCHAR2 (100 BYTE)

OBJECT_DESC VARCHAR2 (4000 BYTE)

OBJECT_FILENAME VARCHAR2 (200 BYTE)

OBJECT_DATA BLOB

TABLE EITDR_PREFERENCE_TYPES

PREF_ID NUMBER NOT NULL

PREF_DESC VARCHAR2 (100 BYTE) NOT NULL

DEFAULT_SETTING VARCHAR2 (100 BYTE)

PREF_GROUP VARCHAR2 (100 BYTE) NOT NULL

TABLE EITDR_PROCESS

PROCESS_ID NUMBER NOT NULL

PROCESS_NAME VARCHAR2 (100 BYTE) NOT NULL

CREATOR NUMBER NOT NULL

CREATE_TS DATE NOT NULL

LAST_MOD_TS DATE NOT NULL

STATUS_IND NUMBER NOT NULL

DUE_DATE DATE

PROCESS_DESC VARCHAR2 (4000 BYTE)

TIMELINE VARCHAR2 (100 BYTE)

TABLE EITDR_RELEASE_INFO

REF_ID NUMBER NOT NULL

RELEASE_NUMBER VARCHAR2 (100 BYTE) NOT NULL

CREATE_TS DATE NOT NULL

RELEASE_NOTES VARCHAR2 (4000 BYTE)

TABLE EITDR_RESOURCE_EXPORT

INVESTMENT_ID NUMBER

SURVEY_ID NUMBER

INIT_NUM VARCHAR2 (100 BYTE)

APPN_CODE VARCHAR2 (100 BYTE)

INVEST_STAGE VARCHAR2 (100 BYTE)

BA_CODE VARCHAR2 (100 BYTE)

PEC_CODE VARCHAR2 (100 BYTE)

BLI_CODE VARCHAR2 (100 BYTE)

CY_OFFSET NUMBER

YEAR_VAL NUMBER

FUNDING_SRC_ID VARCHAR2 (4 BYTE)

FTE_CD CHAR (3 BYTE)

CATEGORY_ID NUMBER

ELEMENT_ID NUMBER

LINE_ID NUMBER

TABLE EITDR_SMTP_SETTINGS

SMTP_SERVER VARCHAR2 (100 BYTE) NOT NULL

SMTP_HELO VARCHAR2 (100 BYTE) NOT NULL

MAIL_FROM VARCHAR2 (100 BYTE) NOT NULL

PRIMARY_IND NUMBER NOT NULL

CREATOR NUMBER NOT NULL

LAST_MOD_TS DATE NOT NULL

REPLY_TO VARCHAR2 (100 BYTE)

SUBJECT_PREFIX VARCHAR2 (100 BYTE)

SMTP_SERVER_PORT NUMBER

MESSAGE_FOOTER VARCHAR2 (4000 BYTE)

TABLE ETL_SRVY_QUES_STAT_MIN_TS

SURVEY_ID NUMBER

DISCIPLINE_ID NUMBER

QUESTION_ID NUMBER

LOCKED_TS DATE

LOCKED_BY_USER NUMBER

REVIEWED_TS DATE

REVIEWED_BY_USER NUMBER

VALIDATED_TS DATE

VALIDATED_BY_USER NUMBER

INVALIDATED_TS DATE

INVALIDATED_BY_USER NUMBER

ANSWERED_IND NUMBER

SUPPRESSED_IND NUMBER

MIN_LOCKED_TS VARCHAR2 (10 BYTE)

MIN_REVIEWED_TS DATE

MIN_VALIDATED_TS DATE

TABLE EUL5_ACCESS_PRIVS

AP_ID NUMBER (10) NOT NULL

AP_TYPE VARCHAR2 (10 BYTE) NOT NULL

AP_EU_ID NUMBER (10) NOT NULL

AP_PRIV_LEVEL NUMBER (2) NOT NULL

GP_APP_ID NUMBER (10)

GBA_BA_ID NUMBER (10)

GD_DOC_ID NUMBER (10)

AP_ELEMENT_STATE NUMBER (10) NOT NULL

AP_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

AP_CREATED_DATE DATE NOT NULL

AP_UPDATED_BY VARCHAR2 (64 BYTE)

AP_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_APP_PARAMS

APP_ID NUMBER (10) NOT NULL

APP_TYPE VARCHAR2 (10 BYTE) NOT NULL

APP_NAME_MN NUMBER (10) NOT NULL

APP_DESCRIPTION_MN NUMBER (10) NOT NULL

SP_DEFAULT_VALUE VARCHAR2 (240 BYTE)

SP_VALUE VARCHAR2 (240 BYTE)

APP_ELEMENT_STATE NUMBER (10) NOT NULL

APP_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

APP_CREATED_DATE DATE NOT NULL

APP_UPDATED_BY VARCHAR2 (64 BYTE)

APP_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_ASMP_CONS

APC_ID NUMBER (10) NOT NULL

APC_TYPE VARCHAR2 (10 BYTE) NOT NULL

APC_CONS_TYPE NUMBER (2) NOT NULL

APC_ASMP_ID NUMBER (10) NOT NULL

AOC_OBJ_ID NUMBER (10)

ASOC_SUMO_ID NUMBER (10)

AUC_EU_ID NUMBER (10)

APC_ELEMENT_STATE NUMBER (10) NOT NULL

APC_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

APC_CREATED_DATE DATE NOT NULL

APC_UPDATED_BY VARCHAR2 (64 BYTE)

APC_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_ASMP_LOGS

APL_ID NUMBER (10) NOT NULL

APL_TIMESTAMP DATE NOT NULL

APL_EVENT_TYPE NUMBER (2) NOT NULL

APL_ASMP_ID NUMBER (10) NOT NULL

APL_SUMO_ID NUMBER (10)

APL_ELEMENT_STATE NUMBER (10) NOT NULL

APL_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

APL_CREATED_DATE DATE NOT NULL

APL_UPDATED_BY VARCHAR2 (64 BYTE)

APL_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_ASM_POLICIES

ASMP_ID NUMBER (10) NOT NULL

ASMP_NAME VARCHAR2 (100 BYTE) NOT NULL

ASMP_DEVELOPER_KEY VARCHAR2 (100 BYTE) NOT NULL

ASMP_DESCRIPTION VARCHAR2 (240 BYTE)

ASMP_USER_PROP1 VARCHAR2 (100 BYTE)

ASMP_USER_PROP2 VARCHAR2 (100 BYTE)

ASMP_ELEMENT_STATE NUMBER (10) NOT NULL

ASMP_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

ASMP_CREATED_DATE DATE NOT NULL

ASMP_UPDATED_BY VARCHAR2 (64 BYTE)

ASMP_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BAS

BA_ID NUMBER (10) NOT NULL

BA_NAME VARCHAR2 (100 BYTE) NOT NULL

BA_DEVELOPER_KEY VARCHAR2 (100 BYTE) NOT NULL

BA_DESCRIPTION VARCHAR2 (240 BYTE)

BA_EXT_NAME VARCHAR2 (64 BYTE)

BA_USER_PROP1 VARCHAR2 (100 BYTE)

BA_USER_PROP2 VARCHAR2 (100 BYTE)

BA_ELEMENT_STATE NUMBER (10) NOT NULL

BA_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BA_CREATED_DATE DATE NOT NULL

BA_UPDATED_BY VARCHAR2 (64 BYTE)

BA_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BATCH_PARAMS

BP_ID NUMBER (10) NOT NULL

BP_NAME VARCHAR2 (100 BYTE) NOT NULL

BP_VALUE1 VARCHAR2 (250 BYTE) NOT NULL

BP_VALUE2 VARCHAR2 (250 BYTE)

BP_VALUE3 VARCHAR2 (250 BYTE)

BP_VALUE4 VARCHAR2 (250 BYTE)

BP_VALUE5 VARCHAR2 (250 BYTE)

BP_VALUE6 VARCHAR2 (250 BYTE)

BP_BS_ID NUMBER (10) NOT NULL

BP_ELEMENT_STATE NUMBER (10) NOT NULL

BP_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BP_CREATED_DATE DATE NOT NULL

BP_UPDATED_BY VARCHAR2 (64 BYTE)

BP_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BATCH_QUERIES

BQ_ID NUMBER (10) NOT NULL

BQ_BS_ID NUMBER (10) NOT NULL

BQ_QUERY_ID VARCHAR2 (240 BYTE) NOT NULL

BQ_RESULT_SQL_1 VARCHAR2 (250 BYTE)

BQ_RESULT_SQL_2 VARCHAR2 (250 BYTE)

BQ_RESULT_SQL_3 VARCHAR2 (250 BYTE)

BQ_RESULT_SQL_4 VARCHAR2 (250 BYTE)

BQ_ELEMENT_STATE NUMBER (10) NOT NULL

BQ_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BQ_CREATED_DATE DATE NOT NULL

BQ_UPDATED_BY VARCHAR2 (64 BYTE)

BQ_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BATCH_REPORTS

BR_ID NUMBER (10) NOT NULL

BR_NAME VARCHAR2 (100 BYTE) NOT NULL

BR_WORKBOOK_NAME VARCHAR2 (240 BYTE) NOT NULL

BR_DESCRIPTION VARCHAR2 (240 BYTE)

BR_NEXT_RUN_DATE DATE

BR_JOB_ID NUMBER (22)

BR_EXPIRY NUMBER (22)

BR_COMPLETION_DATE DATE

BR_NUM_FREQ_UNITS NUMBER (22)

BR_EU_ID NUMBER (10) NOT NULL

BR_RFU_ID NUMBER (10) NOT NULL

BR_AUTO_REFRESH NUMBER (1) NOT NULL

BR_REPORT_SCHEMA VARCHAR2 (64 BYTE) NOT NULL

BR_OVERWRITE_RSLTS NUMBER (1)

BR_ELEMENT_STATE NUMBER (10) NOT NULL

BR_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BR_CREATED_DATE DATE NOT NULL

BR_UPDATED_BY VARCHAR2 (64 BYTE)

BR_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BATCH_SHEETS

BS_ID NUMBER (10) NOT NULL

BS_BR_ID NUMBER (10) NOT NULL

BS_SHEET_NAME VARCHAR2 (240 BYTE) NOT NULL

BS_SHEET_ID VARCHAR2 (240 BYTE) NOT NULL

BS_ELEMENT_STATE NUMBER (10) NOT NULL

BS_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BS_CREATED_DATE DATE NOT NULL

BS_UPDATED_BY VARCHAR2 (64 BYTE)

BS_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BA_OBJ_LINKS

BOL_ID NUMBER (10) NOT NULL

BOL_BA_ID NUMBER (10) NOT NULL

BOL_OBJ_ID NUMBER (10) NOT NULL

BOL_SEQUENCE NUMBER (22)

BOL_ELEMENT_STATE NUMBER (10) NOT NULL

BOL_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BOL_CREATED_DATE DATE NOT NULL

BOL_UPDATED_BY VARCHAR2 (64 BYTE)

BOL_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BQ_DEPS

BQD_ID NUMBER (10) NOT NULL

BQD_TYPE VARCHAR2 (10 BYTE) NOT NULL

BQD_BQ_ID NUMBER (10) NOT NULL

BFILD_FIL_ID NUMBER (10)

BID_IT_ID NUMBER (10)

BFUND_FUN_ID NUMBER (10)

BQD_ELEMENT_STATE NUMBER (10) NOT NULL

BQD_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BQD_CREATED_DATE DATE NOT NULL

BQD_UPDATED_BY VARCHAR2 (64 BYTE)

BQD_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BQ_TABLES

BQT_ID NUMBER (10) NOT NULL

BQT_BQ_ID NUMBER (10) NOT NULL

BQT_BRR_ID NUMBER (10) NOT NULL

BQT_TABLE_NAME VARCHAR2 (64 BYTE) NOT NULL

BQT_ELEMENT_STATE NUMBER (10) NOT NULL

BQT_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BQT_CREATED_DATE DATE NOT NULL

BQT_UPDATED_BY VARCHAR2 (64 BYTE)

BQT_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_BR_RUNS

BRR_ID NUMBER (10) NOT NULL

BRR_BR_ID NUMBER (10) NOT NULL

BRR_RUN_NUMBER NUMBER (22) NOT NULL

BRR_STATE NUMBER (2) NOT NULL

BRR_RUN_DATE DATE

BRR_SVR_ERR_CODE NUMBER

BRR_SVR_ERR_TEXT VARCHAR2 (240 BYTE)

BRR_ACT_ELAP_TIME NUMBER

BRR_ELEMENT_STATE NUMBER (10) NOT NULL

BRR_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

BRR_CREATED_DATE DATE NOT NULL

BRR_UPDATED_BY VARCHAR2 (64 BYTE)

BRR_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_DBH_NODES

DHN_ID NUMBER (10) NOT NULL

DHN_NAME VARCHAR2 (100 BYTE) NOT NULL

DHN_DEVELOPER_KEY VARCHAR2 (100 BYTE) NOT NULL

DHN_DESCRIPTION VARCHAR2 (240 BYTE)

DHN_DATA_FMT_MSK VARCHAR2 (100 BYTE) NOT NULL

DHN_DISP_FMT_MSK VARCHAR2 (100 BYTE) NOT NULL

DHN_HI_ID NUMBER (10) NOT NULL

DHN_USER_PROP2 VARCHAR2 (100 BYTE)

DHN_USER_PROP1 VARCHAR2 (100 BYTE)

DHN_ELEMENT_STATE NUMBER (10) NOT NULL

DHN_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

DHN_CREATED_DATE DATE NOT NULL

DHN_UPDATED_BY VARCHAR2 (64 BYTE)

DHN_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_DOCUMENTS

DOC_ID NUMBER (10) NOT NULL

DOC_NAME VARCHAR2 (100 BYTE) NOT NULL

DOC_DEVELOPER_KEY VARCHAR2 (100 BYTE) NOT NULL

DOC_DESCRIPTION VARCHAR2 (240 BYTE)

DOC_EU_ID NUMBER (10) NOT NULL

DOC_LENGTH NUMBER (22) NOT NULL

DOC_BATCH NUMBER (1) NOT NULL

DOC_FOLDER_ID NUMBER (10)

DOC_CONTENT_TYPE VARCHAR2 (100 BYTE) NOT NULL

DOC_DOCUMENT LONG RAW

DOC_USER_PROP2 VARCHAR2 (100 BYTE)

DOC_USER_PROP1 VARCHAR2 (100 BYTE)

DOC_ELEMENT_STATE NUMBER (10) NOT NULL

DOC_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

DOC_CREATED_DATE DATE NOT NULL

DOC_UPDATED_BY VARCHAR2 (64 BYTE)

DOC_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_DOC_FOLDERS

FOL_ID NUMBER (10) NOT NULL

FOL_NAME VARCHAR2 (100 BYTE) NOT NULL

FOL_DEVELOPER_KEY VARCHAR2 (100 BYTE) NOT NULL

FOL_DESCRIPTION VARCHAR2 (240 BYTE)

FOL_EU_ID NUMBER (10) NOT NULL

FOL_PARENT_ID NUMBER (10)

FOL_USER_PROP2 VARCHAR2 (100 BYTE)

FOL_USER_PROP1 VARCHAR2 (100 BYTE)

FOL_ELEMENT_STATE NUMBER (10) NOT NULL

FOL_CREATED_BY VARCHAR2 (64 BYTE) NOT NULL

FOL_CREATED_DATE DATE NOT NULL

FOL_UPDATED_BY VARCHAR2 (64 BYTE)

FOL_UPDATED_DATE DATE

NOTM NUMBER (10)

TABLE EUL5_DOMAINS

DOM_ID NUMBER (10) NOT NULL

DOM_NAME VARCHAR2 (100 BYTE) NOT NULL

DOM_DEVELOPER_KEY VARCHAR2 (100 BYTE) NOT NULL

DOM_DESCRIPTION VARCHAR2 (240 BYTE)

DOM_DATA_TYPE NUMBER (2) NOT NULL

DOM_LOGICAL_ITEM NUMBER (1) NOT NULL

DOM_SYS_GENERATED NUMBER (1) NOT NULL

DOM_CARDINALITY NUMBER (22)

DOM_LAST_EXEC_TIME NUMBER (22)

DOM_CACHED NUMBER (1) NOT NULL

DOM_IT_ID_LOV NUMBER (10)

DOM_IT_ID_RANK NUMBER (10)

DOM_ARRAY_FETCH_SZ NUMBER (22)

DOM_FTCH_IMMEDIATE…

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .