OPP_MASTER |
Default Table Name | OPP_MASTER |
Definition |
OPP_MASTER Columns |
ColumnName | Domain | Datatype | NULL | Definition |
OPP_ID![]() |
VARCHAR2(32) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
OPP_REC_TYPE | VARCHAR2(12) | NO | ||
OPP_NAME | VARCHAR2(60) | NO | ||
OPP_NUMBER | VARCHAR2(30) | NO | ||
OPP_DESC | VARCHAR2(4000) | NO | ||
OPP_LONG_NAME | VARCHAR2(256) | YES | ||
OPP_LONG_DESC | CLOB | YES | ||
OPP_KEY_WORDS | VARCHAR2(4000) | YES | ||
OPP_OUR_ROLE_CD | VARCHAR2(10) | YES | ||
PRIME_CONTRACTOR | VARCHAR2(32) | YES | ||
PRIME_CNTR_ADDR_DC | VARCHAR2(10) | YES | ||
OPP_CT_ROLE_CD | VARCHAR2(10) | YES | ||
MSTR_CNTR_NO | VARCHAR2(30) | YES | ||
OPP_REG_CT_NO | VARCHAR2(30) | YES | ||
SUBCNTR_NO | VARCHAR2(30) | YES | ||
CNTR_VEH_CD | VARCHAR2(10) | YES | ||
TASK_ORDER_NO | VARCHAR2(50) | YES | ||
PRIMARY_LOCATION | VARCHAR2(50) | YES | ||
PRIME_AGEN_ID | VARCHAR2(15) | YES | ||
PRIME_CUST_ID | VARCHAR2(32) | YES | ||
PRIME_CNTACT_ID | VARCHAR2(10) | YES | ||
PRIME_ADDR_DC | VARCHAR2(10) | YES | ||
ACQ_AGENCY_ID | VARCHAR2(15) | YES | ||
ACQ_CUST_ID | VARCHAR2(32) | YES | ||
ACQ_CNTACT_ID | VARCHAR2(10) | YES | ||
ACQ_ADDR_DC | VARCHAR2(10) | YES | ||
OPP_TOTAL_VALUE | NUMBER(17, 2) | YES | ||
TRN_TOTAL_VALUE | NUMBER(17, 2) | YES | ||
TRN_CRNCY_CD | VARCHAR2(3) | YES | ||
OPP_OUR_VALUE | NUMBER(17, 2) | YES | ||
TRN_OUR_VALUE | NUMBER(17, 2) | YES | ||
OPP_WIN_PROB_CD | VARCHAR2(10) | YES | ||
OPP_WEIGHTED_REV | NUMBER(17, 2) | YES | ||
TRN_WEIGHTED_REV | NUMBER(17, 2) | YES | ||
OPP_OPENED_DT | DATE | YES | ||
OPP_CLOSED_DT | DATE | YES | ||
CLOSED_RSN_CD | VARCHAR2(10) | YES | ||
OCI_CHECK_FL | VARCHAR2(1) | YES | ||
OCI_STATUS_CD | VARCHAR2(10) | YES | ||
OCI_CHECK_DT | DATE | YES | ||
OCI_COMPL_BY | VARCHAR2(12) | YES | ||
CONFLICT_WITH | VARCHAR2(60) | YES | ||
GWIQ_GO_PROB | NUMBER(5, 2) | YES | ||
GWIQ_WIN_PROB | NUMBER(5, 2) | YES | ||
GWIQ_FINAL_PROB | NUMBER(5, 2) | YES | ||
OPP_BUS_UNIT_CD | VARCHAR2(15) | YES | ||
OPP_BUS_UNIT_LEAD | VARCHAR2(12) | YES | ||
ORG_ID | VARCHAR2(20) | YES | ||
OPP_STAGE_CD | VARCHAR2(12) | YES | ||
STAGE_CHANGE_DT | DATE | YES | ||
OPP_TYPE_CD | VARCHAR2(10) | YES | ||
OPP_SOURCE_CD | VARCHAR2(10) | YES | ||
RECORD_STATUS_CD | VARCHAR2(1) | YES | ||
EST_START_DT | DATE | YES | ||
EST_END_DT | DATE | YES | ||
OPP_WEBSITE | VARCHAR2(1024) | YES | ||
NAICS_CD_1 | VARCHAR2(15) | YES | ||
NAICS_CD_2 | VARCHAR2(15) | YES | ||
OPP_NOTES | VARCHAR2(256) | YES | ||
ENTR_USER_ID | VARCHAR2(20) | YES | ||
ENTR_DTT | DATE | YES | ||
OPP_LABEL1 | VARCHAR2(50) | YES | ||
OPP_LABEL2 | VARCHAR2(50) | YES | ||
OPP_LABEL3 | VARCHAR2(50) | YES | ||
OPP_LABEL4 | VARCHAR2(50) | YES | ||
OPP_LABEL5 | VARCHAR2(50) | YES | ||
OPP_LABEL6 | VARCHAR2(50) | YES | ||
OPP_LABEL7 | VARCHAR2(50) | YES | ||
OPP_LABEL8 | VARCHAR2(50) | YES | ||
OPP_LABEL9 | VARCHAR2(50) | YES | ||
OPP_LABEL10 | VARCHAR2(50) | YES | ||
OPP_DATE1 | DATE | YES | ||
OPP_DATE2 | DATE | YES | ||
OPP_DATE3 | DATE | YES | ||
OPP_DATE4 | DATE | YES | ||
OPP_DATE5 | DATE | YES | ||
OPP_DATE6 | DATE | YES | ||
OPP_DATE7 | DATE | YES | ||
OPP_DATE8 | DATE | YES | ||
OPP_DATE9 | DATE | YES | ||
OPP_DATE10 | DATE | YES | ||
OPP_DATE11 | DATE | YES | ||
OPP_DATE12 | DATE | YES | ||
TEAM_AGREE_FL | VARCHAR2(1) | YES | ||
SUBCT_PLAN_FL | VARCHAR2(1) | YES | ||
DD254_APPLY_FL | VARCHAR2(1) | YES | ||
SCA_FL | VARCHAR2(1) | YES | ||
DAVIS_BACON_FL | VARCHAR2(1) | YES | ||
HIRE_RESTRICT_FL | VARCHAR2(1) | YES | ||
HIRE_RESTRICT_REMK | VARCHAR2(256) | YES | ||
HIRE_RESTR_STATUS | VARCHAR2(35) | YES | ||
SET_ASIDES | VARCHAR2(256) | YES | ||
BID_PROP_NO | VARCHAR2(50) | YES | ||
POP_MONTHS | NUMBER(5, 0) | YES | ||
RFI_RFP_MONTHS | NUMBER(5, 0) | YES | ||
REQ_BP_PROJ_FL | VARCHAR2(1) | YES | ||
BP_PROJ_NOTIFY | VARCHAR2(12) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
EXCL_RPTS_FL | VARCHAR2(1) | NO | ||
PRIME_CONTR_ID | VARCHAR2(30) | YES | ||
PRIME_CONTR_NAME | VARCHAR2(30) | YES | ||
SUBCNTR_PLAN_STAT_CD | VARCHAR2(1) | NO | ||
SUBCNTR_SUBMIT_DT | DATE | YES | ||
GEN_SM_BUS_FL | VARCHAR2(1) | NO | ||
SUBCNTR_PCT_REQ | NUMBER(5, 4) | NO | ||
USE_PLANNING | VARCHAR2(1) | NO | ||
PRIME_CUST_ADDR_DC | VARCHAR2(10) | YES | ||
ACQ_CUST_ADDR_DC | VARCHAR2(10) | YES | ||
LEAD_CNTACT_ID![]() |
VARCHAR2(32) | YES | ||
CMMC_LEVEL | NUMBER(1, 0) | YES |
OPP_MASTER Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_OPP_MASTER_IDX | PrimaryKey | OPP_ID, COMPANY_ID |
OPP_MASTER Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
LEAD_CNTACT_MASTER | Non-Identifying | Zero or One to Zero or More | FK_OPP_MASTER_LE_IDX | LEAD_CNTACT_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
CT_ACTV_MASTER | Non-Identifying | One To Zero or More | FK_CT_ACTV_MASTER_OPCO_IDX | NO | NO | NO | |||
OPP_ASSESSMENT | Identifying | One To Zero or More | FK_OPP_ASSESSMENT_OPCO_IDX | NO | NO | NO | |||
OPP_EMPL_TEAM | Identifying | One To Zero or More | FK_OPP_EMPL_TEAM_OPCO_IDX | NO | NO | NO | |||
OPP_GOVWINIQ | Identifying | One To Zero or More | FK_OPP_GOVWINIQ_OPCO_IDX | NO | NO | NO | |||
OPP_SUBC_PLAN | Identifying | One To Zero or More | FK_OPP_SUBC_PLAN_OPCO_IDX | NO | NO | NO | |||
OPP_TEAMMATES | Identifying | One To Zero or More | FK_OPP_TEAMMATES_OPCO_IDX | NO | NO | NO | |||
OPP_WORKFORCE_EMPL | Identifying | One To Zero or More | FK_OPP_WORKFORCE_EMPL_OPCO_IDX | NO | NO | NO | |||
POST_AWARD_DEBRIEF | Identifying | One To Zero or More | FK_POST_AWARD_DEBRIEF_OPCO_IDX | NO | NO | NO |