FUNC_JOB_TITLES |
Default Table Name | FUNC_JOB_TITLES |
Definition |
FUNC_JOB_TITLES Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FUNC_JOB_CD![]() |
VARCHAR2(10) | NO | ||
FUNC_JOB_DESC | VARCHAR2(30) | NO | ||
S_EEO_CD | VARCHAR2(4) | NO | ||
S_EEO_TRAIN_IND_CD | VARCHAR2(1) | NO | ||
SUM_JOB_CD![]() |
VARCHAR2(10) | YES | ||
SAL_GRADE_CD![]() |
VARCHAR2(10) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
JOB_GROUP_CD![]() |
VARCHAR2(10) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
S_VETS_CD | VARCHAR2(4) | NO | ||
S_VETS100A_CD | VARCHAR2(4) | YES |
FUNC_JOB_TITLES Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_1054 | PrimaryKey | FUNC_JOB_CD |
FUNC_JOB_TITLES Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
SUM_JOB_TITLES | Non-Identifying | Zero or One to Zero or More | F09827 | SUM_JOB_CD | NO | NO | NO | ||
SALARY_GRADES | Non-Identifying | One To Zero or More | F09828 | SAL_GRADE_CD | NO | NO | NO | ||
H_JOB_GROUP | Non-Identifying | Zero or One to Zero or More | F21573 | JOB_GROUP_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
DETL_JOB_TITLES | Non-Identifying | One To Zero or More | F09829 | NO | NO | NO | |||
SURVEY_FUNC_TITLE | Non-Identifying | One To Zero or More | F09886 | NO | NO | NO | |||
SURVEY_SAL_RANGE | Identifying | One To Zero or More | F09889 | NO | NO | NO | |||
H_AFF_CENSUS_LN | Identifying | One To Zero or More | F20381 | NO | NO | NO | |||
H_FUNC_POS_DESC | Identifying | One To Zero or More | F20477 | NO | NO | NO |