OPP_ASSESSMENT |
Default Table Name | OPP_ASSESSMENT |
Definition |
OPP_ASSESSMENT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
OPP_ID![]() |
VARCHAR2(32) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
OPP_ASSESS_KEY![]() |
NUMBER(10, 0) | NO | ||
OPP_ASSESS_IQ_ID | VARCHAR2(32) | YES | ||
OA_FORMAT_ID![]() |
VARCHAR2(10) | YES | ||
OPP_ASSESS_NAME | VARCHAR2(60) | NO | ||
OPP_ASSESS_LONG_NAME | VARCHAR2(255) | YES | ||
SRCE_ID | VARCHAR2(6) | NO | ||
TYPE | VARCHAR2(6) | NO | ||
OPP_ASSESS_STAT_CD | VARCHAR2(1) | NO | ||
TOT_SCORE | NUMBER(5, 0) | YES | ||
ASSESS_PERCENT | NUMBER(5, 0) | YES | ||
OPP_STAGE_CD | VARCHAR2(10) | NO | ||
ASSESS_DATE | DATE | NO | ||
GOVWINIQ_LOGIN_ID | VARCHAR2(100) | YES | ||
GOVWINIQ_OA_URL | VARCHAR2(254) | YES | ||
EMPL_ID | VARCHAR2(12) | YES | ||
ASSESS_RATE_1 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_1 | VARCHAR2(60) | YES | ||
ASSESS_RATE_2 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_2 | VARCHAR2(60) | YES | ||
ASSESS_RATE_3 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_3 | VARCHAR2(60) | YES | ||
ASSESS_RATE_4 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_4 | VARCHAR2(60) | YES | ||
ASSESS_RATE_5 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_5 | VARCHAR2(60) | YES | ||
ASSESS_RATE_6 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_6 | VARCHAR2(60) | YES | ||
ASSESS_RATE_7 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_7 | VARCHAR2(60) | YES | ||
ASSESS_RATE_8 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_8 | VARCHAR2(60) | YES | ||
ASSESS_RATE_9 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_9 | VARCHAR2(60) | YES | ||
ASSESS_RATE_10 | NUMBER(2, 0) | YES | ||
ASSESS_COMMENTS_10 | VARCHAR2(60) | YES | ||
OPP_ASSESS_NOTES | VARCHAR2(254) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
OPP_ASSESSMENT Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_OPP_ASSESSMENT_IDX | PrimaryKey | OPP_ID, COMPANY_ID, OPP_ASSESS_KEY |
OPP_ASSESSMENT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
OPP_ASSESS_FORMAT | Non-Identifying | Zero or One to Zero or More | FK_OPP_ASSESSMENT_OACO_IDX | COMPANY_ID, OA_FORMAT_ID | NO | NO | NO | ||
OPP_MASTER | Identifying | One To Zero or More | FK_OPP_ASSESSMENT_OPCO_IDX | OPP_ID, COMPANY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |