"UTILIZATION to UDT01_TYPE" |
RelationshipType | Non-Identifying |
Relationship Name | F00001 |
Relationship Business Name | |
Parent Table | UTILIZATION |
Child Table | UDT01_TYPE |
Existence | Mandatory |
"UTILIZATION to UDT01_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UTILIZATION to UDT01_TYPE" Foreign Keys |
Parent Key | Child Key |
UTIL_CD | DFLT_UTIL_CD |
"UDT01_TYPE to UDT01" |
RelationshipType | Non-Identifying |
Relationship Name | F00002 |
Relationship Business Name | |
Parent Table | UDT01_TYPE |
Child Table | UDT01 |
Existence | Mandatory |
"UDT01_TYPE to UDT01" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01_TYPE to UDT01" Foreign Keys |
Parent Key | Child Key |
UDT01_TYPE_CD | UDT01_TYPE_CD |
"UDT10 to UDT10" |
RelationshipType | Non-Identifying |
Relationship Name | F00003 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | UDT10 |
Existence | Optional |
"UDT10 to UDT10" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to UDT10" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | OT_UDT10_ID |
"CHARGE to CHARGE_BRANCH" |
RelationshipType | Identifying |
Relationship Name | F00004 |
Relationship Business Name | |
Parent Table | CHARGE |
Child Table | CHARGE_BRANCH |
Existence | Mandatory |
"CHARGE to CHARGE_BRANCH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE to CHARGE_BRANCH" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD | CHARGE_TREE_CD |
"CHARGE_BRANCH to CHARGE_BRANCH" |
RelationshipType | Non-Identifying |
Relationship Name | F00005 |
Relationship Business Name | |
Parent Table | CHARGE_BRANCH |
Child Table | CHARGE_BRANCH |
Existence | Optional |
"CHARGE_BRANCH to CHARGE_BRANCH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE_BRANCH to CHARGE_BRANCH" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD, CHARGE_BRANCH_CD | CHARGE_TREE_CD, PARENT_CHARGE_BRANCH_CD |
"CHARGE_BRANCH to CHARGE_BRANCH_CHARGE" |
RelationshipType | Identifying |
Relationship Name | F00006 |
Relationship Business Name | |
Parent Table | CHARGE_BRANCH |
Child Table | CHARGE_BRANCH_CHARGE |
Existence | Mandatory |
"CHARGE_BRANCH to CHARGE_BRANCH_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE_BRANCH to CHARGE_BRANCH_CHARGE" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD, CHARGE_BRANCH_CD | CHARGE_TREE_CD, CHARGE_BRANCH_CD |
"CLASS to CLASS_UDT10" |
RelationshipType | Identifying |
Relationship Name | F00007 |
Relationship Business Name | |
Parent Table | CLASS |
Child Table | CLASS_UDT10 |
Existence | Mandatory |
"CLASS to CLASS_UDT10" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CLASS to CLASS_UDT10" Foreign Keys |
Parent Key | Child Key |
CLASS_CD | CLASS_CD |
"UDT10 to CLASS_UDT10" |
RelationshipType | Identifying |
Relationship Name | F00008 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | CLASS_UDT10 |
Existence | Mandatory |
"UDT10 to CLASS_UDT10" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to CLASS_UDT10" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | UDT10_ID |
"LANGUAGE to COMPANY" |
RelationshipType | Non-Identifying |
Relationship Name | F00009 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | COMPANY |
Existence | Mandatory |
"LANGUAGE to COMPANY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to COMPANY" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | DFLT_COUNTRY_CD, DFLT_LANGUAGE_CD |
"TS_SCHEDULE to TS_SCHEDULE_PERIOD" |
RelationshipType | Identifying |
Relationship Name | F00010 |
Relationship Business Name | |
Parent Table | TS_SCHEDULE |
Child Table | TS_SCHEDULE_PERIOD |
Existence | Mandatory |
"TS_SCHEDULE to TS_SCHEDULE_PERIOD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS_SCHEDULE to TS_SCHEDULE_PERIOD" Foreign Keys |
Parent Key | Child Key |
TS_SCHEDULE_CD | TS_SCHEDULE_CD |
"WORK_SCHEDULE to WORK_SCHEDULE_DATE" |
RelationshipType | Identifying |
Relationship Name | F00011 |
Relationship Business Name | |
Parent Table | WORK_SCHEDULE |
Child Table | WORK_SCHEDULE_DATE |
Existence | Mandatory |
"WORK_SCHEDULE to WORK_SCHEDULE_DATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WORK_SCHEDULE to WORK_SCHEDULE_DATE" Foreign Keys |
Parent Key | Child Key |
WORK_SCHEDULE_CD | WORK_SCHEDULE_CD |
"ROLE to EMPL" |
RelationshipType | Non-Identifying |
Relationship Name | F00025 |
Relationship Business Name | |
Parent Table | ROLE |
Child Table | EMPL |
Existence | Mandatory |
"ROLE to EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ROLE to EMPL" Foreign Keys |
Parent Key | Child Key |
ROLE_CD | ROLE_CD |
"EMPL_GROUP_TYPE to EMPL_GROUP" |
RelationshipType | Non-Identifying |
Relationship Name | F00026 |
Relationship Business Name | |
Parent Table | EMPL_GROUP_TYPE |
Child Table | EMPL_GROUP |
Existence | Mandatory |
"EMPL_GROUP_TYPE to EMPL_GROUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL_GROUP_TYPE to EMPL_GROUP" Foreign Keys |
Parent Key | Child Key |
EMPL_GROUP_TYPE_CD | EMPL_GROUP_TYPE_CD |
"EMPL_GROUP to EMPL_GROUP_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00027 |
Relationship Business Name | |
Parent Table | EMPL_GROUP |
Child Table | EMPL_GROUP_EMPL |
Existence | Mandatory |
"EMPL_GROUP to EMPL_GROUP_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL_GROUP to EMPL_GROUP_EMPL" Foreign Keys |
Parent Key | Child Key |
EMPL_GROUP_CD | EMPL_GROUP_CD |
"EMPL to EMPL_GROUP_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00028 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_GROUP_EMPL |
Existence | Mandatory |
"EMPL to EMPL_GROUP_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_GROUP_EMPL" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EMPL_GROUP to EMPL_GROUP_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00029 |
Relationship Business Name | |
Parent Table | EMPL_GROUP |
Child Table | EMPL_GROUP_SPVSR |
Existence | Mandatory |
"EMPL_GROUP to EMPL_GROUP_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL_GROUP to EMPL_GROUP_SPVSR" Foreign Keys |
Parent Key | Child Key |
EMPL_GROUP_CD | EMPL_GROUP_CD |
"EMPL to EMPL_GROUP_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00030 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_GROUP_SPVSR |
Existence | Mandatory |
"EMPL to EMPL_GROUP_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_GROUP_SPVSR" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | SPVSR_EMPL_ID |
"EMPL to EMPL_HISTORY" |
RelationshipType | Identifying |
Relationship Name | F00031 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_HISTORY |
Existence | Mandatory |
"EMPL to EMPL_HISTORY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_HISTORY" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"WORK_SCHEDULE to EMPL_HISTORY" |
RelationshipType | Non-Identifying |
Relationship Name | F00032 |
Relationship Business Name | |
Parent Table | WORK_SCHEDULE |
Child Table | EMPL_HISTORY |
Existence | Mandatory |
"WORK_SCHEDULE to EMPL_HISTORY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WORK_SCHEDULE to EMPL_HISTORY" Foreign Keys |
Parent Key | Child Key |
WORK_SCHEDULE_CD | WORK_SCHEDULE_CD |
"CLASS to EMPL_HISTORY" |
RelationshipType | Non-Identifying |
Relationship Name | F00033 |
Relationship Business Name | |
Parent Table | CLASS |
Child Table | EMPL_HISTORY |
Existence | Mandatory |
"CLASS to EMPL_HISTORY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CLASS to EMPL_HISTORY" Foreign Keys |
Parent Key | Child Key |
CLASS_CD | CLASS_CD |
"TS_SCHEDULE to EMPL_HISTORY" |
RelationshipType | Non-Identifying |
Relationship Name | F00034 |
Relationship Business Name | |
Parent Table | TS_SCHEDULE |
Child Table | EMPL_HISTORY |
Existence | Mandatory |
"TS_SCHEDULE to EMPL_HISTORY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS_SCHEDULE to EMPL_HISTORY" Foreign Keys |
Parent Key | Child Key |
TS_SCHEDULE_CD | TS_SCHEDULE_CD |
"EMPL to EMPL_PREFERENCE" |
RelationshipType | Identifying |
Relationship Name | F00036 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_PREFERENCE |
Existence | Mandatory |
"EMPL to EMPL_PREFERENCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_PREFERENCE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"LANGUAGE to EMPL_PREFERENCE" |
RelationshipType | Non-Identifying |
Relationship Name | F00037 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | EMPL_PREFERENCE |
Existence | Mandatory |
"LANGUAGE to EMPL_PREFERENCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to EMPL_PREFERENCE" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"EMPL to TS" |
RelationshipType | Identifying |
Relationship Name | F00038 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | TS |
Existence | Mandatory |
"EMPL to TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to TS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"TS_SCHEDULE_PERIOD to TS" |
RelationshipType | Identifying |
Relationship Name | F00039 |
Relationship Business Name | |
Parent Table | TS_SCHEDULE_PERIOD |
Child Table | TS |
Existence | Mandatory |
"TS_SCHEDULE_PERIOD to TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS_SCHEDULE_PERIOD to TS" Foreign Keys |
Parent Key | Child Key |
TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"CLASS to TS" |
RelationshipType | Non-Identifying |
Relationship Name | F00040 |
Relationship Business Name | |
Parent Table | CLASS |
Child Table | TS |
Existence | Mandatory |
"CLASS to TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CLASS to TS" Foreign Keys |
Parent Key | Child Key |
CLASS_CD | CLASS_CD |
"WORK_SCHEDULE to TS" |
RelationshipType | Non-Identifying |
Relationship Name | F00041 |
Relationship Business Name | |
Parent Table | WORK_SCHEDULE |
Child Table | TS |
Existence | Mandatory |
"WORK_SCHEDULE to TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WORK_SCHEDULE to TS" Foreign Keys |
Parent Key | Child Key |
WORK_SCHEDULE_CD | WORK_SCHEDULE_CD |
"TS to TS_REVISION" |
RelationshipType | Identifying |
Relationship Name | F00042 |
Relationship Business Name | |
Parent Table | TS |
Child Table | TS_REVISION |
Existence | Mandatory |
"TS to TS_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS to TS_REVISION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"EMPL to TS_REVISION" |
RelationshipType | Non-Identifying |
Relationship Name | F00043 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | TS_REVISION |
Existence | Optional |
"EMPL to TS_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to TS_REVISION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | SIGN_EMPL_ID |
"EMPL to TS_REVISION" |
RelationshipType | Non-Identifying |
Relationship Name | F00044 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | TS_REVISION |
Existence | Optional |
"EMPL to TS_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to TS_REVISION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | APPROVE_EMPL_ID |
"TS to TS_LINE" |
RelationshipType | Identifying |
Relationship Name | F00045 |
Relationship Business Name | |
Parent Table | TS |
Child Table | TS_LINE |
Existence | Mandatory |
"TS to TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS to TS_LINE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"TS_LINE to TS_CELL" |
RelationshipType | Identifying |
Relationship Name | F00046 |
Relationship Business Name | |
Parent Table | TS_LINE |
Child Table | TS_CELL |
Existence | Mandatory |
"TS_LINE to TS_CELL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS_LINE to TS_CELL" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO |
"TS_REVISION to TS_AUDIT" |
RelationshipType | Identifying |
Relationship Name | F00047 |
Relationship Business Name | |
Parent Table | TS_REVISION |
Child Table | TS_AUDIT |
Existence | Mandatory |
"TS_REVISION to TS_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS_REVISION to TS_AUDIT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, REVISION_NO | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, REVISION_NO |
"EMPL to TS_AUDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00048 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | TS_AUDIT |
Existence | Mandatory |
"EMPL to TS_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to TS_AUDIT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | REVISION_EMPL_ID |
"TS_CELL to TS_AUDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00049 |
Relationship Business Name | |
Parent Table | TS_CELL |
Child Table | TS_AUDIT |
Existence | Optional |
"TS_CELL to TS_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS_CELL to TS_AUDIT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO, HRS_DT | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO, HRS_DT |
"UDT01 to LINK12" |
RelationshipType | Identifying |
Relationship Name | F00050 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | LINK12 |
Existence | Mandatory |
"UDT01 to LINK12" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to LINK12" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"UDT02 to LINK12" |
RelationshipType | Identifying |
Relationship Name | F00051 |
Relationship Business Name | |
Parent Table | UDT02 |
Child Table | LINK12 |
Existence | Mandatory |
"UDT02 to LINK12" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT02 to LINK12" Foreign Keys |
Parent Key | Child Key |
UDT02_ID | UDT02_ID |
"UDT01 to LINK19" |
RelationshipType | Identifying |
Relationship Name | F00052 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | LINK19 |
Existence | Mandatory |
"UDT01 to LINK19" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to LINK19" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"UDT09 to LINK19" |
RelationshipType | Identifying |
Relationship Name | F00053 |
Relationship Business Name | |
Parent Table | UDT09 |
Child Table | LINK19 |
Existence | Mandatory |
"UDT09 to LINK19" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT09 to LINK19" Foreign Keys |
Parent Key | Child Key |
UDT09_ID | UDT09_ID |
"UDT01 to LINK17" |
RelationshipType | Identifying |
Relationship Name | F00054 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | LINK17 |
Existence | Mandatory |
"UDT01 to LINK17" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to LINK17" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"UDT07 to LINK17" |
RelationshipType | Identifying |
Relationship Name | F00055 |
Relationship Business Name | |
Parent Table | UDT07 |
Child Table | LINK17 |
Existence | Mandatory |
"UDT07 to LINK17" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT07 to LINK17" Foreign Keys |
Parent Key | Child Key |
UDT07_ID, CP_COMPANY_CD | UDT07_ID, CP_COMPANY_CD |
"UDT02 to LINK27" |
RelationshipType | Identifying |
Relationship Name | F00056 |
Relationship Business Name | |
Parent Table | UDT02 |
Child Table | LINK27 |
Existence | Mandatory |
"UDT02 to LINK27" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT02 to LINK27" Foreign Keys |
Parent Key | Child Key |
UDT02_ID | UDT02_ID |
"UDT07 to LINK27" |
RelationshipType | Identifying |
Relationship Name | F00057 |
Relationship Business Name | |
Parent Table | UDT07 |
Child Table | LINK27 |
Existence | Mandatory |
"UDT07 to LINK27" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT07 to LINK27" Foreign Keys |
Parent Key | Child Key |
UDT07_ID, CP_COMPANY_CD | UDT07_ID, CP_COMPANY_CD |
"UDT02 to LINK29" |
RelationshipType | Identifying |
Relationship Name | F00058 |
Relationship Business Name | |
Parent Table | UDT02 |
Child Table | LINK29 |
Existence | Mandatory |
"UDT02 to LINK29" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT02 to LINK29" Foreign Keys |
Parent Key | Child Key |
UDT02_ID | UDT02_ID |
"UDT09 to LINK29" |
RelationshipType | Identifying |
Relationship Name | F00059 |
Relationship Business Name | |
Parent Table | UDT09 |
Child Table | LINK29 |
Existence | Mandatory |
"UDT09 to LINK29" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT09 to LINK29" Foreign Keys |
Parent Key | Child Key |
UDT09_ID | UDT09_ID |
"UDT09 to LINK93" |
RelationshipType | Identifying |
Relationship Name | F00060 |
Relationship Business Name | |
Parent Table | UDT09 |
Child Table | LINK93 |
Existence | Mandatory |
"UDT09 to LINK93" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT09 to LINK93" Foreign Keys |
Parent Key | Child Key |
UDT09_ID | UDT09_ID |
"UDT03 to LINK93" |
RelationshipType | Identifying |
Relationship Name | F00061 |
Relationship Business Name | |
Parent Table | UDT03 |
Child Table | LINK93 |
Existence | Mandatory |
"UDT03 to LINK93" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT03 to LINK93" Foreign Keys |
Parent Key | Child Key |
UDT03_ID | UDT03_ID |
"EMPL to EMPL_CHARGE_FAVORITES" |
RelationshipType | Identifying |
Relationship Name | F00062 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_CHARGE_FAVORITES |
Existence | Mandatory |
"EMPL to EMPL_CHARGE_FAVORITES" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_CHARGE_FAVORITES" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"CHARGE_BRANCH_CHARGE to EMPL_CHARGE_FAVORITES" |
RelationshipType | Identifying |
Relationship Name | F00063 |
Relationship Business Name | |
Parent Table | CHARGE_BRANCH_CHARGE |
Child Table | EMPL_CHARGE_FAVORITES |
Existence | Mandatory |
"CHARGE_BRANCH_CHARGE to EMPL_CHARGE_FAVORITES" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE_BRANCH_CHARGE to EMPL_CHARGE_FAVORITES" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD | CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD |
"SCREENS to SCREENS" |
RelationshipType | Non-Identifying |
Relationship Name | F00064 |
Relationship Business Name | |
Parent Table | SCREENS |
Child Table | SCREENS |
Existence | Optional |
"SCREENS to SCREENS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCREENS to SCREENS" Foreign Keys |
Parent Key | Child Key |
SCREEN_CD | PARENT_SCREEN_CD |
"UDT01 to TS_LINE" |
RelationshipType | Non-Identifying |
Relationship Name | F00065 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | TS_LINE |
Existence | Mandatory |
"UDT01 to TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to TS_LINE" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"UDT10 to TS_LINE" |
RelationshipType | Non-Identifying |
Relationship Name | F00066 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | TS_LINE |
Existence | Mandatory |
"UDT10 to TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to TS_LINE" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | UDT10_ID |
"UDT07 to LINK17_WILDCARD" |
RelationshipType | Identifying |
Relationship Name | F00067 |
Relationship Business Name | |
Parent Table | UDT07 |
Child Table | LINK17_WILDCARD |
Existence | Mandatory |
"UDT07 to LINK17_WILDCARD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT07 to LINK17_WILDCARD" Foreign Keys |
Parent Key | Child Key |
UDT07_ID, CP_COMPANY_CD | UDT07_ID, CP_COMPANY_CD |
"UDT07 to LINK27_WILDCARD" |
RelationshipType | Identifying |
Relationship Name | F00068 |
Relationship Business Name | |
Parent Table | UDT07 |
Child Table | LINK27_WILDCARD |
Existence | Mandatory |
"UDT07 to LINK27_WILDCARD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT07 to LINK27_WILDCARD" Foreign Keys |
Parent Key | Child Key |
UDT07_ID, CP_COMPANY_CD | UDT07_ID, CP_COMPANY_CD |
"UDT03 to LINK93_WILDCARD" |
RelationshipType | Identifying |
Relationship Name | F00069 |
Relationship Business Name | |
Parent Table | UDT03 |
Child Table | LINK93_WILDCARD |
Existence | Mandatory |
"UDT03 to LINK93_WILDCARD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT03 to LINK93_WILDCARD" Foreign Keys |
Parent Key | Child Key |
UDT03_ID | UDT03_ID |
"CHARGE_BRANCH_CHARGE to CHARGE_BRANCH_CHARGE_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00070 |
Relationship Business Name | |
Parent Table | CHARGE_BRANCH_CHARGE |
Child Table | CHARGE_BRANCH_CHARGE_EMPL |
Existence | Mandatory |
"CHARGE_BRANCH_CHARGE to CHARGE_BRANCH_CHARGE_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE_BRANCH_CHARGE to CHARGE_BRANCH_CHARGE_EMPL" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD | CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD |
"EMPL to CHARGE_BRANCH_CHARGE_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00071 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CHARGE_BRANCH_CHARGE_EMPL |
Existence | Mandatory |
"EMPL to CHARGE_BRANCH_CHARGE_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CHARGE_BRANCH_CHARGE_EMPL" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"CHARGE_BRANCH to CHARGE_BRANCH_EMPL_GROUP" |
RelationshipType | Identifying |
Relationship Name | F00072 |
Relationship Business Name | |
Parent Table | CHARGE_BRANCH |
Child Table | CHARGE_BRANCH_EMPL_GROUP |
Existence | Mandatory |
"CHARGE_BRANCH to CHARGE_BRANCH_EMPL_GROUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE_BRANCH to CHARGE_BRANCH_EMPL_GROUP" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD, CHARGE_BRANCH_CD | CHARGE_TREE_CD, CHARGE_BRANCH_CD |
"EMPL_GROUP to CHARGE_BRANCH_EMPL_GROUP" |
RelationshipType | Identifying |
Relationship Name | F00073 |
Relationship Business Name | |
Parent Table | EMPL_GROUP |
Child Table | CHARGE_BRANCH_EMPL_GROUP |
Existence | Mandatory |
"EMPL_GROUP to CHARGE_BRANCH_EMPL_GROUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL_GROUP to CHARGE_BRANCH_EMPL_GROUP" Foreign Keys |
Parent Key | Child Key |
EMPL_GROUP_CD | EMPL_GROUP_CD |
"CHARGE to CHARGE_EMPL_GROUP" |
RelationshipType | Identifying |
Relationship Name | F00074 |
Relationship Business Name | |
Parent Table | CHARGE |
Child Table | CHARGE_EMPL_GROUP |
Existence | Mandatory |
"CHARGE to CHARGE_EMPL_GROUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE to CHARGE_EMPL_GROUP" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD | CHARGE_TREE_CD |
"EMPL_GROUP to CHARGE_EMPL_GROUP" |
RelationshipType | Identifying |
Relationship Name | F00075 |
Relationship Business Name | |
Parent Table | EMPL_GROUP |
Child Table | CHARGE_EMPL_GROUP |
Existence | Mandatory |
"EMPL_GROUP to CHARGE_EMPL_GROUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL_GROUP to CHARGE_EMPL_GROUP" Foreign Keys |
Parent Key | Child Key |
EMPL_GROUP_CD | EMPL_GROUP_CD |
"CLASS to CLASS_LEAVE" |
RelationshipType | Identifying |
Relationship Name | F00076 |
Relationship Business Name | |
Parent Table | CLASS |
Child Table | CLASS_LEAVE |
Existence | Mandatory |
"CLASS to CLASS_LEAVE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CLASS to CLASS_LEAVE" Foreign Keys |
Parent Key | Child Key |
CLASS_CD | CLASS_CD |
"LEAVE_TYPE to CLASS_LEAVE" |
RelationshipType | Identifying |
Relationship Name | F00077 |
Relationship Business Name | |
Parent Table | LEAVE_TYPE |
Child Table | CLASS_LEAVE |
Existence | Mandatory |
"LEAVE_TYPE to CLASS_LEAVE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LEAVE_TYPE to CLASS_LEAVE" Foreign Keys |
Parent Key | Child Key |
LEAVE_TYPE_CD | LEAVE_TYPE_CD |
"EMPL to EMPL_LEAVE" |
RelationshipType | Identifying |
Relationship Name | F00078 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_LEAVE |
Existence | Mandatory |
"EMPL to EMPL_LEAVE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_LEAVE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"LEAVE_TYPE to EMPL_LEAVE" |
RelationshipType | Identifying |
Relationship Name | F00079 |
Relationship Business Name | |
Parent Table | LEAVE_TYPE |
Child Table | EMPL_LEAVE |
Existence | Mandatory |
"LEAVE_TYPE to EMPL_LEAVE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LEAVE_TYPE to EMPL_LEAVE" Foreign Keys |
Parent Key | Child Key |
LEAVE_TYPE_CD | LEAVE_TYPE_CD |
"LEAVE_TYPE to LEAVE_TYPE_UDT" |
RelationshipType | Identifying |
Relationship Name | F00080 |
Relationship Business Name | |
Parent Table | LEAVE_TYPE |
Child Table | LEAVE_TYPE_UDT |
Existence | Mandatory |
"LEAVE_TYPE to LEAVE_TYPE_UDT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LEAVE_TYPE to LEAVE_TYPE_UDT" Foreign Keys |
Parent Key | Child Key |
LEAVE_TYPE_CD | LEAVE_TYPE_CD |
"EVENT to EVENT_NOTIFICATION" |
RelationshipType | Identifying |
Relationship Name | F00085 |
Relationship Business Name | |
Parent Table | EVENT |
Child Table | EVENT_NOTIFICATION |
Existence | Mandatory |
"EVENT to EVENT_NOTIFICATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EVENT to EVENT_NOTIFICATION" Foreign Keys |
Parent Key | Child Key |
EVENT_CD | EVENT_CD |
"CLASS to CLASS_EVENT" |
RelationshipType | Identifying |
Relationship Name | F00086 |
Relationship Business Name | |
Parent Table | CLASS |
Child Table | CLASS_EVENT |
Existence | Mandatory |
"CLASS to CLASS_EVENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CLASS to CLASS_EVENT" Foreign Keys |
Parent Key | Child Key |
CLASS_CD | CLASS_CD |
"EVENT to CLASS_EVENT" |
RelationshipType | Identifying |
Relationship Name | F00087 |
Relationship Business Name | |
Parent Table | EVENT |
Child Table | CLASS_EVENT |
Existence | Mandatory |
"EVENT to CLASS_EVENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EVENT to CLASS_EVENT" Foreign Keys |
Parent Key | Child Key |
EVENT_CD | EVENT_CD |
"EVENT to DESKTOP_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00089 |
Relationship Business Name | |
Parent Table | EVENT |
Child Table | DESKTOP_TASKS |
Existence | Mandatory |
"EVENT to DESKTOP_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EVENT to DESKTOP_TASKS" Foreign Keys |
Parent Key | Child Key |
EVENT_CD | EVENT_CD |
"EMPL to DESKTOP_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00090 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_TASKS |
Existence | Mandatory |
"EMPL to DESKTOP_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_TASKS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EVENT to DESKTOP_ALERTS" |
RelationshipType | Identifying |
Relationship Name | F00091 |
Relationship Business Name | |
Parent Table | EVENT |
Child Table | DESKTOP_ALERTS |
Existence | Mandatory |
"EVENT to DESKTOP_ALERTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EVENT to DESKTOP_ALERTS" Foreign Keys |
Parent Key | Child Key |
EVENT_CD | EVENT_CD |
"EMPL to DESKTOP_ALERTS" |
RelationshipType | Identifying |
Relationship Name | F00092 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_ALERTS |
Existence | Mandatory |
"EMPL to DESKTOP_ALERTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_ALERTS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EMPL to EMPL_MENU" |
RelationshipType | Identifying |
Relationship Name | F00094 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_MENU |
Existence | Mandatory |
"EMPL to EMPL_MENU" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_MENU" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"SCREENS to EMPL_MENU" |
RelationshipType | Identifying |
Relationship Name | F00095 |
Relationship Business Name | |
Parent Table | SCREENS |
Child Table | EMPL_MENU |
Existence | Mandatory |
"SCREENS to EMPL_MENU" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCREENS to EMPL_MENU" Foreign Keys |
Parent Key | Child Key |
SCREEN_CD | SCREEN_CD |
"EMPL to EMPL_DESKTOP_LEFT" |
RelationshipType | Identifying |
Relationship Name | F00096 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_DESKTOP_LEFT |
Existence | Mandatory |
"EMPL to EMPL_DESKTOP_LEFT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_DESKTOP_LEFT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"DESKTOP to EMPL_DESKTOP_LEFT" |
RelationshipType | Identifying |
Relationship Name | F00097 |
Relationship Business Name | |
Parent Table | DESKTOP |
Child Table | EMPL_DESKTOP_LEFT |
Existence | Mandatory |
"DESKTOP to EMPL_DESKTOP_LEFT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DESKTOP to EMPL_DESKTOP_LEFT" Foreign Keys |
Parent Key | Child Key |
DESKTOP_CD | DESKTOP_CD |
"EMPL to EMPL_DESKTOP_RIGHT" |
RelationshipType | Identifying |
Relationship Name | F00098 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_DESKTOP_RIGHT |
Existence | Mandatory |
"EMPL to EMPL_DESKTOP_RIGHT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_DESKTOP_RIGHT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"DESKTOP to EMPL_DESKTOP_RIGHT" |
RelationshipType | Identifying |
Relationship Name | F00099 |
Relationship Business Name | |
Parent Table | DESKTOP |
Child Table | EMPL_DESKTOP_RIGHT |
Existence | Mandatory |
"DESKTOP to EMPL_DESKTOP_RIGHT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DESKTOP to EMPL_DESKTOP_RIGHT" Foreign Keys |
Parent Key | Child Key |
DESKTOP_CD | DESKTOP_CD |
"TS to TS_DAY" |
RelationshipType | Identifying |
Relationship Name | F00100 |
Relationship Business Name | |
Parent Table | TS |
Child Table | TS_DAY |
Existence | Mandatory |
"TS to TS_DAY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS to TS_DAY" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"TS to TS_INVOICE" |
RelationshipType | Identifying |
Relationship Name | F00101 |
Relationship Business Name | |
Parent Table | TS |
Child Table | TS_INVOICE |
Existence | Mandatory |
"TS to TS_INVOICE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS to TS_INVOICE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"FUNCTIONAL_ROLE to EMPL_GROUP_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00102 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | EMPL_GROUP_SPVSR |
Existence | Mandatory |
"FUNCTIONAL_ROLE to EMPL_GROUP_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to EMPL_GROUP_SPVSR" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to TS_LINE" |
RelationshipType | Non-Identifying |
Relationship Name | F00103 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | TS_LINE |
Existence | Optional |
"EMPL to TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to TS_LINE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | APPROVE_REJECT_EMPL_ID |
"FUNCTIONAL_ROLE to EVENT" |
RelationshipType | Non-Identifying |
Relationship Name | F00104 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | EVENT |
Existence | Mandatory |
"FUNCTIONAL_ROLE to EVENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to EVENT" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"FUNCTIONAL_ROLE to EVENT_NOTIFICATION" |
RelationshipType | Identifying |
Relationship Name | F00105 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | EVENT_NOTIFICATION |
Existence | Mandatory |
"FUNCTIONAL_ROLE to EVENT_NOTIFICATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to EVENT_NOTIFICATION" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"UDT01 to UDT01_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00106 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | UDT01_SPVSR |
Existence | Mandatory |
"UDT01 to UDT01_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to UDT01_SPVSR" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"EMPL to UDT01_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00107 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | UDT01_SPVSR |
Existence | Mandatory |
"EMPL to UDT01_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to UDT01_SPVSR" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | SPVSR_EMPL_ID |
"FUNCTIONAL_ROLE to UDT01_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00108 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | UDT01_SPVSR |
Existence | Mandatory |
"FUNCTIONAL_ROLE to UDT01_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to UDT01_SPVSR" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"UDT02 to UDT02_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00109 |
Relationship Business Name | |
Parent Table | UDT02 |
Child Table | UDT02_SPVSR |
Existence | Mandatory |
"UDT02 to UDT02_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT02 to UDT02_SPVSR" Foreign Keys |
Parent Key | Child Key |
UDT02_ID | UDT02_ID |
"EMPL to UDT02_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00110 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | UDT02_SPVSR |
Existence | Mandatory |
"EMPL to UDT02_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to UDT02_SPVSR" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | SPVSR_EMPL_ID |
"FUNCTIONAL_ROLE to UDT02_SPVSR" |
RelationshipType | Identifying |
Relationship Name | F00111 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | UDT02_SPVSR |
Existence | Mandatory |
"FUNCTIONAL_ROLE to UDT02_SPVSR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to UDT02_SPVSR" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"FUNCTIONAL_ROLE to DESKTOP_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00112 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_TASKS |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_TASKS" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"FUNCTIONAL_ROLE to DESKTOP_ALERTS" |
RelationshipType | Identifying |
Relationship Name | F00113 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_ALERTS |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_ALERTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_ALERTS" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to EMPL_ACCESS" |
RelationshipType | Identifying |
Relationship Name | F00114 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_ACCESS |
Existence | Mandatory |
"EMPL to EMPL_ACCESS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_ACCESS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"COMPANY to COMPANY_ACCESS" |
RelationshipType | Identifying |
Relationship Name | F00115 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | COMPANY_ACCESS |
Existence | Mandatory |
"COMPANY to COMPANY_ACCESS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to COMPANY_ACCESS" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"COMPANY to GENERAL_CONFIG" |
RelationshipType | Identifying |
Relationship Name | F00116 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | GENERAL_CONFIG |
Existence | Mandatory |
"COMPANY to GENERAL_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to GENERAL_CONFIG" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"CURRENCY to GENERAL_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00117 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | GENERAL_CONFIG |
Existence | Mandatory |
"CURRENCY to GENERAL_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to GENERAL_CONFIG" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | DFLT_CURRENCY_CD |
"UDT01_TYPE to GENERAL_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00118 |
Relationship Business Name | |
Parent Table | UDT01_TYPE |
Child Table | GENERAL_CONFIG |
Existence | Mandatory |
"UDT01_TYPE to GENERAL_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01_TYPE to GENERAL_CONFIG" Foreign Keys |
Parent Key | Child Key |
UDT01_TYPE_CD | DFLT_UDT01_TYPE_CD |
"ROLE to GENERAL_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00119 |
Relationship Business Name | |
Parent Table | ROLE |
Child Table | GENERAL_CONFIG |
Existence | Mandatory |
"ROLE to GENERAL_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ROLE to GENERAL_CONFIG" Foreign Keys |
Parent Key | Child Key |
ROLE_CD | DFLT_ROLE_CD |
"COMPANY to GENERAL_CONFIG_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00120 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | GENERAL_CONFIG_LABELS |
Existence | Mandatory |
"COMPANY to GENERAL_CONFIG_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to GENERAL_CONFIG_LABELS" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"LANGUAGE to GENERAL_CONFIG_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00121 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | GENERAL_CONFIG_LABELS |
Existence | Mandatory |
"LANGUAGE to GENERAL_CONFIG_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to GENERAL_CONFIG_LABELS" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"GENERAL_CONFIG to GENERAL_CONFIG_UDT" |
RelationshipType | Identifying |
Relationship Name | F00122 |
Relationship Business Name | |
Parent Table | GENERAL_CONFIG |
Child Table | GENERAL_CONFIG_UDT |
Existence | Mandatory |
"GENERAL_CONFIG to GENERAL_CONFIG_UDT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GENERAL_CONFIG to GENERAL_CONFIG_UDT" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"GENERAL_CONFIG_UDT to GENERAL_CONFIG_UDT_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00123 |
Relationship Business Name | |
Parent Table | GENERAL_CONFIG_UDT |
Child Table | GENERAL_CONFIG_UDT_LABELS |
Existence | Mandatory |
"GENERAL_CONFIG_UDT to GENERAL_CONFIG_UDT_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GENERAL_CONFIG_UDT to GENERAL_CONFIG_UDT_LABELS" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID, S_UDT_CD | COMPANY_ID, S_UDT_CD |
"LANGUAGE to GENERAL_CONFIG_UDT_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00124 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | GENERAL_CONFIG_UDT_LABELS |
Existence | Mandatory |
"LANGUAGE to GENERAL_CONFIG_UDT_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to GENERAL_CONFIG_UDT_LABELS" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"COMPANY to TIME_CONFIG" |
RelationshipType | Identifying |
Relationship Name | F00125 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | TIME_CONFIG |
Existence | Mandatory |
"COMPANY to TIME_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to TIME_CONFIG" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"TS_SCHEDULE to TIME_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00126 |
Relationship Business Name | |
Parent Table | TS_SCHEDULE |
Child Table | TIME_CONFIG |
Existence | Mandatory |
"TS_SCHEDULE to TIME_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS_SCHEDULE to TIME_CONFIG" Foreign Keys |
Parent Key | Child Key |
TS_SCHEDULE_CD | DFLT_TS_SCHEDULE_CD |
"WORK_SCHEDULE to TIME_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00127 |
Relationship Business Name | |
Parent Table | WORK_SCHEDULE |
Child Table | TIME_CONFIG |
Existence | Mandatory |
"WORK_SCHEDULE to TIME_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WORK_SCHEDULE to TIME_CONFIG" Foreign Keys |
Parent Key | Child Key |
WORK_SCHEDULE_CD | DFLT_WORK_SCHEDULE_CD |
"CLASS to TIME_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00128 |
Relationship Business Name | |
Parent Table | CLASS |
Child Table | TIME_CONFIG |
Existence | Mandatory |
"CLASS to TIME_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CLASS to TIME_CONFIG" Foreign Keys |
Parent Key | Child Key |
CLASS_CD | DFLT_CLASS_CD |
"COMPANY to TIME_CONFIG_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00129 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | TIME_CONFIG_LABELS |
Existence | Mandatory |
"COMPANY to TIME_CONFIG_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to TIME_CONFIG_LABELS" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"LANGUAGE to TIME_CONFIG_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00130 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | TIME_CONFIG_LABELS |
Existence | Mandatory |
"LANGUAGE to TIME_CONFIG_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to TIME_CONFIG_LABELS" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"COMPANY to TIME_CONFIG_UDT" |
RelationshipType | Identifying |
Relationship Name | F00131 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | TIME_CONFIG_UDT |
Existence | Mandatory |
"COMPANY to TIME_CONFIG_UDT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to TIME_CONFIG_UDT" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"CURRENCY to EMPL" |
RelationshipType | Non-Identifying |
Relationship Name | F00132 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EMPL |
Existence | Mandatory |
"CURRENCY to EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EMPL" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | CURRENCY_CD |
"CP_COMPANY to LEAVE_TYPE" |
RelationshipType | Non-Identifying |
Relationship Name | F00133 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | LEAVE_TYPE |
Existence | Mandatory |
"CP_COMPANY to LEAVE_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to LEAVE_TYPE" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CP_COMPANY to UDT02" |
RelationshipType | Non-Identifying |
Relationship Name | F00134 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | UDT02 |
Existence | Mandatory |
"CP_COMPANY to UDT02" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to UDT02" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CP_COMPANY to UDT04" |
RelationshipType | Non-Identifying |
Relationship Name | F00135 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | UDT04 |
Existence | Mandatory |
"CP_COMPANY to UDT04" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to UDT04" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CP_COMPANY to UDT05" |
RelationshipType | Non-Identifying |
Relationship Name | F00136 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | UDT05 |
Existence | Mandatory |
"CP_COMPANY to UDT05" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to UDT05" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CP_COMPANY to UDT06" |
RelationshipType | Identifying |
Relationship Name | F00137 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | UDT06 |
Existence | Mandatory |
"CP_COMPANY to UDT06" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to UDT06" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CP_COMPANY to UDT07" |
RelationshipType | Identifying |
Relationship Name | F00138 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | UDT07 |
Existence | Mandatory |
"CP_COMPANY to UDT07" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to UDT07" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CP_COMPANY to UDT09" |
RelationshipType | Non-Identifying |
Relationship Name | F00139 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | UDT09 |
Existence | Mandatory |
"CP_COMPANY to UDT09" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to UDT09" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CP_COMPANY to EMPL_HISTORY" |
RelationshipType | Non-Identifying |
Relationship Name | F00140 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | EMPL_HISTORY |
Existence | Mandatory |
"CP_COMPANY to EMPL_HISTORY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to EMPL_HISTORY" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CP_COMPANY to TS" |
RelationshipType | Non-Identifying |
Relationship Name | F00141 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | TS |
Existence | Mandatory |
"CP_COMPANY to TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to TS" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"UDT05 to WAGE_SCHEDULE" |
RelationshipType | Identifying |
Relationship Name | F00144 |
Relationship Business Name | |
Parent Table | UDT05 |
Child Table | WAGE_SCHEDULE |
Existence | Mandatory |
"UDT05 to WAGE_SCHEDULE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT05 to WAGE_SCHEDULE" Foreign Keys |
Parent Key | Child Key |
UDT05_ID | UDT05_ID |
"UDT03 to WAGE_SCHEDULE" |
RelationshipType | Identifying |
Relationship Name | F00145 |
Relationship Business Name | |
Parent Table | UDT03 |
Child Table | WAGE_SCHEDULE |
Existence | Mandatory |
"UDT03 to WAGE_SCHEDULE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT03 to WAGE_SCHEDULE" Foreign Keys |
Parent Key | Child Key |
UDT03_ID | UDT03_ID |
"WAGE_SCHEDULE to WAGE_SCHEDULE_RATE" |
RelationshipType | Identifying |
Relationship Name | F00146 |
Relationship Business Name | |
Parent Table | WAGE_SCHEDULE |
Child Table | WAGE_SCHEDULE_RATE |
Existence | Mandatory |
"WAGE_SCHEDULE to WAGE_SCHEDULE_RATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WAGE_SCHEDULE to WAGE_SCHEDULE_RATE" Foreign Keys |
Parent Key | Child Key |
EFFECTIVE_DT, UDT05_ID, UDT03_ID, UDT01_ID_S | EFFECTIVE_DT, UDT05_ID, UDT03_ID, UDT01_ID_S |
"UDT10 to UDT10" |
RelationshipType | Non-Identifying |
Relationship Name | F00147 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | UDT10 |
Existence | Optional |
"UDT10 to UDT10" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to UDT10" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | RECAST_LABOR_UDT10_ID |
"UDT10 to UDT10" |
RelationshipType | Non-Identifying |
Relationship Name | F00148 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | UDT10 |
Existence | Optional |
"UDT10 to UDT10" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to UDT10" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | RECAST_PAYROLL_UDT10_ID |
"EXP_CLASS to EMPL_HISTORY" |
RelationshipType | Non-Identifying |
Relationship Name | F00149 |
Relationship Business Name | |
Parent Table | EXP_CLASS |
Child Table | EMPL_HISTORY |
Existence | Mandatory |
"EXP_CLASS to EMPL_HISTORY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CLASS to EMPL_HISTORY" Foreign Keys |
Parent Key | Child Key |
EXP_CLASS_CD | EXP_CLASS_CD |
"EXP_TYPE to EXP_TYPE_RATE_CEILING" |
RelationshipType | Identifying |
Relationship Name | F00153 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_RATE_CEILING |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_RATE_CEILING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_RATE_CEILING" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"EXP_CLASS to EXP_CLASS_EXP_RPT_TYPE" |
RelationshipType | Identifying |
Relationship Name | F00159 |
Relationship Business Name | |
Parent Table | EXP_CLASS |
Child Table | EXP_CLASS_EXP_RPT_TYPE |
Existence | Mandatory |
"EXP_CLASS to EXP_CLASS_EXP_RPT_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CLASS to EXP_CLASS_EXP_RPT_TYPE" Foreign Keys |
Parent Key | Child Key |
EXP_CLASS_CD | EXP_CLASS_CD |
"EXP_RPT_TYPE to EXP_CLASS_EXP_RPT_TYPE" |
RelationshipType | Identifying |
Relationship Name | F00160 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_CLASS_EXP_RPT_TYPE |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_CLASS_EXP_RPT_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_CLASS_EXP_RPT_TYPE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"EXP_CLASS to EXP_CLASS_PAY_METHOD" |
RelationshipType | Identifying |
Relationship Name | F00161 |
Relationship Business Name | |
Parent Table | EXP_CLASS |
Child Table | EXP_CLASS_PAY_METHOD |
Existence | Mandatory |
"EXP_CLASS to EXP_CLASS_PAY_METHOD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CLASS to EXP_CLASS_PAY_METHOD" Foreign Keys |
Parent Key | Child Key |
EXP_CLASS_CD | EXP_CLASS_CD |
"PAY_METHOD to EXP_CLASS_PAY_METHOD" |
RelationshipType | Identifying |
Relationship Name | F00162 |
Relationship Business Name | |
Parent Table | PAY_METHOD |
Child Table | EXP_CLASS_PAY_METHOD |
Existence | Mandatory |
"PAY_METHOD to EXP_CLASS_PAY_METHOD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PAY_METHOD to EXP_CLASS_PAY_METHOD" Foreign Keys |
Parent Key | Child Key |
PAY_METHOD_CD | PAY_METHOD_CD |
"PAY_METHOD to EMPL_PAY_METHOD" |
RelationshipType | Identifying |
Relationship Name | F00163 |
Relationship Business Name | |
Parent Table | PAY_METHOD |
Child Table | EMPL_PAY_METHOD |
Existence | Mandatory |
"PAY_METHOD to EMPL_PAY_METHOD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PAY_METHOD to EMPL_PAY_METHOD" Foreign Keys |
Parent Key | Child Key |
PAY_METHOD_CD | PAY_METHOD_CD |
"EMPL to EMPL_PAY_METHOD" |
RelationshipType | Identifying |
Relationship Name | F00164 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_PAY_METHOD |
Existence | Mandatory |
"EMPL to EMPL_PAY_METHOD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_PAY_METHOD" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"PER_DIEM to PER_DIEM_SCHEDULE" |
RelationshipType | Identifying |
Relationship Name | F00165 |
Relationship Business Name | |
Parent Table | PER_DIEM |
Child Table | PER_DIEM_SCHEDULE |
Existence | Mandatory |
"PER_DIEM to PER_DIEM_SCHEDULE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PER_DIEM to PER_DIEM_SCHEDULE" Foreign Keys |
Parent Key | Child Key |
PER_DIEM_SCHEDULE_CD | PER_DIEM_SCHEDULE_CD |
"COMPANY to EXP_CONFIG" |
RelationshipType | Identifying |
Relationship Name | F00169 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | EXP_CONFIG |
Existence | Mandatory |
"COMPANY to EXP_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to EXP_CONFIG" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"EXP_CONFIG to EXP_CONFIG_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00171 |
Relationship Business Name | |
Parent Table | EXP_CONFIG |
Child Table | EXP_CONFIG_LABELS |
Existence | Mandatory |
"EXP_CONFIG to EXP_CONFIG_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CONFIG to EXP_CONFIG_LABELS" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"LANGUAGE to EXP_CONFIG_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00172 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | EXP_CONFIG_LABELS |
Existence | Mandatory |
"LANGUAGE to EXP_CONFIG_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to EXP_CONFIG_LABELS" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"EXP_CONFIG to EXP_CONFIG_UDT" |
RelationshipType | Identifying |
Relationship Name | F00173 |
Relationship Business Name | |
Parent Table | EXP_CONFIG |
Child Table | EXP_CONFIG_UDT |
Existence | Mandatory |
"EXP_CONFIG to EXP_CONFIG_UDT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CONFIG to EXP_CONFIG_UDT" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"CURRENCY to CURRENCY_SCHEDULE_RATE" |
RelationshipType | Identifying |
Relationship Name | F00177 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | CURRENCY_SCHEDULE_RATE |
Existence | Mandatory |
"CURRENCY to CURRENCY_SCHEDULE_RATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to CURRENCY_SCHEDULE_RATE" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | FROM_CURRENCY_CD |
"CURRENCY to CURRENCY_SCHEDULE_RATE" |
RelationshipType | Identifying |
Relationship Name | F00178 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | CURRENCY_SCHEDULE_RATE |
Existence | Mandatory |
"CURRENCY to CURRENCY_SCHEDULE_RATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to CURRENCY_SCHEDULE_RATE" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | TO_CURRENCY_CD |
"CURRENCY_SCHEDULE to CURRENCY_SCHEDULE_RATE" |
RelationshipType | Identifying |
Relationship Name | F00179 |
Relationship Business Name | |
Parent Table | CURRENCY_SCHEDULE |
Child Table | CURRENCY_SCHEDULE_RATE |
Existence | Mandatory |
"CURRENCY_SCHEDULE to CURRENCY_SCHEDULE_RATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY_SCHEDULE to CURRENCY_SCHEDULE_RATE" Foreign Keys |
Parent Key | Child Key |
CURRENCY_SCHEDULE_CD | CURRENCY_SCHEDULE_CD |
"UDT07 to WAGE_SCHEDULE_RATE" |
RelationshipType | Identifying |
Relationship Name | F00180 |
Relationship Business Name | |
Parent Table | UDT07 |
Child Table | WAGE_SCHEDULE_RATE |
Existence | Mandatory |
"UDT07 to WAGE_SCHEDULE_RATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT07 to WAGE_SCHEDULE_RATE" Foreign Keys |
Parent Key | Child Key |
UDT07_ID, CP_COMPANY_CD | UDT07_ID, UDT07_CP_COMPANY_CD |
"EXP_TYPE to EXP_TYPE_EXP_CHARGE_TYPE" |
RelationshipType | Identifying |
Relationship Name | F00182 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_EXP_CHARGE_TYPE |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_EXP_CHARGE_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_EXP_CHARGE_TYPE" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"EXP_CHARGE_TYPE to EXP_TYPE_EXP_CHARGE_TYPE" |
RelationshipType | Identifying |
Relationship Name | F00183 |
Relationship Business Name | |
Parent Table | EXP_CHARGE_TYPE |
Child Table | EXP_TYPE_EXP_CHARGE_TYPE |
Existence | Mandatory |
"EXP_CHARGE_TYPE to EXP_TYPE_EXP_CHARGE_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CHARGE_TYPE to EXP_TYPE_EXP_CHARGE_TYPE" Foreign Keys |
Parent Key | Child Key |
EXP_CHARGE_TYPE_CD | EXP_CHARGE_TYPE_CD |
"EXP_CHARGE_TYPE to EXP_CHARGE_TYPE_CHARGE" |
RelationshipType | Identifying |
Relationship Name | F00184 |
Relationship Business Name | |
Parent Table | EXP_CHARGE_TYPE |
Child Table | EXP_CHARGE_TYPE_CHARGE |
Existence | Mandatory |
"EXP_CHARGE_TYPE to EXP_CHARGE_TYPE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CHARGE_TYPE to EXP_CHARGE_TYPE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_CHARGE_TYPE_CD | EXP_CHARGE_TYPE_CD |
"EXP_TYPE to EXP_TYPE_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00187 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_LABELS |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_LABELS" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"LANGUAGE to EXP_TYPE_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00188 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | EXP_TYPE_LABELS |
Existence | Mandatory |
"LANGUAGE to EXP_TYPE_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to EXP_TYPE_LABELS" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"EXP_TYPE to EXP_TYPE_OTHER" |
RelationshipType | Identifying |
Relationship Name | F00189 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_OTHER |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_OTHER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_OTHER" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"EXP_CLASS to EXP_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00201 |
Relationship Business Name | |
Parent Table | EXP_CLASS |
Child Table | EXP_CONFIG |
Existence | Mandatory |
"EXP_CLASS to EXP_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CLASS to EXP_CONFIG" Foreign Keys |
Parent Key | Child Key |
EXP_CLASS_CD | DFLT_EXP_CLASS_CD |
"CP_COMPANY to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00203 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | EXP_RPT |
Existence | Mandatory |
"CP_COMPANY to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CURRENCY to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00204 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_RPT |
Existence | Mandatory |
"CURRENCY to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | PAY_CURRENCY_CD |
"CURRENCY to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00205 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_RPT |
Existence | Mandatory |
"CURRENCY to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | BASE_CURRENCY_CD |
"CURRENCY_SCHEDULE to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00206 |
Relationship Business Name | |
Parent Table | CURRENCY_SCHEDULE |
Child Table | EXP_RPT |
Existence | Optional |
"CURRENCY_SCHEDULE to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY_SCHEDULE to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
CURRENCY_SCHEDULE_CD | CURRENCY_SCHEDULE_CD |
"EMPL to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00207 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_RPT |
Existence | Mandatory |
"EMPL to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EXP_CLASS to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00208 |
Relationship Business Name | |
Parent Table | EXP_CLASS |
Child Table | EXP_RPT |
Existence | Mandatory |
"EXP_CLASS to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CLASS to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
EXP_CLASS_CD | EXP_CLASS_CD |
"EXP_RPT_TYPE to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00209 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_RPT |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"PER_DIEM to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00210 |
Relationship Business Name | |
Parent Table | PER_DIEM |
Child Table | EXP_RPT |
Existence | Optional |
"PER_DIEM to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PER_DIEM to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
PER_DIEM_SCHEDULE_CD | PER_DIEM_SCHEDULE_CD |
"EXP_RPT to EXP_RPT_CHARGE_ALLOCATIONS" |
RelationshipType | Identifying |
Relationship Name | F00212 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | EXP_RPT_CHARGE_ALLOCATIONS |
Existence | Mandatory |
"EXP_RPT to EXP_RPT_CHARGE_ALLOCATIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to EXP_RPT_CHARGE_ALLOCATIONS" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EXP_RPT to EXP_RPT_PAYMENT" |
RelationshipType | Identifying |
Relationship Name | F00213 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | EXP_RPT_PAYMENT |
Existence | Mandatory |
"EXP_RPT to EXP_RPT_PAYMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to EXP_RPT_PAYMENT" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EXP_RPT to EXP_RPT_REVISION" |
RelationshipType | Identifying |
Relationship Name | F00214 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | EXP_RPT_REVISION |
Existence | Mandatory |
"EXP_RPT to EXP_RPT_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to EXP_RPT_REVISION" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EMPL to EXP_RPT_REVISION" |
RelationshipType | Non-Identifying |
Relationship Name | F00215 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_RPT_REVISION |
Existence | Optional |
"EMPL to EXP_RPT_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_RPT_REVISION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | REVISION_EMPL_ID |
"CURRENCY to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00220 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_RPT_EXPENSE |
Existence | Mandatory |
"CURRENCY to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | TRANS_CURRENCY_CD |
"EXP_RPT to EXP_RPT_EXPENSE" |
RelationshipType | Identifying |
Relationship Name | F00225 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | EXP_RPT_EXPENSE |
Existence | Mandatory |
"EXP_RPT to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00226 |
Relationship Business Name | |
Parent Table | EXP_RPT_EXPENSE |
Child Table | EXP_RPT_EXPENSE |
Existence | Optional |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, EXPENSE_ID | EXP_RPT_ID, PARENT_EXPENSE_ID |
"PAY_METHOD to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00228 |
Relationship Business Name | |
Parent Table | PAY_METHOD |
Child Table | EXP_RPT_EXPENSE |
Existence | Mandatory |
"PAY_METHOD to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PAY_METHOD to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
PAY_METHOD_CD | PAY_METHOD_CD |
"PROVIDER to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00229 |
Relationship Business Name | |
Parent Table | PROVIDER |
Child Table | EXP_RPT_EXPENSE |
Existence | Optional |
"PROVIDER to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROVIDER to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
PROVIDER_CD | PROVIDER_CD |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_ATTENDEE" |
RelationshipType | Identifying |
Relationship Name | F00230 |
Relationship Business Name | |
Parent Table | EXP_RPT_EXPENSE |
Child Table | EXP_RPT_EXPENSE_ATTENDEE |
Existence | Mandatory |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_ATTENDEE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_ATTENDEE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, EXPENSE_ID | EXP_RPT_ID, EXPENSE_ID |
"EMPL to EXP_RPT_EXPENSE_ATTENDEE" |
RelationshipType | Non-Identifying |
Relationship Name | F00231 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_RPT_EXPENSE_ATTENDEE |
Existence | Optional |
"EMPL to EXP_RPT_EXPENSE_ATTENDEE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_RPT_EXPENSE_ATTENDEE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EXP_CHARGE_TYPE to EXP_RPT_EXPENSE_CHARGE" |
RelationshipType | Non-Identifying |
Relationship Name | F00232 |
Relationship Business Name | |
Parent Table | EXP_CHARGE_TYPE |
Child Table | EXP_RPT_EXPENSE_CHARGE |
Existence | Optional |
"EXP_CHARGE_TYPE to EXP_RPT_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CHARGE_TYPE to EXP_RPT_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_CHARGE_TYPE_CD | EXP_CHARGE_TYPE_CD |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_CHARGE" |
RelationshipType | Identifying |
Relationship Name | F00233 |
Relationship Business Name | |
Parent Table | EXP_RPT_EXPENSE |
Child Table | EXP_RPT_EXPENSE_CHARGE |
Existence | Mandatory |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, EXPENSE_ID | EXP_RPT_ID, EXPENSE_ID |
"EXP_RPT_CHARGE_ALLOCATIONS to EXP_RPT_EXPENSE_CHARGE" |
RelationshipType | Identifying |
Relationship Name | F00234 |
Relationship Business Name | |
Parent Table | EXP_RPT_CHARGE_ALLOCATIONS |
Child Table | EXP_RPT_EXPENSE_CHARGE |
Existence | Mandatory |
"EXP_RPT_CHARGE_ALLOCATIONS to EXP_RPT_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_CHARGE_ALLOCATIONS to EXP_RPT_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, ALLOCATION_ID | EXP_RPT_ID, ALLOCATION_ID |
"UDT01 to EXP_RPT_EXPENSE_CHARGE" |
RelationshipType | Non-Identifying |
Relationship Name | F00235 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | EXP_RPT_EXPENSE_CHARGE |
Existence | Mandatory |
"UDT01 to EXP_RPT_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to EXP_RPT_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"UDT10 to EXP_RPT_EXPENSE_CHARGE" |
RelationshipType | Non-Identifying |
Relationship Name | F00236 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | EXP_RPT_EXPENSE_CHARGE |
Existence | Optional |
"UDT10 to EXP_RPT_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to EXP_RPT_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | UDT10_ID |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_DAY" |
RelationshipType | Identifying |
Relationship Name | F00237 |
Relationship Business Name | |
Parent Table | EXP_RPT_EXPENSE |
Child Table | EXP_RPT_EXPENSE_DAY |
Existence | Mandatory |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_DAY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_DAY" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, EXPENSE_ID | EXP_RPT_ID, EXPENSE_ID |
"EXP_TYPE_OTHER to EXP_RPT_EXPENSE_OTHER" |
RelationshipType | Non-Identifying |
Relationship Name | F00238 |
Relationship Business Name | |
Parent Table | EXP_TYPE_OTHER |
Child Table | EXP_RPT_EXPENSE_OTHER |
Existence | Mandatory |
"EXP_TYPE_OTHER to EXP_RPT_EXPENSE_OTHER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE_OTHER to EXP_RPT_EXPENSE_OTHER" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD, OTHER_EXPENSE_CD | EXP_TYPE_CD, OTHER_EXPENSE_CD |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_OTHER" |
RelationshipType | Identifying |
Relationship Name | F00239 |
Relationship Business Name | |
Parent Table | EXP_RPT_EXPENSE |
Child Table | EXP_RPT_EXPENSE_OTHER |
Existence | Mandatory |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_OTHER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_OTHER" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, EXPENSE_ID | EXP_RPT_ID, EXPENSE_ID |
"EMPL to DESKTOP_EXPENSE_ALERTS" |
RelationshipType | Identifying |
Relationship Name | F00242 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_EXPENSE_ALERTS |
Existence | Mandatory |
"EMPL to DESKTOP_EXPENSE_ALERTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_EXPENSE_ALERTS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"FUNCTIONAL_ROLE to DESKTOP_EXPENSE_ALERTS" |
RelationshipType | Identifying |
Relationship Name | F00243 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_EXPENSE_ALERTS |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_EXPENSE_ALERTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_EXPENSE_ALERTS" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to DESKTOP_SCHEDULE_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00247 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_SCHEDULE_TASKS |
Existence | Mandatory |
"EMPL to DESKTOP_SCHEDULE_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_SCHEDULE_TASKS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EVENT to DESKTOP_SCHEDULE_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00248 |
Relationship Business Name | |
Parent Table | EVENT |
Child Table | DESKTOP_SCHEDULE_TASKS |
Existence | Mandatory |
"EVENT to DESKTOP_SCHEDULE_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EVENT to DESKTOP_SCHEDULE_TASKS" Foreign Keys |
Parent Key | Child Key |
EVENT_CD | EVENT_CD |
"FUNCTIONAL_ROLE to DESKTOP_SCHEDULE_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00249 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_SCHEDULE_TASKS |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_SCHEDULE_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_SCHEDULE_TASKS" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00259 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_RPT_EXPENSE |
Existence | Optional |
"EMPL to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | RECEIPT_EMPL_ID |
"UDT01 to LINK110" |
RelationshipType | Identifying |
Relationship Name | F00260 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | LINK110 |
Existence | Mandatory |
"UDT01 to LINK110" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to LINK110" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"UDT10 to LINK110" |
RelationshipType | Identifying |
Relationship Name | F00261 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | LINK110 |
Existence | Mandatory |
"UDT10 to LINK110" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to LINK110" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | UDT10_ID |
"TIME_ZONE to GENERAL_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00262 |
Relationship Business Name | |
Parent Table | TIME_ZONE |
Child Table | GENERAL_CONFIG |
Existence | Mandatory |
"TIME_ZONE to GENERAL_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TIME_ZONE to GENERAL_CONFIG" Foreign Keys |
Parent Key | Child Key |
TIME_ZONE_CD | SERVER_TIME_ZONE_CD |
"TIME_ZONE to EMPL_PREFERENCE" |
RelationshipType | Non-Identifying |
Relationship Name | F00263 |
Relationship Business Name | |
Parent Table | TIME_ZONE |
Child Table | EMPL_PREFERENCE |
Existence | Optional |
"TIME_ZONE to EMPL_PREFERENCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TIME_ZONE to EMPL_PREFERENCE" Foreign Keys |
Parent Key | Child Key |
TIME_ZONE_CD | TIME_ZONE_CD |
"TAX_SCHEDULE to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00268 |
Relationship Business Name | |
Parent Table | TAX_SCHEDULE |
Child Table | EXP_RPT_EXPENSE |
Existence | Optional |
"TAX_SCHEDULE to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TAX_SCHEDULE to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
TAX_SCHEDULE_CD | TAX_SCHEDULE_CD |
"LANGUAGE to TAX_SCHEDULE_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00269 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | TAX_SCHEDULE_LABELS |
Existence | Mandatory |
"LANGUAGE to TAX_SCHEDULE_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to TAX_SCHEDULE_LABELS" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"TAX_SCHEDULE to TAX_SCHEDULE_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00270 |
Relationship Business Name | |
Parent Table | TAX_SCHEDULE |
Child Table | TAX_SCHEDULE_LABELS |
Existence | Mandatory |
"TAX_SCHEDULE to TAX_SCHEDULE_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TAX_SCHEDULE to TAX_SCHEDULE_LABELS" Foreign Keys |
Parent Key | Child Key |
TAX_SCHEDULE_CD | TAX_SCHEDULE_CD |
"TAX_SCHEDULE to TAX_SCHEDULE_RATE" |
RelationshipType | Identifying |
Relationship Name | F00271 |
Relationship Business Name | |
Parent Table | TAX_SCHEDULE |
Child Table | TAX_SCHEDULE_RATE |
Existence | Mandatory |
"TAX_SCHEDULE to TAX_SCHEDULE_RATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TAX_SCHEDULE to TAX_SCHEDULE_RATE" Foreign Keys |
Parent Key | Child Key |
TAX_SCHEDULE_CD | TAX_SCHEDULE_CD |
"EXP_TYPE to EXP_TYPE_PROVIDER" |
RelationshipType | Identifying |
Relationship Name | F00272 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_PROVIDER |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_PROVIDER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_PROVIDER" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"PROVIDER to EXP_TYPE_PROVIDER" |
RelationshipType | Identifying |
Relationship Name | F00273 |
Relationship Business Name | |
Parent Table | PROVIDER |
Child Table | EXP_TYPE_PROVIDER |
Existence | Mandatory |
"PROVIDER to EXP_TYPE_PROVIDER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROVIDER to EXP_TYPE_PROVIDER" Foreign Keys |
Parent Key | Child Key |
PROVIDER_CD | PROVIDER_CD |
"EXP_TYPE to EXP_TYPE_PAY_METHOD" |
RelationshipType | Identifying |
Relationship Name | F00274 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_PAY_METHOD |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_PAY_METHOD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_PAY_METHOD" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"PAY_METHOD to EXP_TYPE_PAY_METHOD" |
RelationshipType | Identifying |
Relationship Name | F00275 |
Relationship Business Name | |
Parent Table | PAY_METHOD |
Child Table | EXP_TYPE_PAY_METHOD |
Existence | Mandatory |
"PAY_METHOD to EXP_TYPE_PAY_METHOD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PAY_METHOD to EXP_TYPE_PAY_METHOD" Foreign Keys |
Parent Key | Child Key |
PAY_METHOD_CD | PAY_METHOD_CD |
"EXP_TYPE to EXP_TYPE_CODE1" |
RelationshipType | Identifying |
Relationship Name | F00276 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_CODE1 |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_CODE1" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_CODE1" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"EXP_TYPE to EXP_TYPE_CODE2" |
RelationshipType | Identifying |
Relationship Name | F00277 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_CODE2 |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_CODE2" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_CODE2" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"EXP_TYPE to EXP_TYPE_CODE3" |
RelationshipType | Identifying |
Relationship Name | F00278 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_CODE3 |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_CODE3" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_CODE3" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CATEGORY" |
RelationshipType | Identifying |
Relationship Name | F00279 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_RPT_TYPE_CATEGORY |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CATEGORY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CATEGORY" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_TYPE_CATEGORY_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00281 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE_CATEGORY |
Child Table | EXP_RPT_TYPE_CATEGORY_LABELS |
Existence | Mandatory |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_TYPE_CATEGORY_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_TYPE_CATEGORY_LABELS" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD, EXP_CATEGORY_CD | EXP_RPT_TYPE_CD, EXP_CATEGORY_CD |
"LANGUAGE to EXP_RPT_TYPE_CATEGORY_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00282 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | EXP_RPT_TYPE_CATEGORY_LABELS |
Existence | Mandatory |
"LANGUAGE to EXP_RPT_TYPE_CATEGORY_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to EXP_RPT_TYPE_CATEGORY_LABELS" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" |
RelationshipType | Identifying |
Relationship Name | F00283 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE_CATEGORY |
Child Table | EXP_RPT_TYPE_CATEGORY_EXP_TYPE |
Existence | Mandatory |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD, EXP_CATEGORY_CD | EXP_RPT_TYPE_CD, EXP_CATEGORY_CD |
"EXP_TYPE to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" |
RelationshipType | Identifying |
Relationship Name | F00284 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_RPT_TYPE_CATEGORY_EXP_TYPE |
Existence | Mandatory |
"EXP_TYPE to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"PAY_METHOD to EXP_BATCH_TYPE" |
RelationshipType | Non-Identifying |
Relationship Name | F00286 |
Relationship Business Name | |
Parent Table | PAY_METHOD |
Child Table | EXP_BATCH_TYPE |
Existence | Mandatory |
"PAY_METHOD to EXP_BATCH_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PAY_METHOD to EXP_BATCH_TYPE" Foreign Keys |
Parent Key | Child Key |
PAY_METHOD_CD | PAY_METHOD_CD |
"PROVIDER to EXP_BATCH_TYPE" |
RelationshipType | Non-Identifying |
Relationship Name | F00287 |
Relationship Business Name | |
Parent Table | PROVIDER |
Child Table | EXP_BATCH_TYPE |
Existence | Optional |
"PROVIDER to EXP_BATCH_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROVIDER to EXP_BATCH_TYPE" Foreign Keys |
Parent Key | Child Key |
PROVIDER_CD | DFLT_PROVIDER_CD |
"EMPL to EXP_BATCH_TYPE" |
RelationshipType | Non-Identifying |
Relationship Name | F00288 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_BATCH_TYPE |
Existence | Optional |
"EMPL to EXP_BATCH_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_BATCH_TYPE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | DFLT_EMPL_ID |
"CURRENCY to EXP_BATCH_TYPE" |
RelationshipType | Non-Identifying |
Relationship Name | F00289 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_BATCH_TYPE |
Existence | Optional |
"CURRENCY to EXP_BATCH_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_BATCH_TYPE" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | DFLT_TRANS_CURRENCY_CD |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_FILTER" |
RelationshipType | Identifying |
Relationship Name | F00290 |
Relationship Business Name | |
Parent Table | EXP_BATCH_TYPE |
Child Table | EXP_BATCH_TYPE_FILTER |
Existence | Mandatory |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_FILTER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_FILTER" Foreign Keys |
Parent Key | Child Key |
EXP_BATCH_TYPE_CD | EXP_BATCH_TYPE_CD |
"EXP_BATCH_TYPE to BATCH_EXPENSE_EDIT" |
RelationshipType | Identifying |
Relationship Name | F00291 |
Relationship Business Name | |
Parent Table | EXP_BATCH_TYPE |
Child Table | BATCH_EXPENSE_EDIT |
Existence | Mandatory |
"EXP_BATCH_TYPE to BATCH_EXPENSE_EDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_BATCH_TYPE to BATCH_EXPENSE_EDIT" Foreign Keys |
Parent Key | Child Key |
EXP_BATCH_TYPE_CD | EXP_BATCH_TYPE_CD |
"EMPL to BATCH_EXPENSE_EDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00292 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | BATCH_EXPENSE_EDIT |
Existence | Optional |
"EMPL to BATCH_EXPENSE_EDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to BATCH_EXPENSE_EDIT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"PROVIDER to BATCH_EXPENSE_EDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00293 |
Relationship Business Name | |
Parent Table | PROVIDER |
Child Table | BATCH_EXPENSE_EDIT |
Existence | Optional |
"PROVIDER to BATCH_EXPENSE_EDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROVIDER to BATCH_EXPENSE_EDIT" Foreign Keys |
Parent Key | Child Key |
PROVIDER_CD | PROVIDER_CD |
"PAY_METHOD to BATCH_EXPENSE_EDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00295 |
Relationship Business Name | |
Parent Table | PAY_METHOD |
Child Table | BATCH_EXPENSE_EDIT |
Existence | Mandatory |
"PAY_METHOD to BATCH_EXPENSE_EDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PAY_METHOD to BATCH_EXPENSE_EDIT" Foreign Keys |
Parent Key | Child Key |
PAY_METHOD_CD | PAY_METHOD_CD |
"CURRENCY to BATCH_EXPENSE_EDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00296 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | BATCH_EXPENSE_EDIT |
Existence | Mandatory |
"CURRENCY to BATCH_EXPENSE_EDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to BATCH_EXPENSE_EDIT" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | TRANS_CURRENCY_CD |
"EXP_BATCH_TYPE to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Identifying |
Relationship Name | F00297 |
Relationship Business Name | |
Parent Table | EXP_BATCH_TYPE |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Mandatory |
"EXP_BATCH_TYPE to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_BATCH_TYPE to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EXP_BATCH_TYPE_CD | EXP_BATCH_TYPE_CD |
"EMPL to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00298 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Mandatory |
"EMPL to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"PROVIDER to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00299 |
Relationship Business Name | |
Parent Table | PROVIDER |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Optional |
"PROVIDER to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROVIDER to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
PROVIDER_CD | PROVIDER_CD |
"PAY_METHOD to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00300 |
Relationship Business Name | |
Parent Table | PAY_METHOD |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Mandatory |
"PAY_METHOD to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PAY_METHOD to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
PAY_METHOD_CD | PAY_METHOD_CD |
"CURRENCY to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00301 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Mandatory |
"CURRENCY to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | TRANS_CURRENCY_CD |
"EXP_RPT_EXPENSE to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00302 |
Relationship Business Name | |
Parent Table | EXP_RPT_EXPENSE |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Optional |
"EXP_RPT_EXPENSE to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_EXPENSE to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, EXPENSE_ID | EXP_RPT_ID, EXPENSE_ID |
"EMPL to TS_EXPORT_ADJUSTMENT" |
RelationshipType | Identifying |
Relationship Name | F00303 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | TS_EXPORT_ADJUSTMENT |
Existence | Mandatory |
"EMPL to TS_EXPORT_ADJUSTMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to TS_EXPORT_ADJUSTMENT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"TS to TS_EXPORT_ADJUSTMENT" |
RelationshipType | Identifying |
Relationship Name | F00304 |
Relationship Business Name | |
Parent Table | TS |
Child Table | TS_EXPORT_ADJUSTMENT |
Existence | Mandatory |
"TS to TS_EXPORT_ADJUSTMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS to TS_EXPORT_ADJUSTMENT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"EMPL to ADVANCE_OUTSTANDING" |
RelationshipType | Identifying |
Relationship Name | F00305 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | ADVANCE_OUTSTANDING |
Existence | Mandatory |
"EMPL to ADVANCE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to ADVANCE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EXP_RPT to ADVANCE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00306 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | ADVANCE_OUTSTANDING |
Existence | Optional |
"EXP_RPT to ADVANCE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to ADVANCE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"CURRENCY to ADVANCE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00307 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | ADVANCE_OUTSTANDING |
Existence | Mandatory |
"CURRENCY to ADVANCE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to ADVANCE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | PAY_CURRENCY_CD |
"CURRENCY to ADVANCE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00308 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | ADVANCE_OUTSTANDING |
Existence | Mandatory |
"CURRENCY to ADVANCE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to ADVANCE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | BASE_CURRENCY_CD |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_GHOST_CARD" |
RelationshipType | Identifying |
Relationship Name | F00309 |
Relationship Business Name | |
Parent Table | EXP_BATCH_TYPE |
Child Table | EXP_BATCH_TYPE_GHOST_CARD |
Existence | Mandatory |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_GHOST_CARD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_GHOST_CARD" Foreign Keys |
Parent Key | Child Key |
EXP_BATCH_TYPE_CD | EXP_BATCH_TYPE_CD |
"EXP_TYPE to EXP_TYPE_OTHER" |
RelationshipType | Non-Identifying |
Relationship Name | F00311 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_OTHER |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_OTHER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_OTHER" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | OTHER_EXP_TYPE_CD |
"CLASS to CLASS_UDT" |
RelationshipType | Identifying |
Relationship Name | F00312 |
Relationship Business Name | |
Parent Table | CLASS |
Child Table | CLASS_UDT |
Existence | Mandatory |
"CLASS to CLASS_UDT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CLASS to CLASS_UDT" Foreign Keys |
Parent Key | Child Key |
CLASS_CD | CLASS_CD |
"FUNCTIONAL_ROLE to FUNCTIONAL_ROLE" |
RelationshipType | Non-Identifying |
Relationship Name | F00317 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | FUNCTIONAL_ROLE |
Existence | Optional |
"FUNCTIONAL_ROLE to FUNCTIONAL_ROLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to FUNCTIONAL_ROLE" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | DELEGATION_ROLE_CD |
"TAX_SCHEDULE to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" |
RelationshipType | Non-Identifying |
Relationship Name | F00320 |
Relationship Business Name | |
Parent Table | TAX_SCHEDULE |
Child Table | EXP_RPT_TYPE_CATEGORY_EXP_TYPE |
Existence | Optional |
"TAX_SCHEDULE to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TAX_SCHEDULE to EXP_RPT_TYPE_CATEGORY_EXP_TYPE" Foreign Keys |
Parent Key | Child Key |
TAX_SCHEDULE_CD | TAX_SCHEDULE_CD |
"EMPL to DESKTOP_DELEGATION_EMPLOYEE" |
RelationshipType | Identifying |
Relationship Name | F00321 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_DELEGATION_EMPLOYEE |
Existence | Mandatory |
"EMPL to DESKTOP_DELEGATION_EMPLOYEE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_DELEGATION_EMPLOYEE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EMPL to DESKTOP_DELEGATION_EMPLOYEE" |
RelationshipType | Identifying |
Relationship Name | F00322 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_DELEGATION_EMPLOYEE |
Existence | Mandatory |
"EMPL to DESKTOP_DELEGATION_EMPLOYEE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_DELEGATION_EMPLOYEE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | DELEGATE_EMPL_ID |
"EMPL_GROUP to DESKTOP_DELEGATION_EMPLOYEE" |
RelationshipType | Identifying |
Relationship Name | F00323 |
Relationship Business Name | |
Parent Table | EMPL_GROUP |
Child Table | DESKTOP_DELEGATION_EMPLOYEE |
Existence | Mandatory |
"EMPL_GROUP to DESKTOP_DELEGATION_EMPLOYEE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL_GROUP to DESKTOP_DELEGATION_EMPLOYEE" Foreign Keys |
Parent Key | Child Key |
EMPL_GROUP_CD | EMPL_GROUP_CD |
"FUNCTIONAL_ROLE to DESKTOP_DELEGATION_EMPLOYEE" |
RelationshipType | Identifying |
Relationship Name | F00324 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_DELEGATION_EMPLOYEE |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_DELEGATION_EMPLOYEE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_DELEGATION_EMPLOYEE" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to DESKTOP_DELEGATION_UDT" |
RelationshipType | Identifying |
Relationship Name | F00325 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_DELEGATION_UDT |
Existence | Mandatory |
"EMPL to DESKTOP_DELEGATION_UDT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_DELEGATION_UDT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EMPL to DESKTOP_DELEGATION_UDT" |
RelationshipType | Identifying |
Relationship Name | F00326 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_DELEGATION_UDT |
Existence | Mandatory |
"EMPL to DESKTOP_DELEGATION_UDT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_DELEGATION_UDT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | DELEGATE_EMPL_ID |
"FUNCTIONAL_ROLE to DESKTOP_DELEGATION_UDT" |
RelationshipType | Identifying |
Relationship Name | F00327 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_DELEGATION_UDT |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_DELEGATION_UDT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_DELEGATION_UDT" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"SCREENS to SCREEN_PARAMETER" |
RelationshipType | Identifying |
Relationship Name | F00328 |
Relationship Business Name | |
Parent Table | SCREENS |
Child Table | SCREEN_PARAMETER |
Existence | Mandatory |
"SCREENS to SCREEN_PARAMETER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCREENS to SCREEN_PARAMETER" Foreign Keys |
Parent Key | Child Key |
SCREEN_CD | SCREEN_CD |
"EMPL to SCREEN_PARAMETER" |
RelationshipType | Non-Identifying |
Relationship Name | F00329 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | SCREEN_PARAMETER |
Existence | Mandatory |
"EMPL to SCREEN_PARAMETER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to SCREEN_PARAMETER" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"SCREEN_PARAMETER to SCHEDULED_PROCESS" |
RelationshipType | Identifying |
Relationship Name | F00331 |
Relationship Business Name | |
Parent Table | SCREEN_PARAMETER |
Child Table | SCHEDULED_PROCESS |
Existence | Mandatory |
"SCREEN_PARAMETER to SCHEDULED_PROCESS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCREEN_PARAMETER to SCHEDULED_PROCESS" Foreign Keys |
Parent Key | Child Key |
SCREEN_CD, PARAMETER_CD | SCREEN_CD, PARAMETER_CD |
"EMPL to SCHEDULED_PROCESS" |
RelationshipType | Non-Identifying |
Relationship Name | F00333 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | SCHEDULED_PROCESS |
Existence | Mandatory |
"EMPL to SCHEDULED_PROCESS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to SCHEDULED_PROCESS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMAIL_EMPL_ID |
"EMPL to SCHEDULED_PROCESS" |
RelationshipType | Identifying |
Relationship Name | F00334 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | SCHEDULED_PROCESS |
Existence | Mandatory |
"EMPL to SCHEDULED_PROCESS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to SCHEDULED_PROCESS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EXECUTE_EMPL_ID |
"SCHEDULED_PROCESS to SCHEDULED_PROCESS_HISTORY" |
RelationshipType | Identifying |
Relationship Name | F00335 |
Relationship Business Name | |
Parent Table | SCHEDULED_PROCESS |
Child Table | SCHEDULED_PROCESS_HISTORY |
Existence | Mandatory |
"SCHEDULED_PROCESS to SCHEDULED_PROCESS_HISTORY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCHEDULED_PROCESS to SCHEDULED_PROCESS_HISTORY" Foreign Keys |
Parent Key | Child Key |
SCREEN_CD, PARAMETER_CD, RECURRENCE_CD, PROCESS_START_HRS, PROCESS_START_MINS, S_PROCESS_START_CD, EXECUTE_EMPL_ID | SCREEN_CD, PARAMETER_CD, RECURRENCE_CD, PROCESS_START_HRS, PROCESS_START_MINS, S_PROCESS_START_CD, EXECUTE_EMPL_ID |
"COMPANY to ESS_CONFIG" |
RelationshipType | Identifying |
Relationship Name | F00336 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | ESS_CONFIG |
Existence | Mandatory |
"COMPANY to ESS_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to ESS_CONFIG" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00340 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE_CATEGORY |
Child Table | EXP_RPT_EXPENSE |
Existence | Mandatory |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE_CATEGORY to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD, EXP_CATEGORY_CD | EXP_RPT_TYPE_CD, EXP_CATEGORY_CD |
"EXP_TYPE to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00341 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_RPT_EXPENSE |
Existence | Mandatory |
"EXP_TYPE to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"UDT09 to EXP_RPT_CHARGE_ALLOCATIONS" |
RelationshipType | Non-Identifying |
Relationship Name | F00342 |
Relationship Business Name | |
Parent Table | UDT09 |
Child Table | EXP_RPT_CHARGE_ALLOCATIONS |
Existence | Optional |
"UDT09 to EXP_RPT_CHARGE_ALLOCATIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT09 to EXP_RPT_CHARGE_ALLOCATIONS" Foreign Keys |
Parent Key | Child Key |
UDT09_ID | UDT09_ID |
"EXP_AUTH to EXP_RPT" |
RelationshipType | Non-Identifying |
Relationship Name | F00346 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | EXP_RPT |
Existence | Optional |
"EXP_AUTH to EXP_RPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to EXP_RPT" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"CP_COMPANY to EXP_AUTH" |
RelationshipType | Non-Identifying |
Relationship Name | F00347 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | EXP_AUTH |
Existence | Mandatory |
"CP_COMPANY to EXP_AUTH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to EXP_AUTH" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CURRENCY to EXP_AUTH" |
RelationshipType | Non-Identifying |
Relationship Name | F00348 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_AUTH |
Existence | Mandatory |
"CURRENCY to EXP_AUTH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_AUTH" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | PAY_CURRENCY_CD |
"CURRENCY to EXP_AUTH" |
RelationshipType | Non-Identifying |
Relationship Name | F00349 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_AUTH |
Existence | Mandatory |
"CURRENCY to EXP_AUTH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_AUTH" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | BASE_CURRENCY_CD |
"CURRENCY_SCHEDULE to EXP_AUTH" |
RelationshipType | Non-Identifying |
Relationship Name | F00350 |
Relationship Business Name | |
Parent Table | CURRENCY_SCHEDULE |
Child Table | EXP_AUTH |
Existence | Optional |
"CURRENCY_SCHEDULE to EXP_AUTH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY_SCHEDULE to EXP_AUTH" Foreign Keys |
Parent Key | Child Key |
CURRENCY_SCHEDULE_CD | CURRENCY_SCHEDULE_CD |
"EMPL to EXP_AUTH" |
RelationshipType | Non-Identifying |
Relationship Name | F00351 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_AUTH |
Existence | Mandatory |
"EMPL to EXP_AUTH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_AUTH" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EXP_CLASS to EXP_AUTH" |
RelationshipType | Non-Identifying |
Relationship Name | F00352 |
Relationship Business Name | |
Parent Table | EXP_CLASS |
Child Table | EXP_AUTH |
Existence | Mandatory |
"EXP_CLASS to EXP_AUTH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CLASS to EXP_AUTH" Foreign Keys |
Parent Key | Child Key |
EXP_CLASS_CD | EXP_CLASS_CD |
"EXP_RPT_TYPE to EXP_AUTH" |
RelationshipType | Non-Identifying |
Relationship Name | F00353 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_AUTH |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_AUTH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_AUTH" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"PER_DIEM to EXP_AUTH" |
RelationshipType | Non-Identifying |
Relationship Name | F00354 |
Relationship Business Name | |
Parent Table | PER_DIEM |
Child Table | EXP_AUTH |
Existence | Optional |
"PER_DIEM to EXP_AUTH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PER_DIEM to EXP_AUTH" Foreign Keys |
Parent Key | Child Key |
PER_DIEM_SCHEDULE_CD | PER_DIEM_SCHEDULE_CD |
"CHARGE_BRANCH_CHARGE to EXP_AUTH_CHARGE_ALLOCATIONS" |
RelationshipType | Non-Identifying |
Relationship Name | F00356 |
Relationship Business Name | |
Parent Table | CHARGE_BRANCH_CHARGE |
Child Table | EXP_AUTH_CHARGE_ALLOCATIONS |
Existence | Optional |
"CHARGE_BRANCH_CHARGE to EXP_AUTH_CHARGE_ALLOCATIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE_BRANCH_CHARGE to EXP_AUTH_CHARGE_ALLOCATIONS" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD | CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD |
"EXP_AUTH to EXP_AUTH_CHARGE_ALLOCATIONS" |
RelationshipType | Identifying |
Relationship Name | F00357 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | EXP_AUTH_CHARGE_ALLOCATIONS |
Existence | Mandatory |
"EXP_AUTH to EXP_AUTH_CHARGE_ALLOCATIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to EXP_AUTH_CHARGE_ALLOCATIONS" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"UDT09 to EXP_AUTH_CHARGE_ALLOCATIONS" |
RelationshipType | Non-Identifying |
Relationship Name | F00358 |
Relationship Business Name | |
Parent Table | UDT09 |
Child Table | EXP_AUTH_CHARGE_ALLOCATIONS |
Existence | Optional |
"UDT09 to EXP_AUTH_CHARGE_ALLOCATIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT09 to EXP_AUTH_CHARGE_ALLOCATIONS" Foreign Keys |
Parent Key | Child Key |
UDT09_ID | UDT09_ID |
"EXP_AUTH to EXP_AUTH_EXPENSE" |
RelationshipType | Identifying |
Relationship Name | F00359 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | EXP_AUTH_EXPENSE |
Existence | Mandatory |
"EXP_AUTH to EXP_AUTH_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to EXP_AUTH_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"PER_DIEM to EXP_AUTH_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00360 |
Relationship Business Name | |
Parent Table | PER_DIEM |
Child Table | EXP_AUTH_EXPENSE |
Existence | Optional |
"PER_DIEM to EXP_AUTH_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PER_DIEM to EXP_AUTH_EXPENSE" Foreign Keys |
Parent Key | Child Key |
PER_DIEM_SCHEDULE_CD | PER_DIEM_SCHEDULE_CD |
"EXP_RPT_TYPE_CATEGORY to EXP_AUTH_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00361 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE_CATEGORY |
Child Table | EXP_AUTH_EXPENSE |
Existence | Mandatory |
"EXP_RPT_TYPE_CATEGORY to EXP_AUTH_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE_CATEGORY to EXP_AUTH_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD, EXP_CATEGORY_CD | EXP_RPT_TYPE_CD, EXP_CATEGORY_CD |
"EXP_TYPE to EXP_AUTH_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00362 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_AUTH_EXPENSE |
Existence | Mandatory |
"EXP_TYPE to EXP_AUTH_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_AUTH_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"EXP_AUTH_EXPENSE to EXP_AUTH_EXPENSE_CHARGE" |
RelationshipType | Identifying |
Relationship Name | F00363 |
Relationship Business Name | |
Parent Table | EXP_AUTH_EXPENSE |
Child Table | EXP_AUTH_EXPENSE_CHARGE |
Existence | Mandatory |
"EXP_AUTH_EXPENSE to EXP_AUTH_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_EXPENSE to EXP_AUTH_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, EXPENSE_ID | EXP_AUTH_ID, EXPENSE_ID |
"EXP_AUTH_CHARGE_ALLOCATIONS to EXP_AUTH_EXPENSE_CHARGE" |
RelationshipType | Identifying |
Relationship Name | F00364 |
Relationship Business Name | |
Parent Table | EXP_AUTH_CHARGE_ALLOCATIONS |
Child Table | EXP_AUTH_EXPENSE_CHARGE |
Existence | Mandatory |
"EXP_AUTH_CHARGE_ALLOCATIONS to EXP_AUTH_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_CHARGE_ALLOCATIONS to EXP_AUTH_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, ALLOCATION_ID | EXP_AUTH_ID, ALLOCATION_ID |
"EMPL to EXP_AUTH_REVISION" |
RelationshipType | Non-Identifying |
Relationship Name | F00365 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_AUTH_REVISION |
Existence | Optional |
"EMPL to EXP_AUTH_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_AUTH_REVISION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | REVISION_EMPL_ID |
"EXP_AUTH to EXP_AUTH_REVISION" |
RelationshipType | Identifying |
Relationship Name | F00366 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | EXP_AUTH_REVISION |
Existence | Mandatory |
"EXP_AUTH to EXP_AUTH_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to EXP_AUTH_REVISION" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"EMPL to DESKTOP_AUTH_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00371 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_AUTH_TASKS |
Existence | Mandatory |
"EMPL to DESKTOP_AUTH_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_AUTH_TASKS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EXP_AUTH to DESKTOP_AUTH_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00372 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | DESKTOP_AUTH_TASKS |
Existence | Mandatory |
"EXP_AUTH to DESKTOP_AUTH_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to DESKTOP_AUTH_TASKS" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"FUNCTIONAL_ROLE to DESKTOP_AUTH_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00373 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_AUTH_TASKS |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_AUTH_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_AUTH_TASKS" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EXP_AUTH to ADVANCE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00374 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | ADVANCE_OUTSTANDING |
Existence | Optional |
"EXP_AUTH to ADVANCE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to ADVANCE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"LANGUAGE to CUSTOM_TEXT" |
RelationshipType | Identifying |
Relationship Name | F00375 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | CUSTOM_TEXT |
Existence | Mandatory |
"LANGUAGE to CUSTOM_TEXT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to CUSTOM_TEXT" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"FUNCTIONAL_ROLE to LIFE_EVENT" |
RelationshipType | Non-Identifying |
Relationship Name | F00376 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | LIFE_EVENT |
Existence | Optional |
"FUNCTIONAL_ROLE to LIFE_EVENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to LIFE_EVENT" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD_1 |
"FUNCTIONAL_ROLE to LIFE_EVENT" |
RelationshipType | Non-Identifying |
Relationship Name | F00377 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | LIFE_EVENT |
Existence | Optional |
"FUNCTIONAL_ROLE to LIFE_EVENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to LIFE_EVENT" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD_2 |
"EMPL to DESKTOP_SELF_SERVICE_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00378 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_SELF_SERVICE_TASKS |
Existence | Mandatory |
"EMPL to DESKTOP_SELF_SERVICE_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_SELF_SERVICE_TASKS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"FUNCTIONAL_ROLE to DESKTOP_SELF_SERVICE_TASKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00379 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_SELF_SERVICE_TASKS |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_SELF_SERVICE_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_SELF_SERVICE_TASKS" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"LIFE_EVENT to DESKTOP_SELF_SERVICE_TASKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00380 |
Relationship Business Name | |
Parent Table | LIFE_EVENT |
Child Table | DESKTOP_SELF_SERVICE_TASKS |
Existence | Optional |
"LIFE_EVENT to DESKTOP_SELF_SERVICE_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LIFE_EVENT to DESKTOP_SELF_SERVICE_TASKS" Foreign Keys |
Parent Key | Child Key |
LIFE_EVENT_CD | LIFE_EVENT_CD |
"EMPL to DESKTOP_SELF_SERVICE_ALERTS" |
RelationshipType | Identifying |
Relationship Name | F00381 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | DESKTOP_SELF_SERVICE_ALERTS |
Existence | Mandatory |
"EMPL to DESKTOP_SELF_SERVICE_ALERTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to DESKTOP_SELF_SERVICE_ALERTS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"FUNCTIONAL_ROLE to DESKTOP_SELF_SERVICE_ALERTS" |
RelationshipType | Identifying |
Relationship Name | F00382 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | DESKTOP_SELF_SERVICE_ALERTS |
Existence | Mandatory |
"FUNCTIONAL_ROLE to DESKTOP_SELF_SERVICE_ALERTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to DESKTOP_SELF_SERVICE_ALERTS" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"FUNCTIONAL_ROLE to ESS_CONFIG" |
RelationshipType | Non-Identifying |
Relationship Name | F00383 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | ESS_CONFIG |
Existence | Optional |
"FUNCTIONAL_ROLE to ESS_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to ESS_CONFIG" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"FUNCTIONAL_ROLE to EXP_RPT_TASKS_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00386 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | EXP_RPT_TASKS_EMPL |
Existence | Mandatory |
"FUNCTIONAL_ROLE to EXP_RPT_TASKS_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to EXP_RPT_TASKS_EMPL" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to EXP_RPT_TASKS_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00387 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_RPT_TASKS_EMPL |
Existence | Mandatory |
"EMPL to EXP_RPT_TASKS_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_RPT_TASKS_EMPL" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"FUNCTIONAL_ROLE to EXP_AUTH_TASKS_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00389 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | EXP_AUTH_TASKS_EMPL |
Existence | Mandatory |
"FUNCTIONAL_ROLE to EXP_AUTH_TASKS_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to EXP_AUTH_TASKS_EMPL" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to EXP_AUTH_TASKS_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00390 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_AUTH_TASKS_EMPL |
Existence | Mandatory |
"EMPL to EXP_AUTH_TASKS_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_AUTH_TASKS_EMPL" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EXP_RPT_TYPE to EXP_RPT_TYPE_SCHEDULE" |
RelationshipType | Identifying |
Relationship Name | F00391 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_RPT_TYPE_SCHEDULE |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_RPT_TYPE_SCHEDULE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_RPT_TYPE_SCHEDULE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"EXP_RPT_TYPE to EXP_RPT_TYPE_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00392 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_RPT_TYPE_LABELS |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_RPT_TYPE_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_RPT_TYPE_LABELS" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"LANGUAGE to EXP_RPT_TYPE_LABELS" |
RelationshipType | Identifying |
Relationship Name | F00393 |
Relationship Business Name | |
Parent Table | LANGUAGE |
Child Table | EXP_RPT_TYPE_LABELS |
Existence | Mandatory |
"LANGUAGE to EXP_RPT_TYPE_LABELS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LANGUAGE to EXP_RPT_TYPE_LABELS" Foreign Keys |
Parent Key | Child Key |
COUNTRY_CD, LANGUAGE_CD | COUNTRY_CD, LANGUAGE_CD |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE1" |
RelationshipType | Identifying |
Relationship Name | F00394 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_RPT_TYPE_CODE1 |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE1" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE1" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE2" |
RelationshipType | Identifying |
Relationship Name | F00395 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_RPT_TYPE_CODE2 |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE2" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE2" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE3" |
RelationshipType | Identifying |
Relationship Name | F00396 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_RPT_TYPE_CODE3 |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE3" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_RPT_TYPE_CODE3" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"EMPL to UDT01" |
RelationshipType | Non-Identifying |
Relationship Name | F00402 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | UDT01 |
Existence | Optional |
"EMPL to UDT01" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to UDT01" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | INTERIM_EMPL_ID |
"EMPL to UDT02" |
RelationshipType | Non-Identifying |
Relationship Name | F00403 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | UDT02 |
Existence | Optional |
"EMPL to UDT02" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to UDT02" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | INTERIM_EMPL_ID |
"TS to TS_START_STOP" |
RelationshipType | Identifying |
Relationship Name | F00404 |
Relationship Business Name | |
Parent Table | TS |
Child Table | TS_START_STOP |
Existence | Mandatory |
"TS to TS_START_STOP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS to TS_START_STOP" Foreign Keys |
Parent Key | Child Key |
EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"PROVIDER to PROVIDER_VISA_SUPPLIER" |
RelationshipType | Identifying |
Relationship Name | F00409 |
Relationship Business Name | |
Parent Table | PROVIDER |
Child Table | PROVIDER_VISA_SUPPLIER |
Existence | Mandatory |
"PROVIDER to PROVIDER_VISA_SUPPLIER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROVIDER to PROVIDER_VISA_SUPPLIER" Foreign Keys |
Parent Key | Child Key |
PROVIDER_CD | PROVIDER_CD |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_FILTER_VISA" |
RelationshipType | Identifying |
Relationship Name | F00410 |
Relationship Business Name | |
Parent Table | EXP_BATCH_TYPE |
Child Table | EXP_BATCH_TYPE_FILTER_VISA |
Existence | Mandatory |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_FILTER_VISA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_FILTER_VISA" Foreign Keys |
Parent Key | Child Key |
EXP_BATCH_TYPE_CD | EXP_BATCH_TYPE_CD |
"VISA_TRANS_TYPE to EXP_BATCH_TYPE_FILTER_VISA" |
RelationshipType | Identifying |
Relationship Name | F00411 |
Relationship Business Name | |
Parent Table | VISA_TRANS_TYPE |
Child Table | EXP_BATCH_TYPE_FILTER_VISA |
Existence | Mandatory |
"VISA_TRANS_TYPE to EXP_BATCH_TYPE_FILTER_VISA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"VISA_TRANS_TYPE to EXP_BATCH_TYPE_FILTER_VISA" Foreign Keys |
Parent Key | Child Key |
VISA_TRANS_TYPE_CD | VISA_TRANS_TYPE_CD |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_VISA_WIZARD" |
RelationshipType | Identifying |
Relationship Name | F00412 |
Relationship Business Name | |
Parent Table | EXP_BATCH_TYPE |
Child Table | EXP_BATCH_TYPE_VISA_WIZARD |
Existence | Mandatory |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_VISA_WIZARD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_BATCH_TYPE to EXP_BATCH_TYPE_VISA_WIZARD" Foreign Keys |
Parent Key | Child Key |
EXP_BATCH_TYPE_CD | EXP_BATCH_TYPE_CD |
"PAY_METHOD to EXP_BATCH_TYPE_VISA_WIZARD" |
RelationshipType | Non-Identifying |
Relationship Name | F00413 |
Relationship Business Name | |
Parent Table | PAY_METHOD |
Child Table | EXP_BATCH_TYPE_VISA_WIZARD |
Existence | Mandatory |
"PAY_METHOD to EXP_BATCH_TYPE_VISA_WIZARD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PAY_METHOD to EXP_BATCH_TYPE_VISA_WIZARD" Foreign Keys |
Parent Key | Child Key |
PAY_METHOD_CD | PAY_METHOD_CD |
"PER_DIEM to PER_DIEM_EDIT" |
RelationshipType | Identifying |
Relationship Name | F00414 |
Relationship Business Name | |
Parent Table | PER_DIEM |
Child Table | PER_DIEM_EDIT |
Existence | Mandatory |
"PER_DIEM to PER_DIEM_EDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PER_DIEM to PER_DIEM_EDIT" Foreign Keys |
Parent Key | Child Key |
PER_DIEM_SCHEDULE_CD | PER_DIEM_SCHEDULE_CD |
"CHARGE_BRANCH_CHARGE to TS_LINE" |
RelationshipType | Non-Identifying |
Relationship Name | F00415 |
Relationship Business Name | |
Parent Table | CHARGE_BRANCH_CHARGE |
Child Table | TS_LINE |
Existence | Optional |
"CHARGE_BRANCH_CHARGE to TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE_BRANCH_CHARGE to TS_LINE" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD | CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD |
"CURRENCY to EXP_TYPE_RATE_CEILING" |
RelationshipType | Identifying |
Relationship Name | F00416 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_TYPE_RATE_CEILING |
Existence | Mandatory |
"CURRENCY to EXP_TYPE_RATE_CEILING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_TYPE_RATE_CEILING" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | CURRENCY_CD |
"EMPL to EMPL_CHARGE_FAVORITES_CP" |
RelationshipType | Identifying |
Relationship Name | F00417 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EMPL_CHARGE_FAVORITES_CP |
Existence | Mandatory |
"EMPL to EMPL_CHARGE_FAVORITES_CP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EMPL_CHARGE_FAVORITES_CP" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"EMPL_GROUP to EMPL_GROUP_CHARGE_FAVORITES_CP" |
RelationshipType | Identifying |
Relationship Name | F00418 |
Relationship Business Name | |
Parent Table | EMPL_GROUP |
Child Table | EMPL_GROUP_CHARGE_FAVORITES_CP |
Existence | Mandatory |
"EMPL_GROUP to EMPL_GROUP_CHARGE_FAVORITES_CP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL_GROUP to EMPL_GROUP_CHARGE_FAVORITES_CP" Foreign Keys |
Parent Key | Child Key |
EMPL_GROUP_CD | EMPL_GROUP_CD |
"CURRENCY to BATCH_EXPENSE_EDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00419 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | BATCH_EXPENSE_EDIT |
Existence | Mandatory |
"CURRENCY to BATCH_EXPENSE_EDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to BATCH_EXPENSE_EDIT" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | PAY_CURRENCY_CD |
"CURRENCY to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00420 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Mandatory |
"CURRENCY to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | PAY_CURRENCY_CD |
"CURRENCY to EXP_BATCH_TYPE" |
RelationshipType | Non-Identifying |
Relationship Name | F00421 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_BATCH_TYPE |
Existence | Optional |
"CURRENCY to EXP_BATCH_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_BATCH_TYPE" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | PAY_CURRENCY_CD |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_CHARGE_ALLOC" |
RelationshipType | Identifying |
Relationship Name | F00423 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_EXP_RPT_CHARGE_ALLOC |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_CHARGE_ALLOC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_CHARGE_ALLOC" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00424 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_EXPENSE |
Child Table | CORRECT_EXP_RPT_EXPENSE |
Existence | Optional |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID | EXP_RPT_ID, CORRECTION_NO, PARENT_EXPENSE_ID |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_EXPENSE" |
RelationshipType | Identifying |
Relationship Name | F00425 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_EXP_RPT_EXPENSE |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_CHARGE" |
RelationshipType | Identifying |
Relationship Name | F00426 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_EXPENSE |
Child Table | CORRECT_EXP_RPT_EXPENSE_CHARGE |
Existence | Mandatory |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID | EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_EXP_RPT_EXPENSE_CHARGE" |
RelationshipType | Identifying |
Relationship Name | F00427 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_CHARGE_ALLOC |
Child Table | CORRECT_EXP_RPT_EXPENSE_CHARGE |
Existence | Mandatory |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_EXP_RPT_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_EXP_RPT_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, ALLOCATION_ID | EXP_RPT_ID, CORRECTION_NO, ALLOCATION_ID |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_DAY" |
RelationshipType | Identifying |
Relationship Name | F00428 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_EXPENSE |
Child Table | CORRECT_EXP_RPT_EXPENSE_DAY |
Existence | Mandatory |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_DAY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_DAY" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID | EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_OTHER" |
RelationshipType | Identifying |
Relationship Name | F00429 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_EXPENSE |
Child Table | CORRECT_EXP_RPT_EXPENSE_OTHER |
Existence | Mandatory |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_OTHER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_OTHER" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID | EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_PAYMENT" |
RelationshipType | Identifying |
Relationship Name | F00431 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_EXP_RPT_PAYMENT |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_PAYMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_PAYMENT" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_REVISION" |
RelationshipType | Identifying |
Relationship Name | F00432 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_EXP_RPT_REVISION |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_REVISION" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_TASKS" |
RelationshipType | Identifying |
Relationship Name | F00433 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_EXP_RPT_TASKS |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_TASKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_TASKS" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"CORRECT_EXP_RPT_TASKS to CORRECT_EXP_RPT_TASKS_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00434 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_TASKS |
Child Table | CORRECT_EXP_RPT_TASKS_EMPL |
Existence | Mandatory |
"CORRECT_EXP_RPT_TASKS to CORRECT_EXP_RPT_TASKS_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_TASKS to CORRECT_EXP_RPT_TASKS_EMPL" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, ALLOCATION_ID, FUNCTIONAL_ROLE_CD, S_TASK_CD | EXP_RPT_ID, CORRECTION_NO, ALLOCATION_ID, FUNCTIONAL_ROLE_CD, S_TASK_CD |
"FUNCTIONAL_ROLE to CORRECT_EXP_RPT_TASKS_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00435 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | CORRECT_EXP_RPT_TASKS_EMPL |
Existence | Mandatory |
"FUNCTIONAL_ROLE to CORRECT_EXP_RPT_TASKS_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to CORRECT_EXP_RPT_TASKS_EMPL" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to CORRECT_EXP_RPT_TASKS_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00436 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_EXP_RPT_TASKS_EMPL |
Existence | Mandatory |
"EMPL to CORRECT_EXP_RPT_TASKS_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_EXP_RPT_TASKS_EMPL" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXP_ATTENDEE" |
RelationshipType | Identifying |
Relationship Name | F00437 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_EXPENSE |
Child Table | CORRECT_EXP_RPT_EXP_ATTENDEE |
Existence | Mandatory |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXP_ATTENDEE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXP_ATTENDEE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID | EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID |
"EMPL to CORRECT_ADVANCE_OUTSTANDING" |
RelationshipType | Identifying |
Relationship Name | F00438 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_ADVANCE_OUTSTANDING |
Existence | Mandatory |
"EMPL to CORRECT_ADVANCE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_ADVANCE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"CORRECT_EXP_RPT to CORRECT_ADVANCE_OUTSTANDING" |
RelationshipType | Identifying |
Relationship Name | F00439 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_ADVANCE_OUTSTANDING |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_ADVANCE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_ADVANCE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"CORRECT_EXP_RPT to CORRECT_BATCH_EXP_OUTSTANDING" |
RelationshipType | Identifying |
Relationship Name | F00440 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_BATCH_EXP_OUTSTANDING |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_BATCH_EXP_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_BATCH_EXP_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"SCREENS to MENU" |
RelationshipType | Non-Identifying |
Relationship Name | F00441 |
Relationship Business Name | |
Parent Table | SCREENS |
Child Table | MENU |
Existence | Optional |
"SCREENS to MENU" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCREENS to MENU" Foreign Keys |
Parent Key | Child Key |
SCREEN_CD | SCREEN_CD |
"EMPL to LOCATION" |
RelationshipType | Non-Identifying |
Relationship Name | F00442 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | LOCATION |
Existence | Optional |
"EMPL to LOCATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to LOCATION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | LOCATION_EMPL_ID |
"LOCATION to EXP_AUTH_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00443 |
Relationship Business Name | |
Parent Table | LOCATION |
Child Table | EXP_AUTH_EXPENSE |
Existence | Optional |
"LOCATION to EXP_AUTH_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LOCATION to EXP_AUTH_EXPENSE" Foreign Keys |
Parent Key | Child Key |
LOCATION_ID | LOCATION_ID |
"LOCATION to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00444 |
Relationship Business Name | |
Parent Table | LOCATION |
Child Table | EXP_RPT_EXPENSE |
Existence | Optional |
"LOCATION to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LOCATION to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
LOCATION_ID | LOCATION_ID |
"EXP_AUTH to EXP_AUTH_LOCATION" |
RelationshipType | Identifying |
Relationship Name | F00445 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | EXP_AUTH_LOCATION |
Existence | Mandatory |
"EXP_AUTH to EXP_AUTH_LOCATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to EXP_AUTH_LOCATION" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"LOCATION to EXP_AUTH_LOCATION" |
RelationshipType | Non-Identifying |
Relationship Name | F00446 |
Relationship Business Name | |
Parent Table | LOCATION |
Child Table | EXP_AUTH_LOCATION |
Existence | Mandatory |
"LOCATION to EXP_AUTH_LOCATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LOCATION to EXP_AUTH_LOCATION" Foreign Keys |
Parent Key | Child Key |
LOCATION_ID | LOCATION_ID |
"EXP_RPT to EXP_RPT_LOCATION" |
RelationshipType | Identifying |
Relationship Name | F00447 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | EXP_RPT_LOCATION |
Existence | Mandatory |
"EXP_RPT to EXP_RPT_LOCATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to EXP_RPT_LOCATION" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"LOCATION to EXP_RPT_LOCATION" |
RelationshipType | Non-Identifying |
Relationship Name | F00448 |
Relationship Business Name | |
Parent Table | LOCATION |
Child Table | EXP_RPT_LOCATION |
Existence | Mandatory |
"LOCATION to EXP_RPT_LOCATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LOCATION to EXP_RPT_LOCATION" Foreign Keys |
Parent Key | Child Key |
LOCATION_ID | LOCATION_ID |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_LOCATION" |
RelationshipType | Identifying |
Relationship Name | F00449 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_EXP_RPT_LOCATION |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_LOCATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_LOCATION" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"LOCATION to CORRECT_EXP_RPT_LOCATION" |
RelationshipType | Non-Identifying |
Relationship Name | F00450 |
Relationship Business Name | |
Parent Table | LOCATION |
Child Table | CORRECT_EXP_RPT_LOCATION |
Existence | Mandatory |
"LOCATION to CORRECT_EXP_RPT_LOCATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LOCATION to CORRECT_EXP_RPT_LOCATION" Foreign Keys |
Parent Key | Child Key |
LOCATION_ID | LOCATION_ID |
"COMPANY to GENERAL_CONFIG_ATTACHMENT" |
RelationshipType | Identifying |
Relationship Name | F00451 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | GENERAL_CONFIG_ATTACHMENT |
Existence | Mandatory |
"COMPANY to GENERAL_CONFIG_ATTACHMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to GENERAL_CONFIG_ATTACHMENT" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"COMPANY to GENERAL_CONFIG_ATTACHMENT_LBLS" |
RelationshipType | Identifying |
Relationship Name | F00452 |
Relationship Business Name | |
Parent Table | COMPANY |
Child Table | GENERAL_CONFIG_ATTACHMENT_LBLS |
Existence | Mandatory |
"COMPANY to GENERAL_CONFIG_ATTACHMENT_LBLS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"COMPANY to GENERAL_CONFIG_ATTACHMENT_LBLS" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"GENERAL_CONFIG_ATTACHMENT to GENERAL_CONFIG_ATTACHMENT_LBLS" |
RelationshipType | Identifying |
Relationship Name | F00453 |
Relationship Business Name | |
Parent Table | GENERAL_CONFIG_ATTACHMENT |
Child Table | GENERAL_CONFIG_ATTACHMENT_LBLS |
Existence | Mandatory |
"GENERAL_CONFIG_ATTACHMENT to GENERAL_CONFIG_ATTACHMENT_LBLS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GENERAL_CONFIG_ATTACHMENT to GENERAL_CONFIG_ATTACHMENT_LBLS" Foreign Keys |
Parent Key | Child Key |
ATTACHMENT_TYPE_CD | ATTACHMENT_TYPE_CD |
"GENERAL_CONFIG_ATTACHMENT to ATTACHMENT" |
RelationshipType | Non-Identifying |
Relationship Name | F00454 |
Relationship Business Name | |
Parent Table | GENERAL_CONFIG_ATTACHMENT |
Child Table | ATTACHMENT |
Existence | Mandatory |
"GENERAL_CONFIG_ATTACHMENT to ATTACHMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GENERAL_CONFIG_ATTACHMENT to ATTACHMENT" Foreign Keys |
Parent Key | Child Key |
ATTACHMENT_TYPE_CD | ATTACHMENT_TYPE_CD |
"EXP_TYPE to EXP_TYPE_TASK" |
RelationshipType | Identifying |
Relationship Name | F00455 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | EXP_TYPE_TASK |
Existence | Mandatory |
"EXP_TYPE to EXP_TYPE_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to EXP_TYPE_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"FUNCTIONAL_ROLE to EXP_TYPE_TASK" |
RelationshipType | Identifying |
Relationship Name | F00456 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | EXP_TYPE_TASK |
Existence | Mandatory |
"FUNCTIONAL_ROLE to EXP_TYPE_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to EXP_TYPE_TASK" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"GENERAL_CONFIG_ATTACHMENT to EXP_TYPE_TASK" |
RelationshipType | Identifying |
Relationship Name | F00457 |
Relationship Business Name | |
Parent Table | GENERAL_CONFIG_ATTACHMENT |
Child Table | EXP_TYPE_TASK |
Existence | Mandatory |
"GENERAL_CONFIG_ATTACHMENT to EXP_TYPE_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GENERAL_CONFIG_ATTACHMENT to EXP_TYPE_TASK" Foreign Keys |
Parent Key | Child Key |
ATTACHMENT_TYPE_CD | ATTACHMENT_TYPE_CD |
"EXP_RPT_TYPE to EXP_RPT_TYPE_TASK" |
RelationshipType | Identifying |
Relationship Name | F00458 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | EXP_RPT_TYPE_TASK |
Existence | Mandatory |
"EXP_RPT_TYPE to EXP_RPT_TYPE_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to EXP_RPT_TYPE_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"FUNCTIONAL_ROLE to EXP_RPT_TYPE_TASK" |
RelationshipType | Identifying |
Relationship Name | F00459 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | EXP_RPT_TYPE_TASK |
Existence | Mandatory |
"FUNCTIONAL_ROLE to EXP_RPT_TYPE_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to EXP_RPT_TYPE_TASK" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"GENERAL_CONFIG_ATTACHMENT to EXP_RPT_TYPE_TASK" |
RelationshipType | Identifying |
Relationship Name | F00460 |
Relationship Business Name | |
Parent Table | GENERAL_CONFIG_ATTACHMENT |
Child Table | EXP_RPT_TYPE_TASK |
Existence | Mandatory |
"GENERAL_CONFIG_ATTACHMENT to EXP_RPT_TYPE_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GENERAL_CONFIG_ATTACHMENT to EXP_RPT_TYPE_TASK" Foreign Keys |
Parent Key | Child Key |
ATTACHMENT_TYPE_CD | ATTACHMENT_TYPE_CD |
"FUNCTIONAL_ROLE to EXP_RPT_TYPE_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00461 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | EXP_RPT_TYPE_TASK |
Existence | Mandatory |
"FUNCTIONAL_ROLE to EXP_RPT_TYPE_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to EXP_RPT_TYPE_TASK" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | BACKUP_FUNCTIONAL_ROLE_CD |
"ATTACHMENT to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00470 |
Relationship Business Name | |
Parent Table | ATTACHMENT |
Child Table | TASK |
Existence | Optional |
"ATTACHMENT to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ATTACHMENT to TASK" Foreign Keys |
Parent Key | Child Key |
ATTACHMENT_ID | ATTACHMENT_ID |
"FUNCTIONAL_ROLE to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00471 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | TASK |
Existence | Mandatory |
"FUNCTIONAL_ROLE to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to TASK" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"FUNCTIONAL_ROLE to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00472 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | TASK |
Existence | Mandatory |
"FUNCTIONAL_ROLE to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to TASK" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | BACKUP_FUNCTIONAL_ROLE_CD |
"GENERAL_CONFIG_ATTACHMENT to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00473 |
Relationship Business Name | |
Parent Table | GENERAL_CONFIG_ATTACHMENT |
Child Table | TASK |
Existence | Mandatory |
"GENERAL_CONFIG_ATTACHMENT to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GENERAL_CONFIG_ATTACHMENT to TASK" Foreign Keys |
Parent Key | Child Key |
ATTACHMENT_TYPE_CD | ATTACHMENT_TYPE_CD |
"EMPL to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00474 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | TASK |
Existence | Optional |
"EMPL to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to TASK" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | TASK_EMPL_ID |
"FUNCTIONAL_ROLE to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00483 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | CORRECT_TASK |
Existence | Mandatory |
"FUNCTIONAL_ROLE to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"FUNCTIONAL_ROLE to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00484 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | CORRECT_TASK |
Existence | Mandatory |
"FUNCTIONAL_ROLE to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | BACKUP_FUNCTIONAL_ROLE_CD |
"GENERAL_CONFIG_ATTACHMENT to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00485 |
Relationship Business Name | |
Parent Table | GENERAL_CONFIG_ATTACHMENT |
Child Table | CORRECT_TASK |
Existence | Mandatory |
"GENERAL_CONFIG_ATTACHMENT to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GENERAL_CONFIG_ATTACHMENT to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
ATTACHMENT_TYPE_CD | ATTACHMENT_TYPE_CD |
"EMPL to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00486 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_TASK |
Existence | Optional |
"EMPL to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | TASK_EMPL_ID |
"TASK to TASK_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00488 |
Relationship Business Name | |
Parent Table | TASK |
Child Table | TASK_EMPL |
Existence | Mandatory |
"TASK to TASK_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TASK to TASK_EMPL" Foreign Keys |
Parent Key | Child Key |
TASK_ID | TASK_ID |
"EMPL to TASK_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00489 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | TASK_EMPL |
Existence | Mandatory |
"EMPL to TASK_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to TASK_EMPL" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"FUNCTIONAL_ROLE to TASK_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00490 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | TASK_EMPL |
Existence | Mandatory |
"FUNCTIONAL_ROLE to TASK_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to TASK_EMPL" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"CORRECT_TASK to CORRECT_TASK_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00491 |
Relationship Business Name | |
Parent Table | CORRECT_TASK |
Child Table | CORRECT_TASK_EMPL |
Existence | Mandatory |
"CORRECT_TASK to CORRECT_TASK_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TASK to CORRECT_TASK_EMPL" Foreign Keys |
Parent Key | Child Key |
TASK_ID, CORRECTION_NO | TASK_ID, CORRECTION_NO |
"EMPL to CORRECT_TASK_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00492 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_TASK_EMPL |
Existence | Mandatory |
"EMPL to CORRECT_TASK_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_TASK_EMPL" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"FUNCTIONAL_ROLE to CORRECT_TASK_EMPL" |
RelationshipType | Identifying |
Relationship Name | F00493 |
Relationship Business Name | |
Parent Table | FUNCTIONAL_ROLE |
Child Table | CORRECT_TASK_EMPL |
Existence | Mandatory |
"FUNCTIONAL_ROLE to CORRECT_TASK_EMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNCTIONAL_ROLE to CORRECT_TASK_EMPL" Foreign Keys |
Parent Key | Child Key |
FUNCTIONAL_ROLE_CD | FUNCTIONAL_ROLE_CD |
"EMPL to EXP_ADVANCE" |
RelationshipType | Non-Identifying |
Relationship Name | F00500 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_ADVANCE |
Existence | Mandatory |
"EMPL to EXP_ADVANCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_ADVANCE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | ADVANCE_EMPL_ID |
"EXP_AUTH to EXP_ADVANCE" |
RelationshipType | Non-Identifying |
Relationship Name | F00501 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | EXP_ADVANCE |
Existence | Optional |
"EXP_AUTH to EXP_ADVANCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to EXP_ADVANCE" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"CURRENCY to EXP_ADVANCE" |
RelationshipType | Non-Identifying |
Relationship Name | F00502 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_ADVANCE |
Existence | Mandatory |
"CURRENCY to EXP_ADVANCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_ADVANCE" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | PAY_CURRENCY_CD |
"CURRENCY to EXP_ADVANCE" |
RelationshipType | Non-Identifying |
Relationship Name | F00503 |
Relationship Business Name | |
Parent Table | CURRENCY |
Child Table | EXP_ADVANCE |
Existence | Mandatory |
"CURRENCY to EXP_ADVANCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CURRENCY to EXP_ADVANCE" Foreign Keys |
Parent Key | Child Key |
CURRENCY_CD | BASE_CURRENCY_CD |
"EXP_ADVANCE to EXP_ADVANCE_REVISION" |
RelationshipType | Identifying |
Relationship Name | F00504 |
Relationship Business Name | |
Parent Table | EXP_ADVANCE |
Child Table | EXP_ADVANCE_REVISION |
Existence | Mandatory |
"EXP_ADVANCE to EXP_ADVANCE_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_ADVANCE to EXP_ADVANCE_REVISION" Foreign Keys |
Parent Key | Child Key |
ADVANCE_ID | ADVANCE_ID |
"EMPL to EXP_ADVANCE_REVISION" |
RelationshipType | Non-Identifying |
Relationship Name | F00505 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_ADVANCE_REVISION |
Existence | Optional |
"EMPL to EXP_ADVANCE_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_ADVANCE_REVISION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | REVISION_EMPL_ID |
"EXP_AUTH to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00506 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | TASK |
Existence | Optional |
"EXP_AUTH to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to TASK" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"EXP_RPT to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00507 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | TASK |
Existence | Optional |
"EXP_RPT to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to TASK" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EXP_AUTH_EXPENSE to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00508 |
Relationship Business Name | |
Parent Table | EXP_AUTH_EXPENSE |
Child Table | TASK |
Existence | Optional |
"EXP_AUTH_EXPENSE to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_EXPENSE to TASK" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, EXPENSE_ID | EXP_AUTH_ID, EA_EXPENSE_ID |
"EXP_RPT_EXPENSE to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00509 |
Relationship Business Name | |
Parent Table | EXP_RPT_EXPENSE |
Child Table | TASK |
Existence | Optional |
"EXP_RPT_EXPENSE to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_EXPENSE to TASK" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, EXPENSE_ID | EXP_RPT_ID, ER_EXPENSE_ID |
"EXP_AUTH_EXPENSE_CHARGE to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00510 |
Relationship Business Name | |
Parent Table | EXP_AUTH_EXPENSE_CHARGE |
Child Table | TASK |
Existence | Optional |
"EXP_AUTH_EXPENSE_CHARGE to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_EXPENSE_CHARGE to TASK" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, EXPENSE_ID, ALLOCATION_ID | EXP_AUTH_ID, EA_EXPENSE_ID, EA_ALLOCATION_ID |
"EXP_AUTH_CHARGE_ALLOCATIONS to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00512 |
Relationship Business Name | |
Parent Table | EXP_AUTH_CHARGE_ALLOCATIONS |
Child Table | TASK |
Existence | Optional |
"EXP_AUTH_CHARGE_ALLOCATIONS to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_CHARGE_ALLOCATIONS to TASK" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, ALLOCATION_ID | EXP_AUTH_ID, EA_ALLOCATION_ID |
"EXP_RPT_CHARGE_ALLOCATIONS to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00513 |
Relationship Business Name | |
Parent Table | EXP_RPT_CHARGE_ALLOCATIONS |
Child Table | TASK |
Existence | Optional |
"EXP_RPT_CHARGE_ALLOCATIONS to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_CHARGE_ALLOCATIONS to TASK" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, ALLOCATION_ID | EXP_RPT_ID, ER_ALLOCATION_ID |
"EXP_ADVANCE to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00514 |
Relationship Business Name | |
Parent Table | EXP_ADVANCE |
Child Table | CORRECT_TASK |
Existence | Optional |
"EXP_ADVANCE to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_ADVANCE to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
ADVANCE_ID | ADVANCE_ID |
"EXP_AUTH to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00515 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | CORRECT_TASK |
Existence | Optional |
"EXP_AUTH to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"EXP_RPT to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00516 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | CORRECT_TASK |
Existence | Optional |
"EXP_RPT to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EXP_AUTH_EXPENSE to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00517 |
Relationship Business Name | |
Parent Table | EXP_AUTH_EXPENSE |
Child Table | CORRECT_TASK |
Existence | Optional |
"EXP_AUTH_EXPENSE to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_EXPENSE to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, EXPENSE_ID | EXP_AUTH_ID, EA_EXPENSE_ID |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00518 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_EXPENSE |
Child Table | CORRECT_TASK |
Existence | Optional |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID | EXP_RPT_ID, CORRECTION_NO, ER_EXPENSE_ID |
"EXP_AUTH_EXPENSE_CHARGE to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00519 |
Relationship Business Name | |
Parent Table | EXP_AUTH_EXPENSE_CHARGE |
Child Table | CORRECT_TASK |
Existence | Optional |
"EXP_AUTH_EXPENSE_CHARGE to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_EXPENSE_CHARGE to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, EXPENSE_ID, ALLOCATION_ID | EXP_AUTH_ID, EA_EXPENSE_ID, EA_ALLOCATION_ID |
"EXP_AUTH_CHARGE_ALLOCATIONS to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00521 |
Relationship Business Name | |
Parent Table | EXP_AUTH_CHARGE_ALLOCATIONS |
Child Table | CORRECT_TASK |
Existence | Optional |
"EXP_AUTH_CHARGE_ALLOCATIONS to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_CHARGE_ALLOCATIONS to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, ALLOCATION_ID | EXP_AUTH_ID, EA_ALLOCATION_ID |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00522 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_CHARGE_ALLOC |
Child Table | CORRECT_TASK |
Existence | Optional |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_TASK" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, ALLOCATION_ID | EXP_RPT_ID, CORRECTION_NO, ER_ALLOCATION_ID |
"EXP_ADVANCE to TASK" |
RelationshipType | Non-Identifying |
Relationship Name | F00523 |
Relationship Business Name | |
Parent Table | EXP_ADVANCE |
Child Table | TASK |
Existence | Optional |
"EXP_ADVANCE to TASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_ADVANCE to TASK" Foreign Keys |
Parent Key | Child Key |
ADVANCE_ID | ADVANCE_ID |
"EXP_AUTH to EXP_AUTH_WARNING" |
RelationshipType | Identifying |
Relationship Name | F00524 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | EXP_AUTH_WARNING |
Existence | Mandatory |
"EXP_AUTH to EXP_AUTH_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to EXP_AUTH_WARNING" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"EMPL to EXP_AUTH_WARNING" |
RelationshipType | Non-Identifying |
Relationship Name | F00525 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_AUTH_WARNING |
Existence | Mandatory |
"EMPL to EXP_AUTH_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_AUTH_WARNING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"EXP_AUTH_EXPENSE to EXP_AUTH_EXPENSE_WARNING" |
RelationshipType | Identifying |
Relationship Name | F00526 |
Relationship Business Name | |
Parent Table | EXP_AUTH_EXPENSE |
Child Table | EXP_AUTH_EXPENSE_WARNING |
Existence | Mandatory |
"EXP_AUTH_EXPENSE to EXP_AUTH_EXPENSE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_EXPENSE to EXP_AUTH_EXPENSE_WARNING" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, EXPENSE_ID | EXP_AUTH_ID, EXPENSE_ID |
"EMPL to EXP_AUTH_EXPENSE_WARNING" |
RelationshipType | Non-Identifying |
Relationship Name | F00527 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_AUTH_EXPENSE_WARNING |
Existence | Mandatory |
"EMPL to EXP_AUTH_EXPENSE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_AUTH_EXPENSE_WARNING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"EXP_AUTH_CHARGE_ALLOCATIONS to EXP_AUTH_CHARGE_WARNING" |
RelationshipType | Identifying |
Relationship Name | F00528 |
Relationship Business Name | |
Parent Table | EXP_AUTH_CHARGE_ALLOCATIONS |
Child Table | EXP_AUTH_CHARGE_WARNING |
Existence | Mandatory |
"EXP_AUTH_CHARGE_ALLOCATIONS to EXP_AUTH_CHARGE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_CHARGE_ALLOCATIONS to EXP_AUTH_CHARGE_WARNING" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, ALLOCATION_ID | EXP_AUTH_ID, ALLOCATION_ID |
"EMPL to EXP_AUTH_CHARGE_WARNING" |
RelationshipType | Non-Identifying |
Relationship Name | F00529 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_AUTH_CHARGE_WARNING |
Existence | Mandatory |
"EMPL to EXP_AUTH_CHARGE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_AUTH_CHARGE_WARNING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"EXP_RPT to EXP_RPT_WARNING" |
RelationshipType | Identifying |
Relationship Name | F00530 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | EXP_RPT_WARNING |
Existence | Mandatory |
"EXP_RPT to EXP_RPT_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to EXP_RPT_WARNING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EMPL to EXP_RPT_WARNING" |
RelationshipType | Non-Identifying |
Relationship Name | F00531 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_RPT_WARNING |
Existence | Mandatory |
"EMPL to EXP_RPT_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_RPT_WARNING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_WARNING" |
RelationshipType | Identifying |
Relationship Name | F00532 |
Relationship Business Name | |
Parent Table | EXP_RPT_EXPENSE |
Child Table | EXP_RPT_EXPENSE_WARNING |
Existence | Mandatory |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_EXPENSE to EXP_RPT_EXPENSE_WARNING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, EXPENSE_ID | EXP_RPT_ID, EXPENSE_ID |
"EMPL to EXP_RPT_EXPENSE_WARNING" |
RelationshipType | Non-Identifying |
Relationship Name | F00533 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_RPT_EXPENSE_WARNING |
Existence | Mandatory |
"EMPL to EXP_RPT_EXPENSE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_RPT_EXPENSE_WARNING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"EXP_RPT_CHARGE_ALLOCATIONS to EXP_RPT_CHARGE_WARNING" |
RelationshipType | Identifying |
Relationship Name | F00534 |
Relationship Business Name | |
Parent Table | EXP_RPT_CHARGE_ALLOCATIONS |
Child Table | EXP_RPT_CHARGE_WARNING |
Existence | Mandatory |
"EXP_RPT_CHARGE_ALLOCATIONS to EXP_RPT_CHARGE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_CHARGE_ALLOCATIONS to EXP_RPT_CHARGE_WARNING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, ALLOCATION_ID | EXP_RPT_ID, ALLOCATION_ID |
"EMPL to EXP_RPT_CHARGE_WARNING" |
RelationshipType | Non-Identifying |
Relationship Name | F00535 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | EXP_RPT_CHARGE_WARNING |
Existence | Mandatory |
"EMPL to EXP_RPT_CHARGE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to EXP_RPT_CHARGE_WARNING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_WARNING" |
RelationshipType | Identifying |
Relationship Name | F00536 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT |
Child Table | CORRECT_EXP_RPT_WARNING |
Existence | Mandatory |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT to CORRECT_EXP_RPT_WARNING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO | EXP_RPT_ID, CORRECTION_NO |
"EMPL to CORRECT_EXP_RPT_WARNING" |
RelationshipType | Non-Identifying |
Relationship Name | F00537 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_EXP_RPT_WARNING |
Existence | Mandatory |
"EMPL to CORRECT_EXP_RPT_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_EXP_RPT_WARNING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_WARN" |
RelationshipType | Identifying |
Relationship Name | F00538 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_EXPENSE |
Child Table | CORRECT_EXP_RPT_EXPENSE_WARN |
Existence | Mandatory |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_WARN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_EXPENSE to CORRECT_EXP_RPT_EXPENSE_WARN" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID | EXP_RPT_ID, CORRECTION_NO, EXPENSE_ID |
"EMPL to CORRECT_EXP_RPT_EXPENSE_WARN" |
RelationshipType | Non-Identifying |
Relationship Name | F00539 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_EXP_RPT_EXPENSE_WARN |
Existence | Mandatory |
"EMPL to CORRECT_EXP_RPT_EXPENSE_WARN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_EXP_RPT_EXPENSE_WARN" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_EXP_RPT_CHARGE_WARNING" |
RelationshipType | Identifying |
Relationship Name | F00540 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_CHARGE_ALLOC |
Child Table | CORRECT_EXP_RPT_CHARGE_WARNING |
Existence | Mandatory |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_EXP_RPT_CHARGE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_CHARGE_ALLOC to CORRECT_EXP_RPT_CHARGE_WARNING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, ALLOCATION_ID | EXP_RPT_ID, CORRECTION_NO, ALLOCATION_ID |
"EMPL to CORRECT_EXP_RPT_CHARGE_WARNING" |
RelationshipType | Non-Identifying |
Relationship Name | F00541 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_EXP_RPT_CHARGE_WARNING |
Existence | Mandatory |
"EMPL to CORRECT_EXP_RPT_CHARGE_WARNING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_EXP_RPT_CHARGE_WARNING" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | WARNING_EMPL_ID |
"EXP_RPT_LOCATION to EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00542 |
Relationship Business Name | |
Parent Table | EXP_RPT_LOCATION |
Child Table | EXP_RPT_EXPENSE |
Existence | Optional |
"EXP_RPT_LOCATION to EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_LOCATION to EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, LOCATION_NO | EXP_RPT_ID, LOCATION_NO |
"EXP_AUTH_LOCATION to EXP_AUTH_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00543 |
Relationship Business Name | |
Parent Table | EXP_AUTH_LOCATION |
Child Table | EXP_AUTH_EXPENSE |
Existence | Optional |
"EXP_AUTH_LOCATION to EXP_AUTH_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH_LOCATION to EXP_AUTH_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID, LOCATION_NO | EXP_AUTH_ID, LOCATION_NO |
"CORRECT_EXP_RPT_LOCATION to CORRECT_EXP_RPT_EXPENSE" |
RelationshipType | Non-Identifying |
Relationship Name | F00544 |
Relationship Business Name | |
Parent Table | CORRECT_EXP_RPT_LOCATION |
Child Table | CORRECT_EXP_RPT_EXPENSE |
Existence | Optional |
"CORRECT_EXP_RPT_LOCATION to CORRECT_EXP_RPT_EXPENSE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_EXP_RPT_LOCATION to CORRECT_EXP_RPT_EXPENSE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID, CORRECTION_NO, LOCATION_NO | EXP_RPT_ID, CORRECTION_NO, LOCATION_NO |
"EXP_RPT to EXP_RPT_ADVANCE" |
RelationshipType | Identifying |
Relationship Name | F00546 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | EXP_RPT_ADVANCE |
Existence | Mandatory |
"EXP_RPT to EXP_RPT_ADVANCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to EXP_RPT_ADVANCE" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EXP_ADVANCE to EXP_RPT_ADVANCE" |
RelationshipType | Identifying |
Relationship Name | F00547 |
Relationship Business Name | |
Parent Table | EXP_ADVANCE |
Child Table | EXP_RPT_ADVANCE |
Existence | Mandatory |
"EXP_ADVANCE to EXP_RPT_ADVANCE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_ADVANCE to EXP_RPT_ADVANCE" Foreign Keys |
Parent Key | Child Key |
ADVANCE_ID | ADVANCE_ID |
"EXP_RPT_TYPE to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00548 |
Relationship Business Name | |
Parent Table | EXP_RPT_TYPE |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Optional |
"EXP_RPT_TYPE to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT_TYPE to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_TYPE_CD | EXP_RPT_TYPE_CD |
"EXP_TYPE to BATCH_EXPENSE_OUTSTANDING" |
RelationshipType | Non-Identifying |
Relationship Name | F00549 |
Relationship Business Name | |
Parent Table | EXP_TYPE |
Child Table | BATCH_EXPENSE_OUTSTANDING |
Existence | Optional |
"EXP_TYPE to BATCH_EXPENSE_OUTSTANDING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_TYPE to BATCH_EXPENSE_OUTSTANDING" Foreign Keys |
Parent Key | Child Key |
EXP_TYPE_CD | EXP_TYPE_CD |
"BATCH_EXPENSE_OUTSTANDING to BATCH_EXP_OUTSTANDING_ATTACH" |
RelationshipType | Identifying |
Relationship Name | F00550 |
Relationship Business Name | |
Parent Table | BATCH_EXPENSE_OUTSTANDING |
Child Table | BATCH_EXP_OUTSTANDING_ATTACH |
Existence | Mandatory |
"BATCH_EXPENSE_OUTSTANDING to BATCH_EXP_OUTSTANDING_ATTACH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BATCH_EXPENSE_OUTSTANDING to BATCH_EXP_OUTSTANDING_ATTACH" Foreign Keys |
Parent Key | Child Key |
EXP_BATCH_ID, EXP_BATCH_TYPE_CD, TRANSACTION_ID | EXP_BATCH_ID, EXP_BATCH_TYPE_CD, TRANSACTION_ID |
"EMPL to CORRECT_TS" |
RelationshipType | Identifying |
Relationship Name | F00551 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_TS |
Existence | Mandatory |
"EMPL to CORRECT_TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_TS" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"TS_SCHEDULE_PERIOD to CORRECT_TS" |
RelationshipType | Identifying |
Relationship Name | F00552 |
Relationship Business Name | |
Parent Table | TS_SCHEDULE_PERIOD |
Child Table | CORRECT_TS |
Existence | Mandatory |
"TS_SCHEDULE_PERIOD to CORRECT_TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TS_SCHEDULE_PERIOD to CORRECT_TS" Foreign Keys |
Parent Key | Child Key |
TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"CLASS to CORRECT_TS" |
RelationshipType | Non-Identifying |
Relationship Name | F00553 |
Relationship Business Name | |
Parent Table | CLASS |
Child Table | CORRECT_TS |
Existence | Mandatory |
"CLASS to CORRECT_TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CLASS to CORRECT_TS" Foreign Keys |
Parent Key | Child Key |
CLASS_CD | CLASS_CD |
"WORK_SCHEDULE to CORRECT_TS" |
RelationshipType | Non-Identifying |
Relationship Name | F00554 |
Relationship Business Name | |
Parent Table | WORK_SCHEDULE |
Child Table | CORRECT_TS |
Existence | Mandatory |
"WORK_SCHEDULE to CORRECT_TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WORK_SCHEDULE to CORRECT_TS" Foreign Keys |
Parent Key | Child Key |
WORK_SCHEDULE_CD | WORK_SCHEDULE_CD |
"CP_COMPANY to CORRECT_TS" |
RelationshipType | Non-Identifying |
Relationship Name | F00555 |
Relationship Business Name | |
Parent Table | CP_COMPANY |
Child Table | CORRECT_TS |
Existence | Mandatory |
"CP_COMPANY to CORRECT_TS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CP_COMPANY to CORRECT_TS" Foreign Keys |
Parent Key | Child Key |
CP_COMPANY_CD | CP_COMPANY_CD |
"CORRECT_TS to CORRECT_TS_LINE" |
RelationshipType | Identifying |
Relationship Name | F00556 |
Relationship Business Name | |
Parent Table | CORRECT_TS |
Child Table | CORRECT_TS_LINE |
Existence | Mandatory |
"CORRECT_TS to CORRECT_TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS to CORRECT_TS_LINE" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"UDT01 to CORRECT_TS_LINE" |
RelationshipType | Non-Identifying |
Relationship Name | F00557 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | CORRECT_TS_LINE |
Existence | Mandatory |
"UDT01 to CORRECT_TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to CORRECT_TS_LINE" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"UDT10 to CORRECT_TS_LINE" |
RelationshipType | Non-Identifying |
Relationship Name | F00558 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | CORRECT_TS_LINE |
Existence | Mandatory |
"UDT10 to CORRECT_TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to CORRECT_TS_LINE" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | UDT10_ID |
"EMPL to CORRECT_TS_LINE" |
RelationshipType | Non-Identifying |
Relationship Name | F00559 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_TS_LINE |
Existence | Optional |
"EMPL to CORRECT_TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_TS_LINE" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | APPROVE_REJECT_EMPL_ID |
"CHARGE_BRANCH_CHARGE to CORRECT_TS_LINE" |
RelationshipType | Non-Identifying |
Relationship Name | F00560 |
Relationship Business Name | |
Parent Table | CHARGE_BRANCH_CHARGE |
Child Table | CORRECT_TS_LINE |
Existence | Optional |
"CHARGE_BRANCH_CHARGE to CORRECT_TS_LINE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CHARGE_BRANCH_CHARGE to CORRECT_TS_LINE" Foreign Keys |
Parent Key | Child Key |
CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD | CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD |
"CORRECT_TS_LINE to CORRECT_TS_CELL" |
RelationshipType | Identifying |
Relationship Name | F00561 |
Relationship Business Name | |
Parent Table | CORRECT_TS_LINE |
Child Table | CORRECT_TS_CELL |
Existence | Mandatory |
"CORRECT_TS_LINE to CORRECT_TS_CELL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS_LINE to CORRECT_TS_CELL" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO |
"CORRECT_TS to CORRECT_TS_REVISION" |
RelationshipType | Identifying |
Relationship Name | F00562 |
Relationship Business Name | |
Parent Table | CORRECT_TS |
Child Table | CORRECT_TS_REVISION |
Existence | Mandatory |
"CORRECT_TS to CORRECT_TS_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS to CORRECT_TS_REVISION" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"EMPL to CORRECT_TS_REVISION" |
RelationshipType | Non-Identifying |
Relationship Name | F00563 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_TS_REVISION |
Existence | Optional |
"EMPL to CORRECT_TS_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_TS_REVISION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | SIGN_EMPL_ID |
"EMPL to CORRECT_TS_REVISION" |
RelationshipType | Non-Identifying |
Relationship Name | F00564 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_TS_REVISION |
Existence | Optional |
"EMPL to CORRECT_TS_REVISION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_TS_REVISION" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | APPROVE_EMPL_ID |
"CORRECT_TS_REVISION to CORRECT_TS_AUDIT" |
RelationshipType | Identifying |
Relationship Name | F00565 |
Relationship Business Name | |
Parent Table | CORRECT_TS_REVISION |
Child Table | CORRECT_TS_AUDIT |
Existence | Mandatory |
"CORRECT_TS_REVISION to CORRECT_TS_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS_REVISION to CORRECT_TS_AUDIT" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, REVISION_NO | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, REVISION_NO |
"EMPL to CORRECT_TS_AUDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00566 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_TS_AUDIT |
Existence | Mandatory |
"EMPL to CORRECT_TS_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_TS_AUDIT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | REVISION_EMPL_ID |
"CORRECT_TS_CELL to CORRECT_TS_AUDIT" |
RelationshipType | Non-Identifying |
Relationship Name | F00567 |
Relationship Business Name | |
Parent Table | CORRECT_TS_CELL |
Child Table | CORRECT_TS_AUDIT |
Existence | Optional |
"CORRECT_TS_CELL to CORRECT_TS_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS_CELL to CORRECT_TS_AUDIT" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO, HRS_DT | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO, HRS_DT |
"CORRECT_TS to CORRECT_TS_DAY" |
RelationshipType | Identifying |
Relationship Name | F00568 |
Relationship Business Name | |
Parent Table | CORRECT_TS |
Child Table | CORRECT_TS_DAY |
Existence | Mandatory |
"CORRECT_TS to CORRECT_TS_DAY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS to CORRECT_TS_DAY" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"EMPL to CORRECT_TS_EXPORT_ADJUSTMENT" |
RelationshipType | Identifying |
Relationship Name | F00569 |
Relationship Business Name | |
Parent Table | EMPL |
Child Table | CORRECT_TS_EXPORT_ADJUSTMENT |
Existence | Mandatory |
"EMPL to CORRECT_TS_EXPORT_ADJUSTMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPL to CORRECT_TS_EXPORT_ADJUSTMENT" Foreign Keys |
Parent Key | Child Key |
EMPL_ID | EMPL_ID |
"CORRECT_TS to CORRECT_TS_EXPORT_ADJUSTMENT" |
RelationshipType | Identifying |
Relationship Name | F00570 |
Relationship Business Name | |
Parent Table | CORRECT_TS |
Child Table | CORRECT_TS_EXPORT_ADJUSTMENT |
Existence | Mandatory |
"CORRECT_TS to CORRECT_TS_EXPORT_ADJUSTMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS to CORRECT_TS_EXPORT_ADJUSTMENT" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"CORRECT_TS to CORRECT_TS_INVOICE" |
RelationshipType | Identifying |
Relationship Name | F00571 |
Relationship Business Name | |
Parent Table | CORRECT_TS |
Child Table | CORRECT_TS_INVOICE |
Existence | Mandatory |
"CORRECT_TS to CORRECT_TS_INVOICE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS to CORRECT_TS_INVOICE" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"CORRECT_TS to CORRECT_TS_START_STOP" |
RelationshipType | Identifying |
Relationship Name | F00572 |
Relationship Business Name | |
Parent Table | CORRECT_TS |
Child Table | CORRECT_TS_START_STOP |
Existence | Mandatory |
"CORRECT_TS to CORRECT_TS_START_STOP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CORRECT_TS to CORRECT_TS_START_STOP" Foreign Keys |
Parent Key | Child Key |
CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD | CORRECTION_NO, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD |
"UDT01 to EXP_AUTH_EXPENSE_CHARGE" |
RelationshipType | Non-Identifying |
Relationship Name | F00573 |
Relationship Business Name | |
Parent Table | UDT01 |
Child Table | EXP_AUTH_EXPENSE_CHARGE |
Existence | Optional |
"UDT01 to EXP_AUTH_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT01 to EXP_AUTH_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
UDT01_ID | UDT01_ID |
"UDT10 to EXP_AUTH_EXPENSE_CHARGE" |
RelationshipType | Non-Identifying |
Relationship Name | F00574 |
Relationship Business Name | |
Parent Table | UDT10 |
Child Table | EXP_AUTH_EXPENSE_CHARGE |
Existence | Optional |
"UDT10 to EXP_AUTH_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UDT10 to EXP_AUTH_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
UDT10_ID | UDT10_ID |
"EXP_CHARGE_TYPE to EXP_AUTH_EXPENSE_CHARGE" |
RelationshipType | Non-Identifying |
Relationship Name | F00575 |
Relationship Business Name | |
Parent Table | EXP_CHARGE_TYPE |
Child Table | EXP_AUTH_EXPENSE_CHARGE |
Existence | Optional |
"EXP_CHARGE_TYPE to EXP_AUTH_EXPENSE_CHARGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_CHARGE_TYPE to EXP_AUTH_EXPENSE_CHARGE" Foreign Keys |
Parent Key | Child Key |
EXP_CHARGE_TYPE_CD | EXP_CHARGE_TYPE_CD |
"EXP_RPT to EXP_RPT_ATTACHMENT" |
RelationshipType | Non-Identifying |
Relationship Name | F00576 |
Relationship Business Name | |
Parent Table | EXP_RPT |
Child Table | EXP_RPT_ATTACHMENT |
Existence | Optional |
"EXP_RPT to EXP_RPT_ATTACHMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_RPT to EXP_RPT_ATTACHMENT" Foreign Keys |
Parent Key | Child Key |
EXP_RPT_ID | EXP_RPT_ID |
"EXP_AUTH to EXP_RPT_ATTACHMENT" |
RelationshipType | Non-Identifying |
Relationship Name | F00577 |
Relationship Business Name | |
Parent Table | EXP_AUTH |
Child Table | EXP_RPT_ATTACHMENT |
Existence | Optional |
"EXP_AUTH to EXP_RPT_ATTACHMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_AUTH to EXP_RPT_ATTACHMENT" Foreign Keys |
Parent Key | Child Key |
EXP_AUTH_ID | EXP_AUTH_ID |
"EXP_ADVANCE to EXP_RPT_ATTACHMENT" |
RelationshipType | Non-Identifying |
Relationship Name | F00578 |
Relationship Business Name | |
Parent Table | EXP_ADVANCE |
Child Table | EXP_RPT_ATTACHMENT |
Existence | Optional |
"EXP_ADVANCE to EXP_RPT_ATTACHMENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXP_ADVANCE to EXP_RPT_ATTACHMENT" Foreign Keys |
Parent Key | Child Key |
ADVANCE_ID | ADVANCE_ID |