H_EXIT_INTV_FORM |
Default Table Name | H_EXIT_INTV_FORM |
Definition |
H_EXIT_INTV_FORM Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EXIT_FORM_ID![]() |
VARCHAR2(12) | NO | ||
EXIT_FORM_DESC | VARCHAR2(30) | NO | ||
PERS_ACT_RSN_CD | VARCHAR2(10) | NO | ||
EMPL_SSN_FL | VARCHAR2(1) | NO | ||
EMPL_MAN_FL | VARCHAR2(1) | NO | ||
EMPL_HRLY_FL | VARCHAR2(1) | NO | ||
EMPL_SUP_FL | VARCHAR2(1) | NO | ||
EMPL_TIT_FL | VARCHAR2(1) | NO | ||
EMPL_ORG_FL | VARCHAR2(1) | NO | ||
EMPL_LOC_FL | VARCHAR2(1) | NO | ||
EMPL_ANNL_FL | VARCHAR2(1) | NO | ||
SIGN_OFF1_S | VARCHAR2(20) | NO | ||
SIGN_OFF2_S | VARCHAR2(20) | NO | ||
SIGN_OFF3_S | VARCHAR2(20) | NO | ||
SIGN_OFF4_S | VARCHAR2(20) | NO | ||
SIGN_OFF5_S | VARCHAR2(20) | NO | ||
SIGN_OFF6_S | VARCHAR2(20) | NO | ||
SIGN_OFF7_S | VARCHAR2(20) | NO | ||
SIGN_OFF8_S | VARCHAR2(20) | NO | ||
SIGN_OFF9_S | VARCHAR2(20) | NO | ||
SIGN_OFF10_S | VARCHAR2(20) | NO | ||
SIGN_HEAD_NT | VARCHAR2(254) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
H_EXIT_INTV_FORM Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6265 | PrimaryKey | EXIT_FORM_ID |
H_EXIT_INTV_FORM 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 |
H_EMPL_EXIT_INTV | Non-Identifying | One To Zero or More | F20440 | NO | NO | NO | |||
H_EMPL_S2_HDR_SEC | Non-Identifying | One To Zero or More | F20451 | NO | NO | NO | |||
H_EMPL_S3_HDR_COMP | Non-Identifying | One To Zero or More | F20454 | NO | NO | NO | |||
H_EMPL_S4_HDR_LV | Non-Identifying | One To Zero or More | F20457 | NO | NO | NO | |||
H_EMPL_S5_HDR_AMT | Non-Identifying | One To Zero or More | F20460 | NO | NO | NO | |||
H_EMPL_S6_COMMENTS | Non-Identifying | One To Zero or More | F20463 | NO | NO | NO | |||
H_SECT1_EMPL_EXIT | Non-Identifying | One To Zero or More | F20491 | NO | NO | NO | |||
H_SECT2_HDR_SEC | Identifying | One To Zero or More | F20493 | NO | NO | NO | |||
H_SECT3_HDR_COMP | Identifying | One To Zero or More | F20495 | NO | NO | NO | |||
H_SECT4_HDR_LV | Identifying | One To Zero or More | F20497 | NO | NO | NO | |||
H_SECT5_HDR_AMT | Identifying | One To Zero or More | F20500 | NO | NO | NO | |||
H_SECT6_COMMENTS | Identifying | One To Zero or More | F20502 | NO | NO | NO |