RF_S1_CONFIG |
Default Table Name | RF_S1_CONFIG |
Definition |
RF_S1_CONFIG Columns |
ColumnName | Domain | Datatype | NULL | Definition |
REVIEW_FORM_ID![]() |
VARCHAR2(12) | NO | ||
REVIEW_FORM_DESC | VARCHAR2(30) | NO | ||
CUSTOM_FORM_FL | VARCHAR2(1) | NO | ||
CUSTOM_FORM_NAME | VARCHAR2(12) | NO | ||
EMPL_SSN_FL | VARCHAR2(1) | NO | ||
EMPL_ADD_FL | VARCHAR2(1) | NO | ||
EMPL_HIRE_DT_FL | VARCHAR2(1) | NO | ||
EMPL_LAST_DT_FL | VARCHAR2(1) | NO | ||
EMPL_SUP_FL | VARCHAR2(1) | NO | ||
EMPL_MAN_FL | VARCHAR2(1) | NO | ||
EMPL_COMP_FL | VARCHAR2(1) | NO | ||
EMPL_GRADE_FL | VARCHAR2(1) | NO | ||
EMPL_STEP_FL | VARCHAR2(1) | NO | ||
EMPL_H_S_FL | VARCHAR2(1) | NO | ||
EMPL_DET_FL | VARCHAR2(1) | NO | ||
EMPL_HRLY_FL | VARCHAR2(1) | NO | ||
EMPL_SAL_FL | VARCHAR2(1) | NO | ||
EMPL_ANNL_FL | VARCHAR2(1) | NO | ||
EMPL_LPCT_FL | VARCHAR2(1) | NO | ||
EMPL_LRAT_FL | VARCHAR2(1) | NO | ||
EMPL_LABGP_FL | VARCHAR2(1) | NO | ||
EMPL_LOC_FL | VARCHAR2(1) | NO | ||
EMPL_GLC_FL | VARCHAR2(1) | NO | ||
EMPL_ORG_FL | VARCHAR2(1) | NO | ||
EMPL_SSN_NO | NUMBER(5, 0) | NO | ||
EMPL_ADD_NO | NUMBER(5, 0) | NO | ||
EMPL_HIRE_DT_NO | NUMBER(5, 0) | NO | ||
EMPL_LAST_DT_NO | NUMBER(5, 0) | NO | ||
EMPL_SUP_NO | NUMBER(5, 0) | NO | ||
EMPL_MAN_NO | NUMBER(5, 0) | NO | ||
EMPL_COMP_NO | NUMBER(5, 0) | NO | ||
EMPL_GRADE_NO | NUMBER(5, 0) | NO | ||
EMPL_STEP_NO | NUMBER(5, 0) | NO | ||
EMPL_H_S_NO | NUMBER(5, 0) | NO | ||
EMPL_DET_NO | NUMBER(5, 0) | NO | ||
EMPL_HRLY_NO | NUMBER(5, 0) | NO | ||
EMPL_SAL_NO | NUMBER(5, 0) | NO | ||
EMPL_ANNL_NO | NUMBER(5, 0) | NO | ||
EMPL_LPCT_NO | NUMBER(5, 0) | NO | ||
EMPL_LRAT_NO | NUMBER(5, 0) | NO | ||
EMPL_LABGP_NO | NUMBER(5, 0) | NO | ||
EMPL_LOC_NO | NUMBER(5, 0) | NO | ||
EMPL_GLC_NO | NUMBER(5, 0) | NO | ||
EMPL_ORG_NO | NUMBER(5, 0) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
RF_S1_CONFIG Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_1105 | PrimaryKey | REVIEW_FORM_ID |
RF_S1_CONFIG Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
RF_DFLT | Non-Identifying | One To Zero or More | F09857 | NO | NO | NO | |||
TEMPLATE_RF_S1 | Identifying | One To Zero or More | F09891 | NO | NO | NO |