[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_AUD_RULE_SETS |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_AUD_RULE_SETS
|
| Subobject Name: | |
| Status: | VALID |
AP_AUD_RULE_SETS is an audit-specific table that contains audit rules.
The data in this table controls which expense reports are audited and when an employee is placed on the audit list. The primary key for this table is RULE_SET_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_AUD_RULE_SETS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 RULE_SET_ID
|
| AP_AUD_RULE_SETS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RULE_SET_NAME
|
| AP_AUD_RULE_SETS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RULE_SET_TYPE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RULE_SET_ID | NUMBER | (15) | Yes | Rule set unique identifier. |
| RULE_SET_NAME | VARCHAR2 | (60) | Yes | Rule set name. |
| RULE_SET_TYPE | VARCHAR2 | (30) | Yes | Rule set type. Value RULE is used for rule sets to determine whether an expense report is audited. Value AUDIT_LIST is used for rule sets to determine whether an employee is placed on the audit list. |
| DESCRIPTION | VARCHAR2 | (240) | Rule set description. | |
| START_DATE | DATE | Start date for the rule set. | ||
| END_DATE | DATE | End date for the rule set. | ||
| PAPERLESS_AUDIT_CC_ONLY_FLAG | VARCHAR2 | (1) | Determines whether paperless audit is used for expense reports that contain corporate credit card transactions only. | |
| PAPERLESS_AUDIT_VIOLATION_FLAG | VARCHAR2 | (1) | Determines whether paperless audit is used for expense reports that have policy violations. | |
| PAPERLESS_AUDIT_PDM_ONLY_FLAG | VARCHAR2 | (1) | Determines whether paperless audit is used for expense reports that claim only per diem and/or mileage expenses. | |
| ASSIGN_AUDITOR_STAGE_CODE | VARCHAR2 | (30) | Determines at which stage an auditor is assigned to an expense report. | |
| AUDIT_ALL_VIOLATIONS_FLAG | VARCHAR2 | (1) | Determines whether all expense reports with policy violations are audited. | |
| AUDIT_ALL_FROM_AUDIT_LIST_FLAG | VARCHAR2 | (1) | Determines whether all expense reports from employees on the audit list are audited. | |
| AUDIT_ALL_OLD_RECEIPTS_FLAG | VARCHAR2 | (1) | Determines whether all expense reports with receipts older than a specified time limit are audited. | |
| AUDIT_ALL_RECEIPT_DAYS_LIMIT | NUMBER | Time limit used to determine whether expense reports with old receipts are audited. | ||
| RANDOM_AUDIT_FLAG | VARCHAR2 | (1) | Determines whether expense reports are randomly audited. | |
| RANDOM_AUDIT_PERCENTAGE | NUMBER | Probability that an expense report is randomly audited. | ||
| IGNORE_CREDIT_ONLY_FLAG | VARCHAR2 | (1) | Determines whether the random audit ignores expense reports that contain credit lines only. | |
| IGNORE_RJ_NOT_REQ_ONLY_FLAG | VARCHAR2 | (1) | Determines whether the random audit ignores expense reports that contain only expense types where receipt and justification are not required. | |
| AUTO_APPROVAL_TAG | VARCHAR2 | (80) | Indicator printed on the expense report submission confirmation page indicating that the expense report is automatically approved. | |
| REQUIRES_AUDIT_TAG | VARCHAR2 | (80) | Indicator printed on the expense report submission confirmation page indicating that the expense report requires audit. | |
| PAPERLESS_AUDIT_TAG | VARCHAR2 | (80) | Indicator printed on the expense report submission confirmation page indicating that paperless audit is used for the expense report. | |
| RECEIPT_DELAY_RULE_FLAG | VARCHAR2 | (1) | Determines whether employees sending receipts later than a specified time limit are placed on the audit list. | |
| RECEIPT_DELAY_DAYS | NUMBER | Time limit used to determine whether employees sending receipts late are placed on the audit list. | ||
| MONTHLY_TOTAL_RULE_FLAG | VARCHAR2 | (1) | Determines whether employees submitting more than a specified cumulative total of expense reports per month are placed on the audit list. | |
| MONTHLY_TOTAL_ALLOWED | NUMBER | Number limit used to determine whether employees submitting expense reports with large totals are placed on the audit list. | ||
| MONTHLY_VIOLATIONS_RULE_FLAG | VARCHAR2 | (1) | Determines whether employees submitting expense reports with more than a specified number of policy violations per month are placed on the audit list. | |
| MONTHLY_VIOLATIONS_ALLOWED | NUMBER | Limit used to determine whether employees submitting expense reports with policy violations are placed on the audit list. | ||
| MONTHLY_REPORTS_RULE_FLAG | VARCHAR2 | (1) | Determines whether employees submitting more than a specified number of expense reports per month are placed on the audit list. | |
| MONTHLY_REPORTS_ALLOWED | NUMBER | Limit used to determine whether employees submitting several expense reports are placed on the audit list. | ||
| AUDIT_TERM_DURATION_DAYS | NUMBER | Number of days an employee remains on the audit list. | ||
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| NOTIFY_RCT_OVERDUE_DAYS | NUMBER | Time limit in days that determines when the system sends a receipt package overdue notification | ||
| NOTIFY_ACTION_REQUIRED_DAYS | NUMBER | Time limit in days after which reminders are sent to an employee who has not taken action on the first notification. | ||
| NOTIFY_DOCUMENT_REQUIRED_CODE | VARCHAR2 | (30) | Determines whether a physical document is required when the employee declares receipts missing. | |
| NOTIFY_RESPONSE_OVERDUE_DAYS | NUMBER | Time limit in days after employee response to determine if receipt package is overdue | ||
| NOTIFY_RCT_RECEIVED_CODE | VARCHAR2 | (30) | Determines whether employee is notified when a receipt package is received. | |
| HOLD_CODE | VARCHAR2 | (30) | Determines the circumstances under which payments are put on hold. | |
| HOLD_RCT_OVERDUE_DAYS | NUMBER | Time limit in days after which expense report payments are put on hold because of late receipts | ||
| HOLD_RCT_OVERDUE_BP_CC_CODE | VARCHAR2 | (30) | Determines whether to hold payments on credit card expenses in the Both Pay scenario because of late receipts. | |
| AUDIT_ALL_AMOUNT_CODE | VARCHAR2 | (30) | Determines whether all expense reports with an amount greater than a specified amount are audited. | |
| AUDIT_ALL_AMOUNT_LIMIT | NUMBER | Maximum amount allowed for an expense report without audit. | ||
| AUDIT_ALL_AMOUNT_CURRENCY_CODE | VARCHAR2 | (15) | Currency of the maximum amount allowed for an expense report without audit. | |
| AUDIT_ALL_RECEIPTS_CODE | VARCHAR2 | (30) | Determines whether all expense reports with at least one expense line that requires receipts are audited. | |
| AUDIT_ALL_JUSTIFICATION_CODE | VARCHAR2 | (30) | Determines whether all expense reports with at least one expense line that requires justification are audited. | |
| AUDIT_ALL_INACTIVE_CODE | VARCHAR2 | (30) | Determines whether all expense reports of individuals with an inactive status are audited. | |
| AUDIT_ALL_UNUSED_ADVANCES | VARCHAR2 | (30) | Specifies whether all expense reports with unapplied advances are required to be audited. |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_SET_ID
, RULE_SET_NAME
, RULE_SET_TYPE
, DESCRIPTION
, START_DATE
, END_DATE
, PAPERLESS_AUDIT_CC_ONLY_FLAG
, PAPERLESS_AUDIT_VIOLATION_FLAG
, PAPERLESS_AUDIT_PDM_ONLY_FLAG
, ASSIGN_AUDITOR_STAGE_CODE
, AUDIT_ALL_VIOLATIONS_FLAG
, AUDIT_ALL_FROM_AUDIT_LIST_FLAG
, AUDIT_ALL_OLD_RECEIPTS_FLAG
, AUDIT_ALL_RECEIPT_DAYS_LIMIT
, RANDOM_AUDIT_FLAG
, RANDOM_AUDIT_PERCENTAGE
, IGNORE_CREDIT_ONLY_FLAG
, IGNORE_RJ_NOT_REQ_ONLY_FLAG
, AUTO_APPROVAL_TAG
, REQUIRES_AUDIT_TAG
, PAPERLESS_AUDIT_TAG
, RECEIPT_DELAY_RULE_FLAG
, RECEIPT_DELAY_DAYS
, MONTHLY_TOTAL_RULE_FLAG
, MONTHLY_TOTAL_ALLOWED
, MONTHLY_VIOLATIONS_RULE_FLAG
, MONTHLY_VIOLATIONS_ALLOWED
, MONTHLY_REPORTS_RULE_FLAG
, MONTHLY_REPORTS_ALLOWED
, AUDIT_TERM_DURATION_DAYS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, NOTIFY_RCT_OVERDUE_DAYS
, NOTIFY_ACTION_REQUIRED_DAYS
, NOTIFY_DOCUMENT_REQUIRED_CODE
, NOTIFY_RESPONSE_OVERDUE_DAYS
, NOTIFY_RCT_RECEIVED_CODE
, HOLD_CODE
, HOLD_RCT_OVERDUE_DAYS
, HOLD_RCT_OVERDUE_BP_CC_CODE
, AUDIT_ALL_AMOUNT_CODE
, AUDIT_ALL_AMOUNT_LIMIT
, AUDIT_ALL_AMOUNT_CURRENCY_CODE
, AUDIT_ALL_RECEIPTS_CODE
, AUDIT_ALL_JUSTIFICATION_CODE
, AUDIT_ALL_INACTIVE_CODE
, AUDIT_ALL_UNUSED_ADVANCES
FROM AP.AP_AUD_RULE_SETS;
AP.AP_AUD_RULE_SETS does not reference any database object
AP.AP_AUD_RULE_SETS is referenced by following:
APPS
AP_AUD_RULE_SETS
|
|
|
|