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