ADVANCE_OUTSTANDING.RI_F00305 |
Entity Name | ADVANCE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ADVANCE_OUTSTANDING.RI_F00305 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
ADVANCE_OUTSTANDING.RI_F00374 |
Entity Name | ADVANCE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ADVANCE_OUTSTANDING.RI_F00374 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID |
ADVANCE_OUTSTANDING.RI_F00308 |
Entity Name | ADVANCE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ADVANCE_OUTSTANDING.RI_F00308 Index Columns |
ColumnName | Sort Order |
BASE_CURRENCY_CD |
ADVANCE_OUTSTANDING.RI_F00307 |
Entity Name | ADVANCE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ADVANCE_OUTSTANDING.RI_F00307 Index Columns |
ColumnName | Sort Order |
PAY_CURRENCY_CD |
ADVANCE_OUTSTANDING.RI_F00306 |
Entity Name | ADVANCE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ADVANCE_OUTSTANDING.RI_F00306 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID |
ADVANCE_OUTSTANDING.PI_0227 |
Entity Name | ADVANCE_OUTSTANDING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
ADVANCE_OUTSTANDING.PI_0227 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
ADVANCE_REFERENCE_CD |
ATTACHMENT.PI_O236 |
Entity Name | ATTACHMENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
ATTACHMENT.PI_O236 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_ID |
ATTACHMENT.SI_0098 |
Entity Name | ATTACHMENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ATTACHMENT.SI_0098 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_CD |
ATTACHMENT.SI_0154 |
Entity Name | ATTACHMENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ATTACHMENT.SI_0154 Index Columns |
ColumnName | Sort Order |
BARCODE_ID |
BATCH_EXPENSE_EDIT.RI_F00419 |
Entity Name | BATCH_EXPENSE_EDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_EDIT.RI_F00419 Index Columns |
ColumnName | Sort Order |
PAY_CURRENCY_CD |
BATCH_EXPENSE_EDIT.RI_F00296 |
Entity Name | BATCH_EXPENSE_EDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_EDIT.RI_F00296 Index Columns |
ColumnName | Sort Order |
TRANS_CURRENCY_CD |
BATCH_EXPENSE_EDIT.RI_F00295 |
Entity Name | BATCH_EXPENSE_EDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_EDIT.RI_F00295 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
BATCH_EXPENSE_EDIT.RI_F00293 |
Entity Name | BATCH_EXPENSE_EDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_EDIT.RI_F00293 Index Columns |
ColumnName | Sort Order |
PROVIDER_CD |
BATCH_EXPENSE_EDIT.RI_F00292 |
Entity Name | BATCH_EXPENSE_EDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_EDIT.RI_F00292 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
BATCH_EXPENSE_EDIT.RI_F00291 |
Entity Name | BATCH_EXPENSE_EDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_EDIT.RI_F00291 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD |
BATCH_EXPENSE_EDIT.PI_0224 |
Entity Name | BATCH_EXPENSE_EDIT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
BATCH_EXPENSE_EDIT.PI_0224 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_ID | |
EXP_BATCH_TYPE_CD | |
TRANSACTION_ID |
BATCH_EXPENSE_OUTSTANDING.RI_F00420 |
Entity Name | BATCH_EXPENSE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_OUTSTANDING.RI_F00420 Index Columns |
ColumnName | Sort Order |
PAY_CURRENCY_CD |
BATCH_EXPENSE_OUTSTANDING.RI_F00302 |
Entity Name | BATCH_EXPENSE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_OUTSTANDING.RI_F00302 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID |
BATCH_EXPENSE_OUTSTANDING.RI_F00301 |
Entity Name | BATCH_EXPENSE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_OUTSTANDING.RI_F00301 Index Columns |
ColumnName | Sort Order |
TRANS_CURRENCY_CD |
BATCH_EXPENSE_OUTSTANDING.RI_F00300 |
Entity Name | BATCH_EXPENSE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_OUTSTANDING.RI_F00300 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
BATCH_EXPENSE_OUTSTANDING.RI_F00299 |
Entity Name | BATCH_EXPENSE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_OUTSTANDING.RI_F00299 Index Columns |
ColumnName | Sort Order |
PROVIDER_CD |
BATCH_EXPENSE_OUTSTANDING.RI_F00298 |
Entity Name | BATCH_EXPENSE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_OUTSTANDING.RI_F00298 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
BATCH_EXPENSE_OUTSTANDING.RI_F00297 |
Entity Name | BATCH_EXPENSE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
BATCH_EXPENSE_OUTSTANDING.RI_F00297 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD |
BATCH_EXPENSE_OUTSTANDING.PI_0225 |
Entity Name | BATCH_EXPENSE_OUTSTANDING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
BATCH_EXPENSE_OUTSTANDING.PI_0225 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_ID | |
EXP_BATCH_TYPE_CD | |
TRANSACTION_ID |
CHARGE.PI_0013 |
Entity Name | CHARGE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CHARGE.PI_0013 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD |
CHARGE_BRANCH.SI_0031 |
Entity Name | CHARGE_BRANCH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH.SI_0031 Index Columns |
ColumnName | Sort Order |
PARENT_CHARGE_BRANCH_CD | |
CHARGE_BRANCH_CD | |
CHARGE_TREE_CD |
CHARGE_BRANCH.RI_F00005 |
Entity Name | CHARGE_BRANCH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH.RI_F00005 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
PARENT_CHARGE_BRANCH_CD |
CHARGE_BRANCH.RI_F00004 |
Entity Name | CHARGE_BRANCH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH.RI_F00004 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD |
CHARGE_BRANCH.PI_0014 |
Entity Name | CHARGE_BRANCH |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CHARGE_BRANCH.PI_0014 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD |
CHARGE_BRANCH_CHARGE.SI_0074 |
Entity Name | CHARGE_BRANCH_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE.SI_0074 Index Columns |
ColumnName | Sort Order |
RESTRICT_EMPL_FL | |
ACTIVE_FL | |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD | |
DFLT_UDT02_ID | |
DFLT_UDT01_ID |
CHARGE_BRANCH_CHARGE.SI_0071 |
Entity Name | CHARGE_BRANCH_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE.SI_0071 Index Columns |
ColumnName | Sort Order |
DFLT_UDT01_ID | |
OVERRIDE_CHARGE_DESC | |
ACTIVE_FL |
CHARGE_BRANCH_CHARGE.SI_0068 |
Entity Name | CHARGE_BRANCH_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE.SI_0068 Index Columns |
ColumnName | Sort Order |
DFLT_UDT02_ID | |
OVERRIDE_CHARGE_DESC | |
ACTIVE_FL |
CHARGE_BRANCH_CHARGE.RI_LF_0025 |
Entity Name | CHARGE_BRANCH_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE.RI_LF_0025 Index Columns |
ColumnName | Sort Order |
DFLT_UDT09_ID |
CHARGE_BRANCH_CHARGE.SI_0034 |
Entity Name | CHARGE_BRANCH_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE.SI_0034 Index Columns |
ColumnName | Sort Order |
DFLT_UDT02_ID | |
ACTIVE_FL |
CHARGE_BRANCH_CHARGE.SI_0033 |
Entity Name | CHARGE_BRANCH_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE.SI_0033 Index Columns |
ColumnName | Sort Order |
DFLT_UDT01_ID | |
ACTIVE_FL |
CHARGE_BRANCH_CHARGE.RI_F00006 |
Entity Name | CHARGE_BRANCH_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE.RI_F00006 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD |
CHARGE_BRANCH_CHARGE.PI_0015 |
Entity Name | CHARGE_BRANCH_CHARGE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CHARGE_BRANCH_CHARGE.PI_0015 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD |
CHARGE_BRANCH_CHARGE_EMPL.RI_F00071 |
Entity Name | CHARGE_BRANCH_CHARGE_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE_EMPL.RI_F00071 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
CHARGE_BRANCH_CHARGE_EMPL.RI_F00070 |
Entity Name | CHARGE_BRANCH_CHARGE_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_CHARGE_EMPL.RI_F00070 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD |
CHARGE_BRANCH_CHARGE_EMPL.PI_0107 |
Entity Name | CHARGE_BRANCH_CHARGE_EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CHARGE_BRANCH_CHARGE_EMPL.PI_0107 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD | |
EMPL_ID |
CHARGE_BRANCH_EMPL_GROUP.PI_0106 |
Entity Name | CHARGE_BRANCH_EMPL_GROUP |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CHARGE_BRANCH_EMPL_GROUP.PI_0106 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
EMPL_GROUP_CD |
CHARGE_BRANCH_EMPL_GROUP.SI_0008 |
Entity Name | CHARGE_BRANCH_EMPL_GROUP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_EMPL_GROUP.SI_0008 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
EMPL_GROUP_CD |
CHARGE_BRANCH_EMPL_GROUP.RI_F00073 |
Entity Name | CHARGE_BRANCH_EMPL_GROUP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_EMPL_GROUP.RI_F00073 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD |
CHARGE_BRANCH_EMPL_GROUP.RI_F00072 |
Entity Name | CHARGE_BRANCH_EMPL_GROUP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_BRANCH_EMPL_GROUP.RI_F00072 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD |
CHARGE_EMPL_GROUP.RI_F00075 |
Entity Name | CHARGE_EMPL_GROUP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_EMPL_GROUP.RI_F00075 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD |
CHARGE_EMPL_GROUP.RI_F00074 |
Entity Name | CHARGE_EMPL_GROUP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CHARGE_EMPL_GROUP.RI_F00074 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD |
CHARGE_EMPL_GROUP.PI_0105 |
Entity Name | CHARGE_EMPL_GROUP |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CHARGE_EMPL_GROUP.PI_0105 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
EMPL_GROUP_CD |
CLASS.SI_0003 |
Entity Name | CLASS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
CLASS.SI_0003 Index Columns |
ColumnName | Sort Order |
CLASS_DESC |
CLASS.PI_0016 |
Entity Name | CLASS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CLASS.PI_0016 Index Columns |
ColumnName | Sort Order |
CLASS_CD |
CLASS_EVENT.RI_F00087 |
Entity Name | CLASS_EVENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CLASS_EVENT.RI_F00087 Index Columns |
ColumnName | Sort Order |
EVENT_CD |
CLASS_EVENT.RI_F00086 |
Entity Name | CLASS_EVENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CLASS_EVENT.RI_F00086 Index Columns |
ColumnName | Sort Order |
CLASS_CD |
CLASS_EVENT.PI_0117 |
Entity Name | CLASS_EVENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CLASS_EVENT.PI_0117 Index Columns |
ColumnName | Sort Order |
CLASS_CD | |
EVENT_CD |
CLASS_LEAVE.RI_F00077 |
Entity Name | CLASS_LEAVE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CLASS_LEAVE.RI_F00077 Index Columns |
ColumnName | Sort Order |
LEAVE_TYPE_CD |
CLASS_LEAVE.RI_F00076 |
Entity Name | CLASS_LEAVE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CLASS_LEAVE.RI_F00076 Index Columns |
ColumnName | Sort Order |
CLASS_CD |
CLASS_LEAVE.PI_0111 |
Entity Name | CLASS_LEAVE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CLASS_LEAVE.PI_0111 Index Columns |
ColumnName | Sort Order |
CLASS_CD | |
LEAVE_TYPE_CD |
CLASS_UDT.RI_F00312 |
Entity Name | CLASS_UDT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CLASS_UDT.RI_F00312 Index Columns |
ColumnName | Sort Order |
CLASS_CD |
CLASS_UDT.PI_0229 |
Entity Name | CLASS_UDT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CLASS_UDT.PI_0229 Index Columns |
ColumnName | Sort Order |
CLASS_CD | |
S_UDT_CD |
CLASS_UDT10.RI_F00008 |
Entity Name | CLASS_UDT10 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CLASS_UDT10.RI_F00008 Index Columns |
ColumnName | Sort Order |
UDT10_ID |
CLASS_UDT10.RI_F00007 |
Entity Name | CLASS_UDT10 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CLASS_UDT10.RI_F00007 Index Columns |
ColumnName | Sort Order |
CLASS_CD |
CLASS_UDT10.PI_0017 |
Entity Name | CLASS_UDT10 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CLASS_UDT10.PI_0017 Index Columns |
ColumnName | Sort Order |
CLASS_CD | |
UDT10_ID |
COMPANY.RI_F00009 |
Entity Name | COMPANY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
COMPANY.RI_F00009 Index Columns |
ColumnName | Sort Order |
DFLT_LANGUAGE_CD | |
DFLT_COUNTRY_CD |
COMPANY.PI_0019 |
Entity Name | COMPANY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
COMPANY.PI_0019 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
COMPANY_ACCESS.RI_F00115 |
Entity Name | COMPANY_ACCESS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
COMPANY_ACCESS.RI_F00115 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
COMPANY_ACCESS.PI_0133 |
Entity Name | COMPANY_ACCESS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
COMPANY_ACCESS.PI_0133 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
S_SYSTEM_CD |
CORRECT_ADVANCE_OUTSTANDING.RI_F00439 |
Entity Name | CORRECT_ADVANCE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_ADVANCE_OUTSTANDING.RI_F00439 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO |
CORRECT_ADVANCE_OUTSTANDING.RI_F00438 |
Entity Name | CORRECT_ADVANCE_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_ADVANCE_OUTSTANDING.RI_F00438 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
CORRECT_ADVANCE_OUTSTANDING.PI_0298 |
Entity Name | CORRECT_ADVANCE_OUTSTANDING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_ADVANCE_OUTSTANDING.PI_0298 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
ADVANCE_REFERENCE_CD | |
CORRECTION_NO | |
EXP_RPT_ID |
CORRECT_BATCH_EXP_OUTSTANDING.RI_F00440 |
Entity Name | CORRECT_BATCH_EXP_OUTSTANDING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_BATCH_EXP_OUTSTANDING.RI_F00440 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO |
CORRECT_BATCH_EXP_OUTSTANDING.PI_0299 |
Entity Name | CORRECT_BATCH_EXP_OUTSTANDING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_BATCH_EXP_OUTSTANDING.PI_0299 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_ID | |
EXP_BATCH_TYPE_CD | |
TRANSACTION_ID | |
CORRECTION_NO | |
EXP_RPT_ID |
CORRECT_EXP_RPT.PI_0285 |
Entity Name | CORRECT_EXP_RPT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT.PI_0285 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO |
CORRECT_EXP_RPT_CHARGE_ALLOC.RI_F00423 |
Entity Name | CORRECT_EXP_RPT_CHARGE_ALLOC |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_CHARGE_ALLOC.RI_F00423 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO |
CORRECT_EXP_RPT_CHARGE_ALLOC.PI_0287 |
Entity Name | CORRECT_EXP_RPT_CHARGE_ALLOC |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_CHARGE_ALLOC.PI_0287 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
ALLOCATION_ID |
CORRECT_EXP_RPT_CHARGE_WARNING.PI_O257 |
Entity Name | CORRECT_EXP_RPT_CHARGE_WARNING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_CHARGE_WARNING.PI_O257 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
ALLOCATION_ID | |
CORRECTION_NO | |
WARNING_MESSAGE_ID |
CORRECT_EXP_RPT_EXP_ATTENDEE.RI_F00437 |
Entity Name | CORRECT_EXP_RPT_EXP_ATTENDEE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_EXP_ATTENDEE.RI_F00437 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID |
CORRECT_EXP_RPT_EXP_ATTENDEE.PI_0297 |
Entity Name | CORRECT_EXP_RPT_EXP_ATTENDEE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_EXP_ATTENDEE.PI_0297 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID | |
ATTENDEE_SEQ_NO |
CORRECT_EXP_RPT_EXPENSE.RI_F00425 |
Entity Name | CORRECT_EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_EXPENSE.RI_F00425 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO |
CORRECT_EXP_RPT_EXPENSE.RI_F00424 |
Entity Name | CORRECT_EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_EXPENSE.RI_F00424 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
PARENT_EXPENSE_ID |
CORRECT_EXP_RPT_EXPENSE.PI_0288 |
Entity Name | CORRECT_EXP_RPT_EXPENSE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_EXPENSE.PI_0288 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID |
CORRECT_EXP_RPT_EXPENSE_CHARGE.RI_F00427 |
Entity Name | CORRECT_EXP_RPT_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_EXPENSE_CHARGE.RI_F00427 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
ALLOCATION_ID |
CORRECT_EXP_RPT_EXPENSE_CHARGE.RI_F00426 |
Entity Name | CORRECT_EXP_RPT_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_EXPENSE_CHARGE.RI_F00426 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID |
CORRECT_EXP_RPT_EXPENSE_CHARGE.PI_0289 |
Entity Name | CORRECT_EXP_RPT_EXPENSE_CHARGE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_EXPENSE_CHARGE.PI_0289 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_CHARGE_TYPE_CD |
CORRECT_EXP_RPT_EXPENSE_DAY.RI_F00428 |
Entity Name | CORRECT_EXP_RPT_EXPENSE_DAY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_EXPENSE_DAY.RI_F00428 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID |
CORRECT_EXP_RPT_EXPENSE_DAY.PI_0290 |
Entity Name | CORRECT_EXP_RPT_EXPENSE_DAY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_EXPENSE_DAY.PI_0290 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID | |
EXP_DT |
CORRECT_EXP_RPT_EXPENSE_OTHER.RI_F00429 |
Entity Name | CORRECT_EXP_RPT_EXPENSE_OTHER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_EXPENSE_OTHER.RI_F00429 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID |
CORRECT_EXP_RPT_EXPENSE_OTHER.PI_0291 |
Entity Name | CORRECT_EXP_RPT_EXPENSE_OTHER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_EXPENSE_OTHER.PI_0291 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
EXPENSE_ID | |
OTHER_SEQ_NO |
CORRECT_EXP_RPT_EXPENSE_WARN.PI_O256 |
Entity Name | CORRECT_EXP_RPT_EXPENSE_WARN |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_EXPENSE_WARN.PI_O256 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID | |
CORRECTION_NO | |
WARNING_MESSAGE_ID |
CORRECT_EXP_RPT_LOCATION.SI_0131 |
Entity Name | CORRECT_EXP_RPT_LOCATION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_LOCATION.SI_0131 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
LOCATION_ID |
CORRECT_EXP_RPT_LOCATION.PI_0292 |
Entity Name | CORRECT_EXP_RPT_LOCATION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_LOCATION.PI_0292 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
LOCATION_NO |
CORRECT_EXP_RPT_PAYMENT.RI_F00431 |
Entity Name | CORRECT_EXP_RPT_PAYMENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_PAYMENT.RI_F00431 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO |
CORRECT_EXP_RPT_PAYMENT.PI_0293 |
Entity Name | CORRECT_EXP_RPT_PAYMENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_PAYMENT.PI_0293 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
PAYMENT_REFERENCE_CD |
CORRECT_EXP_RPT_REVISION.RI_F00432 |
Entity Name | CORRECT_EXP_RPT_REVISION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_REVISION.RI_F00432 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO |
CORRECT_EXP_RPT_REVISION.PI_0294 |
Entity Name | CORRECT_EXP_RPT_REVISION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_REVISION.PI_0294 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
REVISION_NO |
CORRECT_EXP_RPT_TASKS.RI_F00433 |
Entity Name | CORRECT_EXP_RPT_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_TASKS.RI_F00433 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO |
CORRECT_EXP_RPT_TASKS.PI_0295 |
Entity Name | CORRECT_EXP_RPT_TASKS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_TASKS.PI_0295 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
ALLOCATION_ID | |
FUNCTIONAL_ROLE_CD | |
S_TASK_CD |
CORRECT_EXP_RPT_TASKS_EMPL.RI_F00436 |
Entity Name | CORRECT_EXP_RPT_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_TASKS_EMPL.RI_F00436 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
CORRECT_EXP_RPT_TASKS_EMPL.RI_F00435 |
Entity Name | CORRECT_EXP_RPT_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_TASKS_EMPL.RI_F00435 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
CORRECT_EXP_RPT_TASKS_EMPL.RI_F00434 |
Entity Name | CORRECT_EXP_RPT_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_EXP_RPT_TASKS_EMPL.RI_F00434 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
ALLOCATION_ID | |
FUNCTIONAL_ROLE_CD | |
S_TASK_CD |
CORRECT_EXP_RPT_TASKS_EMPL.PI_0296 |
Entity Name | CORRECT_EXP_RPT_TASKS_EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_TASKS_EMPL.PI_0296 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
ALLOCATION_ID | |
FUNCTIONAL_ROLE_CD | |
S_TASK_CD | |
EMPL_ID |
CORRECT_EXP_RPT_WARNING.PI_O255 |
Entity Name | CORRECT_EXP_RPT_WARNING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_EXP_RPT_WARNING.PI_O255 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
CORRECTION_NO | |
WARNING_MESSAGE_ID |
CORRECT_TASK.PI_O240 |
Entity Name | CORRECT_TASK |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_TASK.PI_O240 Index Columns |
ColumnName | Sort Order |
TASK_ID | |
CORRECTION_NO |
CORRECT_TASK.SI_0115 |
Entity Name | CORRECT_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_TASK.SI_0115 Index Columns |
ColumnName | Sort Order |
TASK_EMPL_ID |
CORRECT_TASK.SI_0114 |
Entity Name | CORRECT_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_TASK.SI_0114 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_CD |
CORRECT_TASK.SI_0113 |
Entity Name | CORRECT_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_TASK.SI_0113 Index Columns |
ColumnName | Sort Order |
BACKUP_FUNCTIONAL_ROLE_CD |
CORRECT_TASK.SI_0112 |
Entity Name | CORRECT_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_TASK.SI_0112 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
CORRECT_TASK_EMPL.PI_O242 |
Entity Name | CORRECT_TASK_EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CORRECT_TASK_EMPL.PI_O242 Index Columns |
ColumnName | Sort Order |
TASK_ID | |
CORRECTION_NO | |
EMPL_ID | |
FUNCTIONAL_ROLE_CD |
CORRECT_TASK_EMPL.SI_0121 |
Entity Name | CORRECT_TASK_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_TASK_EMPL.SI_0121 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
CORRECT_TASK_EMPL.SI_0120 |
Entity Name | CORRECT_TASK_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_TASK_EMPL.SI_0120 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
CORRECT_TASK_EMPL.SI_0119 |
Entity Name | CORRECT_TASK_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CORRECT_TASK_EMPL.SI_0119 Index Columns |
ColumnName | Sort Order |
TASK_ID |
CP_COMPANY.PI_0134 |
Entity Name | CP_COMPANY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CP_COMPANY.PI_0134 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
CURRENCY.PI_0135 |
Entity Name | CURRENCY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CURRENCY.PI_0135 Index Columns |
ColumnName | Sort Order |
CURRENCY_CD |
CURRENCY_SCHEDULE.PI_0167 |
Entity Name | CURRENCY_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CURRENCY_SCHEDULE.PI_0167 Index Columns |
ColumnName | Sort Order |
CURRENCY_SCHEDULE_CD |
CURRENCY_SCHEDULE_RATE.PI_0168 |
Entity Name | CURRENCY_SCHEDULE_RATE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CURRENCY_SCHEDULE_RATE.PI_0168 Index Columns |
ColumnName | Sort Order |
CURRENCY_SCHEDULE_CD | |
EFFECTIVE_DT | |
FROM_CURRENCY_CD | |
TO_CURRENCY_CD |
CURRENCY_SCHEDULE_RATE.RI_F00179 |
Entity Name | CURRENCY_SCHEDULE_RATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CURRENCY_SCHEDULE_RATE.RI_F00179 Index Columns |
ColumnName | Sort Order |
CURRENCY_SCHEDULE_CD |
CURRENCY_SCHEDULE_RATE.RI_F00178 |
Entity Name | CURRENCY_SCHEDULE_RATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CURRENCY_SCHEDULE_RATE.RI_F00178 Index Columns |
ColumnName | Sort Order |
TO_CURRENCY_CD |
CURRENCY_SCHEDULE_RATE.RI_F00177 |
Entity Name | CURRENCY_SCHEDULE_RATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CURRENCY_SCHEDULE_RATE.RI_F00177 Index Columns |
ColumnName | Sort Order |
FROM_CURRENCY_CD |
CUSTOM_TEXT.RI_F00375 |
Entity Name | CUSTOM_TEXT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
CUSTOM_TEXT.RI_F00375 Index Columns |
ColumnName | Sort Order |
LANGUAGE_CD | |
COUNTRY_CD |
CUSTOM_TEXT.PI_0249 |
Entity Name | CUSTOM_TEXT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
CUSTOM_TEXT.PI_0249 Index Columns |
ColumnName | Sort Order |
TEXT_LABEL_CD | |
COUNTRY_CD | |
LANGUAGE_CD |
DESKTOP.PI_0122 |
Entity Name | DESKTOP |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP.PI_0122 Index Columns |
ColumnName | Sort Order |
DESKTOP_CD |
DESKTOP_ALERTS.RI_F00113 |
Entity Name | DESKTOP_ALERTS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_ALERTS.RI_F00113 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_ALERTS.RI_F00092 |
Entity Name | DESKTOP_ALERTS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_ALERTS.RI_F00092 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_ALERTS.RI_F00091 |
Entity Name | DESKTOP_ALERTS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_ALERTS.RI_F00091 Index Columns |
ColumnName | Sort Order |
EVENT_CD |
DESKTOP_ALERTS.PI_0120 |
Entity Name | DESKTOP_ALERTS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_ALERTS.PI_0120 Index Columns |
ColumnName | Sort Order |
EVENT_CD | |
EMPL_ID | |
ALERT_DTT | |
ALERT_DESC | |
FUNCTIONAL_ROLE_CD |
DESKTOP_AUTH_TASKS.RI_F00371 |
Entity Name | DESKTOP_AUTH_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_AUTH_TASKS.RI_F00371 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_AUTH_TASKS.PI_0246 |
Entity Name | DESKTOP_AUTH_TASKS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_AUTH_TASKS.PI_0246 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
S_TASK_CD | |
TASK_DTT | |
EXP_AUTH_ID | |
ALLOCATION_ID | |
FUNCTIONAL_ROLE_CD |
DESKTOP_AUTH_TASKS.RI_F00373 |
Entity Name | DESKTOP_AUTH_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_AUTH_TASKS.RI_F00373 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_AUTH_TASKS.RI_F00372 |
Entity Name | DESKTOP_AUTH_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_AUTH_TASKS.RI_F00372 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID |
DESKTOP_DELEGATION_EMPLOYEE.RI_F00321 |
Entity Name | DESKTOP_DELEGATION_EMPLOYEE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_DELEGATION_EMPLOYEE.RI_F00321 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_DELEGATION_EMPLOYEE.RI_F00324 |
Entity Name | DESKTOP_DELEGATION_EMPLOYEE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_DELEGATION_EMPLOYEE.RI_F00324 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_DELEGATION_EMPLOYEE.RI_F00323 |
Entity Name | DESKTOP_DELEGATION_EMPLOYEE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_DELEGATION_EMPLOYEE.RI_F00323 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD |
DESKTOP_DELEGATION_EMPLOYEE.RI_F00322 |
Entity Name | DESKTOP_DELEGATION_EMPLOYEE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_DELEGATION_EMPLOYEE.RI_F00322 Index Columns |
ColumnName | Sort Order |
DELEGATE_EMPL_ID |
DESKTOP_DELEGATION_EMPLOYEE.PI_0231 |
Entity Name | DESKTOP_DELEGATION_EMPLOYEE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_DELEGATION_EMPLOYEE.PI_0231 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
FUNCTIONAL_ROLE_CD | |
EMPL_GROUP_CD | |
DELEGATE_EMPL_ID |
DESKTOP_DELEGATION_UDT.RI_F00326 |
Entity Name | DESKTOP_DELEGATION_UDT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_DELEGATION_UDT.RI_F00326 Index Columns |
ColumnName | Sort Order |
DELEGATE_EMPL_ID |
DESKTOP_DELEGATION_UDT.PI_0232 |
Entity Name | DESKTOP_DELEGATION_UDT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_DELEGATION_UDT.PI_0232 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
FUNCTIONAL_ROLE_CD | |
S_UDT_CD | |
UDT_ID_S | |
DELEGATE_EMPL_ID |
DESKTOP_DELEGATION_UDT.RI_F00325 |
Entity Name | DESKTOP_DELEGATION_UDT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_DELEGATION_UDT.RI_F00325 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_DELEGATION_UDT.RI_F00327 |
Entity Name | DESKTOP_DELEGATION_UDT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_DELEGATION_UDT.RI_F00327 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_EXPENSE_ALERTS.RI_F00242 |
Entity Name | DESKTOP_EXPENSE_ALERTS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_EXPENSE_ALERTS.RI_F00242 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_EXPENSE_ALERTS.RI_F00243 |
Entity Name | DESKTOP_EXPENSE_ALERTS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_EXPENSE_ALERTS.RI_F00243 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_EXPENSE_ALERTS.PI_0192 |
Entity Name | DESKTOP_EXPENSE_ALERTS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_EXPENSE_ALERTS.PI_0192 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
ALERT_DTT | |
ALERT_DESC | |
FUNCTIONAL_ROLE_CD |
DESKTOP_SCHEDULE_TASKS.RI_F00248 |
Entity Name | DESKTOP_SCHEDULE_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_SCHEDULE_TASKS.RI_F00248 Index Columns |
ColumnName | Sort Order |
EVENT_CD |
DESKTOP_SCHEDULE_TASKS.RI_F00249 |
Entity Name | DESKTOP_SCHEDULE_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_SCHEDULE_TASKS.RI_F00249 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_SCHEDULE_TASKS.RI_F00247 |
Entity Name | DESKTOP_SCHEDULE_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_SCHEDULE_TASKS.RI_F00247 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_SCHEDULE_TASKS.PI_0194 |
Entity Name | DESKTOP_SCHEDULE_TASKS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_SCHEDULE_TASKS.PI_0194 Index Columns |
ColumnName | Sort Order |
EVENT_CD | |
EMPL_ID | |
S_TASK_CD | |
TASK_DTT | |
TASK_EMPL_ID | |
TASK_WORK_SCHEDULE_CD | |
TASK_SCHEDULE_DT | |
FUNCTIONAL_ROLE_CD |
DESKTOP_SELF_SERVICE_ALERTS.RI_F00382 |
Entity Name | DESKTOP_SELF_SERVICE_ALERTS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_SELF_SERVICE_ALERTS.RI_F00382 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_SELF_SERVICE_ALERTS.RI_F00381 |
Entity Name | DESKTOP_SELF_SERVICE_ALERTS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_SELF_SERVICE_ALERTS.RI_F00381 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_SELF_SERVICE_ALERTS.PI_0252 |
Entity Name | DESKTOP_SELF_SERVICE_ALERTS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_SELF_SERVICE_ALERTS.PI_0252 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
ALERT_DTT | |
ALERT_DESC | |
FUNCTIONAL_ROLE_CD |
DESKTOP_SELF_SERVICE_TASKS.RI_F00378 |
Entity Name | DESKTOP_SELF_SERVICE_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_SELF_SERVICE_TASKS.RI_F00378 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_SELF_SERVICE_TASKS.RI_F00380 |
Entity Name | DESKTOP_SELF_SERVICE_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_SELF_SERVICE_TASKS.RI_F00380 Index Columns |
ColumnName | Sort Order |
LIFE_EVENT_CD |
DESKTOP_SELF_SERVICE_TASKS.RI_F00379 |
Entity Name | DESKTOP_SELF_SERVICE_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_SELF_SERVICE_TASKS.RI_F00379 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_SELF_SERVICE_TASKS.PI_0251 |
Entity Name | DESKTOP_SELF_SERVICE_TASKS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_SELF_SERVICE_TASKS.PI_0251 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
S_TASK_CD | |
TASK_DTT |
DESKTOP_TASKS.RI_F00112 |
Entity Name | DESKTOP_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_TASKS.RI_F00112 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
DESKTOP_TASKS.RI_F00090 |
Entity Name | DESKTOP_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_TASKS.RI_F00090 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
DESKTOP_TASKS.RI_F00089 |
Entity Name | DESKTOP_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_TASKS.RI_F00089 Index Columns |
ColumnName | Sort Order |
EVENT_CD |
DESKTOP_TASKS.PI_0119 |
Entity Name | DESKTOP_TASKS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
DESKTOP_TASKS.PI_0119 Index Columns |
ColumnName | Sort Order |
EVENT_CD | |
EMPL_ID | |
S_TASK_CD | |
TASK_DTT | |
TASK_EMPL_ID | |
TASK_TS_SCHEDULE_CD | |
TASK_YEAR_NO_CD | |
TASK_PERIOD_NO_CD | |
TASK_LINE_NO | |
FUNCTIONAL_ROLE_CD |
DESKTOP_TASKS.SI_0035 |
Entity Name | DESKTOP_TASKS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
DESKTOP_TASKS.SI_0035 Index Columns |
ColumnName | Sort Order |
TASK_EMPL_ID | |
TASK_TS_SCHEDULE_CD | |
TASK_YEAR_NO_CD | |
TASK_PERIOD_NO_CD | |
TASK_LINE_NO | |
S_TASK_CD |
EMPL.RI_F00025 |
Entity Name | EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL.RI_F00025 Index Columns |
ColumnName | Sort Order |
ROLE_CD |
EMPL.RI_F00132 |
Entity Name | EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL.RI_F00132 Index Columns |
ColumnName | Sort Order |
CURRENCY_CD |
EMPL.SI_0006 |
Entity Name | EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
EMPL.SI_0006 Index Columns |
ColumnName | Sort Order |
LOGIN_EMPL_ID |
EMPL.PI_0031 |
Entity Name | EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL.PI_0031 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_ACCESS.RI_F00114 |
Entity Name | EMPL_ACCESS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_ACCESS.RI_F00114 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_ACCESS.PI_0132 |
Entity Name | EMPL_ACCESS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_ACCESS.PI_0132 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
S_SYSTEM_CD |
EMPL_CHARGE_FAVORITES.RI_LF_0036 |
Entity Name | EMPL_CHARGE_FAVORITES |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_CHARGE_FAVORITES.RI_LF_0036 Index Columns |
ColumnName | Sort Order |
DFLT_UDT07_ID | |
UDT07_CP_COMPANY_CD |
EMPL_CHARGE_FAVORITES.RI_LF_0035 |
Entity Name | EMPL_CHARGE_FAVORITES |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_CHARGE_FAVORITES.RI_LF_0035 Index Columns |
ColumnName | Sort Order |
DFLT_UDT06_ID | |
UDT06_CP_COMPANY_CD |
EMPL_CHARGE_FAVORITES.RI_LF_0038 |
Entity Name | EMPL_CHARGE_FAVORITES |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_CHARGE_FAVORITES.RI_LF_0038 Index Columns |
ColumnName | Sort Order |
DFLT_UDT09_ID |
EMPL_CHARGE_FAVORITES.RI_F00063 |
Entity Name | EMPL_CHARGE_FAVORITES |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_CHARGE_FAVORITES.RI_F00063 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD |
EMPL_CHARGE_FAVORITES.RI_F00062 |
Entity Name | EMPL_CHARGE_FAVORITES |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_CHARGE_FAVORITES.RI_F00062 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_CHARGE_FAVORITES.PI_0056 |
Entity Name | EMPL_CHARGE_FAVORITES |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_CHARGE_FAVORITES.PI_0056 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD | |
SEQ_NO |
EMPL_CHARGE_FAVORITES_CP.RI_F00417 |
Entity Name | EMPL_CHARGE_FAVORITES_CP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_CHARGE_FAVORITES_CP.RI_F00417 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_CHARGE_FAVORITES_CP.PI_0282 |
Entity Name | EMPL_CHARGE_FAVORITES_CP |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_CHARGE_FAVORITES_CP.PI_0282 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
EMPL_GROUP_CD | |
SEQ_NO |
EMPL_DESKTOP_LEFT.RI_F00097 |
Entity Name | EMPL_DESKTOP_LEFT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_DESKTOP_LEFT.RI_F00097 Index Columns |
ColumnName | Sort Order |
DESKTOP_CD |
EMPL_DESKTOP_LEFT.RI_F00096 |
Entity Name | EMPL_DESKTOP_LEFT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_DESKTOP_LEFT.RI_F00096 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_DESKTOP_LEFT.PI_0124 |
Entity Name | EMPL_DESKTOP_LEFT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_DESKTOP_LEFT.PI_0124 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
DESKTOP_CD |
EMPL_DESKTOP_RIGHT.RI_F00098 |
Entity Name | EMPL_DESKTOP_RIGHT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_DESKTOP_RIGHT.RI_F00098 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_DESKTOP_RIGHT.PI_0125 |
Entity Name | EMPL_DESKTOP_RIGHT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_DESKTOP_RIGHT.PI_0125 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
DESKTOP_CD |
EMPL_DESKTOP_RIGHT.RI_F00099 |
Entity Name | EMPL_DESKTOP_RIGHT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_DESKTOP_RIGHT.RI_F00099 Index Columns |
ColumnName | Sort Order |
DESKTOP_CD |
EMPL_GROUP.PI_0033 |
Entity Name | EMPL_GROUP |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_GROUP.PI_0033 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD |
EMPL_GROUP.RI_F00026 |
Entity Name | EMPL_GROUP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_GROUP.RI_F00026 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_TYPE_CD |
EMPL_GROUP_CHARGE_FAVORITES_CP.RI_F00418 |
Entity Name | EMPL_GROUP_CHARGE_FAVORITES_CP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_GROUP_CHARGE_FAVORITES_CP.RI_F00418 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD |
EMPL_GROUP_CHARGE_FAVORITES_CP.PI_0283 |
Entity Name | EMPL_GROUP_CHARGE_FAVORITES_CP |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_GROUP_CHARGE_FAVORITES_CP.PI_0283 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD | |
SEQ_NO |
EMPL_GROUP_EMPL.PI_0034 |
Entity Name | EMPL_GROUP_EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_GROUP_EMPL.PI_0034 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD | |
EMPL_ID |
EMPL_GROUP_EMPL.RI_F00028 |
Entity Name | EMPL_GROUP_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_GROUP_EMPL.RI_F00028 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_GROUP_EMPL.RI_F00027 |
Entity Name | EMPL_GROUP_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_GROUP_EMPL.RI_F00027 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD |
EMPL_GROUP_SPVSR.PI_0035 |
Entity Name | EMPL_GROUP_SPVSR |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_GROUP_SPVSR.PI_0035 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD | |
SPVSR_EMPL_ID | |
FUNCTIONAL_ROLE_CD |
EMPL_GROUP_SPVSR.RI_F00102 |
Entity Name | EMPL_GROUP_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_GROUP_SPVSR.RI_F00102 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
EMPL_GROUP_SPVSR.RI_F00030 |
Entity Name | EMPL_GROUP_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_GROUP_SPVSR.RI_F00030 Index Columns |
ColumnName | Sort Order |
SPVSR_EMPL_ID |
EMPL_GROUP_SPVSR.RI_F00029 |
Entity Name | EMPL_GROUP_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_GROUP_SPVSR.RI_F00029 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_CD |
EMPL_GROUP_TYPE.PI_0032 |
Entity Name | EMPL_GROUP_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_GROUP_TYPE.PI_0032 Index Columns |
ColumnName | Sort Order |
EMPL_GROUP_TYPE_CD |
EMPL_HISTORY.RI_LF_0021 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.RI_LF_0021 Index Columns |
ColumnName | Sort Order |
DFLT_UDT07_ID | |
UDT07_CP_COMPANY_CD |
EMPL_HISTORY.RI_LF_0018 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.RI_LF_0018 Index Columns |
ColumnName | Sort Order |
DFLT_UDT06_ID | |
UDT06_CP_COMPANY_CD |
EMPL_HISTORY.RI_F00140 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.RI_F00140 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
EMPL_HISTORY.PI_0036 |
Entity Name | EMPL_HISTORY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_HISTORY.PI_0036 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
EFFECTIVE_DT |
EMPL_HISTORY.RI_F00149 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.RI_F00149 Index Columns |
ColumnName | Sort Order |
EXP_CLASS_CD |
EMPL_HISTORY.SI_0038 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.SI_0038 Index Columns |
ColumnName | Sort Order |
EFFECTIVE_DT | |
EMPL_ID | |
CLASS_CD | |
TS_SCHEDULE_CD |
EMPL_HISTORY.RI_F00031 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.RI_F00031 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_HISTORY.RI_F00034 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.RI_F00034 Index Columns |
ColumnName | Sort Order |
TS_SCHEDULE_CD |
EMPL_HISTORY.RI_F00033 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.RI_F00033 Index Columns |
ColumnName | Sort Order |
CLASS_CD |
EMPL_HISTORY.RI_F00032 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.RI_F00032 Index Columns |
ColumnName | Sort Order |
WORK_SCHEDULE_CD |
EMPL_HISTORY.SI_0051 |
Entity Name | EMPL_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_HISTORY.SI_0051 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
EFFECTIVE_DT | |
CLASS_CD | |
TS_SCHEDULE_CD | |
WORK_SCHEDULE_CD |
EMPL_LEAVE.PI_0110 |
Entity Name | EMPL_LEAVE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_LEAVE.PI_0110 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
LEAVE_TYPE_CD | |
TRANS_DT | |
S_TRANS_TYPE_CD | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO |
EMPL_LEAVE.RI_F00079 |
Entity Name | EMPL_LEAVE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_LEAVE.RI_F00079 Index Columns |
ColumnName | Sort Order |
LEAVE_TYPE_CD |
EMPL_LEAVE.RI_F00078 |
Entity Name | EMPL_LEAVE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_LEAVE.RI_F00078 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_MENU.PI_0123 |
Entity Name | EMPL_MENU |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_MENU.PI_0123 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
SCREEN_CD |
EMPL_MENU.RI_F00095 |
Entity Name | EMPL_MENU |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_MENU.RI_F00095 Index Columns |
ColumnName | Sort Order |
SCREEN_CD |
EMPL_MENU.RI_F00094 |
Entity Name | EMPL_MENU |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_MENU.RI_F00094 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_PAY_METHOD.RI_F00164 |
Entity Name | EMPL_PAY_METHOD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_PAY_METHOD.RI_F00164 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_PAY_METHOD.RI_F00163 |
Entity Name | EMPL_PAY_METHOD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_PAY_METHOD.RI_F00163 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
EMPL_PAY_METHOD.PI_0158 |
Entity Name | EMPL_PAY_METHOD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_PAY_METHOD.PI_0158 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
PAY_METHOD_CD |
EMPL_PREFERENCE.RI_F00263 |
Entity Name | EMPL_PREFERENCE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_PREFERENCE.RI_F00263 Index Columns |
ColumnName | Sort Order |
TIME_ZONE_CD |
EMPL_PREFERENCE.PI_0038 |
Entity Name | EMPL_PREFERENCE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EMPL_PREFERENCE.PI_0038 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EMPL_PREFERENCE.RI_F00037 |
Entity Name | EMPL_PREFERENCE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EMPL_PREFERENCE.RI_F00037 Index Columns |
ColumnName | Sort Order |
LANGUAGE_CD | |
COUNTRY_CD |
ESS_CONFIG.RI_F00383 |
Entity Name | ESS_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ESS_CONFIG.RI_F00383 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
ESS_CONFIG.PI_0238 |
Entity Name | ESS_CONFIG |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
ESS_CONFIG.PI_0238 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
EVENT.RI_F00104 |
Entity Name | EVENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EVENT.RI_F00104 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
EVENT.PI_0114 |
Entity Name | EVENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EVENT.PI_0114 Index Columns |
ColumnName | Sort Order |
EVENT_CD |
EVENT_NOTIFICATION.RI_F00105 |
Entity Name | EVENT_NOTIFICATION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EVENT_NOTIFICATION.RI_F00105 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
EVENT_NOTIFICATION.RI_F00085 |
Entity Name | EVENT_NOTIFICATION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EVENT_NOTIFICATION.RI_F00085 Index Columns |
ColumnName | Sort Order |
EVENT_CD |
EVENT_NOTIFICATION.PI_0116 |
Entity Name | EVENT_NOTIFICATION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EVENT_NOTIFICATION.PI_0116 Index Columns |
ColumnName | Sort Order |
EVENT_CD | |
FUNCTIONAL_ROLE_CD |
EXP_ADVANCE.PI_O247 |
Entity Name | EXP_ADVANCE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_ADVANCE.PI_O247 Index Columns |
ColumnName | Sort Order |
ADVANCE_ID |
EXP_ADVANCE_REVISION.PI_O248 |
Entity Name | EXP_ADVANCE_REVISION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_ADVANCE_REVISION.PI_O248 Index Columns |
ColumnName | Sort Order |
ADVANCE_ID | |
REVISION_NO |
EXP_AUTH.RI_F00354 |
Entity Name | EXP_AUTH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH.RI_F00354 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD |
EXP_AUTH.RI_F00353 |
Entity Name | EXP_AUTH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH.RI_F00353 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_AUTH.RI_F00352 |
Entity Name | EXP_AUTH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH.RI_F00352 Index Columns |
ColumnName | Sort Order |
EXP_CLASS_CD |
EXP_AUTH.RI_F00351 |
Entity Name | EXP_AUTH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH.RI_F00351 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EXP_AUTH.RI_F00350 |
Entity Name | EXP_AUTH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH.RI_F00350 Index Columns |
ColumnName | Sort Order |
CURRENCY_SCHEDULE_CD |
EXP_AUTH.RI_F00349 |
Entity Name | EXP_AUTH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH.RI_F00349 Index Columns |
ColumnName | Sort Order |
BASE_CURRENCY_CD |
EXP_AUTH.RI_F00348 |
Entity Name | EXP_AUTH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH.RI_F00348 Index Columns |
ColumnName | Sort Order |
PAY_CURRENCY_CD |
EXP_AUTH.RI_F00347 |
Entity Name | EXP_AUTH |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH.RI_F00347 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
EXP_AUTH.PI_0240 |
Entity Name | EXP_AUTH |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH.PI_0240 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID |
EXP_AUTH_CHARGE_ALLOCATIONS.RI_F00357 |
Entity Name | EXP_AUTH_CHARGE_ALLOCATIONS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_CHARGE_ALLOCATIONS.RI_F00357 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID |
EXP_AUTH_CHARGE_ALLOCATIONS.RI_F00358 |
Entity Name | EXP_AUTH_CHARGE_ALLOCATIONS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_CHARGE_ALLOCATIONS.RI_F00358 Index Columns |
ColumnName | Sort Order |
UDT09_ID |
EXP_AUTH_CHARGE_ALLOCATIONS.RI_F00356 |
Entity Name | EXP_AUTH_CHARGE_ALLOCATIONS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_CHARGE_ALLOCATIONS.RI_F00356 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD |
EXP_AUTH_CHARGE_ALLOCATIONS.PI_0241 |
Entity Name | EXP_AUTH_CHARGE_ALLOCATIONS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_CHARGE_ALLOCATIONS.PI_0241 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
ALLOCATION_ID |
EXP_AUTH_CHARGE_WARNING.PI_O251 |
Entity Name | EXP_AUTH_CHARGE_WARNING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_CHARGE_WARNING.PI_O251 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
ALLOCATION_ID | |
WARNING_MESSAGE_ID |
EXP_AUTH_EXPENSE.RI_F00359 |
Entity Name | EXP_AUTH_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_EXPENSE.RI_F00359 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID |
EXP_AUTH_EXPENSE.RI_F00362 |
Entity Name | EXP_AUTH_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_EXPENSE.RI_F00362 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_AUTH_EXPENSE.RI_F00361 |
Entity Name | EXP_AUTH_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_EXPENSE.RI_F00361 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
EXP_CATEGORY_CD |
EXP_AUTH_EXPENSE.RI_F00360 |
Entity Name | EXP_AUTH_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_EXPENSE.RI_F00360 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD |
EXP_AUTH_EXPENSE.PI_0242 |
Entity Name | EXP_AUTH_EXPENSE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_EXPENSE.PI_0242 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
EXPENSE_ID |
EXP_AUTH_EXPENSE_CHARGE.RI_F00363 |
Entity Name | EXP_AUTH_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_EXPENSE_CHARGE.RI_F00363 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
EXPENSE_ID |
EXP_AUTH_EXPENSE_CHARGE.RI_F00364 |
Entity Name | EXP_AUTH_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_EXPENSE_CHARGE.RI_F00364 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
ALLOCATION_ID |
EXP_AUTH_EXPENSE_CHARGE.PI_0243 |
Entity Name | EXP_AUTH_EXPENSE_CHARGE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_EXPENSE_CHARGE.PI_0243 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
EXPENSE_ID | |
ALLOCATION_ID |
EXP_AUTH_EXPENSE_WARNING.PI_O250 |
Entity Name | EXP_AUTH_EXPENSE_WARNING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_EXPENSE_WARNING.PI_O250 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
EXPENSE_ID | |
WARNING_MESSAGE_ID |
EXP_AUTH_LOCATION.SI_0130 |
Entity Name | EXP_AUTH_LOCATION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_LOCATION.SI_0130 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
LOCATION_ID |
EXP_AUTH_LOCATION.PI_0302 |
Entity Name | EXP_AUTH_LOCATION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_LOCATION.PI_0302 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
LOCATION_NO |
EXP_AUTH_REVISION.RI_F00366 |
Entity Name | EXP_AUTH_REVISION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_REVISION.RI_F00366 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID |
EXP_AUTH_REVISION.RI_F00365 |
Entity Name | EXP_AUTH_REVISION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_REVISION.RI_F00365 Index Columns |
ColumnName | Sort Order |
REVISION_EMPL_ID |
EXP_AUTH_REVISION.PI_0244 |
Entity Name | EXP_AUTH_REVISION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_REVISION.PI_0244 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
REVISION_NO |
EXP_AUTH_TASKS_EMPL.RI_F00388 |
Entity Name | EXP_AUTH_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_TASKS_EMPL.RI_F00388 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
ALLOCATION_ID | |
FUNCTIONAL_ROLE_CD | |
S_TASK_CD |
EXP_AUTH_TASKS_EMPL.RI_F00389 |
Entity Name | EXP_AUTH_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_TASKS_EMPL.RI_F00389 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
EXP_AUTH_TASKS_EMPL.RI_F00390 |
Entity Name | EXP_AUTH_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_AUTH_TASKS_EMPL.RI_F00390 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EXP_AUTH_TASKS_EMPL.PI_0256 |
Entity Name | EXP_AUTH_TASKS_EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_TASKS_EMPL.PI_0256 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
ALLOCATION_ID | |
FUNCTIONAL_ROLE_CD | |
S_TASK_CD | |
EMPL_ID |
EXP_AUTH_WARNING.PI_O249 |
Entity Name | EXP_AUTH_WARNING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_AUTH_WARNING.PI_O249 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID | |
WARNING_MESSAGE_ID |
EXP_BATCH_TYPE.RI_F00421 |
Entity Name | EXP_BATCH_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE.RI_F00421 Index Columns |
ColumnName | Sort Order |
PAY_CURRENCY_CD |
EXP_BATCH_TYPE.RI_F00289 |
Entity Name | EXP_BATCH_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE.RI_F00289 Index Columns |
ColumnName | Sort Order |
DFLT_TRANS_CURRENCY_CD |
EXP_BATCH_TYPE.RI_F00288 |
Entity Name | EXP_BATCH_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE.RI_F00288 Index Columns |
ColumnName | Sort Order |
DFLT_EMPL_ID |
EXP_BATCH_TYPE.RI_F00287 |
Entity Name | EXP_BATCH_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE.RI_F00287 Index Columns |
ColumnName | Sort Order |
DFLT_PROVIDER_CD |
EXP_BATCH_TYPE.RI_F00286 |
Entity Name | EXP_BATCH_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE.RI_F00286 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
EXP_BATCH_TYPE.PI_0222 |
Entity Name | EXP_BATCH_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_BATCH_TYPE.PI_0222 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD |
EXP_BATCH_TYPE_FILTER.RI_F00290 |
Entity Name | EXP_BATCH_TYPE_FILTER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE_FILTER.RI_F00290 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD |
EXP_BATCH_TYPE_FILTER.PI_0223 |
Entity Name | EXP_BATCH_TYPE_FILTER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_BATCH_TYPE_FILTER.PI_0223 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD | |
AMEX_START_POSITION_NO | |
AMEX_END_POSITION_NO | |
AMEX_FILTER_S |
EXP_BATCH_TYPE_FILTER_VISA.RI_F00410 |
Entity Name | EXP_BATCH_TYPE_FILTER_VISA |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE_FILTER_VISA.RI_F00410 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD |
EXP_BATCH_TYPE_FILTER_VISA.RI_F00411 |
Entity Name | EXP_BATCH_TYPE_FILTER_VISA |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE_FILTER_VISA.RI_F00411 Index Columns |
ColumnName | Sort Order |
VISA_TRANS_TYPE_CD |
EXP_BATCH_TYPE_FILTER_VISA.PI_0279 |
Entity Name | EXP_BATCH_TYPE_FILTER_VISA |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_BATCH_TYPE_FILTER_VISA.PI_0279 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD | |
VISA_TRANS_TYPE_CD |
EXP_BATCH_TYPE_GHOST_CARD.RI_F00309 |
Entity Name | EXP_BATCH_TYPE_GHOST_CARD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE_GHOST_CARD.RI_F00309 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD |
EXP_BATCH_TYPE_GHOST_CARD.PI_0228 |
Entity Name | EXP_BATCH_TYPE_GHOST_CARD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_BATCH_TYPE_GHOST_CARD.PI_0228 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD | |
GHOST_CARD_S |
EXP_BATCH_TYPE_VISA_WIZARD.RI_F00412 |
Entity Name | EXP_BATCH_TYPE_VISA_WIZARD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE_VISA_WIZARD.RI_F00412 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD |
EXP_BATCH_TYPE_VISA_WIZARD.RI_F00413 |
Entity Name | EXP_BATCH_TYPE_VISA_WIZARD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_BATCH_TYPE_VISA_WIZARD.RI_F00413 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
EXP_BATCH_TYPE_VISA_WIZARD.PI_0280 |
Entity Name | EXP_BATCH_TYPE_VISA_WIZARD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_BATCH_TYPE_VISA_WIZARD.PI_0280 Index Columns |
ColumnName | Sort Order |
EXP_BATCH_TYPE_CD | |
FROM_VISA_MERCHANT_CATEGORY_CD | |
TO_VISA_MERCHANT_CATEGORY_CD |
EXP_CHARGE_TYPE.PI_0170 |
Entity Name | EXP_CHARGE_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_CHARGE_TYPE.PI_0170 Index Columns |
ColumnName | Sort Order |
EXP_CHARGE_TYPE_CD |
EXP_CHARGE_TYPE_CHARGE.RI_F00184 |
Entity Name | EXP_CHARGE_TYPE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CHARGE_TYPE_CHARGE.RI_F00184 Index Columns |
ColumnName | Sort Order |
EXP_CHARGE_TYPE_CD |
EXP_CHARGE_TYPE_CHARGE.PI_0171 |
Entity Name | EXP_CHARGE_TYPE_CHARGE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_CHARGE_TYPE_CHARGE.PI_0171 Index Columns |
ColumnName | Sort Order |
EXP_CHARGE_TYPE_CD | |
S_EXP_LINE_TYPE_CD |
EXP_CLASS.PI_0146 |
Entity Name | EXP_CLASS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_CLASS.PI_0146 Index Columns |
ColumnName | Sort Order |
EXP_CLASS_CD |
EXP_CLASS_EXP_RPT_TYPE.RI_F00159 |
Entity Name | EXP_CLASS_EXP_RPT_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CLASS_EXP_RPT_TYPE.RI_F00159 Index Columns |
ColumnName | Sort Order |
EXP_CLASS_CD |
EXP_CLASS_EXP_RPT_TYPE.PI_0155 |
Entity Name | EXP_CLASS_EXP_RPT_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_CLASS_EXP_RPT_TYPE.PI_0155 Index Columns |
ColumnName | Sort Order |
EXP_CLASS_CD | |
EXP_RPT_TYPE_CD |
EXP_CLASS_EXP_RPT_TYPE.RI_F00160 |
Entity Name | EXP_CLASS_EXP_RPT_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CLASS_EXP_RPT_TYPE.RI_F00160 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_CLASS_PAY_METHOD.RI_F00161 |
Entity Name | EXP_CLASS_PAY_METHOD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CLASS_PAY_METHOD.RI_F00161 Index Columns |
ColumnName | Sort Order |
EXP_CLASS_CD |
EXP_CLASS_PAY_METHOD.RI_F00162 |
Entity Name | EXP_CLASS_PAY_METHOD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CLASS_PAY_METHOD.RI_F00162 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
EXP_CLASS_PAY_METHOD.PI_0156 |
Entity Name | EXP_CLASS_PAY_METHOD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_CLASS_PAY_METHOD.PI_0156 Index Columns |
ColumnName | Sort Order |
EXP_CLASS_CD | |
PAY_METHOD_CD |
EXP_COMMIT_DETL.SI_0143 |
Entity Name | EXP_COMMIT_DETL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_COMMIT_DETL.SI_0143 Index Columns |
ColumnName | Sort Order |
EXP_ID | |
EXPENSE_ID |
EXP_CONFIG.RI_F00201 |
Entity Name | EXP_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CONFIG.RI_F00201 Index Columns |
ColumnName | Sort Order |
DFLT_EXP_CLASS_CD |
EXP_CONFIG.PI_0163 |
Entity Name | EXP_CONFIG |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_CONFIG.PI_0163 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
EXP_CONFIG_LABELS.RI_F00171 |
Entity Name | EXP_CONFIG_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CONFIG_LABELS.RI_F00171 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
EXP_CONFIG_LABELS.RI_F00172 |
Entity Name | EXP_CONFIG_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CONFIG_LABELS.RI_F00172 Index Columns |
ColumnName | Sort Order |
LANGUAGE_CD | |
COUNTRY_CD |
EXP_CONFIG_LABELS.PI_0164 |
Entity Name | EXP_CONFIG_LABELS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_CONFIG_LABELS.PI_0164 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
COUNTRY_CD | |
LANGUAGE_CD |
EXP_CONFIG_UDT.RI_F00173 |
Entity Name | EXP_CONFIG_UDT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_CONFIG_UDT.RI_F00173 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
EXP_CONFIG_UDT.PI_0165 |
Entity Name | EXP_CONFIG_UDT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_CONFIG_UDT.PI_0165 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
S_UDT_CD |
EXP_RPT.RI_F00346 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00346 Index Columns |
ColumnName | Sort Order |
EXP_AUTH_ID |
EXP_RPT.RI_F00207 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00207 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EXP_RPT.RI_F00206 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00206 Index Columns |
ColumnName | Sort Order |
CURRENCY_SCHEDULE_CD |
EXP_RPT.RI_F00205 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00205 Index Columns |
ColumnName | Sort Order |
BASE_CURRENCY_CD |
EXP_RPT.RI_F00204 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00204 Index Columns |
ColumnName | Sort Order |
PAY_CURRENCY_CD |
EXP_RPT.RI_F00203 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00203 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
EXP_RPT.PI_0180 |
Entity Name | EXP_RPT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT.PI_0180 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID |
EXP_RPT.RI_F00210 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00210 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD |
EXP_RPT.RI_F00209 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00209 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT.RI_F00208 |
Entity Name | EXP_RPT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT.RI_F00208 Index Columns |
ColumnName | Sort Order |
EXP_CLASS_CD |
EXP_RPT_ADVANCE.PI_0303 |
Entity Name | EXP_RPT_ADVANCE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_ADVANCE.PI_0303 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
ADVANCE_ID |
EXP_RPT_CHARGE_ALLOCATIONS.RI_F00342 |
Entity Name | EXP_RPT_CHARGE_ALLOCATIONS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_CHARGE_ALLOCATIONS.RI_F00342 Index Columns |
ColumnName | Sort Order |
UDT09_ID |
EXP_RPT_CHARGE_ALLOCATIONS.RI_F00212 |
Entity Name | EXP_RPT_CHARGE_ALLOCATIONS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_CHARGE_ALLOCATIONS.RI_F00212 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID |
EXP_RPT_CHARGE_ALLOCATIONS.PI_0182 |
Entity Name | EXP_RPT_CHARGE_ALLOCATIONS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_CHARGE_ALLOCATIONS.PI_0182 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
ALLOCATION_ID |
EXP_RPT_CHARGE_ALLOCATIONS.SI_0049 |
Entity Name | EXP_RPT_CHARGE_ALLOCATIONS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_CHARGE_ALLOCATIONS.SI_0049 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD |
EXP_RPT_CHARGE_WARNING.PI_O254 |
Entity Name | EXP_RPT_CHARGE_WARNING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_CHARGE_WARNING.PI_O254 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
ALLOCATION_ID | |
WARNING_MESSAGE_ID |
EXP_RPT_EXPENSE.RI_F00225 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00225 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID |
EXP_RPT_EXPENSE.RI_F00220 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00220 Index Columns |
ColumnName | Sort Order |
TRANS_CURRENCY_CD |
EXP_RPT_EXPENSE.RI_F00268 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00268 Index Columns |
ColumnName | Sort Order |
TAX_SCHEDULE_CD |
EXP_RPT_EXPENSE.PI_0186 |
Entity Name | EXP_RPT_EXPENSE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_EXPENSE.PI_0186 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID |
EXP_RPT_EXPENSE.RI_F00259 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00259 Index Columns |
ColumnName | Sort Order |
RECEIPT_EMPL_ID |
EXP_RPT_EXPENSE.RI_F00229 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00229 Index Columns |
ColumnName | Sort Order |
PROVIDER_CD |
EXP_RPT_EXPENSE.RI_F00228 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00228 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
EXP_RPT_EXPENSE.RI_F00226 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00226 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
PARENT_EXPENSE_ID |
EXP_RPT_EXPENSE.RI_F00341 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00341 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_RPT_EXPENSE.RI_F00340 |
Entity Name | EXP_RPT_EXPENSE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE.RI_F00340 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
EXP_CATEGORY_CD |
EXP_RPT_EXPENSE_ATTENDEE.RI_F00230 |
Entity Name | EXP_RPT_EXPENSE_ATTENDEE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_ATTENDEE.RI_F00230 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID |
EXP_RPT_EXPENSE_ATTENDEE.PI_0187 |
Entity Name | EXP_RPT_EXPENSE_ATTENDEE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_EXPENSE_ATTENDEE.PI_0187 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID | |
ATTENDEE_SEQ_NO |
EXP_RPT_EXPENSE_ATTENDEE.RI_F00231 |
Entity Name | EXP_RPT_EXPENSE_ATTENDEE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_ATTENDEE.RI_F00231 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EXP_RPT_EXPENSE_CHARGE.SI_0128 |
Entity Name | EXP_RPT_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_CHARGE.SI_0128 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID | |
ALLOCATION_ID |
EXP_RPT_EXPENSE_CHARGE.RI_F00233 |
Entity Name | EXP_RPT_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_CHARGE.RI_F00233 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID |
EXP_RPT_EXPENSE_CHARGE.RI_F00236 |
Entity Name | EXP_RPT_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_CHARGE.RI_F00236 Index Columns |
ColumnName | Sort Order |
UDT10_ID |
EXP_RPT_EXPENSE_CHARGE.RI_F00235 |
Entity Name | EXP_RPT_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_CHARGE.RI_F00235 Index Columns |
ColumnName | Sort Order |
UDT01_ID |
EXP_RPT_EXPENSE_CHARGE.RI_F00234 |
Entity Name | EXP_RPT_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_CHARGE.RI_F00234 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
ALLOCATION_ID |
EXP_RPT_EXPENSE_CHARGE.RI_F00232 |
Entity Name | EXP_RPT_EXPENSE_CHARGE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_CHARGE.RI_F00232 Index Columns |
ColumnName | Sort Order |
EXP_CHARGE_TYPE_CD |
EXP_RPT_EXPENSE_CHARGE.PI_0188 |
Entity Name | EXP_RPT_EXPENSE_CHARGE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_EXPENSE_CHARGE.PI_0188 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_CHARGE_TYPE_CD |
EXP_RPT_EXPENSE_DAY.RI_F00237 |
Entity Name | EXP_RPT_EXPENSE_DAY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_DAY.RI_F00237 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID |
EXP_RPT_EXPENSE_DAY.PI_0189 |
Entity Name | EXP_RPT_EXPENSE_DAY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_EXPENSE_DAY.PI_0189 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID | |
EXP_DT |
EXP_RPT_EXPENSE_OTHER.RI_F00239 |
Entity Name | EXP_RPT_EXPENSE_OTHER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_OTHER.RI_F00239 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID |
EXP_RPT_EXPENSE_OTHER.RI_F00238 |
Entity Name | EXP_RPT_EXPENSE_OTHER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_EXPENSE_OTHER.RI_F00238 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
OTHER_EXPENSE_CD |
EXP_RPT_EXPENSE_OTHER.PI_0190 |
Entity Name | EXP_RPT_EXPENSE_OTHER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_EXPENSE_OTHER.PI_0190 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID | |
OTHER_SEQ_NO |
EXP_RPT_EXPENSE_WARNING.PI_O253 |
Entity Name | EXP_RPT_EXPENSE_WARNING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_EXPENSE_WARNING.PI_O253 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
EXPENSE_ID | |
WARNING_MESSAGE_ID |
EXP_RPT_LOCATION.SI_0129 |
Entity Name | EXP_RPT_LOCATION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_LOCATION.SI_0129 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
LOCATION_ID |
EXP_RPT_LOCATION.PI_0269 |
Entity Name | EXP_RPT_LOCATION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_LOCATION.PI_0269 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
LOCATION_NO |
EXP_RPT_PAYMENT.RI_F00213 |
Entity Name | EXP_RPT_PAYMENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_PAYMENT.RI_F00213 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID |
EXP_RPT_PAYMENT.PI_0183 |
Entity Name | EXP_RPT_PAYMENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_PAYMENT.PI_0183 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
PAYMENT_REFERENCE_CD |
EXP_RPT_REVISION.RI_F00214 |
Entity Name | EXP_RPT_REVISION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_REVISION.RI_F00214 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID |
EXP_RPT_REVISION.RI_F00215 |
Entity Name | EXP_RPT_REVISION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_REVISION.RI_F00215 Index Columns |
ColumnName | Sort Order |
REVISION_EMPL_ID |
EXP_RPT_REVISION.PI_0184 |
Entity Name | EXP_RPT_REVISION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_REVISION.PI_0184 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
REVISION_NO |
EXP_RPT_TASKS_EMPL.RI_F00385 |
Entity Name | EXP_RPT_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TASKS_EMPL.RI_F00385 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
ALLOCATION_ID | |
FUNCTIONAL_ROLE_CD | |
S_TASK_CD |
EXP_RPT_TASKS_EMPL.RI_F00387 |
Entity Name | EXP_RPT_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TASKS_EMPL.RI_F00387 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
EXP_RPT_TASKS_EMPL.RI_F00386 |
Entity Name | EXP_RPT_TASKS_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TASKS_EMPL.RI_F00386 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
EXP_RPT_TASKS_EMPL.PI_0255 |
Entity Name | EXP_RPT_TASKS_EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TASKS_EMPL.PI_0255 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
ALLOCATION_ID | |
FUNCTIONAL_ROLE_CD | |
S_TASK_CD | |
EMPL_ID |
EXP_RPT_TYPE.PI_0152 |
Entity Name | EXP_RPT_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE.PI_0152 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT_TYPE.RI_LF_0075 |
Entity Name | EXP_RPT_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE.RI_LF_0075 Index Columns |
ColumnName | Sort Order |
CURRENCY_SCHEDULE_CD |
EXP_RPT_TYPE_CATEGORY.RI_F00279 |
Entity Name | EXP_RPT_TYPE_CATEGORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CATEGORY.RI_F00279 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT_TYPE_CATEGORY.PI_0218 |
Entity Name | EXP_RPT_TYPE_CATEGORY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_CATEGORY.PI_0218 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
EXP_CATEGORY_CD |
EXP_RPT_TYPE_CATEGORY_EXP_TYPE.RI_F00283 |
Entity Name | EXP_RPT_TYPE_CATEGORY_EXP_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CATEGORY_EXP_TYPE.RI_F00283 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
EXP_CATEGORY_CD |
EXP_RPT_TYPE_CATEGORY_EXP_TYPE.RI_F00284 |
Entity Name | EXP_RPT_TYPE_CATEGORY_EXP_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CATEGORY_EXP_TYPE.RI_F00284 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_RPT_TYPE_CATEGORY_EXP_TYPE.RI_F00320 |
Entity Name | EXP_RPT_TYPE_CATEGORY_EXP_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CATEGORY_EXP_TYPE.RI_F00320 Index Columns |
ColumnName | Sort Order |
TAX_SCHEDULE_CD |
EXP_RPT_TYPE_CATEGORY_EXP_TYPE.PI_0220 |
Entity Name | EXP_RPT_TYPE_CATEGORY_EXP_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_CATEGORY_EXP_TYPE.PI_0220 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
EXP_CATEGORY_CD | |
EXP_TYPE_CD |
EXP_RPT_TYPE_CATEGORY_LABELS.RI_F00281 |
Entity Name | EXP_RPT_TYPE_CATEGORY_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CATEGORY_LABELS.RI_F00281 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
EXP_CATEGORY_CD |
EXP_RPT_TYPE_CATEGORY_LABELS.PI_0219 |
Entity Name | EXP_RPT_TYPE_CATEGORY_LABELS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_CATEGORY_LABELS.PI_0219 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
EXP_CATEGORY_CD | |
COUNTRY_CD | |
LANGUAGE_CD |
EXP_RPT_TYPE_CATEGORY_LABELS.RI_F00282 |
Entity Name | EXP_RPT_TYPE_CATEGORY_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CATEGORY_LABELS.RI_F00282 Index Columns |
ColumnName | Sort Order |
COUNTRY_CD | |
LANGUAGE_CD |
EXP_RPT_TYPE_CODE1.RI_F00394 |
Entity Name | EXP_RPT_TYPE_CODE1 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CODE1.RI_F00394 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT_TYPE_CODE1.PI_0259 |
Entity Name | EXP_RPT_TYPE_CODE1 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_CODE1.PI_0259 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
CODE1_CD |
EXP_RPT_TYPE_CODE2.RI_F00395 |
Entity Name | EXP_RPT_TYPE_CODE2 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CODE2.RI_F00395 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT_TYPE_CODE2.PI_0260 |
Entity Name | EXP_RPT_TYPE_CODE2 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_CODE2.PI_0260 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
CODE2_CD |
EXP_RPT_TYPE_CODE3.RI_F00396 |
Entity Name | EXP_RPT_TYPE_CODE3 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_CODE3.RI_F00396 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT_TYPE_CODE3.PI_0261 |
Entity Name | EXP_RPT_TYPE_CODE3 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_CODE3.PI_0261 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
CODE3_CD |
EXP_RPT_TYPE_LABELS.RI_F00393 |
Entity Name | EXP_RPT_TYPE_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_LABELS.RI_F00393 Index Columns |
ColumnName | Sort Order |
LANGUAGE_CD | |
COUNTRY_CD |
EXP_RPT_TYPE_LABELS.RI_F00392 |
Entity Name | EXP_RPT_TYPE_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_LABELS.RI_F00392 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT_TYPE_LABELS.PI_0258 |
Entity Name | EXP_RPT_TYPE_LABELS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_LABELS.PI_0258 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
COUNTRY_CD | |
LANGUAGE_CD |
EXP_RPT_TYPE_SCHEDULE.RI_F00391 |
Entity Name | EXP_RPT_TYPE_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_SCHEDULE.RI_F00391 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT_TYPE_SCHEDULE.PI_0257 |
Entity Name | EXP_RPT_TYPE_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_SCHEDULE.PI_0257 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
S_TYPE_CD | |
S_SCHEDULE_CD |
EXP_RPT_TYPE_TASK.PI_O238 |
Entity Name | EXP_RPT_TYPE_TASK |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_TYPE_TASK.PI_O238 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD | |
FUNCTIONAL_ROLE_CD | |
S_TASK_OBJECT_CD | |
S_TASK_SUB_OBJECT_CD | |
S_TASK_TYPE_CD | |
ATTACHMENT_TYPE_CD |
EXP_RPT_TYPE_TASK.SI_0106 |
Entity Name | EXP_RPT_TYPE_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_TASK.SI_0106 Index Columns |
ColumnName | Sort Order |
BACKUP_FUNCTIONAL_ROLE_CD |
EXP_RPT_TYPE_TASK.SI_0105 |
Entity Name | EXP_RPT_TYPE_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_TASK.SI_0105 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_CD |
EXP_RPT_TYPE_TASK.SI_0104 |
Entity Name | EXP_RPT_TYPE_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_TASK.SI_0104 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
EXP_RPT_TYPE_TASK.SI_0103 |
Entity Name | EXP_RPT_TYPE_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_RPT_TYPE_TASK.SI_0103 Index Columns |
ColumnName | Sort Order |
EXP_RPT_TYPE_CD |
EXP_RPT_WARNING.PI_O252 |
Entity Name | EXP_RPT_WARNING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_RPT_WARNING.PI_O252 Index Columns |
ColumnName | Sort Order |
EXP_RPT_ID | |
WARNING_MESSAGE_ID |
EXP_TYPE.PI_0149 |
Entity Name | EXP_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE.PI_0149 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_CODE1.RI_F00276 |
Entity Name | EXP_TYPE_CODE1 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_CODE1.RI_F00276 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_CODE1.PI_0215 |
Entity Name | EXP_TYPE_CODE1 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_CODE1.PI_0215 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
CODE1_CD |
EXP_TYPE_CODE2.RI_F00277 |
Entity Name | EXP_TYPE_CODE2 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_CODE2.RI_F00277 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_CODE2.PI_0216 |
Entity Name | EXP_TYPE_CODE2 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_CODE2.PI_0216 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
CODE2_CD |
EXP_TYPE_CODE3.RI_F00278 |
Entity Name | EXP_TYPE_CODE3 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_CODE3.RI_F00278 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_CODE3.PI_0217 |
Entity Name | EXP_TYPE_CODE3 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_CODE3.PI_0217 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
CODE3_CD |
EXP_TYPE_EXP_CHARGE_TYPE.RI_F00182 |
Entity Name | EXP_TYPE_EXP_CHARGE_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_EXP_CHARGE_TYPE.RI_F00182 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_EXP_CHARGE_TYPE.RI_F00183 |
Entity Name | EXP_TYPE_EXP_CHARGE_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_EXP_CHARGE_TYPE.RI_F00183 Index Columns |
ColumnName | Sort Order |
EXP_CHARGE_TYPE_CD |
EXP_TYPE_EXP_CHARGE_TYPE.PI_0169 |
Entity Name | EXP_TYPE_EXP_CHARGE_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_EXP_CHARGE_TYPE.PI_0169 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
EXP_CHARGE_TYPE_CD |
EXP_TYPE_LABELS.RI_F00187 |
Entity Name | EXP_TYPE_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_LABELS.RI_F00187 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_LABELS.RI_F00188 |
Entity Name | EXP_TYPE_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_LABELS.RI_F00188 Index Columns |
ColumnName | Sort Order |
LANGUAGE_CD | |
COUNTRY_CD |
EXP_TYPE_LABELS.PI_0173 |
Entity Name | EXP_TYPE_LABELS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_LABELS.PI_0173 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
COUNTRY_CD | |
LANGUAGE_CD |
EXP_TYPE_OTHER.RI_F00189 |
Entity Name | EXP_TYPE_OTHER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_OTHER.RI_F00189 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_OTHER.RI_F00311 |
Entity Name | EXP_TYPE_OTHER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_OTHER.RI_F00311 Index Columns |
ColumnName | Sort Order |
OTHER_EXP_TYPE_CD |
EXP_TYPE_OTHER.PI_0174 |
Entity Name | EXP_TYPE_OTHER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_OTHER.PI_0174 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
OTHER_EXPENSE_CD |
EXP_TYPE_PAY_METHOD.RI_F00274 |
Entity Name | EXP_TYPE_PAY_METHOD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_PAY_METHOD.RI_F00274 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_PAY_METHOD.PI_0214 |
Entity Name | EXP_TYPE_PAY_METHOD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_PAY_METHOD.PI_0214 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
PAY_METHOD_CD |
EXP_TYPE_PAY_METHOD.RI_F00275 |
Entity Name | EXP_TYPE_PAY_METHOD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_PAY_METHOD.RI_F00275 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
EXP_TYPE_PROVIDER.RI_F00273 |
Entity Name | EXP_TYPE_PROVIDER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_PROVIDER.RI_F00273 Index Columns |
ColumnName | Sort Order |
PROVIDER_CD |
EXP_TYPE_PROVIDER.RI_F00272 |
Entity Name | EXP_TYPE_PROVIDER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_PROVIDER.RI_F00272 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_PROVIDER.PI_0213 |
Entity Name | EXP_TYPE_PROVIDER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_PROVIDER.PI_0213 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
PROVIDER_CD |
EXP_TYPE_RATE_CEILING.RI_F00416 |
Entity Name | EXP_TYPE_RATE_CEILING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_RATE_CEILING.RI_F00416 Index Columns |
ColumnName | Sort Order |
CURRENCY_CD |
EXP_TYPE_RATE_CEILING.RI_F00153 |
Entity Name | EXP_TYPE_RATE_CEILING |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_RATE_CEILING.RI_F00153 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXP_TYPE_RATE_CEILING.PI_0150 |
Entity Name | EXP_TYPE_RATE_CEILING |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_RATE_CEILING.PI_0150 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
EFFECTIVE_DT | |
CURRENCY_CD |
EXP_TYPE_TASK.PI_O237 |
Entity Name | EXP_TYPE_TASK |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXP_TYPE_TASK.PI_O237 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD | |
FUNCTIONAL_ROLE_CD | |
S_TASK_OBJECT_CD | |
S_TASK_SUB_OBJECT_CD | |
S_TASK_TYPE_CD | |
ATTACHMENT_TYPE_CD |
EXP_TYPE_TASK.SI_0102 |
Entity Name | EXP_TYPE_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_TASK.SI_0102 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_CD |
EXP_TYPE_TASK.SI_0101 |
Entity Name | EXP_TYPE_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_TASK.SI_0101 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
EXP_TYPE_TASK.SI_0099 |
Entity Name | EXP_TYPE_TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXP_TYPE_TASK.SI_0099 Index Columns |
ColumnName | Sort Order |
EXP_TYPE_CD |
EXPORT_EXPENSE.PI_0197 |
Entity Name | EXPORT_EXPENSE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXPORT_EXPENSE.PI_0197 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
EXPORT_LABOR.PI_0092 |
Entity Name | EXPORT_LABOR |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXPORT_LABOR.PI_0092 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT | |
SEQ_NO |
EXPORT_LABOR.SI_0045 |
Entity Name | EXPORT_LABOR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXPORT_LABOR.SI_0045 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
EXPORT_PAYROLL.PI_0093 |
Entity Name | EXPORT_PAYROLL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
EXPORT_PAYROLL.PI_0093 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT | |
SEQ_NO |
EXPORT_PAYROLL.SI_0046 |
Entity Name | EXPORT_PAYROLL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
EXPORT_PAYROLL.SI_0046 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
FUNCTIONAL_ROLE.PI_0129 |
Entity Name | FUNCTIONAL_ROLE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
FUNCTIONAL_ROLE.PI_0129 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
FUNCTIONAL_ROLE.RI_F00317 |
Entity Name | FUNCTIONAL_ROLE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
FUNCTIONAL_ROLE.RI_F00317 Index Columns |
ColumnName | Sort Order |
DELEGATION_ROLE_CD |
GENERAL_CONFIG.RI_F00262 |
Entity Name | GENERAL_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG.RI_F00262 Index Columns |
ColumnName | Sort Order |
SERVER_TIME_ZONE_CD |
GENERAL_CONFIG.RI_F00119 |
Entity Name | GENERAL_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG.RI_F00119 Index Columns |
ColumnName | Sort Order |
DFLT_ROLE_CD |
GENERAL_CONFIG.RI_F00118 |
Entity Name | GENERAL_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG.RI_F00118 Index Columns |
ColumnName | Sort Order |
DFLT_UDT01_TYPE_CD |
GENERAL_CONFIG.RI_F00117 |
Entity Name | GENERAL_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG.RI_F00117 Index Columns |
ColumnName | Sort Order |
DFLT_CURRENCY_CD |
GENERAL_CONFIG.PI_0136 |
Entity Name | GENERAL_CONFIG |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
GENERAL_CONFIG.PI_0136 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
GENERAL_CONFIG_ATTACHMENT.UI_0001 |
Entity Name | GENERAL_CONFIG_ATTACHMENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Unique Constraint |
GENERAL_CONFIG_ATTACHMENT.UI_0001 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_CD |
GENERAL_CONFIG_ATTACHMENT.PI_O234 |
Entity Name | GENERAL_CONFIG_ATTACHMENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
GENERAL_CONFIG_ATTACHMENT.PI_O234 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
ATTACHMENT_TYPE_CD |
GENERAL_CONFIG_ATTACHMENT.SI_0095 |
Entity Name | GENERAL_CONFIG_ATTACHMENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG_ATTACHMENT.SI_0095 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
GENERAL_CONFIG_ATTACHMENT_LBLS.PI_O235 |
Entity Name | GENERAL_CONFIG_ATTACHMENT_LBLS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
GENERAL_CONFIG_ATTACHMENT_LBLS.PI_O235 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
ATTACHMENT_TYPE_CD | |
COUNTRY_CD | |
LANGUAGE_CD |
GENERAL_CONFIG_ATTACHMENT_LBLS.SI_0097 |
Entity Name | GENERAL_CONFIG_ATTACHMENT_LBLS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG_ATTACHMENT_LBLS.SI_0097 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_CD |
GENERAL_CONFIG_ATTACHMENT_LBLS.SI_0096 |
Entity Name | GENERAL_CONFIG_ATTACHMENT_LBLS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG_ATTACHMENT_LBLS.SI_0096 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
GENERAL_CONFIG_LABELS.RI_F00120 |
Entity Name | GENERAL_CONFIG_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG_LABELS.RI_F00120 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
GENERAL_CONFIG_LABELS.RI_F00121 |
Entity Name | GENERAL_CONFIG_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG_LABELS.RI_F00121 Index Columns |
ColumnName | Sort Order |
LANGUAGE_CD | |
COUNTRY_CD |
GENERAL_CONFIG_LABELS.PI_0137 |
Entity Name | GENERAL_CONFIG_LABELS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
GENERAL_CONFIG_LABELS.PI_0137 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
COUNTRY_CD | |
LANGUAGE_CD |
GENERAL_CONFIG_UDT.RI_F00122 |
Entity Name | GENERAL_CONFIG_UDT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG_UDT.RI_F00122 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
GENERAL_CONFIG_UDT.PI_0138 |
Entity Name | GENERAL_CONFIG_UDT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
GENERAL_CONFIG_UDT.PI_0138 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
S_UDT_CD |
GENERAL_CONFIG_UDT_LABELS.RI_F00124 |
Entity Name | GENERAL_CONFIG_UDT_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG_UDT_LABELS.RI_F00124 Index Columns |
ColumnName | Sort Order |
LANGUAGE_CD | |
COUNTRY_CD |
GENERAL_CONFIG_UDT_LABELS.RI_F00123 |
Entity Name | GENERAL_CONFIG_UDT_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
GENERAL_CONFIG_UDT_LABELS.RI_F00123 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
S_UDT_CD |
GENERAL_CONFIG_UDT_LABELS.PI_0139 |
Entity Name | GENERAL_CONFIG_UDT_LABELS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
GENERAL_CONFIG_UDT_LABELS.PI_0139 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
COUNTRY_CD | |
LANGUAGE_CD | |
S_UDT_CD |
IMPORT_ERROR.SI_0073 |
Entity Name | IMPORT_ERROR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
IMPORT_ERROR.SI_0073 Index Columns |
ColumnName | Sort Order |
MESSAGE_GROUP_NAME | |
ERROR_ID |
IMPORT_ERROR.PI_0270 |
Entity Name | IMPORT_ERROR |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
IMPORT_ERROR.PI_0270 Index Columns |
ColumnName | Sort Order |
ERROR_ID |
IMPORT_LOG.PI_0304 |
Entity Name | IMPORT_LOG |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
IMPORT_LOG.PI_0304 Index Columns |
ColumnName | Sort Order |
BATCH_DTT | |
MESSAGE_GROUP_NAME | |
FILE_NAME | |
MESSAGE_NAME |
JDE_TS_F5606ZW.SI_0055 |
Entity Name | JDE_TS_F5606ZW |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
JDE_TS_F5606ZW.SI_0055 Index Columns |
ColumnName | Sort Order |
WKC5606EMP | |
WKC5606T01 | |
WKC5606T10 | |
WKC5606CRF | |
WKC5606TSD | |
WKC5606T07 |
JDE_TS_F5606ZW.SI_0054 |
Entity Name | JDE_TS_F5606ZW |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
JDE_TS_F5606ZW.SI_0054 Index Columns |
ColumnName | Sort Order |
WKC5606CRF | |
WKEDSP |
JDE_TS_F5606ZW.SI_0053 |
Entity Name | JDE_TS_F5606ZW |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
JDE_TS_F5606ZW.SI_0053 Index Columns |
ColumnName | Sort Order |
WKC5606EMP | |
WKC5606T01 | |
WKC5606T10 |
JDE_TS_F5606ZW.PI_O233 |
Entity Name | JDE_TS_F5606ZW |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
JDE_TS_F5606ZW.PI_O233 Index Columns |
ColumnName | Sort Order |
WKC5606EMP | |
WKC5606TS | |
WKC5606FYR | |
WKC5606PER | |
WKEDLN | |
WKC5606CDT |
LANGUAGE.PI_0018 |
Entity Name | LANGUAGE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LANGUAGE.PI_0018 Index Columns |
ColumnName | Sort Order |
COUNTRY_CD | |
LANGUAGE_CD |
LEAVE_TYPE.RI_F00133 |
Entity Name | LEAVE_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LEAVE_TYPE.RI_F00133 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
LEAVE_TYPE.PI_0108 |
Entity Name | LEAVE_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LEAVE_TYPE.PI_0108 Index Columns |
ColumnName | Sort Order |
LEAVE_TYPE_CD |
LEAVE_TYPE_UDT.RI_F00080 |
Entity Name | LEAVE_TYPE_UDT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LEAVE_TYPE_UDT.RI_F00080 Index Columns |
ColumnName | Sort Order |
LEAVE_TYPE_CD |
LEAVE_TYPE_UDT.PI_0109 |
Entity Name | LEAVE_TYPE_UDT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LEAVE_TYPE_UDT.PI_0109 Index Columns |
ColumnName | Sort Order |
LEAVE_TYPE_CD | |
LEAVE_UDT_ID |
LIFE_EVENT.RI_F00377 |
Entity Name | LIFE_EVENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LIFE_EVENT.RI_F00377 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD_2 |
LIFE_EVENT.RI_F00376 |
Entity Name | LIFE_EVENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LIFE_EVENT.RI_F00376 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD_1 |
LIFE_EVENT.PI_0250 |
Entity Name | LIFE_EVENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LIFE_EVENT.PI_0250 Index Columns |
ColumnName | Sort Order |
LIFE_EVENT_CD |
LINK110.RI_F00260 |
Entity Name | LINK110 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK110.RI_F00260 Index Columns |
ColumnName | Sort Order |
UDT01_ID |
LINK110.RI_F00261 |
Entity Name | LINK110 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK110.RI_F00261 Index Columns |
ColumnName | Sort Order |
UDT10_ID |
LINK110.PI_0208 |
Entity Name | LINK110 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK110.PI_0208 Index Columns |
ColumnName | Sort Order |
UDT01_ID | |
UDT10_ID |
LINK12.RI_F00051 |
Entity Name | LINK12 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK12.RI_F00051 Index Columns |
ColumnName | Sort Order |
UDT02_ID |
LINK12.RI_F00050 |
Entity Name | LINK12 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK12.RI_F00050 Index Columns |
ColumnName | Sort Order |
UDT01_ID |
LINK12.PI_0044 |
Entity Name | LINK12 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK12.PI_0044 Index Columns |
ColumnName | Sort Order |
UDT01_ID | |
UDT02_ID |
LINK12.SI_0060 |
Entity Name | LINK12 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK12.SI_0060 Index Columns |
ColumnName | Sort Order |
UDT02_ID | |
UDT01_ID |
LINK12_WILDCARD.PI_0045 |
Entity Name | LINK12_WILDCARD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK12_WILDCARD.PI_0045 Index Columns |
ColumnName | Sort Order |
UDT01_ID_S | |
UDT02_ID_S |
LINK17.PI_0048 |
Entity Name | LINK17 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK17.PI_0048 Index Columns |
ColumnName | Sort Order |
UDT01_ID | |
UDT07_ID | |
CP_COMPANY_CD |
LINK17.SI_0061 |
Entity Name | LINK17 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK17.SI_0061 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
UDT01_ID | |
UDT07_NAME |
LINK17.RI_F00055 |
Entity Name | LINK17 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK17.RI_F00055 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
CP_COMPANY_CD |
LINK17.RI_F00054 |
Entity Name | LINK17 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK17.RI_F00054 Index Columns |
ColumnName | Sort Order |
UDT01_ID |
LINK17_WILDCARD.RI_F00067 |
Entity Name | LINK17_WILDCARD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK17_WILDCARD.RI_F00067 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
CP_COMPANY_CD |
LINK17_WILDCARD.PI_0049 |
Entity Name | LINK17_WILDCARD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK17_WILDCARD.PI_0049 Index Columns |
ColumnName | Sort Order |
UDT01_ID_S | |
UDT07_ID | |
CP_COMPANY_CD |
LINK19.SI_0062 |
Entity Name | LINK19 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK19.SI_0062 Index Columns |
ColumnName | Sort Order |
UDT09_ID | |
UDT01_ID |
LINK19.RI_F00053 |
Entity Name | LINK19 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK19.RI_F00053 Index Columns |
ColumnName | Sort Order |
UDT09_ID |
LINK19.RI_F00052 |
Entity Name | LINK19 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK19.RI_F00052 Index Columns |
ColumnName | Sort Order |
UDT01_ID |
LINK19.PI_0046 |
Entity Name | LINK19 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK19.PI_0046 Index Columns |
ColumnName | Sort Order |
UDT01_ID | |
UDT09_ID |
LINK19_WILDCARD.PI_0047 |
Entity Name | LINK19_WILDCARD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK19_WILDCARD.PI_0047 Index Columns |
ColumnName | Sort Order |
UDT01_ID_S | |
UDT09_ID_S |
LINK27.SI_0063 |
Entity Name | LINK27 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK27.SI_0063 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
UDT02_ID | |
CP_COMPANY_CD | |
UDT07_NAME |
LINK27.RI_F00057 |
Entity Name | LINK27 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK27.RI_F00057 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
CP_COMPANY_CD |
LINK27.RI_F00056 |
Entity Name | LINK27 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK27.RI_F00056 Index Columns |
ColumnName | Sort Order |
UDT02_ID |
LINK27.PI_0050 |
Entity Name | LINK27 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK27.PI_0050 Index Columns |
ColumnName | Sort Order |
UDT02_ID | |
UDT07_ID | |
CP_COMPANY_CD |
LINK27_WILDCARD.RI_F00068 |
Entity Name | LINK27_WILDCARD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK27_WILDCARD.RI_F00068 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
CP_COMPANY_CD |
LINK27_WILDCARD.PI_0051 |
Entity Name | LINK27_WILDCARD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK27_WILDCARD.PI_0051 Index Columns |
ColumnName | Sort Order |
UDT02_ID_S | |
UDT07_ID | |
CP_COMPANY_CD |
LINK29.RI_F00059 |
Entity Name | LINK29 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK29.RI_F00059 Index Columns |
ColumnName | Sort Order |
UDT09_ID |
LINK29.RI_F00058 |
Entity Name | LINK29 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK29.RI_F00058 Index Columns |
ColumnName | Sort Order |
UDT02_ID |
LINK29.PI_0052 |
Entity Name | LINK29 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK29.PI_0052 Index Columns |
ColumnName | Sort Order |
UDT02_ID | |
UDT09_ID |
LINK29.SI_0064 |
Entity Name | LINK29 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK29.SI_0064 Index Columns |
ColumnName | Sort Order |
UDT09_ID | |
UDT02_ID |
LINK29_WILDCARD.PI_0053 |
Entity Name | LINK29_WILDCARD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK29_WILDCARD.PI_0053 Index Columns |
ColumnName | Sort Order |
UDT02_ID_S | |
UDT09_ID_S |
LINK93.PI_0054 |
Entity Name | LINK93 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK93.PI_0054 Index Columns |
ColumnName | Sort Order |
UDT09_ID | |
UDT03_ID |
LINK93.RI_F00061 |
Entity Name | LINK93 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK93.RI_F00061 Index Columns |
ColumnName | Sort Order |
UDT03_ID |
LINK93.RI_F00060 |
Entity Name | LINK93 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK93.RI_F00060 Index Columns |
ColumnName | Sort Order |
UDT09_ID |
LINK93.SI_0065 |
Entity Name | LINK93 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK93.SI_0065 Index Columns |
ColumnName | Sort Order |
UDT03_ID | |
UDT03_NAME | |
UDT09_ID |
LINK93_WILDCARD.PI_0055 |
Entity Name | LINK93_WILDCARD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LINK93_WILDCARD.PI_0055 Index Columns |
ColumnName | Sort Order |
UDT09_ID_S | |
UDT03_ID |
LINK93_WILDCARD.RI_F00069 |
Entity Name | LINK93_WILDCARD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
LINK93_WILDCARD.RI_F00069 Index Columns |
ColumnName | Sort Order |
UDT03_ID |
LOCATION.PI_0301 |
Entity Name | LOCATION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
LOCATION.PI_0301 Index Columns |
ColumnName | Sort Order |
LOCATION_ID |
MEAL_INCIDENTAL_BREAKDOWN.PI_0161 |
Entity Name | MEAL_INCIDENTAL_BREAKDOWN |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
MEAL_INCIDENTAL_BREAKDOWN.PI_0161 Index Columns |
ColumnName | Sort Order |
EFFECTIVE_DT | |
S_SOURCE_CD | |
MEAL_INCIDENTAL_AMT |
MENU.PI_0300 |
Entity Name | MENU |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
MENU.PI_0300 Index Columns |
ColumnName | Sort Order |
MENU_CD |
PAY_METHOD.PI_0157 |
Entity Name | PAY_METHOD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
PAY_METHOD.PI_0157 Index Columns |
ColumnName | Sort Order |
PAY_METHOD_CD |
PER_DIEM.PI_0159 |
Entity Name | PER_DIEM |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
PER_DIEM.PI_0159 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD |
PER_DIEM_EDIT.RI_F00414 |
Entity Name | PER_DIEM_EDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_EDIT.RI_F00414 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD |
PER_DIEM_EDIT.PI_0281 |
Entity Name | PER_DIEM_EDIT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
PER_DIEM_EDIT.PI_0281 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
COUNTRY_NAME | |
STATE_NAME | |
CITY_NAME | |
COUNTY_NAME | |
EFFECTIVE_DT | |
SEASON_START_DATE | |
SEASON_END_DATE | |
S_SOURCE_CD |
PER_DIEM_MASTER.SI_0067 |
Entity Name | PER_DIEM_MASTER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_MASTER.SI_0067 Index Columns |
ColumnName | Sort Order |
S_SOURCE_CD | |
MEAL_INCIDENTAL_AMT |
PER_DIEM_MASTER.PI_0191 |
Entity Name | PER_DIEM_MASTER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
PER_DIEM_MASTER.PI_0191 Index Columns |
ColumnName | Sort Order |
COUNTRY_NAME | |
STATE_NAME | |
CITY_NAME | |
COUNTY_NAME | |
EFFECTIVE_DT | |
SEASON_START_DATE | |
SEASON_END_DATE | |
S_SOURCE_CD |
PER_DIEM_SCHEDULE.RI_F00165 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.RI_F00165 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD |
PER_DIEM_SCHEDULE.SI_0094 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0094 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
OVERRIDE_COUNTRY_NAME | |
OVERRIDE_STATE_NAME | |
OVERRIDE_CITY_NAME | |
OVERRIDE_COUNTY_NAME | |
EFFECTIVE_DT | |
SEASON_START_DATE | |
SEASON_END_DATE | |
S_SCHEDULE_SOURCE_CD |
PER_DIEM_SCHEDULE.SI_0093 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0093 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
OVERRIDE_COUNTY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0092 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0092 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
OVERRIDE_CITY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0091 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0091 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
OVERRIDE_STATE_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0090 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0090 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
OVERRIDE_COUNTRY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0089 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0089 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
OVERRIDE_COUNTRY_NAME | |
OVERRIDE_CITY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0088 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0088 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
OVERRIDE_COUNTRY_NAME | |
OVERRIDE_STATE_NAME | |
OVERRIDE_CITY_NAME | |
OVERRIDE_COUNTY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0087 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0087 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
COUNTY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0086 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0086 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
CITY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0085 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0085 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
STATE_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0084 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0084 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
COUNTRY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0083 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0083 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
COUNTRY_NAME | |
STATE_NAME | |
CITY_NAME | |
COUNTY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0082 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0082 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
COUNTRY_NAME | |
CITY_NAME | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0081 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0081 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
TERMINATE_DT |
PER_DIEM_SCHEDULE.SI_0080 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0080 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
EFFECTIVE_DT |
PER_DIEM_SCHEDULE.SI_0066 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PER_DIEM_SCHEDULE.SI_0066 Index Columns |
ColumnName | Sort Order |
S_MEALS_SOURCE_CD | |
MEAL_INCIDENTAL_AMT |
PER_DIEM_SCHEDULE.PI_0160 |
Entity Name | PER_DIEM_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
PER_DIEM_SCHEDULE.PI_0160 Index Columns |
ColumnName | Sort Order |
PER_DIEM_SCHEDULE_CD | |
COUNTRY_NAME | |
STATE_NAME | |
CITY_NAME | |
COUNTY_NAME | |
EFFECTIVE_DT | |
SEASON_START_DATE | |
SEASON_END_DATE | |
S_SCHEDULE_SOURCE_CD |
PROVIDER.PI_0148 |
Entity Name | PROVIDER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
PROVIDER.PI_0148 Index Columns |
ColumnName | Sort Order |
PROVIDER_CD |
PROVIDER_VISA_SUPPLIER.RI_F00409 |
Entity Name | PROVIDER_VISA_SUPPLIER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PROVIDER_VISA_SUPPLIER.RI_F00409 Index Columns |
ColumnName | Sort Order |
PROVIDER_CD |
PROVIDER_VISA_SUPPLIER.SI_0076 |
Entity Name | PROVIDER_VISA_SUPPLIER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
PROVIDER_VISA_SUPPLIER.SI_0076 Index Columns |
ColumnName | Sort Order |
VISA_SUPPLIER_NAME |
PROVIDER_VISA_SUPPLIER.PI_0278 |
Entity Name | PROVIDER_VISA_SUPPLIER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
PROVIDER_VISA_SUPPLIER.PI_0278 Index Columns |
ColumnName | Sort Order |
PROVIDER_CD | |
VISA_SUPPLIER_NAME |
RECURRENCE.PI_0234 |
Entity Name | RECURRENCE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
RECURRENCE.PI_0234 Index Columns |
ColumnName | Sort Order |
RECURRENCE_CD |
ROLE.PI_0024 |
Entity Name | ROLE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
ROLE.PI_0024 Index Columns |
ColumnName | Sort Order |
ROLE_CD |
ROLE.SI_0005 |
Entity Name | ROLE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
ROLE.SI_0005 Index Columns |
ColumnName | Sort Order |
ROLE_NAME |
ROLE_SCREEN.PI_0026 |
Entity Name | ROLE_SCREEN |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
ROLE_SCREEN.PI_0026 Index Columns |
ColumnName | Sort Order |
ROLE_CD | |
SCREEN_CD |
ROLE_SCREEN.RI_F00013 |
Entity Name | ROLE_SCREEN |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ROLE_SCREEN.RI_F00013 Index Columns |
ColumnName | Sort Order |
SCREEN_CD |
ROLE_SCREEN.RI_F00012 |
Entity Name | ROLE_SCREEN |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
ROLE_SCREEN.RI_F00012 Index Columns |
ColumnName | Sort Order |
ROLE_CD |
SCHEDULED_PROCESS.RI_F00331 |
Entity Name | SCHEDULED_PROCESS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
SCHEDULED_PROCESS.RI_F00331 Index Columns |
ColumnName | Sort Order |
SCREEN_CD | |
PARAMETER_CD |
SCHEDULED_PROCESS.RI_F00334 |
Entity Name | SCHEDULED_PROCESS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
SCHEDULED_PROCESS.RI_F00334 Index Columns |
ColumnName | Sort Order |
EXECUTE_EMPL_ID |
SCHEDULED_PROCESS.RI_F00333 |
Entity Name | SCHEDULED_PROCESS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
SCHEDULED_PROCESS.RI_F00333 Index Columns |
ColumnName | Sort Order |
EMAIL_EMPL_ID |
SCHEDULED_PROCESS.RI_F00330 |
Entity Name | SCHEDULED_PROCESS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
SCHEDULED_PROCESS.RI_F00330 Index Columns |
ColumnName | Sort Order |
RECURRENCE_CD |
SCHEDULED_PROCESS.PI_0236 |
Entity Name | SCHEDULED_PROCESS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
SCHEDULED_PROCESS.PI_0236 Index Columns |
ColumnName | Sort Order |
SCREEN_CD | |
PARAMETER_CD | |
RECURRENCE_CD | |
PROCESS_START_HRS | |
PROCESS_START_MINS | |
S_PROCESS_START_CD | |
EXECUTE_EMPL_ID |
SCHEDULED_PROCESS_HISTORY.RI_F00335 |
Entity Name | SCHEDULED_PROCESS_HISTORY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
SCHEDULED_PROCESS_HISTORY.RI_F00335 Index Columns |
ColumnName | Sort Order |
SCREEN_CD | |
PARAMETER_CD | |
RECURRENCE_CD | |
PROCESS_START_HRS | |
PROCESS_START_MINS | |
S_PROCESS_START_CD | |
EXECUTE_EMPL_ID |
SCHEDULED_PROCESS_HISTORY.PI_0237 |
Entity Name | SCHEDULED_PROCESS_HISTORY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
SCHEDULED_PROCESS_HISTORY.PI_0237 Index Columns |
ColumnName | Sort Order |
SCREEN_CD | |
PARAMETER_CD | |
RECURRENCE_CD | |
PROCESS_START_HRS | |
PROCESS_START_MINS | |
S_PROCESS_START_CD | |
EXECUTE_EMPL_ID | |
LAST_RUN_DTT |
SCREEN_PARAMETER.RI_F00329 |
Entity Name | SCREEN_PARAMETER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
SCREEN_PARAMETER.RI_F00329 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
SCREEN_PARAMETER.PI_0235 |
Entity Name | SCREEN_PARAMETER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
SCREEN_PARAMETER.PI_0235 Index Columns |
ColumnName | Sort Order |
SCREEN_CD | |
PARAMETER_CD |
SCREEN_PARAMETER.RI_F00328 |
Entity Name | SCREEN_PARAMETER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
SCREEN_PARAMETER.RI_F00328 Index Columns |
ColumnName | Sort Order |
SCREEN_CD |
SCREENS.RI_F00064 |
Entity Name | SCREENS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
SCREENS.RI_F00064 Index Columns |
ColumnName | Sort Order |
PARENT_SCREEN_CD |
SCREENS.PI_0025 |
Entity Name | SCREENS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
SCREENS.PI_0025 Index Columns |
ColumnName | Sort Order |
SCREEN_CD |
TASK.PI_O239 |
Entity Name | TASK |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TASK.PI_O239 Index Columns |
ColumnName | Sort Order |
TASK_ID |
TASK.SI_0111 |
Entity Name | TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TASK.SI_0111 Index Columns |
ColumnName | Sort Order |
TASK_EMPL_ID |
TASK.SI_0110 |
Entity Name | TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TASK.SI_0110 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_CD |
TASK.SI_0109 |
Entity Name | TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TASK.SI_0109 Index Columns |
ColumnName | Sort Order |
BACKUP_FUNCTIONAL_ROLE_CD |
TASK.SI_0108 |
Entity Name | TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TASK.SI_0108 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
TASK.SI_0107 |
Entity Name | TASK |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TASK.SI_0107 Index Columns |
ColumnName | Sort Order |
ATTACHMENT_ID |
TASK_EMPL.PI_O241 |
Entity Name | TASK_EMPL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TASK_EMPL.PI_O241 Index Columns |
ColumnName | Sort Order |
TASK_ID | |
EMPL_ID | |
FUNCTIONAL_ROLE_CD |
TASK_EMPL.SI_0118 |
Entity Name | TASK_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TASK_EMPL.SI_0118 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
TASK_EMPL.SI_0117 |
Entity Name | TASK_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TASK_EMPL.SI_0117 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
TASK_EMPL.SI_0116 |
Entity Name | TASK_EMPL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TASK_EMPL.SI_0116 Index Columns |
ColumnName | Sort Order |
TASK_ID |
TAX_SCHEDULE.PI_0210 |
Entity Name | TAX_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TAX_SCHEDULE.PI_0210 Index Columns |
ColumnName | Sort Order |
TAX_SCHEDULE_CD |
TAX_SCHEDULE_LABELS.RI_F00270 |
Entity Name | TAX_SCHEDULE_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TAX_SCHEDULE_LABELS.RI_F00270 Index Columns |
ColumnName | Sort Order |
TAX_SCHEDULE_CD |
TAX_SCHEDULE_LABELS.RI_F00269 |
Entity Name | TAX_SCHEDULE_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TAX_SCHEDULE_LABELS.RI_F00269 Index Columns |
ColumnName | Sort Order |
COUNTRY_CD | |
LANGUAGE_CD |
TAX_SCHEDULE_LABELS.PI_0211 |
Entity Name | TAX_SCHEDULE_LABELS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TAX_SCHEDULE_LABELS.PI_0211 Index Columns |
ColumnName | Sort Order |
TAX_SCHEDULE_CD | |
COUNTRY_CD | |
LANGUAGE_CD |
TAX_SCHEDULE_RATE.RI_F00271 |
Entity Name | TAX_SCHEDULE_RATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TAX_SCHEDULE_RATE.RI_F00271 Index Columns |
ColumnName | Sort Order |
TAX_SCHEDULE_CD |
TAX_SCHEDULE_RATE.PI_0212 |
Entity Name | TAX_SCHEDULE_RATE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TAX_SCHEDULE_RATE.PI_0212 Index Columns |
ColumnName | Sort Order |
TAX_SCHEDULE_CD | |
EFFECTIVE_DT | |
EXP_TYPE_CD | |
TAX_LOCATION_S |
TIME_CONFIG.RI_F00128 |
Entity Name | TIME_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TIME_CONFIG.RI_F00128 Index Columns |
ColumnName | Sort Order |
DFLT_CLASS_CD |
TIME_CONFIG.RI_F00127 |
Entity Name | TIME_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TIME_CONFIG.RI_F00127 Index Columns |
ColumnName | Sort Order |
DFLT_WORK_SCHEDULE_CD |
TIME_CONFIG.RI_F00126 |
Entity Name | TIME_CONFIG |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TIME_CONFIG.RI_F00126 Index Columns |
ColumnName | Sort Order |
DFLT_TS_SCHEDULE_CD |
TIME_CONFIG.PI_0140 |
Entity Name | TIME_CONFIG |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TIME_CONFIG.PI_0140 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
TIME_CONFIG_LABELS.RI_F00130 |
Entity Name | TIME_CONFIG_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TIME_CONFIG_LABELS.RI_F00130 Index Columns |
ColumnName | Sort Order |
LANGUAGE_CD | |
COUNTRY_CD |
TIME_CONFIG_LABELS.PI_0141 |
Entity Name | TIME_CONFIG_LABELS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TIME_CONFIG_LABELS.PI_0141 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
COUNTRY_CD | |
LANGUAGE_CD |
TIME_CONFIG_LABELS.RI_F00129 |
Entity Name | TIME_CONFIG_LABELS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TIME_CONFIG_LABELS.RI_F00129 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
TIME_CONFIG_UDT.RI_F00131 |
Entity Name | TIME_CONFIG_UDT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TIME_CONFIG_UDT.RI_F00131 Index Columns |
ColumnName | Sort Order |
COMPANY_ID |
TIME_CONFIG_UDT.PI_0142 |
Entity Name | TIME_CONFIG_UDT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TIME_CONFIG_UDT.PI_0142 Index Columns |
ColumnName | Sort Order |
COMPANY_ID | |
S_UDT_CD |
TIME_ZONE.PI_0209 |
Entity Name | TIME_ZONE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TIME_ZONE.PI_0209 Index Columns |
ColumnName | Sort Order |
TIME_ZONE_CD |
TOOLKIT.PI_0284 |
Entity Name | TOOLKIT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TOOLKIT.PI_0284 Index Columns |
ColumnName | Sort Order |
TOOLKIT_ID |
TS.RI_F00039 |
Entity Name | TS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS.RI_F00039 Index Columns |
ColumnName | Sort Order |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS.RI_F00038 |
Entity Name | TS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS.RI_F00038 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
TS.SI_0079 |
Entity Name | TS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
TS.SI_0079 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
S_STATUS_CD |
TS.SI_0039 |
Entity Name | TS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS.SI_0039 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS.RI_F00141 |
Entity Name | TS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS.RI_F00141 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
TS.PI_0039 |
Entity Name | TS |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS.PI_0039 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS.RI_F00041 |
Entity Name | TS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS.RI_F00041 Index Columns |
ColumnName | Sort Order |
WORK_SCHEDULE_CD |
TS.RI_F00040 |
Entity Name | TS |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS.RI_F00040 Index Columns |
ColumnName | Sort Order |
CLASS_CD |
TS_AUDIT.RI_F00049 |
Entity Name | TS_AUDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_AUDIT.RI_F00049 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
TS_AUDIT.RI_F00048 |
Entity Name | TS_AUDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_AUDIT.RI_F00048 Index Columns |
ColumnName | Sort Order |
REVISION_EMPL_ID |
TS_AUDIT.RI_F00047 |
Entity Name | TS_AUDIT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_AUDIT.RI_F00047 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
REVISION_NO |
TS_AUDIT.PI_0043 |
Entity Name | TS_AUDIT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_AUDIT.PI_0043 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
REVISION_NO | |
REVISION_SUB_NO |
TS_CELL.SI_0077 |
Entity Name | TS_CELL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_CELL.SI_0077 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
S_CELL_STATUS_CD |
TS_CELL.SI_0075 |
Entity Name | TS_CELL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_CELL.SI_0075 Index Columns |
ColumnName | Sort Order |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
HRS_DT |
TS_CELL.SI_0042 |
Entity Name | TS_CELL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_CELL.SI_0042 Index Columns |
ColumnName | Sort Order |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
S_CELL_STATUS_CD | |
BATCH_ID |
TS_CELL.SI_0040 |
Entity Name | TS_CELL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_CELL.SI_0040 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO |
TS_CELL.PI_0042 |
Entity Name | TS_CELL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_CELL.PI_0042 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
TS_CELL.SI_0050 |
Entity Name | TS_CELL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_CELL.SI_0050 Index Columns |
ColumnName | Sort Order |
HRS_DT | |
EMPL_ID | |
ENTERED_HRS |
TS_CELL.RI_F00046 |
Entity Name | TS_CELL |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_CELL.RI_F00046 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO |
TS_DAY.RI_F00100 |
Entity Name | TS_DAY |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_DAY.RI_F00100 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS_DAY.PI_0127 |
Entity Name | TS_DAY |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_DAY.PI_0127 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
COLUMN_DT |
TS_EXPORT_ADJUSTMENT.RI_F00304 |
Entity Name | TS_EXPORT_ADJUSTMENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_EXPORT_ADJUSTMENT.RI_F00304 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS_EXPORT_ADJUSTMENT.RI_F00303 |
Entity Name | TS_EXPORT_ADJUSTMENT |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_EXPORT_ADJUSTMENT.RI_F00303 Index Columns |
ColumnName | Sort Order |
EMPL_ID |
TS_EXPORT_ADJUSTMENT.PI_0226 |
Entity Name | TS_EXPORT_ADJUSTMENT |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_EXPORT_ADJUSTMENT.PI_0226 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
TS_INVOICE.RI_F00101 |
Entity Name | TS_INVOICE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_INVOICE.RI_F00101 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS_INVOICE.PI_0128 |
Entity Name | TS_INVOICE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_INVOICE.PI_0128 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
INVOICE_NO_CD | |
INVOICE_UDT_ID |
TS_LINE.RI_F00103 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_F00103 Index Columns |
ColumnName | Sort Order |
APPROVE_REJECT_EMPL_ID |
TS_LINE.PI_0041 |
Entity Name | TS_LINE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_LINE.PI_0041 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO |
TS_LINE.RI_F00415 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_F00415 Index Columns |
ColumnName | Sort Order |
CHARGE_TREE_CD | |
CHARGE_BRANCH_CD | |
CHARGE_CD |
TS_LINE.RI_F00066 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_F00066 Index Columns |
ColumnName | Sort Order |
UDT10_ID |
TS_LINE.RI_F00065 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_F00065 Index Columns |
ColumnName | Sort Order |
UDT01_ID |
TS_LINE.RI_F00045 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_F00045 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS_LINE.RI_LF_0026 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_LF_0026 Index Columns |
ColumnName | Sort Order |
UDT09_ID |
TS_LINE.RI_LF_0023 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_LF_0023 Index Columns |
ColumnName | Sort Order |
UDT08_ID |
TS_LINE.RI_LF_0020 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_LF_0020 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
UDT07_CP_COMPANY_CD |
TS_LINE.RI_LF_0017 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_LF_0017 Index Columns |
ColumnName | Sort Order |
UDT06_ID | |
UDT06_CP_COMPANY_CD |
TS_LINE.RI_LF_0014 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_LF_0014 Index Columns |
ColumnName | Sort Order |
UDT05_ID |
TS_LINE.RI_LF_0011 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_LF_0011 Index Columns |
ColumnName | Sort Order |
UDT04_ID |
TS_LINE.RI_LF_0008 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_LF_0008 Index Columns |
ColumnName | Sort Order |
UDT03_ID |
TS_LINE.RI_LF_0005 |
Entity Name | TS_LINE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_LINE.RI_LF_0005 Index Columns |
ColumnName | Sort Order |
UDT02_ID |
TS_REVISION.RI_F00042 |
Entity Name | TS_REVISION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_REVISION.RI_F00042 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS_REVISION.RI_F00044 |
Entity Name | TS_REVISION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_REVISION.RI_F00044 Index Columns |
ColumnName | Sort Order |
APPROVE_EMPL_ID |
TS_REVISION.RI_F00043 |
Entity Name | TS_REVISION |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_REVISION.RI_F00043 Index Columns |
ColumnName | Sort Order |
SIGN_EMPL_ID |
TS_REVISION.PI_0040 |
Entity Name | TS_REVISION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_REVISION.PI_0040 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
REVISION_NO |
TS_SCHEDULE.SI_0002 |
Entity Name | TS_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
TS_SCHEDULE.SI_0002 Index Columns |
ColumnName | Sort Order |
TS_SCHEDULE_DESC |
TS_SCHEDULE.PI_0020 |
Entity Name | TS_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_SCHEDULE.PI_0020 Index Columns |
ColumnName | Sort Order |
TS_SCHEDULE_CD |
TS_SCHEDULE_PERIOD.RI_F00010 |
Entity Name | TS_SCHEDULE_PERIOD |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_SCHEDULE_PERIOD.RI_F00010 Index Columns |
ColumnName | Sort Order |
TS_SCHEDULE_CD |
TS_SCHEDULE_PERIOD.PI_0021 |
Entity Name | TS_SCHEDULE_PERIOD |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_SCHEDULE_PERIOD.PI_0021 Index Columns |
ColumnName | Sort Order |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS_START_STOP.RI_F00404 |
Entity Name | TS_START_STOP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_START_STOP.RI_F00404 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD |
TS_START_STOP.RI_F00405 |
Entity Name | TS_START_STOP |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
TS_START_STOP.RI_F00405 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
COLUMN_DT |
TS_START_STOP.PI_0271 |
Entity Name | TS_START_STOP |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
TS_START_STOP.PI_0271 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
COLUMN_DT | |
SEQ_NO |
UDT01.RI_F00402 |
Entity Name | UDT01 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT01.RI_F00402 Index Columns |
ColumnName | Sort Order |
INTERIM_EMPL_ID |
UDT01.SI_0069 |
Entity Name | UDT01 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT01.SI_0069 Index Columns |
ColumnName | Sort Order |
UDT01_ID | |
UDT01_NAME | |
ACTIVE_FL | |
ALLOW_CHARGE_FL | |
UDT01_ABBRV_ID |
UDT01.PI_0003 |
Entity Name | UDT01 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT01.PI_0003 Index Columns |
ColumnName | Sort Order |
UDT01_ID |
UDT01.RI_F00002 |
Entity Name | UDT01 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT01.RI_F00002 Index Columns |
ColumnName | Sort Order |
UDT01_TYPE_CD |
UDT01_SPVSR.RI_F00106 |
Entity Name | UDT01_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT01_SPVSR.RI_F00106 Index Columns |
ColumnName | Sort Order |
UDT01_ID |
UDT01_SPVSR.PI_0130 |
Entity Name | UDT01_SPVSR |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT01_SPVSR.PI_0130 Index Columns |
ColumnName | Sort Order |
UDT01_ID | |
SPVSR_EMPL_ID | |
FUNCTIONAL_ROLE_CD |
UDT01_SPVSR.RI_F00108 |
Entity Name | UDT01_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT01_SPVSR.RI_F00108 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
UDT01_SPVSR.RI_F00107 |
Entity Name | UDT01_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT01_SPVSR.RI_F00107 Index Columns |
ColumnName | Sort Order |
SPVSR_EMPL_ID |
UDT01_TYPE.SI_0004 |
Entity Name | UDT01_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
UDT01_TYPE.SI_0004 Index Columns |
ColumnName | Sort Order |
UDT01_TYPE_DESC |
UDT01_TYPE.PI_0002 |
Entity Name | UDT01_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT01_TYPE.PI_0002 Index Columns |
ColumnName | Sort Order |
UDT01_TYPE_CD |
UDT01_TYPE.RI_F00001 |
Entity Name | UDT01_TYPE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT01_TYPE.RI_F00001 Index Columns |
ColumnName | Sort Order |
DFLT_UTIL_CD |
UDT02.RI_F00403 |
Entity Name | UDT02 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT02.RI_F00403 Index Columns |
ColumnName | Sort Order |
INTERIM_EMPL_ID |
UDT02.SI_0070 |
Entity Name | UDT02 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT02.SI_0070 Index Columns |
ColumnName | Sort Order |
UDT02_ID | |
UDT02_NAME | |
ACTIVE_FL | |
ALLOW_CHARGE_FL | |
UDT02_ABBRV_ID |
UDT02.PI_0004 |
Entity Name | UDT02 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT02.PI_0004 Index Columns |
ColumnName | Sort Order |
UDT02_ID |
UDT02.RI_F00134 |
Entity Name | UDT02 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT02.RI_F00134 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
UDT02_SPVSR.RI_F00109 |
Entity Name | UDT02_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT02_SPVSR.RI_F00109 Index Columns |
ColumnName | Sort Order |
UDT02_ID |
UDT02_SPVSR.PI_0131 |
Entity Name | UDT02_SPVSR |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT02_SPVSR.PI_0131 Index Columns |
ColumnName | Sort Order |
UDT02_ID | |
SPVSR_EMPL_ID | |
FUNCTIONAL_ROLE_CD |
UDT02_SPVSR.RI_F00111 |
Entity Name | UDT02_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT02_SPVSR.RI_F00111 Index Columns |
ColumnName | Sort Order |
FUNCTIONAL_ROLE_CD |
UDT02_SPVSR.RI_F00110 |
Entity Name | UDT02_SPVSR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT02_SPVSR.RI_F00110 Index Columns |
ColumnName | Sort Order |
SPVSR_EMPL_ID |
UDT03.PI_0005 |
Entity Name | UDT03 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT03.PI_0005 Index Columns |
ColumnName | Sort Order |
UDT03_ID |
UDT04.PI_0006 |
Entity Name | UDT04 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT04.PI_0006 Index Columns |
ColumnName | Sort Order |
UDT04_ID |
UDT04.RI_F00135 |
Entity Name | UDT04 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT04.RI_F00135 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
UDT05.PI_0007 |
Entity Name | UDT05 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT05.PI_0007 Index Columns |
ColumnName | Sort Order |
UDT05_ID |
UDT05.RI_F00136 |
Entity Name | UDT05 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT05.RI_F00136 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
UDT06.PI_0008 |
Entity Name | UDT06 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT06.PI_0008 Index Columns |
ColumnName | Sort Order |
UDT06_ID | |
CP_COMPANY_CD |
UDT06.RI_F00137 |
Entity Name | UDT06 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT06.RI_F00137 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
UDT07.PI_0009 |
Entity Name | UDT07 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT07.PI_0009 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
CP_COMPANY_CD |
UDT07.RI_F00138 |
Entity Name | UDT07 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT07.RI_F00138 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
UDT08.PI_0010 |
Entity Name | UDT08 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT08.PI_0010 Index Columns |
ColumnName | Sort Order |
UDT08_ID |
UDT09.RI_F00139 |
Entity Name | UDT09 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT09.RI_F00139 Index Columns |
ColumnName | Sort Order |
CP_COMPANY_CD |
UDT09.PI_0011 |
Entity Name | UDT09 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT09.PI_0011 Index Columns |
ColumnName | Sort Order |
UDT09_ID |
UDT10.RI_F00003 |
Entity Name | UDT10 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT10.RI_F00003 Index Columns |
ColumnName | Sort Order |
OT_UDT10_ID |
UDT10.RI_F00148 |
Entity Name | UDT10 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT10.RI_F00148 Index Columns |
ColumnName | Sort Order |
RECAST_PAYROLL_UDT10_ID |
UDT10.RI_F00147 |
Entity Name | UDT10 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
UDT10.RI_F00147 Index Columns |
ColumnName | Sort Order |
RECAST_LABOR_UDT10_ID |
UDT10.PI_0012 |
Entity Name | UDT10 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT10.PI_0012 Index Columns |
ColumnName | Sort Order |
UDT10_ID |
UDT11.PI_0262 |
Entity Name | UDT11 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT11.PI_0262 Index Columns |
ColumnName | Sort Order |
UDT11_ID |
UDT12.PI_0263 |
Entity Name | UDT12 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT12.PI_0263 Index Columns |
ColumnName | Sort Order |
UDT12_ID |
UDT13.PI_0264 |
Entity Name | UDT13 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT13.PI_0264 Index Columns |
ColumnName | Sort Order |
UDT13_ID |
UDT14.PI_0265 |
Entity Name | UDT14 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT14.PI_0265 Index Columns |
ColumnName | Sort Order |
UDT14_ID |
UDT15.PI_0266 |
Entity Name | UDT15 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UDT15.PI_0266 Index Columns |
ColumnName | Sort Order |
UDT15_ID |
UNSENT_EMAIL.PI_0126 |
Entity Name | UNSENT_EMAIL |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UNSENT_EMAIL.PI_0126 Index Columns |
ColumnName | Sort Order |
RECIPIENT_ADDRESS_S | |
SENDER_ADDRESS_S | |
SENT_DTT |
UTILIZATION.PI_0001 |
Entity Name | UTILIZATION |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
UTILIZATION.PI_0001 Index Columns |
ColumnName | Sort Order |
UTIL_CD |
VISA_TRANS_TYPE.PI_0277 |
Entity Name | VISA_TRANS_TYPE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
VISA_TRANS_TYPE.PI_0277 Index Columns |
ColumnName | Sort Order |
VISA_TRANS_TYPE_CD |
WAGE_SCHEDULE.RI_F00145 |
Entity Name | WAGE_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
WAGE_SCHEDULE.RI_F00145 Index Columns |
ColumnName | Sort Order |
UDT03_ID |
WAGE_SCHEDULE.RI_F00144 |
Entity Name | WAGE_SCHEDULE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
WAGE_SCHEDULE.RI_F00144 Index Columns |
ColumnName | Sort Order |
UDT05_ID |
WAGE_SCHEDULE.PI_0143 |
Entity Name | WAGE_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
WAGE_SCHEDULE.PI_0143 Index Columns |
ColumnName | Sort Order |
EFFECTIVE_DT | |
UDT05_ID | |
UDT03_ID | |
UDT01_ID_S |
WAGE_SCHEDULE_RATE.RI_F00146 |
Entity Name | WAGE_SCHEDULE_RATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
WAGE_SCHEDULE_RATE.RI_F00146 Index Columns |
ColumnName | Sort Order |
EFFECTIVE_DT | |
UDT05_ID | |
UDT03_ID | |
UDT01_ID_S |
WAGE_SCHEDULE_RATE.RI_F00180 |
Entity Name | WAGE_SCHEDULE_RATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
WAGE_SCHEDULE_RATE.RI_F00180 Index Columns |
ColumnName | Sort Order |
UDT07_ID | |
UDT07_CP_COMPANY_CD |
WAGE_SCHEDULE_RATE.RI_LF_0198 |
Entity Name | WAGE_SCHEDULE_RATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
WAGE_SCHEDULE_RATE.RI_LF_0198 Index Columns |
ColumnName | Sort Order |
UDT06_ID | |
UDT06_CP_COMPANY_CD |
WAGE_SCHEDULE_RATE.PI_0144 |
Entity Name | WAGE_SCHEDULE_RATE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
WAGE_SCHEDULE_RATE.PI_0144 Index Columns |
ColumnName | Sort Order |
EFFECTIVE_DT | |
UDT05_ID | |
UDT03_ID | |
UDT01_ID_S | |
UDT07_ID | |
UDT07_CP_COMPANY_CD | |
UDT06_ID | |
UDT06_CP_COMPANY_CD |
WORK_SCHEDULE.SI_0001 |
Entity Name | WORK_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
WORK_SCHEDULE.SI_0001 Index Columns |
ColumnName | Sort Order |
WORK_SCHEDULE_DESC |
WORK_SCHEDULE.PI_0022 |
Entity Name | WORK_SCHEDULE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
WORK_SCHEDULE.PI_0022 Index Columns |
ColumnName | Sort Order |
WORK_SCHEDULE_CD |
WORK_SCHEDULE_DATE.SI_0044 |
Entity Name | WORK_SCHEDULE_DATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
WORK_SCHEDULE_DATE.SI_0044 Index Columns |
ColumnName | Sort Order |
WORK_SCHEDULE_CD | |
SCHEDULE_DT | |
EMPL_ID |
WORK_SCHEDULE_DATE.RI_F00011 |
Entity Name | WORK_SCHEDULE_DATE |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
WORK_SCHEDULE_DATE.RI_F00011 Index Columns |
ColumnName | Sort Order |
WORK_SCHEDULE_CD |
WORK_SCHEDULE_DATE.PI_0023 |
Entity Name | WORK_SCHEDULE_DATE |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
WORK_SCHEDULE_DATE.PI_0023 Index Columns |
ColumnName | Sort Order |
WORK_SCHEDULE_CD | |
S_DAY_OF_WEEK_CD | |
SCHEDULE_DT | |
EMPL_ID |
Z_ADV_EXPORT01.SI_0133 |
Entity Name | Z_ADV_EXPORT01 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT01.SI_0133 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT02.SI_0134 |
Entity Name | Z_ADV_EXPORT02 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT02.SI_0134 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT03.SI_0135 |
Entity Name | Z_ADV_EXPORT03 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT03.SI_0135 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT04.SI_0136 |
Entity Name | Z_ADV_EXPORT04 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT04.SI_0136 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT05.SI_0137 |
Entity Name | Z_ADV_EXPORT05 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT05.SI_0137 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT06.SI_0138 |
Entity Name | Z_ADV_EXPORT06 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT06.SI_0138 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT07.SI_0139 |
Entity Name | Z_ADV_EXPORT07 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT07.SI_0139 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT08.SI_0140 |
Entity Name | Z_ADV_EXPORT08 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT08.SI_0140 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT09.SI_0141 |
Entity Name | Z_ADV_EXPORT09 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT09.SI_0141 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_ADV_EXPORT10.SI_0142 |
Entity Name | Z_ADV_EXPORT10 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_ADV_EXPORT10.SI_0142 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
ADVANCE_ID |
Z_COMMIT_EXPORT01.SI_0144 |
Entity Name | Z_COMMIT_EXPORT01 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT01.SI_0144 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT02.SI_0145 |
Entity Name | Z_COMMIT_EXPORT02 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT02.SI_0145 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT03.SI_0146 |
Entity Name | Z_COMMIT_EXPORT03 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT03.SI_0146 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT04.SI_0147 |
Entity Name | Z_COMMIT_EXPORT04 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT04.SI_0147 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT05.SI_0148 |
Entity Name | Z_COMMIT_EXPORT05 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT05.SI_0148 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT06.SI_0149 |
Entity Name | Z_COMMIT_EXPORT06 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT06.SI_0149 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT07.SI_0150 |
Entity Name | Z_COMMIT_EXPORT07 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT07.SI_0150 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT08.SI_0151 |
Entity Name | Z_COMMIT_EXPORT08 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT08.SI_0151 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT09.SI_0152 |
Entity Name | Z_COMMIT_EXPORT09 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT09.SI_0152 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_COMMIT_EXPORT10.SI_0153 |
Entity Name | Z_COMMIT_EXPORT10 |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_COMMIT_EXPORT10.SI_0153 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_ID | |
EXPENSE_ID |
Z_EXP_EXPORT01.PI_0198 |
Entity Name | Z_EXP_EXPORT01 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT01.PI_0198 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT02.PI_0199 |
Entity Name | Z_EXP_EXPORT02 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT02.PI_0199 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT03.PI_0200 |
Entity Name | Z_EXP_EXPORT03 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT03.PI_0200 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT04.PI_0201 |
Entity Name | Z_EXP_EXPORT04 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT04.PI_0201 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT05.PI_0202 |
Entity Name | Z_EXP_EXPORT05 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT05.PI_0202 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT06.PI_0203 |
Entity Name | Z_EXP_EXPORT06 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT06.PI_0203 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT07.PI_0204 |
Entity Name | Z_EXP_EXPORT07 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT07.PI_0204 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT08.PI_0205 |
Entity Name | Z_EXP_EXPORT08 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT08.PI_0205 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT09.PI_0206 |
Entity Name | Z_EXP_EXPORT09 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT09.PI_0206 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXP_EXPORT10.PI_0207 |
Entity Name | Z_EXP_EXPORT10 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXP_EXPORT10.PI_0207 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
EXP_RPT_ID | |
PARENT_EXPENSE_ID | |
EXPENSE_ID | |
ALLOCATION_ID | |
S_TYPE_CD | |
S_CHARGE_TYPE_CD | |
CORRECTION_NO |
Z_EXPORT01.PI_0094 |
Entity Name | Z_EXPORT01 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT01.PI_0094 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT02.PI_0095 |
Entity Name | Z_EXPORT02 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT02.PI_0095 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT03.PI_0096 |
Entity Name | Z_EXPORT03 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT03.PI_0096 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT04.PI_0097 |
Entity Name | Z_EXPORT04 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT04.PI_0097 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT05.PI_0098 |
Entity Name | Z_EXPORT05 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT05.PI_0098 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT06.PI_0099 |
Entity Name | Z_EXPORT06 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT06.PI_0099 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT07.PI_0100 |
Entity Name | Z_EXPORT07 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT07.PI_0100 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT08.PI_0101 |
Entity Name | Z_EXPORT08 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT08.PI_0101 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT09.PI_0102 |
Entity Name | Z_EXPORT09 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT09.PI_0102 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT10.PI_0103 |
Entity Name | Z_EXPORT10 |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT10.PI_0103 Index Columns |
ColumnName | Sort Order |
BATCH_ID | |
TIMESHEET_DT | |
EMPL_ID | |
TS_SCHEDULE_CD | |
YEAR_NO_CD | |
PERIOD_NO_CD | |
LINE_NO | |
HRS_DT |
Z_EXPORT_USER.PI_0104 |
Entity Name | Z_EXPORT_USER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | PrimaryKey |
Z_EXPORT_USER.PI_0104 Index Columns |
ColumnName | Sort Order |
EMPL_ID | |
BATCH_ID | |
S_TYPE_CD |
Z_EXPORT_USER.SI_0078 |
Entity Name | Z_EXPORT_USER |
Unique | YES |
Clustered Option | NON-CLUSTERED |
Key Type | Alternate Key |
Z_EXPORT_USER.SI_0078 Index Columns |
ColumnName | Sort Order |
WORK_TABLE_NO | |
S_TYPE_CD |
Z_EXPORT_USER.SI_0041 |
Entity Name | Z_EXPORT_USER |
Unique | NO |
Clustered Option | NON-CLUSTERED |
Key Type | Inversion Entry |
Z_EXPORT_USER.SI_0041 Index Columns |
ColumnName | Sort Order |
BATCH_ID |