"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