CNTR_MASTER |
Default Table Name | CNTR_MASTER |
Definition |
CNTR_MASTER Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CNTR_ID![]() |
VARCHAR2(30) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
CNTR_NAME | VARCHAR2(25) | NO | ||
OPP_ID | VARCHAR2(32) | YES | ||
OPP_NAME | VARCHAR2(60) | YES | ||
CP_OPP_FL | VARCHAR2(1) | NO | ||
PRIME_CONTR_ID | VARCHAR2(30) | YES | ||
PRIME_CONTR_NAME | VARCHAR2(30) | YES | ||
PRIME_CONTRACTOR | VARCHAR2(12) | YES | ||
MSTR_CNTR_NO | VARCHAR2(50) | YES | ||
SUB_CONTR_FL | VARCHAR2(1) | NO | ||
SUBCNTR_NO | VARCHAR2(30) | YES | ||
PO_ID | VARCHAR2(30) | YES | ||
CNTR_VEH_CD | VARCHAR2(10) | YES | ||
TASK_ORDER_NO | VARCHAR2(50) | YES | ||
CNTR_TYPE_CD | VARCHAR2(10) | NO | ||
PROJ_TYPE_DC | VARCHAR2(15) | NO | ||
BPA_FL | VARCHAR2(1) | NO | ||
CPAF_FL | VARCHAR2(1) | NO | ||
CPIF_FL | VARCHAR2(1) | NO | ||
CPFF_FL | VARCHAR2(1) | NO | ||
CR_FL | VARCHAR2(1) | NO | ||
CS_FL | VARCHAR2(1) | NO | ||
FFP_FL | VARCHAR2(1) | NO | ||
FFI_FL | VARCHAR2(1) | NO | ||
FPLOE_FL | VARCHAR2(1) | NO | ||
IDIQ_FL | VARCHAR2(1) | NO | ||
TM_FL | VARCHAR2(1) | NO | ||
OTHER_FL | VARCHAR2(1) | NO | ||
OTHER_DESC | VARCHAR2(15) | YES | ||
CNTR_STATUS | VARCHAR2(10) | NO | ||
PRIMARY_LOCATION | VARCHAR2(50) | YES | ||
CNTR_RISK_FL | VARCHAR2(1) | NO | ||
ALERT_FL | VARCHAR2(1) | NO | ||
CNTR_DESC | VARCHAR2(4000) | YES | ||
PROJ_MGR_ID | VARCHAR2(12) | YES | ||
PROJ_MGR_NAME | VARCHAR2(25) | YES | ||
BILLER_ID | VARCHAR2(12) | YES | ||
BILLER_NAME | VARCHAR2(25) | YES | ||
CNTR_ADMIN_ID | VARCHAR2(12) | YES | ||
CNTR_ADMIN_NAME | VARCHAR2(25) | YES | ||
SUB_ADMIN_ID | VARCHAR2(12) | YES | ||
SUB_ADMIN_NAME | VARCHAR2(25) | YES | ||
DCAA_OFFICE | VARCHAR2(400) | YES | ||
SBU_AUDIT_FL | VARCHAR2(1) | NO | ||
SBU_ENERGY_FL | VARCHAR2(1) | NO | ||
SBU_ENVIRO_FL | VARCHAR2(1) | NO | ||
SBU_DEFINTL_FL | VARCHAR2(1) | NO | ||
SBU_FINSVC_FL | VARCHAR2(1) | NO | ||
SBU_SEC_FL | VARCHAR2(1) | NO | ||
SBU_HEALTH_FL | VARCHAR2(1) | NO | ||
SBU_INTL_FL | VARCHAR2(1) | NO | ||
SBU_SLGPS_FL | VARCHAR2(1) | NO | ||
SBU_SLNGPS_FL | VARCHAR2(1) | NO | ||
SBU_OTHER_FL | VARCHAR2(1) | NO | ||
SBU_OTHER_DESC | VARCHAR2(50) | YES | ||
NAICS_CD_1![]() |
VARCHAR2(15) | YES | ||
NAICS_CD_2![]() |
VARCHAR2(15) | YES | ||
NDA_RQRD_FL | VARCHAR2(1) | NO | ||
NDA_SIGNED_DT | DATE | YES | ||
CLASSIFIED_FL | VARCHAR2(1) | NO | ||
US_CITIZEN_FL | VARCHAR2(1) | NO | ||
DD254_RQRD_FL | VARCHAR2(1) | NO | ||
SEC_CLR_CD![]() |
VARCHAR2(6) | YES | ||
SCISAP_CLR_CD![]() |
VARCHAR2(6) | YES | ||
SEC_CLR_DESC | VARCHAR2(30) | YES | ||
SCISAP_CLR_DESC | VARCHAR2(30) | YES | ||
REG_FAR_FL | VARCHAR2(1) | NO | ||
REG_DFARS_FL | VARCHAR2(1) | NO | ||
REG_NASA_FL | VARCHAR2(1) | NO | ||
REG_AMS_FL | VARCHAR2(1) | NO | ||
REG_DOE_FL | VARCHAR2(1) | NO | ||
REG_GSAR_FL | VARCHAR2(1) | NO | ||
REG_HSAR_FL | VARCHAR2(1) | NO | ||
REG_TREASURY_FL | VARCHAR2(1) | NO | ||
REG_OTHER_FL | VARCHAR2(1) | NO | ||
REG_AIDAR_FL | VARCHAR2(1) | NO | ||
REG_OTHER_DESC | VARCHAR2(50) | YES | ||
STMT_OF_WORK_TX | CLOB | YES | ||
CST_ACCT_STD_FL | VARCHAR2(1) | NO | ||
PROPOSAL_REC_FL | VARCHAR2(1) | NO | ||
CONTR_REC_FL | VARCHAR2(1) | NO | ||
FAC_RQRD_FL | VARCHAR2(1) | NO | ||
LOE_CLAUSE_FL | VARCHAR2(1) | NO | ||
CNTR_LIMITS_NOTES | VARCHAR2(2000) | YES | ||
CNTR_SPEC_REQ_FL | VARCHAR2(1) | NO | ||
CNTR_SPEC_NOTES | VARCHAR2(2000) | YES | ||
CNTR_SPEC_LITM_NOTES | VARCHAR2(2000) | YES | ||
GSA_FL | VARCHAR2(1) | NO | ||
GFE_FL | VARCHAR2(1) | NO | ||
GFE_NOTES | VARCHAR2(2000) | YES | ||
COM_FL | VARCHAR2(1) | NO | ||
COM_NOTES | VARCHAR2(2000) | YES | ||
BURD_CEIL_FL | VARCHAR2(1) | NO | ||
BURD_CEIL_NOTES | VARCHAR2(2000) | YES | ||
TM_FFP_FL | VARCHAR2(1) | NO | ||
COMMERCIAL_FL | VARCHAR2(1) | NO | ||
A8_CONTR_FL | VARCHAR2(1) | NO | ||
SCA_FL | VARCHAR2(1) | NO | ||
DAVIS_BACON_FL | VARCHAR2(1) | NO | ||
SUBCT_PLAN_FL | VARCHAR2(1) | NO | ||
ALLOW_CST_NOTES | VARCHAR2(2000) | YES | ||
UNALLOW_CST_NOTES | VARCHAR2(2000) | YES | ||
PROFIT_FEE_NOTES | VARCHAR2(2000) | YES | ||
CST_SHARE_NOTES | VARCHAR2(2000) | YES | ||
CNTR_AWARD_DT | DATE | YES | ||
CNTR_START_MM | NUMBER(5, 0) | YES | ||
CNTR_START_DT | DATE | YES | ||
CNTR_END_MM | NUMBER(5, 0) | YES | ||
CNTR_END_DT | DATE | YES | ||
PROJ_COMPLETE_FL | VARCHAR2(1) | YES | ||
CUST_REQUEST_FL | VARCHAR2(1) | YES | ||
MODS_EXEC_FL | VARCHAR2(1) | YES | ||
SUBS_CLOSED_FL | VARCHAR2(1) | YES | ||
FIN_RECON_FL | VARCHAR2(1) | YES | ||
ICS_FL | VARCHAR2(1) | YES | ||
RATE_AUDIT_FL | VARCHAR2(1) | YES | ||
FINAL_INVC_FL | VARCHAR2(1) | YES | ||
FINAL_INVC_PAID_FL | VARCHAR2(1) | YES | ||
CLOSE_PKG_FL | VARCHAR2(1) | YES | ||
PROJ_COMPLETE_DT | DATE | YES | ||
CUST_REQUEST_DT | DATE | YES | ||
MODS_EXEC_DT | DATE | YES | ||
SUBS_CLOSED_DT | DATE | YES | ||
FIN_RECON_DT | DATE | YES | ||
ICS_DT | DATE | YES | ||
RATE_AUDIT_DT | DATE | YES | ||
FINAL_INVC_DT | DATE | YES | ||
FINAL_INVC_PAID_DT | DATE | YES | ||
CLOSE_PKG_DT | DATE | YES | ||
PROJ_COMPLETE_BY | VARCHAR2(12) | YES | ||
CUST_REQUEST_BY | VARCHAR2(12) | YES | ||
MODS_EXEC_BY | VARCHAR2(12) | YES | ||
SUBS_CLOSED_BY | VARCHAR2(12) | YES | ||
FIN_RECON_BY | VARCHAR2(12) | YES | ||
ICS_BY | VARCHAR2(12) | YES | ||
RATE_AUDIT_BY | VARCHAR2(12) | YES | ||
FINAL_INVC_BY | VARCHAR2(12) | YES | ||
FINAL_INVC_PAID_BY | VARCHAR2(12) | YES | ||
CLOSE_PKG_BY | VARCHAR2(12) | YES | ||
CLASS_MATL_NOTES | VARCHAR2(2000) | YES | ||
GOVT_PROP_NOTES | VARCHAR2(2000) | YES | ||
INVENT_NOTES | VARCHAR2(2000) | YES | ||
OTHER_ISSUES_NOTES | VARCHAR2(2000) | YES | ||
CUST_ACCEPT_FL | VARCHAR2(1) | YES | ||
CUST_ACCEPT_SIGN | VARCHAR2(12) | YES | ||
CUST_ACCEPT_DT | DATE | YES | ||
PROJ_EST_TOT_AMT | NUMBER(17, 2) | YES | ||
PRIME_AGEN_ID | VARCHAR2(15) | YES | ||
ACQ_AGENCY_ID | VARCHAR2(15) | YES | ||
TIME_STAMP | DATE | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
RECORD_STATUS_CD | VARCHAR2(1) | YES | ||
DMS_DPS_CD | VARCHAR2(6) | YES | ||
EXCL_RPTS_FL | VARCHAR2(1) | 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 | ||
CNTR_LONG_NAME | VARCHAR2(120) | YES |
CNTR_MASTER Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_CNTR_MASTER_IDX | PrimaryKey | CNTR_ID, COMPANY_ID |
CNTR_MASTER Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
OPP_NAICS_CODES | Non-Identifying | Zero or One to Zero or More | FK_CNTR_MASTER_N1_IDX | NAICS_CD_1 | NO | NO | NO | ||
OPP_NAICS_CODES | Non-Identifying | Zero or One to Zero or More | FK_CNTR_MASTER_N2_IDX | NAICS_CD_2 | NO | NO | NO | ||
SCISAP_CLR | Non-Identifying | Zero or One to Zero or More | FK_CNTR_MASTER_SC_IDX | SCISAP_CLR_CD | NO | NO | NO | ||
SEC_CLR_SETTINGS | Non-Identifying | Zero or One to Zero or More | FK_CNTR_MASTER_SE_IDX | SEC_CLR_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
CNTR_BILL_LAB_CAT | Identifying | One To Zero or More | FK_CNTR_BILL_LAB_CAT_CNCO_IDX | NO | NO | NO | |||
CNTR_CAS | Identifying | One To Zero or More | FK_CNTR_CAS_CNCO_IDX | NO | NO | NO | |||
CNTR_DATES | Identifying | One To Zero or More | FK_CNTR_DATES_CNCO_IDX | NO | NO | NO | |||
CNTR_DELIV | Identifying | One To Zero or More | FK_CNTR_DELIV_CNCO_IDX | NO | NO | NO | |||
CNTR_DFAR | Identifying | One To Zero or More | FK_CNTR_DFAR_CNCO_IDX | NO | NO | NO | |||
CNTR_EMPL_TEAM | Identifying | One To Zero or More | FK_CNTR_EMPL_TEAM_CNCO_IDX | NO | NO | NO | |||
CNTR_FAR | Identifying | One To Zero or More | FK_CNTR_FAR_CNCO_IDX | NO | NO | NO | |||
CNTR_GSA_SCH | Identifying | One To Zero or More | FK_CNTR_GSA_SCH_CNCO_IDX | NO | NO | NO | |||
CNTR_MASTER_CONTACT | Identifying | One To Zero or More | FK_CNTR_MASTERCONTACT_CNCO_IDX | NO | NO | NO | |||
CNTR_OPP | Identifying | One To Zero or More | FK_CNTR_OPP_CNCO_IDX | NO | NO | NO | |||
CNTR_PROJ_MOD | Identifying | One To Zero or More | FK_CNTR_PROJ_MOD_CNCO_IDX | NO | NO | NO | |||
CNTR_PROVISIONS | Identifying | One To Zero or More | FK_CNTR_PROVISIONS_CNCO_IDX | NO | NO | NO | |||
CNTR_SUBC_PLAN | Identifying | One To Zero or More | FK_CNTR_SUBC_PLAN_CNCO_IDX | NO | NO | NO | |||
CNTR_TEAMMATES | Identifying | One To Zero or More | FK_CNTR_TEAMMATES_CNCO_IDX | NO | NO | NO | |||
CNTR_TINA | Identifying | One To Zero or More | FK_CNTR_TINA_CNCO_IDX | NO | NO | NO | |||
CNTR_WORKFORCE_EMPL | Identifying | One To Zero or More | FK_CNTR_WORKFORCEEMPL_CNCO_IDX | NO | NO | NO | |||
CT_ACTV_MASTER | Non-Identifying | One To Zero or More | FK_CT_ACTV_MASTER_CNCO_IDX | NO | NO | NO |