PAY_CODE |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| pay_code_key | decimal (15,0) | |||
| pay_code | varchar (10) | |||
| description | varchar (100) | YES | ||
References made to PAY_CODE |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| ADP_SETUP | pay_code_key | fk_adp_setup3 |
| DEFAULT_TIME_DATA | pay_code_key | fk_default_time_data5 |
| PERSON | pay_code_key | fk_person5 |
| PERSON_TIME_DATA | pay_code_key | fk_person_time_data1 |
| PERSON_TIME_DATA_HISTORY | pay_code_key | fk_person_time_data_history1 |
| PTD_AUDIT_TRAIL | pay_code_key | fk_ptd_audit_trail1 |
| VALID_PAYCODE | pay_code_key | fk_valid_paycode2 |
Dependent Views |
|
| View Name | |
|---|---|
| TIMESHEET_DATA | |
Indexes on PAY_CODE |
|
| Index Name | Column(s) |
|---|---|
| idx_pay_code1 | pay_code |
| pk_pay_code | pay_code_key |