IMPORT_CHARGE.SI_0029 |
Entity Name | IMPORT_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_CHARGE.SI_0029 Index Columns |
IMPORT_EMPL.SI_0009 |
Entity Name | IMPORT_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_EMPL.SI_0009 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
EMPL_ID |
IMPORT_EMPL_GROUP.SI_0010 |
Entity Name | IMPORT_EMPL_GROUP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_EMPL_GROUP.SI_0010 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
EMPL_GROUP_CD | |
S_IMPORT_TYPE_CD |
IMPORT_EMPL_HISTORY.SI_0011 |
Entity Name | IMPORT_EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_EMPL_HISTORY.SI_0011 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
EMPL_ID | |
EFFECTIVE_DT |
IMPORT_EMPL_LEAVE.SI_0012 |
Entity Name | IMPORT_EMPL_LEAVE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_EMPL_LEAVE.SI_0012 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP |
IMPORT_LINK12.SI_0013 |
Entity Name | IMPORT_LINK12 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_LINK12.SI_0013 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT01_ID | |
UDT02_ID |
IMPORT_LINK17.SI_0014 |
Entity Name | IMPORT_LINK17 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_LINK17.SI_0014 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT01_ID | |
UDT07_ID |
IMPORT_LINK19.SI_0015 |
Entity Name | IMPORT_LINK19 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_LINK19.SI_0015 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT01_ID | |
UDT09_ID |
IMPORT_LINK27.SI_0016 |
Entity Name | IMPORT_LINK27 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_LINK27.SI_0016 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT02_ID | |
UDT07_ID |
IMPORT_LINK29.SI_0017 |
Entity Name | IMPORT_LINK29 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_LINK29.SI_0017 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT02_ID | |
UDT09_ID |
IMPORT_LINK93.SI_0018 |
Entity Name | IMPORT_LINK93 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_LINK93.SI_0018 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT09_ID | |
UDT03_ID |
IMPORT_REJECTION.SI_0030 |
Entity Name | IMPORT_REJECTION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_REJECTION.SI_0030 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
S_REJECT_TYPE_CD | |
BATCH_ID | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
IMPORT_UDT01.SI_0019 |
Entity Name | IMPORT_UDT01 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT01.SI_0019 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT01_ID |
IMPORT_UDT02.SI_0020 |
Entity Name | IMPORT_UDT02 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT02.SI_0020 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT02_ID |
IMPORT_UDT03.SI_0021 |
Entity Name | IMPORT_UDT03 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT03.SI_0021 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT03_ID |
IMPORT_UDT04.SI_0022 |
Entity Name | IMPORT_UDT04 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT04.SI_0022 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT04_ID |
IMPORT_UDT05.SI_0023 |
Entity Name | IMPORT_UDT05 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT05.SI_0023 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT05_ID |
IMPORT_UDT06.SI_0024 |
Entity Name | IMPORT_UDT06 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT06.SI_0024 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT06_ID |
IMPORT_UDT07.SI_0025 |
Entity Name | IMPORT_UDT07 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT07.SI_0025 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT07_ID |
IMPORT_UDT08.SI_0026 |
Entity Name | IMPORT_UDT08 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT08.SI_0026 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT08_ID |
IMPORT_UDT09.SI_0027 |
Entity Name | IMPORT_UDT09 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT09.SI_0027 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT09_ID |
IMPORT_UDT10.SI_0028 |
Entity Name | IMPORT_UDT10 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_UDT10.SI_0028 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
S_IMPORT_CD | |
TIME_STAMP | |
EXTERNAL_USER | |
UDT10_ID |
S_CHILD_PARENT.SI_1123 |
Entity Name | S_CHILD_PARENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
S_CHILD_PARENT.SI_1123 Index Columns |
ColumnName | Sort Order |
CON_STRAINT | |
CHILD_NAME | |
PARENT_NAME | |
SEQ_NO |
SCHEMA_CONFIG.PI_0121 |
Entity Name | SCHEMA_CONFIG |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
SCHEMA_CONFIG.PI_0121 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID |
SCHEMA_TRANSLATION.PI_0000 |
Entity Name | SCHEMA_TRANSLATION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
SCHEMA_TRANSLATION.PI_0000 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID |
USER_INFO.RI_F00081 |
Entity Name | USER_INFO |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
USER_INFO.RI_F00081 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID |
USER_INFO.PI_0112 |
Entity Name | USER_INFO |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
USER_INFO.PI_0112 Index Columns |
ColumnName | Sort Order |
LOGIN_ID | |
USER_COMPANY_ID |
USER_PASSWORD.RI_F00082 |
Entity Name | USER_PASSWORD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
USER_PASSWORD.RI_F00082 Index Columns |
ColumnName | Sort Order |
LOGIN_ID | |
USER_COMPANY_ID |
USER_PASSWORD.PI_0113 |
Entity Name | USER_PASSWORD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
USER_PASSWORD.PI_0113 Index Columns |
ColumnName | Sort Order |
USER_COMPANY_ID | |
LOGIN_ID | |
EFFECTIVE_DTT |