EITDR_DB_SPEC_20131216.pdf
PDF 590 KB Posted
- Attached to
- EITDR Reporting Environment
- Solicitation number
- FA8771-EITDR_Reporting_Environment
About this file
EITDR_DB_SPEC
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFI_for_Reporting_Environment(final)_(4).pdf | ||
| EITDR_processes.pdf | ||
| RFI_for_Reporting_Environment(final)_(3).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 .