CN_PROCESS_AUDIT_LINES_ALL
CN_PROCESS_AUDIT_LINES contains debugging and log file messages issued by a user run process. You need one row for each message issued by the process. . The table stores untranslated message codes and debugging messages. Currently only the calculation process writes messages to this table. . MESSAGE_TYPE_CODE defines whether the message is for debugging and non-translatable or whether the message will be translated when viewed in the Process Log form
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CN_PROCESS_AUDIT_LINES_PK |
PROCESS_AUDIT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROCESS_AUDIT_LINE_ID | NUMBER | 18 | Yes | Primary key | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| PROCESS_AUDIT_ID | NUMBER | 18 | Yes | Process audit unique identifier | |
| MESSAGE_TYPE_CODE | VARCHAR2 | 30 | Yes | Type of message | |
| MESSAGE_TEXT | VARCHAR2 | 1000 | Yes | Translatable message code or debugging message | |
| PARTICIPANT_ID | NUMBER | 18 | Participant Identifier | ||
| COMP_PLAN_ID | NUMBER | 18 | Compensation Plan Identifier | ||
| PLAN_COMPONENT_ID | NUMBER | 18 | Plan Component Identifier | ||
| FORMULA_ID | NUMBER | 18 | Formula Identifier | ||
| RATE_TABLE_ID | NUMBER | 18 | Rate Table Identifier | ||
| ELIGIBLE_CAT_ID | NUMBER | 18 | Credit Category Identifier | ||
| RULE_ID | NUMBER | 18 | Rule Identifier | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CN_PROCESS_AUDIT_LINES_ALL | cn_process_audits_all | PROCESS_AUDIT_ID |
| CN_PROCESS_AUDIT_LINES_ALL | cn_srp_participants_all | PARTICIPANT_ID |
| CN_PROCESS_AUDIT_LINES_ALL | cn_comp_plans_all_b | COMP_PLAN_ID |
| CN_PROCESS_AUDIT_LINES_ALL | cn_plan_components_all_b | PLAN_COMPONENT_ID, ORG_ID |
| CN_PROCESS_AUDIT_LINES_ALL | cn_formulas_all_b | FORMULA_ID |
| CN_PROCESS_AUDIT_LINES_ALL | cn_rate_tables_all_b | RATE_TABLE_ID |
| CN_PROCESS_AUDIT_LINES_ALL | cn_eligible_cats_all_b | ELIGIBLE_CAT_ID |
| CN_PROCESS_AUDIT_LINES_ALL | cn_rs_rules_all_b | RULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CN_PROCESS_AUDIT_LINES_N1 | Non Unique | Default | PROCESS_AUDIT_ID, PROCESS_AUDIT_LINE_ID |
| CN_PROCESS_AUDIT_LINES_U1 | Unique | Default | PROCESS_AUDIT_LINE_ID |