All Check Constraints |
| |
Table Name |
Constraint Name |
Definition |
| 1. |
ADP_SETUP |
cc_adp_setup_sign_field |
(sign_field = 'N' or (sign_field = 'P')) |
| 2. |
APPROVAL_HISTORY |
cc_ah_approved |
(approved = 'N' or (approved = 'Y')) |
| 3. |
APPROVAL_HISTORY |
cc_ah_status |
(status = 'LOCKED' or (status = 'EXTRACTED' or (status = 'COMPLETED' or (status = 'DISAPPROVED' or (status = 'APPROVING' or (status = 'SUBMITTED' or (status = 'INUSE'))))))) |
| 4. |
CURRENCY |
cc_currency_locale |
(locale is not null) |
| 5. |
CUSTOMER_APPROVER |
cc_ca_approve_sequence |
(approve_sequence = 'P' or (approve_sequence = 'C' or (approve_sequence = 'N'))) |
| 6. |
EMAIL_TEMPLATE |
cc_enabled |
(enabled = 'N' or (enabled = 'Y')) |
| 7. |
EXP_CUST_APPROVAL_STATUS |
cc_ecas_approved |
(approved = 'N' or (approved = 'Y')) |
| 8. |
EXPENSE_DATA |
cc_ed_exchange_rate |
(exchange_rate is not null) |
| 9. |
EXPENSE_DATA |
cc_ed_expense_amount |
(expense_amount is not null) |
| 10. |
EXPENSE_DATA |
cc_ed_expense_currency |
(expense_currency is not null) |
| 11. |
EXPENSE_DATA |
cc_ed_project_type_key |
(project_type_key is not null) |
| 12. |
EXPENSE_HISTORY |
cc_eh_status |
null |
| 13. |
EXPENSE_PM_APPROVAL_STATUS |
cc_emas_approved |
(approved = 'N' or (approved = 'Y')) |
| 14. |
EXPENSE_REPORT |
cc_er_status |
null |
| 15. |
EXPENSE_TYPE |
cc_et_receipt_required |
(receipt_required = 'N' or (receipt_required = 'Y' and (receipt_required is not null))) |
| 16. |
EXPENSE_TYPE |
cc_et_request_allowed |
(request_allowed = 'N' or (request_allowed = 'Y' and (request_allowed is not null))) |
| 17. |
HISTORY_APPROVAL_HISTORY |
cc_hah_status |
null |
| 18. |
HISTORY_EXPENSE_REPORT |
cc_her_status |
null |
| 19. |
MANAGER_APPROVAL_STATUS |
cc_mas_approved |
(approved = 'N' or (approved = 'Y')) |
| 20. |
PERSON |
cc_active |
(active = 'N' or (active = 'Y')) |
| 21. |
PERSON |
cc_expense_email |
(expense_email = 'N' or (expense_email = 'Y')) |
| 22. |
PERSON |
cc_person_exempt_status |
(exempt_status = 'X' or (exempt_status = 'N' or (exempt_status = 'E'))) |
| 23. |
PERSON |
cc_timesheet_email |
(timesheet_email = 'N' or (timesheet_email = 'Y')) |
| 24. |
PERSON |
cc_timesheet_lines |
(timesheet_lines = 'N' or (timesheet_lines = 'Y')) |
| 25. |
PERSON_TIME |
cc_pt_partial_flag |
(partial_flag = 'R' or (partial_flag = 'L' or (partial_flag = 'F'))) |
| 26. |
PERSON_TIME |
cc_pt_status |
(status = 'LOCKED' or (status = 'EXTRACTED' or (status = 'COMPLETED' or (status = 'DISAPPROVED' or (status = 'APPROVING' or (status = 'SUBMITTED' or (status = 'INUSE'))))))) |
| 27. |
PROJECT |
cc_pjt_assignment_flag |
(assignment_flag = 'N' or (assignment_flag = 'Y')) |
| 28. |
PROJECT |
cc_pjt_expense_pm_approval |
(expense_manager_approval = 'N' or (expense_manager_approval = 'Y')) |
| 29. |
PROJECT |
cc_pjt_manager_approval |
(manager_approval = 'N' or (manager_approval = 'Y')) |
| 30. |
PROJECT |
cc_prj_er_task_required |
(er_task_required = 'N' or (er_task_required = 'Y' and (er_task_required is not null))) |
| 31. |
PROJECT |
cc_prj_ts_task_required |
(ts_task_required = 'N' or (ts_task_required = 'Y' and (ts_task_required is not null))) |
| 32. |
PROJECT_ASSIGNMENT |
cc_pjta_web_plan |
(web_plan = 'N' or (web_plan = 'Y')) |
| 33. |
PROJECT_ASSIGNMENT |
cc_pjta_web_time |
(web_time = 'N' or (web_time = 'Y')) |
| 34. |
PROJECT_STATUS |
cc_pjts_open_status |
(open_status = 'N' or (open_status = 'Y')) |
| 35. |
PROJECT_TYPE |
cc_pjtt_administrative |
(administrative = 'N' or (administrative = 'Y')) |
| 36. |
PROJECT_TYPE |
cc_pjtt_billable |
(billable = 'N' or (billable = 'Y' and (billable is not null))) |
| 37. |
REQUEST_EXPENSE_DATA |
cc_red_exchange_rate |
(exchange_rate is not null) |
| 38. |
REQUEST_EXPENSE_DATA |
cc_red_expense_amount |
(expense_amount is not null) |
| 39. |
REQUEST_EXPENSE_DATA |
cc_red_expense_currency |
(expense_currency is not null) |
| 40. |
TASK |
cc_task_active |
(active = 'N' or (active = 'Y')) |
| 41. |
TIME_CUST_APPROVAL_STATUS |
cc_tcas_approved |
(approved = 'N' or (approved = 'Y')) |
| 42. |
TIME_PERIOD_SETUP |
cc_tps_enabled |
(enabled = 'N' or (enabled = 'Y')) |